Discounted Cash Flow Analysis on a Design
This plugin downloads a design using the Geodesignhub API, computes its area and construction costs and provides a Discounted Cash Flow analysis to calculate Net Present Value of this design. The core idea of this plugin is to generate the data and then download as a CSV and use in Excel or other programs to do more advanced analysis.
Spatial Analysis Library
In additon to computing the basic financial analysis (Discounted Cash Flow), a spatial anlaysis library is included in this plugin. The library analyzes the location of the diagram and then generates a grid. Once the grid is generated, it allocates the costs and income over that grid. This is useful to visualize how money flows in the design over time and space.
Adding the plugin
The plugin can be added to your project using the Administration panel.
You can adjust the WACC to different settings for a new NPV and cash flow analysis. Generally a value between 5-15 is recommended. Consult a professional to estimate the range.
Once the WACC and the NPV has been calculated, maps are generated that show how the investemnts are distributed in the study area. The Spatial Analysis library distributes the investments over a grid.
In addition to showing the total investment, you can choose to see yearly investments and use the slider to see how over the years, your investment will be distributed.
While the defualt is to show the Cash flow analysis for every system, you can choose to see just specific systems e.g. Transport and Housing and so on.
You can select the “Raw” numbers to get the actual number instead of abbreviated on and then directly use it in Excel. Changing the Raw / Pretty Print button will update the tables and the values.