📈 Advanced Real Estate Investment Analysis Course: Financial Modelling and Due Diligence

Module 1: Foundations of Real Estate Investment Analysis

ü  Overview of the real estate investment process

ü  Key drivers of property value (Location, Timing, Leverage)

ü  The role of real estate in diversified investment portfolios

ü  Understanding different property sectors (core, value-add, opportunistic)

ü  Defining the scope and objectives of real estate investment analysis course

ü  Practical Session: Reviewing a Sample Investment Case Study and Identifying Key Risks

 

Module 2: Time Value of Money and Investment Metrics

ü  Review of Net Present Value (NPV) and Internal Rate of Return (IRR)

ü  Equity Multiple, Cash-on-Cash Return, and Return on Cost

ü  Terminal Value and Capitalization Rate (Cap Rate) methods

ü  Calculating the discount rate and required rate of return

ü  Pitfalls and limitations of common investment metrics

ü  Practical Session: Calculating and Interpreting IRR and NPV using Excel Functions

 

Module 3: Advanced Operating Cash Flow Modeling (NOI)

ü  Building the Annual Cash Flow Waterfall from Gross Potential Rent

ü  Accounting for Vacancy, Credit Loss, and Concessions

ü  Detailed Operating Expense budgeting and modeling (Fixed vs. Variable)

ü  Analyzing and projecting Net Operating Income (NOI)

ü  Above-the-line and Below-the-line expenses

ü  Practical Session: Structuring an NOI Model and Projecting Property Income

 

Module 4: Discounted Cash Flow (DCF) Analysis Mastery

ü  Constructing the full 10-year investment horizon model

ü  Modeling capital expenditures (CapEx) and reserves

ü  Calculating Reversion (Sale) proceeds and Exit Cap Rate determination

ü  Discounting future cash flows to arrive at present value

ü  Incorporating financing costs (Debt Service) into the model

ü  Practical Session: Practical Session: Integrating NOI and Reversion into a Multi-Period DCF Model

 

Module 5: Equity Valuation and Partnership Structures

ü  Joint Venture (JV) structures and waterfall mechanics

ü  Modeling Preferred Return, Promote, and Carried Interest

ü  Equity Multiple and Return on Equity calculations

ü  Analyzing different equity stack compositions

ü  Structuring partnership agreements and governance

ü  Practical Session: Building a Partnership Waterfall Model (Modeling the Promote)

 

Module 6: Debt Structuring and Financial Leverage

ü  Types of commercial real estate debt (Senior, Mezzanine, Construction)

ü  Modeling Amortization, Interest-Only, and Balloon Payments

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

ü  Understanding Covenants and Default Provisions

ü  The impact of leverage on equity returns (positive and negative)

ü  Practical Session: Modeling Different Loan Scenarios and Sensitivity to Interest Rates

 

Module 7: Market, Submarket, and Economic Analysis

ü  Key indicators for market selection (e.g., population growth, employment)

ü  Supply and Demand analysis (Vacancy, Absorption, New Construction)

ü  Analyzing macroeconomic trends and their impact on property performance

ü  Conducting competitive analysis and SWOT for a submarket

ü  Utilizing demographic and zoning data

ü  Practical Session: Conducting a Competitive Set Analysis and Defining Market Rents

 

Module 8: Analyzing Multifamily and Residential Investments

ü  Unit-by-unit rent roll analysis and underwriting

ü  Modeling lease expiration and tenant turnover risk

ü  Capital improvement and value-add strategies

ü  Analyzing operating efficiencies specific to multifamily (e.g., utility costs)

ü  Affordable housing models and government subsidies

ü  Practical Session: Modeling a Value-Add Renovation Strategy for a Multifamily Property

 

Module 9: Analyzing Office and Retail Property Investments

ü  Lease analysis (Gross vs. Triple Net) and expense pass-throughs

ü  Modeling tenant improvements (TIs) and leasing commissions (LCs)

ü  Anchor tenant risk and co-tenancy clauses in retail

ü  Analyzing tenant credit and weighted average lease term (WALT)

ü  Trends in commercial space utilization and flexible workspace

ü  Practical Session: Underwriting a Commercial Lease and TI/LC Budget

 

Module 10: Industrial, Hospitality, and Specialized Assets

ü  Analyzing industrial properties (Logistics, Warehouse, Cold Storage)

ü  Hospitality investment analysis (Revenue Per Available Room - RevPAR)

ü  Specialized asset classes (Data Centers, Medical Office Buildings)

ü  Key operational metrics specific to each asset class

ü  Risk factors and investment horizon for specialized assets

