Main Model - Wiring Up the Debt Lines
- 01:43
Modeling a large project finance model - debt schedule
Glossary
Debt Schedule modeling Project financeTranscript
Now we're ready to link up our deadlines into the balance sheet. Let's begin with our revolving credit facility. We can get this number from the finance tab in our model that the ending balance in the first construction year would be 0. And if we copy this to the right, see that the entire forecast of our ending balance here is 0 because we don't use that facility in this projection.
The next line will be our syndicated loan. So let's get that balance from our finance tab. The ending balance in our first year is 263.7. Let's copy that to the right.
And at this point, we should see our balance sheet still balanced during the construction year as well as the operational period. But what's more interesting is that if we go to the cashflow statement, we'll now see that our cash balance is no longer negative. In fact, it is 0 during the first two construction years, and it turns positive at the end of the third construction year or at the end of the construction phase. And that is because we've built up a debt service reserve fund into our cash balance, which is equal to 338.3. So this is telling us that the model works. We've already linked up the deadlines, and our debt service reserve fund is in our balance sheet.