The president of the retailer Prime Products has just approached the company's bank with a request...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
The president of the retailer Prime Products has just approached the company's bank with a request for a $85,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 $13,600. Accounts receivable on April 1 will total $168,000, of which $144,000 will be collected during April and $19,200 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% is bad debts that are never collected. Budgeted sales and expenses for the three- month period follow: Sales (all on account) April $ 240,000 May $ 620,000 June Merchandise purchases Payroll $ 192,000 $ 196,500 289,000 179,500 $ 16,200 $ 16,200 $ 24,700 Lease payments $ 38,200 $ 38,200 $ 38,200 Advertising $ 72,600 $ 72,600 $ 72,880 Equipment purchases $ 66,500 Depreciation $ 33,800 $ 33,800 $ 33,800 c. Merchandise purchases are paid in full during the month following purchase. Accounts payable for merchandise purchases during March, which will be paid in April, total $156,000. d. In preparing the cash budget, assume that the $85,000 loan will be made in April and repaid in June. Interest on the loan will total $1,200. Required: 1. Calculate the expected cash collections for April, May, and June, and for the three months in total. 2. Prepare a cash budget, by month and in total, for the three-month period. Required 1 Required 2 Calculate the expected cash collections for April, May, and June, and for the three moi Schedule of Expected Cash Collections Total cash collections Required 1 Required 2 April May June Quarter Prepare a cash budget, by month and in total, for the three-month period. (Cash deficiency, repayments and intere indicated by a minus sign.) Beginning cash balance Add receipts: Collections from customers Total cash available Less cash disbursements: Merchandise purchases Payroll Lease payments Advertising + Equipment purchases Total cash disbursements Excess (deficiency) of cash available over disbursements Financing: Borrowings Repayments Interest Total financing Ending cash balance Prime Products Cash Budget April May June Quarter The president of the retailer Prime Products has just approached the company's bank with a request for a $85,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 $13,600. Accounts receivable on April 1 will total $168,000, of which $144,000 will be collected during April and $19,200 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% is bad debts that are never collected. Budgeted sales and expenses for the three- month period follow: Sales (all on account) April $ 240,000 May $ 620,000 June Merchandise purchases Payroll $ 192,000 $ 196,500 289,000 179,500 $ 16,200 $ 16,200 $ 24,700 Lease payments $ 38,200 $ 38,200 $ 38,200 Advertising $ 72,600 $ 72,600 $ 72,880 Equipment purchases $ 66,500 Depreciation $ 33,800 $ 33,800 $ 33,800 c. Merchandise purchases are paid in full during the month following purchase. Accounts payable for merchandise purchases during March, which will be paid in April, total $156,000. d. In preparing the cash budget, assume that the $85,000 loan will be made in April and repaid in June. Interest on the loan will total $1,200. Required: 1. Calculate the expected cash collections for April, May, and June, and for the three months in total. 2. Prepare a cash budget, by month and in total, for the three-month period. Required 1 Required 2 Calculate the expected cash collections for April, May, and June, and for the three moi Schedule of Expected Cash Collections Total cash collections Required 1 Required 2 April May June Quarter Prepare a cash budget, by month and in total, for the three-month period. (Cash deficiency, repayments and intere indicated by a minus sign.) Beginning cash balance Add receipts: Collections from customers Total cash available Less cash disbursements: Merchandise purchases Payroll Lease payments Advertising + Equipment purchases Total cash disbursements Excess (deficiency) of cash available over disbursements Financing: Borrowings Repayments Interest Total financing Ending cash balance Prime Products Cash Budget April May June Quarter
Expert Answer:
Related Book For
Managerial Accounting
ISBN: 978-0697789938
13th Edition
Authors: Ray H. Garrison, Eric W. Noreen, Peter C. Brewer
Posted Date:
Students also viewed these accounting questions
-
The president of the retailer Prime Products has just approached the companys bank with a request for a $30,000, 90-day loan. The purpose of the loan is to assist the company in acquiring...
-
The president of the retailer Prime Products has just approached the companys bank with a request for a $69,000, 90-day loan. The purpose of the loan is to assist the company in acquiring...
-
If the firm's lowest average cost is $52 and the corresponding average variable cost is $26, what does it pay a perfectly competitive firm to do if? a. The market price is $51 b. The price is $36 c....
-
Assign oxidation numbers to the atoms in each substance. a. Kr (krypton) b. krypton tetrafluoride (KrF4) c. dioxygen difluoride (O2F2)
-
Getrich has 4.1 million shares outstanding and a current share price of $8.8 per share. It also has $56.6 million in outstanding debt, with a debt cost of capital of 6.2%. Getrich's equity cost of...
-
The hot and cold inlet temperatures to a concentric tube heat exchanger are \(T_{h, i}=200^{\circ} \mathrm{C}, T_{c, i}=100^{\circ} \mathrm{C}\), respectively. The outlet temperatures are \(T_{h,...
-
Blue Ridge Hot Tubs manufactures and sells two models of hot tubs: the Aqua- Spa and the Hydro-Lux. Howie Jones, the owner and manager of the company, needs to decide how many of each type of hot tub...
-
A triangle is defined by the vertex coordinates (x,y), (x,y), and (x3.3). Write a C++ program that will 1. Interactively prompt a user for the x and y coordinates at each triangle vertex. 2. Print...
-
Mindless toys is considering replacing both production lines with one production line. There are three options listed below: Option Manual Machine Variable Cost per Unit Fully Automated 0.45...
-
a. What is interest rate risk? b. What is price risk? c. What is reinvestment rate risk?
-
Why is capital structure important to the managers of not-forprofit businesses?
-
Why are callable bonds riskier for investors than similar bonds without a call provision?
-
What unique problems do managers of not-for-profit businesses face regarding capital structure decisions?
-
How do bond ratings affect the cost of debt to the issuing firm?
-
You need to make a presentation on: The great schism Justinian Encaustic Fresco Mosaic Illuminated manuscripts
-
Charles owns an office building and land that are used in his trade or business. The office building and land were acquired in 1978 for $800,000 and $100,000, respectively. During the current year,...
-
During the 2002 Winter Olympics in Salt Lake City, Utah, a local microbrewery received a rush order for 100 gallons of beer containing at least 4.0 volume \(\%\) alcohol. Although no \(4 \%\) beer...
-
Willy Wonka has engaged your consultation services to assist in the recipe formulation of a new brand of chocolate bar, weighing \(100 \mathrm{~g}\), which he plans to name "Super-choc." Each...
-
A batch distillation facility has a bank of columns of Type 1 and another bank of Type 2. Type 1 columns are available for processing \(6,000 \mathrm{hr} /\) week, and Type 2 columns are available...
Study smarter with the SolutionInn App