PROBLEM 8—23 schedule or Expected cash collections;
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, die cash balance will be $24,000.
b. Past experience shows that 30% of a mouth's sales are collected in the mouth of sale, 60% in the month following sale, and 8% in the second month following sale. The other 2% is
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 $140,000.
d. In preparing the cash budget, assume that the $30,000 loan will he mode in April and repaid in June Interest on the loan will total $1,200.
Required:
- Calculate the expected cash collections for April, May, and Tune, and for the three months in total.
- Prepare a cash budget, by month and in total, for the three-month period.
- If the company needs a minimum cash balance of $20,000 to start each month, can the loan be repaid as planned? Explain.

Want to see the full answer?
Check out a sample textbook solution
Chapter 8 Solutions
MANAGERIAL ACCOUNTING ACCESS CARD
- If someone tracks, tallys and totals a current liabilities for an accounting period, and then seeks to apply this value in a calculation to assess our liquidity, what’s the difference between the current ratio and the “acid-test” (or “quick”) ratio? Does the difference between these two metrics even matter?arrow_forwardDear tutor. I mistakenly submitted blurr image please comment i will write values. please dont Solve with incorrect values otherwise unhelpful.arrow_forwardno aiWhich of the following errors will not be detected by a trial balance?A. Debiting cash instead of accounts receivableB. Recording revenue twiceC. Failing to record a transactionD. A $100 debit matched with a $100 creditarrow_forward
- Don't use chatgpt Which of the following errors will not be detected by a trial balance?A. Debiting cash instead of accounts receivableB. Recording revenue twiceC. Failing to record a transactionD. A $100 debit matched with a $100 creditarrow_forward7. If inventory is overstated at year-end, which of the following is true?A. Net income is understatedB. Expenses are overstatedC. Net income is overstatedD. Assets are understated i need help in this question quiarrow_forwardI need correct answer 7. If inventory is overstated at year-end, which of the following is true?A. Net income is understatedB. Expenses are overstatedC. Net income is overstatedD. Assets are understatedarrow_forward
- No chatgpt 7. If inventory is overstated at year-end, which of the following is true?A. Net income is understatedB. Expenses are overstatedC. Net income is overstatedD. Assets are understatedarrow_forward7. If inventory is overstated at year-end, which of the following is true?A. Net income is understatedB. Expenses are overstatedC. Net income is overstatedD. Assets are understatedneed anarrow_forwardNo ai 7. If inventory is overstated at year-end, which of the following is true?A. Net income is understatedB. Expenses are overstatedC. Net income is overstatedD. Assets are understatedarrow_forward
- 7. If inventory is overstated at year-end, which of the following is true?A. Net income is understatedB. Expenses are overstatedC. Net income is overstatedD. Assets are understatedarrow_forwardI mistakenly submitted blurr image please comment i will write values. please dont Solve with incorrect values otherwise unhelpful.arrow_forwardDevelopment costs in preparing the mine $ 3,400,000 Mining equipment 159,600 Construction of various structures on site 77,900 After the minerals are removed from the mine, the equipment will be sold for an estimated residual value of $12,000. The structures will be torn down. Geologists estimate that 820,000 tons of ore can be extracted from the mine. After the ore is removed, the land will revert back to the state of New Mexico. The contract with the state requires Hecala to restore the land to its original condition after mining operations are completed in approximately four years. Management has provided the following possible outflows for the restoration costs: Cash Outflow Probability $ 620,000 40% 720,000 30% 820,000 30% Hecala’s credit-adjusted risk-free interest rate is 7%. During 2024, Hecala extracted 122,000 tons of ore from the mine. The company’s fiscal year ends on December 31. Required: Determine the amount at which Hecala will record the mine. Calculate the…arrow_forward
- Cornerstones of Financial AccountingAccountingISBN:9781337690881Author:Jay Rich, Jeff JonesPublisher:Cengage LearningFundamentals of Financial Management, Concise Edi...FinanceISBN:9781285065137Author:Eugene F. Brigham, Joel F. HoustonPublisher:Cengage LearningFundamentals of Financial Management, Concise Edi...FinanceISBN:9781305635937Author:Eugene F. Brigham, Joel F. HoustonPublisher:Cengage Learning
- Fundamentals of Financial Management (MindTap Cou...FinanceISBN:9781285867977Author:Eugene F. Brigham, Joel F. HoustonPublisher:Cengage Learning



