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...
-
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...
-
The following income statement was prepared for Ludlum, Clancy, Follet & Associates, a partnership comprised of four partners who share income equally. The adjusted cost base to Mr. Clancy of his...
-
Use the table of values of to determine which of (A) or (B) in Figure 14 is the graph of '. Explain. X 0 0.5 1 1.5 2 2.5 3 3.5 4 237 257 268 f(x) 10 55 98 139 177 210 Kn y (A) (B) -X
-
A flat conducting plate is centered in the \(x y\) plane of an \(x y z\) coordinate system in which the \(x y\) plane is horizontal. A bar magnet is lowered vertically toward the plate. If the magnet...
-
Suppose that the court determines that the parties did not reach an agreement. Further suppose that Amstel, in anticipation of building Durbins studio, had purchased materials and refused other jobs...
-
A hiker and his dog have discovered a skeleton hidden deep in the woods. The medical examiner has identified this skeleton as female. What characteristics of the skeleton would help the examiner make...
-
A firm is planning on paying its first dividend of $2 in three years. After that dividends are expected to grow at 6% per year indefinitely. The stock's required return is 14%. What is the intrinsic...
-
The adjusting entry for accrued wages was omitted at July 31, the end of the current year. Indicate which items will be in error, because of the omission, on (a) the income statement for the current...
-
The balance in the unearned fees account, before adjustment at the end of the year, is $18,000. Journalize the adjusting entry required if the amount of unearned fees at the end of the year is $3,600.
-
Identify each of the following accounts of Liken Services Co. as asset, liability, stockholders equity, revenue, or expense, and state in each case whether the normal balance is a debit or a credit:...
-
Accrued salaries owed to employees for October 30 and 31 are not considered in preparing the financial statements for the year ended October 31. Indicate which items will be erroneously stated,...
-
At the end of the current year, $59,500 of fees have been earned but have not been billed to clients. a. Journalize the adjusting entry to record the accrued fees. b. If the cash basis rather than...
-
Write a paper on Excessive Internet Use Leads to Adverse Health Issues
-
On April 29, 2015, Auk Corporation acquires 100% of the outstanding stock of Amazon Corporation (E & P of $750,000) for $1.2 million. Amazon has assets with a fair market value of $1.4 million (basis...
-
Which of these adaptations is the result of sexual selection? (a) the spines on cactus plants (b) parental care in male poison dart frogs (c) the songs of male birds (d) dark wings in peppered moths
-
Which of the following provides evidence for evolution? (a) changes in the coloration of peppered moth populations over time (b) the presence of vestigial eyes in cave salamanders (c) the fact that...
-
If you put a heavy load in a wheelbarrow, the force you apply to the handles is much less than the weight of the load and the wheelbarrow. To lift with the least force, you put the load toward the...
Study smarter with the SolutionInn App