Video Tutorial:
The value of the model is that it takes cash flows on a monthly basis and you can dynamically change the start/end dates of each project and the right IRR will populate accordingly, no matter what month is chosen to start/end.
There is also a consolidated IRR result.
You will see a comparison chart for IRR vs. required rate of return analysis as well as some approve/reject conditional formatting.
The main inputs include entering the name of each project, how much each project costs and the month it starts, the start/end date of cash flows, and a possible exit cash flow.
| Industry | Financial Model, Investment |
| Summary | A 3-tab based template to easily enter up to 19 deals and see their resulting IRR's. |
| Screenshots / Pictures |
|
| Use Cases | Cash Flow Analysis, Cash Flow Projections, CFO, Consolidation, Dashboard, Excel, Financial Feasibility, Financial Projections, Forecast, Forecasting, Investors, IRR, Management, NPV, ROI |