ü  Practical Session: Modeling a Simple Hospitality Proforma (Focusing on Revenue Management)

 

Module 11: Real Estate Development Financial Modeling

ü  Modeling construction costs, soft costs, and contingency

ü  Phasing and timing of construction and lease-up period

ü  Calculating the Development Yield and Profit Margin

ü  Construction loan draw schedules and interest reserve

ü  Analyzing the feasibility of ground-up development vs. acquisition

ü  Practical Session: Building a Development Model and Calculating Profit Metrics

 

Module 12: Tax, Legal, and Regulatory Considerations

ü  Depreciation and tax shields in real estate

ü  Understanding property taxes and assessments

ü  Capital Gains tax on disposition and 1031 Exchange mechanics

ü  Zoning laws, entitlements, and land use regulations

ü  Environmental liability and compliance issues

ü  Practical Session: Calculating the After-Tax Cash Flow from Property Sale

 

Module 13: Due Diligence and Transaction Management

ü  Establishing a comprehensive due diligence checklist

ü  Reviewing legal documents (Title, Surveys, Leases)

ü  Coordinating technical, environmental, and engineering reports

ü  Closing process and settlement statement review

ü  Post-acquisition integration and management transition

ü  Practical Session: Identifying Red Flags in Due Diligence Reports

 

Module 14: Risk Analysis and Sensitivity Testing

ü  Identifying key variables for risk modeling (Rent, Cap Rate, Vacancy)

ü  Performing sensitivity analysis on investment metrics (IRR, NPV)

ü  Scenario planning (Worst Case, Base Case, Best Case)

ü  Introduction to Monte Carlo simulation for advanced risk modeling

ü  Mitigating downside risk through contract and financial structuring

ü  Practical Session: Conducting a 3-Scenario Sensitivity Analysis in Excel

 

Module 15: Exit Strategy and Property Disposition Modeling

ü  Timing the sale of a property for maximum returns

ü  Strategies for maximizing the Exit Cap Rate

ü  Modeling different disposition methods (Single Sale vs. Portfolio Sale)

ü  Calculating net sale proceeds after taxes, fees, and debt payoff

ü  Market conditions influence on exit valuation

ü  Practical Session: Comparing Hold vs. Sell Scenarios using Financial Metrics

 

Module 16: Real Estate Portfolio and Asset Management

ü  Portfolio diversification and risk aggregation

ü  Asset management strategies to maximize NOI

ü  Portfolio-level performance measurement and benchmarking

ü  Refinancing strategies and their impact on portfolio IRR

ü  Strategic capital allocation across property types and geographies

ü  Practical Session: Analyzing the Performance and Risk of a Multi-Property Portfolio

 

Module 17: Valuation Techniques (Sales Comp, Cost, Income)

ü  In-depth application of the Sales Comparison Approach

ü  Utilizing the Cost Approach for special-use properties

ü  Applying the Income Capitalization Approach (Direct Cap and DCF)

ü  Reconciling valuation estimates from different approaches

ü  Appraisal review and understanding valuation biases

ü  Practical Session: Performing a Simple Valuation using All Three Approaches

 

Module 18: Preparing the Institutional Investment Memorandum

ü  Structuring the Investment Memo (Executive Summary, Market, Financials)

ü  Best practices for visual data presentation (charts, tables)

ü  Presenting the investment thesis and mitigating risks

ü  Packaging the financial model and supporting documentation

ü  Delivering an effective investment pitch

ü  Practical Session: Final Group Project: Drafting and Presenting an Investment Memorandum

About Our Trainers

 

Our trainers are seasoned real estate investment professionals with a minimum of 10 years of experience in acquisitions, financial modeling, and fund management at top-tier investment firms, private equity funds, or major institutional lenders. They possess advanced certifications (e.g., CFA, CAIA, CPA) and have directly executed significant commercial real estate transactions across multiple property types. Their deep expertise ensures that this real estate investment analysis course provides practical, institutional-grade training.

 

Quality Statement

 

Phoenix Training Center is committed to delivering a superior real estate investment analysis course experience. We guarantee that our curriculum is up-to-date with current market practices, advanced financial modeling techniques, and prevailing regulatory environments. Our focus on intensive, hands-on Excel modeling ensures that participants acquire immediately valuable, career-enhancing technical skills.

 

Tailor-Made Courses

 

We offer customized real estate investment analysis course solutions tailored to your organization's specific needs, such as focusing exclusively on a particular property type (e.g., industrial logistics or student housing), a specific geographic market's regulations, or advanced topics like distressed asset analysis. We can adjust the duration, content, and case studies to match your team’s prior expertise and investment strategy, providing a highly efficient private training program. 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