Project Finance and Excel - Build Financial Models from Scratch - Return Metrics and Conclusion

The video tutorial guides viewers through the process of computing the Internal Rate of Return (IRR) using Excel. It begins with setting up a spreadsheet to calculate project IRR, followed by detailing cash flow calculations. The focus then shifts to equity IRR from an investor's perspective, highlighting the importance of dividends and returns. The tutorial demonstrates how to adjust the heavy vehicle tariff to achieve a target IRR of 23%. It concludes by summarizing the financial model's construction and its application across various industries.

What new insight or understanding did you gain from this video?

Evaluate responses using AI:

OFF