Question

In: Finance

Sway's Back Store is considering a project which will require the purchase of $1.5 million in...

  1. Sway's Back Store is considering a project which will require the purchase of $1.5 million in new equipment. The equipment will be depreciated straight-line to a book value of $0.5 million over the 5-year life of the project. Annual sales from this project are estimated at $950,000. The variable cost is 40% of the annual sales and there is an annual fixed cost of $100,000. Sway's Back Store will sell the equipment at the end of the project for a salvage value of $0.7 mil. Additional net working capital equal to $0.4 mil to support the project. All of the new net working capital will be recouped at the end of the project. The firm desires a minimal 10% rate of return on this project. The tax rate is 40%. You can use the following tables to construct the cash flows necessary for the NPV calculation. (10 points)

a. What is the annual depreciation? *** Straight line depreciation expense = (beginning value- ending value) / life expectancy

b. What is the TAX on salvage? *** Taxes on salvage = Tax rate * Capital Gain

C. What is the operating cash flow?

***Operating Cash Flow = (Sales-Costs-Depreciation) – Taxes + Depreciation

          or = Net Income + Depreciation

d. What is the project's NPV?

Solutions

Expert Solution

a.

annual depreciation =

-200000

b.

tax on salvage = 700000*0.4 = 280000

c.

OCF

=

362000

d.

Time line 0 1 2 3 4 5
Cost of new machine -1500000
Initial working capital -400000
=Initial Investment outlay -1900000
Sales 950000 950000 950000 950000 950000
Profits Sales-variable cost 570000 570000 570000 570000 570000
Fixed cost -100000 -100000 -100000 -100000 -100000
-Depreciation (purchase price-last yr book value)/5 -200000 -200000 -200000 -200000 -200000
=Pretax cash flows 270000 270000 270000 270000 270000
-taxes =(Pretax cash flows)*(1-tax) 162000 162000 162000 162000 162000
+Depreciation 200000 200000 200000 200000 200000
=after tax operating cash flow 362000 362000 362000 362000 362000
reversal of working capital 400000
+Proceeds from sale of equipment after tax =selling price* ( 1 -tax rate) 420000
+Tax shield on salvage book value =Salvage value * tax rate 200000
=Terminal year after tax cash flows 1020000
Total Cash flow for the period -1900000 362000 362000 362000 362000 1382000
Discount factor= (1+discount rate)^corresponding period 1 1.1 1.21 1.331 1.4641 1.61051
Discounted CF= Cashflow/discount factor -1900000 329090.91 299173.554 271975.96 247250.87 858113.3
NPV= Sum of discounted CF= 105604.56

b


Related Solutions

RSM Co is considering a project which will require the purchase of $2.7 million in new...
RSM Co is considering a project which will require the purchase of $2.7 million in new equipment. The equipment will be depreciated straight-line to a book value of $1 million over the 5-year life of the project. Annual sales from this project are estimated at $2,950,000. The variable cost is 40% of the annual sales and there is an annual fixed cost of $200,000. Sway's Back Store will sell the equipment at the end of the project for 30% of...
Layla's Distribution Co. is considering a project which will require the purchase of $1.6 million in...
Layla's Distribution Co. is considering a project which will require the purchase of $1.6 million in new equipment. The equipment will be depreciated straight-line to a zero book value over the 5-year life of the project. Layla's expects to sell the equipment at the end of the project for $180,000. Annual sales from this project are estimated at $1.3 million, and you will incur $100,000 in fixed costs and variable costs equal to 10% of sales. Net working capital equal...
1) ABC Ltd is considering a project which will require the purchase of a machine for...
1) ABC Ltd is considering a project which will require the purchase of a machine for RO1,000,000 at time zero, this machine will have a scrap value at the end of its four - year life: this will be equal to its written - down value. (25% declining balance writing - down allowance on the machine each year). Corporation tax, at a rate of 30% of taxable income, is payable. ABC Ltd's required rate of return is 12%. Operating cash...
A firm is considering a project with the following information: Project will require purchase of a...
A firm is considering a project with the following information: Project will require purchase of a machine for $92,101.00 that is MACRS depreciable over a five-year schedule. (no depreciation until end of year 1). Project will require immediate non-depreciable expenses of $25,021.00 TODAY (year 0). Project will have the following projected balance sheet values of NWC: YEAR 0 1 2 NWC Level $4,000 9.00% of sales 8.00% of sales Sales for the project will be $54,556.00 per year, with all...
A company is considering a new project. This project will require the purchase of $321,000 of...
A company is considering a new project. This project will require the purchase of $321,000 of equipment, the purchase of $45,000 in inventory and will increase accounts payable by $73,000. Expected sales are $625,000 with costs of $480,000. The project will last for five years, be taxed at 35% and have a required rate of return of 14%. The equipment will have no salvage value at the end of the project and will be depreciated using the MACRS three-year class....
Your company is considering a project which will require the purchase of $685,000 in new equipment....
Your company is considering a project which will require the purchase of $685,000 in new equipment. The company expects to sell the equipment at the end of the project for 25% of its original cost, but some assets will remain in the CCA class. Annual sales from this project are estimated at $244,000. Initial net working capital equal to 30.50% of sales will be required. All of the net working capital will be recovered at the end of the project....
Your company is considering a project which will require the purchase of $715,000 in new equipment....
Your company is considering a project which will require the purchase of $715,000 in new equipment. The company expects to sell the equipment at the end of the project for 25% of its original cost, but some assets will remain in the CCA class. Annual sales from this project are estimated at $256,000. Initial net working capital equal to 32.00% of sales will be required. All of the net working capital will be recovered at the end of the project....
Your company is considering a project which will require the purchase of $725,000 in new equipment....
Your company is considering a project which will require the purchase of $725,000 in new equipment. The company expects to sell the equipment at the end of the project for 25% of its original cost, but some assets will remain in the CCA class. Annual sales from this project are estimated at $260,000. Initial net working capital equal to 32.50% of sales will be required. All of the net working capital will be recovered at the end of the project....
Your company is considering a project which will require the purchase of $805,000 in new equipment....
Your company is considering a project which will require the purchase of $805,000 in new equipment. The company expects to sell the equipment at the end of the project for 25% of its original cost, but some assets will remain in the CCA class. Annual sales from this project are estimated at $292,000. Initial net working capital equal to 36.50% of sales will be required. All of the net working capital will be recovered at the end of the project....
Your company is considering a project which will require the purchase of $775,000 in new equipment....
Your company is considering a project which will require the purchase of $775,000 in new equipment. The company expects to sell the equipment at the end of the project for 25% of its original cost, but some assets will remain in the CCA class. Annual sales from this project are estimated at $280,000. Initial net working capital equal to 35.00% of sales will be required. All of the net working capital will be recovered at the end of the project....
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT