This question uses the same file as the previous question. You do not need data from Sections 2 and 4 to answer this question. Calculate the total revolver balance on 12/31/2021. 2,100,000,000 2,187,500,000 1,700,000,000 1,750,000,000 2,031,250,000 Section 1 Current date 12/31/2016 Table 1: 2017 Beginning debt Revolver Term Loan B Term Loan C 1st Lien Bonds 2nd Lien Bonds Subordinated note Amount Amount 7 750,000,000 Libor +300 basis points with 1 1,500,000,000 Libor +300 basis points with 1 4,000,000,000 Libor +375 basis points with 1 2,000,000,0005% annual coupon (paid at yea 1,250,000,0006.5% annual coupon (paid at y 2,000,000,0007.25%50% as PIK, 50% in cas Term (years) . Assume all interest is calculated off beginning of year balances Assume a cash balance on 12/31/2016 of 0 Treatment of excess cash If there is a cash surplus after making all required principal p[ayments, The company decided that any excess cash generated will go to pay down the Term Loan C first. if there's anything left over, it will go to pay down term loan B (above and beyond the required prinicipal paydown). If there's anything left over, it will go to pay down the revolver. Should the revolver get fully paid down, cash will accumulate. Treatment of cash shortfall IF cash is insufficient to meet required payments, the revolver will be tapped to fund the required principal payments Section 2 2017 Projections EBITDA D\&A Capital expenditures Tax rate LIBOR (bps) Section 3 Section 3 Cash from operations, less investing activities 4,000,000,000 1,500,000,000 2,600,000,000 40% 49 Assume interest expense is already taken into account in the cash from operations illustrated here. This question uses the same file as the previous question. You do not need data from Sections 2 and 4 to answer this question. Calculate the total revolver balance on 12/31/2021. 2,100,000,000 2,187,500,000 1,700,000,000 1,750,000,000 2,031,250,000 Section 1 Current date 12/31/2016 Table 1: 2017 Beginning debt Revolver Term Loan B Term Loan C 1st Lien Bonds 2nd Lien Bonds Subordinated note Amount Amount 7 750,000,000 Libor +300 basis points with 1 1,500,000,000 Libor +300 basis points with 1 4,000,000,000 Libor +375 basis points with 1 2,000,000,0005% annual coupon (paid at yea 1,250,000,0006.5% annual coupon (paid at y 2,000,000,0007.25%50% as PIK, 50% in cas Term (years) . Assume all interest is calculated off beginning of year balances Assume a cash balance on 12/31/2016 of 0 Treatment of excess cash If there is a cash surplus after making all required principal p[ayments, The company decided that any excess cash generated will go to pay down the Term Loan C first. if there's anything left over, it will go to pay down term loan B (above and beyond the required prinicipal paydown). If there's anything left over, it will go to pay down the revolver. Should the revolver get fully paid down, cash will accumulate. Treatment of cash shortfall IF cash is insufficient to meet required payments, the revolver will be tapped to fund the required principal payments Section 2 2017 Projections EBITDA D\&A Capital expenditures Tax rate LIBOR (bps) Section 3 Section 3 Cash from operations, less investing activities 4,000,000,000 1,500,000,000 2,600,000,000 40% 49 Assume interest expense is already taken into account in the cash from operations illustrated here