(Calculating free cash flows) Spartan Stores is expanding operations with the introduction of a new distribution center. Not only will sales increase but investment in inventory will decline due to increased efficiencies in getting inventory to showrooms. As a result of this new distribution center, Spartan expects a change in EBIT of $1,000,000. Although inventory expected to drop from $86,000 to $62,000, accounts receivables are expected to climb as a result of increased credit sales from $83,000 to $130,000. In addition, accounts payable are expected to increase from $70,000 to $84,000. This project will also produce $400,000 of bonus depreciation in year 1 and Spartan Stores is in the 36 percent marginal tax rate. What is the project's free cash flow in year 1? The project's free cash flow in year 1 is S (Round to the nearest dollar.)

(Calculating free cash flows) Spartan Stores is expanding operations with the introduction of a new distribution center. Not only will sales increase but investment in inventory will decline due to increased efficiencies in getting inventory to showrooms. As a result of this new distribution center, Spartan expects a change in EBIT of $1,000,000. Although inventory expected to drop from $86,000 to $62,000, accounts receivables are expected to climb as a result of increased credit sales from $83,000 to $130,000. In addition, accounts payable are expected to increase from $70,000 to $84,000. This project will also produce $400,000 of bonus depreciation in year 1 and Spartan Stores is in the 36 percent marginal tax rate. What is the project's free cash flow in year 1? The project's free cash flow in year 1 is S (Round to the nearest dollar.)

Corporate Fin Focused Approach

5th Edition

ISBN:9781285660516

Author:EHRHARDT

Publisher:EHRHARDT

Chapter12: Corporate Valuation And Financial Planning

Section: Chapter Questions

Problem 2STP

See similar textbooks

Similar questions

