Harry's Carryout Stores has eight locations. The firm wishes to expand by two more stores and...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Harry's Carryout Stores has eight locations. The firm wishes to expand by two more stores and needs a bank loan to do this. Mr. Wilson, the banker, will finance construction if the firm can present an acceptable three-month financial plan for January through March. The following are actual and forecast sales figures: Actual Forecast Additional Information $380,000 November $280,000 January $360,000 April forecast December 300,000 February March 400,000 390,000 Of the firm's sales, 40 percent are for cash and the remaining 60 percent are on credit. Of credit sales, 50 percent are paid in the month after sale and 50 percent are paid in the second month after the sale. Materials cost 40 percent of sales and are purchased and received each month in an amount sufficient to cover the following month's expected sales. Materials are paid for in the month after they are received. Labor expense is 30 percent of sales and is paid for in the month of sales. Selling and administrative expense is 15 percent of sales and is paid in the month of sales. Overhead expense is $21,000 in cash per month. Depreciation expense is $10,400 per month. Taxes of $8,400 will be paid in January, and dividends of $4,000 will be paid in March. Cash at the beginning of January is $88,000, and the minimum desired cash balance is $83,000. a. Prepare a schedule of monthly cash receipts for January, February, and March. Sales Credit sales Cash sales One month after sale Two months after sale Harry's Carryout Stores Cash Receipts Schedule November December January February March 4 10 a. Prepare a schedule of monthly cash receipts for January, February, and March. points eBook Sales Credit sales Cash sales Print One month after sale Two months after sale Total cash receipts Harry's Carryout Stores Cash Receipts Schedule November December January February March $ 0 $ 0 $ 0 b. Prepare a schedule of monthly cash payments for January, February, and March. Harry's Carryout Stores Payments for purchases Labor expense Selling and administrative Overhead Cash Payments Schedule January February March 10 b. Prepare a schedule of monthly cash payments for January, February, and March. 4 points eBook Print Payments for purchases Labor expense Selling and administrative Overhead Taxes Harry's Carryout Stores Cash Payments Schedule January February March Dividends Total cash payments $ 0 $ 0 $ 0 c. Prepare a monthly cash budget with borrowings and repayments for January, February, and March. (Negative amounts should be indicated by a minus sign. Assume the January beginning loan balance is $0.) Harry's Carryout Stores Cash Budget January February March Total cash receipts Total cash payments Net cash flow 0 0 0 Check m 4 10 Dividends Total cash payments $ 0 $ 0 $ 0 points eBook Print c. Prepare a monthly cash budget with borrowings and repayments for January, February, and March. (Negative amounts should be indicated by a minus sign. Assume the January beginning loan balance is $0.) Total cash receipts Total cash payments Harry's Carryout Stores Cash Budget January February March Net cash flow 0 0 0 Beginning cash balance Cumulative cash balance 0 0 0 Monthly loan (or repayment) Ending cash balance 0 0 0 Cumulative loan balance Harry's Carryout Stores has eight locations. The firm wishes to expand by two more stores and needs a bank loan to do this. Mr. Wilson, the banker, will finance construction if the firm can present an acceptable three-month financial plan for January through March. The following are actual and forecast sales figures: Actual Forecast Additional Information $380,000 November $280,000 January $360,000 April forecast December 300,000 February March 400,000 390,000 Of the firm's sales, 40 percent are for cash and the remaining 60 percent are on credit. Of credit sales, 50 percent are paid in the month after sale and 50 percent are paid in the second month after the sale. Materials cost 40 percent of sales and are purchased and received each month in an amount sufficient to cover the following month's expected sales. Materials are paid for in the month after they are received. Labor expense is 30 percent of sales and is paid for in the month of sales. Selling and administrative expense is 15 percent of sales and is paid in the month of sales. Overhead expense is $21,000 in cash per month. Depreciation expense is $10,400 per month. Taxes of $8,400 will be paid in January, and dividends of $4,000 will be paid in March. Cash at the beginning of January is $88,000, and the minimum desired cash balance is $83,000. a. Prepare a schedule of monthly cash receipts for January, February, and March. Sales Credit sales Cash sales One month after sale Two months after sale Harry's Carryout Stores Cash Receipts Schedule November December January February March 4 10 a. Prepare a schedule of monthly cash receipts for January, February, and March. points eBook Sales Credit sales Cash sales Print One month after sale Two months after sale Total cash receipts Harry's Carryout Stores Cash Receipts Schedule November December January February March $ 0 $ 0 $ 0 b. Prepare a schedule of monthly cash payments for January, February, and March. Harry's Carryout Stores Payments for purchases Labor expense Selling and administrative Overhead Cash Payments Schedule January February March 10 b. Prepare a schedule of monthly cash payments for January, February, and March. 4 points eBook Print Payments for purchases Labor expense Selling and administrative Overhead Taxes Harry's Carryout Stores Cash Payments Schedule January February March Dividends Total cash payments $ 0 $ 0 $ 0 c. Prepare a monthly cash budget with borrowings and repayments for January, February, and March. (Negative amounts should be indicated by a minus sign. Assume the January beginning loan balance is $0.) Harry's Carryout Stores Cash Budget January February March Total cash receipts Total cash payments Net cash flow 0 0 0 Check m 4 10 Dividends Total cash payments $ 0 $ 0 $ 0 points eBook Print c. Prepare a monthly cash budget with borrowings and repayments for January, February, and March. (Negative amounts should be indicated by a minus sign. Assume the January beginning loan balance is $0.) Total cash receipts Total cash payments Harry's Carryout Stores Cash Budget January February March Net cash flow 0 0 0 Beginning cash balance Cumulative cash balance 0 0 0 Monthly loan (or repayment) Ending cash balance 0 0 0 Cumulative loan balance
Expert Answer:
Related Book For
Foundations of Financial Management
ISBN: 978-1259194078
15th edition
Authors: Stanley Block, Geoffrey Hirt, Bartley Danielsen
Posted Date:
Students also viewed these finance questions
-
Post the following entry to the general ledger and subsidiary ledger. GENERAL JOURNAL Post. Ref. Page 52 Date 20-- August 16 Sales Returns and Allowances Description Debit Credit 2 8 6 42 Accounts...
-
The following additional information as at 31 May 2019 is available: i)Inventories as at the close of business were valued at RM25,900. ii)Depreciation for the year ended 31 May 2019 has yet to be...
-
Harrys Carryout Stores has eight locations. The firm wishes to expand by two more stores and needs a bank loan to do this. Mr. Wilson, the banker, will finance construction if the firm can present an...
-
Ford Company's cost of capital is 13%. It has invested x (million dollars) in current assets. The following function represents the shortage cost of its current assets: S = 9 e- x/3 Find the...
-
Jonsub Ltd. is a wholly owned subsidiary of Normpar Ltd. Normpar Ltd. plans to merge the two companies, either by amalgamating with the subsidiary [sec. 87] or by winding up the subsidiary [ssec....
-
What are the key factors that auditors consider when assessing the risk of material misstatement in financial reporting?
-
Cedric Salos is considering different ways to raise money for the expansion of his company's operations. Cedric is not sure about the advantages of issuing bonds versus issuing common stock. In...
-
a. In the accompanying diagram (which represents the market for chocolate candy bars), the initial equilibrium is at the intersection of S1 and D1. Circle the new equilibrium if there is an increase...
-
*4. Suppose there are no taxes. Firm ABC has no debt, and firm XYZ has debt of $5000 on which it pays interest of 10% each year. Both companies have identical projects that generate free cash flows...
-
Hauck Financial Services has a number of passive, buy-and-hold clients. For these clients, Hauck offers an investment account whereby clients agree to put their money into a portfolio of mutual funds...
-
On January 1, 2021, Wahoo Company sells equipment for $25,600. The equipment was originally purchased on January 1, 2019 for $46,200. The equipment was estimated to have a useful life of 5 years and...
-
Suppose that the initial HRIS implementation was not successful. HR person resigned and his replacement investigated the failure to establish what the problem might have been. The person uncovered...
-
The abrams corporation incurred the following quality costs during the year: inspections $ 3 2 , 4 0 0 , training $ 1 5 , 0 0 0 , quality planning $ 7 , 0 0 0 , maintenance $ 6 , 3 0 0 , rework $ 3 ,...
-
At 9 am on 2 0 th November Mr Chan, ( " Chan " ) received a faxed pro forma standard form contract from HK Paper Ltd:"Premium XX photocopy paper at HK$ 5 0 0 per box of 2 , 0 0 0 pages per box, 5 0 0...
-
Question after watching all this link answer and put reference include citations How can the concepts of psychological safety, collaboration, and social cohesion contribute to the effectiveness of...
-
How do financial institutions manage interest rate risk arising from mismatches in the repricing profiles of their assets and liabilities, and what hedging strategies, such as duration matching,...
-
An investment, C, yields the following cash flow and salvage value in the end of last year, calculate the capital cost required for this investment at interest rate of 10% compounded annually. Please...
-
A consumer magazine is evaluating five brands of trash compactors for their effectiveness in reducing the volume of typical household products that are discarded. In the experiment, each block...
-
Global Markets, Inc. was experiencing a shortage of cash. Consequently, the President was considering two options to provide an immediate inflow of cash. The first option was to sell \($2\) million...
-
Star Communications designs, manufactures, and sells telecommunication equipment, and provides services associated with their installation, operation, and maintenance in China, India, Korea, and...
-
The 2015 annual report of the Procter & Gamble Company (P&G) is available at www.pginvestor.com. After reviewing P&Gs annual report, respond to the following questions: a. When does P&G recognize...
Study smarter with the SolutionInn App