Description
This Bundle Is For You If You Want To
This is a good fit if you want to:
- Gain proficiency in basic and intermediate Excel-based CRE financial modeling skills
- Pass exams to add known and valued skills Certifications to your resume and LinkedIn profile
- Accelerate your career advancement by becoming the go-to analyst or associate for Excel-based financial modeling
REFM’s Certification in Excel for Real Estate program has existed since 2011, and thousands of certifications have been granted. Certification holders use their REFM credentials to prove their skills and to support their career moves.
Applicable Analysis Types
- Stabilized and Value-add Acquisitions
- Ground-up Development
- All Property Types
Why REFM?
Through the direct experience of REFM’s principals in commercial real estate transactions, and REFM’s ongoing consulting to industry practitioners across the U.S. for the last decade, we have developed and have continually refined “The REFM Way” of teaching financial modeling.
To enhance your learning and help you to efficiently build a practical skill set, we:
- Always set the stage by providing the big picture first, and keep it at the fore with graphs and sparklines
- Speak in plain language and define industry terms on an ongoing basis
- Give you highly granular video chapter hyperlinks so you can find what you want quickly and easily.
Overview
In this 3-hour course, you will learn basics of operating in Excel, as well as dozens of practical skills and 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 course is the preparatory material for REFM Excel for Real Estate Level 1 Certification.
In this approximately 2-hour course, you will learn 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 course is the REFM Excel for Real Estate Level 2 Certification Preparatory Material.
In this 3-hour course, you will learn basics of operating in Excel, as well as dozens of practical skills and 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 course is the preparatory material for REFM Excel for Real Estate Level 1 Certification.
In this approximately 2-hour course, you will learn 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 course is the REFM Excel for Real Estate Level 2 Certification Preparatory Material.
What You Get
Lifetime online access to:
- Two (2) easily-navigated video tutorials, with captions available and playback controls up to 2x speed. Videos are playable on any device including PC, Mac, phones and tablets.
- Accompanying fully-unlocked, annotated Excel files, compatible with Excel on both PC and Mac, which you can re-purpose for future analyses.
- Access to the Certification exams, as well as to 70 practice questions to help you prepare.
Meet Your Instructor
Details on Level 1 Bootcamp
Excel for Real Estate
In this 3-hour course, you will learn 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.
- 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
- 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
- COLUMNS, ROWS
- IFERROR
- RATE
- PV, FV
- NPV and XNPV
- IRR and XIRR
- PMT, PPMT, IPMT
- CUMPRINC, CUMIPMT
This is a hands-on-the-keyboard course. You will watch the video and pause it to complete exercises in the associated Excel; you will repeat this process.
Our approach to help you learn is to isolate individual techniques and tie them to real world applications. Examples are given and then exercises are given for you to complete. Solutions are in the Excel, and are reviewed on the video.
Rest assured that you will work very hard in this course programming dozens of formulas, and you will learn a lot about the real estate business in the process.
The video running time is 3 hours. Watching all the video (replaying parts where desired) and completing the exercises will take approximately 4 to 6 hours, depending on the individual.
The sample questions and 35-question Certification exam will take approximately an additional 2 hours to complete.
This course will prepare you to pass the associated 35-question Certification exam, which is available online 24/7/365, and is open book. The exam has questions similar to these sample questions.
Passing the exam requires a score of 70% or better, and passing With Distinction requires a score of 85% or better. You can retake the exam if you are unsatisfied with your score.
Upon passing, you will be listed automatically on the Certification Holders page.
You are allowed one re-take of the test if you wish to take it again.
Upon successful completion of this course, you will:
- Have built confidence in your ability to apply the most commonly-used set of formulas, functions and techniques for CRE Excel-based modeling
- Be able to understand how outputs are generated on any spreadsheet you come across
- Be ready to build upon the technical foundations you have put in place
- Keyboard Shortcuts
- Spreadsheet and Formula Basics
- Cell Formatting
- Arithmetic
- Statistics
- Relative vs. Absolute References
- Insert and Delete Rows and Columns
- Dates
- SUMIF and COUNTIF
- Paste Special, Transpose
- VLOOKUP and HLOOKUP
- Conditional Statements
- Conditional Statements Solution
- Conditional Formatting
- TVM and Financial Functions
- Financial Functions Exercise
- Mortgage Payment
- Mortgage Payment Exercise
- Mortgage Payment Exercise Solution
- CUMPRINC and CUMIPMT
- Formula Auditing
- Data Source
- Data Tables
- Circular References
- Best Practices
Since 2009, top companies and educational institutions have trusted REFM to train thousands of their employees and students.
New to REFM training?
Clients Include
Clients Include
Amherst
ASB Capital Management
Barings
BentallGreenOak
BrightSpire
Brixmor
Brookfield
CapitalOne
CBRE Global Investors
CCRE
Centennial Bank
Citibank
ColonyNorthstar
Conrex
CPPIB
CRC Companies
CreditSuisse
Crescent Communities
Crow Holdings
DDG
DLA Piper
Greystar
GTIS Partners
Hodes Weill & Associates
Houlihan Lokey
Howard Hughes
Jamestown
JBG Smith
JPMorganChase
Kennedy Wilson
Link Logistics
LivCor
Lubert-Adler
Macys
Oxford Properties
Park Hill
Peterson Companies
PGIM
PN Hoffman
Prometheus
QuadReal
Related
Revantage
SEO
Skanska USA
Square Mile Capital
USAA Real Estate
Asset Living
CBRE Global Investors
Clark Enterprises
Comstock Homes
Conor Commercial
Crescent Communities
Federal City Property
Flournoy
Four Seasons
Grosvenor
GTIS Partners
Hines
Hoffman
Howard Hughes
HPET
Hunt Companies
Insight Property Group
Kettler
LaSalle Investment
MadisonMarquette
Markwood
Mesa Capital
Midway
Miller Valentine
Panoramic Interests
PEG Development
Renaissance Downtowns
Rockefeller Group
Skanska USA
Snavely Group
Trammell Crow Residential
Trion Properties
Vornado
Details on Level 2 Bootcamp
Real Estate Finance
In this approximately 2-hour course, you will learn about 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.
- 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
- Compounding and Discounting (FV, PV)
- Net Present Value (NPV)
- Conditional Statements (IF, AND)
- Cumulative Principal (CUMPRINC)
- Minimum (MIN)
This is a hands-on-the-keyboard course. You will watch the video and pause it to complete exercises in the associated Excel; you will repeat this process.
Our approach to help you learn is to walk through a series of mini case studies that illustrate key dynamics of real estate finance. In the interest of getting you to learn efficiently in your limited study time, we give you “skeletons” of the analysis set-ups and teach from that point of progress forward. You are of course welcome to re-build the spreadsheets from scratch at any time.
Rest assured that you will work very hard in this course, and you will learn a tremendous amount about real estate finance and financial modeling in the process.
The video running time is 1 hour 48 minutes. Watching all the video (replaying parts where desired) and completing the exercises will take approximately 3 to 5 hours, depending on the individual.
The sample questions and 39-question Certification exam will take approximately an additional 2 hours to complete.
This course will prepare you to pass the associated 35-question Certification exam, which is available online 24/7/365, and is open book. The exam has questions similar to these sample questions.
Passing the exam requires a score of 70% or better, and passing With Distinction requires a score of 85% or better. You can retake the exam if you are unsatisfied with your score.
Upon passing, you will be listed automatically on the Certification Holders page.
Upon successful completion of this course, you will:
- Have gained a critical understanding of basic and intermediate capital structuring for real estate transactions
- Be able to project property cash flows, and discount them at both constant and variable discount rates to solve for the NPV
- Be able to back-solve for the residual land value of a site for a potential office building development
- Be able to model the funding and repayment of up to 5 equity and debt layers in a development transaction analysis context, and size a refinancing loan on an existing owned property
- TVM Timeline
- DCF Timeline
- DCF Exercise
- DCF Solution
- Residential Refi 1 – Exercise
- Residential Refi 1 – Solution
- Residential Refi 2 – Exercise
- Residential Refi 2 – Solution
- Residual Land Valuation Overview
- Office Industrial Development Back of the Envelope Exercise
- Office Industrial Development Back of the Envelope Solution
- Capital Structure 1
- Capital Structure 2
- Capital Structure 3
- Capital Structure 4
- Senior Construction Loan Overview
- Equity Exercise
- Equity Solution
- Mezzanine Loan Exercise
- Mezzanine Loan Solution
- Pari Passu Exercise
- Pari Passu Solution
- Maximum Loan Amount Exercise
- Maximum Loan Amount Solution
- Profit Sharing
- Waterfall #1 Graphs
- Double Promote
- Waterfall #2 Graphs
- Keyboard Shortcuts
Level 2 Bootcamp Sample Content
- Time Value of Money Theory Explanation
- Time Value of Money Example
- FV Function Review
- PV Function Review
- Case Study Assumptions
- Investment Cash Outflow
- Base Rent
- Escalations
- Percentage Rent
- Expected Return
- Year-Over-Year Growth
- Cash-On-Cash Return
- Present Value of Cash Flows
- NPV
- Discount Rate Selection
- DCF Exercise
- NPV With Different Discount Rates
