This OID is offered at deal inception. We can find it on the input tab and it was 12. Now, that issue of discount has to be amortized over time. So my beginning balance starts at 12, but I need to calculate that amortization. I want to take the minus minimum of, and I firstly want to calculate the amount that needs to be amortized. So I'm going to take that 12, I'm going to lock onto that, but I want to divide it by the number of years it's going to be amortized over. Now again, that's on our input tab, and that's going to be linked to the life of the debt. Again, I want to lock onto that. Now, I said I wanted the minus minimum. It's the minus minimum of that, and what? Well, I want the minus minimum of the amount we're amortizing or the beginning balance. It may be that our amortization comes in at 1.5, but our beginning balance is only maybe 0.5. It's because of the stub period at the beginning that that may happen. Now, at the moment, that gives me a figure of 1.3.

However, I'm in the stub period right now. I'm in the three months, so I don't want a whole year of amortization. Instead, I just want three months worth. I'm going to multiply this by the post-deal percent, i.e., how long did we own the company after the deal where we only owned it for 25% of that year, the three months afterwards? Great, that gets me three months worth of amortization. My ending balance is then the sum of the two items above. Now, I just need to be careful when I copy this to the right, because I've still got that nor 0.3. I've still got that post deal percent happening here, and let me just reveal more of the formula up at the top. There's that post deal percent. So from column J onwards, when I own the company for the whole of the year, I want to delete out that post deal percent. That will be the case for lots of income statement items, including interest. As we copy this to the right, all the way to column T, let's just check what's happened. So each period, I'm taking the minus minimum of the 1.3 or beginning balance, that's fine. But when we get into column R, we can see the minus minimum of 1.3 or the beginning balance, it reverts to the beginning balance. So only the beginning balance is paid off, getting us down to a nice tidy zero.