Case Study The Whole Life of the Project
- 02:16
This video copies workings forwards to all years in the model and checks integrity.
Downloads
No associated resources to download.
Glossary
modeling modelling Project finance RenewablesTranscript
We've got an intermediate step now as I mentioned, which is to copy the model forward.
If you've been doing this throughout, then great.
Hopefully everything's working fine.
I've copied forward from my annotation column forward all the way to the end of the project, and I'm just curious whether everything's still working.
Because there were a couple of interactions that went beyond my working area, which could have caused problems.
The first thing I've got in mind is that DSRA, because remember the way we structured it, I had a gap here and you can see the DSRA is going up and then eventually we don't need anything because there are no payments being anticipated.
I'm also interested in the debt itself.
You can see that the junior debt has a life of 18 years, and so it will disappear in the lifetime of the project.
And the senior debt has a life of 15 years, so it's long gone by the end of the project, and that's working fine.
We don't have this account ending up with minuses.
Now, the other accounts where that could happen are in the P&L.
We've got NOLs, which could end up with negative NOLs but doesn't because we've got a good min going there and we've got disallowed interest, which again, there's a small chance it could have gone through the floor as such.
So the fact it doesn't gives us a bit of happiness there.
Finally, we've got the CapEx account, excuse me, the PP&E account.
PP&E account was down here.
And remember we've got another min baked in there.
It's a long time ago now, so you may have forgotten about it, but that min effectively stops the account going below zero.
Now, because we've got a 20 year life, that cannot happen.
But say we would go another year, it still cannot happen because we've structured this nicely and that means that if we change our assumptions here, nothing falls apart.
So effectively a little bit of tidying up there, little tore through, making sure it still works.
In preparation for outputs, which are data tables effectively down here where we analyze the situation.