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:
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/05/664fe94d245fb_100664fe94ca69a7.jpg)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/05/664fe94dbc2d2_101664fe94d54109.jpg)
Transcribed Image Text:
The president of the retailer Prime Products has just approached the company's bank with a request for a $69,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 $22,200. Accounts receivable on April 1 will total $176,400, of which $151,200 will be collected during April and $20,160 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) Payroll Merchandise purchases Lease payments Advertising Equipment purchases Depreciation April $438.000 May $480,000 June $261.000 $291,000 $183.500 $136,500 $27.400 $27.400 $26,100 $28,500 $28.600 $28,600 $70,800 $70.800 $75.460 50 50 $67,500 $19,000 $19.000 $19.000 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 $180,500. d. In preparing the cash budget, assume that the $69,000 loan will be made in April and repaid in June. Interest on the loan will total $1,040. 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. Complete this question by entering your answers in the tabs below. Required 1 Required 2 Calculate the expected cash collections for April, May, and June, and for the three months in total. Schedule of Expected Cash Collections Total cash collections April May June Quarter Required 2 > The president of the retailer Prime Products has just approached the company's bank with a request for a $69,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 $22,200. Accounts receivable on April 1 will total $176,400, of which $151,200 will be collected during April and $20,160 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: Depreciation Api $450,000 $480.000 $301.000 $291,000 $183,500 $138,500 $27,400 $26,100 $28,000 $70,800 $67300 $10,000 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 $180,500. d. In preparing the cash budget, assume that the $69,000 loan will be made in April and repaid in June. Interest on the loan will total $1,040. 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. Complete this question by entering your answers in the tabs below. Required Required 2 Prepare a cash budget, by month and in total, for the three-month period. (Cash deficiency, repayments and interest should be indicated by a minus sign.) Collections from Less cash dsburse Merchande puhas Payrol Advertising Equipment purchases Tital cash disbursements Excess (deficiency) of cash over dents Financing T Produ Ap May Quarter The president of the retailer Prime Products has just approached the company's bank with a request for a $69,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 $22,200. Accounts receivable on April 1 will total $176,400, of which $151,200 will be collected during April and $20,160 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) Payroll Merchandise purchases Lease payments Advertising Equipment purchases Depreciation April $438.000 May $480,000 June $261.000 $291,000 $183.500 $136,500 $27.400 $27.400 $26,100 $28,500 $28.600 $28,600 $70,800 $70.800 $75.460 50 50 $67,500 $19,000 $19.000 $19.000 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 $180,500. d. In preparing the cash budget, assume that the $69,000 loan will be made in April and repaid in June. Interest on the loan will total $1,040. 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. Complete this question by entering your answers in the tabs below. Required 1 Required 2 Calculate the expected cash collections for April, May, and June, and for the three months in total. Schedule of Expected Cash Collections Total cash collections April May June Quarter Required 2 > The president of the retailer Prime Products has just approached the company's bank with a request for a $69,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 $22,200. Accounts receivable on April 1 will total $176,400, of which $151,200 will be collected during April and $20,160 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: Depreciation Api $450,000 $480.000 $301.000 $291,000 $183,500 $138,500 $27,400 $26,100 $28,000 $70,800 $67300 $10,000 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 $180,500. d. In preparing the cash budget, assume that the $69,000 loan will be made in April and repaid in June. Interest on the loan will total $1,040. 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. Complete this question by entering your answers in the tabs below. Required Required 2 Prepare a cash budget, by month and in total, for the three-month period. (Cash deficiency, repayments and interest should be indicated by a minus sign.) Collections from Less cash dsburse Merchande puhas Payrol Advertising Equipment purchases Tital cash disbursements Excess (deficiency) of cash over dents Financing T Produ Ap May 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
-
Use the test of your choice to determine whether the following series converge. 1 1! + 4 2! + 9 16 + 3! 4!
-
In September 1996, U.S. News & World Report published a report on America's health maintenance organizations (HMOs). The report was intended to serve as a consumer guide to HMO quality. For each HMO...
-
Describe the distinction between the term profits as generally used by accountants and the use of the term in the law for lost profits measurements.
-
What are the elements of a negligence claim?
-
On January 1, 2014, the ledger of Zaur Company contains the following liability accounts. Accounts Payable .......... $42,500 Sales Taxes Payable ......... 5,800 Unearned Service Revenue ..........
-
One of the responsibilities a leader should possess is to ensure that employees are engaged in their tasks and that they are excited about working for the organization. Explain why a leader should be...
-
answer all the questions 4. Four light bulbs are selected at random without replacement from 16 bulbs, of which 7 are defective. Find the probability that a) none are defective. b) exactly one is...
-
How do Change Management connoisseurs navigate the turbulent waters of regulatory compliance, legal frameworks, and ethical considerations inherent in transformative change initiatives, ensuring...
-
list four reasons employers may grant employees time off with pay. which of the reasons you've listed would be most likely to apply to a college professor or a biochemist who works for the...
-
What resistance, if any, was displayed by the employees of Yahoo after the bureaucratic approach was used?
-
Bosses who are approachable but also empower their employees to work independently are often highly valued. that leads to greater ownership of the work by employees, and greater motivation and...
-
Chung manages his employees by carefully monitoring their production, comparing what they do to predicted schedules and desired budgets. Chung can best be described as what leader?
-
\f
-
Government is advised to tax goods whose demand curves are inelastic if the goal is to raise tax revenues. If the goal is to discourage consumption, then it ought to tax goods whose demand curves are...
-
What account or accounts are debited when (a) establishing a petty cash fund and (b) replenishing a petty cash fund? LO2
-
What entry should be made if a check received from a customer and deposited is returned by the bank for lack of sufficient funds (an NSF check)? LO2
-
AT WHAT POINT IN A PROCESS ARE JOINT PRODUCTS IDENTIFIABLE? LO1.
![Mobile App Logo](https://dsd5zvtm8ll6.cloudfront.net/includes/images/mobile/finalLogo.png)
Study smarter with the SolutionInn App