We may earn an affiliate commission when you visit our partners.
Course image
Justin Kivel

Want to learn how to build professional, dynamic, institutional-quality real estate development 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 real estate development model that YOU'VE created - from scratch. 

Read more

Want to learn how to build professional, dynamic, institutional-quality real estate development 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 real estate development 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 development 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 development 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 development model from scratch

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

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

  • Confidently model key investment metrics such as the Stabilized Return on Cost, IRR, and Equity Multiple, and calculate these metrics automatically as you change manual input drivers

  • Build a dynamic construction budget (including S-Curve functionality)

  • Model dynamic lease-up revenue and expenses that change automatically as construction timelines change

  • Build out floating rate construction loan draws, dynamic equity draws, and permanent take-out financing to accurately model any financing structure

  • Build formula "checks" to error-proof your work and feel confident your calculations are correct

This course is perfect for you if:

  • You're a college student or graduate student looking to break into real estate development 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 become a real real estate developer on the side and want to be able to confidently analyze a ground-up development deal 

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

  • You've bought rental homes or duplexes, and now you're looking to become a real estate developer and want to feel confident in your ability to analyze new ground-up construction projects

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

"I have taken other RE Development courses and they were over-complicated and hard to follow, this course was just the opposite. As with all his other courses, Justin delivers a clear and easy to follow lesson, making him easily the best Real Estate modeling instructor on the internet. I honestly bought this course within 3 minutes of its release, and it was worth every penny.” 

"I've been in CRE valuation, investment sales brokerage, and realty capital for over 30 years, and I've never taken a class with this much detailed content. Justin not only crushes this course, but more importantly pulls back the curtain on how institutional investors view and model their deals. You'd have to work at an institutional PE or CRE firm for years to learn what he is offering here. It's not an easy walk but if one can master this content, you can size and model anything in the CRE universe. Congrats, Justin - job well done. "

"Another flagship course by Justin. First, it's all about the thoroughness of the course design (takes me step-by-step). Second, and more importantly, Justin keeps the communications going with his students. I am experiencing this myself and you could verify this by how many I post in the Q&A section, and how many got answered. I don't get this treatment often."

"Something that I've been looking for for a long time. I feel like I understand how to approach almost any RE modeling going forward."

"I've taken several real estate financial modeling courses to improve my skill level for my job. This is by far the best I have taken. Everything is taught step by step with clear instruction and explanations of formulas."

"Another great course taught by Justin, this was filled with many in depth excel modeling techniques to implement when forming a development model. Trying to break into CRE finance/ development can be tough and these skills can really give you an upper hand on the competition. Thanks. "

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

Enroll now

What's inside

Learning objectives

  • Learn how to build dynamic, institutional-grade real estate development models from scratch
  • Learn how to build out s-curve construction models, equity and construction loan draw funding, and dynamic lease-up modeling for new development deals
  • Learn how to create institutional, professionally formatted models to present development pro forma calculations to investors and partners

Syllabus

Students will be introduced to the real estate development model they will build in the course.
Welcome!
What We Will Cover - Part 1
What We Will Cover - Part 2
Read more
What We Will Cover - Part 3
A Sneak Peek Into What You'll Build
Setting Expectations
About The Instructor & Student Success Stories
Disclaimer
Students will learn the fundamentals of real estate development modeling in Excel in this section.
Real Estate Development Modeling Fundamentals
Real Estate Pro Forma Modeling 101
Monthly vs. Annual CF Modeling & Checks
Real Estate Financial Modeling Color Coding
The Development Model Set-Up
Advanced Excel Settings
Excel Shortcuts Cheat Sheet
Students will build out the summary dashboard of their real estate development model in this section of the course.
Building Out The Summary Tab
Modeling Land Acquisition Assumptions
Modeling Lease-Up Assumptions
Construction Financing Assumptions
Permanent Financing Assumptions - Part 1
Permanent Financing Assumptions - Part 2
Modeling Total Project Costs
Modeling Sale Details
Building Out The Circuit Breaker
Modeling Sources & Uses
Post-Construction Equity & Return Metrics Build-Out
Students will model multifamily revenue, including a dynamic lease-up period, in this section of the development model.
Building Out The Rent Roll
Weighted Average Rents
Modeling Other Income
Vacancy, Bad Debt, & Rent Growth Assumptions
Modeling The Lease-Up
Modeling Stabilized Rents
Calculating Percentage of Lease-Up Complete
Net Rental Revenue
Modeling Stabilized Other Income
Modeling Actual Other Income
Students will build out dynamic fixed and variable operating expenses in their real estate development model in this section of the course.
Building Out The Expenses Tab
Stabilized, Fixed, & Variable Expenses
PM Fees & Reserves
Building Out The Property Tax Information Table
Annual Property Tax Growth Modeling
Modeling Stabilized Operating Expenses
Modeling Actual Operating Expenses
Students will build out a dynamic construction schedule using an S-curve development cost framework in this section of the development model build-out.
Building Out The Construction Budget Tab
Building Out The Hard Costs Table
Total Costs & Timing
Building Out The Construction Timeline
S-Curve Construction Cost Modeling
Construction Funding Checks
Modeling Soft Costs - Part 1
Modeling Soft Costs - Part 2
Modeling Soft Costs - Part 3
Building In The Contingency
Students will build out monthly cash flows in this section of the real estate development model using the assumptions and formulas created throughout the course.
Building Out The Monthly CF Tab
Modeling Revenue
Dynamic Physical Vacancy Modeling
Bad Debt, Concessions, & Other Loss
Modeling Operating Expenses
Property Taxes & PM Fees
Capital Reserves & NOI
Capital Expenses & Cash Flow Before Debt Service
Modeling Acquisition & Sale Information
Loan Information Section Build-Out
Cash Flow Line Item Totals & Formatting Clean-Up
Property Taxes Finalization
Students will build out equity financing and construction loan draws, as well as capitalized interest, in this section of the real estate development model build-out.
Building Out The Financing Tab
Modeling Operating Metrics
Total Land & Construction Costs
Modeling Equity Financing
Modeling Equity Draws
Construction Financing Table Build-Out
Modeling Construction Loan Draws
Up-Front Financing Costs
Interest Rate Projections (Forward Curves)
Modeling Floating Interest Rates
Modeling Interest Expense & Capitalized Interest
Construction Loan Payoff & Ending Balance
Building Out The Permanent Financing Table
Timing The Permanent Loan Funding
Modeling The Total Loan Payment
Modeling Principal & Interest Payments
Permanent Loan Payoff & Ending Balance
Equity & Debt Funding Checks
Finalizing The Sources & Uses Table
Monthly CF Tab Financing Finalization - Part 1
Monthly CF Tab Financing Finalization - Part 2
Students will build out annual property cash flows, create checks, and finalize the real estate development model in this section of the course.
Building Out The Annual CF Tab
Modeling Annual Cash Flows
Building Out The Cash-on-Cash Return
Dynamic Refinance Loan Sizing

Good to know

Know what's good
, what to watch for
, and possible dealbreakers
Examines real estate development models which is highly relevant to those in the field
Teaches students how to create dynamic, professional-quality financial models from scratch
Suitable for individuals with a basic understanding of real estate finance, college students and professionals alike
Led by Justin Kivel, an expert in real estate financial modeling with a strong reputation in the industry
May require additional software or tools not readily available to all learners
Covers a range of topics essential for real estate development modeling, suitable for those seeking a comprehensive understanding

Save this course

Save The Real Estate Development Modeling Master Class to your list so you can find it easily later:
Save

Activities

Be better prepared before your course. Deepen your understanding during and after it. Supplement your coursework and achieve mastery of the topics covered in The Real Estate Development Modeling Master Class with these activities:
Review Course Materials
Establish a solid foundation by thoroughly reviewing the provided course materials before engaging in other activities.
Show steps
  • Read all assigned readings and watch all videos attentively.
  • Take notes and highlight important concepts.
Curate a Resource Library
Organize and consolidate relevant resources, such as articles, websites, and videos, to support your learning journey.
Show steps
  • Create a dedicated folder or online repository to store resources.
  • Actively search for and collect materials that align with course topics.
  • Categorize and tag resources for easy retrieval and reference.
Participate in Discussion Forums
Engage with peers to discuss course concepts, share insights, and answer questions, fostering a collaborative learning environment.
Show steps
  • Regularly participate in online discussion forums provided by the course platform.
  • Ask thoughtful questions and provide insightful responses to other students' posts.
Four other activities
Expand to see all activities and additional details
Show all seven activities
Explore Industry Resources and Case Studies
Gain additional knowledge and insights by reviewing industry publications, case studies, and best practices.
Browse courses on Case Study Analysis
Show steps
  • Visit websites of leading real estate development firms to read their project profiles and case studies.
  • Subscribe to industry newsletters and follow real estate development professionals on social media.
  • Attend online webinars or workshops hosted by industry experts.
