Jodi Horton, president of the retailer Crestline Products, has just approached the company's bank with a...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Jodi Horton, president of the retailer Crestline 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 in support of peak April sales. 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-June, dur- ing which the loan will be used: a. On April 1, the start of the loan period, the cash balance will be $26,000. Accounts receivable on April 1 will total $151,500, of which $141,000 will be collected during April and $7,200 will be collected during May. The remainder will be uncollectible. b. Past experience shows that 20% of a month's sales are collected in the month of sale, 75% in the month following sale, and 4% in the second month following sale. The other 1% rep- resents bad debts that are never collected. Budgeted sales and expenses for the three-month period follow: April May June Sales (all on account). $200,000 $300,000 $250,000 Merchandise purchases $120,000 $180,000 $150,000 Payroll..... $9,000 $9,000 $8,000 Lease payments. $15,000 $15,000 $15,000 Advertising.. $70,000 $80,000 $60,000 Equipment purchases. $8,000 Depreciation... $10,000 $10,000 $10,000 C. Merchandise purchases are paid in full during the month following purchase. Accounts pay- able for merchandise purchases on March 31, which will be paid during April, total $108,000. d. In preparing the cash budget, assume that the $30,000 loan will be made in April and repaid in June. Interest on the loan will total $1,200. Required: 1. Prepare a schedule of 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. 3. If the company needs a minimum cash balance of $20,000 to start each month, can the loan be repaid as planned? Explain. Jodi Horton, president of the retailer Crestline 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 in support of peak April sales. 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-June, dur- ing which the loan will be used: a. On April 1, the start of the loan period, the cash balance will be $26,000. Accounts receivable on April 1 will total $151,500, of which $141,000 will be collected during April and $7,200 will be collected during May. The remainder will be uncollectible. b. Past experience shows that 20% of a month's sales are collected in the month of sale, 75% in the month following sale, and 4% in the second month following sale. The other 1% rep- resents bad debts that are never collected. Budgeted sales and expenses for the three-month period follow: April May June Sales (all on account). $200,000 $300,000 $250,000 Merchandise purchases $120,000 $180,000 $150,000 Payroll..... $9,000 $9,000 $8,000 Lease payments. $15,000 $15,000 $15,000 Advertising.. $70,000 $80,000 $60,000 Equipment purchases. $8,000 Depreciation... $10,000 $10,000 $10,000 C. Merchandise purchases are paid in full during the month following purchase. Accounts pay- able for merchandise purchases on March 31, which will be paid during April, total $108,000. d. In preparing the cash budget, assume that the $30,000 loan will be made in April and repaid in June. Interest on the loan will total $1,200. Required: 1. Prepare a schedule of 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. 3. If the company needs a minimum cash balance of $20,000 to start each month, can the loan be repaid as planned? Explain.
Expert Answer:
Related Book For
Managerial Accounting
ISBN: 9780073526706
12th Edition
Authors: Ray H. Garrison, Eric W. Noreen, Peter C. Brewer
Posted Date:
Students also viewed these accounting questions
-
Jodi Horton, president of the retailer Crestline 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...
-
d. Describe the general steps that should have taken place at the interim and final stages for this design and what numbers and estimates should be used where. For example, what effect size and...
-
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...
-
A Norman window has the outline of a semicircle on top of a rectangle. Suppose there are 8 + feet of wood trim available. Discuss why a window designer might want to maximize the area of the window....
-
What are the advantages of working for an environmentally-friendly company? Are there any disadvantages? Explain.
-
To control the power output of an isentropic steam turbine, a throttle valve is placed in the steam line supplying the turbine inlet, as shown in the figure. Steam at 6 MPa and 400°C is supplied...
-
A market trader is offering a $500m loan agreement in 3 months, for a period of 3 months on the following terms: 3 3/4% 3 7/8%. Using the information provided in Questions 1 and 2, can you identify...
-
Burger Baby restaurants engaged Air Advertising to fly an advertisement above the Connecticut beaches. The advertisement offered $1,000 to any person who could swim from the Connecticut beaches to...
-
Quality Fender, which uses a standard cost system, manufactured 20,000 boat fenders during 2018, using 142,000 square feet of extruded vinyl purchased at $1.35 per square foot. Production required...
-
Analysis and Interpretation of Profitability Balance sheets and income statements for 3M Company follow. 3M COMPANY Consolidated Statements of Income For Years ended December 31 ($ millions) 2018...
-
2b) Utilizing Excel's Goal Seek function, determine the number of units that need to be sold to have a net income of $200,000 given that the price is maintained at $29.99. Do NOT round your number to...
-
Under the assumption that a leftist tree has m internal nodes, where x is the label of the root and s( x ) is its s -value (just give a sketch of the proof). Show that, a s(x) log 2 ( m + 1) ...
-
What is the minimum force you must apply to pull a wagon weighing 5 0 lbs up a frictionless ramp inclined at a 1 5 degree angle?
-
Explain why synergy is most obvious when firms merge with other firms in the same line of business.
-
Today is May 5, 2017 and the current (APR form) three-month interest rate is r0,3mth = 10%. A bank makes a market in $95/$100 August 2017 bear put spreads on 10-year Treasury notes with a semi-annual...
-
3 kg box slides across a surface with an initial speed of 2 m / s . The box comes to a stop at a distance of 8 m . Determine ( quantitatively ) the force required to bring the box to a stop.
-
Noriaki's Canning manufactures cans used in a variety of industries. The company split its operations into two divisions: beverages and food products. The information for the past year is as follows:...
-
Identify the source of funds within Micro Credit? How does this differ from traditional sources of financing? What internal and external governance mechanisms are in place in Micro Credit?
-
What is important in a capital increase where each shareholder takes his proportionate share of the issue?
-
Why are the most profitable companies the ones that gain the most by issuing new shares?
-
Should there be an issue of new shares whenever the share price is overvalued?
Study smarter with the SolutionInn App