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
-
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...
-
There is a range of items on the balance sheet that lack tangibility'. There are items such as: a. Short- or long-term accounts receivable b. Prepaid expenses for rent or insurance c. Deferred...
-
In a learning curve application, 846.2 work-hours are required for the third production unit and 783.0 work-hours are required for the fifth production unit. Determine the value of n (and therefore...
-
The temperature at which a liquid is in equilibrium with its own vapour at a specified pressure is called the (a) Adiabatic temperature (b) Saturated temperature (c) Equilibrium temperature (d) None...
-
The following defined pension data of Doreen Corp. apply to the year 2012. Defined benefit obligation, 1/1/12 (before amendment) ... $560,000 Plan assets, 1/1/12 ................... 546,200 Pension...
-
During 2011, Friesen Corporation is sued by a customer who slipped and fell on the company's property. As of 12/31/2011, the lawsuit has not been finalized. Friesen Corporation evaluates the...
-
Darryl received several acres of land from his mother as a gift. At the time of the gift, the land had a fair market value of $95,000. The mother's adjusted basis in the land was $105,000. Two years...
-
1. Discuss the various kinds of crime classifications. To what extent or degree are they distinguishable? 2. List the problems faced by todays police departments that were also present during the...
-
Google developed a cross-compiler from Java to JavaScript. Why did they do this? Does this mean that JavaScript is not good enought for developing advanced web apps? What cultural phenomenon occurred...
-
A company provides the following account balances at year end ( except for Retained Earnings, which is the beginning balance ) . The CFO has asked you to use this information to prepare an income...
-
You are the Head of Security for your multimillion - dollar corporation. Recently, you have been restoring your computer system because of a serious breach that occurred over a period of several...
-
The Metropolitan Company sells its latest product at a unit price of $ 9 . Variable costs are estimated to be 5 0 % of the total revenue, while fixed costs amount to $ 6 , 3 0 0 per month. How many...
-
Temperature and volume data Trial Temperature (Celsius) Volume (mL) Starting Volume Room Temperature = Hot Water Trial 1 Hot Water Trial 2 Cold Water Trial 1 Cold Water Trial 2 Note: On the graph,...
-
According to a recent survey, 40% of millennials (those born in the 1980s or 1990s) view themselves more as spenders than savers. The survey also reveals that 75% of millennials view social...
-
Discuss the parts of the communications mix.
-
What choice criteria did Jim and Mary use when deciding whether to buy a computer and which model to buy?
-
Did the salesperson understand the motives behind the purchase? If not, why not? Did s/he make any other mistakes?
Study smarter with the SolutionInn App