Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please answer yellow and orange color cells. Information (dollar figures in millions) Reven u e Cost Of goods sold SG&A and Other indirect expenses Accounts
Please answer yellow and orange color cells.
Information (dollar figures in millions) Reven u e Cost Of goods sold SG&A and Other indirect expenses Accounts receivable Inventory PP&E Accounts payable Total liabilities Total equ Ity Depreciation CAPEX Working capital funding gap (in days) Asset tu rnover 2017A 750,888 281,418 54,609 80,247 55,604 98,721 16,964 415,955 326,625 13,771 2018A 569,589 372,497 60,472 78,177 53,631 114,182 18,943 403,900 331,527 54,240 2019A 714,309 333,111 66,619 70,528 55,211 121,736 15,589 463,115 394,123 51,115 2020A 800,891 339,731 125,228 85,366 70,998 135,634 24,625 437,055 222,182 7,091 2021A 753,377 337,238 123,085 60,299 72,196 151,246 43,665 518,656 703,208 13,179 2022E 95,880 26,702 27,887 425,598 34,690 2023E 96,343 39,662 40,347 563,269 27,018 XS. Use the assumptions described in the table when modeling items that are not computed as totals or subtotals, or that are not computed using information available from the model su Variableo Revenuee Cost of goods soW SG&A and other indirect expenses Working capital funding gapo Modeling assu mption so Annual revenue growth in each forecast year is 1.15 percentage points less than the average annual revenue growth rate from the last 3 years of the historical period Cost of goods sold to revenue in each forecast year is 2.39 percentage points worse than the ratio from the previous yeare SG&A and other indirect expenses to sales in each forecast year is 1.19 percentage points better than the ratio from the second last year of the historical period (the year immediately before the last year of the historical period)o PP&E in the first year of the forecast period is $5,723 less than PP&E from the previous year and PP&E in each subsequent year is $6,159 greater than PP&E from the previous yea The working capital funding gap in each forecast year is 1.23 days greater than the working capital funding gap from the previous yea
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