Question
Assuming the same SG&A predictions as in Part D the company's goal is to break-even over the four-year projected period 2021 through 2024, where breaking
Assuming the same SG&A predictions as in Part D the company's goal is to break-even over the four-year projected period 2021 through 2024, where breaking even is defined as showing a non-negative sum of the Net Incomes for those four years. Assume also a worsening of the CGS Ratio to 61.4% and an aggressive Advertising campaign that will increase Advertising expenses by $73 million dollars each year over the previous year (instead of the $22 million dollars in Part A). What is the minimum Sales Revenue Growth Rate that would be necessary for the company to break-even (as defined above)? Show your answer to one decimal place (e.g., 5.3%). Indicate your answer on the sheet in a "Text Box" and also use an arrow to point from the textbox to the data that support your answer
INPUT VARIABLES Sales Revenue Growth Rate CGS Ratio Tax Rate SG&A Growth Rate Depreciation and Amortization Growth Rate Rental Expense Growth Rate Other Expense Growth Rate Advertising Increase ($ Millions) -5.0% 61.4% 25% 39% 24% 0% 17% $73 All Figures in Millions of Dollars 2018 2019 2020 2021 2022 2023 2024 REVENUE Sales Revenue Cost of Goods Sold (CGS) Gross Profit $43,862 17,520 $26,342 $40,265 17,998 $22,267 $50,198 18,245 $31,953 $ 47,688 29,280 $18,408 $45,304 27,816 $17,487 $43,039 26,426 $ 16,613 $40,887 25,104 $15,782 EXPENSE Selling, General, and Administrative (SG&A) Advertising Depreciation and Amortization Rental Expense Other Expense Total Expenses 2,135 1,275 2,574 2,228 3,130 $11,342 1,825 1,176 2,479 2,228 3,200 $10,908 2,119 1,472 3,242 2,228 5,430 $14,491 2,945 1,545 4,020 2,228 6,353 $17,092 4,094 1,618 4,985 2,228 7,433 $20,358 5,691 1,691 6,181 2,228 8,697 $24,488 7,910 1,764 7,665 2,228 10,175 $29,742 EBT (Earnings Before Taxes) Taxes Expense Net Income $15,000 2,988 $12,012 $11,359 3,544 $7,815 $17,462 3,955 $13,507 $1,316 329 $987 -$2,871 0 -$2,871 -$7,875 0 -$7,875 $13,960 0 -$ 13,960Step 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