NPV and IRR calculations

NPV and IRR calculations

NPV and IRR calculations


































Cost of Capital 1.00%






Time/yr 0 1 2 3 4 5

Cash flow Input here







Discounted CF 0 0 0 0 0 0

NPV 0 =cf1/((1+n)^1) =cf2/((1+n)^2) =cf3/((1+n)^3) =cf4/((1+n)^4) =cf5/((1+n)^5)

PV factor
0.99009901 0.980296049 0.970590148 0.960980344 0.951465688










IRR #NUM!


































Year







0 1 2 3 4 5

Capital Outlay-30000000







NWC Recovery







Sales







Margin 60%
of sales or 40% CGS exp 0 0 0 0 0

SGA expense 10% of sales
0 0 0 0 0










Gross Profit
0 0 0 0 0

Depreciation
Expense – Straight Line






Equip $25000000/5







EBT
0 0 0 0 0

Tax Exp at 35%
0 0 0 0 0

Net Income
0 0 0 0 0










Outflow







Cashflow add Depreciation back in
0 0 0 0 0

NWC Recapture







Total Cashflow




0










Cost of Capital/Discount Rate









NPV IRR






$0.00 #NUM!


Price: £ 45

100% Plagiarism Free & Custom Written, Tailored to your instructions

Leave your Comments


Can't read the image? click here to refresh