“The New York Course” Self Study Product
SelfStudy400px250px1

“The New York Course” Self Study Product

$899.00

  Our best Self Study value!

Academic Price – $599.00

To get Academic pricing, click Academic Verification in the header and follow the instructions. Once you have Academic status, the discounted pricing will show.

Product Description

This product is a Self Study version of our popular 2-day intensive live training course that provides you with critical foundations and financial modeling skills specific to development and acquisition transaction analysis and equity returns analysis. Included in the product are:

Permanent online access to easily navigated, mobile-friendly Video Tutorials

Accompanying unlocked Excel files, compatible with both PC and Mac 

All the knowledge needed to attain REFM’s three Certifications

A job interview test Excel Solution Set and 1-page investment memo

What New York Course attendees have said

REFM’s 2-day was intense! A great mix of Excel applications with real estate analysis. Come ready to work.- Mark Thompson, President, Real InSITE
Nothing comes close to the depth of explanation and expertise that was provided in this two day class.- Steve B., Analyst, Private Equity
The material covered in the training session covered every aspect of my business. It was well worth the cost!- Barry Metcalf, VP, Cadence Capital Partners

Why train with REFM?

  • Time-tested training content second to none in terms of refinement, depth and breadth
  • Efficient, student-focused teaching and learning format
  • Potential to achieve the most highly-regarded Excel skills certification in the business

.

REFM is the trainer to these organizations:

 

TrainingClientLogos5by5


Products Included

mac-keyboard

Level 1 Bootcamp – Excel For Real Estate (Level 1 Certification Preparation)

Description

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 REFM Excel for Real Estate Level 1 Certification Preparatory Material.

Includes the following items, which never expire:

 Online access to an easily navigated 56-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 (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, DATEVALUE
  • IF, AND, OR, and combinations thereof
  • SUMIF, SUMIFS
  • COUNTIF, COUNTIFS
  • VLOOKUP, HLOOKUP
  • IFERROR
  • RATE
  • PV, FV
  • NPV and XNPV
  • IRR and XIRR
  • PMT, PPMT, IPMT

Sample Content


.

Level 2 Bootcamp – Real Estate Finance (Level 2 Certification Preparation)

Description

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.

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)

Sample Content


.

Mixed-Use Apartment/Multi-family Building Development Modeling

AptProduct3

Description

An interactive Video Tutorial that teaches how to model the speculative development and sale of a multi-family rental building with ground-floor retail and income-producing parking.

Includes the following items, which never expire:

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

SelfStudy750pxwide

 Accompanying fully-unlocked, annotated Excel file, compatible with both PC and Mac, which you can repurpose for future analyses

100-page Audio Transcript in PDF format

Topics Covered

Site and Building Information

  • Calculation of allowable density using FAR multiple and site area
  • Calculation of allowable building footprint using lot coverage ratio and site area
  • Calculation of building height using slab-to-slab height and story count
  • Calculation of apartment gross square footage given an assumed ground-floor retail square footage
  • Calculation of apartment rentable square footage given an efficiency factor
  • Calculation of parking requirements and required parking gross square footage given usable square footage loss factor

Apartment Unit and Mix Details

  • Calculation of average rent/month given a monthly rent per square foot and average unit size
  • Calculation of total rentable square feet of each unit type and total number of each unit type given average unit sizes, and percentage of total rentable square footage that each unit type comprises
  • Calculation of monthly revenues and share of revenues by unit type

Capital Structure

  • Calculation of sources of funds supplied by each of three equity sources, a mezzanine lender, and a senior lender
  • Calculation of percentage of total development cost that each of the three equity investments comprise

Project Timing Elements

  • Understanding of the relationship between the durations of the three phases of development (Pre-Construction, Construction and Post-Construction), and the timing and dependencies of the major milestones within each of those phases

Uses of Funds

  • Quantification and timing of:
    • Land and Acquisition Costs
    • Hard Costs (based off of a bell-shaped distribution curve) and Tenant Improvement Costs
    • Soft Costs
    • Fixtures, Furnishings and Equipment Costs
    • Financing Costs, including Capitalized Interest Expense, and Operating Deficit

Sources of Funds

  • Quantification and timing and interrelationship of Draws, Interest and Repayment, as applicable, of:
    • Developer Sponsor Equity
    • Developer Partner Equity
    • Third Party Investor Equity
    • Mezzanine Financing
    • Senior Financing

Cash Flows and Returns

  • Income and Expense Assumptions
  • Apartment Unit Lease-Up Schedule
  • Calculation of Gross Rental Income, Effective Gross Revenue and Net Potential Revenue
  • Calculation of Total Operating Expenses and Real Estate Taxes
  • Calculation of Net Operating Income (NOI)
  • Calculation of Current Annual Yield
  • Calculation and Timing of Capital Expenditures
  • Calculation and Timing of Non-Capitalized Interest Expense
  • Timing of Financing Cash Flows
  • Calculation of Project Levered Cash Flow
  • Calculation of Multiple on Equity
  • Calculation of Internal Rate of Return (IRR) on Equity
  • Calculation of Profit Margin

Capitalized Valuation

  • Calculation of “Current” Annual Net Operating Income
  • Calculation of Future Stabilized Net Operating Income
  • Calculation of Future Net Sale Amount

Profit Sharing/Internal Rate of Return Waterfalls

  • Calculation of profit sharing based on an assumed Internal Rate of Return Waterfall structure with preferred returns and promotes

