Youtube is a video-sharing platform that offers a wide variety of educational content, including lectures, tutorials, and courses on a wide range of subjects....
Description
This content covers the essential topic of modelling interest-only loans in Excel, a critical skill for investors and financial analysts working on commercial real estate deals. It delves into the specifics of creating a dynamic loan model that can be easily updated, allowing users to quickly adjust calculations without manually recalculating cash flows. The goal is to provide learners with a simple way to build out formulas that automatically account for interest-only debt structures, making it easier to analyse and compare different deal options. By mastering this skill, viewers will gain confidence in their ability to model complex financial scenarios and make informed investment decisions. The content assumes some basic knowledge of Excel, but provides step-by-step instructions for building the loan model from scratch. It is designed to be accessible to learners with varying levels of experience in commercial real estate financial modelling.
learn more