Ch13UsingAVBTemplate(noform)

Ch13UsingAVBTemplate(noform) - Inputs 0 Units Price Cost or...

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

View Full Document Right Arrow Icon
Inputs 0 1 2 3 4 Units 1000 1000 1000 1000 Price 24 25 25 26 Cost or Unit Cost 10,000 18 18 19 19 Price/Cost Infl 3% 3% 3% MACRS 20% 32% 19% 12% WC/NextSales 10% 10% 10% 10% 10% Initial inv WC 2,400 Salvage Value 500 Cost of Capital 10% 10% 10% 10% 10% Financials Revenues 24,000 24,720 25,462 26,225 COGS 17,500 18,025 18,566 19,123 OPEX 1,000 1,030 1,061 1,093 Depr 2,000 3,200 1,920 1,152 EBIT/EBT 3,500 2,465 3,915 4,858 Taxes 40% 1,400 986 1,566 1,943 NI=NOPAT 2,100 1,479 2,349 2,915 Add Depr 2,000 3,200 1,920 1,152 EQ Op CF 4,100 4,679 4,269 4,067 Minus IncrWC 72 74 76 (2,623) EQ FCF 4,028 4,605 4,193 6,689 Terminal CF 991 Total CF (12,400) 4,028 4,605 4,193 7,681 PV Factor 1 0.9091 0.8264 0.7513 0.6830 PV (12,400) 3,662 3,806 3,150 5,246 NPV 3,463 IRR 21% Payback 2.90 (12,400) (8,372) (3,767) 425 8,106 NOWC 2,400.00 2,472.00 2,546.16 2,622.54 - Increase in NOWC 2,400.00 72 74 76 (2,623)
Background image of page 1

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

View Full DocumentRight Arrow Icon
Tot Depr Book Value 8,272 1,728 Calculated Calculated Recovery of WC (Part of Terminla CF) adds to OpCF Salvage Value -(Salvage Value - Book Value)*TaxRate) 1/(1+rate)^period Total CF* PV Factor SUM PV PLUS The Outflow (or if shown positive MINUS the Outflow) Manual count (you can build a formula)
Background image of page 2
Inputs 0 1 2 3 4 Units 800 800 800 800 Price 24 25 25 26 Cost or Unit Cost 10,000 18 18 19 19 Price/Cost Infl 3% 3% 3% MACRS 20% 32% 19% 12% WC/NextSales 10% 10% 10% 10% 10% Initial inv WC
Background image of page 3

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

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

Page1 / 10

Ch13UsingAVBTemplate(noform) - Inputs 0 Units Price Cost or...

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

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