CHAPTER 17 Financial Planning and Forecasting - PowerPoint PPT Presentation

1 / 21
About This Presentation
Title:

CHAPTER 17 Financial Planning and Forecasting

Description:

TIE 6.25x 9.40x Poor. Current ratio 2.50x 3.00x ' Payout ratio 30.00 ... TIE 6.25x 7.81x 9.40x ' Current ratio ... Debt ratio, TIE would improve. 17-19 ... – PowerPoint PPT presentation

Number of Views:93
Avg rating:3.0/5.0
Slides: 22
Provided by: christo419
Category:

less

Transcript and Presenter's Notes

Title: CHAPTER 17 Financial Planning and Forecasting


1
CHAPTER 17Financial Planning and Forecasting
  • Forecasting sales
  • Projecting the assets and internally generated
    funds
  • Projecting outside funds needed
  • Deciding how to raise funds

2
Planning starts with a Mission Statement
3
Then Strategic Goals are stated---Finally
Operating Plans are needed.
4
(No Transcript)
5
Balance sheet (2002),in millions of dollars
Cash sec. 20 Accts. pay. accruals
100 Accounts rec. 240 Notes payable
100 Inventories 240 Total CL 200 Total
CA 500 L-T debt 100 Common stock 500 Net
fixed Retained assets 500 earnings
200 Total assets 1,000 Total claims 1,000
6
Income statement (2002),in millions of dollars
Sales 2,000.00 Less Var. costs
(60) 1,200.00 Fixed costs 700.00 EBIT
100.00 Interest 16.00 EBT
84.00 Taxes (40) 33.60 Net income
50.40 Dividends (30) 15.12 Addn to RE 35.28
7
Key ratios
NWC
Industry Condition BEP 10.00 20.00 Poor Pro
fit margin 2.52 4.00 ROE 7.20 15.60
DSO 43.80 days 32.00 days Inv.
turnover 8.33x 11.00x F. A. turnover 4.00x 5.00
x T. A. turnover 2.00x 2.50x
Debt/assets 30.00 36.00 Good TIE 6.25x 9.40x P
oor Current ratio 2.50x 3.00x Payout
ratio 30.00 30.00 O. K.
8
Key assumptions
  • Operating at full capacity in 2002.
  • Each type of asset grows proportionally with
    sales.
  • Payables and accruals grow proportionally with
    sales.
  • 2002 profit margin (2.52) and payout (30) will
    be maintained.
  • Sales are expected to increase by 500 million.
    (DS 25)

9
How shall Additional Funds Needed be raised?
  • The payout ratio will remain at 30 percent (d
    30 RR 70).
  • No new common stock will be issued.
  • Any external funds needed will be raised as debt,
    50 notes payable and 50 L-T debt.

10
Forecasted Income Statement (2003)
Forecast Basis
2003 Forecast
2002
Sales 2,000 1.25 2,500 Less VC 1,200 0.60 1,50
0 FC 700 0.35 875 EBIT 100
125 Interest 16 16 EBT
84 109 Taxes (40) 34 44 Net
income 50 65 Div. (30) 15 19 Add
n to RE 35 46
11
Forecasted Balance Sheet (2003)Assets (with 2002
Sales 2000)
2003 1st Pass
Forecast Basis (Sales)
2002
Cash 20 0.01 25 Accts.
rec. 240 0.12 300 Inventories 240 0.12
300 Total CA 500 625 Net FA
500 0.25 625 Total assets 1,000 1,250
12
Forecasted Balance Sheet (2003)Liabilities and
Equity
2003 1st Pass
Forecast Basis
2002
AP/accruals 100 0.05 125 Notes payable
100 100 Total CL 200 225 L-T
debt 100 100 Common stk. 500 500 Ret.earnings
200 46 246 Total
claims 1,000 1,071
From income statement.
13
How will the AFN be financed?
  • Additional N/P
  • 0.5 (179) 89.50
  • Additional L-T debt
  • 0.5 (179) 89.50
  • But this financing will add to interest expense,
    which will lower NI and retained earnings. We
    will generally ignore financing feedbacks.

14
Forecasted Balance Sheet (2003)Assets 2nd pass
2003 1st Pass
2003 2nd Pass
AFN
Cash 25 - 25 Accts.
rec. 300 - 300 Inventories 300 - 300
Total CA 625 625 Net FA 625 -
625 Total assets 1,250 1,250
15
Forecasted Balance Sheet (2003)Liabilities and
Equity 2nd pass
2003 1st Pass
2003 2nd Pass
AFN
AP/accruals 125 - 125 Notes payable
100 89.5 190 Total CL 225
315 L-T debt 100 89.5 189 Common
stk. 500 - 500 Ret.earnings 246 - 246
Total claims 1,071 1,250
From income statement.
16
Forecasted ratios (2003)
2002 2003(E) Industry
BEP 10.00 10.00 20.00 Poor Profit
margin 2.52 2.62 4.00 ROE 7.20 8.77 15.60
DSO (days) 43.80 43.80
32.00 Inv. turnover 8.33x 8.33x 11.00x F.
A. turnover 4.00x 4.00x 5.00x T. A.
turnover 2.00x 2.00x 2.50x D/A
ratio 30.00 40.34 36.00 TIE 6.25x 7.81x 9.40
x Current ratio 2.50x 1.99x 3.00x Payout
ratio 30.00 30.00 30.00 O. K.
17
Suppose fixed assets had only been operating at
75 of capacity in 2002
  • Additional sales could be supported with the
    existing level of assets.
  • The maximum amount of sales that can be supported
    by the current level of assets is
  • Capacity sales Actual sales / of capacity
  • 2,000 / 0.75 2,667
  • Since this is less than 2003 forecasted sales, no
    additional assets are needed.

18
How would excess capacity affect the forecasted
ratios?
  • Sales wouldnt change but assets would be lower,
    so turnovers would be better.
  • Less new debt, hence lower interest, so higher
    profits, EPS, ROE (when financing feedbacks were
    considered).
  • Debt ratio, TIE would improve.

19
Forecasted ratios (2003)with projected 2003
sales of 2,500
of 2002 Capacity 100 75
Industry
BEP 10.00 11.11 20.00 Profit
margin 2.62 2.62 4.00 ROE 8.77 8.77 15.60 DS
O (days) 43.80 43.80
32.00 Inv. turnover 8.33x 8.33x 11.00x F. A.
turnover 4.00x 5.00x 5.00x T. A.
turnover 2.00x 2.22x 2.50x D/A ratio 40.34 33.71
36.00 TIE 7.81x 7.81x 9.40x Current
ratio 1.99x 2.48x 3.00x
20
How is NWC managing its receivables and
inventories?
  • DSO is higher than the industry average, and
    inventory turnover is lower than the industry
    average.
  • Improvements here would lower current assets,
    reduce capital requirements, and further improve
    profitability and other ratios.

21
How would the following items affect the AFN?
  • Higher dividend payout ratio?
  • Increase AFN Less retained earnings.
  • Higher profit margin?
  • Decrease AFN Higher profits, more retained
    earnings.
  • Higher capital intensity ratio?
  • Increase AFN Need more assets for given sales.
  • Pay suppliers in 60 days, rather than 30 days?
  • Decrease AFN Trade creditors supply more capital
    (i.e., L/S0 increases).
Write a Comment
User Comments (0)
About PowerShow.com