Answered step by step
Verified Expert Solution
Question
1 Approved Answer
How do you change the cells highlighted in yellow to get the answers in blue? I will thumbs up immediately thank you! 2016 2017 2018
How do you change the cells highlighted in yellow to get the answers in blue? I will thumbs up immediately thank you!
2016 2017 2018 2020 E 2021 E 2022 E 2023 E 1,521,282 27,861 169,596 2,040,017 30,911 234,659.36 2,142,018 34,983 246,392.33 2,142,018 39,591 246,392.33 2,206,279 44,806 253,784.10 Sales Depreciation Net Fixed Assets Depreciation Rate (D) Cap-Ex Maintenance Cap-Ex Net New Cap-Ex Net New as % of New Sales 1,552,351 10,902 176,421 6.18% 17,727 10,902.00 6,825 0.44% 1,773,206 35,147 200,901 17.49% 59,627 35,147.00 24,480 1.38% 2019 Average 2017-2019 2,019,819 30,632 232,336 13.18% 13.17% 62,067 30,632.00 31,435 1.56% 1.13% 33,234 30,911.00 22,961 46,716 34,982.82 24,109 39,591 39,591.00 24,109 52,198 44,806.21 24,832 Cap-Ex Maintenance Cap-Ex Net New Cap-Ex 2020 $ 33,234 $ 2022 $ 39,591 $ 2023 $ 24,832 $ 33,234 32,365 10,373 SALES FORECAST (in thousands of US dollars) Sales % yy growth 2020 E 2,040,017 1.00% 2021 E 2,142,018 5.00% 2022 E 2,142,018 0.00% 2023 E 2,206,279 3.00% 2016 2017 2018 2020 E 2021 E 2022 E 2023 E 1,521,282 27,861 169,596 2,040,017 30,911 234,659.36 2,142,018 34,983 246,392.33 2,142,018 39,591 246,392.33 2,206,279 44,806 253,784.10 Sales Depreciation Net Fixed Assets Depreciation Rate (D) Cap-Ex Maintenance Cap-Ex Net New Cap-Ex Net New as % of New Sales 1,552,351 10,902 176,421 6.18% 17,727 10,902.00 6,825 0.44% 1,773,206 35,147 200,901 17.49% 59,627 35,147.00 24,480 1.38% 2019 Average 2017-2019 2,019,819 30,632 232,336 13.18% 13.17% 62,067 30,632.00 31,435 1.56% 1.13% 33,234 30,911.00 22,961 46,716 34,982.82 24,109 39,591 39,591.00 24,109 52,198 44,806.21 24,832 Cap-Ex Maintenance Cap-Ex Net New Cap-Ex 2020 $ 33,234 $ 2022 $ 39,591 $ 2023 $ 24,832 $ 33,234 32,365 10,373 SALES FORECAST (in thousands of US dollars) Sales % yy growth 2020 E 2,040,017 1.00% 2021 E 2,142,018 5.00% 2022 E 2,142,018 0.00% 2023 E 2,206,279 3.00%
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started