Excel Modeling Exercises
Enhance your proficiency in Excel by practicing essential financial modeling techniques, such as formula writing, data manipulation, and scenario analysis.
Show steps
  • Complete a series of guided Excel exercises focusing on real estate development modeling concepts.
  • Create a custom Excel tool or template to automate calculations or streamline your workflow.
Connect with Industry Professionals
Seek guidance and insights from experienced professionals in the real estate development field to enhance your understanding and career prospects.
Show steps
  • Identify potential mentors through LinkedIn or industry events.
  • Reach out to mentors and express your interest in learning from their expertise.
  • Schedule regular meetings or phone calls to discuss your progress and receive feedback.
Write a Case Study on a Real Estate Development Project
Deepen your understanding of real estate development principles by analyzing a real-world case study and presenting your findings in a written report.
Show steps
  • Select a completed real estate development project.
  • Gather information about the project, including market analysis, financial projections, and project timeline.
  • Analyze the project's performance, identify key success factors, and discuss lessons learned.
  • Write a comprehensive case study report outlining your findings and insights.

Career center

Learners who complete The Real Estate Development Modeling Master Class will develop knowledge and skills that may be useful to these careers:
Real Estate Developer
Real Estate Developers plan and oversee the construction of residential, commercial, and industrial properties. They are responsible for all aspects of the development process, from acquiring land and obtaining financing to designing the project and overseeing construction. This course can be particularly useful if you are looking to break into the field of real estate development. With its focus on building dynamic real estate development models and mastering advanced Excel techniques, this course may help you develop the skills needed to succeed in this role by providing you with the technical expertise to analyze and execute development projects.
Real Estate Consultant
Real Estate Consultants provide advice to clients on all aspects of real estate, including investment, development, and management. This course provides valuable knowledge and skills that are essential for real estate consultants. By learning how to build financial models and conduct real estate analysis, you will be well-equipped to provide valuable insights and recommendations to your clients. Whether you are an experienced consultant or looking to enter this field, this course can provide you with the necessary tools to succeed.
Development Analyst
Development Analysts assess the feasibility of real estate development projects. They analyze market data, financial projections, and other factors to determine whether a project is likely to be successful. This course provides a solid foundation in real estate finance and modeling for those aspiring to become Development Analysts. By learning how to build dynamic models, you will develop the skills necessary to analyze and evaluate real estate development projects effectively.
Real Estate Investment Banker
Real Estate Investment Bankers provide financial advice to real estate companies and investors. They help their clients raise capital, structure deals, and make investment decisions. This course can help equip you with the knowledge and skills that are essential to succeeding in this profession. To excel as a Real Estate Investment Banker, you must be able to analyze financial data and develop sophisticated financial models. This course provides hands-on experience in these areas and can enhance your ability to excel in this role.
Portfolio Manager
Portfolio Managers make investment decisions for individuals and institutions. They develop and manage investment portfolios that meet their clients' financial goals. This course can be a valuable addition to your skill set if you wish to become a Portfolio Manager. It teaches you how to build financial models and conduct financial analysis, which are essential for making sound investment decisions. By understanding how to build dynamic models, you can make informed decisions and deliver better outcomes for your clients.
Commercial Real Estate Broker
Commercial Real Estate Brokers facilitate the buying, selling, and leasing of commercial properties. They work with clients to identify their needs and help them find the right property. If pursuing a career as a Commercial Real Estate Broker is your goal, this course can be a useful tool in your arsenal. It imparts the knowledge of real estate finance and modeling that will enable you to confidently analyze and present development deals to potential clients.
Quantitative Analyst
Quantitative Analysts use mathematical and statistical models to solve complex problems in the financial industry. They develop models to assess risk, price financial instruments, and make trading decisions. If you are pursuing a path as a Quantitative Analyst, this course can provide you with valuable knowledge. It teaches you how to build financial models and conduct financial analysis, which are highly sought-after skills in this field.
Risk Analyst
Risk Analysts identify, assess, and manage financial risks. They develop models to quantify risk and make recommendations on how to mitigate it. Understanding how to build and interpret financial models is crucial for success in this role. This course can help you develop the skills necessary to thrive as a Risk Analyst. By learning how to build financial models in Excel, you can gain a deeper understanding of how to evaluate and manage financial risks.
Construction Manager
Construction Managers oversee the construction of buildings and other structures. They are responsible for planning, coordinating, and executing construction projects. This course can enhance your ability to succeed as a Construction Manager by providing a deeper understanding of real estate finance and modeling. Learning how to build models in Excel will enable you to analyze construction projects and make informed decisions throughout the construction process.
Property Manager
Property Managers oversee the day-to-day operations of residential and commercial properties. They are responsible for managing the property's budget, leasing units, and maintaining the property's condition. This course can help enhance your ability to succeed as a Property Manager as it provides a solid foundation in real estate finance and modeling. By learning how to build dynamic models, you can gain a deeper understanding of how real estate projects perform financially.
Real Estate Appraiser
Real Estate Appraisers determine the value of real estate properties. They analyze market data, property characteristics, and other factors to come up with an accurate valuation. This course can provide you with a strong foundation in real estate finance and modeling as you embark on your career as a Real Estate Appraiser. By learning how to build dynamic models, you can analyze real estate projects and determine their value more effectively.
Asset Manager
Asset Managers oversee the day-to-day operations of commercial real estate properties. They are responsible for managing the property's budget, leasing units, and maintaining the property's condition. If you are considering a career as an Asset Manager, it is important to have a strong understanding of real estate finance and modeling. This course can help you develop these skills and position you for success in this role. Additionally, knowing how to utilize Excel to build dynamic models can help you become a more effective and efficient Asset Manager.
Investment Analyst
Investment Analysts study financial markets and companies to make recommendations on investments. They use their expertise to help investors make informed decisions about where to allocate their money. This course can help provide you with a foundation in financial modeling. As part of their role, Investment Analysts need to be prepared to build financial models and understand how to project future financial performance. The skills taught in this course may help you excel in this career path.
Financial Analyst
Financial Analysts provide expertise on a company's financial situation so that informed business decisions can be made. These professionals create financial models and conduct analyses to forecast future financial performance, evaluate investments, and make recommendations for business strategy. This course provides an understanding of real estate investment fundamentals and can help build a foundation in financial modeling that is relevant to Financial Analysts' work. Whether you are currently a professional in this role or an individual who aspires to be one, this course can help equip you with the necessary knowledge for success.
Project Manager
A Project Manager plans, organizes, and executes projects of all sizes, from small to large-scale developments. This position calls for tracking progress and managing all aspects of the project, ensuring that it is completed on time, on budget, and according to specifications. If you are seeking to excel as a Project Manager, you will need to know how to create detailed plans, allocate resources, and manage risk. With its emphasis on building models with dynamic projections, this course may be useful in helping you develop the foundational knowledge that Project Managers draw upon.

