Net cash flows for a marketing campaign Marcus Tube, a manufacturer of high quality aluminum buaing, has inaintained stable sales and profits over the past 10 years. Although the market for allminum tubing has been expanding by 5% per year, Marcus has been unsuccessful in sharing This growth. To Incrasse ts sales the form is considering an aggressive marketing campaign that centers on regularly ning ads in all relevant trade journals and exhibiting products at all major regional and national trade shoes. The campaign is expected to require en sub/tex-deductible exorditure of $145,100 aver the next 5 years. SRIRS CRVENUE, a shown in the income statement for 2014 totale $20.11.com. If the proposed markering 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 campagnesles 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 78% of sales, general and administrative expense (exclusive of any marketing campaign oullays) is expected to remain al 12% of sales, and annual depreciation expense is expected to remain at 3180,000. Assuming 8. 10% tax rate. find the nel cash flow over the next 5 years 828ociated with the propceed marketing campaign. The annual Operating cash flow without the marketing campaign wil be $ 1398000. (Round in the neares: dollar.) Calculate the net portsatte taxes and operating cash flows with the marketing campaign below: Round to the nearest $1,000. Data Table Marcus Tube Calculation of Relevant Cash Flow ($000) - 2019 Data Table $ $ $ (Click on the ivan located on the top right corner of the data table below in order copy its contenta o spreadsheet) Marcus Tube Sales Forecast Year Sales revenue 2019 S20.600.000 2020 21,100,000 2021 21 in ND 2022 22.800.000 2028 23.000.000 Sales Cast of good sold (798) Gross profit Le Operating expenses General and administrative expense (12%) Marketing campaign Depreciation Tatal operating expenses Nel prufit balur mes Less: Tawes (40%) Nel profit aller faxee Operating cash flow Incremental cash for $ $ $ $ $ $ Gick on the icon located on the top-1ght comer of the datatable below in order to copy its contents into a spraushout) Marcus Tube Income Statement for . the Year Ended December 31, 2018 Sales revenue $20 100 000 Less: Cost of goods sold(78% 15.676.000 Gross profits $4422 OND Less: Operating expenses General and scministrative expense 12% $2.412.000 Depreciation axpense 490.CIUS Total operating expansin $2892 000 Famings before Interest and taxes $1,530,000 LARS: Taxas (409) 612 000 Nat operating note after taxes S918.000 Print Done 5 $ $ 5
