Question

In: Finance

Edgar Justin Monique Cost of equipment 30M 20M 20M Replacement frequency (years) 16 8 4 Pre-tax...

Edgar Justin Monique
Cost of equipment 30M 20M 20M
Replacement frequency (years) 16 8 4
Pre-tax cash flows per year 4M 4M 8M
Salvage 20M 10M 0

Depreciation rate for all equipment is 0.2 and tax rate is 35%. Cost of capital is 8%

a. What is the NPV of each project Edgar, Justin , and Monique

b. Which project is the best to use? (Hint: Use equivalent annual annuity or replacement chain method to answer this question)

Solutions

Expert Solution

a. Follow the below steps to compute NPV.

1. Put down all the cashflows from years 0 till the replacement year .

2. Always put a minus sign for costs

3. Subtract the tax for each cashflow every year

4. Add the salvage value and the depreciated equipment value to last year cashflow.

In Excel , using NPV function , the NPV of the three projects are determined as :

NPV of Edgar = 6.674 Million

NPV of Justin = 10.285 Million

NPV of Monique = 11.336 Million

b . Equivalent Annual Annuity can be used as a parameter to determine the best project :

C = ( r* NPV) / (1-(1+r)^-n) where n is the replacement years and r is the cost of capital.

C for Justin = 0.75 Million

C for Edgar = 1.79 Million

C for Monique = 3.42 Million

Thus , we can conclude that Monique is the best project to use as C is highest for that project.


Related Solutions

■Machine A –Initial Cost = $150,000 –Pre-tax operating cost = $65,000 Expected life is 8 years...
■Machine A –Initial Cost = $150,000 –Pre-tax operating cost = $65,000 Expected life is 8 years ■Machine B –Initial Cost = $100,000 –Pre-tax operating cost = $57,500 –Expected life is 6 years The machine chosen will be replaced indefinitely and neither machine will have a differential impact on revenue. No change in NWC is required. The required return is 10%, the applicable CCA rate is 20% and the tax rate is 40%. Which machine should you buy?
You are considering investing in a piece of equipment to implement a cost-cutting proposal. The pre-tax...
You are considering investing in a piece of equipment to implement a cost-cutting proposal. The pre-tax cost reduction is expected to equal $41.67 for each of the three years of the project's life. The equipment has an initial cost of $125 and belongs in a 20% CCA class. Assume a 34% tax bracket, a discount rate of 15%, and a salvage value of zero. If the equipment is sold to another company at the end of year 3 for $20,...
REPLACEMENT ANALYSIS The Darlington Equipment Company purchased a machine 5 years ago at a cost of...
REPLACEMENT ANALYSIS The Darlington Equipment Company purchased a machine 5 years ago at a cost of $80,000. The machine had an expected life of 10 years at the time of purchase, and it is being depreciated by the straight-line method by $8,000 per year. If the machine is not replaced, it can be sold for $5,000 at the end of its useful life. A new machine can be purchased for $180,000, including installation costs. During its 5-year life, it will...
Problem 16-5 Change in tax rate; record taxes for four years [LO16-1, 16-4, 16-5] The DeVille...
Problem 16-5 Change in tax rate; record taxes for four years [LO16-1, 16-4, 16-5] The DeVille Company reported pretax accounting income on its income statement as follows:     2018 $ 405,000 2019 325,000 2020 395,000 2021 435,000     Included in the income of 2018 was an installment sale of property in the amount of $52,000. However, for tax purposes, DeVille reported the income in the year cash was collected. Cash collected on the installment sale was $20,800 in 2019, $26,000...
r= 8% Summary Tax Rate 30% Initial Investment PV of Cash Flows After Tax Equipment cost...
r= 8% Summary Tax Rate 30% Initial Investment PV of Cash Flows After Tax Equipment cost PV of CCA Tax Shield Setup and training PV of Ending Cash Flows Decision: Investment in NWC NPV A.  Initial Investment Proceed with Project? Yr 1 2 3 4 5 Sales Less forgone rental Income Costs Project cash flows before tax Tax Project cash flows after tax B. PV of Cash Flows After Tax C.  PV of CCA tax shield formula Salvage value (if asset class...
Crane Corporation acquired new equipment at a cost of $110,000 plus 8% provincial sales tax and...
Crane Corporation acquired new equipment at a cost of $110,000 plus 8% provincial sales tax and 4% GST. (GST is a recoverable tax.) The company paid $1,780 to transport the equipment to its plant. The site where the equipment was to be placed was not yet ready and Crane Corporation spent another $520 for one month’s storage costs. When installed, $400 in labour and $260 of materials were used to adjust and calibrate the machine to the company’s exact specifications....
Development cost and timing: $8 million over 2 years Time period 5 years Ramp-up cost: $4...
Development cost and timing: $8 million over 2 years Time period 5 years Ramp-up cost: $4 million over 1 year, starting 1st quarter of year 2. Marketing and support cost: $1.6 million/year, starting 3rd quarter of year 2. Unit production cost: $550/unit. Sales and Production volume: 20,000 units/year, starting 3rd quarter of year 2 Discount rate: 3 percent per quarter Unit Price: $1200/unit 1) Using Excel Calculate the NPV for the total period. Calculate the PV for the 1st quarter...
JLMB Company owns earth moving equipment that cost ?98,000. After 8 years, it will have estimated...
JLMB Company owns earth moving equipment that cost ?98,000. After 8 years, it will have estimated salvage value of ?18,000. Compute the depreciation charge for each of the first two years and the book value at the end of 4 years by each of the following three methods of depreciation: a. straight line method; b. sum-of-the-years digit method; and c. double declining balance method.
Assume project lasts 4 years Operating income 100 Tax rate 21% Machine cost 50
  Assume project lasts 4 years Operating income 100 Tax rate 21% Machine cost 50 Straight line depreciation over 5 years Salvage value after 5 years = 20 Working capital 2 per year , 3 initially WACC = 10% What is the IRR What is the NPV What is the payback
   Years 0 1 2 3 4 Investment Outlay Equipment cost ($350,000) Shipping and installation ($70,000)...
   Years 0 1 2 3 4 Investment Outlay Equipment cost ($350,000) Shipping and installation ($70,000) Increase in inventory ($55,000) Increase in accounts payable $18,000 Total initial investment ($457,000) Operating cash flow $        113,990 $           96,350 $        140,450 $        152,210 Total termination cash flow $           53,250 Project Cash Flows Net cash flows ($457,000) $113,990 $96,350 $140,450 $205,460 Required return (used as the discount rate) 12% Payback period (2.22) Present value of net cash inflows Present value of cash outflows Profitability...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT