Preview of Excel for Real Estate Certification Level 2 Bootcamp | Real Estate Finance Course

This course includes:

• Chaptered video totaling 1 hour 48 minutes
• Fully-unlocked Excel file with solution set
• Lifetime access, even on mobile devices
• Access to the online Certification exam, which bestows Level 2 Excel for Real Estate Certification upon passing

Overview

In this approximately 2-hour course, you will learn about the foundations of real estate finance as well as advanced techniques and topics. You will follow along in Excel in real time and perform exercises to ensure you are grasping the lesson and are mastering the technical skills being taught.

Topics Covered Include:

• The Time Value of Money Model
• The Discounted Cash Flow Model
• Net Present Value
• Residential Property Refinancing Feasibility Case Study
• Back of the Envelope Residual Land Valuation of Development Sites
• Acquisition and Development Transaction Capital Structuring
• Senior Construction Loan Mechanics
• Multi-Party Transaction Equity Structures
• Senior and Mezzanine Loan Funding and Repayment Dynamics
• Staggered and Pari Passu Equity Player Funding
• Maximum Refinance Loan Amount Calculation
• Equity Player Profit Sharing Introduction
• Preferred Return, Internal Rate of Return Waterfall and Promote Theory Basics

Excel Formulas and Functions Taught/Employed:

• Compounding and Discounting (FV, PV)
• Net Present Value (NPV)
• Conditional Statements (IF, AND)
• Cumulative Principal (CUMPRINC)
• Minimum (MIN).

Instructions

Download the Excel from the Materials tab above. Then watch the videos, and follow along and perform the exercises in the Excel.

Video Sample

• Time Value of Money Theory Explanation
• Time Value of Money Example
• FV Function Review
• PV Function Review
• Case Study Assumptions
• Investment Cash Outflow
• Base Rent
• Escalations
• Percentage Rent
• Expected Return
• Year-Over-Year Growth
• Cash-On-Cash Return
• Present Value of Cash Flows
• NPV
• Discount Rate Selection
• DCF Exercise
• NPV With Different Discount Rates

Excel File Tabs

The Excel file is 100% unlocked, and you can re-purpose the tabs and comprising code as you desire.

1. TVM Timeline
2. DCF Timeline
3. DCF Exercise
4. DCF Solution
5. Residential Refi 1 – Exercise
6. Residential Refi 1 – Solution
7. Residential Refi 2 – Exercise
8. Residential Refi 2 – Solution
9. Residual Land Valuation Overview
10. Office Industrial Development Back of the Envelope Exercise
11. Office Industrial Development Back of the Envelope Solution
12. Capital Structure 1
13. Capital Structure 2
14. Capital Structure 3
15. Capital Structure 4
16. Senior Construction Loan Overview
17. Equity Exercise
18. Equity Solution
19. Mezzanine Loan Exercise
20. Mezzanine Loan Solution
21. Pari Passu Exercise
22. Pari Passu Solution
23. Maximum Loan Amount Exercise
24. Maximum Loan Amount Solution
25. Profit Sharing
26. Waterfall #1 Graphs
27. Double Promote
28. Waterfall #2 Graphs
29. Keyboard Shortcuts