Debt Capacity - Interest Adjustments
- 01:25
The steps required to balance the balance sheet, incorporate the interest calculations for a new bond, and update the income statement to reflect these changes.
Download a file of the data from the free downloads section, or access the live industry data in Felix.
Access the live industry data for Charles River Laboratories International here: https://felix.fe.training/company-analytics/?ticker=CRL&cik=0001100682
Transcript
Once we've got the balance sheet to balance, the final thing we've got to do is to add in the interest calculations for the new bond. So we need to go and grab the balance sheet values for that new bond. And then to calculate the interest expense, we've gotta pick up the interest rate from the assumptions, the 5.3%, which we then multiply by the average of the opening and closing balance for the year.
The final adjustment we then have to make is to make sure that this new interest expense is being picked up in the net interest expense that is going into the income statement. At the moment, we've only got the interest income on cash and the interest expense. So we also need to add into this the interest expense on the new bond and copy it across for every year. If we go back up to see how the income statement looks, after all this adjustments and analysis, you can see that at the moment the interest expense is zero, and this is because we currently have our switch off, so we can turn that on. And our little warning message tells us that we need to turn our iterative calculations on, which is entirely as you'd expect to do with a model like this.
And if we turn those iterations on, we can see that the interest numbers come through to the model, and the model is still working because our balance sheet check balance is still zero.