Save for later

The Real Estate Pro Forma Modeling Master Class

Want to learn how to build professional, dynamic, institutional-quality real estate pro forma models in Microsoft Excel? This course will take you by the hand and walk you step-by-step through the entire process. This is a project-based course, meaning you'll start with a blank Excel workbook and walk away with a fully-functional, dynamic, eight-tab pro forma model that YOU'VE created - from scratch. 

When I was first learning real estate financial modeling, I would download real estate investment models or real estate investment calculators on the internet, only to feel overwhelmed and frustrated by the complex functions and formulas everywhere in the Excel file. And once I felt like I was getting used to one of these things, I still was petrified to touch or change anything because I didn't want to "break" the model. And honestly, even if I understood it and I believed the model was working correctly, I still had no idea if I could even trust the calculations in the first place. 

If you've ever felt any of these things, this course will pull back the curtain and uncover the "Black Box" that most real estate financial models appear to be. By the end of this course, you'll be able to build a dynamic, professional-quality real estate pro forma model from scratch, and your first one will be done by the time you finish the last lecture.

This course will teach you how to build a real estate pro forma investment model the way the largest and most sophisticated private equity real estate firms look at deals. At the end of this course, you will be able to:

  • Build an institutional-quality, dynamic real estate pro forma investment model from scratch

  • Learn key Excel shortcuts to double your real estate financial modeling speed

  • Modify and customize existing real estate pro forma models to fit your specific investment scenario and needs

  • Confidently model key investment metrics such as the XIRR, Equity Multiple, and Cash-on-Cash returns, and calculate these metrics automatically as you change manual input drivers

  • Build a dynamic renovation budget that captures exactly when and how you plan to renovate the property

  • Model renovation premiums and timing for a property renovation

  • Build out dynamic loan schedules and refinancing scenarios to accurately model any financing structure

  • Build formula "checks" to error-proof your work and feel confident your calculations are accurate and can be trusted

This course is perfect for you if:

  • You're a college student or graduate student looking to break into real estate investment after graduation, and you're looking to add the key technical skill sets to your arsenal that will put you head and shoulders above the competition and allow you to land a lucrative career opportunity in the field

  • You're a professional in a different field, but looking to buy real estate on the side and want to be able to confidently analyze a deal 

  • You're an existing real estate professional looking to advance your career, increase your compensation, and break into the real estate investment industry.

  • You've bought rental homes or duplexes, and now you're looking to move into bigger properties and want to feel confident in your ability to analyze deals.

Here's what some of our students have had to say:

"Great Course. I really enjoyed the pace, the content and the explanations. I have worked on complex real estate models before but still learned a lot in this course. Will definitely take another course from Justin. Highly recommended."

"Justin does a great job of explaining how to underwrite a deal with this MBA-level course. Coming from Asset Management I thought I had a solid background into financial modeling, but later realized I was missing many of the advanced skills that are covered in this course. I recommend this course to anyone that wants to sharpen it's skills and move into the acquisition world. Justin is a great teacher and a very responsive one as well. (Usually responds the Q&A section within a day or two). As a bonus, I've sharpened my excel "shortcut" skills to another level. Thank you."

"Justin, Is a very effective instructor. This course is well organized and he lays out the material at just the right pace. His responsiveness to all student questions makes the class feel interactive and shows that he's engaged in this with you. This master class was excellent. He walks you step-by-step through everything, so even if you don't understand certain things you can at least build the muscle memory by doing the steps to build the model and then review the reason behind the steps later, if you need to. I definitely built some neural pathways through this one. "

"The course is very on par with my education in MRED. It covers a great deal of the real estate pro-forma modeling, with great insights and 'checks'. It is a great foundation and practical experience brought to the masses."

"These classes are hands down the most valuable real estate modeling tools available online. The finished models themselves are useful, but the techniques you'll learn will give you the skillset to model any type of scenario you need. I work at a boutique investment and development firm and our principals and investment partners have been extremely impressed by the models I built based on Justin's coursework. I look forward to more classes in the future."

