From the course: Excel: Learning Cash Flow Forecasting
Join today to access over 24,600 courses taught by industry experts.
Challenge: Forecasting debt service with INDEX/XMATCH
From the course: Excel: Learning Cash Flow Forecasting
Challenge: Forecasting debt service with INDEX/XMATCH
(bright electronic music) - [Instructor] In this challenge, you're going to take debt service a step further. You'll borrow from modeling techniques we've covered throughout this course, and you'll decide which one makes the most sense to you. Now, in a prior lesson, we calculated loan payments, principle and interest on $1.185 million of construction and equipment loans. Now, it's time to connect the schedule to the Cashflow Forecast Model. In this challenge, it's up to you how you want to do this through functions and formulas of your choice. You may consider index and match, index and X match, X lookup, V lookup, or maybe something else. But think about what the purpose is to connect the supporting debt schedule to the cash flow. If and when the debt schedule gets updated, we want to ensure these figures get captured with 100% certainty in the Cashflow Forecast Model. Good luck.
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.