M&A: Using this data, please select one of the given answer choices for the following questions:

Q1) You are modeling a LBO transaction to close on 12/31/2016, which is being funded with the debt securities listed in the Excel file, with their expected repayment plans.

In 2017, the net change in Total Cash for the Balance Sheet will be:

• No change in cash
• 36.75 million decrease
• 113.250 million increase
• 109.250 decrease

Q2) Calculate the total revolver balance on 12/31/2021. You do not need data from Sections 2 and 4 to answer this question.

• 2,100,000,000
• 2,187,500,000
• 1,700,000,000
• 1,750,000,000
• 2,031,250,000

Q3) Calculate the subordinated note balance on 12/31/2021. You do not need data from Sections 2 and 4 to answer this question.

• 1,448,946,829
• 1,503,446,775
• 1,441,345,801
• 1,390,924,778
• 2,389,751,338

Q4) You only need data from Sections 1 and 4 to answer this question. What is the end of period cash balance on 12/31/2021?

• 440,844,228
• 100,899,353
• 262,786,401
• 0
• 160,055,125

Section 1 Current date 12/31/16 Table 1: 2017 Beginning debt Section 3