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 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 websites and exhibiting products at all major regional and national trade shows. The campaign is expected to require an annual tax-deductible expenditure of $150,000 over the next 5 years. Sales revenue, as shown in the accompanying income statement for 2018, totaled $20,000,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 accompanying table for each of the next 5 years; cost of goods sold is expected to remain at 80% of sales; general and administrative expense (exclusive of any marketing campaign outlays) is expected to remain at 10% of sales; and annual
Marcus Tube Income Statement for the Year Ended December 31, 2018
Sales revenue | $20,000,000 |
Less: Cost of goods sold (80%) | 16,000,000 |
Gross profits | $ 4,000,000 |
Less: Operating expenses | |
General and administrative expense (10%) | $ 2,000,000 |
Depreciation expense | 500,000 |
Total operating expense | $ 2,500,000 |
Earnings before interest and taxes | $ 1,500,000 |
Less: Taxes (rate= 40%) | 600,000 |
Net operating profit after taxes | $ 900,,000 |
Marcus Tube Sales
Year | Sales revenue |
2019 | $20,500,000 |
2020 | 21,00,000 |
2021 | 21,500,000 |
2022 | 22,500,000 |
2023 | 23,500,000 |
Want to see the full answer?
Check out a sample textbook solutionChapter 11 Solutions
Gitman: Principl Manageri Finance_15 (15th Edition) (What's New in Finance)
- Economics GO GREEN Recycling Company starts its recycling business today. It recycles paper, cardboard, aluminum, and glass. The initial investment for this business is $510,000. The net cash flow at the end of the first year of business is forecast to be only $10,000. But it is expected that the net cash flow will increase at a rate of $40,000 per year starting from the end of Year 2. (а) Draw a cash flow diagram for the first 5 years. (b) What is the present worth of ALL the cashflows for the first 5 years at an interest rate of 10% per year? Round off your final answer to the nearest integer. (c) If GO GREEN sells its business for $710,000 at the end of Year 5, can we say this business has achieved an internal rate of return greater than 20% per year? Why?arrow_forwardMarcus 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 $152,000 over the next 5 years. Sales revenue, as shown in the income statement for 2020 Marcus Tube Income Statement for the Year Ended December 31, 2020 Sales revenue $19,400,000 Less: Cost of goods sold (78%) 15,132,000 Gross profits $4,268,000 Less: Operating expenses General and administrative expense (12%) $2,328,000 Depreciation expense 490,000 Total operating expense $2,818,000 Earnings before interest and taxes $1,450,000…arrow_forwardAssume a company's Income Statement for Year 9 is as follows: Year 9 (in 000s) Income Statement Data Total Revenues Cost of Goods Sold Delivery Costs Marketing Costs Administrative Expenses Operating Profit (Loss) Other Income (Expense) Interest Income (Expense) Pre-tax Profit (Loss) Income Taxes Net Profit (Loss) $610,000 370,000 40,000 48,000 10,000 142,000 -2,000 -8,500 131,500 39,450 $ 92,050 Based on the above income statement data, the company's interest coverage ratio a operating profit margin are O 19.29 and 15.1%. 15.47 and 23.3%. 16.71 and 23.3%. 10.83 and 15.1%. O 17.22 and 24.6%.arrow_forward
- View Policies Current Attempt in Progress Linda is hoping that an investment of $30,000 will provide additional revenue to the store of $18,000 per year for 3 years. Her partner in crime, Robert, is confident that a larger investment of $40,200 will be required to bring in a steady flow of $22,800 in new revenue per year for 3 years. Determine the discounted payback period for each investment (using before-tax cash flows). The company's required rate of return is 8%. (Round present value factor calculations to 5 decimal places, e.g. 1.25124 and final answers to 2 decimal places e.g. 15.25.) Click here to view the factor table Discounted payback period Linda years Whose investment appears to better use the company's resources? Robert yearsarrow_forwardNakamichi Bancorp has made an investment in banking software at a cost of $1,430,438. Management expects productivity gains and cost savings over the next several years. If, as a result of this investment, the firm is expected to generate additional cash flows of $667,344, $725,331, $475,138, and $343,237 over the next four years, what is the investment’s payback period? (Round answer to 2 decimal places, e.g. 15.25.) Payback period is yearsarrow_forwardPetal Providers Corporation opens and operates “mega” floral stores in the U.S. The idea behind the super store concept is to model the U.S. floral industry after its European counterparts whose flower markets generally have larger selections at lower prices. Revenues were $1 million with net profit of $50,000 last year when the first “mega” Petal Providers floral outlet was opened. If the economy grows rapidly next year, Petal Providers expects its sales to growth by 50 percent. However, if the economy exhibits average growth, Petal Providers expects a sales growth of 30 percent. For a slow economic growth scenario, sales are expected to grow next year at a 10 percent rate. Management estimates the probability of each scenario occurring to be: rapid growth (.30); average growth (.50), and slow growth (.20). Petal Providers net profit margins are also expected to vary with the level of economic activity next year. If slow grow occurs, the net profit margin is expected to be 5…arrow_forward
- [EXCEL] Payback: Nakamichi Bancorp has made an investment in banking software at a cost of $1,875,000. Management expects productivity gains and cost savings over the next several years. If, as a result of this investment, the firm is expected to generate additional cash flows of $586,212, $713,277, $431,199, and $318,697 over the next four years, what is the investment's payback period?arrow_forwardYour consulting firm was recently hired to improve the performance of Realyou Inc, which is highly profitable but has been experiencing cash shortages due to its high growth rate. As one part of your analysis, you want to determine the firm’s cash conversion cycle. Using the following information and a 365-day year, what is the firm’s present cash conversion cycle? Average inventory P75,000 Annual sales 500,000 Annual cost of goods sold 360,000 Average accounts receivable 160,000 Average accounts payable 25,000arrow_forwardWhich one is correct answer please confirm? QUESTION 39 Getrag expects its sales to increase 20% next year from its current level of $4.7 million. Getrag has current assets of $660,000, net fixed assets of $1.5 million, and current liabilities of $462,000. All assets are expected to grow proportionately with sales. If Getrag has a net profit margin of 10%, what additional financing will be needed to support the increase in sales? Getrag does not pay dividends. a. $339,600 b. No financing needed, surplus of $224,400 c. No financing needed, surplus of $524,400 d. $283,200arrow_forward
- Please find the Operating Cash Flow for the first 5 years with the following information below: Currently, Ljutic A/I Inc. has hired a consulting firm (Oakland Association-OA) to estimate the size of the market and hence expected unit sales for its main product (E-toral application sensor). OA’s work resulted in unit sales estimates of 318,331, 341,342, 368,769, 383,432, and 376,532 units respectively for the next five years conditioned on Ljutic adhering to an average sales price of $568 per unit for the first two years and $387 in years three, four, and five. From that point going forward, growth in unit sales is predicted to be 2.72% indefinitely. The results of an independent outside analysis by a leading market research firm has determined that the company can manufacture its product line at a variable cost per unit expected to be $63.47 growing at 2.23% per year for the first 5 years and 3.17% per year indefinitely thereafter while overall fixed costs are estimated to be…arrow_forwardA firm is considering several policy changes to increase sales. It will increase inventory by $10,000 it will offer more liberal sales terms but will result in average receivables increasing by $65,000. These actions are expected to increase sales by $800,000 per year, and cost of goods will remain at 80% of sales. Because of the firm’s increased purchase of its won production needs, average payable increases by $35,000.What factors should they consider when making these decisions? What effects would they have on the firm’s cash cycle? Please select three financial ratios they should consider and whyarrow_forwardA new advertising campaign by a company that manufactures products that rely on biometrics, surveillance, and satellite technologies resulted in the cash flows shown (in $1000 units). Develop one spreadsheet that displays the following: external rate of return using both the ROIC method with ir = 30% per year, and the modified ROR approach with ir = 30% and ib = 10% per year; and the unique or multiple internal rate of return value(s) indicated by the two multiple-root sign tests.arrow_forward
- EBK CONTEMPORARY FINANCIAL MANAGEMENTFinanceISBN:9781337514835Author:MOYERPublisher:CENGAGE LEARNING - CONSIGNMENT