REFM Corporate Skills Supplement Program

REFM Corporate Skills Supplement Program

REFM_CSSP_230px_r1

Overview

Employers are faced with a monumental task in getting employees on par with one another in the principles and practices of real estate, finance, and financial modeling hard skills.

In many cases, employees have little or no real estate or finance knowledge base, nor any of the Excel-based financial modeling skills that are so valuable to employers. As time during the workday is severely limited, the thorough hands-on teaching of hard financial modeling skills cannot always be accommodated beyond a once-yearly training session.

Since 2009, REFM has performed corporate trainings for some of the most highly-regarded real estate organizations.

REFM’s Corporate Skills Supplement Program assists further by teaching financial modeling through self-study and online testing, which enrich employee knowledge and further promote employee development.

Program Materials

Program Materials

  • Over 16 hours of detailed online video instruction across 13 content modules
  • 13 accompanying unlocked Excel files with hands-on exercises and documented solutions
  • 3 online Completion Certification exams, which bestow REFM Certification In Excel For Real Estate

Authorship

Authorship

The Corporate Skills Supplement Program’s training and testing content is created by REFM founder Bruce Kirsch, who is an Editor of the Third Edition of Real Estate Finance and Investments: Risks and Opportunities by The Wharton School’s Emeritus Professor of Real Estate, Dr. Peter Linneman. Mr. Kirsch has been creating self-study financial modeling training modules for executives since 2009, and he personally trains executives at some of the world’s largest institutional real estate investors.

Mr. Kirsch was previously a three-time Adjunct Faculty member in Real Estate at Georgetown University. He holds an MBA in Real Estate from The Wharton School, where he received a scholarship for academic excellence in real estate, and he holds a BA in Communication from Stanford University. Prior to founding REFM, Mr. Kirsch worked in analytical roles for two top real estate platforms and a global fund manager.

Training Goals and Format

Training Goals

The goals of the program are to:

  • Improve employee Excel-based problem-solving and analysis skills, resulting in quicker work turnaround and fewer mistakes
  • Enable stronger employee performance on projects, assignments, and in interviews
  • Increase employee confidence in advanced sensitivity analysis abilities
  • Improve employee financial modeling knowledge, understanding and customization capabilities
  • Sharpen employee presentation of transaction financials

Format

The teaching and learning are intended to be a supplement to, not a replacement of, existing corporate training programs. Engaging in the work is to occur on the employee’s own time, at their own pace, outside of class.

REFM recognizes that there can never be a substitute for constructing financial models from scratch, and recommends that all employees replicate as many of the program models as they can starting from a blank spreadsheet.

The minimum suggested engagement level for employees is as follows:

  • Employee accesses program content via a company-branded portal webpage
  • Employee plays video-based tutorials (sample below) on their computer, following along in the accompanying unlocked Excel file
  • Employee performs hands-on exercises in the Excel file, and reviews solutions
  • Employee takes Completion Confirmation exams online on their own schedule.

 

Program Body of Knowledge and Video Tutorial Module Samples

Body of Knowledge

The program body of knowledge comprises how to apply Excel functions, construct formulas, and build and operate advanced transaction and joint venture partnership financial projection models. The program also includes three online Completion Confirmation tests that employees may take at any time.

Detailed module descriptions are found at left. The three main categories of content are:

  • Excel and real estate finance modeling foundations
  • Modeling development and acquisition transactions
  • Modeling joint ventures and private equity funds

Click here to launch an interactive content module chart

Topics for any additional in-person on-campus training can comprise these same topics, or other topics in the REFM library of content. In-person on-campus training is a separate, additional charge.

Excel Basics

This module is for those with little or no prior exposure to Microsoft Excel. 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

Excel for Real Estate Bootcamp (Level 1 Certification)

This module teaches the basics of operating in Excel, as well as advanced techniques, specifically as they relate to real estate analysis. All topics include exercises. Topics covered include:

  • 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

Truly Understanding Internal Rate of Return (IRR)

In this module, employees will come to truly understand the nature of the IRR calculation and see why it reacts the way it does in the various acquisition and development cases that are presented in spreadsheet form. Topics covered include:

  • Time value of money crash course: Present Value, Future Value and Net Present Value
  • The nature of the IRR calculation, and how the IRR value changes during a transaction
  • Equivalent Annual IRR rates for quarterly-, monthly-, and daily-based IRR calculations
  • Why a monthly-based IRR is more accurate than an annual-based IRR
  • Relationship between the IRR and the Equity Multiple
  • What IRR tells us, and what it doesn’t tell us
  • IRR for acquisitions and development examples

Excel functions taught include:

  • PV – Present Value
  • FV – Future Value
  • NPV – Net Present Value
  • IRR – Internal Rate of Return
  • XNPV – NPV for non-periodic cash flows with known dates
  • XIRR – IRR for non-periodic cash flows with known dates

Truly Understanding Capitalization (Cap) Rates

In this module, employees learn the answers to the following questions:

  • What is a capitalization (cap) rate?
  • What composes a cap rate?
  • Why do cap rates change?
  • How do you calculate a cap rate?
  • How do you select one when performing a property valuation?
  • What should you think when people quote cap rates verbally?
  • Where can I find cap rates for a certain property in a certain geography?

Residual Land Valuation

In this module, employee learn the answers the question: how does a real estate developer know what to pay for a piece of developable land?

Employees will learn the basics of real estate development residual land valuation for both income-producing assets and unit sales assets, as well as the principles of valuation through comparable sales (comps).

Topics covered include

Residual Land Valuation Basics:

  • Allowable Building Density/FAR
  • Ground-Floor Retail Square Footage
  • Primary Building Use Gross and Net Square Footages
  • Calculation of Building Parking Requirements
  • Development Cost Excluding Land
  • Sources of Funds For Development

Specific To Income-Producing Assets (Office/Industrial/Retail, or Apartments):

  • Stabilized Net Operating Income From Primary Use and Parking
  • Future Stabilized Yield On Cost
  • Solving for Residual Land Value

Specific To Unit Sales Assets (Condominiums or Housing Subdivisions):

  • Net Sales Proceeds From Housing Units, Parking & Storage
  • Gross Valuation and Net Sales Proceeds of Retail Component
  • Solving for Residual Land Value

Real Estate Finance Bootcamp (Level 2 Certification)

In this module, employees learn the foundations of real estate finance as well as advanced techniques and topics. Topics covered include:

  • 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

Mixed-Use Development Transaction Financial Modeling

The developer’s analysis is conducted assuming a mixed-use prototype with ground floor retail and income-producing parking for multi-family, office/industrial and condominiums/housing subdivisions. All topics contain exercises. Topics covered include:

  • Site and building information
  • Rentable/salable square footage allocations across uses
  • Project timing elements
  • Capital structure
  • Uses and sources of funds
  • Cash flows and returns

Apartment Property Acquisition Transaction Financial Modeling

Using a case study, employees learn how to model the acquisition of an existing multi-family property and the unit-by-unit renovation process. Topics covered include:

  • Integration of historical property data and existing rent roll into your pro-forma
  • Modeling of future lease expirations and renewals and the individual unit renovation program
  • Modeling of operating expense savings gained from the renovation/greening of apartment units
  • Modeling of acquisition loan financing, residual equity requirement, and permanent take-out loan/refinancing
  • Property disposition modeling
  • Running of sensitivity analyses around key variables in 2-way Data Tables

Multi-Tenant Commercial Property Acquisition Modeling from ARGUS Valuation DCF Operating Cash Flow Output

In this module, employees learn the collection of technical skills for the modeling of the acquisition, operation and disposition of an existing multi-tenant commercial (office, industrial or retail) property. Employees also learn the mathematical mechanics behind how ARGUS Valuation DCF works, and how to integrate an ARGUS cash flow projection into Excel to perform levered, equity partnership and sensitivity analyses.

Topics covered include:

  • Integration of historical property data and existing rent roll into your pro-forma
  • Modeling of weighted average expected values based on probability assumptions for future lease expirations or renewals
  • How to quickly build a live Excel-based pro-forma valuation model that links directly to a 11-year cash flow projection from ARGUS
  • Modeling of acquisition loan financing, residual equity requirement, and permanent take-out loan/refinancing
  • Equity partnership modeling
  • Sensitivity analysis on key variables
  • Property disposition
  • Presentation of transaction performance indicators in an institutional investor-friendly format

Single Transaction Equity Joint Venture Partnership and Waterfall Modeling (Level 3 Bootcamp)

In this module, employees learn advanced techniques and topics related to joint venture partnerships and investment waterfall modeling for single property transactions. Topics covered include:

  • Rationale behind targeting disproportionate returns to the Sponsor
  • How to achieve disproportionate returns through fees and partitioning of cash flows
  • Preferred Return overview
  • Preferred Return variations with respect to priority of payment
  • Preferred Return in context (Payment Types A, B and C)
  • Nature of Preferred Return (Non-compounded/compounded, non-cumulative/cumulative)
  • Annual Preferred Return Exercise
  • Monthly Preferred Return Exercise
  • Waterfall Distribution overview, with Animation
  • Promote Mechanism overview and modeling
  • Look-Back Internal Rate of Return (IRR) Method
  • 3-Tier Waterfall modeling
  • Double-Promote, 5-Tier Waterfall modeling
  • Double-Promote Exercise
  • Alternate Compounding Periods: Monthly, Daily, Quarterly
  • Sample Partnership Structures

Private Equity Fund Modeling

In this module, employees will learn big picture real estate private equity fund basics, the general legal structure of funds based in the U.S., how to set up a fund-level model, and considerations for running sensitivity analyses. A property-level partnership analysis is also addressed. Topics covered include:

  • Capital sources
  • Major types of funds
  • General legal structure
  • Rationale behind disproportionate reward to the General Partner/Fund Manager through a promote structure
  • Modeling and then replicating a prototypical transaction starting at Net Operating Income and ending at Levered Cash Flow
  • Weaving in and rolling up and modeling multiple transactions on the fund-level
  • Considerations for running sensitivities
  • Individual transaction typical partner joint venture structure and modeling
Testing and Certification

Testing and Certification

All self-study modules contain rigorous Excel-based hands-on exercises and solutions, so there is in effect continuous testing integrated into the program.

In addition, there are three formal online Completion Certification exams that the employees may take at any time. These exams bestow REFM Certification In Excel For Real Estate. Scoring is automatically, instantaneously reported back to the employees, and it can be reported back to the training program administrator if desired. A sample test question appears below.

Inquiries

Inquiries

To discuss your needs, please email Sales at Sales@GetREFM.com to schedule a phone conversation.

Register now to get FREE e-Books, Excel tools and access to Valuate REGISTER
left to take 50% off with coupon code: yearend50