60.1K

Verified Solution

Link Copied!

forecast and integrate capex and d&a

fill in the rows where it says either "Capex" or "D&A"

please show formulas used for them.

these are not open ended questions. its plug in formulas to find the row answers...

is this fixed assets? here is income statement

G 201 2020 HY H (10) 2021 HY 2022 FY 10 2023 FY Inne year K 20 2024 FY 30 2025 FY 40 2026 FY N 50 2022 FY o 60 2028 FY Outer years P 20 2020 FY O 80 2000 FY R 90 2031 FY S 10.0 2032 FY Term DSA c F1 SE 2 Nine USD Mons F01 4 EMSE1112 5 Inputs 30 31 32 Forecast drivers Revenue growth (5) 34 ENT) 35 Capers of 36 Caperto 37 30 Terminal value drivers 30 Fevence growth (3) 40 ET magn 11 Capers of DA) 190 15 50% 6.15 1417 13725 16.7 KOKOISS K1 8251 6.74% 5 50% 16 614 16.52 10 10% 70 8331 4504 1634 3.67% 1626 300% 16 17% 2454 16 09 2009 16.00% 44 45 Tasks for next week 1) Forecast and grade Cape DBA - AB G H M 1 N O FEES (20) P Q R (10) 10 20 310 2 Nake, Inc - USD Milions 4.0 50 50 80 70 90 2020 100 2021 2022 2023 2024 2025 2006 2027 3 2028 2029 20:30 F161 HY 20:32 HY FY 2031 FY FY FY 4 FY -ESSE11" E12 FY FY FY FY FY FY inner years 5 Inputs Outer years Terminal 15 Number of histoncal years 15 Tax rate 17 18 Forecasting inputs 19 Forecasted financials 21 Revenue 37809050047 2760 53.7630 59 1960 640706683981 72162875,4067 78,1751 80 510 1 12.400 9 84 1407 22 EBIT 31150 0 5,7010 90240 9.88310 6418 11.290 7 11 3573 126 12,700313,0200 Cape 13.260 0 134695 24 DRA 25 26 Broker forecasts 27 Revenue 47 2760,7030301950 26 ENT 6.7010 9020 20 30 DRA 31 22 Enter USERS Inputs TE NESRINESS Chede 7 Outer years AB c . G H J K L M N o P Q R S FIF1SES 51,F1+1) (2.0) (10) 1.0 2.0 3.0 4.0 5.0 60 7.0 80 3.0 10.0 Ne, Inc - USD Milions 10,12G1) 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 IF(610 HYFY HY HY FY FY FY FY FY FY FY FY FY FY FY -EBSSE118' SE12 Inner years Terminal Inputs Hax Forecasting inputs 19 20 Forecasted financials 21 Revenue 37.403,0 44,5380 47.276.0 53.763 0 59 1950 64,079,668 398.1 72,1628 75,406.7 78.175.1 80,519,1 82,490.9 84,1407 22 EBIT 3.11506.9370 6.70101 0.024.09.883.0 10.6418 11,298.7 11.8573 12,324 6.12.709 3 13.020.9 13.289.0 13.4625 23 Capex 24 DRA 25 26 Broker forecasts 22 Revenue 20 472760 53,7630 59 1950 EDIT 6.70109,0240 29 Capex 30 DA 31 32 Forecast drivers 33 Revenue growth ) SEMBOSS51.51 19.08% 34 6.15% 13724 10.10% 5.50% EBIT marges (6 8 26% 6.74% 450% 3.67% 300% 8.33% 15.58% 14.17% 16,78% 10.70% 245% 2.00% 35 16 61% 16.62% 1643% 16 34% 16.26% 16.17% Capers of sales 16.09% 16.00% 30 Capo DLA 37 (20) 2020 HY (1:0) 2021 HY 1.0 2023 FY 20 2024 FY Nike, Inc. - USD Milions 3.0 2025 FY 2022 FY 4.0 2026 FY 5.0 2027 FY 60 2028 FY 7.0 2029 FY 8.0 2030 FY 9.0 2031 FY 10.0 2032 FY Income Statement Done Done Forecasted income statement Revenue Operating costs (excl. DSA) EBITDA D&A EBIT Interest expense EBT Tax expense (adjusted) Net Income (adjusted) Post-tax adjustment Net income (reported) 37 4030 44,538 047 2760 53.763,0 59,195,0 640796 68.398.1 72.152.8 75,406.7 78,1751 80,519.1 82.490 9 54,1407 -33169 -36804 40575 -44739 -49312 534378 -57099.4 -603055 -63082.1 65465.967498.3 -69222 -706782 4,234.0 7.734.0 6.701.0 9,024,0 9,883.0 10,641.8 11,298.7 11,857,3 12,324.6 12,709.3 13,020,9 13,269.0 13,462.5 (1.1190) (797) 3,115,0 6,937.0 6,701.09.024.0 9,863.0 10,641.8 11,298.7 11,8573 12,324,6 12,709.3 13,020,9 13,269.0 13,462.5 1890) (262.0) 3,026,0 6,675.0 6.701,0 9,024,0 3,863.0 10.641,8 11,298.7 11,857.3 12,324.6 12,709.3 13,020.9 13,269.0 13,462.5 (3772) (936.9) 2.648.85,738.1 6,701.09.024.00.883.0 10,641,8 11,298.7 11,857,3 12,324.6 12,709.3 13,020,9 13,269.0 13,462.5 (1098) (11.1) 2.539,0 5,727 0 BASE or Corkscrew model 3,1790 3.179.0 3.179.0 3,1790 3,179.0 3.179.0 3.179.0 3.179.0 3.179.0 3.179.0 3,179.0 * Retained samnings reconciliation Beginning of period Not income Dividends End of period 3.179.0 3.179.0 3.1790 3.179.0 3,179,0 3,179.0 3,179,0 3,179.03.179.0 3.179.0 3.179.0 3.179.0 G 201 2020 HY H (10) 2021 HY 2022 FY 10 2023 FY Inne year K 20 2024 FY 30 2025 FY 40 2026 FY N 50 2022 FY o 60 2028 FY Outer years P 20 2020 FY O 80 2000 FY R 90 2031 FY S 10.0 2032 FY Term DSA c F1 SE 2 Nine USD Mons F01 4 EMSE1112 5 Inputs 30 31 32 Forecast drivers Revenue growth (5) 34 ENT) 35 Capers of 36 Caperto 37 30 Terminal value drivers 30 Fevence growth (3) 40 ET magn 11 Capers of DA) 190 15 50% 6.15 1417 13725 16.7 KOKOISS K1 8251 6.74% 5 50% 16 614 16.52 10 10% 70 8331 4504 1634 3.67% 1626 300% 16 17% 2454 16 09 2009 16.00% 44 45 Tasks for next week 1) Forecast and grade Cape DBA - AB G H M 1 N O FEES (20) P Q R (10) 10 20 310 2 Nake, Inc - USD Milions 4.0 50 50 80 70 90 2020 100 2021 2022 2023 2024 2025 2006 2027 3 2028 2029 20:30 F161 HY 20:32 HY FY 2031 FY FY FY 4 FY -ESSE11" E12 FY FY FY FY FY FY inner years 5 Inputs Outer years Terminal 15 Number of histoncal years 15 Tax rate 17 18 Forecasting inputs 19 Forecasted financials 21 Revenue 37809050047 2760 53.7630 59 1960 640706683981 72162875,4067 78,1751 80 510 1 12.400 9 84 1407 22 EBIT 31150 0 5,7010 90240 9.88310 6418 11.290 7 11 3573 126 12,700313,0200 Cape 13.260 0 134695 24 DRA 25 26 Broker forecasts 27 Revenue 47 2760,7030301950 26 ENT 6.7010 9020 20 30 DRA 31 22 Enter USERS Inputs TE NESRINESS Chede 7 Outer years AB c . G H J K L M N o P Q R S FIF1SES 51,F1+1) (2.0) (10) 1.0 2.0 3.0 4.0 5.0 60 7.0 80 3.0 10.0 Ne, Inc - USD Milions 10,12G1) 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 IF(610 HYFY HY HY FY FY FY FY FY FY FY FY FY FY FY -EBSSE118' SE12 Inner years Terminal Inputs Hax Forecasting inputs 19 20 Forecasted financials 21 Revenue 37.403,0 44,5380 47.276.0 53.763 0 59 1950 64,079,668 398.1 72,1628 75,406.7 78.175.1 80,519,1 82,490.9 84,1407 22 EBIT 3.11506.9370 6.70101 0.024.09.883.0 10.6418 11,298.7 11.8573 12,324 6.12.709 3 13.020.9 13.289.0 13.4625 23 Capex 24 DRA 25 26 Broker forecasts 22 Revenue 20 472760 53,7630 59 1950 EDIT 6.70109,0240 29 Capex 30 DA 31 32 Forecast drivers 33 Revenue growth ) SEMBOSS51.51 19.08% 34 6.15% 13724 10.10% 5.50% EBIT marges (6 8 26% 6.74% 450% 3.67% 300% 8.33% 15.58% 14.17% 16,78% 10.70% 245% 2.00% 35 16 61% 16.62% 1643% 16 34% 16.26% 16.17% Capers of sales 16.09% 16.00% 30 Capo DLA 37 (20) 2020 HY (1:0) 2021 HY 1.0 2023 FY 20 2024 FY Nike, Inc. - USD Milions 3.0 2025 FY 2022 FY 4.0 2026 FY 5.0 2027 FY 60 2028 FY 7.0 2029 FY 8.0 2030 FY 9.0 2031 FY 10.0 2032 FY Income Statement Done Done Forecasted income statement Revenue Operating costs (excl. DSA) EBITDA D&A EBIT Interest expense EBT Tax expense (adjusted) Net Income (adjusted) Post-tax adjustment Net income (reported) 37 4030 44,538 047 2760 53.763,0 59,195,0 640796 68.398.1 72.152.8 75,406.7 78,1751 80,519.1 82.490 9 54,1407 -33169 -36804 40575 -44739 -49312 534378 -57099.4 -603055 -63082.1 65465.967498.3 -69222 -706782 4,234.0 7.734.0 6.701.0 9,024,0 9,883.0 10,641.8 11,298.7 11,857,3 12,324.6 12,709.3 13,020,9 13,269.0 13,462.5 (1.1190) (797) 3,115,0 6,937.0 6,701.09.024.0 9,863.0 10,641.8 11,298.7 11,8573 12,324,6 12,709.3 13,020,9 13,269.0 13,462.5 1890) (262.0) 3,026,0 6,675.0 6.701,0 9,024,0 3,863.0 10.641,8 11,298.7 11,857.3 12,324.6 12,709.3 13,020.9 13,269.0 13,462.5 (3772) (936.9) 2.648.85,738.1 6,701.09.024.00.883.0 10,641,8 11,298.7 11,857,3 12,324.6 12,709.3 13,020,9 13,269.0 13,462.5 (1098) (11.1) 2.539,0 5,727 0 BASE or Corkscrew model 3,1790 3.179.0 3.179.0 3,1790 3,179.0 3.179.0 3.179.0 3.179.0 3.179.0 3.179.0 3,179.0 * Retained samnings reconciliation Beginning of period Not income Dividends End of period 3.179.0 3.179.0 3.1790 3.179.0 3,179,0 3,179.0 3,179,0 3,179.03.179.0 3.179.0 3.179.0 3.179.0

Answer & Explanation Solved by verified expert

See Answer