Transcription of Excel Financial Modelling training@modelre.co.uk …
1 Excel Financial Modelling Contact For real estate applications Our Teaching method allows for beginner real estate professionals to learn the necessary Excel and Modelling skills in context. We cover the basics of Excel to an intermediate level and the necessary Financial mathematics and theory needed to successfully model real estate developments and income producing assets. Our Training can be bespoke or structured. Online or classroom based trainings and 1 to 1 training sessions. We teach 2 separate sessions: 1. real estate development 2. real estate investor/analyst real estate Developer: Structured Training Sessions Over a few classes Our expert sessions cover Excel Modelling applied to real estate over a few evening classes, online sessions or 2 whole day sessions: Part 1: Excel introduction 3.
2 Spreadsheet Modelling best practise 4. Review of Financial mathematics 5. IRR, NPV. 6. Cashflow inputs (rents, yields, growth rates and target returns). 7. Comparing Value, price and worth 8. Yields and return metrics Part 2: Development Course 9. Residual appraisals (with and without interest). 10. Cashflow Modelling (DCF). 11. Sensitivity analysis 12. IRR Analysis (XIRR and MIRR). 13. Development financing, gearing and borrowing 14. Debt, Equity, Mezzanine structures real estate Investor/Analyst: Structured Training Sessions Over a few classes Our expert sessions cover Excel Modelling applied to real estate over a few evening classes, online sessions or 2 whole day sessions: 1. Review of Financial mathematics 2. Conventional Valuation: Term & Reversion, Layer Method, Froth (over rent), Equivalent yield 3.
3 Cash Flow models (DCF). 4. Property finance, gearing and sensitivity analysis 5. Multi let cashflows, rent function, void periods, costs 6. Rent indexation Bespoke Excel Modelling Our trained professionals can provide you with bespoke Excel models and reports, please contact us with your requirements and we can discuss Modelling your data and the time involved. Book a session.
