What you'll learn:
- How to build an institutional-quality real estate pro forma acquisition model from scratch in Excel
- How to create dynamic cash flow projections and calculate key investment metrics including the IRR, equity multiple, and cash-on-cash return
- How to create clean, professional-looking pro forma templates to present to investors and partners
- How to use Excel hotkeys and shortcuts to build real estate financial models quickly and efficiently
Want to learn how to build professional, dynamic, institutional-quality real estatepro 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 andwalk away with a fully-functional, dynamic, pro forma acquisition model that you've build -from scratch.
When I was first learning real estate financial modeling, I would downloadpro forma templates or real estate investment "calculators"on the internet, only to feeloverwhelmed and frustratedbythe complexfunctions and formulas everywherein the file. And even when I started to get comfortable with the layout of some of these, I still was petrified to change anythingout of fear of"breaking" the model.And honestly, even if Iunderstood what was going on and believed the model was working correctly,I still didn't know 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 on the "black box" that most real estate financial models appear to be. And by the end of this course, you'll be able to build a dynamic, professional-quality real estate pro forma acquisition model from scratch in Excel.
In this class, we’ll cover topics including:
Modeling construction costs and renovation premiums
Modeling rent growth and expense growth over time
Creating future cash flow projections for an investment
Modeling acquisition loan and refinance cash flows
Building a working capital account to fund future capital costs
Calculating key real estate investment return metrics, including the IRR, equity multiple, and cash-on-cash return
Whether you’re a real estate investor trying to build models to analyze your own deals, or if you’re trying to land an analyst or associate role at a top real estate firm, this course will teach you everything you need to know to create dynamic, institutional-quality real estate pro forma models from scratch in Excel.
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’re ready to get started building out this model with me, I’d love to have you in the class. Go ahead and click that "Buy Now" button, and I’ll see you on the inside of the course!
