FIN 615 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!
