3. Your firm plans to purchase a manufacturing machine, which costs $500,000 fro
ID: 2809043 • Letter: 3
Question
3. Your firm plans to purchase a manufacturing machine, which costs $500,000 from a local manufacturer. This machine has straight-line depreciation period of 8 years. However, you were told that if you buy the same machine from a manufacturer from Alaska, the U.S. tax authorities will allow you an accelerated straight-line depreciation period of 4 years. You also know that in the latter case you will have to pay additional shipping costs of $15,000 (payable today).
Assuming your firm’s tax rate is 30%, and the discount rate is 12%, from which manufacturer should you buy the machine?
What is the maximal shipping cost at which you’ll be indifferent between the manufacturers (assuming that shipping cost cannot be considered for depreciation purpose)? Answer withoutusing Excel’s function ‘Goal Seek’ or ‘Solver’
Hint: you need to consider the tax benefit of depreciation for these two different choices. Tax benefit related to depreciation is called a “tax shield of depreciation.” Put it more straightforward, if your firm has a tax rate of 30%, for every $100 depreciation, this will save you $30 taxes.
please add formulas
1 Accelerated depreciation 2 Shifting cost 3 Machine cost 4 Normal depreciation period $15,000 $500,000 6 Discount rate 7 Tax rate 8 9 Normal depreciation period (Local) 10 11 Annual depreciation 12 13 14 Accelerated depreciation period (Alaska) 15 16 Annual depreciation 17 18 19 20 Differential cash flow 21 NPV 1296 30% Annual tax shield from depreciation Annual tax shield from depreciation Additional value including shifting costs 23 24 What should the be maximum Shifting costs that will make Alaska purchase and local purchase different? 25 26 27 28Explanation / Answer
If we purchase the asset from local manufacturer at $500,000 we will depreciate it equally over 8 years, so that means our annual depreciation will be 500,000/8 = $62,500. If we purchase the asset from Alaska manufacturer at $500,000 plus 15,000 shipping we will depreciate it equally over 4 years, so that means our annual depreciation will be 515,000/4 = $128,750. Normal depreciation period (local) Year 1 2 3 4 5 6 7 8 Annual depreciation 62,500 62,500 62,500 62,500 62,500 62,500 62,500 62,500 Annual tax shield from depreciation 18,750 18,750 18,750 18,750 18,750 18,750 18,750 18,750 Normal depreciation period Alaska) Year 1 2 3 4 5 6 7 8 Annual depreciation 128,750 128,750 128,750 128,750 0 0 0 0 Annual tax shield from depreciation 38,625 38,625 38,625 38,625 - - - - Differential cash flow 19,875 19,875 19,875 19,875 (18,750) (18,750) (18,750) (18,750) NPV @12% required rate of return 17,745.54 15,844.23 14,146.63 12,630.92 (10,639.25) (9,499.33) (8,481.55) (7,572.81) Additional value including shipping cost 2,745.54 15,844.23 14,146.63 12,630.92 (10,639.25) (9,499.33) (8,481.55) (7,572.81) Net Gain from using machine from Alaska will be 9,174.37 Maximal shipping cost will be that cost which will be the Net gain from these two method in Present value terms Normal depreciation period (local) Year 1 2 3 4 5 6 7 8 Annual depreciation 62,500 62,500 62,500 62,500 62,500 62,500 62,500 62,500 Annual tax shield from depreciation 18,750 18,750 18,750 18,750 18,750 18,750 18,750 18,750 Normal depreciation period Alaska) Year 1 2 3 4 5 6 7 8 Annual depreciation (500,000/4) not including shipping cost 125,000 125,000 125,000 125,000 0 0 0 0 Annual tax shield from depreciation 37,500 37,500 37,500 37,500 - - - - Differential cash flow 18,750 18,750 18,750 18,750 (18,750) (18,750) (18,750) (18,750) NPV @12% required rate of return 16,741.07 14,947.39 13,345.88 11,915.96 (10,639.25) (9,499.33) (8,481.55) (7,572.81) Net Gain from using machine from Alaska will be 20,757.35 So, at shipping cost of 20,757.25, both the option will be neutral
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.