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 $71,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 $43,800. Accounts receivable on April 1 will total $179,200, of which $153,600 will be collected during April and $20,480 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 $ 235,000 Merchandise purchases Payroll Lease payments Advertising $ 197,000 $ 33,600 $ 33,600 May $ 652,000 $213,500 June $ 342,000 $ 151,000 $ 23,100 $ 39,600 $ 39,600 $ 39,600 $ 70,200 $ 70,200 $ 83,280 Equipment purchases Depreciation $ 70,000 $ 31,200 $ 31,200 $ 31,200 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 $145,500. d. In preparing the cash budget, assume that the $71,000 loan will be made in April and repaid in June. Interest on the loan will total $1,060. The president of the retailer Prime Products has just approached the company's bank with a request for a $71,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 $43,800. Accounts receivable on April 1 will total $179,200, of which $153,600 will be collected during April and $20,480 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 $ 235,000 Merchandise purchases Payroll Lease payments Advertising $ 197,000 $ 33,600 $ 33,600 May $ 652,000 $213,500 June $ 342,000 $ 151,000 $ 23,100 $ 39,600 $ 39,600 $ 39,600 $ 70,200 $ 70,200 $ 83,280 Equipment purchases Depreciation $ 70,000 $ 31,200 $ 31,200 $ 31,200 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 $145,500. d. In preparing the cash budget, assume that the $71,000 loan will be made in April and repaid in June. Interest on the loan will total $1,060.
Expert Answer:
Answer rating: 100% (QA)
To prepare the cash budget for Prime Products for the months April through June we need to forecast ... View the full answer
Posted Date:
Students also viewed these accounting questions
-
COMPANY, RECEIVABLES, PAYABLES Modules Mar 6 The manager advised you that she used the business Universal Credit card to purchase $50.00, plus HST, on invoice #223 for miscellaneous repair parts for...
-
K Solve the system by using matrix reduction w+ xy5z=-3 2w+3x+2y+10z= 10 2w+x+2y+ 2z 2 Select the correct choice below and fill in any answer boxes to complete your choice. OA. The unique solution is...
-
Find the savings plan balance after 3 years with an APR of 4 % and monthly payments of $ 1 5 0
-
Show that in the limit ??x ?? 0 and ??t ?? 0, the difference Equation (3.12) is equivalent to the differential Equation (2.5). GIVENThe difference equation for one-dimensional transient...
-
Seventy percent of the bicycles sold by a certain store are mountain bikes. Among 100 randomly selected bike purchases, what is the approximate probability that a. At most 75 are mountain bikes? b....
-
Solve the given homogeneous linear system. Compare your results to the results of the corresponding exercise in Section TSS. 1. x1 + 4x2 + 3x3 - x4 = 0 x1 - x2 + x3 + 2x4 = 0 4x1 + x2 + 6x3 + 5x4 = 0...
-
Albin Companys adjusted trial balance on March 31, 2005, its fiscal year-end, follows: Required 1. Calculate the companys net sales for the year. 2. Calculate the companys total cost of merchandise...
-
Rode Inc. incurred a net operating loss of $500,000 in 2010. Combined income for 2008 and 2009 was $350,000. The tax rate for all years is 40%. Rode elects the carry back option. Prepare the journal...
-
AMNP dreptunghic, m(4N)-90, NR- nlime n triunghi. NR-4 cm, RP-8 cm, aflai: MR, MP, MN, NP.
-
Apply your critical-thinking ability to the knowledge youve gained. These cases will provide you with an opportunity to develop your research, analysis, judgment, and communication skills. You also...
-
Walen Co. has intends to purchase a new forklift for $80,000.00 cash. It expects annual net operating cash flows of $15,000 per year for 8 years, and a salvage value at the end of 8 years of $8,200....
-
what extent does the articulation of a company's mission and values influence employee engagement and the overall effectiveness of internal communications ?
-
what ways can strategic communication and messaging coherence enhance brand perception and stakeholder engagement in multinational corporations ?
-
Cornish and Duffee form a partnership by investing $ 1 2 0 , 0 0 0 and $ 1 3 0 , 0 0 0 respectively. Their partnership agreement stipulates that Cornish will receive an annual salary allowance of $ 1...
-
East Jet Inc. sells a customer an airline ticket on March 2 9 , 2 0 2 3 to fly business class from Toronto to Hong Kong on April 3 , returning July 1 , 2 0 2 3 . The fare is $ 1 2 , 5 0 0 and was...
-
Making smaller batch sizes and moving processes closer together can reduce conveyance muda. True False
-
What are the 5 Cs of marketing channel structure?
-
A company often test-markets a proposed product in a specific area or location. Suppose that you wish to test-market your new, revolutionary SuperWax car wax, which requires only one application for...
-
The idea for New Belgium Brewing Company began with a bicycling trip through Belgium, where some of the worlds finest ales have been brewed for centuries. As Jeff Lebesch, a U.S. electrical engineer,...
-
It is helpful to think of a total product offering as having a combination of three interdependent elements: the core product itself, its supplemental features, and its symbolic or experiential...
Study smarter with the SolutionInn App