Case 4 Growing Pains Solution
Patrick R. Price2004-08-22T17:16:00Financial Analysis and Forecasting
Growing Pains
Questions Since this is the first time Jim and Mason will be conducting a financial forecast for Oats’ R’ Us, how do you think they should proceed? Which approaches or models can they use? What are the assumptions necessary for utilizing each model?
Jim and Mason should begin their planning with a reasonable sales forecast. The sales forecast ought to be based on clearly stated assumptions about future economic conditions. Next, they should prepare pro forma financial statements by either assuming that the key items vary proportionately with sales or remain constant (as the case may be). Based on their asset utilization rate, they would be able to determine the asset requirements for growth. Some of the funds required to finance growth would be raised from spontaneous sources such as accounts payables and accruals and from future retained earnings. The remaining funds necessary for growth could then be raised from external sources such as new debt and stock offering.
Jim and Mason can use one of the following approaches: Pro Forma Approach – where most of the income statement and balance sheet items are assumed to maintain a constant proportion to sales, but individual items can be forecasted using statistical techniques and feedback effects involving changes in interest costs etc. can be included. EFN Formula Method – which is simple to use but does not allow the inclusion of feedback effects.
If Oats’ R’ Us is operating its fixed assets at full capacity, what growth rate can it support without the need for any additional external financing?
EFN = (Ao/So)*(Change in sales) – (Lo/So)*(Change in Sales) - Net Margin*(So + Change in sales)*Retention Rate where, So = Current sales;
New Sales = S1 = (So + Change in sales)
Retention Rate = 1 – Payout Ratio
Income Statement –Percent of Sales | For the Year Ended Dec. 31st, 2004 |
Growing Pains
Questions Since this is the first time Jim and Mason will be conducting a financial forecast for Oats’ R’ Us, how do you think they should proceed? Which approaches or models can they use? What are the assumptions necessary for utilizing each model?
Jim and Mason should begin their planning with a reasonable sales forecast. The sales forecast ought to be based on clearly stated assumptions about future economic conditions. Next, they should prepare pro forma financial statements by either assuming that the key items vary proportionately with sales or remain constant (as the case may be). Based on their asset utilization rate, they would be able to determine the asset requirements for growth. Some of the funds required to finance growth would be raised from spontaneous sources such as accounts payables and accruals and from future retained earnings. The remaining funds necessary for growth could then be raised from external sources such as new debt and stock offering.
Jim and Mason can use one of the following approaches: Pro Forma Approach – where most of the income statement and balance sheet items are assumed to maintain a constant proportion to sales, but individual items can be forecasted using statistical techniques and feedback effects involving changes in interest costs etc. can be included. EFN Formula Method – which is simple to use but does not allow the inclusion of feedback effects.
If Oats’ R’ Us is operating its fixed assets at full capacity, what growth rate can it support without the need for any additional external financing?
EFN = (Ao/So)*(Change in sales) – (Lo/So)*(Change in Sales) - Net Margin*(So + Change in sales)*Retention Rate where, So = Current sales;
New Sales = S1 = (So + Change in sales)
Retention Rate = 1 – Payout Ratio
Income Statement –Percent of Sales | For the Year Ended Dec. 31st, 2004 |