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:





Sales (all on account)

$ 300,000

$ 400,000


Merchandise purchases








Lease payments








Equipment purchases








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

Ask Question & Get Answers from Experts
Browse some more (Managerial Accounting) Materials
Processing first begins in the Boiling department. After boiling of all the materials have been completed, the product is transferred to Cooling department. In the Cooling dep
Milan Machining Company has identified the following overhead activities, costs, and activity drivers for the coming year. Determine the cost of the Receiving activity. Assign
Some firms have a lot of fixed costs and a few variable costs, while other firms are configured the other way around. What effect do you think the existence of a high propor
At December 31, 2014, before adjusting entries, the balances in selected accounts were: Accounts Receivable $318,400 debit, and Allowance for Doubtful Accounts $4,040 credit.
What would be the amount(s) related to the bonds that Agee would report in its statement of cash flows for the year ended December 31, 2011, if it uses the direct method?
Given the following information, Describe the budget line for consumer. Be sure to label the axis and give a number for vertical and horizontal intercepts. Slope? Meaning?
Health Coop is an outpatient surgical clinic that wants to better understand its costs. It decides to prepare an activity based cost analysis, including an estimate of the ave
Calculate a) net book value of the equipment at the end of the third year using the straight-line method of depreciation; and b) depreciation expense for the second year u