Refinancing debt in the debt schedule
Assume the model in question is a basic 3 statement operating model.
In the debt schedule you've already taken
Opening cash balance + net cash flows for repaying debt (from the CFS ~ CFO+CFI+CFF excl. change to debt)
Once that flows through your RCF and other debt obligations, let's say you want to build a facility for a complete re-fi of ALL existing Long term debt - what's the best way to go about it so that you can simply build a "yes" / "no" switch to either re-fi all the debt or not
I was toying with the idea and tried building it out but faced a couple of issues or quandries the only way I could think of doing it was to have a separate BASE analysis (like a waterfall) for each of the projection years....
If someone has a better example / idea please let me know
You could build out another debt scenario in a separate tab and have your 'switch' basically decide which tab to pull from. If you upload the doc I'd be happy to take a look at it.
Quasi nostrum recusandae quaerat quaerat error consequatur et. Iure sed tempora error dolores nostrum reprehenderit iste. Eligendi ipsam veniam odio.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...