Want to learn how to build professional, dynamic, institutional-quality commercial 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 commercial real estate development model that YOU'VE created - from scratch.
Read more
Want to learn how to build professional, dynamic, institutional-quality commercial 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 commercial real estate development model that YOU'VE created - from scratch.
Want to learn how to build professional, dynamic, institutional-quality commercial 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 commercial 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 commercial 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)
Build a "circuit-breaker" to automatically fix calculation errors in your model with a couple of clicks
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 about the class:
"Great course, amazing content made relatively simple, all thanks to Justin. Thank you for making these courses and spreading the knowledge of Real Estate Financial Modeling. Really Grateful."
"Very clear explanations. I like the repetition through the different examples to embed learning. It's also helpful to say which shortcuts you are doing so that this becomes second nature."
"Fantastic course, and just like with Justin's other courses: crammed with great content and hands-on application. No fluff. Just into the materials and the mechanics. This course is rather advanced, but it covers a lot of different techniques, methods, and concepts."
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.
13 deals to help you save
BFCMSALE24
BFCMSALE24
UDEAFNULP2024
What's inside
Learning objectives
- Learn how to build dynamic, institutional-grade real estate development models from scratch
- Learn how to create institutional, professionally formatted models to present development pro forma calculations to investors and partners
- 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 build a "circuit breaker" to automatically fix errors in your model quickly and easily
- Learn how to build dynamic, institutional-grade real estate development models from scratch
- Learn how to create institutional, professionally formatted models to present development pro forma calculations to investors and partners
- 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 build a "circuit breaker" to automatically fix errors in your model quickly and easily
Syllabus
Introduction
A Sneak Peek Into What You'll Build
The Summary Dashboard
The Commercial Leases Tab
Read more
Syllabus
Good to know
Save this course
Save
Activities
Organize and Review Course Materials
Show steps
Lay a strong foundation for your learning by organizing and reviewing the course materials, ensuring you have a solid grasp of the concepts before moving forward.
Show steps
-
Review the course syllabus and identify key topics and concepts.
-
Organize lecture notes, readings, and any additional materials provided.
Brush Up on Excel Skills
Show steps
Strengthen your Excel proficiency to enhance your ability to build and analyze real estate development models.
Browse courses on
Financial Modeling
Show steps
-
Review basic Excel functions and formulas.
-
Practice creating and formatting spreadsheets.
Connect with Real Estate Development Professionals
Show steps
Enhance your learning and gain valuable insights by connecting with experienced professionals in the real estate development industry.
Show steps
-
Attend industry events and conferences to network with potential mentors.
-
Reach out to professionals on LinkedIn and other platforms.
Six other activities
Expand to see all activities and additional details
Show all nine activities
Understand Core Real Estate Finance
Show steps
Review foundational concepts in real estate finance to refresh your knowledge and strengthen your understanding before the course begins.
Browse courses on
Real Estate Finance
Show steps
-
Review foundational concepts in real estate finance, including debt and equity financing, property valuation, and project feasibility analysis.
-
Attend an online webinar or seminar on commercial real estate development to enhance your foundational knowledge.
Read Investment Analysis
Show steps
Review foundational concepts in investment analysis to better prepare for building the institutional real estate models.
Show steps
-
Understand the fundamentals of investment analysis, including risk and return
-
Apply investment analysis techniques to evaluate real estate investment opportunities
-
Interpret financial statements and make informed investment decisions based on the analysis
Explore Commercial Real Estate Modeling in Practice
Show steps
Complement your learning with relevant tutorials and online resources to solidify your grasp of building dynamic real estate development models in Excel, enhancing your practical skills.
Browse courses on
Financial Modeling
Show steps
-
Follow online tutorials and demonstrations on real estate development modeling to familiarize yourself with the process.
-
Use Excel to build simple commercial real estate models to practice and apply your understanding.
Strengthen Development Model Construction Skills
Show steps
Engage in practical exercises and simulations to develop your proficiency in building and analyzing commercial real estate development models.
Browse courses on
Financial Modeling
Show steps
-
Complete practice exercises in the course materials to reinforce the concepts of building dynamic real estate development models.
-
Build a hypothetical commercial real estate development model from scratch to test your understanding of the process.
Create a Model Presentation
Show steps
Deepen your understanding of real estate development modeling by creating a comprehensive presentation of a hypothetical project, showcasing your ability to apply the concepts and communicate your findings effectively.
Browse courses on
Presentation Skills
Show steps
-
Develop a hypothetical commercial real estate development project.
-
Build a comprehensive financial model for the project using Excel.
-
Create a presentation that summarizes the project, the financial model, and your analysis.
Participate in Real Estate Modeling Competitions
Show steps
Test and enhance your real estate modeling skills by participating in competitions, allowing you to benchmark your abilities against others and gain valuable feedback.
Browse courses on
Financial Modeling
Show steps
-
Identify and research real estate modeling competitions.
-
Form a team and develop a compelling project proposal.
-
Build a comprehensive real estate development model and prepare a presentation.
-
Present your model and analysis to a panel of judges.
Organize and Review Course Materials
Show steps
Lay a strong foundation for your learning by organizing and reviewing the course materials, ensuring you have a solid grasp of the concepts before moving forward.
Show steps
- Review the course syllabus and identify key topics and concepts.
- Organize lecture notes, readings, and any additional materials provided.
Brush Up on Excel Skills
Show steps
Strengthen your Excel proficiency to enhance your ability to build and analyze real estate development models.
Browse courses on
Financial Modeling
Show steps
- Review basic Excel functions and formulas.
- Practice creating and formatting spreadsheets.
Connect with Real Estate Development Professionals
Show steps
Enhance your learning and gain valuable insights by connecting with experienced professionals in the real estate development industry.
Show steps
- Attend industry events and conferences to network with potential mentors.
- Reach out to professionals on LinkedIn and other platforms.
Understand Core Real Estate Finance
Show steps
Review foundational concepts in real estate finance to refresh your knowledge and strengthen your understanding before the course begins.
Browse courses on
Real Estate Finance
Show steps
- Review foundational concepts in real estate finance, including debt and equity financing, property valuation, and project feasibility analysis.
- Attend an online webinar or seminar on commercial real estate development to enhance your foundational knowledge.
Read Investment Analysis
Show steps
Review foundational concepts in investment analysis to better prepare for building the institutional real estate models.
Show steps
- Understand the fundamentals of investment analysis, including risk and return
- Apply investment analysis techniques to evaluate real estate investment opportunities
- Interpret financial statements and make informed investment decisions based on the analysis
Explore Commercial Real Estate Modeling in Practice
Show steps
Complement your learning with relevant tutorials and online resources to solidify your grasp of building dynamic real estate development models in Excel, enhancing your practical skills.
Browse courses on
Financial Modeling
Show steps
- Follow online tutorials and demonstrations on real estate development modeling to familiarize yourself with the process.
- Use Excel to build simple commercial real estate models to practice and apply your understanding.
Strengthen Development Model Construction Skills
Show steps
Engage in practical exercises and simulations to develop your proficiency in building and analyzing commercial real estate development models.
Browse courses on
Financial Modeling
Show steps
- Complete practice exercises in the course materials to reinforce the concepts of building dynamic real estate development models.
- Build a hypothetical commercial real estate development model from scratch to test your understanding of the process.
Create a Model Presentation
Show steps
Deepen your understanding of real estate development modeling by creating a comprehensive presentation of a hypothetical project, showcasing your ability to apply the concepts and communicate your findings effectively.
Browse courses on
Presentation Skills
Show steps
- Develop a hypothetical commercial real estate development project.
- Build a comprehensive financial model for the project using Excel.
- Create a presentation that summarizes the project, the financial model, and your analysis.
Participate in Real Estate Modeling Competitions
Show steps
Test and enhance your real estate modeling skills by participating in competitions, allowing you to benchmark your abilities against others and gain valuable feedback.
Browse courses on
Financial Modeling
Show steps
- Identify and research real estate modeling competitions.
- Form a team and develop a compelling project proposal.
- Build a comprehensive real estate development model and prepare a presentation.
- Present your model and analysis to a panel of judges.
Career center
Real Estate Developer
Real Estate Investment Manager
Real Estate Appraiser
Project Manager
Construction Manager
Private Equity Analyst
Real Estate Finance Analyst
Property Manager
Venture Capitalist
Market Research Analyst
Real Estate Analyst
Real Estate Broker
Financial Analyst
Data Analyst
Investment Banker
Reading list
Save
Share
Similar courses
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.
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.
