Question

In: Finance

Dunder-Mifflin is considering opening a new branch in Columbia with an initial fixed asset cost of...

Dunder-Mifflin is considering opening a new branch in Columbia with an initial fixed asset cost of $2.46 million which will be depreciated straight-line to a zero book value over the 10-year life of the project.

At the end of the project the equipment will be sold for an estimated $300,000. The project will not directly produce any sales but will reduce operating costs by $725,000 a year. The tax rate is 35 percent. The project will require $45,000 of inventory which will be recouped when the project ends. What is the NPV of this project if the firm requires a 13.7 percent rate of return? Enter the dollar amount as an integer value (ex. -$5,000.45 as -5000 or +$3,450.70 as 3451).

Solutions

Expert Solution

Time line 0 1 2 3 4 5 6 7 8 9 10
Cost of new machine -2460000
Initial working capital -45000
=Initial Investment outlay -2505000
100.00%
Savings 725000 725000 725000 725000 725000 725000 725000 725000 725000 725000
-Depreciation Cost of equipment/no. of years -246000 -246000 -246000 -246000 -246000 -246000 -246000 -246000 -246000 -246000 0 =Salvage Value
=Pretax cash flows 479000 479000 479000 479000 479000 479000 479000 479000 479000 479000
-taxes =(Pretax cash flows)*(1-tax) 311350 311350 311350 311350 311350 311350 311350 311350 311350 311350
+Depreciation 246000 246000 246000 246000 246000 246000 246000 246000 246000 246000
=after tax operating cash flow 557350 557350 557350 557350 557350 557350 557350 557350 557350 557350
reversal of working capital 45000
+Proceeds from sale of equipment after tax =selling price* ( 1 -tax rate) 195000
+Tax shield on salvage book value =Salvage value * tax rate 0
=Terminal year after tax cash flows 240000
Total Cash flow for the period -2505000 557350 557350 557350 557350 557350 557350 557350 557350 557350 797350
Discount factor= (1+discount rate)^corresponding period 1 1.137 1.292769 1.469878353 1.671251687 1.9002132 2.1605424 2.456536678 2.7930822 3.175734464 3.61081
Discounted CF= Cashflow/discount factor -2505000 490193.4916 431128.8405 379181.0383 333492.5578 293309.2 257967.63 226884.461 199546.58 175502.7085 220823
NPV= Sum of discounted CF= 503030.00

Related Solutions

Dunder-Mifflin is considering opening a new branch in Columbia with an initial fixed asset cost of...
Dunder-Mifflin is considering opening a new branch in Columbia with an initial fixed asset cost of $3.66 million which will be depreciated straight-line to a zero book value over the 10-year life of the project. At the end of the project the equipment will be sold for an estimated $300,000. The project will not directly produce any sales but will reduce operating costs by $725,000 a year. The tax rate is 21 percent. The project will require $45,000 of inventory...
Dunder-Mifflin is considering opening a new branch in Columbia with an initial fixed asset cost of...
Dunder-Mifflin is considering opening a new branch in Columbia with an initial fixed asset cost of $2.46 million which will be depreciated straight-line to a zero book value over the 10-year life of the project. At the end of the project the equipment will be sold for an estimated $300,000. The project will not directly produce any sales but will reduce operating costs by $725,000 a year. The tax rate is 35 percent. The project will require $45,000 of inventory...
I) Initial Investment Outlay: Dunder Mifflin is considering opening a Philadelphia branch for the next five...
I) Initial Investment Outlay: Dunder Mifflin is considering opening a Philadelphia branch for the next five years to augment its existing facilities in Scranton, PA. After five years, they will close the Philadelphia branch and seek regional alternatives. A financial analyst has estimated the following costs: A) $100,000 market analysis (already conducted) B) $1,000,000 purchase of distribution center C) $250,000 fixtures and installation of equipment II) Changes in Net Working Capital The managers of the Scranton branch estimated that the...
Dunder Mifflin Paper Company is considering purchasing a new stamping machine that costs ​$450,000. This new...
Dunder Mifflin Paper Company is considering purchasing a new stamping machine that costs ​$450,000. This new machine will produce cash inflows of $150,000 each year at the end of years 1 through​ 5, then at the end of year 7 there will be a cash outflow of $200,000 The company has a weighted average cost of capital of 14 percent​ (use this as the reinvestment​ rate). What is the MIRR of the​ investment?
City Security is considering a project with an initial fixed asset cost of $5,600,000 which will...
City Security is considering a project with an initial fixed asset cost of $5,600,000 which will be depreciated on the MACRS 5-year class over the 5-year of the project. At the end of the project, the book value will be zero and the equipment will be sold for an estimated $2,800,000. The project will not directly produce any sales but will save the firm $1,000,000 per year in pretax operating cost. The system requires an initial investment in net-working capital...
Costco is considering a project with an initial fixed asset cost of $2.46 million which will...
Costco is considering a project with an initial fixed asset cost of $2.46 million which will be depreciated straight-line to a zero book value over the 10-year life of the project. At the end of the project the equipment will be sold for an estimated $300,000. The project will not directly produce any sales but will reduce operating costs by $650,000 a year. The tax rate is 21 percent. The project will require $45,000 of inventory which will be recouped...
Advance Engineering is considering opening a new location with an initial cost of $398,0000. This location...
Advance Engineering is considering opening a new location with an initial cost of $398,0000. This location is expected to generate cash flows of $117,000, $121,000, $126,000, $133,000, and $142,000 in Years 1 to 5. What is the payback period?
Company A is opening a new branch in Charlotte today. Their unlevered cost of equity is...
Company A is opening a new branch in Charlotte today. Their unlevered cost of equity is 14%, and their cost of debt is 5%. Their debt to equity ratio is 1.1, and their tax rate is 26%. Initial costs are $1.5M. The firm expects EBIT of $1M one year from today, $500,000 two years from today, and $200,000 three years from today, after which they expect to shut down. They will finance some of their startup costs by borrowing $400,000...
West Wells is considering opening a new branch. The company expects the new branch’s EBIT to...
West Wells is considering opening a new branch. The company expects the new branch’s EBIT to be $10 million per year. At this time, the company is considering the following two financing plans: Plan 1: Equity financing. Under this plan, 3 million common shares will be sold at $12 each. Plan 2: Debt-equity financing. Under this plan, $20 million of 12 percent long-term debt and 1.6 million common shares at $10 each will be sold. Use a 40 percent marginal...
Gateway Communications is considering a project with an initial fixed asset cost of $1.2 million which...
Gateway Communications is considering a project with an initial fixed asset cost of $1.2 million which will be depreciated straight-line to a zero book value over the 4-year life of the project. At the end of the project the equipment will be sold for an estimated $300,000. The project will not directly produce any sales but will reduce operating costs by $725,000 a year. The tax rate is 35 percent. The project will require $45,000 of net working capital which...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT