Real Estate Financial Modeling Tools

REFM Self-Study Program – FIU Business – Foundations Module





What it is

A self-study module that can make you more knowledgeable and skilled, improving your in-class performance and competitiveness as a job applicant.

This self-study module gives you:

 Online access to 440+ minutes of easily-navigated video instruction, playable on any device including PC, Mac, phones and tablets

 Accompanying fully-unlocked Excel files, compatible with both PC and Mac

  2 online Certification Exams, which bestow REFM Certification In Excel For Real Estate.

Product Contents

Excel Basics

In this 20-minute video, you will learn about the very basics of Microsoft Excel as a software tool.

Topics covered include:

  • what Excel is, and what versions are in use
  • launching Excel and saving a new file
  • the spreadsheet grid and worksheets
  • basic formatting
  • basic interface navigation using the ribbon tabs
  • saving alternate file versions
  • printing.

Truly Understanding IRR

In this 40-minute video, you will learn about the internal rate of return as it relates to real estate.

Topics covered include:

  • time value of money basics
  • the nature of the IRR calculation
  • why IRRs rise or fall in various transactions
  • how the IRR changes over the transaction timeline
  • what the IRR does and does not tell us.

Truly Understanding Capitalization (Cap) Rates

In this 50-minute video, you will learn all about cap rates.

Topics covered include:

  • what composes a cap rate
  • why cap rates change
  • how to calculate a cap rate
  • how to select a cap rate when valuing a property sale
  • how to understand nuance in cap rate quotes
  • where to find cap rate data.

Excel for Real Estate | Level 1 Bootcamp

This 3-hour video tutorial is the preparatory material for the REFM Excel for Real Estate Level 1 Certification.

Topics covered include (all topics contain exercises and solutions):

  • Arithmetic and Rounding
  • Statistics
  • Relative vs. Absolute Cell References
  • Inserting and Deleting Rows and Columns
  • Dates and Timelines
  • Conditional Statements
  • Function Wizard
  • Creating Summary Tables
  • Formatting Numbers
  • Conditional Cell Formatting
  • Data Table Lookup Functions
  • Custom Formatting
  • Format Painting
  • Paste Special
  • Transpose
  • Financial Functions for Compounding and Discounting
  • Internal Rate of Return (IRR)
  • Mortgage Payment Calculation
  • Formula Auditing
  • Data Tables for Sensitivity Analysis
  • Circular References
  • Keyboard Shortcuts
  • Best Practices

Excel formulas and functions taught include:

  • SUM
  • Cell Anchoring using Dollar Signs
  • IF, AND, OR, and combinations thereof
  • RATE
  • PV, FV
  • NPV and XNPV
  • IRR and XIRR

How Real Estate Developers Price the Dirt

In this 30-minute video, you will learn how developers solve for land value.

Topics covered include:

  • developer control of project variables
  • how land is different from other development costs
  • residual land valuation
  • comparable sales.

Real Estate Finance | Level 2 Bootcamp

This 2-hour video tutorial is the preparatory material for the REFM Excel for Real Estate Level 2 Certification.

Topics covered include (all topics contain exercises and solutions)

  • 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 include:

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

Registration is open for April Excel Bootcamp Webinars Register Now
left to take 50% off with coupon code: yearend50