DQ 7

profilelanitgmzlian71
Cost-BenefitAnalysisWorksheetWeek7DQ_1206.xlsx
Home>Business & Finance homework help>Management homework help>DQ 7

ROI

Net Present Value of Future CashFlows Worksheet
Discount Rate
9.0%
NOMINAL CASH FLOW DISCOUNTED CASH FLOW
YEAR ANNUAL CUMULATIVE PAYBACK DISC RATE DISC CASH FLOW CUM DISC CF PAYBACK
0 $ - 0 $ - 0 1.00 $ - 0 $ - 0
1 $ - 0 $ - 0 ERROR:#DIV/0! 0.917 $ - 0 $ - 0 ERROR:#DIV/0!
2 $ - 0 $ - 0 ERROR:#DIV/0! 0.842 $ - 0 $ - 0 ERROR:#DIV/0!
3 $ - 0 $ - 0 ERROR:#DIV/0! 0.772 $ - 0 $ - 0 ERROR:#DIV/0!
4 $ - 0 $ - 0 ERROR:#DIV/0! 0.708 $ - 0 $ - 0 ERROR:#DIV/0!
5 $ - 0 $ - 0 ERROR:#DIV/0! 0.650 $ - 0 $ - 0 ERROR:#DIV/0!
6 $ - 0 $ - 0 ERROR:#DIV/0! 0.596 $ - 0 $ - 0 ERROR:#DIV/0!
7 $ - 0 $ - 0 ERROR:#DIV/0! 0.547 $ - 0 $ - 0 ERROR:#DIV/0!
8 $ - 0 $ - 0 ERROR:#DIV/0! 0.502 $ - 0 $ - 0 ERROR:#DIV/0!
9 $ - 0 $ - 0 ERROR:#DIV/0! 0.460 $ - 0 $ - 0 ERROR:#DIV/0!
10 $ - 0 $ - 0 ERROR:#DIV/0! 0.422 $ - 0 $ - 0 ERROR:#DIV/0!
ERROR:#DIV/0! ERROR:#DIV/0!
NPV $0.00
IRR ERROR:#NUM!
Return on Investment (ROI) ERROR:#DIV/0!

Forecasts

Net Present Value of Future CashFlows Worksheet
All Yellow Highlighted cells are input fields and will pre-fill calculated values
YEAR
0 1 2 3 4 5 6 7 8 9 10
Revenues exclusive to your Plan $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Initial investment in acquisition of equipment, company, or other one-time costs $ - 0
On-Going Costs (new hires, outside contractors, and other costs incurred each year) $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Cost savings to be gained each year exclusive to your Plan $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Company average or industry net profit margin 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0%
ANNUAL NOMINAL CASH FLOWS $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0