Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Net 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

image text in transcribedimage text in transcribed

Net 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 4% 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 $159,000 over the next 5 years. Sales revenue, as shown in the income statement for 2018 , totaled $20,700,000. If the proposed marketing campaign is not initiated, sales are expected to remain at this level in each of the next 5 years, 2019 through 2023. 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 74% of sales, general and administrative expense (exclusive of any marketing campaign outlays) is expected to remain at 10% of sales, and annual depreciation expense is expected to remain at $510,000. Assuming a 40% 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 $ 0(Round to the nearest dollar.) Data Table X Data Table (Click on the icon located on the top-right corner of the data table below in order to copy its contents into a spreadsheet.) (Click on the icon located on the top-right corner of the data table below in order to copy its contents into a spreadsheet.) $20,700,000 15,318,000 $5,382,000 Marcus Tube Income Statement for the Year Ended December 31, 2018 Sales revenue Less: Cost of goods sold (74%) Gross profits Less: Operating expenses General and administrative expense (10%) Depreciation expense Total operating expense Earnings before interest and taxes Less: Taxes (40%) Net operating profit after taxes Marcus Tube Sales Forecast 2 Year Sales revenue 2019 $21,200,000 2020 21,700,000 2021 22,200,000 2022 23,200,000 2023 24,200,000 $2,070,000 510,000 $2,580,000 $2,802,000 1,120,800 $1,681,200 Print Done Print Done Net 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 4% 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 $159,000 over the next 5 years. Sales revenue, as shown in the income statement for 2018 , totaled $20,700,000. If the proposed marketing campaign is not initiated, sales are expected to remain at this level in each of the next 5 years, 2019 through 2023. 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 74% of sales, general and administrative expense (exclusive of any marketing campaign outlays) is expected to remain at 10% of sales; and annual depreciation expense is expected to remain at $510,000. Assuming a 40% tax rate, find the net cash flows over the next 5 years associated with the proposed marketing campaign. i Data Table - X i Data Table - X (Click on the icon located on the top-right corner of the data table below in order to copy its contents into a spreadsheet.) (Click on the icon located on the top-right corner of the data table below in order to copy its contents into a spreadsheet.) 2 $20,700,000 15,318,000 $5,382,000 Marcus Tube Income Statement for the Year Ended December 31, 2018 Sales revenue Less: Cost of goods sold (74%) Gross profits Less: Operating expenses General and administrative expense (10%) Depreciation expense Total operating expense Earnings before interest and taxes Less: Taxes (40%) Net operating profit after taxes Marcus Tube Sales Forecast Year Sales revenue 2019 $21,200,000 2020 21,700,000 2021 22,200,000 23,200,000 2023 24,200,000 2022 $2,070,000 510,000 $2,580,000 $2,802,000 1,120,800 $1,681,200 Print Done Print Done

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

Contemporary Issues In Behavioral Finance

Authors: Simon Grima

1st Edition

1787698823, 978-1787698826

More Books

Students also viewed these Finance questions

Question

Let f(x) = x - 3 / x + 1. Show that f(f(f(x))) = x, provided x 1.

Answered: 1 week ago

Question

2. How should this be dealt with by the organisation?

Answered: 1 week ago

Question

explain what is meant by the term fair dismissal

Answered: 1 week ago