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 $100,000,000 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 $250,000 $240,000 $230,000 $220,000 $210,000 $200,000 $190,000 $180,000 $170,000 $180,000 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 $100,000,000 $(250,000) $(240,000) $(230,000) $(220,000) $(210,000) $(200,000) $(190,000) $(180,000) $(170,000) $(180,000) Operating Profit Margin 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% what does this cost benefit analysis worksheet explain