Question

In: Finance

​(Calculating free cash flows​) Spartan Stores is expanding operations with the introduction of a new distribution...

​(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 ​$940,000. Although inventory is expected to drop from ​$82,000 to ​$64,000​, accounts receivables are expected to climb as a result of increased credit sales from ​$86,000 to ​$110,000. In​ addition, accounts payable are expected to increase from ​$65,000 to ​$84,000. This project will also produce ​$350,000 of bonus depreciation in year 1 and Spartan Stores is in the 32 percent marginal tax rate. What is the​ project's free cash flow in year​ 1?

Solutions

Expert Solution

Solution:-

Changes happened during the period of two years in current assets and current liabilities;

Particulars Year 1 Year 2 Change
Inventory $82,000 $64,000 $18,000
Acconts receivable $86,000 $110,000 -$24,000
Current assets $168,000 $174,000 -$6,000
Accounts payable $65,000 $84,000 $19,000
Current liabilities $65,000 $84,000 $19,000
Net working capital 103,000 $90,000 $13,000

Free cash flow = EBIT *(1-tax) + Depreciation - changes in net working capital - capital expenditure

= $940,000 * (1-32%) + $350,000 - $13,000 - 0

= $940,000 * 68% + $350,000 - $13,000

= $639,200 + $350,000 - $13,000

= $976,200

Therefore the project cash flow for year 1 of spartan stores is $976,200.


Related Solutions

​(Calculating free cash flows​) At​ present, Solartech Skateboards is considering expanding its product line to include​...
​(Calculating free cash flows​) At​ present, Solartech Skateboards is considering expanding its product line to include​ gas-powered skateboards;​ however, it is questionable how well they will be received by skateboarders. Although you feel there is a 50 percent chance you will sell 10,000 of these per year for 10 years​ (after which time this project is expected to shut down because​ solar-powered skateboards will become more​ popular), you also recognize that there is a 25 percent chance that you will...
​(Calculating free cash flows​) At​ present, Solartech Skateboards is considering expanding its product line to include​...
​(Calculating free cash flows​) At​ present, Solartech Skateboards is considering expanding its product line to include​ gas-powered skateboards;​ however, it is questionable how well they will be received by skateboarders. Although you feel there is a 50 percent chance you will sell 12 comma 000 of these per year for 10 years​ (after which time this project is expected to shut down because​ solar-powered skateboards will become more​ popular), you also recognize that there is a 25 percent chance that...
(Calculating free cash flows​) At​ present, Solartech Skateboards is considering expanding its product line to include​...
(Calculating free cash flows​) At​ present, Solartech Skateboards is considering expanding its product line to include​ gas-powered skateboards;​ however, it is questionable how well they will be received by skateboarders. Although you feel there is a 70 percent chance you will sell 9,000 of these per year for 10 years​ (after which time this project is expected to shut down because​ solar-powered skateboards will become more​ popular), you also recognize that there is a 15 percent chance that you will...
(Calculating free cash flows​) At​ present, Solartech Skateboards is considering expanding its product line to include​gas-powered...
(Calculating free cash flows​) At​ present, Solartech Skateboards is considering expanding its product line to include​gas-powered skateboards;​ however, it is questionable how well they will be received by skateboarders. Although you feel there is a 50 percent chance you will sell 12,000 of these per year for 10 years​ (after which time this project is expected to shut down because​ solar-powered skateboards will become more​ popular), you also recognize that there is a 25 percent chance that you will only...
Horizon Value of Free Cash Flows Current and projected free cash flows for Radell Global Operations...
Horizon Value of Free Cash Flows Current and projected free cash flows for Radell Global Operations are shown below. Actual 2016 2017 Projected 2018 2019 Free cash flow $602.40 $663.08 $703.13 $759.38 (millions of dollars) Growth is expected to be constant after 2018, and the weighted average cost of capital is 11.55%. What is the horizon (continuing) value at 2019 if growth from 2018 remains constant? Round your answer to the nearest dollar. Round intermediate calculations to two decimal places.
​(Calculating free cash flows​) You are considering new elliptical trainers and you feel you can sell...
​(Calculating free cash flows​) You are considering new elliptical trainers and you feel you can sell 3,000 of these per year for 5 years​ (after which time this project is expected to shut down when it is learned that being fit is​ unhealthy). The elliptical trainers would sell for ​$1,600 each and have a variable cost of ​$800 each. The annual fixed costs associated with production would be ​$1,300,000. In​ addition, there would be a ​$3,000,000 initial expenditure associated with...
(Calculating free cash flows​) You are considering new elliptical trainers and you feel you can sell...
(Calculating free cash flows​) You are considering new elliptical trainers and you feel you can sell 6,000 of these per year for 5 years​ (after which time this project is expected to shut down when it is learned that being fit is​ unhealthy). The elliptical trainers would sell for ​$1,000 each and have a variable cost of ​$500 each. The annual fixed costs associated with production would be ​$1,500,000. In​ addition, there would be a ​$6,000,000 initial expenditure associated with...
​(Calculating project cash flows and​ NPV) You are considering expanding your product line that currently consists...
​(Calculating project cash flows and​ NPV) You are considering expanding your product line that currently consists of skateboards to include​ gas-powered skateboards, and you feel you can sell 7,000 of these per year for 10 years​ (after which time this project is expected to shut down with​ solar-powered skateboards taking​ over). The gas skateboards would sell for ​$70 each with variable costs of ​$50 for each one​ produced, and annual fixed costs associated with production would be ​$190,000 . In​...
(Calculating project cash flows and​ NPV) You are considering expanding your product line that currently consists...
(Calculating project cash flows and​ NPV) You are considering expanding your product line that currently consists of skateboards to include​ gas-powered skateboards, and you feel you can sell 8,000 of these per year for 10 years​ (after which time this project is expected to shut down with​solar-powered skateboards taking​ over). The gas skateboards would sell for ​$70 each with variable costs of ​$30 for each one​ produced, and annual fixed costs associated with production would be $180,000. In​ addition, there...
​(Related to Checkpoint​ 12.1)  ​(Calculating project cash flows and​ NPV)  You are considering expanding your product...
​(Related to Checkpoint​ 12.1)  ​(Calculating project cash flows and​ NPV)  You are considering expanding your product line that currently consists of skateboards to include​ gas-powered skateboards, and you feel you can sell 12 comma 00012,000 of these per year for 1010 years​ (after which time this project is expected to shut down with​ solar-powered skateboards taking​ over). The gas skateboards would sell for ​$130130 each with variable costs of ​$4545 for each one​ produced, and annual fixed costs associated with...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT