$ answer_1 - Copy Compability Mode - Excel 239 File Home Insert Draw Page Layout Formulas Data Review View Help Tell me what you want to do Share Custom Conditional Formatting Insert AT Arial - 10 A A = ab PE $ . % Formata Table EX Delete Paste B 1 UH A- . 00 00 +0 Pcell Styles i Format Cli Famil Alignme Number Styles Cells Filting H36 3 f = SUMIE36:G36) D E F G K M N P R S T UV W 3 Balance Sheet Opening 2021 Adjustments 540 8200 Cash and Cash Equraksts 8 Accounts Receivable 9 Inventones 10 Prepaids and Other Outlet Assets 11 Total Current Assets 13 Property, Planland Ecuipment 14 Cincin 15 Inangibles 16 Other Assets 17 Dulu Fircig Fees Total Assets Pro Forma Year 1 Year 2 Year 3 Year 4 2021 2022 2023 2024 2025 $300 $1, $1000D S1CKO 13,017.0 15,740.5 18, 101.6 20,816.8 23,9393 291,24919 529.0 839.7 7856 B48.0 972.9 $ $40.320.0 $46,530.1 $63.474.6 $61,346.8 S70,397.7 18.065.0 19,599.9 20,374.0 21,302.2 22 389.8 141414 4154.41 4,334.0 4,334,0 4.334.0 4,334.0 4.334.0 81460 8,1410 8 1460 8,14001 1360 122.4 106.8 95.2 818 $67, 656,6 $ $74,153.9 $81,7920 $90,577.8 $100,683.5 3,080 3,731 / 42914 4,931 Projection Period Year 6 Year 6 Year 7 Year Year 9 Year 10 2026 2027 2028 2029 2030 2031 $ 1 000 $1 CHMID S1000 $ 1 000 $1 CHMIEL S1 OCTO 27,530.2 31,959.7 38.108.7 11.870.0 48,150.5 55 373.1 1113 1,8321 1/04 18 4112 10 11 1,118.8 1.200.0 1.4796 1,701.6 1,958.8 2.250.3 $80.807.3 $92,778.4 S105,545.2 $122.177.0 $140,583.5 $140,583.5 S161,521.1 23,597.2 25,000.0 28.6323 28,499.3 30,848.3 33. 1154 14.14.4) (4,6144 1411441 14,1544) 4,334.0 4.334.0 4.3340 4,334.0 4,334.0 4.334.0 8 1460 11401 81410 8,1450 8.1400 680 54.4 40.8 27.2 13.8 $112,3071 $125 676,3 $141.0529 $158, 738.1 $179,078,0 $202.471.0 &fit 11,41! 141414 00 81469 138,0 $72 1650 20 Accounts Payah 21 Accrued Liabilises 22 Other Current Labines 23 Total Current Liabilities 30835 $5.742.0 $ 20060 $6,742.0 3,211 $8,943.4 1.444 1,2475 $9,182.6 4 ARG $10,560.0 6,40 $19.9666 $7.9849 7.4289 $16,080.4 2002 85432 $18.469.6 8,8247 $21,239.9 11 298 4 $24.425.9 $12.144.0 36128 5,1181 9.0131 12,3548 10,2113 2570 31,700 38237 11 !1 0.0 13,588.0 0.0 13,5980 13,598.0 13,5980 13,5880 13,5980 13,6980 13:1930 13,5580 13,588.0 13,598.0 (16.14901 00 0.0 25 Reving Credit Facility 26 Term Loan A 27 Term Loan 20 Term Loan 29 Existing Term Loan 30 2nd Lien 31 Serior Notes 22 Existing dichiar Notes - 33 Serior Subordinated Notes 34 CHhes linht 35 Deferred Income Taxes 24 | Th In IRITE I ahirts 37 Total Liabilities $26.105.0 20 Nentraling mense 40 Shareholders Equity 41 Total Shareholders' Equity S46,050.0 43 Total Liabilities and Equity $72.165.0 44 15 Balance Check 0.000 413 47 Net Working Capital 31.993.0 48 (ISA/Darras In Net Working Capital TS IS BS CF DS DS RA A1 A2 491400! 471400 42140 4,71411 $ $23.564,0 $26.199.9 $29.409,7 $33,113.3 47140 $37,385.1 42140 $42.310.8 42401 $47,800.9 47140 $54,532.8 42140 $82,0723 4,7141 $70,757.0 47140 $80,781.8 44,101.6 1480000 44,101.6 47.954.1 52.3823 57,484.5 63.298.4 $44,101.6 $47,954.1 $62.3823 $57,464.5 $63,298.4 $87,866.8 $74,153.9 $81.7920 $90,577.0 $100,663.5 0.000 0.000 0.000 0.000 0.000 31,993.0 38,800.7 44,489.7 51,163.2 58.837.7 BHX) 69.9064 $69,996.4 $112,3071 0.000 77.807.5 88.5203 98.cese 100,320.2 1217094 $77,687.5 585,520.3 $96.666.8 $108,320.2 $121,709.4 $125,678.3 $141,052,9 $154,738.1 $179,070.0 $202.471.0 0.000 0.000 0.000 0.000 0.000 67.663.3 77,812.0 (111,141) 89.4848 (11 11/19 102,907.5 113,4721 118,349.0 138,0951 (1771 A3 + Ready Calculate + U19 FH 200 0 w P Pr N Tacica Taktuara v ENG 9:20 AM 10/5/2021 X Tell me Share Home Home 2 Tell mesh: IS CFOS - Excel Home Insert Draw Page Layout Formulas Data Review View He A E Conditional Formatting For Alignment Numbe Format as Table Colls cell Styles 15 CFBS 2 - Excel cort Draw Page Layout Formulas Data Review View F. Conditional Formatting Format as Table > Editing . > Styles Clipboard 11 - X 415.272 x Six E E Lze 606335107 2608405 NYSE Common stock SWYSE Connensch APR 21 APR | AFR** APR *** APR -TemImcstments Taur Birullar Account Recowbice AL 21 APR 21 APR 21 JAN 21 OCT '20 JUL 20 APR 20 APR '10 01 FY 04 03 02 01 FYFY 368.2 416.84163 418.2 271.9 348.6 209 200 205 206 2018 1416 1998 1999 2282 283 974 4123 141.6 129.3 139.2 223.2 283 9744 143.2 40 40.50 980.75 12.3131313 1 088 1143 30.7 2.9 21.8200 17.01 * 124 107D1T904? 175.0 145,4 1454 387 1076 78.847 1912 704.0 489 4.1 671.1 6.2.0063.0 560.48636 0231 031.4 200. 2015 415) 205.5 19.1 1931 1970 13150 12 94 183 101 190.9 144 09 00934 2.1 1.8 169 14.8 15.1 1124 2262 034 1454 9 22 23 13 14 1688217 508 436.! g: 0 1 2 3 = 0 : 1 Not Property, Plant & Equipmen raporty Plant & Equipment. Gross Land & Improvements 1.7 202 982a2 907 24 3433 H 1973 3410 3101 3186 .741 BS LTM CFLTM IS LTM | EU E + iz Tadicha Tarkar $ answer_1 - Copy Compability Mode - Excel 239 File Home Insert Draw Page Layout Formulas Data Review View Help Tell me what you want to do Share Custom Conditional Formatting Insert AT Arial - 10 A A = ab PE $ . % Formata Table EX Delete Paste B 1 UH A- . 00 00 +0 Pcell Styles i Format Cli Famil Alignme Number Styles Cells Filting H36 3 f = SUMIE36:G36) D E F G K M N P R S T UV W 3 Balance Sheet Opening 2021 Adjustments 540 8200 Cash and Cash Equraksts 8 Accounts Receivable 9 Inventones 10 Prepaids and Other Outlet Assets 11 Total Current Assets 13 Property, Planland Ecuipment 14 Cincin 15 Inangibles 16 Other Assets 17 Dulu Fircig Fees Total Assets Pro Forma Year 1 Year 2 Year 3 Year 4 2021 2022 2023 2024 2025 $300 $1, $1000D S1CKO 13,017.0 15,740.5 18, 101.6 20,816.8 23,9393 291,24919 529.0 839.7 7856 B48.0 972.9 $ $40.320.0 $46,530.1 $63.474.6 $61,346.8 S70,397.7 18.065.0 19,599.9 20,374.0 21,302.2 22 389.8 141414 4154.41 4,334.0 4,334,0 4.334.0 4,334.0 4.334.0 81460 8,1410 8 1460 8,14001 1360 122.4 106.8 95.2 818 $67, 656,6 $ $74,153.9 $81,7920 $90,577.8 $100,683.5 3,080 3,731 / 42914 4,931 Projection Period Year 6 Year 6 Year 7 Year Year 9 Year 10 2026 2027 2028 2029 2030 2031 $ 1 000 $1 CHMID S1000 $ 1 000 $1 CHMIEL S1 OCTO 27,530.2 31,959.7 38.108.7 11.870.0 48,150.5 55 373.1 1113 1,8321 1/04 18 4112 10 11 1,118.8 1.200.0 1.4796 1,701.6 1,958.8 2.250.3 $80.807.3 $92,778.4 S105,545.2 $122.177.0 $140,583.5 $140,583.5 S161,521.1 23,597.2 25,000.0 28.6323 28,499.3 30,848.3 33. 1154 14.14.4) (4,6144 1411441 14,1544) 4,334.0 4.334.0 4.3340 4,334.0 4,334.0 4.334.0 8 1460 11401 81410 8,1450 8.1400 680 54.4 40.8 27.2 13.8 $112,3071 $125 676,3 $141.0529 $158, 738.1 $179,078,0 $202.471.0 &fit 11,41! 141414 00 81469 138,0 $72 1650 20 Accounts Payah 21 Accrued Liabilises 22 Other Current Labines 23 Total Current Liabilities 30835 $5.742.0 $ 20060 $6,742.0 3,211 $8,943.4 1.444 1,2475 $9,182.6 4 ARG $10,560.0 6,40 $19.9666 $7.9849 7.4289 $16,080.4 2002 85432 $18.469.6 8,8247 $21,239.9 11 298 4 $24.425.9 $12.144.0 36128 5,1181 9.0131 12,3548 10,2113 2570 31,700 38237 11 !1 0.0 13,588.0 0.0 13,5980 13,598.0 13,5980 13,5880 13,5980 13,6980 13:1930 13,5580 13,588.0 13,598.0 (16.14901 00 0.0 25 Reving Credit Facility 26 Term Loan A 27 Term Loan 20 Term Loan 29 Existing Term Loan 30 2nd Lien 31 Serior Notes 22 Existing dichiar Notes - 33 Serior Subordinated Notes 34 CHhes linht 35 Deferred Income Taxes 24 | Th In IRITE I ahirts 37 Total Liabilities $26.105.0 20 Nentraling mense 40 Shareholders Equity 41 Total Shareholders' Equity S46,050.0 43 Total Liabilities and Equity $72.165.0 44 15 Balance Check 0.000 413 47 Net Working Capital 31.993.0 48 (ISA/Darras In Net Working Capital TS IS BS CF DS DS RA A1 A2 491400! 471400 42140 4,71411 $ $23.564,0 $26.199.9 $29.409,7 $33,113.3 47140 $37,385.1 42140 $42.310.8 42401 $47,800.9 47140 $54,532.8 42140 $82,0723 4,7141 $70,757.0 47140 $80,781.8 44,101.6 1480000 44,101.6 47.954.1 52.3823 57,484.5 63.298.4 $44,101.6 $47,954.1 $62.3823 $57,464.5 $63,298.4 $87,866.8 $74,153.9 $81.7920 $90,577.0 $100,663.5 0.000 0.000 0.000 0.000 0.000 31,993.0 38,800.7 44,489.7 51,163.2 58.837.7 BHX) 69.9064 $69,996.4 $112,3071 0.000 77.807.5 88.5203 98.cese 100,320.2 1217094 $77,687.5 585,520.3 $96.666.8 $108,320.2 $121,709.4 $125,678.3 $141,052,9 $154,738.1 $179,070.0 $202.471.0 0.000 0.000 0.000 0.000 0.000 67.663.3 77,812.0 (111,141) 89.4848 (11 11/19 102,907.5 113,4721 118,349.0 138,0951 (1771 A3 + Ready Calculate + U19 FH 200 0 w P Pr N Tacica Taktuara v ENG 9:20 AM 10/5/2021 X Tell me Share Home Home 2 Tell mesh: IS CFOS - Excel Home Insert Draw Page Layout Formulas Data Review View He A E Conditional Formatting For Alignment Numbe Format as Table Colls cell Styles 15 CFBS 2 - Excel cort Draw Page Layout Formulas Data Review View F. Conditional Formatting Format as Table > Editing . > Styles Clipboard 11 - X 415.272 x Six E E Lze 606335107 2608405 NYSE Common stock SWYSE Connensch APR 21 APR | AFR** APR *** APR -TemImcstments Taur Birullar Account Recowbice AL 21 APR 21 APR 21 JAN 21 OCT '20 JUL 20 APR 20 APR '10 01 FY 04 03 02 01 FYFY 368.2 416.84163 418.2 271.9 348.6 209 200 205 206 2018 1416 1998 1999 2282 283 974 4123 141.6 129.3 139.2 223.2 283 9744 143.2 40 40.50 980.75 12.3131313 1 088 1143 30.7 2.9 21.8200 17.01 * 124 107D1T904? 175.0 145,4 1454 387 1076 78.847 1912 704.0 489 4.1 671.1 6.2.0063.0 560.48636 0231 031.4 200. 2015 415) 205.5 19.1 1931 1970 13150 12 94 183 101 190.9 144 09 00934 2.1 1.8 169 14.8 15.1 1124 2262 034 1454 9 22 23 13 14 1688217 508 436.! g: 0 1 2 3 = 0 : 1 Not Property, Plant & Equipmen raporty Plant & Equipment. Gross Land & Improvements 1.7 202 982a2 907 24 3433 H 1973 3410 3101 3186 .741 BS LTM CFLTM IS LTM | EU E + iz Tadicha Tarkar