Reading list

We've selected six books that we think will supplement your learning. Use these to develop background knowledge, enrich your coursework, and gain a deeper understanding of the topics covered in The Real Estate Development Modeling Master Class.
This comprehensive guide to real estate development covers everything from market analysis and site selection to financing and construction. It is an essential resource for professionals in the field.
This comprehensive guide to real estate development is written by the experts at the Urban Land Institute. It covers all aspects of development, from planning and zoning to finance and construction.
Provides a comprehensive overview of real estate negotiation. It valuable resource for learners who want to learn about the different strategies and techniques involved in real estate negotiations.
Provides a comprehensive overview of the legal aspects of real estate. It valuable resource for learners who want to learn about the legal issues that can arise in real estate transactions.
This textbook provides a comprehensive overview of real estate finance and investment. It covers the key concepts and techniques used in the industry, and it includes case studies to illustrate their application.
Offers insights and advice from one of the world's most successful real estate developers. It valuable read for anyone interested in the industry, but it may be particularly inspiring for learners who are new to real estate.

Share

Help others find this course page by sharing it with your friends and followers:

Similar courses

Here are nine courses similar to The Real Estate Development Modeling Master Class.
The Advanced Real Estate Development Modeling Master Class
Most relevant
The Real Estate Pro Forma Modeling Master Class
Most relevant
The Advanced Real Estate Pro Forma Modeling Master Class
Most relevant
The Commercial Real Estate Lease Modeling Master Class
Most relevant
The Complete Guide To Multifamily Real Estate Investing
Most relevant
The Real Estate Financial Modeling Bootcamp
Most relevant
The Real Estate Equity Waterfall Modeling Master Class
Most relevant
The Commercial Real Estate Job Search Guide
Most relevant
Real Estate Asset Management 101
Most relevant
Our mission

OpenCourser helps millions of learners each year. People visit us to learn workspace skills, ace their exams, and nurture their curiosity.

Our extensive catalog contains over 50,000 courses and twice as many books. Browse by search, by topic, or even by career interests. We'll match you to the right resources quickly.

Find this site helpful? Tell a friend about us.

Affiliate disclosure

We're supported by our community of learners. When you purchase or subscribe to courses and programs or purchase books, we may earn a commission from our partners.

Your purchases help us maintain our catalog and keep our servers humming without ads.

Thank you for supporting OpenCourser.

© 2016 - 2024 OpenCourser