Relevant cash flows for a marketing campaignMarcus Tube, a manufacturer of high-quality aluminum tubing, has maintained stable sales and profits over the past 10 years. Although the market for aluminum tubing has been expanding by

3%

per year, Marcus has been unsuccessful in sharing this growth. To increase its sales, the firm is considering an aggressive marketing campaign that centers on regularly running ads in all relevant trade journals and exhibiting products at all major regional and national trade shows. The campaign is expected to require an annual tax-deductible expenditure of

$156,000

over the next 5 years. Sales revenue, as shown in the income statement for

2020

LOADING...

,

totaled

$20,100,000.

If the proposed marketing campaign is not initiated, sales are expected to remain at this level in each of the next 5 years,

2021

through

2025.

With the marketing campaign, sales are expected to rise to the levels shown in the table

LOADING...

for each of the next 5 years; cost of goods sold is expected to remain at

71%

of sales; general and administrative expense (exclusive of any marketing campaign outlays) is expected to remain at

11%

of sales; and annual depreciation expense is expected to remain at

$490,000.

Assuming a

21%

tax rate, find the net cash flows over the next 5 years associated with the proposed marketing campaign.

Relevant cash flows for a marketing campaign Marcus Tube, a manufacturer of high-quality aluminum tubing, has maintained stable sales and profits over the past 10 years. Although the market for aluminum tubing has been expanding by 3% per year, Marcus has been unsuccessful in sharing this growth. To increase its sales, the firm is considering an aggressive marketing campaign that centers on regularly running ads in all relevant trade journals and exhibiting products at all major regional and national trade shows. The campaign is expected to require an annual tax-deductible expenditure of $156,000 over the next 5 years. Sales revenue, as shown in the income statement for 2020 totaled $20,100,000. If the proposed marketing campaign is not initiated, sales are expected to remain at this level in each of the next 5 years, 2021 through 2025. With the marketing campaign, sales are expected to rise to the levels shown in the table for each of the next 5 years; cost of goods sold is expected to remain at 71% of sales, general and administrative expense (exclusive of any marketing campaign outlays) is expected to remain at 11% of sales; and annual depreciation expense is expected to remain at $490,000. Assuming a 21% tax rate, find the net cash flows over the next 5 years associated with the proposed marketing campaign. The annual operating cash flow without the marketing campaign will be $1. (Round to the nearest dollar.) Data Table Data Table (Click on the icon here e in order to copy the contents of the data table below into a spreadsheet.) (Click on the icon here in order to copy the contents of the data table below into a spreadsheet.) $20,100,000 14.271.000 $5,829,000 Marcus Tube Sales Forecast Year Sales revenue 2021 $20.600.000 2022 21,100,000 2023 21,600,000 2024 22,600,000 2025 23,600,000 Marcus Tube Income Statement for the Year Ended December 31, 2020 Sales revenue Less: Cost of goods sold (71%) Gross profits Less: Operating expenses General and administrative expense (11%) Depreciation expense Total operating expense Earnings before interest and taxes Less: Taxes (21%) Net operating profit after taxes Enter your answ $2,211,000 490.000 $2,701,000 $3,128,000 656,880 $2,471,120 parts remaining Print Done Clear All