"Great course. Very helpful in both demonstrating the nuts and bolts of constructing an in-depth CRE financial model, and discussing some KPIs important to an institutional investor or lender. The instructor was concise, articulate and very responsive to questions posed in the Q&A section. While the instructor takes you step-by-step, this is still a very technical course. A solid knowledge of finance, plus some background in real estate and light programming will go a long way in helping you understand what's happening while he's explaining. If you're an aspiring developer or looking to do more modeling for work, I highly recommend this course."

If you have a basic understanding of real estate finance, and you're looking to apply that knowledge to analyze new real estate investment opportunities, enroll now and let's get started building this model together today. Looking forward to having you in the course.

Get Details and Enroll Now

OpenCourser is an affiliate partner of Udemy.

Get a Reminder

Not ready to enroll yet? We'll send you an email reminder for this course

Send to:

Udemy

Rating 4.7 based on 68 ratings
Length 8 total hours
Starts On Demand (Start anytime)
Cost $9
From Udemy
Instructor Justin Kivel
Download Videos Only via the Udemy mobile app
Language English
Subjects Business
Tags Business Real Estate

Get a Reminder

Get an email reminder about this course

Send to:

Similar Courses

What people are saying

According to other learners, here's what you need to know

highly recommend in 7 reviews

Highly recommended!

Would highly recommend the course to anyone else.

If you're an aspiring developer or looking to do more modeling for work, I highly recommend this course.

I highly recommend taking both of his courses.

Highly recommended.

I highly recommend this course and can't wait to take Justin's other courses.

Read more

real estate financial in 4 reviews

the instructor comes back to you with the answers to your questions in a very timely manner, usually within 24 hours time This course presents a very detailed approach to commercial real estate financial modeling.

Really gets into the "nuts & bolts" of real estate financial modelling.

I took this course to build on what I previously learned (in his The Real Estate Financial Modeling Bootcamp) to the next level.

Read more

easy to follow in 4 reviews

The instructions were logical, clear, and easy to follow.

I have finished this course finally, but I have to do it again to master it :)) Thank you very much Great course that was easy to follow.

It is perfect for what I do at my job yes, i enjoy working with real estate spreadsheet models Just perfect Very easy to follow.

Read more

look forward in 4 reviews

Enjoyed this course a lot and look forward to taking more!

I look forward to more classes in the future.

Great work - I look forward to taking more advanced courses you release in the future!

Read more

financial modeling in 4 reviews

I had tried a number of real estate Excel financial modeling classes, and they were all either "30,000 feet" in their presentation or too simplistic.

pro forma in 3 reviews

I joined the course to learn to build a real estate investment pro forma and I'm becoming an advanced Excel user in the process.

The instructor provides step by step instructions on how to set up a Real Estate Pro Forma.

Great beginning Good pace and I like that he is setting up a foundational understanding of the structure of the Pro Forma.

Read more

Careers

An overview of related careers and their average salaries in the US. Bars indicate income percentile.

Real Estate Agent/Real Estate Investing $39k

Real Estate Negotiator and Real Estate Appraiser $40k

Real Estate Translator $60k

Sales/Real Estate $64k

Real Estate Accountat $68k

Shareholder (Real Estate) $71k

Real Estate Aquisitions $74k

Investment Real Estate $78k

Real Estate and Insurance $85k

Real Estate Law $94k

Associate Real Estate & Real Estate Litigation $137k

Partner- Real Estate $260k

Write a review

Your opinion matters. Tell us what you think.

Udemy

Rating 4.7 based on 68 ratings
Length 8 total hours
Starts On Demand (Start anytime)
Cost $9
From Udemy
Instructor Justin Kivel
Download Videos Only via the Udemy mobile app
Language English
Subjects Business
Tags Business Real Estate

Similar Courses

Sorted by relevance

Like this course?

Here's what to do next:

  • Save this course for later
  • Get more details from the course provider
  • Enroll in this course
Enroll Now