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)
- Investment cash flows: Six Twelve Inc. is considering opening up a new convenience store in downtown New York City. The expected annual revenue is $800,000. To estimate the increase in working capital, analysts estimate the ratio of cash and cash equivalents to revenue to be 0.03 and the ratio of receivables, inventories, and payables to revenue to be 0.05, 0.10, and 0.04, respectively in the same industry. What is the incremental cash flows related to working capital when the store is opened?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_forwardUneven Cash Flows; NPV; Sensitivity Analysis MaxiCare Corporation, a not-for-profit organization, specializes in health care for senior citizens. Management is considering whether to expand operations by opening a new chain of care centers in the inner city of large metropolitan areas. For a new facility, initial cash outlays for lease, renovations, net working capital, training, and other costs are expected to be about $15 million. The corporation expects the cash inflows of each new facility in its first year of operation to equal the initial investment outlay for the facility. Net cash inflows are expected to increase to $1 million in each of years 2 and 3; $2.5 million in year 4; and $3 million in each of years 5 through 10. The lease agreement for the facility will expire at the end of year 10, and MaxiCare expects the cost to close a facility will pretty much exhaust all cash proceeds from the disposal. Cost of capital for MaxiCare is estimated as 12%. Assume that all cash flows…arrow_forward
- Cash conversion cycle Consider the case of Jealous Leopard Trading Company: Jealous Leopard Trading Company is a mature firm that has a stable flow of business. The following data was taken from its financial statements last year: Annual sales $10,200,000 Cost of goods sold $8,160,000 Inventory $3,100,000 Accounts receivable $2,200,000 Accounts payable $2,500,000 Leopard Trading’s CFO is interested in determining the length of time funds are tied up in working capital. Use the information in the preceding table to complete the following table. (Note: Use 365 days as the length of a year in all calculations, and round all values to two decimal places for the next four parts.) Inventory conversion period (days) Average collection period (days) Payables deferral period (days) Cash conversion cycle (days)arrow_forwardCash management is a very important function of managers. Companies need to manage their operations in a way that they can sustain growth and yet not run out of cash. Consider the case of the Extensive Enterprise Inc.: Extensive Enterprise Inc. has forecasted sales of $30,000,000 for next year and expects its cost of goods sold (COGS) to remain at 60% of sales. Currently, the firm holds $2,900,000 in inventories, $1,800,000 in accounts receivable, and $2,700,000 in accounts payable. A. Approximately how long does it take Extensive Enterprise to convert its raw materials to its finished products and then to sell those goods? (Note: In all calculations, assume that there are 365 days in a year.) 55.87 days 44.11 days 58.81 days 64.69 days B. On average, it takes from the time a sale is made until the time cash is collected from customers. (Calculation required) C. Extensive Enterprise relies on customer credit when it buys raw…arrow_forwardCash conversion cycle American Products is concerned about managing cash effi-ciently. On average, inventories have an age of 80 days, and accounts receivable are collected in 40 days. Accounts payable are paid approximately 30 days after they arise. The firm has annual sales of about $30 million. Goods sold total $20 million, and purchases are $15 million. c. Calculate the amount of resources needed to support the firm’s cash conversion cycle?arrow_forward
- Appalachian Registers, Inc. (ARI) has current sales of $50 million. Sales are expected to grow to $75 million next year. ARI currently has accounts receivable of $11 million, inventories of $15 million, and net fixed assets of $17 million. These assets are expected to grow at the same rate as sales over the next year. Accounts payable are expected to increase from their current level of $15 million to a new level of $20 million next year. ARI wants to increase its cash balance at the end of next year by $3 million over its current cash balances, which average $4 million. Earnings after taxes next year are forecasted to be $10 million. Next year, ARI plans to pay dividends of $1 million, up from $500,000 this year. ARI’s marginal tax rate is 34 percent. How much external financing is required by ARI next year? Enter your answer in millions. For example, an answer of $1.2 million should be entered as 1.2, not 1,200,000. Round your answer to two decimal places. $ _____ million ?arrow_forwardCash management is a very important function of managers. Companies need to manage their operations in a way that they can sustain growth and yet not run out of cash. Consider the case of the Red Hamster Manufacturing Inc.: Red Hamster Manufacturing Inc. has forecasted sales of $30,000,000 for next year and expects its cost of goods sold (COGS) to remain at 80% of sales. Currently, the firm holds $2,800,000 in inventories, $2,200,000 in accounts receivable, and $2,600,000 in accounts payable. Approximately how long does it take Red Hamster Manufacturing to convert its raw materials to its finished products and then to sell those goods? (Note: Use 365 days as the length of a year in all calculations, and round all values to two decimal places.) a) 42.58 days b) 40.45 days c) 38.32 days d) 31.94 days On average, it takes (___) from the time a sale is made until the time cash is collected from customers. Red Hamster Manufacturing…arrow_forwardRelaxing Collection Efforts The Boyd Corporation has annual credit sales of 1.6 million. Current expenses for the collection department are 35,000, bad-debt losses are 1.5%, and the days sales outstanding is 30 days. The firm is considering easing its collection efforts such that collection expenses will be reduced to 22,000 per year. The change is expected to increase bad-debt losses to 2.5% and to increase the days sales outstanding to 45 days. In addition, sales are expected to increase to 1,625,000 per year. Should the firm relax collection efforts if the opportunity cost of funds is 16%, the variable cost ratio is 75%, and taxes are 40%?arrow_forward
- CORPORATE VALUATION Dantzler Corporation is a fast-growing supplier of office products. Analysts project the following free cash flows (FCFs) during the next 3 years, after which FCF is expected to grow at a constant 7% rate. Dantzler's WACC is 12%. *Chart is included as a screenshot* What is Dantzler's horizon, or continuing, value? (Hint: Find the value of all free cash flows beyond Year 3 discounted back to Year 3.) Round your answer to two decimal places. Enter your answer in millions. For example, an answer of $13,550,000 should be entered as 13.55.$ million What is the firm's value today? Round your answer to two decimal places. Enter your answer in millions. For example, an answer of $13,550,000 should be entered as 13.55. Do not round your intermediate calculations.$ million Suppose Dantzler has $102 million of debt and 30 million shares of stock outstanding. What is your estimate of the current price per share? Round your answer to two decimal places. Write out your answer…arrow_forwardFree Cash Flow (FCF) Carter Swimming Pools has $24 million in net operating profit after taxes (NOPAT) in the current year. Carter has $16 million in total net operating assets in the current year and had $14 million in the previous year. What is its free cash flow? Enter your answer in dollars. For example, an answer of $1.2 million should be entered as 1,200,000. Round your answer to the nearest dollar. $arrow_forward[EXCEL] Investment cash flows: Keswick Supply Company wants to set up a division that provides copy and fax services to businesses. Customers will be given 20 days to pay for such services. The annual revenue of the division is estimated to be $25,000. Assuming that the customers take the full 20 days to pay, what is the incremental cash flow associated with accounts receivable? Please use excel.arrow_forward
- Intermediate Financial Management (MindTap Course...FinanceISBN:9781337395083Author:Eugene F. Brigham, Phillip R. DavesPublisher:Cengage LearningEBK CONTEMPORARY FINANCIAL MANAGEMENTFinanceISBN:9781337514835Author:MOYERPublisher:CENGAGE LEARNING - CONSIGNMENTCornerstones of Financial AccountingAccountingISBN:9781337690881Author:Jay Rich, Jeff JonesPublisher:Cengage Learning