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/664c70c3e054b_635664c70c34c416.jpg)
Transcribed Image Text:
The president of the retailer Prime Products has just approached the company's bank with a request for a $53,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 $35,400. Accounts receivable on April 1 will total $154,000, of which $132,000 will be collected during April and $17,600 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 $ 305,000 May $ 642,000 June $ 339,000 Merchandise purchases Payroll $ 251,000 $ 231,000 $ 140,000 $ 32,600 $ 32,600 $ 20,700 Lease payments Advertising Equipment purchases Depreciation $ 24,500 $ 24,500 $ 24,500 $ 62,000 $ 0 $ 26,800 $ 62,000 $ 0 $ 26,800 $ 73,880 $ 79,500 $ 26,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 $169,000. d. In preparing the cash budget, assume that the $53,000 loan will be made in April and repaid in June. Interest on the loan will total $880. 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. The president of the retailer Prime Products has just approached the company's bank with a request for a $53,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 $35,400. Accounts receivable on April 1 will total $154,000, of which $132,000 will be collected during April and $17,600 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 $ 305,000 May $ 642,000 June $ 339,000 Merchandise purchases Payroll $ 251,000 $ 231,000 $ 140,000 $ 32,600 $ 32,600 $ 20,700 Lease payments Advertising Equipment purchases Depreciation $ 24,500 $ 24,500 $ 24,500 $ 62,000 $ 0 $ 26,800 $ 62,000 $ 0 $ 26,800 $ 73,880 $ 79,500 $ 26,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 $169,000. d. In preparing the cash budget, assume that the $53,000 loan will be made in April and repaid in June. Interest on the loan will total $880. 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.
Expert Answer:
Posted Date:
Students also viewed these accounting questions
-
M/s Active Builders Ltd. invested in the shares of another company (with an intention to hold the shares for short term period )on 31st October, 2016 at a cost of Rs.4,50,000. It also earlier...
-
Compute the equivalent units of production for the prior department costs for the month of August. Information about production in the fabricating department of the C&C Company for August 2016...
-
Use the Venn diagram below to find \(n(A \cup B)\). \(U=24\) A 5 7 2 B 10
-
In a survey of U.S. adults, 19% said that they have participated in a clinical trial. You randomly select 200 U.S. adults. Find the probability that the number who have participated in a clinical...
-
Assume that on January 1, 2011, Kimberly-Clark Corp. signs a 10-year non-cancelable lease agreement to lease a storage building from Trevino Storage Company. The following information pertains to...
-
I am very confused on this assessment do I make a PowerPoint or make it on Microsoft word? BSBADM502: Assessment 1 What you have to do This assessment requires yOu to organise an inf0rmal meeting....
-
Dave Packet is a success. From humble beginnings in the 1980s, Dave Packet built an international plastics empire growing financially over a thirty-year period. A multi-millionaire many times over,...
-
A competitive market drives the price to the marginal cost of production. Suppose the monopolist's patent expires and many firms enter the market using the same technology, making the market...
-
About "Dream Toy" manufactory Most of the company processes are not digitized. They use classic product development methods: their commercialization method is in-person B2B only, low to no tech day...
-
You recently bought a house with a 1 0 year mortgage loan of TK 1 2 5 , 0 0 , 0 0 0 . The lender charges 1 2 % nominal interest. Mortgage payments are made at the end of each quarter. How much total...
-
Complete the following questions and be sure to explicitly state any assumptions made: 1. Suppose you were a national security analyst tasked to estimate the maximum uranium production in another...
-
Zwahlen Corporation has an activity-based costing system with three activity cost pools--Processing, Setting Up, and Other. Costs in the Processing cost pool are assigned to products based on...
-
Bob is carrying out a cross-country analysis on the relationship between population and GDP. The following regression is considered: GDP=0+popu+as (popu) + u (3) where GDP and popu denote the GDP (in...
-
Explain what is meant by vicarious liability and when it is available?
-
For the flow analysis in Problem 10, consider the situation when temperature is not constant. There is an internal heat source with volumetric rate \(Q\). The duct's walls are thermally insulated....
-
A steady-state turbulent flow through a long coiled duct is modeled using the standard \(k-\epsilon\) model. Assuming the fluid is incompressible and isothermal, write the full system of equations...
-
What determines the adequate grid step in LES far from the walls?
![Mobile App Logo](https://dsd5zvtm8ll6.cloudfront.net/includes/images/mobile/finalLogo.png)
Study smarter with the SolutionInn App