5 IS CELTM - Excal Home Insert Draw Page Layout Formulas Data Review View Help Tell me 5 13 Filc 15 CFBS 2 - Excel Home Insert Draw Page Layout Formulas Data Review A F. Conditional Formatting 2 Tell mesh X A. X 2 Cell Styles 29 D CUBE HTIK JUL 21 APR 21 JAN 21 OCT 20 J L32 Box Ingen 200409 NYSE Common stock Source: FactSet Fundamentals JUL 21 APR 21 APR-20 APR '19 APR " 1.5.3.2 ro 1,0349 55 60 8022 BOB C 1061 1019.0 826.0 74.8 434 4929 17747203 04 646.7 0910 604 560.6 63.3 6.4 607 699.7 61.0 672 162.7 1430 1422 124.1 139.7 1387 134.0 044 135 136 139 19:22 4 331 1.6 10 37 338 1.973.6 1.7342 1,704.0 1.740.4 1,093.0 10.10. Tout 30.1 13.01.18 12 236 13 8469 si 128 78 10.9 1 2 38.9320000 120. Lila ..." 9 22.11.16 00 00 00 00 00 00 00 2 11 43:06 46.22 10 & EX BSSAR 00 -1.6327.22 BOSS RSS 1742 0019927 384 982 252 423 212 2882 230.0 10.5 1787 1748 136.1 1709 167. 164.5 16.1 161.0 eats # -+++ E- iz Tasichar 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 Accounting Conditional Formatting Insert AT Arial - 10 - A A = ab PE Formata Table EX Delete O- $ . Daste B 1 U A- . * 00 .00 +0 cell Styles i Format Cli ul Alignme Number Styles Cells Fuiting G30 X fo TE B C D 1 N P 0 R 1 La-Z-Boy Incorporated (LZB) Historical Period Year 9 2018 2019 LTM 31/4/2021 2020 Pro forma 2021 Year 1 2022 $54,388.0 15.0% Year 2 2023 $62,623.2 15.0% Year 3 2024 $71,901.6 19.0% Year 2028 $125,760.4 15.0% Year 8 2029 $144,819.9 15.09 2030 $166,312.8 15.09% NA Year 10 2031 $191,269.8 19.0% 20.9% 9.3% Projection Period Year 6 Year 2028 2027 $95,099. $109,363.4 19.0% 15.06 21/10 4 1281/1 $14,379.5 $16,636.4 15 7% 157 % NA 0.2% (in malore, fiecal year ending December 31) 3 Income Statement 4 5 B 7 Sales 8 11 Cast of Ganda Said 11 Gross Pront 12 % margin 15 14 Selling, Cenerel & Administrative 15 Xe 10 17 Ole Expense (nume) 10 EBITDA 19 Year 4 2025 $82,890.9 19.0% FCI 191 $12,603.9 $ 15 7% 55,137.0 $6,871.0 56,519.0 151 $6,799.0 15 1 $7,149.1 15 % SB,221.5 15 7% 1584 $9,464.7 157 61 IWB / $10,873.0 15 7% 106.7205 $19,016.9 15 7% 122,150 $21,869.4 151% 141,138 $25,149.3 15% $28,9223 157% . $5,137.0 $6,519.0 15.1% $6,871.0 14.6% $6,799.0 15.1% $7,149.1 19.1% $8,221.6 191% $9,454.7 19.1% $10,8730 19.1% $12,503.9 19.1% $14,379.5 19.1% $18,630.4 19.1% $19,010,9 19.1% 5,09794 $21,889.4 19.1% $25,149.8 19.1% % $28,922.3 15.1% 7,1!!! 2,98041 3,298 3,4401 4,4115 1941 1,195 1 $3,692.0 1039 S4,489.0 104 54,906.0 10 49 $4,983.0 11 16 $5,239.6 111 $5,026.6 11 1% $13,937.5 $6,929.4 111% $7,968.8 11 $9,164.1 1179 $10,038.8 111* $12,119.6 11 79% $16,028.1 117% $18,432.4 $21, 1972 11 1% 325 219.0 3405 4808 642.7 8296 1,015 1 1,2937 1,580 2 2720 272.0 4759 475 9 4759 4759 4759 475 g 4759 4759 4759 475 9 - 21 apranation 22 mertahan 23 EBIT 24 mangin 20 Interest Expense 27 Revong Credr Fecilty 28 Tem Loan A 29 Tem Loan B 30 Term Loan C 31 Existing Term Loen 32 2nd Lien 33 Serior Notes 34 Senior Subordinated Notes 35 Commitment Fee on Unused Revolver 38 Administrative Apart Fee 37 Cash Interest Expende 38 Amortization of Deferred Financing Fees 39 Total Interest Expense 400 Imanest incom 41 Net Interest Expense 12 13 Earnings Before Taxes TS IS BS CF DS RA 1 - . - - $589.7 $956.7 $272.0 136 $285.6 $5084 134 $522.0 $6949 136 $7085 $816.4 13 1 $830.0 $1,1187 13 $1,1323 $1,305.5 136 $1,319.1 $1,521.1 13 $1,534.7 $1,769.6 136 $1,783 2 $2,056.1 136 $2,069.7 $603.3 $970 $5220 $603.3 $703 5 $830.0 $ $9703 $1,1323 $1,7832 $1,319.1 12,6184 $1,534.7 14,1935 $2,069.7 19,1275 5,500.5 8,3261 7.2003 9,568.5 10,9873 18.649 1 A2 A3 + 11 Ready Calculate # FH ZO Pr N Tacicbar Taskbar A v