Sample Content


.

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

JV_400_250px

Description

An interactive Video Tutorial that teaches you advanced techniques and topics related to joint venture partnerships and investment waterfall modeling for single property transactions (not multi-transaction private equity funds).  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 3 Certification Preparatory Material.

  • Teaches the most difficult, valuable and desired set of financial modeling skills in plain English
  • Teaches you how to model out equity cash flow splits among up to three equity players
  • You can integrate the included annual and monthly waterfall models with your existing spreadsheets

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

 PDF of the 60-slide presentation

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

Topics Covered and Exercises/Solutions Included

  • 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
  • Claw-Back overview and modeling
  • Claw-Back Exercise

Sample Content


 

Office Property Operating Projection and Acquisition Screening Analysis Modeling

get-refm-slider-2-600x400

Description

An interactive Video Tutorial that teaches:

  • Typical line item set-up for office properties
  • Cash flow projection modeling basics
  • Building a multi-tenant property-level operating projection (also applies to single-tenant properties) assuming initial vacancy that is leased up, and no subsequent expirations during the analysis timeline
  • Conducting a property-level acquisition equity returns screening analysis

You will model more than 130 rows across the two parts of the tutorial. This will likely take you 3 to 4 hours including watching the video tutorial.

Includes the following items, which never expire:

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

SelfStudy750pxwide

 Accompanying fully-unlocked, annotated Excel file, compatible with both PC and Mac, which you can repurpose for future analyses

Excel file tabs are:

  • Office Cash Flow Set-Up
  • Projection Formulas
  • Projection Exercise
  • Projection Solution
  • Screening Analysis Exercise
  • Screening Analysis Solution (see Bonus Content included below)

Topics Covered and Exercises/Solutions Included

Part 1

First, you will first learn the generic 20-line item set-up for an existing operating commercial office property, starting at Base Rental Revenue (Gross Potential Rent) and ending at Before-Tax Levered Cash Flow (cash flow to equity).

Then, a primer on projection formula construction is provided to get you ready to construct the 10-year annual property operating projection.

Next, the assumptions for projection modeling exercise are explained.

There are three Suites in the property. The assumptions to be used are that leases for Suites 100 and 200 were put in place at the start of the trailing twelve months, and that Suite 300 is vacant currently and will remain vacant through the end of Year 1. Suite 300 rent will commence at the start of Year 2 with Year 2 Base Year.

Suite 100 is a triple-net (NNN) lease, and Suites 200 and 300 are Gross leases (Base Year stop).

The following assumptions inputs are provided for you to key into the Exercise tab:

  • Property-level Base Year (BY) operating expenses, real estate taxes and utilities PSF
  • Base Year rents for all three suites
  • general vacancy and credit loss
  • Annual growth rates for rents for all three suites
  • % of reimbursable and non-reimbursable expenses that are fixed
  • Annual growth rates for:
    • parking and miscellaneous revenue
    • reimbursable expenses
    • real estate taxes
    • non-reimbursable expenses
    • capital reserves
  • Management fees as a % of EGR
  • Tenant Improvements and Leasing Commissions PSF for Suite 300

Projection formula mathematical descriptions are provided to guide your Excel formula construction.

After a couple of examples are performed for you, you will fill in the 30+ line items in the exercise. You can check your work in real-time against the fully-unlocked Solution set tab provided in the Excel file. Solutions for the lines are explained in the video.

Part 2

The second part of the tutorial takes the NOI line from the Part 1 Solution set tab, and weaves it into an acquisition analysis screening tab that integrates purchase, sale, debt and equity elements.

The sections of this analysis are:

  • Uses of Funds
  • Sources of Funds (Sponsor equity, Third Party Investor equity, Senior Acquisition Loan)
  • Unlevered Projection Analysis
  • Debt Schedule
  • Levered Cash Flow
  • Sensitivity Tables
  • Levered Summary

After a few examples are performed for you, you will model more than 100 rows. You can check your work in real-time against the fully-unlocked Solution set tab provided in the Excel file. Solutions for the lines are explained in the video.

Data tables are used to provide a spectrum of outcome possibilities given simultaneous changes in two key inputs. A levered summary table is also provided to evaluate returns for multiple hold durations side-by-side.

BONUS EXCEL CONTENT INCLUDED! *

  • Annual equity joint venture partnership waterfall between Sponsor and Investor
    • JV partnership structure: (Equity goes in 10% from Sponsor, 90% from Investor.) All equity gets a Preferred Return of 10%; after Preferred Return is distributed and Equity investment is returned, then the Sponsor gets a 20% promote, and the residual 80% goes to ALL Investors, pro-rata to cash investment.

* Bonus content is annotated only; there is no video tutorial footage associated with it.

Sample Content


.

Who Should Buy This Product

Beginner-, intermediate- and advanced-level professionals and students.

SPECIAL BONUS INCLUDED WITH PURCHASE

Job Interview Technical Modeling Test and Solution Set

Case study: development of a hypothetical mixed-use (multifamily and retail) property that includes a refinance and equity joint venture partnership cash flow waterfall with a sponsor catch-up. Assumptions are provided. Build out a 7-year annual projection model down through partner-level returns.

Answer the questions:

  • is this an attractive deal to the third party investor at the assumption set given? Why or why not?
  • if not, at what values does it become attractive?

Solution set provided is a 100% unlocked, dynamic Excel model with annotations, and includes a 1-page investment committee-style writeup.

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