Advanced Real Estate Financial Modelling and Property Valuation Professional Training Course

Module 1: Foundations of Real Estate Finance and Excel Best Practices

ü  Key terminology: Cap Rates, NOI, and Exit Yields

ü  Setting up dynamic Excel environments for real estate

ü  Essential Excel functions for financial analysts

ü  Logical layering and modular model design

ü  Practical Session: Building a basic dynamic property calculator

Module 2: Property Valuation Methodologies and Market Analysis

ü  The Sales Comparison Approach vs. The Cost Approach

ü  Income Capitalization: Direct Cap vs. Yield Cap

ü  Determining appropriate discount rates and terminal cap rates

ü  Analyzing market trends and absorption rates

ü  Practical Session: Conducting a comparative market analysis for a commercial asset

Module 3: Constructing the Pro-Forma: Income and Expense Forecasting

ü  Modelling rental income and vacancy allowances

ü  Operating expenses: Fixed vs. Variable costs

ü  Management fees and capital expenditure (CapEx) reserves

ü  Net Operating Income (NOI) calculation and verification

ü  Practical Session: Constructing a 10-year operating pro-forma in Excel

Module 4: Advanced Discounted Cash Flow (DCF) Modeling

ü  Time value of money (TVM) applications in real estate

ü  Calculating Net Present Value (NPV) for property investments

ü  Handling irregular cash flows and mid-year discounting

ü  Exit value calculations based on forward yields

ü  Practical Session: Creating a full DCF model for a multi-tenant office building

Module 5: Capital Structure: Debt Financing and Amortization

ü  Modelling senior debt: Interest-only vs. Amortizing loans

ü  Loan-to-Value (LTV) and Debt Service Coverage Ratio (DSCR)

ü  Impact of leverage on equity returns

ü  Refinancing scenarios and exit debt repayment

ü  Practical Session: Integrating a flexible debt schedule into an investment model

Module 6: Investment Performance Metrics and IRR Analysis

ü  Internal Rate of Return (IRR) vs. Modified IRR (MIRR)

ü  Equity Multiples and Cash-on-Cash returns

ü  Benchmarking returns against market hurdles

ü  Time-weighted vs. Money-weighted returns

ü  Practical Session: Calculating and interpreting return hurdles for a residential project

Module 7: Joint Venture (JV) Structures and Equity Waterfalls

ü  Understanding GP and LP equity contributions

ü  Modelling preferred returns and promote structures

ü  Catch-up clauses and tiered hurdle rates

ü  Clawback provisions and distribution logic

ü  Practical Session: Building a 3-tier equity waterfall model

Module 8: Sensitivity Analysis and Risk Management in Modelling

ü  Using Data Tables for multi-variable sensitivity

ü  Scenario Manager for "Best-Case" and "Worst-Case" analysis

ü  Identifying "Breakeven" rent and occupancy levels

ü  Monte Carlo simulation concepts for real estate

ü  Practical Session: Stress-testing a model against interest rate hikes and vacancy spikes

Module 9: Development Modelling: Construction and Phasing Analysis

ü  Modelling land acquisition and pre-development costs

ü  Construction "S-Curve" and draw schedules

ü  Financing development: Interest capitalization during construction

ü  Phased sales and absorption modeling

ü  Practical Session: Developing a master-phasing schedule for a mixed-use project

Module 10: Portfolio Analysis and Executive Reporting

ü  Aggregating individual assets into a portfolio model

ü  Diversification and correlation analysis

ü  Creating professional dashboards and charts

ü  Presenting the investment narrative to stakeholders

ü  Practical Session: Designing an executive investment summary dashboard

About Our Trainers

Our trainers are distinguished financial consultants and real estate investment experts with over 15 years of experience in global property markets. They have successfully advised on multi-million dollar transactions and possess advanced certifications in financial modeling and RICS-standard valuations. Their teaching philosophy combines high-level technical precision with practical insights gained from real-world deal-making.

Quality Statement

Phoenix Center for Policy, Research and Training is committed to technical excellence. Our courses are NITA-approved and developed in accordance with international financial reporting standards (IFRS) and RICS valuation guidelines. We ensure that our modeling templates are "audit-ready" and reflect the latest industry best practices for transparency and accuracy.

Tailor-Made Courses

We understand that every organization has unique challenges and opportunities as well as unique training needs. Phoenix Training Center offers tailor-made courses designed to address specific requirements and challenges faced by your team or organization. Whether you need a customized curriculum, a specific duration, or on-site delivery, we can adapt our expertise to provide a training solution that perfectly aligns with your objectives. We can customize this Course to focus on your industry, specific risk profile, or internal stakeholder dynamics. Contact us to discuss how we can create a bespoke training program that maximizes value and impact for your team. For further inquiries, please contact us on Tel: +254720272325 / +254737296202 or Email training@phoenixtrainingcenter.com

Admission Criteria

ü  Participants should be reasonably proficient in English. 

ü  Applicants must live up to Phoenix Center for Policy, Research and Training admission criteria.

Terms and Conditions

ü  Discounts: Organizations sponsoring Four Participants will have the 5th attend Free

ü  What is catered for by the Course Fees: Fees cater for all requirements for the training – Learning materials, Lunches, Teas, Snacks and Certification. All participants will additionally cater for their travel and accommodation expenses, visa application, insurance, and other personal expenses.

ü  Certificate Awarded: Participants are awarded Certificates of Participation at the end of the training.

ü  The program content shown here is for guidance purposes only. Our continuous course improvement process may lead to changes in topics and course structure.

ü  Approval of Course: Our Programs are NITA Approved. Participating organizations can therefore claim reimbursement on fees paid in accordance with NITA Rules.

Booking for Training

Simply send an email to the Training Officer on training@phoenixtrainingcenter.com and we will send you a registration form. We advise you to book early to avoid missing a seat to this training. Or call us on +254720272325 / +254737296202

Payment Options

We provide 3 payment options, choose one for your convenience, and kindly make payments at least 5 days before the Training start date to reserve your seat:

ü  Groups of 5 People and Above – Cheque Payments to: Phoenix Center for Policy, Research and Training Limited should be paid in advance, 5 days to the training.

ü  Invoice: We can send a bill directly to you or your company.

ü  Deposit directly into Bank Account (Account details provided upon request)

Cancellation Policy

ü  Payment for all courses includes a registration fee, which is non-refundable, and equals 15% of the total sum of the course fee.

ü  Participants may cancel attendance 14 days or more prior to the training commencement date.

ü  No refunds will be made 14 days or less before the training commencement date. However, participants who are unable to attend may opt to attend a similar training course at a later date or send a substitute participant provided the participation criteria have been met.

Accommodation and Airport Transfer

For physical training attendees, we can assist with recommendations for accommodation near the training venue. Airport pick-up services can also be arranged upon request to ensure a smooth arrival. Please inform us of your travel details in advance if you require these services. For reservations contact the Training Officer on Email: training@phoenixtrainingcenter.com or on Tel: +254720272325 / +254737296202