For interest calculation, the first thing we need to do is work out how many interest calculations we need to do. Well, we've got short-term borrowings, we've then got three different types of long-term debt, and then we've got the cash and short-term investments. So that's five interest calculations to do. I'm gonna start by putting the interest rate for our short term borrowings in. If I scroll up, I can find my interest rate assumptions. And here, it is 4.5 %. Done. I'm going to do all of the interest rates before I do the interest calculations so now I'm doing my term loan, then I move on to the bonds, then I move on to the last term loan, and then finally, the interest rate on cash and short-term investments. Great. Now let's do the interest calculation on the short-term borrowings first. Well, I'm going to take the 4.5% rate and multiply that by the average of the beginning and the ending short-term borrowings. Because it's a little bit easier in Excel, what I'm going to do is I'm actually gonna take the average of last year's short-term borrowings and this year's short-term borrowings, so the cells are right next to each other. And that gets me a figure of 117.6. Now that same formula structure, I can just copy that with Ctrl + C and paste it into the term loan, Ctrl + V. I can see that has worked perfectly. I want to copy that same formula down to the bonds interest, the last term loan's interest, and for the interest income on cash and cash equivalents. That's given me 992 of interest income. I just want to total up all of the interest expense items and I'm going to do that in row 217. So let's sum them up. Remember, I've got four different types of debts, so I start with the interest expense on short-term borrowings, then I add in the interest expense on the term loan, and on the bonds, and on the second term loan.

Getting me to a figure of 1,730.6 of interest expense.