Class10-7 - Coc NPV 5% $584.09 IRR 19% Payback 4.63 0 375...

Info iconThis preview shows pages 1–5. Sign up to view the full content.

View Full Document Right Arrow Icon
Coc NPV 0 1 2 3 4 5 6 5% $584.09  -375 -300 -200 -100 600 600 926 IRR 19% Payback 4.63 -375 -675 -875 -975 -375 225 1151 Coc NPV 5% $389.38  -575 190 190 190 190 190 190 IRR 24% Payback 3.03 -575 -385 -195 -5 185 375 565 WACC NPVA NPVB 5% $584.09  $389.38  6% 7% 8% 9% 10% 12% $226.96  $206.17  13% 14% 15% 16% 17% 18% $18.24  $89.54 
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
7 -200 NPV formula = Yr0Inv+NPV Rest You could do this by "AVB way" of doing the PV Factors and PVs and Sum 951 Manual count for full years (not counting 0 year) and fraction for next 0 565
Background image of page 2
GO to the Saved Sample using AVB Template (without formulas) 0 1 2 3 4 5 Cost  10,000  20% 32% 19% 12% 11% Salvage 500 NOWC 10% Units  1,000   1,000   1,000   1,000  Price  24.00  24.72 25.46 26.23 Cost   17.50  18.03 18.57 19.12 Infl 3% Fixed  1,000   1,030.00   1,060.90   1,092.73  Tax  40% WACC 10% Financials Revenue  24,000  Cost  17,500  Fixed  1,000  Depr  2,000  EBIT  3,500  Taxes  1,400  NOPAT  2,100  Depr  2,000  OCF  4,100  WC 2400 0 0 0 0 Inv
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
6 6%
Background image of page 4
Image of page 5
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 10

Class10-7 - Coc NPV 5% $584.09 IRR 19% Payback 4.63 0 375...

This preview shows document pages 1 - 5. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online