Modeling Case Study - Interest Calculations
- 02:12
Calculate the interest expense, interest income, and net interest for a financial model, using the average balance sheet numbers and the interest rate assumptions.
Transcript
Now we've completed the balance sheet and the income statement, we're finally able to start on the interest calculation and down at the bottom underneath the cashflow statement, we have the interest calculation. We've got three interest lines, interest expense on the revolver, interest expense on long-term debt, interest income on cash. We'll have assumptions or interest rates for each one of these items. And then we'll take the average of the balance sheet number. Always use averages for interest. So let's do the revolver first. I'll go up to the assumptions using the little navigator column on the left, and I'm gonna go down and get the interest rate on the revolver. And I'll multiply that by the average of last year and this year on the balance sheet for the revolver. And when I do this, it's not going to create circularity when we calculate the interest. I should also make that negative. So I might multiply it by minus 1 because we are not putting it on the income statement yet. Then I'll get the interest on long-term debt. And that's the 6% times the average of long-term debt on the balance sheet, multiplied by months one to make that negative.
And then finally do the interest on cash. And again, always using that navigation tool is going to really speed up your work. And this time we'll multiply it by the average of last year and this year's cash balance.
I don't need to multiply this by minus 1 because it's interest income. So I've got the individual interest lines and we're about ready to put them on the income statement.