January 2022

• Added a ‘Calculating Gross Returns vs. Net Returns’ section to the Adding GP Fees lesson in the Modeling Partnership Cash Flows course
• Created a ‘Calculating Gross Returns vs. Net Returns’ tutorial video
• By popular demand, we’ve replaced the old video intros and outtros with new and improved intros and outros
• Added custom case study thumbnails to each of the case study specific videos
• Added custom course thumbnails to each of the course introduction videos

November 2021

• Updated solution file for ‘Watch Me Solve a REPE Test’ tutorial; includes a few misc. fixes and improvements

June 2021

• Updated the forward rate curve file in the ‘Modeling Floating (Variable) Rate Debt‘ Advanced Concept module to May 29, 2021
• Added Floating Rate debt to Glossary
• Added Fixed Rate debt to Glossary
• Added Prepayment Penalty to Glossary
• Added Yield Maintenance to Glossary
• Created new Advanced Concept Module: ‘Mortgage Prepayment Fees, Including Yield Maintenance and Defeasance‘

May 2021

• Misc. server-side performance enhancements
• Instructions how to join the LinkedIn graduates group

April 2021

• Part I of the Definitive Guide to Microsoft Excel for Real Estate – The Functions That Matter added to the Library of Supplementary Tools
• Part II of the Definitive Guide to Microsoft Excel for Real Estate – The Features That Matter added to the Library of Supplementary Tools
• New case study: The Cellon Group – Real Estate Asset Management Analyst Test
• Added solution to ‘The Cellon Group – Real Estate Asset Management Analyst Test’
• New mini video tutorial added to the Library of Supplementary Tools with additional guidance for modeling complex, multi-partnership structures
• In response to forum question, created mini-video tutorial that talks through the discounted cash flow method for valuing real estate
• Added New Advanced Concept module: “Dynamically Forecasting Development Cash Flows”

December 2020

• Fixed link in course 1, lecture 2.2 to resource about cap rates
• Added ‘Certificate of Completion’ for Agent Candidate and MMCC Candidate curriculum tracks
• Added to the Guide to Getting Started, a link to the Definitive Guide to Microsoft Excel for Real Estate

November 2020

• Added ‘Modeling Variability in Income and Expense Line Items’ to Advanced Concepts in Real Estate Financial Modeling Module
• Added ‘Development Cash Flow: Creating a Steady Decrease Formula (Inverse to the Steady Growth Formula)’ to Advanced Concepts in Real Estate Financial Modeling Module
• Added ‘Altering The Development Model For Pari Passu Coverage of Development Costs Between Debt and Equity’ to Advanced Concepts in Real Estate Financial Modeling Module
• Added ‘Advanced Lender Risk Metrics – Duration and Average Life’ to Advanced Concepts in Real Estate Financial Modeling Module
• Added ‘Using Stochastic (Probabilistic) Analysis and Monte Carlo Simulations’ to Advanced Concepts in Real Estate Financial Modeling Module
• Added video on ‘How to Visualize an IRR Matrix Using Excel’s Charting Tools’ based on a forum post to the Library of Supplementary Learning Tools
• Added ‘The Definitive Guide to Microsoft Excel – The Functions That Matter’ to the Library of Supplementary Learning Tools
• Added to the Guide to Getting Started, a link to the Definitive Guide to Microsoft Excel for Real Estate

October 2020

• Added a complimentary download link to the A.CRE Geocoding Excel Add-in to the Library of Supplementary Tools
• Added mini video tutorial ‘Modeling Total Potential Gross Rent in Long-Term Leases‘ to the Library of Supplementary Tools
• Mini-tutorial added to Library of Supplementary Tools: Technique for Extending Analysis Period in an Existing Mode
• Video tutorial for extending analysis period added to Advanced Concept module ‘Modeling a Construction Loan Takeout‘
• Added mini video tutorial ‘XIRR Dynamic to Project Start Date’ to the Library of Supplementary Tools

September 2020

• Update to the core platform code to reduce load time between lectures
• Added How to Model CapEx Reserve Account to ‘Forum Post Videos’ section of the Library of Supplementary Tools
• Slight edit to question 3 in the Retail Income Statement Quiz, to make the question more clear
• Created tutorial for building Dynamic Portfolio (Fund) models in Advanced Concept module 1.8: Considerations in Portfolio-Level Modeling
• Added new Watch Me Build video to Library of Supplementary Tools: Partitioning an IRR and Equity Multiple
• Added new Case Study to Library of Supplementary Tools: Hamilton Park VIII: Industrial Development Residual Land Analysis
• Added solution file to Hamilton Park VIII Case Study
• Added solution video to Hamilton Park VIII Case Study

August 2020

• Framework for Modeling Bridge + Construction Loan added to the Library of Supplementary Tools
• Capital Stack with Customer Deposits added as Source added to the Library of Supplementary Tools
• Semi-Annual Compounding Debt and Amortization Exercise added to the Library of Supplementary Tools
• Calculating Monthly Hurdle Rate Using an Actual Month and 365 Day Year added to the Library of Supplementary Tools
• DCF Valuation Revisited – Solving for Present Value vs. Solving for IRR added to the Library of Supplementary Tools
• Modeling a Custom Rent Schedule added to the Library of Supplementary Tools
• Added new Watch Me Build module to Library: Watch Me Build – Capital Stack with Mezzanine Debt
• Added new Watch Me Build module to Library: Watch Me Build – American-Style Real Estate Equity Waterfall Model
• New Advanced Concept Module: Break Out Promote, Preferred Return, Excess Cash Flow, and Return of Capital Plus Separate Returns Before and After Fees
• New Advanced Concept Module: Modeling Variability in Income and Expense Line Items
• New Advanced Concept Module: Development Cash Flow: Creating a Steady Decrease Formula (Inverse to the Steady Growth Formula)
• New Advanced Concept Module: Altering The Development Model For Pari Passu Coverage of Development Costs Between Debt and Equity
• New Advanced Concept Module: Advanced Lender Risk Metrics – Duration and Average Life
• New Case Study: Renovo Tower – Office Acquisition
• New Case Study: Presidio – Apartment Acquisition
• New Case Study: Just the Facts – Retail Sale-Leaseback
• New Case Study: The Stones Hotel – Acquisition
• New Case Study: The Jefferson – Branded Condo Development
• New Case Study: Global REPE Firm – Apartment Acquisition
• Update lecture 2.3 of the Waterfall Modeling course to include a link to the new Advanced Concept course that expands the model built in lecture 2.3
• Added Instructor bios to the Guide to Getting Started to better introduce Spencer and Michael to new Accelerator members
• Added a ‘Troubleshooting Issues’ subsection to the ‘Add a Recalculate Button to Avoid Circular References‘ Advanced Concept module

February 2020

• Initial release