+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
Calculate the material handling rate that would have been used by Eloise Smith's predecessor at East Coast Marine - calculate the revised material handling costs to be allocat
Would the following three items be considered advantages of the Small Case Division of the Tax Court: 1. Taxpayer can handle the litigation without using an attorney or a CPA.
The expected return on KarolCo. stock is 16.5 percent. If the risk-free rate is 5 percent and the beta of KarolCo is 2.3, then what is the risk premium on the market assumin
Assuming Marian Nevins believes the controller has acted unethically and not apprised the CEO and CFO of the findings, describe the steps that she should take to resolve the
Dubois Inc. loans money to John Kruk Corporation in the amount of $864,000. Dubois accepts an 8% note due in 6 years with interest payable semiannually. After 2 years (and rec
If the appropriate interest rate is 8 percent, what is the present value of the cash flow stream that the company is offering you? (Round answer to the nearest whole dollar, e
Refer to the information in QS 20-2 and QS 20-3. Blanche's Boxes requisitioned $ 9,000 of indirect materials from its raw materials and used $ 10,000 of indirect labor in its
Perform an Internet search using the term, "activity based costing customer success stories," and locate an article (less than one year old) from the results of your search.