REFM Excel For Real Estate Certification Level One

Courses

  • REFM Excel For Real Estate Certification Level One

    Free!

    1 Lessons

    Level 1 Certification tests to ensure that the proper foundations are in place.  The following knowledge and skills areas are tested: Number Formatting Best Practices (Inputs vs. Calculations) Relative vs. Absolute Cell References (Anchoring Notation) Rounding (ROUND, ROUNDDOWN, ROUNDUP) Dates and Timelines (EOMONTH, EDATE) Conditional Statement Formulas (IF, AND, OR) Mortgage Amortization Schedules (PMT, PPMT, IPMT) Summary Tables (SUMIF, COUNTIF) Time Value of Money (PV, FV, RATE, NPV, XNPV, IRR, XIRR) Formula Auditing Lookup Table Functions (HLOOKUP, VLOOKUP) 2-Variable Sensitivity Analysis (Data Tables) Conditional Cell Formatting for Reporting Keyboard Shortcuts

  • REFM Excel For Real Estate Certification Level Two

    Free!

    1 Lessons

    Level 2 Certification tests advanced concepts of real estate finance analysis and advanced use of functions. Topics include: Advanced Time Value of Money Formula-based Interest-Only/Amortizing Payment Switching Re-Financing Maximum Eligible Loan Amount Calculation Residual Land Valuation (Goal Seek) Future Net Operating Income Calculation Multiple Equity Investor Transaction Capital Structuring Modeling Development Transaction Financing Without Circular References  

  • REFM Excel For Real Estate Certification Level Three

    Free!

    1 Lessons

    Level 3 Certification tests the ability to model complex partnerships and waterfall distributions. Rationale behind targeting disproportionate returns to the Sponsor How to achieve disproportionate returns through fees and partitioning of cash flows Preferred Return and its variations (Non-compounded/compounded, non-cumulative/cumulative) Waterfall Distribution Promote Mechanism Look-Back Internal Rate of Return (IRR) Method 3-Tier Waterfall modeling Double-Promote, 5-Tier Waterfall modeling Claw-Back modeling