Equity Excel essay paper
Equity Excel
ORDER A PLAGIARISM FREE PAPER NOW
Don't use plagiarized sources. Get Your Custom Essay on
Equity Excel essay paper
Just from $15/Page
TS
ValueCo Corporation | |||||||||||||||||
Leveraged Buyout Analysis | Financing Structure: | Structure 1 | |||||||||||||||
($ in millions, fiscal year ending December 31) | Operating Scenario: | Base | |||||||||||||||
Transaction Summary | |||||||||||||||||
SourcesEquity Excel of Funds | Uses of Funds | Purchase Price | Return Analysis | ||||||||||||||
% of Total | Multiple of EBITDA | % of Total | Offer Price per Share | -0 | Exit Year | 2017 | |||||||||||
Amount | Sources | 9/30/2012 | Cumulative | Pricing | Amount | Uses | Fully Diluted Shares | -0 | Entry Multiple | 8.0x | |||||||
Revolving Credit Facility | -0 | – % | – x | – x | L+425 bps | Purchase ValueCo Equity | $4,350.0 | 72.5% | Equity Purchase Price | $4,350.0 | Exit Multiple | 8.0x | |||||
Term Loan A | -0 | – % | – x | – x | NA | Repay Existing Debt | 1,500.0 | 25.0% | Plus: Existing Net Debt | 1,250.0 | IRR | 20% | |||||
Term Loan B | 2,150.0 | 35.8% | 3.1x | 3.1x | L+450 bps | Tender / Call Premiums | 20.0 | 0.3% | Enterprise Value | $5,600.0 | Cash Return | 2.5x | |||||
Term Loan CEquity Excel | -0 | – % | – x | 3.1x | NA | Financing Fees | 90.0 | 1.5% | |||||||||
2nd Lien | -0 | – % | – x | 3.1x | NA | Other Fees and Expenses | 40.0 | 0.7% | Transaction Multiples | Options | |||||||
Senior Notes | 1,500.0 | 25.0% | 2.1x | 5.2x | 8.500% | Enterprise Value / Sales | Financing Structure | 1 | |||||||||
Senior Subordinated Notes | -0 | – % | – x | 5.2x | NA | LTM 9/30/2012 | $3,385.0 | 1.7x | Operating Scenario | 1 | |||||||
Equity Contribution | 2,100.0 | 35.0% | 3.0x | 8.2x | 2012E | 3,450.0 | 1.6x | Cash Flow Sweep | 1 | ||||||||
Rollover Equity | -0 | – % | – x | 8.2x | Enterprise Value / EBITDA | Cash Balance | 1 | ||||||||||
Cash on Hand | 250.0 | 4.2% | 0.4x | 8.6x | LTM 9/30/2012 | $700.0 | 8.0x | Average Interest | 1 | ||||||||
Total Sources | $6,000.0 | 100.0% | 8.6x | 8.6x | Total Uses | $6,000.0 | 100.0% | 2012E | 725.0 | 7.7x | Financing Fees | 1 | |||||
Summary Financial Data | |||||||||||||||||
Historical Period | Projection Period | ||||||||||||||||
LTM | Pro forma | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Year 6 | Year 7 | Year 8 | Year 9 | Year 10 | ||||||
2009 | 2010 | 2011 | 9/30/2012 | 2012 | 2013 | 2014 | 2015 | 2016 | 2017 | 2018 | 2019 | 2020 | 2021 | 2022 | |||
Sales | $2,600.0 | $2,900.0 | $3,200.0 | $3,385.0 | $3,450.0 | $3,708.8 | $3,931.3 | $4,127.8 | $4,293.0 | $4,421.7 | $4,554.4 | $4,691.0 | $4,831.8 | $4,976.7 | $5,126.0 | ||
% growth | NA | 11.5% | 10.3% | NA | 7.8% | 7.5% | 6.0% | 5.0% | 4.0% | 3.0% | 3.0% | 3.0% | 3.0% | 3.0% | 3.0% | ||
Gross Profit | $988.0 | $1,131.0 | $1,280.0 | $1,350.0 | $1,380.0 | $1,483.5 | $1,572.5 | $1,651.1 | $1,717.2 | $1,768.7 | $1,821.8 | $1,876.4 | $1,932.7 | $1,990.7 | $2,050.4 | ||
% margin | 38.0% | 39.0% | 40.0% | 39.9% | 40.0% | 40.0% | 40.0% | 40.0% | 40.0% | 40.0% | 40.0% | 40.0% | 40.0% | 40.0% | 40.0% | ||
EBITDAEquity Excel | $491.4 | $580.0 | $672.0 | $700.0 | $725.0 | $779.4 | $826.1 | $867.4 | $902.1 | $929.2 | $957.1 | $985.8 | $1,015.4 | $1,045.8 | $1,077.2 | ||
% margin | 18.9% | 20.0% | 21.0% | 20.7% | 21.0% | 21.0% | 21.0% | 21.0% | 21.0% | 21.0% | 21.0% | 21.0% | 21.0% | 21.0% | 21.0% | ||
Capital Expenditures | 136.4 | 114.0 | 144.0 | 152.3 | 155.3 | 166.9 | 176.9 | 185.8 | 193.2 | 199.0 | 204.9 | 211.1 | 217.4 | 224.0 | 230.7 | ||
% sales | 5.2% | 3.9% | 4.5% | 4.5% | 4.5% | 4.5% | 4.5% | 4.5% | 4.5% | 4.5% | 4.5% | 4.5% | 4.5% | 4.5% | 4.5% | ||
Cash Interest Expense | 252.5 | 246.6 | 233.8 | 218.8 | 201.7 | 182.8 | 163.7 | 141.2 | 128.9 | 128.9 | 128.9 | ||||||
Total Interest Expense | 263.9 | 258.0 | 245.1 | 230.1 | 213.1 | 194.2 | 175.0 | 151.9 | 135.0 | 128.9 | 128.9 | ||||||
Free Cash Flow | |||||||||||||||||
EBITDA | $779.4 | $826.1 | $867.4 | $902.1 | $929.2 | $957.1 | $985.8 | $1,015.4 | $1,045.8 | $1,077.2 | |||||||
Less: Cash Interest Expense | (246.6) | (233.8) | (218.8) | (201.7) | (182.8) | (163.7) | (141.2) | (128.9) | (128.9) | (128.9) | |||||||
Plus: Interest IncomeEquity Excel | -0 | -0 | -0 | -0 | -0 | -0 | 0.0 | 1.1 | 3.2 | 5.4 | |||||||
Less: Income Taxes | (113.6) | (131.2) | (148.1) | (164.0) | (178.5) | (193.3) | (209.9) | (224.8) | (236.2) | (245.5) | |||||||
Less: Capital Expenditures | (166.9) | (176.9) | (185.8) | (193.2) | (199.0) | (204.9) | (211.1) | (217.4) | (224.0) | (230.7) | |||||||
Less: Increase in Net Working Capital | (47.6) | (41.0) | (36.2) | (30.4) | (23.7) | (24.4) | (25.1) | (25.9) | (26.7) | (27.5) | |||||||
Free Cash Flow | $204.6 | $243.3 | $278.7 | $312.9 | $345.2 | $370.7 | $398.4 | $419.4 | $433.3 | $450.0 | |||||||
Cumulative Free Cash Flow | 204.6 | 448.0 | 726.7 | 1,039.5 | 1,384.7 | 1,755.4 | 2,153.8 | 2,573.2 | 3,006.5 | 3,456.6 | |||||||
Capitalization | |||||||||||||||||
Cash | -0 | -0 | -0 | -0 | -0 | -0 | -0 | $3.8 | $423.2 | $856.5 | $1,306.6 | ||||||
Revolving Credit Facility | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | ||||||
Term Loan A | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | ||||||
Term Loan B | 2,150.0 | 1,945.4 | 1,702.0 | 1,423.3 | 1,110.5 | 765.3 | 394.6 | -0 | -0 | -0 | -0 | ||||||
Term Loan C | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | ||||||
Existing Term Loan | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | ||||||
2nd Lien | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | ||||||
Other Debt | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | ||||||
Total Senior Secured Debt | $2,150.0 | $1,945.4 | $1,702.0 | $1,423.3 | $1,110.5 | $765.3 | $394.6 | -0 | -0 | -0 | -0 | ||||||
Senior Notes | 1,500.0 | 1,500.0 | 1,500.0 | 1,500.0 | 1,500.0 | 1,500.0 | 1,500.0 | 1,500.0 | 1,500.0 | 1,500.0 | 1,500.0 | ||||||
Total Senior Debt | $3,650.0 | $3,445.4 | $3,202.0 | $2,923.3 | $2,610.5 | $2,265.3 | $1,894.6 | $1,500.0 | $1,500.0 | $1,500.0 | $1,500.0 | ||||||
Senior SubordinatedEquity Excel Notes | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | ||||||
Total Debt | $3,650.0 | $3,445.4 | $3,202.0 | $2,923.3 | $2,610.5 | $2,265.3 | $1,894.6 | $1,500.0 | $1,500.0 | $1,500.0 | $1,500.0 | ||||||
Shareholders’ Equity | 2,040.0 | 2,225.3 | 2,439.3 | 2,680.9 | 2,948.4 | 3,239.7 | 3,555.1 | 3,897.6 | 4,264.4 | 4,649.7 | 5,050.4 | ||||||
Total Capitalization | $5,690.0 | $5,670.7 | $5,641.3 | $5,604.3 | $5,558.9 | $5,505.0 | $5,449.8 | $5,397.6 | $5,764.4 | $6,149.7 | $6,550.4 | ||||||
% of Bank Debt Repaid | -0 | 9.5% | 20.8% | 33.8% | 48.3% | 64.4% | 81.6% | 100.0% | 100.0% | 100.0% | 100.0% | ||||||
Credit Statistics | |||||||||||||||||
% Debt / Total Capitalization | 64.1% | 60.8% | 56.8% | 52.2% | 47.0% | 41.1% | 34.8% | 27.8% | 26.0% | 24.4% | 22.9% | ||||||
EBITDA / Cash Interest Expense | 2.9x | 3.2x | 3.5x | 4.0x | 4.5x | 5.1x | 5.8x | 7.0x | 7.9x | 8.1x | 8.4x | ||||||
(EBITDA – Capex) / Cash Interest Expense | 2.3x | 2.5x | 2.8x | 3.1x | 3.5x | 4.0x | 4.6x | 5.5x | 6.2x | 6.4x | 6.6x | ||||||
EBITDA / Total Interest Expense | 2.7x | 3.0x | 3.4x | 3.8x | 4.2x | 4.8x | 5.5x | 6.5x | 7.5x | 8.1x | 8.4x | ||||||
(EBITDA – Capex) / Total Interest Expense | 2.2x | 2.4x | 2.6x | 3.0x | 3.3x | 3.8x | 4.3x | 5.1x | 5.9x | 6.4x | 6.6x | ||||||
Senior Secured Debt / EBITDA | 3.0x | 2.5x | 2.1x | 1.6x | 1.2x | 0.8x | 0.4x | – x | – x | – x | – x | ||||||
Senior Debt / EBITDA | 5.0x | 4.4x | 3.9x | 3.4x | 2.9x | 2.4x | 2.0x | 1.5x | 1.5x | 1.4x | 1.4x | ||||||
Total Debt / EBITDA | 5.0x | 4.4x | 3.9x | 3.4x | 2.9x | 2.4x | 2.0x | 1.5x | 1.5x | 1.4x | 1.4x | ||||||
Net Debt / EBITDAEquity Excel | 5.0x | 4.4x | 3.9x | 3.4x | 2.9x | 2.4x | 2.0x | 1.5x | 1.1x | 0.6x | 0.2x |
IS
($ in millions, fiscal year ending December 31) | ||||||||||||||||||
Income Statement | ||||||||||||||||||
Historical Period | Projection Period | |||||||||||||||||
LTM | Pro forma | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Year 6 | Year 7 | Year 8 | Year 9 | Year 10 | |||||||
2009 | 2010 | 2011 | 9/30/2012 | 2012 | 2013 | 2014 | 2015 | 2016 | 2017 | 2018 | 2019 | 2020 | 2021 | 2022 | ||||
Sales | $2,600.0 | $2,900.0 | $3,200.0 | $3,385.0 | $3,450.0 | $3,708.8 | $3,931.3 | $4,127.8 | $4,293.0 | $4,421.7 | $4,554.4 | $4,691.0 | $4,831.8 | $4,976.7 | $5,126.0 | |||
% growth | NA | 11.5% | 10.3% | NA | 7.8% | 7.5% | 6.0% | 5.0% | 4.0% | 3.0% | 3.0% | 3.0% | 3.0% | 3.0% | 3.0% | |||
Cost of Goods Sold | 1,612.0 | 1,769.0 | 1,920.0 | 2,035.0 | 2,070.0 | 2,225.3 | 2,358.8 | 2,476.7 | 2,575.8 | 2,653.0 | 2,732.6 | 2,814.6 | 2,899.1 | 2,986.0 | 3,075.6 | |||
Gross Profit | $988.0 | $1,131.0 | $1,280.0 | $1,350.0 | $1,380.0 | $1,483.5 | $1,572.5 | $1,651.1 | $1,717.2 | $1,768.7 | $1,821.8 | $1,876.4 | $1,932.7 | $1,990.7 | $2,050.4 | |||
% margin | 38.0% | 39.0% | 40.0% | 39.9% | 40.0% | 40.0% | 40.0% | 40.0% | 40.0% | 40.0% | 40.0% | 40.0% | 40.0% | 40.0% | 40.0% | |||
Selling, General & Administrative | 496.6 | 551.0 | 608.0 | 650.0 | 655.0 | 704.1 | 746.4 | 783.7 | 815.0 | 839.5 | 864.7 | 890.6 | 917.3 | 944.9 | 973.2 | |||
% sales | 19.1% | 19.0% | 19.0% | 19.2% | 19.0% | 19.0% | 19.0% | 19.0% | 19.0% | 19.0% | 19.0% | 19.0% | 19.0% | 19.0% | 19.0% | |||
Other Expense / (Income) | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | |||
EBITDA | $491.4 | $580.0 | $672.0 | $700.0 | $725.0 | $779.4 | $826.1 | $867.4 | $902.1 | $929.2 | $957.1 | $985.8 | $1,015.4 | $1,045.8 | $1,077.2 | |||
% margin | 18.9% | 20.0% | 21.0% | 20.7% | 21.0% | 21.0% | 21.0% | 21.0% | 21.0% | 21.0% | 21.0% | 21.0% | 21.0% | 21.0% | 21.0% | |||
Depreciation | 116.0 | 121.5 | 145.0 | 150.0 | 155.3 | 166.9 | 176.9 | 185.8 | 193.2 | 199.0 | 204.9 | 211.1 | 217.4 | 224.0 | 230.7 | |||
Amortization | 39.0 | 43.5 | 48.0 | 50.0 | 51.8 | 55.6 | 59.0 | 61.9 | 64.4 | 66.3 | 68.3 | 70.4 | 72.5 | 74.7 | 76.9 | |||
EBIT | $336.4 | $415.0 | $479.0 | $500.0 | $518.0 | $556.9 | $590.3 | $619.8 | $644.6 | $663.9 | $683.8 | $704.3 | $725.5 | $747.2 | $769.6 | |||
% margin | 12.9% | 14.3% | 15.0% | 14.8% | 15.0% | 15.0% | 15.0% | 15.0% | 15.0% | 15.0% | 15.0% | 15.0% | 15.0% | 15.0% | 15.0% | |||
Interest Expense | ||||||||||||||||||
Revolving Credit Facility | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | |||||||
Term Loan A | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | |||||||
Term Loan B | 123.6 | 117.7 | 104.9 | 89.9 | 72.8 | 53.9 | 34.8 | 12.3 | -0 | -0 | -0 | |||||||
Term Loan C | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | |||||||
Existing Term Loan | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | |||||||
2nd Lien | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | |||||||
Senior Notes | 127.5 | 127.5 | 127.5 | 127.5 | 127.5 | 127.5 | 127.5 | 127.5 | 127.5 | 127.5 | 127.5 | |||||||
Senior Subordinated Notes | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | |||||||
Commitment Fee on Unused Revolver | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | |||||||
Administrative Agent Fee | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | |||||||
Cash Interest Expense | $252.5 | $246.6 | $233.8 | $218.8 | $201.7 | $182.8 | $163.7 | $141.2 | $128.9 | $128.9 | $128.9 | |||||||
Amortization of Deferred Financing Fees | 11.3 | 11.3 | 11.3 | 11.3 | 11.3 | 11.3 | 11.3 | 10.7 | 6.1 | -0 | -0 | |||||||
Total Interest Expense | $263.9 | $258.0 | $245.1 | $230.1 | $213.1 | $194.2 | $175.0 | $151.9 | $135.0 | $128.9 | $128.9 | |||||||
Interest Income | -0 | -0 | -0 | -0 | -0 | -0 | (0.0) | (1.1) | (3.2) | (5.4) | ||||||||
Net Interest Expense | $258.0 | $245.1 | $230.1 | $213.1 | $194.2 | $175.0 | $151.9 | $133.9 | $125.7 | $123.5 | ||||||||
Earnings Before Taxes | 298.9 | 345.2 | 389.7 | 431.5 | 469.7 | 508.8 | 552.4 | 591.5 | 621.5 | 646.2 | ||||||||
Income Tax Expense | 113.6 | 131.2 | 148.1 | 164.0 | 178.5 | 193.3 | 209.9 | 224.8 | 236.2 | 245.5 | ||||||||
Net Income | $185.3 | $214.0 | $241.6 | $267.5 | $291.2 | $315.5 | $342.5 | $366.8 | $385.3 | $400.6 | ||||||||
% margin | 5.0% | 5.4% | 5.9% | 6.2% | 6.6% | 6.9% | 7.3% | 7.6% | 7.7% | 7.8% | ||||||||
Income Statement Assumptions | ||||||||||||||||||
Sales (% YoY growth) | NA | 11.5% | 10.3% | NA | 7.8% | 7.5% | 6.0% | 5.0% | 4.0% | 3.0% | 3.0% | 3.0% | 3.0% | 3.0% | 3.0% | |||
Cost of Goods Sold (% margin) | 62.0% | 61.0% | 60.0% | 60.1% | 60.0% | 60.0% | 60.0% | 60.0% | 60.0% | 60.0% | 60.0% | 60.0% | 60.0% | 60.0% | 60.0% | |||
SG&A (% sales) | 19.1% | 19.0% | 19.0% | 19.2% | 19.0% | 19.0% | 19.0% | 19.0% | 19.0% | 19.0% | 19.0% | 19.0% | 19.0% | 19.0% | 19.0% | |||
Other Expense / (Income) (% of sales) | – % | – % | – % | – % | – % | – % | – % | – % | – % | – % | – % | – % | – % | – % | – % | |||
Depreciation (% of sales) | 4.5% | 4.2% | 4.5% | 4.4% | 4.5% | 4.5% | 4.5% | 4.5% | 4.5% | 4.5% | 4.5% | 4.5% | 4.5% | 4.5% | 4.5% | |||
Amortization (% of sales) | 1.5% | 1.5% | 1.5% | 1.5% | 1.5% | 1.5% | 1.5% | 1.5% | 1.5% | 1.5% | 1.5% | 1.5% | 1.5% | 1.5% | 1.5% | |||
Interest Income | 0.5% | 0.5% | 0.5% | 0.5% | 0.5% | 0.5% | 0.5% | 0.5% | 0.5% | 0.5% | 0.5% | |||||||
Tax Rate | 38.0% | 38.0% | 38.0% | 38.0% | 38.0% | 38.0% | 38.0% | 38.0% | 38.0% | 38.0% |
BS
($ in millions, fiscal year ending December 31) | |||||||||||||||||
Balance Sheet | |||||||||||||||||
Projection Period | |||||||||||||||||
Opening | Adjustments | Pro Forma | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Year 6 | Year 7 | Year 8 | Year 9 | Year 10 | |||||
2012 | + | – | 2012 | 2013 | 2014 | 2015 | 2016 | 2017 | 2018 | 2019 | 2020 | 2021 | 2022 | ||||
Cash and Cash Equivalents | $250.0 | (250.0) | -0 | -0 | -0 | -0 | -0 | -0 | -0 | $3.8 | $423.2 | $856.5 | $1,306.6 | ||||
Accounts Receivable | 450.0 | 450.0 | 483.8 | 512.8 | 538.4 | 560.0 | 576.7 | 594.1 | 611.9 | 630.2 | 649.1 | 668.6 | |||||
Inventories | 600.0 | 600.0 | 645.0 | 683.7 | 717.9 | 746.6 | 769.0 | 792.1 | 815.8 | 840.3 | 865.5 | 891.5 | |||||
Prepaids and Other Current Assets | 175.0 | 175.0 | 188.1 | 199.4 | 209.4 | 217.8 | 224.3 | 231.0 | 238.0 | 245.1 | 252.4 | 260.0 | |||||
Total Current Assets | $1,475.0 | $1,225.0 | $1,316.9 | $1,395.9 | $1,465.7 | $1,524.3 | $1,570.0 | $1,617.1 | $1,669.4 | $2,138.8 | $2,623.6 | $3,126.7 | |||||
Property, Plant and Equipment, net | 2,500.0 | 2,500.0 | 2,500.0 | 2,500.0 | 2,500.0 | 2,500.0 | 2,500.0 | 2,500.0 | 2,500.0 | 2,500.0 | 2,500.0 | 2,500.0 | |||||
Goodwill | 1,000.0 | 1,850.0 | (1,000.0) | 1,850.0 | 1,850.0 | 1,850.0 | 1,850.0 | 1,850.0 | 1,850.0 | 1,850.0 | 1,850.0 | 1,850.0 | 1,850.0 | 1,850.0 | |||
Intangible Assets | 875.0 | 875.0 | 819.4 | 760.4 | 698.5 | 634.1 | 567.8 | 499.4 | 429.1 | 356.6 | 282.0 | 205.1 | |||||
Other Assets | 150.0 | 150.0 | 150.0 | 150.0 | 150.0 | 150.0 | 150.0 | 150.0 | 150.0 | 150.0 | 150.0 | 150.0 | |||||
Deferred Financing Fees | -0 | 90.0 | 90.0 | 78.7 | 67.3 | 56.0 | 44.7 | 33.4 | 22.0 | 11.3 | 5.2 | 5.2 | 5.2 | ||||
Total Assets | $6,000.0 | $6,690.0 | $6,714.9 | $6,723.6 | $6,720.2 | $6,703.1 | $6,671.2 | $6,638.6 | $6,609.9 | $7,000.7 | $7,410.8 | $7,837.0 | |||||
Accounts Payable | 215.0 | 215.0 | 231.1 | 245.0 | 257.2 | 267.5 | 275.6 | 283.8 | 292.3 | 301.1 | 310.1 | 319.4 | |||||
Accrued Liabilities | 275.0 | 275.0 | 295.6 | 313.4 | 329.0 | 342.2 | 352.5 | 363.0 | 373.9 | 385.1 | 396.7 | 408.6 | |||||
Other Current Liabilities | 100.0 | 100.0 | 107.5 | 114.0 | 119.6 | 124.4 | 128.2 | 132.0 | 136.0 | 140.1 | 144.3 | 148.6 | |||||
Total Current Liabilities | $590.0 | $590.0 | $634.3 | $672.3 | $705.9 | $734.2 | $756.2 | $778.9 | $802.2 | $826.3 | $851.1 | $876.6 | |||||
Revolving Credit Facility | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | |||||
Term Loan A | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | |||||
Term Loan B | -0 | 2,150.0 | 2,150.0 | 1,945.4 | 1,702.0 | 1,423.3 | 1,110.5 | 765.3 | 394.6 | -0 | -0 | -0 | -0 | ||||
Term Loan C | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | |||||
Existing Term Loan | 1,000.0 | (1,000.0) | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | ||||
2nd Lien | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | |||||
Senior Notes | -0 | 1,500.0 | 1,500.0 | 1,500.0 | 1,500.0 | 1,500.0 | 1,500.0 | 1,500.0 | 1,500.0 | 1,500.0 | 1,500.0 | 1,500.0 | 1,500.0 | ||||
Existing Senior Notes | 500.0 | (500.0) | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | ||||
Senior Subordinated Notes | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | |||||
Other Debt | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | |||||
Deferred Income Taxes | 300.0 | 300.0 | 300.0 | 300.0 | 300.0 | 300.0 | 300.0 | 300.0 | 300.0 | 300.0 | 300.0 | 300.0 | |||||
Other Long-Term Liabilities | 110.0 | 110.0 | 110.0 | 110.0 | 110.0 | 110.0 | 110.0 | 110.0 | 110.0 | 110.0 | 110.0 | 110.0 | |||||
Total Liabilities | $2,500.0 | $4,650.0 | $4,489.6 | $4,284.3 | $4,039.3 | $3,754.6 | $3,431.5 | $3,083.5 | $2,712.2 | $2,736.3 | $2,761.1 | $2,786.6 | |||||
Noncontrolling Interest | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | |||||
Shareholders’ Equity | 3,500.0 | 2,040.0 | (3,500.0) | 2,040.0 | 2,225.3 | 2,439.3 | 2,680.9 | 2,948.4 | 3,239.7 | 3,555.1 | 3,897.6 | 4,264.4 | 4,649.7 | 5,050.4 | |||
Total Shareholders’ Equity | $3,500.0 | $2,040.0 | $2,225.3 | $2,439.3 | $2,680.9 | $2,948.4 | $3,239.7 | $3,555.1 | $3,897.6 | $4,264.4 | $4,649.7 | $5,050.4 | |||||
Total Liabilities and Equity | $6,000.0 | $6,690.0 | $6,714.9 | $6,723.6 | $6,720.2 | $6,703.1 | $6,671.2 | $6,638.6 | $6,609.9 | $7,000.7 | $7,410.8 | $7,837.0 | |||||
Balance Check | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | |||||
Net Working Capital | 635.0 | 635.0 | 682.6 | 723.6 | 759.8 | 790.2 | 813.9 | 838.3 | 863.4 | 889.3 | 916.0 | 943.5 | |||||
(Increase) / Decrease in Net Working Capital | (47.6) | (41.0) | (36.2) | (30.4) | (23.7) | (24.4) | (25.1) | (25.9) | (26.7) | (27.5) | |||||||
Balance Sheet Assumptions | |||||||||||||||||
Current Assets | |||||||||||||||||
Days Sales Outstanding (DSO) | 47.6 | 47.6 | 47.6 | 47.6 | 47.6 | 47.6 | 47.6 | 47.6 | 47.6 | 47.6 | 47.6 | 47.6 | |||||
Days Inventory Held (DIH) | 105.8 | 105.8 | 105.8 | 105.8 | 105.8 | 105.8 | 105.8 | 105.8 | 105.8 | 105.8 | 105.8 | 105.8 | |||||
Prepaid and Other Current Assets (% of sales) | 5.1% | 5.1% | 5.1% | 5.1% | 5.1% | 5.1% | 5.1% | 5.1% | 5.1% | 5.1% | 5.1% | 5.1% | |||||
Current Liabilities | |||||||||||||||||
Days Payable Outstanding (DPO) | 37.9 | 37.9 | 37.9 | 37.9 | 37.9 | 37.9 | 37.9 | 37.9 | 37.9 | 37.9 | 37.9 | 37.9 | |||||
Accrued Liabilities (% of sales) | 8.0% | 8.0% | 8.0% | 8.0% | 8.0% | 8.0% | 8.0% | 8.0% | 8.0% | 8.0% | 8.0% | 8.0% | |||||
Other Current Liabilities (% of sales) | 2.9% | 2.9% | 2.9% | 2.9% | 2.9% | 2.9% | 2.9% | 2.9% | 2.9% | 2.9% | 2.9% | 2.9% |
CF
($ in millions, fiscal year ending December 31) | ||||||||||||||
Cash Flow Statement | ||||||||||||||
Projection Period | ||||||||||||||
Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Year 6 | Year 7 | Year 8 | Year 9 | Year 10 | |||||
2013 | 2014 | 2015 | 2016 | 2017 | 2018 | 2019 | 2020 | 2021 | 2022 | |||||
Operating Activities | ||||||||||||||
Net Income | $185.3 | $214.0 | $241.6 | $267.5 | $291.2 | $315.5 | $342.5 | $366.8 | $385.3 | $400.6 | ||||
Plus: Depreciation | 166.9 | 176.9 | 185.8 | 193.2 | 199.0 | 204.9 | 211.1 | 217.4 | 224.0 | 230.7 | ||||
Plus: Amortization | 55.6 | 59.0 | 61.9 | 64.4 | 66.3 | 68.3 | 70.4 | 72.5 | 74.7 | 76.9 | ||||
Plus: Amortization of Financing Fees | 11.3 | 11.3 | 11.3 | 11.3 | 11.3 | 11.3 | 10.7 | 6.1 | -0 | -0 | ||||
Changes in Working Capital Items | ||||||||||||||
(Inc.) / Dec. in Accounts Receivable | (33.8) | (29.0) | (25.6) | (21.5) | (16.8) | (17.3) | (17.8) | (18.4) | (18.9) | (19.5) | ||||
(Inc.) / Dec. in Inventories | (45.0) | (38.7) | (34.2) | (28.7) | (22.4) | (23.1) | (23.8) | (24.5) | (25.2) | (26.0) | ||||
(Inc.) / Dec. in Prepaid and Other Current Assets | (13.1) | (11.3) | (10.0) | (8.4) | (6.5) | (6.7) | (6.9) | (7.1) | (7.4) | (7.6) | ||||
Inc. / (Dec.) in Accounts Payable | 16.1 | 13.9 | 12.2 | 10.3 | 8.0 | 8.3 | 8.5 | 8.8 | 9.0 | 9.3 | ||||
Inc. / (Dec.) in Accrued Liabilities | 20.6 | 17.7 | 15.7 | 13.2 | 10.3 | 10.6 | 10.9 | 11.2 | 11.6 | 11.9 | ||||
Inc. / (Dec.) in Other Current Liabilities | 7.5 | 6.5 | 5.7 | 4.8 | 3.7 | 3.8 | 4.0 | 4.1 | 4.2 | 4.3 | ||||
(Inc.) / Dec. in Net Working Capital | (47.6) | (41.0) | (36.2) | (30.4) | (23.7) | (24.4) | (25.1) | (25.9) | (26.7) | (27.5) | ||||
Cash Flow from Operating Activities | $371.5 | $420.3 | $464.4 | $506.0 | $544.2 | $575.6 | $609.5 | $636.8 | $657.3 | $680.7 | ||||
Investing Activities | ||||||||||||||
Capital Expenditures | (166.9) | (176.9) | (185.8) | (193.2) | (199.0) | (204.9) | (211.1) | (217.4) | (224.0) | (230.7) | ||||
Other Investing Activities | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | ||||
Cash Flow from Investing Activities | ($166.9) | ($176.9) | ($185.8) | ($193.2) | ($199.0) | ($204.9) | ($211.1) | ($217.4) | ($224.0) | ($230.7) | ||||
Financing Activities | ||||||||||||||
Revolving Credit Facility | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | ||||
Term Loan A | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | ||||
Term Loan B | (204.6) | (243.3) | (278.7) | (312.9) | (345.2) | (370.7) | (394.6) | -0 | -0 | -0 | ||||
Term Loan C | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | ||||
Existing Term Loan | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | ||||
2nd Lien | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | ||||
Senior Notes | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | ||||
Senior Subordinated Notes | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | ||||
Other Debt | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | ||||
Dividends | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | ||||
Equity Issuance / (Repurchase) | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | ||||
Cash Flow from Financing Activities | ($204.6) | ($243.3) | ($278.7) | ($312.9) | ($345.2) | ($370.7) | ($394.6) | -0 | -0 | -0 | ||||
Excess Cash for the Period | -0 | -0 | -0 | -0 | -0 | -0 | $3.8 | $419.4 | $433.3 | $450.0 | ||||
Beginning Cash Balance | -0 | -0 | -0 | -0 | -0 | -0 | -0 | 3.8 | 423.2 | 856.5 | ||||
Ending Cash Balance | -0 | -0 | -0 | -0 | -0 | -0 | $3.8 | $423.2 | $856.5 | $1,306.6 | ||||
Cash Flow Statement Assumptions | ||||||||||||||
Capital Expenditures (% of sales) | 4.5% | 4.5% | 4.5% | 4.5% | 4.5% | 4.5% | 4.5% | 4.5% | 4.5% | 4.5% |
DS
($ in millions, fiscal year ending December 31) | ||||||||||||||
Debt Schedule | ||||||||||||||
Projection Period | ||||||||||||||
Pro forma | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Year 6 | Year 7 | Year 8 | Year 9 | Year 10 | ||||
2012 | 2013 | 2014 | 2015 | 2016 | 2017 | 2018 | 2019 | 2020 | 2021 | 2022 | ||||
Forward LIBOR Curve | 0.25% | 0.35% | 0.50% | 0.75% | 1.00% | 1.25% | 1.50% | 1.75% | 2.00% | 2.25% | 2.50% | |||
Cash Flow from Operating Activities | $371.5 | $420.3 | $464.4 | $506.0 | $544.2 | $575.6 | $609.5 | $636.8 | $657.3 | $680.7 | ||||
Cash Flow from Investing Activities | (166.9) | (176.9) | (185.8) | (193.2) | (199.0) | (204.9) | (211.1) | (217.4) | (224.0) | (230.7) | ||||
Cash Available for Debt Repayment | $204.6 | $243.3 | $278.7 | $312.9 | $345.2 | $370.7 | $398.4 | $419.4 | $433.3 | $450.0 | ||||
Total Mandatory Repayments | MinCash | (21.5) | (21.5) | (21.5) | (21.5) | (21.5) | (21.5) | (21.5) | -0 | -0 | -0 | |||
Cash From Balance Sheet | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | 3.8 | 423.2 | 856.5 | |||
Cash Available for Optional Debt Repayment | $183.1 | $221.8 | $257.2 | $291.4 | $323.7 | $349.2 | $376.9 | $423.2 | $856.5 | $1,306.6 | ||||
Revolving Credit Facility | ||||||||||||||
Revolving Credit Facility Size | $250.0 | |||||||||||||
Spread | 4.250% | |||||||||||||
LIBOR Floor | 1.250% | |||||||||||||
Term | 6 years | |||||||||||||
Commitment Fee on Unused Portion | 0.50% | |||||||||||||
Beginning Balance | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | ||||
Drawdown/(Repayment) | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | ||||
Ending Balance | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | ||||
Interest Rate | 5.50% | 5.50% | 5.50% | 5.50% | 5.50% | 5.75% | 6.00% | 6.25% | 6.50% | 6.75% | ||||
Interest Expense | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | ||||
Commitment Fee | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | ||||
Administrative Agent Fee | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | ||||
Term Loan A Facility | ||||||||||||||
Size | -0 | |||||||||||||
Spread | – % | |||||||||||||
Term | 0 years | |||||||||||||
Repayment Schedule | – % | – % | – % | – % | – % | 100.0% | ||||||||
Beginning Balance | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | ||||
Mandatory Repayments | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | ||||
Optional Repayments | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | ||||
Ending Balance | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | ||||
Interest Rate | 0.35% | 0.50% | 0.75% | 1.00% | 1.25% | 1.50% | 1.75% | 2.00% | 2.25% | 2.50% | ||||
Interest Expense | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | ||||
Term Loan B Facility | ||||||||||||||
Size | $2,150.0 | |||||||||||||
Spread | 4.500% | |||||||||||||
LIBOR Floor | 1.250% | |||||||||||||
Term | 7 years | |||||||||||||
Repayment Schedule | 1.0% | Per Annum, Bullet at Maturity | ||||||||||||
Beginning Balance | $2,150.0 | $1,945.4 | $1,702.0 | $1,423.3 | $1,110.5 | $765.3 | $394.6 | -0 | -0 | -0 | ||||
Mandatory Repayments | (21.5) | (21.5) | (21.5) | (21.5) | (21.5) | (21.5) | (21.5) | -0 | -0 | -0 | ||||
Optional Repayments | (183.1) | (221.8) | (257.2) | (291.4) | (323.7) | (349.2) | (373.1) | -0 | -0 | -0 | ||||
Ending Balance | $1,945.4 | $1,702.0 | $1,423.3 | $1,110.5 | $765.3 | $394.6 | -0 | -0 | -0 | -0 | ||||
Interest Rate | 5.75% | 5.75% | 5.75% | 5.75% | 5.75% | 6.00% | 6.25% | 6.50% | 6.75% | 7.00% | ||||
Interest Expense | 117.7 | 104.9 | 89.9 | 72.8 | 53.9 | 34.8 | 12.3 | -0 | -0 | -0 | ||||
Term Loan C Facility | ||||||||||||||
Size | -0 | |||||||||||||
Spread | – % | |||||||||||||
LIBOR Floor | – % | |||||||||||||
Term | 0 years | |||||||||||||
Repayment Schedule | – % | Per Annum, Bullet at Maturity | ||||||||||||
Beginning Balance | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | ||||
Mandatory Repayments | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | ||||
Optional Repayments | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | ||||
Ending Balance | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | ||||
Interest Rate | 0.35% | 0.50% | 0.75% | 1.00% | 1.25% | 1.50% | 1.75% | 2.00% | 2.25% | 2.50% | ||||
Interest Expense | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | ||||
Existing Term Loan Facility | ||||||||||||||
Size | -0 | |||||||||||||
Spread | – % | |||||||||||||
LIBOR Floor | – % | |||||||||||||
Remaining Term | 0 years | |||||||||||||
Repayment Schedule | – % | Per Annum, Bullet at Maturity | ||||||||||||
Beginning Balance | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | ||||
Mandatory Repayments | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | ||||
Optional Repayments | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | ||||
Ending Balance | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | ||||
Interest Rate | 0.35% | 0.50% | 0.75% | 1.00% | 1.25% | 1.50% | 1.75% | 2.00% | 2.25% | 2.50% | ||||
Interest Expense | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | ||||
2nd Lien | ||||||||||||||
Size | -0 | |||||||||||||
Spread | – % | |||||||||||||
LIBOR Floor | – % | |||||||||||||
Term | 0 years | |||||||||||||
Beginning Balance | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | ||||
Repayment | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | ||||
Ending Balance | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | ||||
Interest Rate | 0.35% | 0.50% | 0.75% | 1.00% | 1.25% | 1.50% | 1.75% | 2.00% | 2.25% | 2.50% | ||||
Interest Expense | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | ||||
Senior Notes | ||||||||||||||
Size | $1,500.0 | |||||||||||||
Coupon | 8.500% | |||||||||||||
Term | 8 years | |||||||||||||
Beginning Balance | $1,500.0 | $1,500.0 | $1,500.0 | $1,500.0 | $1,500.0 | $1,500.0 | $1,500.0 | $1,500.0 | $1,500.0 | $1,500.0 | ||||
Repayment | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | ||||
Ending Balance | $1,500.0 | $1,500.0 | $1,500.0 | $1,500.0 | $1,500.0 | $1,500.0 | $1,500.0 | $1,500.0 | $1,500.0 | $1,500.0 | ||||
Interest Expense | 127.5 | 127.5 | 127.5 | 127.5 | 127.5 | 127.5 | 127.5 | 127.5 | 127.5 | 127.5 | ||||
Senior Subordinated Notes | ||||||||||||||
Size | -0 | |||||||||||||
Coupon | – % | |||||||||||||
Term | 0 years | |||||||||||||
Beginning Balance | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | ||||
Repayment | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | ||||
Ending Balance | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | ||||
Interest Expense | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 |
RA
($ in millions, fiscal year ending December 31) | |||||||||||||||
Returns Analysis | |||||||||||||||
Projection Period | |||||||||||||||
Pro forma | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Year 6 | Year 7 | Year 8 | Year 9 | Year 10 | |||||
2012 | 2013 | 2014 | 2015 | 2016 | 2017 | 2018 | 2019 | 2020 | 2021 | 2022 | |||||
Entry EBITDA Multiple | 8.0x | ||||||||||||||
Initial Equity Investment | $2,100.0 | ||||||||||||||
EBITDA | $779.4 | $826.1 | $867.4 | $902.1 | $929.2 | $957.1 | $985.8 | $1,015.4 | $1,045.8 | $1,077.2 | |||||
Exit EBITDA Multiple | 8.0x | ||||||||||||||
Enterprise Value at Exit | $6,235.0 | $6,609.1 | $6,939.6 | $7,217.1 | $7,433.7 | $7,656.7 | $7,886.4 | $8,123.0 | $8,366.6 | $8,617.6 | |||||
Less: Net Debt | |||||||||||||||
Revolving Credit Facility | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | |||||
Term Loan A | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | |||||
Term Loan B | 1,945.4 | 1,702.0 | 1,423.3 | 1,110.5 | 765.3 | 394.6 | -0 | -0 | -0 | -0 | |||||
Term Loan C | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | |||||
Existing Term Loan | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | |||||
2nd Lien | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | |||||
Senior Notes | 1,500.0 | 1,500.0 | 1,500.0 | 1,500.0 | 1,500.0 | 1,500.0 | 1,500.0 | 1,500.0 | 1,500.0 | 1,500.0 | |||||
Senior Subordinated Notes | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | |||||
Other Debt | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | |||||
Total Debt | $3,445.4 | $3,202.0 | $2,923.3 | $2,610.5 | $2,265.3 | $1,894.6 | $1,500.0 | $1,500.0 | $1,500.0 | $1,500.0 | |||||
Less: Cash and Cash Equivalents | -0 | -0 | -0 | -0 | -0 | -0 | 3.8 | 423.2 | 856.5 | 1,306.6 | |||||
Net Debt | $3,445.4 | $3,202.0 | $2,923.3 | $2,610.5 | $2,265.3 | $1,894.6 | $1,496.2 | $1,076.8 | $643.5 | $193.4 | |||||
Equity Value at Exit | $2,789.6 | $3,407.1 | $4,016.2 | $4,606.7 | $5,168.4 | $5,762.0 | $6,390.2 | $7,046.2 | $7,723.2 | $8,424.2 | |||||
Cash Return | 1.3x | 1.6x | 1.9x | 2.2x | 2.5x | 2.7x | 3.0x | 3.4x | 3.7x | 4.0x | |||||
Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Year 6 | Year 7 | Year 8 | Year 9 | Year 10 | ||||||
2013 | 2014 | 2015 | 2016 | 2017 | 2018 | 2019 | 2020 | 2021 | 2022 | ||||||
Initial Equity Investment | ($2,100.0) | ($2,100.0) | ($2,100.0) | ($2,100.0) | ($2,100.0) | ($2,100.0) | ($2,100.0) | ($2,100.0) | ($2,100.0) | ($2,100.0) | |||||
Equity Proceeds | $2,789.6 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | |||||
$3,407.1 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | |||||||
$4,016.2 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | ||||||||
$4,606.7 | -0 | -0 | -0 | -0 | -0 | -0 | |||||||||
$5,168.4 | -0 | -0 | -0 | -0 | -0 | ||||||||||
$5,762.0 | -0 | -0 | -0 | -0 | |||||||||||
$6,390.2 | -0 | -0 | -0 | ||||||||||||
$7,046.2 | -0 | -0 | |||||||||||||
$7,723.2 | -0 | ||||||||||||||
$8,424.2 | |||||||||||||||
IRR | 32.8% | 27.4% | 24.1% | 21.7% | 19.7% | 18.3% | 17.2% | 16.3% | 15.6% | 14.9% | |||||
IRR – Assuming Exit in 2017E | IRR – Assuming 8.0x Entry Multiple | ||||||||||||||
Exit Multiple | Exit Year | ||||||||||||||
19.7% | 7.0x | 7.5x | 8.0x | 8.5x | 9.0x | 2015 | 2016 | 2017 | 2018 | 2019 | |||||
6.0x | 43.4% | 46.4% | 49.2% | 51.7% | 54.2% | 24.1% | 21.7% | 19.7% | 18.3% | 17.2% | |||||
7.0x | 24.8% | 27.4% | 29.9% | 32.1% | 34.2% | 7.0x | 14.5% | 15.2% | 15.1% | 14.8% | 14.5% | ||||
Entry | 7.5x | 19.4% | 21.9% | 24.2% | 26.3% | 28.4% | Exit | 7.5x | 19.5% | 18.6% | 17.5% | 16.6% | 15.9% | ||
Multiple | 8.0x | 15.1% | 17.5% | 19.7% | 21.8% | 23.8% | Multiple | 8.0x | 24.1% | 21.7% | 19.7% | 18.3% | 17.2% | ||
8.5x | 11.6% | 13.9% | 16.1% | 18.1% | 20.0% | 8.5x | 28.4% | 24.6% | 21.8% | 19.9% | 18.5% | ||||
9.0x | 8.6% | 10.9% | 13.0% | 15.0% | 16.8% | 9.0x | 32.5% | 27.3% | 23.8% | 21.4% | 19.7% | ||||
IRR – Assuming Exit in 2017E | |||||||||||||||
Exit Multiple | |||||||||||||||
19.7% | 7.00x | 7.25x | 7.50x | 7.75x | 8.00x | 8.25x | 8.50x | ||||||||
7.00x | 24.8% | 26.1% | 27.4% | 28.7% | 29.9% | 31.0% | 32.1% | ||||||||
7.25x | 21.9% | 23.2% | 24.5% | 25.7% | 26.8% | 27.9% | 29.0% | ||||||||
7.50x | 19.4% | 20.6% | 21.9% | 23.0% | 24.2% | 25.3% | 26.3% | ||||||||
Entry | 7.75x | 17.1% | 18.4% | 19.6% | 20.7% | 21.8% | 22.9% | 24.0% | |||||||
Multiple | 8.00x | 15.1% | 16.3% | 17.5% | 18.6% | 19.7% | 20.8% | 21.8% | |||||||
8.25x | 13.3% | 14.5% | 15.6% | 16.8% | 17.8% | 18.9% | 19.9% | ||||||||
8.50x | 11.6% | 12.8% | 13.9% | 15.0% | 16.1% | 17.1% | 18.1% |
A1
Assumptions Page 1 – Income Statement and Cash Flow Statement | ||||||||||||||
Projection Period | ||||||||||||||
Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Year 6 | Year 7 | Year 8 | Year 9 | Year 10 | |||||
2013 | 2014 | 2015 | 2016 | 2017 | 2018 | 2019 | 2020 | 2021 | 2022 | |||||
Income Statement Assumptions | ||||||||||||||
Sales (% growth) | 7.5% | 6.0% | 5.0% | 4.0% | 3.0% | 3.0% | 3.0% | 3.0% | 3.0% | 3.0% | ||||
Base | 1 | 7.5% | 6.0% | 5.0% | 4.0% | 3.0% | 3.0% | 3.0% | 3.0% | 3.0% | 3.0% | |||
Sponsor | 2 | 10.0% | 8.0% | 6.0% | 4.0% | 3.0% | 3.0% | 3.0% | 3.0% | 3.0% | 3.0% | |||
Management | 3 | 12.0% | 10.0% | 8.0% | 6.0% | 4.0% | 4.0% | 4.0% | 4.0% | 4.0% | 4.0% | |||
Downside 1 | 4 | 5.0% | 4.0% | 3.0% | 3.0% | 3.0% | 3.0% | 3.0% | 3.0% | 3.0% | 3.0% | |||
Downside 2 | 5 | 2.0% | 2.0% | 2.0% | 2.0% | 2.0% | 2.0% | 2.0% | 2.0% | 2.0% | 2.0% | |||
Cost of Goods Sold (% sales) | 60.0% | 60.0% | 60.0% | 60.0% | 60.0% | 60.0% | 60.0% | 60.0% | 60.0% | 60.0% | ||||
Base | 1 | 60.0% | 60.0% | 60.0% | 60.0% | 60.0% | 60.0% | 60.0% | 60.0% | 60.0% | 60.0% | |||
Sponsor | 2 | 60.0% | 60.0% | 60.0% | 60.0% | 60.0% | 60.0% | 60.0% | 60.0% | 60.0% | 60.0% | |||
Management | 3 | 59.0% | 59.0% | 59.0% | 59.0% | 59.0% | 59.0% | 59.0% | 59.0% | 59.0% | 59.0% | |||
Downside 1 | 4 | 61.0% | 61.0% | 61.0% | 61.0% | 61.0% | 61.0% | 61.0% | 61.0% | 61.0% | 61.0% | |||
Downside 2 | 5 | 62.0% | 62.0% | 62.0% | 62.0% | 62.0% | 62.0% | 62.0% | 62.0% | 62.0% | 62.0% | |||
SG&A (% sales) | 19.0% | 19.0% | 19.0% | 19.0% | 19.0% | 19.0% | 19.0% | 19.0% | 19.0% | 19.0% | ||||
Base | 1 | 19.0% | 19.0% | 19.0% | 19.0% | 19.0% | 19.0% | 19.0% | 19.0% | 19.0% | 19.0% | |||
Sponsor | 2 | 18.0% | 18.0% | 18.0% | 18.0% | 18.0% | 18.0% | 18.0% | 18.0% | 18.0% | 18.0% | |||
Management | 3 | 18.0% | 18.0% | 18.0% | 18.0% | 18.0% | 18.0% | 18.0% | 18.0% | 18.0% | 18.0% | |||
Downside 1 | 4 | 20.0% | 20.0% | 20.0% | 20.0% | 20.0% | 20.0% | 20.0% | 20.0% | 20.0% | 20.0% | |||
Downside 2 | 5 | 21.0% | 21.0% | 21.0% | 21.0% | 21.0% | 21.0% | 21.0% | 21.0% | 21.0% | 21.0% | |||
Other Expense / (Income) (% of sales) | – % | – % | – % | – % | – % | – % | – % | – % | – % | – % | ||||
Base | 1 | – % | – % | – % | – % | – % | – % | – % | – % | – % | – % | |||
Sponsor | 2 | – % | – % | – % | – % | – % | – % | – % | – % | – % | – % | |||
Management | 3 | – % | – % | – % | – % | – % | – % | – % | – % | – % | – % | |||
Downside 1 | 4 | – % | – % | – % | – % | – % | – % | – % | – % | – % | – % | |||
Downside 2 | 5 | – % | – % | – % | – % | – % | – % | – % | – % | – % | – % | |||
Depreciation (% sales) | 4.5% | 4.5% | 4.5% | 4.5% | 4.5% | 4.5% | 4.5% | 4.5% | 4.5% | 4.5% | ||||
Base | 1 | 4.5% | 4.5% | 4.5% | 4.5% | 4.5% | 4.5% | 4.5% | 4.5% | 4.5% | 4.5% | |||
Sponsor | 2 | 4.5% | 4.5% | 4.5% | 4.5% | 4.5% | 4.5% | 4.5% | 4.5% | 4.5% | 4.5% | |||
Management | 3 | 4.5% | 4.5% | 4.5% | 4.5% | 4.5% | 4.5% | 4.5% | 4.5% | 4.5% | 4.5% | |||
Downside 1 | 4 | 4.5% | 4.5% | 4.5% | 4.5% | 4.5% | 4.5% | 4.5% | 4.5% | 4.5% | 4.5% | |||
Downside 2 | 5 | 4.5% | 4.5% | 4.5% | 4.5% | 4.5% | 4.5% | 4.5% | 4.5% | 4.5% | 4.5% | |||
Amortization (% sales) | 1.5% | 1.5% | 1.5% | 1.5% | 1.5% | 1.5% | 1.5% | 1.5% | 1.5% | 1.5% | ||||
Base | 1 | 1.5% | 1.5% | 1.5% | 1.5% | 1.5% | 1.5% | 1.5% | 1.5% | 1.5% | 1.5% | |||
Sponsor | 2 | 1.5% | 1.5% | 1.5% | 1.5% | 1.5% | 1.5% | 1.5% | 1.5% | 1.5% | 1.5% | |||
Management | 3 | 1.5% | 1.5% | 1.5% | 1.5% | 1.5% | 1.5% | 1.5% | 1.5% | 1.5% | 1.5% | |||
Downside 1 | 4 | 1.5% | 1.5% | 1.5% | 1.5% | 1.5% | 1.5% | 1.5% | 1.5% | 1.5% | 1.5% | |||
Downside 2 | 5 | 1.5% | 1.5% | 1.5% | 1.5% | 1.5% | 1.5% | 1.5% | 1.5% | 1.5% | 1.5% | |||
Interest Income | 0.5% | 0.5% | 0.5% | 0.5% | 0.5% | 0.5% | 0.5% | 0.5% | 0.5% | 0.5% | ||||
Base | 1 | 0.5% | 0.5% | 0.5% | 0.5% | 0.5% | 0.5% | 0.5% | 0.5% | 0.5% | 0.5% | |||
Sponsor | 2 | 0.5% | 0.5% | 0.5% | 0.5% | 0.5% | 0.5% | 0.5% | 0.5% | 0.5% | 0.5% | |||
Management | 3 | 0.5% | 0.5% | 0.5% | 0.5% | 0.5% | 0.5% | 0.5% | 0.5% | 0.5% | 0.5% | |||
Downside 1 | 4 | 0.5% | 0.5% | 0.5% | 0.5% | 0.5% | 0.5% | 0.5% | 0.5% | 0.5% | 0.5% | |||
Downside 2 | 5 | 0.5% | 0.5% | 0.5% | 0.5% | 0.5% | 0.5% | 0.5% | 0.5% | 0.5% | 0.5% | |||
Cash Flow Statement Assumptions | ||||||||||||||
Capital Expenditures (% sales) | 4.5% | 4.5% | 4.5% | 4.5% | 4.5% | 4.5% | 4.5% | 4.5% | 4.5% | 4.5% | ||||
Base | 1 | 4.5% | 4.5% | 4.5% | 4.5% | 4.5% | 4.5% | 4.5% | 4.5% | 4.5% | 4.5% | |||
Sponsor | 2 | 4.5% | 4.5% | 4.5% | 4.5% | 4.5% | 4.5% | 4.5% | 4.5% | 4.5% | 4.5% | |||
Management | 3 | 4.5% | 4.5% | 4.5% | 4.5% | 4.5% | 4.5% | 4.5% | 4.5% | 4.5% | 4.5% | |||
Downside 1 | 4 | 5.0% | 5.0% | 5.0% | 5.0% | 5.0% | 5.0% | 5.0% | 5.0% | 5.0% | 5.0% | |||
Downside 2 | 5 | 5.0% | 5.0% | 5.0% | 5.0% | 5.0% | 5.0% | 5.0% | 5.0% | 5.0% | 5.0% |
A2
Assumptions Page 2 – Balance Sheet | ||||||||||||||
Projection Period | ||||||||||||||
Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Year 6 | Year 7 | Year 8 | Year 9 | Year 10 | |||||
2013 | 2014 | 2015 | 2016 | 2017 | 2018 | 2019 | 2020 | 2021 | 2022 | |||||
Current Assets | ||||||||||||||
Days Sales Outstanding (DSO) | 47.6 | 47.6 | 47.6 | 47.6 | 47.6 | 47.6 | 47.6 | 47.6 | 47.6 | 47.6 | ||||
Base | 1 | 47.6 | 47.6 | 47.6 | 47.6 | 47.6 | 47.6 | 47.6 | 47.6 | 47.6 | 47.6 | |||
Sponsor | 2 | 47.6 | 47.6 | 47.6 | 47.6 | 47.6 | 47.6 | 47.6 | 47.6 | 47.6 | 47.6 | |||
Management | 3 | 47.6 | 47.6 | 47.6 | 47.6 | 47.6 | 47.6 | 47.6 | 47.6 | 47.6 | 47.6 | |||
Downside 1 | 4 | 50.0 | 50.0 | 50.0 | 50.0 | 50.0 | 50.0 | 50.0 | 50.0 | 50.0 | 50.0 | |||
Downside 2 | 5 | 55.0 | 55.0 | 55.0 | 55.0 | 55.0 | 55.0 | 55.0 | 55.0 | 55.0 | 55.0 | |||
Days Inventory Held (DIH) | 105.8 | 105.8 | 105.8 | 105.8 | 105.8 | 105.8 | 105.8 | 105.8 | 105.8 | 105.8 | ||||
Base | 1 | 105.8 | 105.8 | 105.8 | 105.8 | 105.8 | 105.8 | 105.8 | 105.8 | 105.8 | 105.8 | |||
Sponsor | 2 | 105.8 | 105.8 | 105.8 | 105.8 | 105.8 | 105.8 | 105.8 | 105.8 | 105.8 | 105.8 | |||
Management | 3 | 105.8 | 105.8 | 105.8 | 105.8 | 105.8 | 105.8 | 105.8 | 105.8 | 105.8 | 105.8 | |||
Downside 1 | 4 | 110.0 | 110.0 | 110.0 | 110.0 | 110.0 | 110.0 | 110.0 | 110.0 | 110.0 | 110.0 | |||
Downside 2 | 5 | 115.0 | 115.0 | 115.0 | 115.0 | 115.0 | 115.0 | 115.0 | 115.0 | 115.0 | 115.0 | |||
Prepaids and Other Current Assets (% sales) | 5.1% | 5.1% | 5.1% | 5.1% | 5.1% | 5.1% | 5.1% | 5.1% | 5.1% | 5.1% | ||||
Base | 1 | 5.1% | 5.1% | 5.1% | 5.1% | 5.1% | 5.1% | 5.1% | 5.1% | 5.1% | 5.1% | |||
Sponsor | 2 | 5.1% | 5.1% | 5.1% | 5.1% | 5.1% | 5.1% | 5.1% | 5.1% | 5.1% | 5.1% | |||
Management | 3 | 5.1% | 5.1% | 5.1% | 5.1% | 5.1% | 5.1% | 5.1% | 5.1% | 5.1% | 5.1% | |||
Downside 1 | 4 | 5.1% | 5.1% | 5.1% | 5.1% | 5.1% | 5.1% | 5.1% | 5.1% | 5.1% | 5.1% | |||
Downside 2 | 5 | 5.1% | 5.1% | 5.1% | 5.1% | 5.1% | 5.1% | 5.1% | 5.1% | 5.1% | 5.1% | |||
Current Liabilities | ||||||||||||||
Days Payable Outstanding (DPO) | 37.9 | 37.9 | 37.9 | 37.9 | 37.9 | 37.9 | 37.9 | 37.9 | 37.9 | 37.9 | ||||
Base | 1 | 37.9 | 37.9 | 37.9 | 37.9 | 37.9 | 37.9 | 37.9 | 37.9 | 37.9 | 37.9 | |||
Sponsor | 2 | 37.9 | 37.9 | 37.9 | 37.9 | 37.9 | 37.9 | 37.9 | 37.9 | 37.9 | 37.9 | |||
Management | 3 | 37.9 | 37.9 | 37.9 | 37.9 | 37.9 | 37.9 | 37.9 | 37.9 | 37.9 | 37.9 | |||
Downside 1 | 4 | 35.0 | 35.0 | 35.0 | 35.0 | 35.0 | 35.0 | 35.0 | 35.0 | 35.0 | 35.0 | |||
Downside 2 | 5 | 30.0 | 30.0 | 30.0 | 30.0 | 30.0 | 30.0 | 30.0 | 30.0 | 30.0 | 30.0 | |||
Accrued Liabilities (% sales) | 8.0% | 8.0% | 8.0% | 8.0% | 8.0% | 8.0% | 8.0% | 8.0% | 8.0% | 8.0% | ||||
Base | 1 | 8.0% | 8.0% | 8.0% | 8.0% | 8.0% | 8.0% | 8.0% | 8.0% | 8.0% | 8.0% | |||
Sponsor | 2 | 8.0% | 8.0% | 8.0% | 8.0% | 8.0% | 8.0% | 8.0% | 8.0% | 8.0% | 8.0% | |||
Management | 3 | 8.0% | 8.0% | 8.0% | 8.0% | 8.0% | 8.0% | 8.0% | 8.0% | 8.0% | 8.0% | |||
Downside 1 | 4 | 8.0% | 8.0% | 8.0% | 8.0% | 8.0% | 8.0% | 8.0% | 8.0% | 8.0% | 8.0% | |||
Downside 2 | 5 | 8.0% | 8.0% | 8.0% | 8.0% | 8.0% | 8.0% | 8.0% | 8.0% | 8.0% | 8.0% | |||
Other Current Liabilities (% sales) | 2.9% | 2.9% | 2.9% | 2.9% | 2.9% | 2.9% | 2.9% | 2.9% | 2.9% | 2.9% | ||||
Base | 1 | 2.9% | 2.9% | 2.9% | 2.9% | 2.9% | 2.9% | 2.9% | 2.9% | 2.9% | 2.9% | |||
Sponsor | 2 | 2.9% | 2.9% | 2.9% | 2.9% | 2.9% | 2.9% | 2.9% | 2.9% | 2.9% | 2.9% | |||
Management | 3 | 2.9% | 2.9% | 2.9% | 2.9% | 2.9% | 2.9% | 2.9% | 2.9% | 2.9% | 2.9% | |||
Downside 1 | 4 | 2.9% | 2.9% | 2.9% | 2.9% | 2.9% | 2.9% | 2.9% | 2.9% | 2.9% | 2.9% | |||
Downside 2 | 5 | 2.9% | 2.9% | 2.9% | 2.9% | 2.9% | 2.9% | 2.9% | 2.9% | 2.9% | 2.9% |
A3
($ in millions, fiscal year ending December 31) | |||||||||||||
Assumptions Page 3 – Financing Structures and Fees | |||||||||||||
Financing Structures | Purchase Price | ||||||||||||
Structure | Public / Private Target | 2 | |||||||||||
1 | 2 | 3 | 4 | 5 | |||||||||
Sources of Funds | Structure 1 | Structure 2 | Structure 3 | Structure 4 | Status Quo | Entry EBITDA Multiple | 8.0x | ||||||
Revolving Credit Facility Size | $250.0 | $250.0 | $250.0 | $250.0 | -0 | LTM 9/30/2012 EBITDA | 700.0 | ||||||
Revolving Credit Facility Draw | -0 | -0 | -0 | -0 | -0 | Enterprise Value | $5,600.0 | ||||||
Term Loan A | -0 | 500.0 | -0 | -0 | -0 | ||||||||
Term Loan B | 2,150.0 | 1,650.0 | 2,100.0 | 1,750.0 | -0 | Less: Total Debt | (1,500.0) | ||||||
Term Loan C | -0 | -0 | -0 | -0 | -0 | Less: Preferred Stock | -0 | ||||||
2nd Lien | -0 | -0 | -0 | -0 | -0 | Less: Noncontrolling Interest | -0 | ||||||
Senior Notes | 1,500.0 | 1,500.0 | 700.0 | 1,000.0 | -0 | Plus: Cash and Cash Equivalents | 250.0 | ||||||
Senior Subordinated Notes | -0 | -0 | 700.0 | 1,000.0 | -0 | Equity Purchase Price | $4,350.0 | ||||||
Equity Contribution | 2,100.0 | 2,100.0 | 2,250.0 | 2,250.0 | -0 | ||||||||
Rollover Equity | -0 | -0 | -0 | -0 | -0 | Calculation of Fully Diluted Shares Outstanding | |||||||
Cash on Hand | 250.0 | 250.0 | 250.0 | -0 | -0 | Offer Price per Share | -0 | ||||||
-0 | -0 | -0 | -0 | -0 | |||||||||
Total Sources of Funds | $6,000.0 | $6,000.0 | $6,000.0 | $6,000.0 | -0 | Basic Shares Outstanding | -0 | ||||||
Plus: Shares from In-the-Money Options | -0 | ||||||||||||
Uses of Funds | Less: Shares Repurchased | -0 | |||||||||||
Equity Purchase Price | $4,350.0 | $4,350.0 | $4,350.0 | $4,350.0 | -0 | Net New Shares from Options | -0 | ||||||
Repay Existing Bank Debt | 1,500.0 | 1,500.0 | 1,500.0 | 1,500.0 | -0 | Plus: Shares from Convertible Securities | -0 | ||||||
Tender / Call Premiums | 20.0 | 20.0 | 20.0 | 20.0 | -0 | Fully Diluted Shares Outstanding | -0 | ||||||
Financing Fees | 90.0 | 90.0 | 90.0 | 90.0 | -0 | ||||||||
Other Fees and Expenses | 40.0 | 40.0 | 40.0 | 40.0 | -0 | Options/Warrants | |||||||
– | -0 | -0 | -0 | -0 | -0 | Number of | Exercise | In-the-Money | |||||
– | -0 | -0 | -0 | -0 | -0 | Tranche | Shares | Price | Shares | Proceeds | |||
Total Uses of Funds | $6,000.0 | $6,000.0 | $6,000.0 | $6,000.0 | -0 | Tranche 1 | -0 | -0 | -0 | -0 | |||
Tranche 2 | -0 | -0 | -0 | -0 | |||||||||
Financing Fees | Tranche 3 | -0 | -0 | -0 | -0 | ||||||||
Fees | Tranche 4 | -0 | -0 | -0 | -0 | ||||||||
Structure 1 | Size | (%) | ($) | Tranche 5 | -0 | -0 | -0 | -0 | |||||
Revolving Credit Facility Size | $250.0 | 1.500% | $3.8 | Total | -0 | -0 | -0 | ||||||
Term Loan A | -0 | 1.500% | -0 | ||||||||||
Term Loan B | 2,150.0 | 1.500% | 32.3 | Convertible Securities | |||||||||
Term Loan C | -0 | 1.500% | -0 | Conversion | Conversion | New | |||||||
2nd Lien | -0 | 2.250% | -0 | Amount | Price | Ratio | Shares | ||||||
Senior Notes | 1,500.0 | 2.250% | 33.8 | Issue 1 | -0 | -0 | -0 | -0 | |||||
Senior Subordinated Notes | -0 | 2.250% | -0 | Issue 2 | -0 | -0 | -0 | -0 | |||||
Senior Bridge Facility | 1,500.0 | 1.000% | 15.0 | Issue 3 | -0 | -0 | -0 | -0 | |||||
Senior Subordinated Bridge Facility | -0 | 1.000% | -0 | Issue 4 | -0 | -0 | -0 | -0 | |||||
Other Financing Fees & Expenses | 5.3 | Issue 5 | -0 | -0 | -0 | -0 | |||||||
Total Financing Fees | $90.0 | Total | -0 | ||||||||||
Amortization of Financing Fees | |||||||||||||
Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Year 6 | Year 7 | Year 8 | Year 9 | Year 10 | ||||
Term | 2013 | 2014 | 2015 | 2016 | 2017 | 2018 | 2019 | 2020 | 2021 | 2022 | |||
Revolving Credit Facility Size | 6 | $0.6 | $0.6 | $0.6 | $0.6 | $0.6 | $0.6 | -0 | -0 | -0 | -0 | ||
Term Loan A | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | ||
Term Loan B | 7 | 4.6 | 4.6 | 4.6 | 4.6 | 4.6 | 4.6 | 4.6 | -0 | -0 | -0 | ||
Term Loan C | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | ||
2nd Lien | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | ||
Senior Notes | 8 | 4.2 | 4.2 | 4.2 | 4.2 | 4.2 | 4.2 | 4.2 | 4.2 | -0 | -0 | ||
Senior Subordinated Notes | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | ||
Senior Bridge Facility | 8 | 1.9 | 1.9 | 1.9 | 1.9 | 1.9 | 1.9 | 1.9 | 1.9 | -0 | -0 | ||
Senior Subordinated Bridge Facility | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | ||
Other Financing Fees & Expenses | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | -0 | ||
Annual Amortization | $11.3 | $11.3 |