Enter formulas in the call highlighted yellow Cells that have angle in the upper right hand come have comments you can view Let the cor hover over the call and the 5 comment will bear. These comments have intorno Projections assume that a constant long-term growth rate of 5% begins in 2027 Note atsions 10 Income Statements 45 9.140 Actual Projected Projected Projected Projected Projected Projected Projected 2020 2021 2022 2023 18813 2024 2025 21071 23242 2021 20:27 25,762 5,50 6,50 27150 28816 7340 31/06 30.256 7763 7699 8.3.28 8,378 8472 AN 8.305 545 015 9401 9583 90 078 720 72 841 49 5228 SOY 6413 7633 185 10000 30 340 37 11.220 an 4837 4 455 4858 1039 512 7225 8420 100 2103 1644 1 2021 le SIMO 400 2062 20 1480 1974 2.00 3,670 4.59 5453 1,30 3.153 1057 1001 935 14 21 757 12 Sales n Costs of Goods Sold 14 Sales, General and Active 15 Depreciation 16 1) interest expense Opening Prom Eags Before TM 19 Taxes 10 Net Income 23 22 Dividends 23 Addition to retained earnings 24 2 Balance Sheets 25 at Cash lever Account ceva Total current 31 Net Total set 15 5722 200 630 1225 7337 19 1072 Actual Projected Projected Projected Projected Projected Projected Projected 2020 2021 2022 2023 2024 2026 2026 1807 2027 105 2.105 2302 2.550 2.714 2010 890 2. 1007 1:155 12:57 1412 1:04 1,579 HAVE 6827 519 5.443 897 935 9000 12022 1:21: MM2 1144 12 10.122 21. 2 2010 201 23/15 2141 440 300 5010 5201 1037 109 IM 200 217 231 242 254 4442 4121 48122 3500 2701 205 sas 102 19.00 11216 2002 2514 2671 2,019 2.901 3074 3210 101 1174 12519 TO Accounts payabile 2 Acoudos 16 Sharm dett 17 Total currentibes Lengdum dett Totalbes 14 1010 - Pin 000 07 | FRIS 000 CULT 1104 FO Com 2.200 100 1000 1000 2002 200 To 400 2011 3115 12 Totales and 11 125 21 1264 Projecng the needshow 47 Achal Projected Projected Projected Price Pred 2020 2021 2012 2003 Open 2014 2035 2828 Taxonering 2.30 Saloperinge Operating currera 412 22 Yellret og pa nel capital WIECE SOCIOPA 2022 IVONTS OCD OMON En GO > NO NOTAT prap Crow Crowd b. Estimating weighed average corp WACC) Requited return on bond PV Maataaimha 100005 D SPC Tag con london Agregado m. 54,02000 WESTIT . Estimating the weighted average cost of capital (WACC). 5100000 2.102 sa 345 51.000 52,15665 Required return on bond by 70 Par V Number of bands and 71 touch 22 Number of payments roman Penodic coupon Bond price Ambalbond Strom Banda 7 Bondyed 79 Required return on Mock Beta O ore 2 Mulp Romum org Two Taxe WACC 10 400 2015 70 c. Estimating the pershare Value of ET prestock Actual Propected Practed Projected Projected Projected Projected Projecte Assume long-term growth rate of 2000 2021 2002 2003 2004 2025 2000 5% begins in 2027 2027 FCE 207 Expected growth Ven 2007 Carsch Town PV of open 10 Ote Price per 2.240 mm Enter formulas in the call highlighted yellow Cells that have angle in the upper right hand come have comments you can view Let the cor hover over the call and the 5 comment will bear. These comments have intorno Projections assume that a constant long-term growth rate of 5% begins in 2027 Note atsions 10 Income Statements 45 9.140 Actual Projected Projected Projected Projected Projected Projected Projected 2020 2021 2022 2023 18813 2024 2025 21071 23242 2021 20:27 25,762 5,50 6,50 27150 28816 7340 31/06 30.256 7763 7699 8.3.28 8,378 8472 AN 8.305 545 015 9401 9583 90 078 720 72 841 49 5228 SOY 6413 7633 185 10000 30 340 37 11.220 an 4837 4 455 4858 1039 512 7225 8420 100 2103 1644 1 2021 le SIMO 400 2062 20 1480 1974 2.00 3,670 4.59 5453 1,30 3.153 1057 1001 935 14 21 757 12 Sales n Costs of Goods Sold 14 Sales, General and Active 15 Depreciation 16 1) interest expense Opening Prom Eags Before TM 19 Taxes 10 Net Income 23 22 Dividends 23 Addition to retained earnings 24 2 Balance Sheets 25 at Cash lever Account ceva Total current 31 Net Total set 15 5722 200 630 1225 7337 19 1072 Actual Projected Projected Projected Projected Projected Projected Projected 2020 2021 2022 2023 2024 2026 2026 1807 2027 105 2.105 2302 2.550 2.714 2010 890 2. 1007 1:155 12:57 1412 1:04 1,579 HAVE 6827 519 5.443 897 935 9000 12022 1:21: MM2 1144 12 10.122 21. 2 2010 201 23/15 2141 440 300 5010 5201 1037 109 IM 200 217 231 242 254 4442 4121 48122 3500 2701 205 sas 102 19.00 11216 2002 2514 2671 2,019 2.901 3074 3210 101 1174 12519 TO Accounts payabile 2 Acoudos 16 Sharm dett 17 Total currentibes Lengdum dett Totalbes 14 1010 - Pin 000 07 | FRIS 000 CULT 1104 FO Com 2.200 100 1000 1000 2002 200 To 400 2011 3115 12 Totales and 11 125 21 1264 Projecng the needshow 47 Achal Projected Projected Projected Price Pred 2020 2021 2012 2003 Open 2014 2035 2828 Taxonering 2.30 Saloperinge Operating currera 412 22 Yellret og pa nel capital WIECE SOCIOPA 2022 IVONTS OCD OMON En GO > NO NOTAT prap Crow Crowd b. Estimating weighed average corp WACC) Requited return on bond PV Maataaimha 100005 D SPC Tag con london Agregado m. 54,02000 WESTIT . Estimating the weighted average cost of capital (WACC). 5100000 2.102 sa 345 51.000 52,15665 Required return on bond by 70 Par V Number of bands and 71 touch 22 Number of payments roman Penodic coupon Bond price Ambalbond Strom Banda 7 Bondyed 79 Required return on Mock Beta O ore 2 Mulp Romum org Two Taxe WACC 10 400 2015 70 c. Estimating the pershare Value of ET prestock Actual Propected Practed Projected Projected Projected Projected Projecte Assume long-term growth rate of 2000 2021 2002 2003 2004 2025 2000 5% begins in 2027 2027 FCE 207 Expected growth Ven 2007 Carsch Town PV of open 10 Ote Price per 2.240 mm
