+1-415-670-9189
info@expertsmind.com
Prepare a schedule of expected cash collections for april
Course:- Managerial Accounting
Reference No.:- EM131137808




Assignment Help
Expertsmind Rated 4.9 / 5 based on 47215 reviews.
Review Site
Assignment Help >> Managerial Accounting

The president of the retailer Prime Products has just approached the company's bank with a request for a $30,000, 90-day loan. The purpose of the loan is to assist the company in acquiring inventories. Because the company has had some difficulty in paying off its loans in the past, the loan officer has asked for a cash budget to help determine whether the loan should be made. The following data are available for the months April through June, during which the loan will be used:

a. On April 1, the start of the loan period, the cash balance will be $24,000. Accounts receivable on April 1 will total $140,000, of which $120,000 will be collected during April and $16,000 will be collected during May. The remainder will be uncollectible.

b. Past experience shows that 30% of a month's sales are collected in the month of sale, 60% in the month following sale, and 8% in the second month following sale. The other 2% represents bad debts that are never collected. Budgeted sales and expenses for the three-month period follow:

 

April

May

June

Sales (all on account)

$ 300,000

$ 400,000

$250,000

Merchandise purchases

210,000

160,000

130,000

Payroll

20,000

20,000

18,000

Lease payments

22,000

22,000

22,000

Advertising

60,000

60,000

50,000

Equipment purchases

-

-

65,000

Depreciation

15,000

15,000

15,000

c. Merchandise purchases are paid in full during the month following purchase. Accounts payable for merchandise purchases during March, which will be paid during April, total $140,000.

d. In preparing the cash budget, assume that the $30,000 loan will be made in April and repaid in June. Interest on the loan will total 51,200.

Required: Prepare a schedule of expected cash collections for April, May, and June, and for the three months in total.




Put your comment
 
Minimize


Ask Question & Get Answers from Experts
Browse some more (Managerial Accounting) Materials
Thomas Selling, an expert on nuclear strategy and arms control, examined in his book The Strategy of Conflict (Cambridge, MA: Harvard University Press, 1960), " The power to
Company uses a process cost system. The company started march with 2,300 units in work in process-department A. During the month 4,000 units were started. At the end of the
What is the margin related to this years investment opportunity, and what is the turn over related to this year's investment opportunity and what is the ROI related to year's
Why might managers find out a flexible budget analysis more informative than the strategic-budget analysis? Describe your rationale. How might a manager gain insight in the
What should he do if he follows the EMV criterion and what is the expected value of perfect information - write a report to your manager advising - the advantages and disadvan
Prepare a report for Chandra explaining the errors he made in his income statement and review the performance of Bendigo Fencing Company in 2014 and make a recommendation as
Prepare the bank reconciliation for company as of April 30 and calculate the amount of over- or under-applied overhead and what is the significance of this over- or under-appl
Discuss some of the advantages and disadvantages of using the operating budget as a control device. Prepare a budgeted income statement for 20X6. Explain how to reduce budget