Real Estate Investment & Financial Modelling
Learn how to construct valuation models and discounted cash flow models for single-tenant and multi-tenant buildings. Understand sensitivity analysis to allow you to make better investment decisions. Master real estate finance fundamentals which will enhance your property investment analysis and underwriting processes.
- Overview
- Prices & Dates
- Content
- Participants
- Testimonials
Real Estate Investment & Financial Modelling
Overview
Learn how to construct valuation models and discounted cash flow models for single-tenant and multi-tenant buildings. Understand sensitivity analysis to allow you to make better investment decisions. Master real estate finance fundamentals which will enhance your property investment analysis and underwriting processes.
Pricing
Prices exclude VAT (if applicable) Contact us for Partner discounts. Early Bird Discount when you book & pay at least 30 days in advance.
In Person
Attend the course in person, in Central London.
£1,895
Early Booking
SAVE 10%
Virtual Live
Attend the course, live anywhere in the World.
£1,520
Early Booking
SAVE 10%
On Demand
Instant download of course materials & videos.
£1,216
Lifetime Access
In House
Book this course for your in house team.
Price on request
Dates
Day 1 – Real Estate Financial Modelling in Excel – Income Producing / Multiple Tenancy Property Cash Flow
Multiple tenancy properties
When to accept the project and make investment recommendation
Modelling tenancy schedules and rents forecast
Rent reviews, upward-only, break options, lease expiry
Modelling hypothetical second leases
Void period, rent free and estimated rental values
Time-varying rental growth
Net Operating Income Forecast
OPEX and CAPEX modelling
Modelling capital expenditure for refurbishment and operating costs (letting fees, void costs, empty or business rates)
Investment decision
How to make the optimal investment decision based on IRR, NPV, Profit, Return on Equity (ROE) and Equity Multiple
Day 2 – Real Estate Financial Modelling in Excel – Real Estate Debt Structures and Leveraged Buy-Out Model
Capital Structure, Sources of Debt Finance and Lending Criteria
- Capital structures: debt & equity
- Explanation of different debt & equity structures
- Sources of debt fund & lending criteria
Senior debt repayment modelling
- Interest Only
- Constant Amortisation
- Fully-Amortising Constant Payment
- Partially-Amortising Constant Payment
- Rolled-Up (Capitalised) Interest (Payment in Kind – PIK)
Debt covenants modelling and analysis
Leveraged return analysis based on IRR, NPV and Equity Multiples (MOIC)
Interest Coverage Ratio (ICR), Debt Service Coverage Ratio (DSCR), Loan to Value (LTV), Debt Yield (DY)
What happens when covenants are breached
Cash sweep
Revolving debt facilities
Finding maximum borrowing amount and highest LTV
Dynamic debt modelling using varying debt structures
Entry-level graduates and APC candidates.
Real estate banking and lending analysts, investment surveyors and property consultants