Case Study Modeling Debt - DSRA
- 03:02
This video builds a debt waterfall from EBITDA to ending cash.
Glossary
Debt DSRA modeling modelling Project finance RenewablesTranscript
Okay, so we are ready to do the debt service reserve account. We've been avoiding this for a while as we haven't had the information we needed to build it up. We met it for the first time quite early in the model. It was one of the areas where we needed cash, we needed funds, but we side-stepped it then and now we're back. The debt service reserve account represents another comfort blanket for the lenders. They're going to ask the project to set aside some cash and that cash will in this project, the assumption is gonna be to cover next year's mandatory debt and next year's interest payment. So you could summarize that as next year's debt service.
You can see why we've delayed doing this until now, because we haven't known the mandatory payments until this point. If we go and have a look, you can see we've got the senior, and if we carefully just grab next year because the account anticipates next year's payments, and then we do the same for junior and then we go and do the same for interest, we then sum it and pull it to the right. We should see things start to appear, and what you can see is we do have quite an awkward little error there. The debt service reserve account starts to be built up as it anticipates payments, and what will happen is the payments will start coming online when firstly the IDC period runs out, and then later on the grace period for the principal repayment runs out. And then we've got this final error. And it's really just because of the way I've set up the spreadsheet showing you the formula in the final column because it's going fetch something that's formatted as text. It's not very happy about that. Now, if you're building along with me, I'd suggest that you start building out all the way until the end of the year 20. What I'm gonna do is I'm gonna get rid of these so they don't come back and bug me later. Other formula may come and fetch from there, and then the whole thing could fall apart and we could get it a very awkward set of circular errors. And what I'll do is I'll highlight that so I know could come back to it later and fill it in when I'm pushing the model out all the way to year 20. Now, the debt service reserve account is going to be an allocation of cash. It's not an actual cash flow, it's an allocation of cash. Depending on your preference, you could decide this is cash, this should be positive. Or you could decide this is an allocation of cash that's coming from the cash after financing. So I'm happy with it as a negative. I'm gonna leave it as a negative, but I'm gonna keep in mind that this is not a cash flow.