DCFTEMP.XLSVIP

TemplateforDiscountedCashFlowAnalysisfornPotentialStrategiesPage1Note:ThepresentvalueportionofthecalculationsbelowuseExcelsNPVfunction(Insertpull-downmenu,Function,Financial,NPV).Strategy1Companysestimatedcostofcapital(%)InitialcashoutlayforStrategyA,timezero(negative)CashinflowsduetoStrategyA,year1CashoutflowsduetoStrategyA,year1Netcashflow,year1(inflowsminusoutflows)$-CashinflowsduetoStrategy...