Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Development Tools No-Code Development
Business
Entrepreneurship Communications Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certification Network & Security Hardware Operating Systems Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design Design Thinking 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition Yoga Mental Health Dieting Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Teacher Training Test Prep Other Teaching & Academics
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Cisco CCNA Amazon AWS CompTIA Security+ AWS Certified Developer - Associate
Photoshop Graphic Design Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Mindfulness Personal Development Meditation Personal Transformation Life Purpose Emotional Intelligence CBT
Web Development JavaScript React CSS Angular PHP WordPress Node.Js Python
Digital Marketing Google Ads (Adwords) Social Media Marketing Google Ads (AdWords) Certification Marketing Strategy Internet Marketing YouTube Marketing Email Marketing Retargeting
SQL Microsoft Power BI Tableau Business Analysis Business Intelligence MySQL Data Analysis Data Modeling Data Science
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Online Business Business Plan Startup Freelancing Blogging Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ 2D Game Development Unreal Engine Blueprints Blender
30-Day Money-Back Guarantee
Business Real Estate Real Estate Investing

The Real Estate Financial Modeling Bootcamp

The Complete A to Z Guide to Modeling Real Estate Transactions in Microsoft Excel For Smarter Real Estate Investing
Rating: 4.7 out of 54.7 (4,327 ratings)
17,799 students
Created by Justin Kivel
Last updated 1/2021
English
English [Auto], Italian [Auto], 
30-Day Money-Back Guarantee

What you'll learn

  • The ability to build a functional, dynamic real estate financial model from scratch.
  • The skill set to model real estate transactions for multiple different asset types and solve for the most essential investment metrics evaluated by large institutions and private equity groups.
  • A substantial increase in speed and efficiency in Microsoft Excel by learning powerful tools and functions.
  • A mastery of the foundational analytical and financial modeling tools necessary to break into the real estate private equity industry and model complex commercial real estate transactions.
Curated for the Udemy for Business collection

Requirements

  • Access to Microsoft Excel software for Mac or PC.
  • A basic working knowledge of Microsoft Excel is recommended.

Description

Learn real estate financial modeling. Advance your career. Make more money. Built by an instructor with over eight years of real estate private equity finance experience modeling over $1.5 billion of closed commercial real estate transactions, this course was designed to take you from complete beginner with no knowledge of real estate financial modeling to a real estate financial modeling pro. The skills and concepts you will learn in this course can be used to help you break into the real estate private equity industry, increase your compensation at your existing real estate job, or confidently analyze and model a commercial real estate investment on your own.

This course was created to help our students:

  • Begin a lucrative career in the commercial real estate private equity industry - According to CEL & Associates, Inc., the 2020 median total compensation for an acquisitions associate in retail, office/industrial, and multifamily was $137K, $143K, and $121K, respectively. This course will teach you the core fundamental Excel financial modeling skills necessary to land one of these jobs and succeed in your first commercial real estate investing role.

  • Increase overall compensation and career opportunities in their current real estate role - Real estate agents, property managers, construction managers, and architects all have extremely valuable skills that are highly desirable in the commercial real estate finance industry. Whether you want to earn more money in your current role or make a transition into commercial real estate acquisitions, this course will give you the foundational knowledge to take your real estate investing career to the next level.

  • Confidently model large real estate transactions - For property acquisitions larger than single-family homes, having the ability to confidently create a financial model projecting real estate investment returns is essential to buying profitable deals and garnering the confidence of your investors. Whether you are modeling a real estate investment you are looking to buy with your own money or leading a real estate syndication, strong financial modeling skills are an essential component of the real estate investment process.

This course will teach you the key fundamentals necessary in order for you to be able to model real estate investment transactions accurately, quickly, and efficiently.

Here's what some of our students have said about the course:

★★★★★ "Excellent course that teaches you financial modeling in Excel for CRE. I purchased the course after starting a new job as valuation analyst for a RE asset manager and it has helped me immensely. I have a background in PE funds and my excel skills are fairly advanced so for me the added value was understanding the specificities of CRE. I now look forward to completing the advanced RE modelling course. This instructor is great: no fluff, clear explanations, top notch material and step-by-step directions. Justin is also very responsive with answering your queries. I highly recommend the course!"

★★★★★ "This course is great. I learned everything I needed to build a model for an interview for a Financial Analyst role at a Real Estate Private Equity Fund. And I got the job. I have since gotten other courses by Justin, as they are what I need to get me up to speed at my new job. Also, Justin is great at answering questions when I get stuck and pointing me in the right direction."

