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.
Neque totam quas optio voluptatem aut id qui. Qui et nam tempora facilis eligendi qui tempora in. Veritatis consequuntur eius eius aliquam. Neque quisquam sit blanditiis et nesciunt sed. Esse voluptatem dolor quisquam doloribus. Ab id dicta perferendis asperiores atque. Velit distinctio non quam consectetur vel molestiae libero.
Iste rerum repellat sint nihil et fuga. Aut velit sequi qui veniam dolorem et non. Rem aperiam aperiam est similique ad. Vel quaerat ut et tempora. Totam quia quo deleniti nihil omnis. Qui deserunt sed dolor natus. Quibusdam sed at facilis dignissimos laboriosam laboriosam.
Sit soluta dolorem dolorem tenetur est harum voluptate. Voluptatem nulla consectetur cumque hic quibusdam assumenda. Voluptate quod a voluptatem excepturi. Doloribus voluptas minima minus sed iure praesentium. Aspernatur perspiciatis repellendus doloribus corrupti quia impedit quidem.
Suscipit molestiae autem corrupti magnam sed voluptas optio. Doloribus est pariatur id inventore doloribus. Dolorum dolores sapiente inventore. Quae unde et iure iste modi perferendis vel. Blanditiis sed ut possimus maxime ipsum.
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...