This spreadsheet is a tool designed to simplify the process of conducting a cost-benefit analysis. It provides a clear framework for weighing the costs and benefits of any project, decision, or investment. The template includes sections for inputting financial data, calculating net benefits, and visualizing the results, helping you make more informed decisions.
Feel free to download and adjust this spreadsheet to suit your needs. It’s flexible and easy to customize.
However, please note:
Disclaimer: While I hope this spreadsheet is helpful, I cannot take responsibility for any changes or outcomes resulting from its use. Please double-check all inputs and calculations to ensure accuracy for your specific situation.
Exercise: Cost-Benefit Analysis of a Road in the Amazon
In this exercise, you will step into the role of an economist tasked with evaluating the impacts of paving 100 kilometers of dirt road in the Amazon rainforest. Using a simplified dataset and spreadsheet, you will calculate the financial net present value (NPV) of the project and then expand the analysis to include social and environmental impacts.
By the end, you’ll gain hands-on experience with:
* Building a financial CBA from basic assumptions
* Applying discounting and NPV in Excel
* Extending the analysis to account for externalities
* Understanding why financial and economic results can diverge
This is a practical, step-by-step exercise designed to illustrate how CBA is applied.