★★★★★ "Excellent Course! Thank you for all your hard work in transforming a complex concept into an easy to understand format. This course has multiplied my understanding of financial modeling and the use of Excel. I learned more through this platform than the traditional institutional setting. A great resource and educator."

★★★★★ "Overall, this course was such an awesome experience! As a CRE investor as well, I took this course with the goal of it helping to rebuild my financial model and, what can I say, mission accomplished! From the structure, to the pace, the exercises, Justin's CRE knowledge and Excel tips/tricks - it was exactly what I was looking for and more!"

★★★★★ "Cannot believe the value in this course!! Best deal in real estate education. Thank you Justin, can't wait to take the next course. I could not recommend it more."

★★★★★ "This is a top notch course. The self-pace is perfect for me and it helped refresh all of the concepts that I learned in my grad school real estate courses. Just follow along and practice the examples and you'll extract tremendous value from a modeling perspective!!"

★★★★★ "Justin is awesome! His teaching style makes learning very intuitive. I would recommend this class for anyone that is trying to break into CRE or expand their current foundation of CRE. I was recommended by a friend who spent $600 on a course but found this one to be more helpful and easier to follow/understand."

★★★★★ "Superb course that teaches you the fundamentals of CRE modelling you need to know. Justin is a really good lecturer and he is very responsive with answering your queries, not just about the course material but even things related to your career in CRE. I would recommend the course to anyone looking to understand the fundamentals of CRE modelling."

★★★★★ "Wow! This course and Justin's other courses are the equivalent of an MBA level curriculum. If you are willing to put in the time and effort you will benefit."

If you're looking to learn to model commercial real estate investments to jump-start your career, make more money in your current job, or do your own big deals, you're in the right place.

Join us!

Who this course is for:

  • College students or career switchers who want to begin a career in private equity real estate finance.
  • Current real estate professionals who want to boost their compensation by adding valuable financial modeling skills to their existing skill set.
  • Current real estate investors who want to feel confident moving from purchasing 1-4 unit rental properties to larger properties involving more complex financial metrics and data.

Course content

