Video Tutorial:
This financial model is to be used after annual cash contributions and distributions are known and they are to be plugged in as the primary data input to this template.
There are two tabs. The first displays a resulting DCF analysis based on up to 6 different discount rates. The results are in the form of a table with conditional formatting for positive and negative NPV (net present values) and a corresponding bar chart with 3D formatting. The IRR (internal rate of return) is also displayed.
The second tab allows the user to enter up to 4 different cash flow scenarios. This could be for 4 different possible scenarios with the same project or it could be 4 completely different projects that need to be measured against each other at the same time. The output sensitivity table for this tab will display up to 24 different NPV results with color formatting when the values are +/- 0. Additionally, there is a scatter plot chart that displays the resulting NPV at each discount rate for each of the 4 cash flow scenarios. The IRR is also displayed for each scenario (bar chart and text table).
