urban, cost benefit analysis
heemoaa
A2.xlsSheet1
| Cost Benefit Analysis Template | |||||||||||
| Results Calculation Page | |||||||||||
| Fiscal Year | |||||||||||
| 2018 | 2019 | 2020 | 2021 | 2022 | 2023 | 2024 | 2025 | 2026 | 2027 | TOTALS | |
| Undiscounted Flows | |||||||||||
| Costs | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Benefits | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Net Cash Flow | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Discount Factors | |||||||||||
| Discount Rate | 3.0% | ||||||||||
| Base Year | 2018 | ||||||||||
| Year Index | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | |
| Discount Factor | 1.0000 | 0.9709 | 0.9426 | 0.9151 | 0.8885 | 0.8626 | 0.8375 | 0.8131 | 0.7894 | 0.7664 | |
| Discounted Flows | |||||||||||
| Costs | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Benefits | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Net | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Cumulative | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Net Present Value | $0 | ||||||||||
| CostBenefit Ratio | - 0 | ||||||||||
| Internal Rate of Return | 0% | ||||||||||
| INSTRUCTIONS FOR THIS PAGE: | |||||||||||
| 2. Enter your "discount rate" in cell B14; this is the cost of money that determines the time value of your costs and benefits | |||||||||||
| (for illustration, if you were working with an interest-free loan, this would be zero; a typical value is around 8%) | |||||||||||
| 3. Enter the year you will kick off the project in cell B15; this will be used as the "now" in the CBA calculations on future values | |||||||||||
| (typically, "now" means the current year, which is the year of your initial investment, but it might be different if your plans are for the future) | |||||||||||
| INTERPRETATION OF RESULTS: | |||||||||||
| Row 17 shows the discount factor; this is how much less the cash flows are worth because they are in the future | |||||||||||
| Row 19 shows the discounted costs, and Row 20 shows the discounted benefits. "Discounted" means "in year-0 dollars." | |||||||||||
| Row 21 shows the discounted net value per year, and Row 21 shows the accumulated discounted net value per year | |||||||||||
| Row 22 shows the cumulative net value for all years so far (when this becomes positive, you have completed your "payback period") | |||||||||||
| Row 24 shows the "Net Present Value" of your program; this means that the entire project is economically | |||||||||||
| equivalent to this much money in your hands right now, based on the discount rate you entered | |||||||||||
| Row 25 shows the "Cost Benefit Ratio" of your program; this means that the entire project is economically | |||||||||||
| equivalent to this much money in your hands right now, based on the discount rate you entered | |||||||||||
| Row 26 shows the Internal Rate of Return; this means, the interest rate that would make your project exactly break even. | |||||||||||
| Another way to interpret this is, if you had put the money in a bank account at this interest rate, you would get | |||||||||||
| the exact same monetary benefits as you received from performing this program |
Enter your interest rate here; this is your cost of money or other relevant rate.
Enter the current year here, or year that you wish your future perspectives based upon.
Your project is econimically equivalent to this much cash on hand RIGHT NOW.
Your return on invested cash is equivalent to THIS RATE paid by a bank or other instrument.
Sheet2
| BenefitsTOTAL | Jobs | Clean Water | Reduced Property damage | |||
| 2018 | 0 | |||||
| 2019 | 0 | |||||
| 2020 | 0 | |||||
| 2021 | 0 | |||||
| 2022 | 0 | |||||
| 2023 | 0 | |||||
| 2024 | 0 | |||||
| 2025 | 0 | |||||
| 2026 | 0 | |||||
| 2027 | 0 | |||||
| CostsTOTAL | Planning | Permitting | Design | Construction | Maintenance | |
| 2018 | 0 | |||||
| 2019 | 0 | |||||
| 2020 | 0 | |||||
| 2021 | 0 | |||||
| 2022 | 0 | |||||
| 2023 | 0 | |||||
| 2024 | 0 | |||||
| 2025 | 0 | |||||
| 2026 | 0 | |||||
| 2027 | 0 |