13 sections • 113 lectures • 9h 22m total length

  • Preview04:46
  • Preview02:05
  • Preview05:18
  • Download Me First!
    00:15
  • Disclaimer
    01:18

  • The Property Cash Flow Statement Overview
    02:51
  • Effective Gross Revenue - Part 1
    02:34
  • Effective Gross Revenue - Part 2
    02:48
  • Operating Expenses
    02:37
  • Net Operating Income (NOI)
    01:24
  • Capital Expenses
    04:09
  • Debt Service
    02:57
  • Purchase, Sale, & Financing Metrics
    02:53
  • Unlevered & Levered Cash Flow
    04:12
  • A Note About Income Taxes
    01:32

  • Setting Expectations
    03:12
  • Real Estate Financial Modeling 101 & Dynamic Modeling
    02:20
  • Absolute & Mixed References
    08:02
  • Custom Formatting
    04:12
  • Drop-Down Lists
    04:28
  • Real Estate Financial Modeling Color Codes
    02:52
  • Gridlines & The "Steak Sauce" Cell
    02:06

  • Navigating Worksheets & Workbooks
    05:12
  • Controlling Columns & Rows
    05:58
  • Text Formatting
    05:26
  • Font Style
    04:57
  • Borders
    04:11
  • Alignment
    06:01
  • Excel Function Shortcuts
    04:10
  • Copy, Paste, & Paste Special
    06:12

  • IF Statements
    04:15
  • AND & OR
    05:23
  • SUMIF & SUMIFS
    06:27
  • COUNTIF & COUNTIFS
    05:25
  • AVERAGEIF & AVERAGEIFS
    04:14
  • VLOOKUP & HLOOKUP
    07:39
  • INDEX & MATCH
    06:32
  • Weighted Averages (Using SUMPRODUCT)
    06:23
  • CAGR (Using RATE)
    04:45
  • ROUND, ROUNDUP, & ROUNDDOWN
    06:05
  • DATEDIF
    04:51
  • YEARFRAC & EOMONTH
    04:20
  • PV
    05:03
  • FV
    03:04
  • NPER
    02:45
  • RATE
    03:31
  • PMT
    05:41

  • GPR, Vacancy, & Credit Loss
    06:19
  • Percentage Rent
    05:01
  • The Pro Rata Share
    03:46
  • NNN Reimbursements
    02:44
  • FSG Reimbursements
    01:51
  • MG Reimbursements
    03:11
  • BYS Reimbursements
    04:41
  • The Operating Expense Ratio
    05:33
  • Renewal Probability Modeling
    06:23
  • Cash Flow Modeling With Renewal Probability
    06:50
  • Leasing Commissions
    05:38
  • Tenant Improvement (TI) Allowances
    02:20

  • Loan Terms & Amortization vs. Term
    03:54
  • Loan Functions & PMT
    05:12
  • IPMT & PPMT
    04:17
  • Preview05:42
  • Building a Loan Amortization Schedule
    15:20
  • Loan-To-Value (LTV)
    02:19
  • Loan-To-Cost (LTC)
    02:07
  • Debt Service Coverage Ratio (DSCR)
    01:50
  • Debt Yield
    02:10
  • The Loan Constant
    03:05
  • Loan Sizing (LTV & LTC)
    03:25
  • Loan Sizing (DSCR & Debt Yield)
    04:21
  • Dynamic Loan Sizing Build-Out
    04:32

  • Key Real Estate Investment Analysis Metrics
    01:56
  • Capitalization (Cap) Rates
    08:40
  • Net Present Value (NPV)
    08:29
  • Internal Rate of Return (IRR)
    06:34
  • Equity Multiple
    06:09
  • Cash-on-Cash Return
    08:05
  • Positive vs. Negative Leverage
    05:02
  • XNPV vs. XIRR
    06:57

  • Real Estate Pro Forma Modeling Overview
    02:41
  • Monthly Cash Flow Modeling
    11:07
  • Monthly Growth & Toggle Triggers
    04:23
  • Modeling NOI
    09:24
  • Modeling Capital Expenses
    05:37
  • Modeling Principal & Interest Payments
    05:47
  • Modeling Purchase & Sale Metrics
    09:06
  • Modeling Loan Proceeds & Loan Payoffs
    06:23
  • Modeling Return Metrics
    05:34

  • 1-Variable Data Tables
    06:54
  • 2-Variable Data Tables
    02:50
  • Conditional Formatting
    04:00
  • Goal Seek
    04:07
  • Scenario Analysis
    07:56

Instructor

Justin Kivel
Real Estate Investing & Financial Modeling
Justin Kivel
  • 4.7 Instructor Rating
  • 13,869 Reviews
  • 37,555 Students
  • 19 Courses

Master real estate financial modeling, advance your career, and earn more money.

If you’re an aspiring real estate investment professional looking to break into the real estate investment field, or a current real estate professional looking to advance your career and increase your compensation, you’re in the right place.

My name is Justin Kivel, and I’m a real estate investment professional with a love for teaching. Throughout my career, I’ve worked on over $1.5 billion of closed acquisitions across multifamily, retail, office, and mixed-use properties. I’ve had the opportunity to work with some of the brightest minds in real estate investing and have spent almost a decade in the industry across private equity, finance, and brokerage roles.

Unfortunately, most of what I know today I had to learn on the job. Although great courses exist on Microsoft Excel and financial modeling, I couldn’t find a resource that was specifically tailored toward real estate investment professionals that would actually walk me through exactly what I needed to know to succeed in the real estate investment industry.

These courses are that resource.

After dozens of phone calls and coffee meetings with college students and aspiring real estate investment professionals, I realized that most people were asking exactly what I was asking when I was in their shoes.

“What skills do I actually need to know to break into the real estate investment industry, or advance in my current real estate investment career?”

These courses were created to teach you those skills.

Our students have gone on to land jobs at some of the top real estate investment, development, and brokerage firms across the globe, including Brookfield Asset Management, Hines, Starwood Capital Group, LaSalle Investment Management, Eastdil Secured, JLL, CBRE, and many more.

Over 30,000 current and aspiring real estate investment professionals have used these courses to help them ace real estate financial modeling interview exams to land their dream jobs, secure consulting gigs with top private equity firms, build (and rebuild) entire financial models from scratch, and confidently analyze their own potential real estate investments.

So whatever that next step in your real estate investment career looks like, these courses are here to help you get there as quickly and efficiently as possible.

Looking forward to seeing you in class!

  • Udemy for Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Featured courses
Udemy
© 2021 Udemy, Inc.