Real Estate Financial Modeling Tools

REFM University Curriculum Supplement Program – University of Miami MRED+U

$0.00

SKU: SKU-846 Category:

Description

Welcome 2019-2020 MRED+U Cohort!

What You Get

  • Lifetime access to more than 4 hours of streaming video instruction
  • Lifetime access to fully-unlocked Excel module files
  • 2 online Completion Certification Exams, which bestow REFM Certification In Excel For Real Estate

Content Descriptions

Excel for Real Estate | Level 1 Bootcamp

This training module is an interactive video tutorial that teaches the basics of operating in Excel, as well as advanced techniques, specifically as they relate to real estate analysis.  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.

This product is the preparatory material for the REFM Excel for Real Estate Level 1 Certification.

This module includes the following items, which never expire:

 Online access to an easily navigated 3-hour video tutorial, playable on any device including PC, Mac, phones and tablets

SelfStudy750pxwide

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

Topics Covered (All topics include 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

  • SUM
  • ROUND, ROUNDUP, ROUNDDOWN
  • MAX, MIN, AVERAGE, MEDIAN
  • Cell Anchoring using Dollar Signs
  • EOMONTH, EDATE
  • IF, AND, OR, and combinations thereof
  • SUMIF, SUMIFS
  • COUNTIF, COUNTIFS
  • VLOOKUP, HLOOKUP
  • COLUMNS, ROWS
  • IFERROR
  • RATE
  • PV, FV
  • NPV and XNPV
  • IRR and XIRR
  • PMT, PPMT, IPMT
  • CUMPRINC and CUMIPMT.

Real Estate Finance | Level 2 Bootcamp

An interactive Video Tutorial that teaches you 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.

This product is the REFM Excel for Real Estate Level 2 Certification Preparatory Material.

Product includes the following items, which never expire:

 Online access to an easily navigated 80-minute Video Tutorial, playable on any device including PC, Mac, phones and tablets

SelfStudy750pxwide

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

Topics Covered

  • The Time Value of Money Model (includes Exercise #1)
  • The Discounted Cash Flow Model (includes Exercise #2)
  • Internal Rate of Return (IRR)
  • Mortgage Payment Calculation
  • Refinancing/Interest-Only Scenario Payment Calculation (includes Exercise #3)
  • Refinancing Case Study
  • Maximum Loan Amount Calculation (for income-producing property acquisition)
  • Residual Land Valuation (includes Exercise #4)
  • Future Net Operating Income Calculation
  • Transaction Capital Structures
  • Financing Development Transactions
  • Multiple Equity Investors Discussion (includes Exercise #5)
  • Profit Sharing Discussion
  • Preferred Return, Internal Rate of Return Waterfall and Promote theory

Excel Formulas and Functions Taught

  • Compounding and Discounting
  • Net Present Value (NPV) and XNPV
  • Internal Rate of Return (IRR) and XIRR
  • Conditional Statements
  • Mortgage Payment (PMT)
  • Principal Payment (PPMT)
  • Interest Payment (IPMT)
  • Minimum (MIN)
  • Maximum (MAX).

Don't Miss Our Live Webinar: Gain An Edge With REFAI Certification | Tue. 9/17 at 3PM ET REGISTER
left to take 50% off with coupon code: yearend50