What you'll learn
Learn how to build an institutional Commercial (office) Real Estate Model from scratch.
Learn Real Estate Financial Modelling best practices.
Learn most used and common formulas in Excel.
Understand in depth the 3 types of cash flows (Investment Cash Flow/Operating Cash Flow/ Financing Cash Flow) in a Real Estate Financial Model.
Requirements
For all levels. However, basic Real Estate knowledge is recommended.
Description
This course is based on the following Case Study:BackgroundAs an investor at Udemy Capital specializing in office building developments, you are planning to purchase a land plot to develop a modern, build-to-suit office building for a major tenant who is willing to sign a 10-year lease (with no break options) for their headquarters. As part of Udemy Capital's underwriting process you need to model the following assumptions on a monthly cash flow basis. If you think, that some of these assumptions may not make sense or could be more accurate, feel free to change them as long as you justify it properly.Land & Acquisition CostsLocation: Barcelona's Prime Office AreaPurchase of the Land on 01 January 2025Land Purchase Price: to be determined by a minimum Levered IRR (LIRR) of 15% and an Equity Multiple (EM) of at least 1.80xBuildability: 10,000 sqmReal Estate Transfer Tax: 10% over Land Purchase PriceNotary & Registry: 0.25% over Land Purchase PriceBuy-Side Brokerage Fee: 1.50% over Land Purchase PriceDue Diligence: 75,000€DevelopmentProject: 10,000 sqmConstruction Period: 18 months starting in Month 1Hard Costs: 1,800 €/sqmSoft Costs: 15% over Hard CostsContingency: 5% over Hard + Soft CostsLeasing Costs: 1 month of RentTenant Improvements: 23.50 €/sqm to be paid out for 2 months and starting the first month of rentOperationsGross Leasable Area (GLA): 10,000 sqmRent: 23.50 €/sqmYearly Rental Bump: 2.50% on each lease anniversaryFree Rent: 5 months of rentOperating Expenses (Opex): 15% over Gross Rental IncomeNon-Recoverable Expenses: 10% of OpexBuilding Capex Maintenance: 5% over Gross Rental IncomeExit / SaleHolding Period: 5 yearsExit Cap Rate: 4.25%Selling Costs: 1.50% over Sales ProceedsAcquisition LoanNone, land will be acquired with EquityDevelopment LoanLoan to Cost (LTC): 60%Arrangement Fee: 1.00% over Loan ProceedsEquity First StructureAll-in interest rate: 5.50%Repayment: bullet at RefinanceRefinance LoanRefinance Month: at stabilization after TIs and Free Rent PeriodsArrangement Fee: 1.00% over Loan ProceedsLTV: 55% of value at refinanceCap Rate at Refinance: 4.75%All-in interest rate: 4.50%Amortization: French amortization scheduleLoan Term: 15 yearsOutputsIn order for your Investment Committee to consider this deal you will need to show:Annual Cash Flow TabLand Purchase PriceLevered IRREquity MultipleProfitEquity PeakSensitivity Tables- Rent and Hard Cost- Land Purchase Price and Exit Cap Rate
Who this course is for
College students or career switchers who want to break into the Real Estate Investment Industry and work for companies such as real estate funds, family offices, consulting firms, investment banks, etc.
Current real estate professionals who want to boost their financial modelling skills.
Current real estate investors who want to feel confident in modelling their own deals.
Job applicants that have a Real Estate Financial Modeling test coming up.
Homepage

https://www.udemy.com/course/real-estate-financial-development-modeling-course/