Net Present Value of Future CashFlows Worksheet All Yellow Highlighted cells are input fields and will pre-fill calculated values DISCOUNT RATE 9% YEAR 0 1 2 3 4 5 6 7 8 9 10 Revenues exclusive to your Plan $- $- $- $- $- $- $- $- $- $- Initial investment in acquisition of equipment, company, or other one-time costs $- Additional Investments in sudsequent years $- $- On-Going Costs (new hires, outside contractors, and other costs incurred each year) $- $- $- $- $- $- $- $- $- $- Cost savings to be gained each year exclusive to your Plan $- $- $- $- $- $- $- $- $- $- 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 $- $- $- $- $- $- $- $- $- $- $- Operating Profit Margin 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% How do i calculate ROI, IRR AND PAYBACK FOR MY STRATEGIC INITIATIVE