FIN 615
NPV and IRR calculations
Cost of Capital1.00%
Time/yr012345
Cash flow Input here
Discounted CF000000
NPV0=cf1/((1+n)^1)=cf2/((1+n)^2)=cf3/((1+n)^3)=cf4/((1+n)^4)=cf5/((1+n)^5)
PV factor0.990099010.9802960490.9705901480.9609803440.951465688
IRR#NUM!
Year
012345
Capital Outlay-30000000
NWC Recovery
Sales
Margin 60% of sales or 40% CGS exp00000
SGA expense 10% of sales00000
Gross Profit00000
Depreciation Expense – Straight Line
Equip $25000000/5
EBT00000
Tax Exp at 35%00000
Net Income00000
Outflow
Cashflow add Depreciation back in00000
NWC Recapture
Total Cashflow0
Cost of Capital/Discount Rate
NPVIRR
$0.00#NUM!