Forecast and Integrate Capex and D&A
show formulas used
H (10) 2021 HY 2022 FY K 20 2024 FY 10 2023 FY 80 30 2025 FY N 50 2022 FY 40 2026 FY O 60 2028 FY Outer years P 70 2029 FY R 90 20:31 FY 2030 FY S 10.0 203 FY Term Inne year OSA C G 1 F1SE20) 2 Ninc USD Mons 2020 3 F01 HY 4 ESSE1112 5 Inputs 30 31 32 Forecast drivers 23 Revenue growth ) 34 EINT magn) 3339 35 Capes of 36 Caperto DOO 37 30 Terminal value drivers 30 Revence growth (%) 40 ET magn 11 Capers of Cape DAAD 1900 15.50 5.15% 1417 KASSI K51 10 101 2016 6.74 5 50 TON 16.614 16 52 1643% 460% 16.30 367 1626 300 16 17% 2454 1600 2009 100% 16.7 Tasks for next week 1) Forecast and worse Cape 44 45 16 UAB C G H 1 M N 1 O Q P FESSES (20) R (10) 10 20 310 4.0 50 2 50 80 Nike, Inc - USD Milions 70 90 2020 100 2021 2022 2023 2024 2025 2006 2027 2028 3 2020 20:30 2031 F(G1 HY 20:12 HY FY FY FY FY FY FY FY FY 4 ESSE115 E12 FY FY FY inner Yes 5 Inputs Outer years Terminal 15 Number of histoncal years 16 Tarrate 17 10 Forecasting inputs 10 20 Forecasted financials 21 Revenue 3740304160047 2700 53.7630 59.1950 640796683981 72102875,406,7 78,1751 80,5191 32.400 9 84, 1407 22 EBIT 9370 6,7010 9.0240 0106418 11.2007 11 8573 126 12,700 3 13.0200 13,2600 13.4695 23 Caper 24 DRA 25 26 Broker forecasts 27 Revenue 47 276,763091960 20 ENT 67010 90240 20 Caper 30 OSA INVERNESSES Entenvers Tout O crede H - J K L M N o P Q R T AB E F G FIF1 SESSM1,F1+1) (2.0) Nike Inc - USD Millions 10,12"G1) 2020 IF(G1OTHY FYN HY EBSXE118' SE12 Inputs (10) 2021 HY 2022 FY 1.0 2023 FY Inner years 2.0 2024 FY 30 2025 FY 4.0 2026 FY 5.0 2027 FY 60 2028 FY 7.0 2029 FY 80 2030 FY 9.0 2031 FY S 10.0 2032 FY Terminal Outer years 37.403,0 44,5380 47.276.0 53.763,0 59,1950 64,0796 68 398.1 72,162,8 75,406.7 78.175.1 80,519,1 82.490 9 84,140,7 3.11506,9370 6.70109.0240 9,883.0 10.641.8 11,298.7 11,8573 12,324 612.709 3 13.020.9 13.289013.4625 fax Forecasting inputs 19 20 Forecasted financials 21 Revenue 22 EBIT 23 Capes 24 DRA 25 25 Broker forecasts 22 Revenue 20 EDIT 29 Capex 30 DEA 31 32 Forecast drivers 33 Revenue growth 34 EBIT margin (6) 35 Capers of 30 Caperlo DLA 37 472700 53.7630 59 1950 6,70109,0240 19.00% 6.15% 1372410.10% 8334 15.58% 14.17% 16,78% 16,70% SE333 (US$1.51) 8 26% 674% 5.50% 450N 3.67% 16 61% 16.52% 1643% 16 34% 16.26% 3.00% 16.17% 245% 2.00% 16.09% 16.00% innor years Outer years Inputs Forecast drivers Revenue growth (%) EBIT margin (%) Capex as % of sales (%) Capex to D&A (X) 19.08% 15.58% 6.15% 13.72% 14.17% 16.78% =K33"($E39/K33) (1/($S$1-K$1)) 8.25% 6.74% 5.50% 4.50% 16.61% 16.52% 16.43% 16.34% 10.10% 16.70% 8.33% 2 3 4 15 36 37 38 39 40 41 42 43 44 Terminal value drivers Revenue growth (%) EBIT margin (%) Capex as % of sales (%) Capex to DSA (X) 2.00% 16.00% 3.00% 1.00x Tasks for next week
