Financial modeling certificate(1/2)
Questions and Answers 100% Pass
What makes learning to model real estate assets challenging? - ✔✔Industry limitations
to "one size fits all" modeling • Different players interact with real estate financial
models in different ways
Financial models are key to many real estate functions - ✔✔Such as:
Private Equity
Brokers
Lenders
Operators
Asset Managers
Property Management
Formatting and Layout - ✔✔Always assume the model will be used by someone else •
Be predictable •
Create "plug-and-play" models to increase efficiency
Katelyn Whitman, All Rights Reserved © 2025 1
,Color Coding - ✔✔Hard-coded numbers (inputs) =1234 Blue
Formulas (calculations) =A1*A2 Black
Links to other worksheets =Sheet2!A1 Green
Dates and Timelines - ✔✔-Real estate models are heavily reliant upon dynamic dates
and timelines
-EOMONTH(start_date, months) used for calculations with dates
-Time is often used as an input with custom formatting
-Built on monthly cash flows that are later summarized annually
Rules of Thumb - ✔✔Avoid unnecessarily long formulas
Avoid merging cells, center across selection instead
Avoid naming cells and ranges
Only use decimals for cap rates, yields, IRRs, and multiples
• Use cell comments to cite assumptions
Modeling Best Practices Key Takeaways - ✔✔Formatting is important •
General modeling best practices translate to real estate modeling •
Reliance on dates and timelines make real estate models unique
Three Main Sheets - ✔✔-Inputs & Drivers
Katelyn Whitman, All Rights Reserved © 2025 2
, -Model
-Transaction Summary
Inputs & Drivers - ✔✔Property overview
• Timing assumptions
• Purchase price
• Sale price
• Revenue drivers
• Expense drivers
• Capital expenditures
Model - ✔✔• Occupancy
• Revenues
• Operating expenses
• Non-operating expenses
• Purchase and sale
• Financing
• JV waterfall
Katelyn Whitman, All Rights Reserved © 2025 3
Questions and Answers 100% Pass
What makes learning to model real estate assets challenging? - ✔✔Industry limitations
to "one size fits all" modeling • Different players interact with real estate financial
models in different ways
Financial models are key to many real estate functions - ✔✔Such as:
Private Equity
Brokers
Lenders
Operators
Asset Managers
Property Management
Formatting and Layout - ✔✔Always assume the model will be used by someone else •
Be predictable •
Create "plug-and-play" models to increase efficiency
Katelyn Whitman, All Rights Reserved © 2025 1
,Color Coding - ✔✔Hard-coded numbers (inputs) =1234 Blue
Formulas (calculations) =A1*A2 Black
Links to other worksheets =Sheet2!A1 Green
Dates and Timelines - ✔✔-Real estate models are heavily reliant upon dynamic dates
and timelines
-EOMONTH(start_date, months) used for calculations with dates
-Time is often used as an input with custom formatting
-Built on monthly cash flows that are later summarized annually
Rules of Thumb - ✔✔Avoid unnecessarily long formulas
Avoid merging cells, center across selection instead
Avoid naming cells and ranges
Only use decimals for cap rates, yields, IRRs, and multiples
• Use cell comments to cite assumptions
Modeling Best Practices Key Takeaways - ✔✔Formatting is important •
General modeling best practices translate to real estate modeling •
Reliance on dates and timelines make real estate models unique
Three Main Sheets - ✔✔-Inputs & Drivers
Katelyn Whitman, All Rights Reserved © 2025 2
, -Model
-Transaction Summary
Inputs & Drivers - ✔✔Property overview
• Timing assumptions
• Purchase price
• Sale price
• Revenue drivers
• Expense drivers
• Capital expenditures
Model - ✔✔• Occupancy
• Revenues
• Operating expenses
• Non-operating expenses
• Purchase and sale
• Financing
• JV waterfall
Katelyn Whitman, All Rights Reserved © 2025 3
