The Advanced Real Estate Financial Modeling Bootcamp
h264, yuv420p, 1280x720 |ENGLISH, aac, 48000 Hz, 2 channels | 10h 07 mn | 6.5 GB Created by: Justin Kivel The Complete Guide To Advanced Real Estate Financial Modeling For Real Estate Investment Professionals
What you'll learn The ability to model complex real estate investment scenarios in Microsoft Excel. A mastery of real estate financial modeling formulas, functions, and processes. The skill set to model development projects, major renovation projects, and complex debt and equity structures. The ability to manipulate data provided by sellers and brokers quickly and easily to arrive at more precise real estate valuations more efficiently. Requirements Access to Microsoft Excel for Mac or PC. An intermediate knowledge of real estate finance and financial modeling is recommended. A basic working knowledge of Microsoft Excel is recommended. Description Master real estate financial modeling. Advance your career. Make more money. If you're a current real estate professional looking to beef up your real estate financial modeling skill set, or you're looking to break into the real estate investment industry and want a leg up on your competition, you're in the right place. The Advanced Real Estate Financial Modeling Bootcamp will take you from a basic knowledge of real estate finance and Excel to an expert real estate financial modeler who can model complex real estate investment scenarios, whether you're looking to land a new job or do your first deal on your own. This course was built as a "playbook" that you can reference at any time. Need to model a construction loan? Check out the course. Modeling a hold/sell analysis? Log in again. Modeling a cash-out refinance after your renovation? Just check back into the class and follow the steps. There are a LOT of things that you'll be able to do after taking this course, including: Create dual-metric data tables to sensitize multiple investment return metrics in the same analysis Build a dynamic best/base/weak case analysis that automatically calculates returns based on your upside (and downside) scenarios of any deal Model a next-buyer analysis to precisely project sale proceeds at the end of a real estate investment Partition your IRR so you know what percentage of your returns are coming from cash flow and what percentage are coming from sale (and your risk based on both) Build a hold/sell analysis to calculate the optimal year to sell your property Build out construction loan draws, dynamic equity draws, and capitalized interest to accurately model your capital structure on ground-up development deals Model cash flow distributions on a monthly, quarterly, and annual basis (that can be switched at the press of a button). This course is perfect for you if: You're a college student or graduate student looking to break into the real estate investment industry 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 an existing real estate professional looking to advance your career, increase your compensation, and break into the real estate investment industry at a high level You've bought rental homes or duplexes, and now you're looking to buy larger commercial real estate properties and want to feel confident in your ability to analyze new deals Here's what some of our students have had to say: ★★★★★ "This course was definitely intense, but the information is invaluable. Justin does a great job explaining everything thoroughly and I've learned more about Excel in my past few courses than my entire life." ★★★★★ "Another great course by Justin. I found this to be the most difficult of all his courses, very advanced. The best part is the comprehensive case study at the end that really ties everything together well. I felt like I learned a lot." ★★★★★ "Loved this course. Justin's approach is very didactic and on point. If you have strong understanding of the basics in real estate finance, but don't know how to create a model, this course is for you. As Justin said, the secret to succeeding in this particular field is practice. Create the model again from scratch, go back to the solution file to make sure you get the right numbers." ★★★★★ "This was a fantastic course! Justin is very knowledgeable and explains all the concepts extremely well. I feel that this course has helped me very much and I am looking forward to continuing practicing the topics and improving on my skill set. I would highly recommend this course to anyone. Thank you Justin for the great work that you have put together." ★★★★★ "If you are a beginner to a veteran in CRE, and you've always wondered how to analyze an investment and the capital stack behind it, this is the only course you'll ever need. Justin Kivel does an excellent job of breaking down each of the considerations and explains them thoroughly. Thanks to Justin for putting out such a high-quality course!" If you understand the basics of real estate finance, and you're looking to take your real estate financial modeling skill set to an expert level, I'd love to have you join us. Looking forward to seeing you inside! 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.
Download link : (If you need these, buy and download immediately before they are delete)