0% Complete
0/4 Steps

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

Lesson
Materials

REFM’s Certification in Excel for Real Estate program has existed since 2011, and thousands of certifications have been granted. Certification holders use their REFM credentials to prove their skills and to support their career moves.

A note from instructor Bruce Kirsch, REFAI

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

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

REFM_Level_2_Bootcamp_Excel_v35.1

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