Jim Daniels Health Products has eight stores. The firm wants to expand by two more stores...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Jim Daniels Health Products has eight stores. The firm wants to expand by two more stores and needs a bank loan to do this. Mr. Hewitt, the banker, will finance construction if the firm can present an acceptable three-month financial plan for January through March. Following are actual and forecasted sales figures: November December Actual Forecast $280,000 January 300,000 February March Additional Information $360,000 April forecast $410,000 400,000 420,000 Of the firm's sales, 30 percent are for cash and the remaining 70 percent are on credit. Of credit sales, 20 percent are paid in the month after sale and 80 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 current month's expected sales. Materials are paid for in the month they are received. Labour expense is 30 percent of sales and is paid in the month of sales. Selling and administrative expense is 7 percent of sales and is also paid in the month of sales. Overhead is $30,000 in cash per month; amortization 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 Collections in the month after credit sales Collections two months after credit sales Total cash receipts Jim Daniels Health Products Cash Receipts Schedule November December January February March April $ $ $ $ $ $ $ $ $ b. Prepare a schedule of monthly cash payments for January, February and March. Jim Daniels Health Products Cash Payments Schedule January $ Payments for purchases Labour expense Selling and administrative expense Overhead Taxes Dividends Total cash payments February $ March $ $ $ c. Prepare a schedule of monthly cash budget with borrowings and repayments for January, February and March. (Do not leave any empty spaces; input a O wherever it is required. Negative answers and amounts to be deducted should be indicated by a minus sign.) Total cash receipts Total cash payments Net cash flow Jim Daniels Health Products Cash Budget January Beginning cash balance. Cumulative cash balance Monthly loan or (repayment) Cumulative loan balance Ending cash balance February March es $ $ es es Jim Daniels Health Products has eight stores. The firm wants to expand by two more stores and needs a bank loan to do this. Mr. Hewitt, the banker, will finance construction if the firm can present an acceptable three-month financial plan for January through March. Following are actual and forecasted sales figures: November December Actual Forecast $280,000 January 300,000 February March Additional Information $360,000 April forecast $410,000 400,000 420,000 Of the firm's sales, 30 percent are for cash and the remaining 70 percent are on credit. Of credit sales, 20 percent are paid in the month after sale and 80 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 current month's expected sales. Materials are paid for in the month they are received. Labour expense is 30 percent of sales and is paid in the month of sales. Selling and administrative expense is 7 percent of sales and is also paid in the month of sales. Overhead is $30,000 in cash per month; amortization 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 Collections in the month after credit sales Collections two months after credit sales Total cash receipts Jim Daniels Health Products Cash Receipts Schedule November December January February March April $ $ $ $ $ $ $ $ $ b. Prepare a schedule of monthly cash payments for January, February and March. Jim Daniels Health Products Cash Payments Schedule January $ Payments for purchases Labour expense Selling and administrative expense Overhead Taxes Dividends Total cash payments February $ March $ $ $ c. Prepare a schedule of monthly cash budget with borrowings and repayments for January, February and March. (Do not leave any empty spaces; input a O wherever it is required. Negative answers and amounts to be deducted should be indicated by a minus sign.) Total cash receipts Total cash payments Net cash flow Jim Daniels Health Products Cash Budget January Beginning cash balance. Cumulative cash balance Monthly loan or (repayment) Cumulative loan balance Ending cash balance February March es $ $ es es
Expert Answer:
Related Book For
Foundations of Financial Management
ISBN: 978-1259024979
10th Canadian edition
Authors: Stanley Block, Geoffrey Hirt, Bartley Danielsen, Doug Short, Michael Perretta
Posted Date:
Students also viewed these finance questions
-
LinkedIn Live Events allow organizations to schedule virtual events in advance to gather attendees and stream directly to an audience via video or audio - only formats.
-
Item 5 1 0 points eBookHintCheck my workCheck My Work button is now enabled 7 Item 5 Exercise 1 0 - 1 5 ( Static ) Prepare a statement of stockholders' equity ( LO 1 0 - 7 ) Power Drive Corporation...
-
The comparative accounts payable and long-term debt balances for a company follow. Current Year Previous Year Accounts payable $54,644 $71,900 Long-term debt 43,648 35,200 Based on this information,...
-
If you were in charge of B&D, indicate the possible decisions you might take as regards the four Ps and the points you would want to keep in mind as you go about the task of marketing for...
-
Consider the following items: a. Lottery' Company has a mailing list of people who have an established tendency to buy lottery tickets through the mail. It sold an exclusive copy of this mailing list...
-
On Monday mornings, the First National Bank only has one teller window open for deposits and withdrawals. Experience has shown that the average number of arriving customers in a four-minute interval...
-
Journalizing and Posting Transactions London Painting Service Ltd. specializes in painting houses. During June, its first month of operations, London Painting engaged in the following transactions:...
-
Luther Processing Company uses a weighted-average process costing system and manufactures a single product??a premium rug shampoo and cleaner. The manufacturing activity for the month of October has...
-
Question 2. A particle moves along a line. At t seconds the particle's velocity is given by v(t) = 2(t-2) 1 1+ (t - 2)2. We observe that . v(t) 2 0 for 0 0 for 2
-
Answer using both methods and follow instructions. =) for the following, Problem, Solve an'd Hand Show the work => Temperature dis tribution's Modeling has seduce d follows.: by Mathematical...
-
The market values and after-tax costs of various sources of capital used by Ridge Tool are shown in the following table. Source of capital Market value Individual cost Long-term debt $700,000 5.3%...
-
What is the present value (aka price) of a 26-year, pure discount bond (zero coupon bond) that pays $1100 at maturity if it is priced to yield 8.09% per year (YTM)? Answer to 2decimal places.
-
The customers and the potential facilities of a country have been aggregated in seven regions as shown in Figure 1. Figure 1: A B D E F G A 0 7 4 5 12 7 14 B 7 0 11 12 12 14 11 A A company would...
-
Windsor Inc. issues 8,500 shares of $100 par value preferred stock for cash at $110 per share. Journalize the issuance of the preferred stock. (Credit account titles are automatically indented when...
-
Suppose you have $600 today and you need $1,300 to buy a new laptop. How long will you have to wait to buy the laptop if she earns 8 percent compounded annually on her money?
-
1. A manufacturer reports the following information below forits first three years in operation.Year 1Year 2Year 3Variable costing income$ 76,000$ 109,000$ 115,000Beginning finished 2 answers
-
A stock has had returns of 8 percent, 26 percent, 14 percent, 17 percent, 31 percent, and 1 percent over the last six years. What are the arithmetic and geometric average returns for the stock?
-
Product mix decision: limited demand (Learning Objective 5) Consider StoreAll in S8-8 . Assume that demand for regular bins is limited to 30,000 units and demand for large bins is limited to 25,000...
-
Replace a department (Learning Objective 4)} Consider Knight Fashion from S8-5 . Assume once again that all fixed costs are unavoidable. If Knight Fashion drops one of the current departments, it...
-
Drop a department: revised information (Learning Objective 4)} Consider Knight Fashion from S8-5 . Assume that the fixed expenses assigned to each department include only direct fixed costs of the...
Study smarter with the SolutionInn App