A firm is considering several policy changes to increase sales. It will increase the variety of goods it keeps in inventory, but this will increase inventory by $12,000. It will offer more liberal sales terms, but this will result in average receivables increasing by $69,000. These actions are expected to increase sales by $820,000 per year, and cost of goods will remain at 80% of sales. Because of the firm’s increased purchases for its own production needs, average payables will increase by $37,000. What effect will these changes have on the firm’s cash cycle? (Use 365 days in a year. Do not round your intermediate calculations. Round your answer to 2 decimal places.) Change in cash cycle days
A firm is considering several policy changes to increase sales. It will increase the variety of goods it keeps in inventory, but this will increase inventory by $11,500. It will offer more liberal sales terms, but this will result in average receivables increasing by $68,000. These actions are expected to increase sales by $815,000 per year, and cost of goods will remain at 70% of sales. Because of the firm’s increased purchases for its own production needs, average payables will increase by $36,500. What effect will these changes have on the firm’s cash cycle? (Use 365 days in a year. Do not round your intermediate calculations. Round your answer to 2 decimal places.) What is the change in cash cycle? Answer in Excel and show formulas please.
A company with annual sales of $22,000,000 is considering changing its payment terms from net 40 to net 30 to encourage customers to pay more promptly. The company forecasts that customers would respond by paying on day 32 rather than day 44 as at present (assume a 360 day year) but would decrease their purchases by $400,000 per year. The company also forecasts that its idle cash balance would decrease by $80,000 and administrative costs would be reduced by $30,000 per year. The company's variable costs average 62% of sales, it is in the 35% marginal tax bracket, and it has an 8% cost of capital. Part A: Calculate the incremental cash flows from accepting this proposal, and organize your cash flows into a cash flow spreadsheet. Part B: Calculate the proposal's NPV, IRR, and NAB. Part C: Should the company shorten its payment terms?
A 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 why
A company with annual sales of $22,000,000 is considering changing its payment terms from net 40 to net 30 to encourage customers to pay more promptly. The company forecasts that customers would respond by paying on day 32 rather than day 44 as at present (assume a 360 day year) but would decrease their purchases by $400,000 per year. The company also forecasts that its idle cash balance would decrease by $80,000 and administrative costs would be reduced by $30,000 per year. The company's variable costs average 62% of sales, it is in the 35% marginal tax bracket, and it has an 8% cost of capital. Part A: Calculate the incremental cash flows from accepting this proposal, and organize your cash flows from part A into a cash flow spreadsheet. Part B: Calculate the proposal's NPV, IRR, and NAB. Part C: Should the company shorten its payment terms?
Henderson Office Supply is considering a more liberal credit policy to increase sales but expects that 9 percent of the new accounts will be uncollectible. Collection costs are 6 percent of new sales, production and selling costs are 74 percent, and accounts receivable turnover is four times. Assume income taxes of 20 percent and an increase in sales of $65,000. No other asset buildup will be required to service the new accounts. Assume that Henderson also needs to increase its level of inventory to support new sales and that inventory turnover is two times. d. What would be the total incremental investment in accounts receivable and inventory needed to support a $65,000 increase in sales?
Kiley Corporation had the following data for the most recent year (in millions). The new CFO believes (1) that an improved inventory management system could lower the average inventory by $4,000, (2) that improvements in the credit department could reduce receivables by $2,000, and (3) that the purchasing department could negotiate better credit terms and thereby increase accounts payable by $2,000. Furthermore, she thinks that these changes would not affect either sales or the costs of goods sold. If these changes were made, by how many days would the cash conversion cycle be lowered? Original Revised Annual sales: unchanged $110,000 $110,000 Cost of goods sold: unchanged $80,000 $80,000 Average inventory: lowered by $4,000 $20,000 $16,000 Average receivables: lowered by $2,000 $16,000 $14,000 Average payables: increased by $2,000 $10,000 $12,000 Days in year 365 365
To increase sales, management is considering reducing its credit standards. This action is expected to increase sales by $120,000. Unfortunately, it is anticipated that 7 percent of the sales will be uncollectible. Accounts receivable turnover is expected to be seven times a year, and it costs the firm 11 percent to carry its receivables. Collection costs will be 4 percent of sales, and the cost of the additional goods sold is $62,000. Will earnings increase? Round your answer to the nearest dollar. Net in earnings is $ .
Kiley Corporation had the following data for the most recent year (in millions). The new CFO believes (1) that an improved inventory management system could lower the average inventory by $4,000, (2) that improvements in the credit department could reduce receivables by $2,000, and (3) that the purchasing department could negotiate better credit terms and thereby increase accounts payable by $2,000. Furthermore, she thinks that these changes would not affect either sales or the costs of goods sold. If these changes were made, by how many days would the cash conversion cycle be lowered? (Hint: Calculate the CCC for original and then for revised and take the difference. SHOW ALL WORK)
Williams & Sons last year reported sales of $15 million, cost of goods sold (COGS) of $12 million, and an inventory turnover ratio of 2. The company is now adopting a new inventory system. If the new system is able to reduce the firm's inventory level and increase the firm's inventory turnover ratio to 6 while maintaining the same level of sales and COGS, how much cash will be freed up? Do not round intermediate calculations. Enter your answer in dollars. For example, an answer of $1.23 million should be entered as 1,230,000,000. Round your answer to the nearest dollar. $
10. Zervos Inc. had the following data for last year (in millions). The new CFO believes (1) that an improved inventory management system could lower the average inventory by $4,000, (2) that improvements in the credit department could reduce receivables by $2,000, and (3) that the purchasing department could negotiate better credit terms and thereby increase accounts payable by $2,000. Furthermore, she thinks that these changes would not affect either sales or the costs of goods sold. If these changes were made, by how many days would the cash conversion cycle be lowered? Original $124,000 $80,000 $20,000 $16,000 $10,000 Revised Annual sales: unchanged Cost of goods sold: unchanged Average inventory: lowered by $4,000 Average receivables: lowered by $2,000 Average payables: increased by $2,000 Days in year $124,000 $80,000 $16,000 $14,000 $12,000 365 365 а. 34.6 days b. 39.2 days с. 37.2 days d. 33.3 days e. 36.9 days
Your consulting firm was recently hired to improve the performance of RP 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 Annual sales Annual cost of goods seld Average accounts receivable Average accunts payable P5.000 P00.000 PH0,000 P0,000 F5000 140.6 days 120.6 days 133.6 days 148.0 days O 126.9 days