Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed

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,960

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

Step: 3

blur-text-image

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

Routledge Handbook Of Environmental Accounting

Authors: Jan Bebbington, Carlos Larrinaga, Brendan O'Dwyer, Ian Thomson

1st Edition

0367724901, 9780367724900

More Books

Students also viewed these Accounting questions

Question

What do you mean by dual mode operation?

Answered: 1 week ago

Question

Explain the difference between `==` and `===` in JavaScript.

Answered: 1 week ago