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.

This to all my hatin' folks seeing me getting guac right now..
 

Itaque officia dolores sapiente ut minus sint. Reiciendis qui quia molestias eligendi.

Voluptatem error aut quia veritatis soluta blanditiis consectetur aut. Qui similique voluptas dolores veritatis reiciendis reiciendis. Maxime rerum qui voluptatem voluptatem fugit.

Dolor culpa repudiandae fugiat sunt laboriosam. Officia minus non unde ratione et in enim. Sequi voluptates dignissimos qui molestiae inventore praesentium. Vel corporis nihil quaerat nihil eum aut.

Excepturi aut quia rem labore quia quaerat. Officia et et voluptatem ducimus. Architecto unde quod et est.

Career Advancement Opportunities

March 2024 Investment Banking

  • Jefferies & Company 02 99.4%
  • Goldman Sachs 19 98.8%
  • Harris Williams & Co. (++) 98.3%
  • Lazard Freres 02 97.7%
  • JPMorgan Chase 03 97.1%

Overall Employee Satisfaction

March 2024 Investment Banking

  • Harris Williams & Co. 18 99.4%
  • JPMorgan Chase 10 98.8%
  • Lazard Freres 05 98.3%
  • Morgan Stanley 07 97.7%
  • William Blair 03 97.1%

Professional Growth Opportunities

March 2024 Investment Banking

  • Lazard Freres 01 99.4%
  • Jefferies & Company 02 98.8%
  • Goldman Sachs 17 98.3%
  • Moelis & Company 07 97.7%
  • JPMorgan Chase 05 97.1%

Total Avg Compensation

March 2024 Investment Banking

  • Director/MD (5) $648
  • Vice President (19) $385
  • Associates (86) $261
  • 3rd+ Year Analyst (13) $181
  • Intern/Summer Associate (33) $170
  • 2nd Year Analyst (66) $168
  • 1st Year Analyst (202) $159
  • Intern/Summer Analyst (144) $101
notes
16 IB Interviews Notes

“... there’s no excuse to not take advantage of the resources out there available to you. Best value for your $ are the...”

Leaderboard

1
redever's picture
redever
99.2
2
Betsy Massar's picture
Betsy Massar
99.0
3
Secyh62's picture
Secyh62
99.0
4
BankonBanking's picture
BankonBanking
99.0
5
DrApeman's picture
DrApeman
98.9
6
CompBanker's picture
CompBanker
98.9
7
dosk17's picture
dosk17
98.9
8
GameTheory's picture
GameTheory
98.9
9
kanon's picture
kanon
98.9
10
Jamoldo's picture
Jamoldo
98.8
success
From 10 rejections to 1 dream investment banking internship

“... I believe it was the single biggest reason why I ended up with an offer...”