Answered step by step
Verified Expert Solution
Link Copied!

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!

image text in transcribedimage text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Healthcare Finance An Introduction To Accounting And Financial Management

Authors: Louis C. Gapenski

4th Edition

1567932800, 978-1567932805

More Books

Students also viewed these Finance questions

Question

What does the cross elasticity of demand measure?

Answered: 1 week ago