Prepare a schedule of cash surplus

Assignment Help Finance Basics
Reference no: EM13843111

Bob has also identified a cash payment of $175,000 upon completion of a new boat dock in July. As of March 1st, the company now has $125,000 in cash on hand and would like to maintain a minimum cash balance of $85,000 at all times.

Required:

1. Prepare a Schedule of Collections and Payments for the six month period beginning in March, using the template provided and the data above.

2. Prepare a Schedule of Cash Gains and Losses by month for the six month period beginning in March, using the template provided and the data above.

3. Prepare a Schedule of Cash Surplus or Shortages by month for the six month period beginning in March, using the template provided and the data above.

4. Prepare a schedule of Net Cash Flow by month for the six month period beginning in March, using the template provided and the data above indicating the timing and amounts that must be borrowed or the amounts that can be re-invested or used in the firm.

5. Based on the information in the reports you constructed above would you recommend any changes in the credit policy of the firm? If so, what would they be? Explain your answers

Reference no: EM13843111

Questions Cloud

Analyze persuasive requests and sales messages : Analyze persuasive requests and sales messages. What traits do persuasive requests and sales messages share in common and how do they differ?
History of telecommunications-overview of cyber security : A summary of the US regulatory framework that has grown up along with the telecommunications industry. An overview of cyber security. The history of telecommunications
Discuss how freedom of expression and intellectual property : The Internet is an ideal communication mechanism because of its openness and anonymity but people must make ethical decisions about how to use this power. Discuss how freedom of expression and intellectual property rights might ethically conflict.
What is the bullwhip measure for the retailer-manufacturer : Supplier. The retailer’s demand over an 8-week period was 100 units each of the first 2 weeks, 200 units each of the second 2 weeks, 300 units each of the third 2 weeks, and 400 units each of the fourth 2 weeks. What is the bullwhip measure for the r..
Prepare a schedule of cash surplus : Prepare a Schedule of Collections and Payments for the six month period beginning in March, using the template provided and the data above. Prepare a Schedule of Cash Surplus or Shortages by month for the six month period beginning in March, using ..
Research the key facts and critical issues : Research the key facts and critical issues of BP before the BP oil spill of 2010 and summarize them here as they relate to the past conduct of the organization.
Classified as transactional and tactical information sharing : Do you agree or disagree that supply chain collaboration can be classified as transactional, tactical information sharing, or strategic in nature? Why? Some companies are hesitant to use frequent shopper cards because the data provided could violate ..
How it worked and why you think they were successful : Your sense of the particular character type they sought to develop in their students. Your reactions to how it worked and why you think they were successful. What ideas you will (or won't, if you didn't like their approach) take from the case as exa..
Write around about india position and the china dream : You need to write around about India position and the China dream of the new silk roads ( OBOR) specially the one goes through Pakistan.

Reviews

Write a Review

Finance Basics Questions & Answers

  Prior to reporting this income statement the company wants

dividends bowles sporting inc. is prepared to report the following 2011 income statement shown in thousands of

  Harriet''s suggestion of using the cost of debt

1. What is your reaction to Harriet's suggestion of using the cost of debt only? Is it a good idea or a bad idea? Why?

  What is the maximum that they should spend on the system

If a company can implement cash management systems and save three days by reducing remittance time and one day by increasing disbursement time based on $2,000,000 in average daily remittances and $2,500,000.

  You have 12000 in cash you can deposit it today in a mutual

you have 12000 in cash. you can deposit it today in a mutual fund earning 5.7 percent semiannually or you can wait

  Computing the taxable gross income of a person

Rosemary is single and works for Big B Corporation. Her only income consists of her Big B salary and interest on a saving account. During the year, she has $400 withheld from her salary for state income taxes and $7800 for federal income taxes.

  Which investment has the higher irr

Which investment has the higher IRR?

  How would you explain the value of financial planning

How would you explain the value of financial planning to friends or family?

  What the duration of a 30-year zero coupon bond

1. What's the duration of a 30-year zero coupon bond?2. Identify at least three different kinds of fixed-income securities, and the pros and cons of each from both the firm's perspective as well as the potential investor's perspective.

  The good life store has sales of 79600 the cost of goods

the good life store has sales of 79600. the cost of goods sold is 48200 and the other costs are 18700. depreciation is

  How much annual income will he need from his employer plan

If he needs 80 percent of his income to maintain his standard of living upon retirement, how much annual income will he need from his employer's plan and from his own planning when he retires? (Show all work.)

  Which of the following statements describes the effect of

1 which of the following is a consequence of the way in which the ferris home is titled?a. either spouse can dispose of

  Under this view what would be the appropriate proxy to use

the risk for real estate can be viewed as a derived demand. if this is the case the risk of real estate can be

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd