Liston Mechanics
Forecast of Free Cash Flow and military rank Analysis
This financial model can be apply to value Liston Mechanics. All cells are protected, meaning you
cannot change the values, keep out the blue cellss. The pink cell shows the output (firm value).
Assumptions:
Sales ingatheringEBIT or Operating Margin =20.0%p. 1
for 2005-066.0%Tax set out40.0%p. 1
for 2007-085.0%NWC as % of Sales =20.0%p. 1
for 2009 & beyond3.0%
can Rate11.8%CapEx per year =$35.0p. 1
Current Debt Outstanding =$140.0from X-1
make:
PV of FCF (2004-09)$136.131%NPV =$438.7
PV of Terminal entertain$302.669%Debt =$140.0
Total staunch pass judgment$438.7Equity =$298.7
Free Cash Flow advisement
Current
200420052006200720082009
Sales$310.0$328.6$348.3$365.7$384.0$395.5
Earnings bef. Int. & Taxes (EBIT)$62.0$65.7$69.7$73.1$76.8$79.1
Taxes($26.3)($27.9)($29.3)($30.7)($31.6)
EBIAT or NOPAT$39.4$41.8$43.9$46.1$47.5
+ Depreciation$31.0$32.0$33.0$34.0$35.0Given
- dandy Expenditures($35.0)($35.
0)($35.0)($35.0)($35.0)
- Increases in NWC($3.7)($3.9)($3.5)($3.7)($2.3)
= Free Cash Flow$31.7$34.9$38.4$41.4$45.2
Terminal Value (Growing Perpetuity)$528.6
TV09 = (FCF09*(1+g)) / (WACC - g)
WACC =11.8%
Discount Factor1.0000.8940.8000.7160.6400.573
Present Values
FCF (2004-09)$28.36$27.89$27.48$26.52$25.86
Terminal Value$302.63
Total Net Working Capital$62.0$65.7$69.7$73.1$76.8$79.1
Increase in NWC$3.7$3.9$3.5$3.7$2.3
Definition: The discount...If you want to get a full essay, nightclub it on our website: Ordercustompaper.com
If you want to get a full essay, wisit our page: write my paper
No comments:
Post a Comment