From the course: Excel: Learning Cash Flow Forecasting

Unlock this course with a free trial

Join today to access over 24,600 courses taught by industry experts.

Solution: Forecasting debt service with INDEX/XMATCH

Solution: Forecasting debt service with INDEX/XMATCH

From the course: Excel: Learning Cash Flow Forecasting

Start my 1-month free trial Buy for my team

Solution: Forecasting debt service with INDEX/XMATCH

“

(upbeat music) - [Instructor] All right. How did you do? In this challenge, you are faced with connecting the debt service schedule with the cashflow forecast model. You are to use a lookup of your choice to accomplish this with the ultimate goal of being completely confident that the figures from the financing schedule get captured and any update to the schedule makes its way into the forecast of the cash disbursements. Well over here we have our debt service schedule, and the area that I want to focus on is going to be column K and column O, right? Principle paid in cash, interest paid in cash. We don't want to focus on J because this is the accrual of the principle that we will pay in cash quarterly, and this is the accrual of the interest expense that we will be paying quarterly. Now, here's what I'm going to do. I'm going to go all the way over here to my cashflow forecast, and I'm going to focus our attention down here on line 38. I'm going to begin by going over to my debt…

Contents