In this hands-on workshop, you'll delve into the mastery of data analysis, constructing interactive dashboards that transform complexity into clarity. From crafting project calculators and equity returns, you'll emerge with a toolkit of financial prowess. But that's not all – gain insights into the nuances of IRR and uncover its limitations. Get ready to elevate your financial acumen and Modelling Multiple Tranches of Debtbring your projects to life with numbers that not only make sense but also make an impact!
- Gain in-depth insights into the principles of data analysis
- Explore effective design principles for creating and presenting data in a visually compelling manner.
- Learn advanced techniques for analysing Excel data using various functions.
- Hands-on experience in building interactive dashboard reports, incorporating features like buttons and drop-down menus for enhanced user interactivity.
- Setting-up the Model
- Understanding Construction Costs and Financing
- Modelling Multiple Tranches of Debt
- Modelling Debt to a Target DSCR
- Calculating Project and Equity Returns
- Limitations of IRR (XIRR, MIRR)