Incremental PV of tax savings using SYD depreciation calculation |
SYD excel formula=(cost, salvage, life, per)
for eg: year 1 depreciation =(200,000,0,4,1)
SLD excel formula= (cost, salvage, life)
CALCULATION:
Method | year 1 | year 2 | year 3 | year 4 | Total | |
SYD depreciation | [1] | $80,000 | $60,000 | $40,000 | $20,000 | |
tax benefit@40% | [2] | $32,000 | $24,000 | $16,000 | $8,000 | |
PV for $1 factor for 11% | [3] | 0.901 | 0.812 | 0.731 | 0.659 | |
PV [2]*[3] | [4] | 28832 | 19488 | $11,696 | $5,272 | $65288 |
Straight Line Depreciation (SLD) | [1] | $50,000 | $50,000 | $50,000 | $50,000 | |
tax benefit | [2] | $20,000 | $20,000 | $20,000 | $20,000 | |
PV for $1 | [3] | $0.901 | 0.812 | 0.731 | 0.659 | |
PV [2]*[3] | [4] | $18020 | $16240 | $14,620 | $13,180 | $62060 |
Incremental PV of tax savings using SYD depreciation | [$65288-$62060] | $3228 |
2) Incremental PV of tax savings using DDB depreciation
DDB excel formula=(cost, salvage, life, period)
for eg:- for year 1 depreciation=(200000,0,4,1)
Method | year 1 | year 2 | year 3 | year 4 | Total | |
DDB depreciation | [1] | $100,000 | $50,000 | $25,000 | $12,500 | |
tax benefit@40% | [2] | $40,000 | $20,000 | $10,000 | $5,000 | |
PV for $1 factor for 11% | [3] | 0.901 | 0.812 | 0.731 | 0.659 | |
PV [2]*[3] | [4] | $36,040 | $16,240 | $7,310 | $3,295 | $62,885 |
Straight Line Depreciation (SLD) | [1] | $50,000 | $50,000 | $50,000 | $50,000 | |
tax benefit | [2] | $20,000 | $20,000 | $20,000 | $20,000 | |
PV for $1 | [3] | $0.901 | 0.812 | 0.731 | 0.659 | |
PV [2]*[3] | [4] | $18,020 | $16,240 | $14,620 | $13,180 | $62,060 |
Incremental PV of tax savings using DDB depreciation | [$62885-$62060] | $825 |
3) Incremental PV of tax savings using MACRS over SYD |
Asset is going to depreciate over 3 years using half-year convention. The MACRS rate for each of the 4 years are:
year 1 | 33.33% |
year 2 | 44.45% |
year 3 | 14.81% |
year 4 | 7.41% |
All these rates add unto 100%. It means asset will be fully depreciated and MACRS don't consider salvage value. for Now let's see how to calculate depreciation using the above rate. For eg:- depreciation for year 1 is calculated as: $200,000*33.33%= $66,660.
[Note: the rate was not given in the question, so I took it from public source.]
3.a) Incremental PV of tax savings using MACRS over SYD |
Method | year 1 | year 2 | year 3 | year 4 | Total | |
SYD depreciation | [1] | $80,000 | $60,000 | $40,000 | $20,000 | |
tax benefit@40% | [2] | $32,000 | $24,000 | $16,000 | $8,000 | |
PV for $1 factor for 11% | [3] | 0.901 | 0.812 | 0.731 | 0.659 | |
PV [2]*[3] | [4] | $28,832 | $19,488 | $11,696 | $5,272 | $65,288 |
MACRS depreciation | [1] | $66,660 | $88,900 | $29,620 | $14,820 | |
tax benefit@40% | [2] | $26,664 | $35,560 | $11,848 | $5,928 | |
PV for $1 | [3] | $0.901 | 0.812 | 0.731 | 0.659 | |
PV [2]*[3] | [4] | $24,024 | $28,875 | $8,661 | $3,907 | $65,466 |
Incremental PV of tax savings using MACRS over SYD | [$65,466-$65288] | $178 |
3.B) Incremental PV of tax savings using MACRS over DDB |
Method | year 1 | year 2 | year 3 | year 4 | Total | |
DDB depreciation | [1] | $100,000 | $50,000 | $25,000 | $12,500 | |
tax benefit@40% | [2] | $40,000 | $20,000 | $10,000 | $5,000 | |
PV for $1 factor for 11% | [3] | 0.901 | 0.812 | 0.731 | 0.659 | |
PV [2]*[3] | [4] | $36,040 | $16,240 | $7,310 | $3,295 | $62,885 |
MACRS depreciation | [1] | $66,660 | $88,900 | $29,620 | $14,820 | |
tax benefit@40% | [2] | $26,664 | $35,560 | $11,848 | $5,928 | |
PV for $1 | [3] | $0.901 | 0.812 | 0.731 | 0.659 | |
PV [2]*[3] | [4] | $24,024 | $28,875 | $8,661 | $3,907 | $65,466 |
Incremental PV of tax savings using MACRS over DDB | [$62885-$62060] | $2,581 |
Check my work Freedom Corporation acquired a fixed asset for $200,000. Its estimated life at time...
Check my work Freedom Corporation acquired a fixed asset for $200,000. Its estimated life at time of purchase was 4 years, with no estimated salvage value. Assume a discount rate of 11% and an income tax rate of 40%. (Use Exhibit 12.4, Appendix C, TABLE 1 and Appendix C TABLE 2.) 0.25 points eBook Required: 1. What is the incremental present value of the tax benefits resulting from calculating depreciation using the sum-of-the-years'-digits (SYD) method rather than the straight-line (SLN)...
Freedom Corporation acquired a fixed asset for $120,000. Its estimated life at time of purchase was 4 years, with no estimated salvage value. Assume a discount rate of 7% and an income tax rate of 40%. (Use Exhibit 12.4, Appendix C, TABLE 1 and Appendix C, TABLE 2.) Required: 1. What is the incremental present value of the tax benefits resulting from calculating depreciation using the sum-of-the-years’-digits (SYD) method rather than the straight-line (SLN) method on this asset? Use the...
Exercise 12-29 Value of Accelerated Depreciation: Sum-of-Years'-Digits (SYD) and Double Declining. Balance (DDB) Methods (LO 12-3) Freedom Corporation acquired a fixed asset for $100,000. Its estimated life at time of purchase was 4 years, with no estimated salvage value. Assume a discount rate of 8% and an income tax rate of 40%. (Use Exhibit 124. Appendix C. TABLE 1 and Appendix C. TABLE 2) Required: 1. What is the incremental present value of the tax benefits resulting from calculating depreciation...
signment Saved Help Save & Exit Submit Check my work Freedom Corporation acquired a fixed asset for $180,000. Its estimated life at time of purchase was 4 years, with no estimated salvage value. Assume a discount rate of 10% and an income tax rate of 40% (Use Exhibit 12.4. Appendix C. TABLE1 and Appendix C. TABLE 2) Required: 1. What is the incremental present value of the tax benefits resulting from calculating depreciation using the sum-of-the-years-digits (SYD) method rather than...
Freedom Corporation acquired a fixed asset for $220,000. Its estimated life at time of purchase was 4 years, with no estimated salvage value. Assume a discount rate of 7% and an income tax rate of 40%. (Use Exhibit 12.4, Appendix C, TABLE 1 and Appendix C, TABLE 2.) TABLE2 Present Value of Annuity of $1 Periods 4% 5% 6% 7% 8% 9% 10% 11% 12% 13% 14% 15% 20% 25% 30% 1 0.962 0.952 0.943 0.935 0.926 0.917 0.909 0.901...
A computer chip manufacturer spent $2,500,000 to develop a special-purpose molding machine. The machine has been used for one year and is expected to be obsolete after an additional 3 years. The company uses straight-line (SLN) depreciation for this machine At the beginning of the second year, a machine salesperson offers a new, vastly more efficient machine. This machine will cost $2,000,000, reduce annual cash manufacturing costs from $1,800,000 to $1,000,000, and have zero disposal value at the end of...
A computer chip manufacturer spent $2,540,000 to develop a special-purpose molding machine. The machine has been used for one year and is expected to be obsolete after an additional 3 years. The company uses straight-line (SLN) depreciation for this machine. At the beginning of the second year, a machine salesperson offers a new, vastly more efficient machine. This machine will cost $2,040,000, reduce annual cash manufacturing costs from $1,840,000 to $1,040,000, and have zero disposal value at the end of...
Check my work eEgg is considering the purchase of a new distributed network computer system to help handle its warehouse inventories. The system costs $50,000 to purchase and install and $32,000 to operate each year. The system is estimated to be useful for 4 years. Management expects the new system to reduce the cost of managing inventories by $58,000 per year. The firm's cost of capital (discount rate) is 11%. 0.25 points eBook References Required: 1. What is the net...
i tried to answer 996,-996,292,-292,3201,-3201, all these were incorrect. Freedom Corporation acquired a fixed asset for $220,000. Its estimated life at time of purchase was 4 years, with no estimated salvage value. Assume a discount rate of 7% and an income tax rate of 40%. (Use Exhibit 12.4, Appendix C, TABLE 1 and Appendix C, TABLE 2.) TABLE 2 Present Value of Annuity of $1 Periods 4% 5% 6% 7% 8% 9% 10% 11% 12% 13% 14% 15% 20% 25%...
*P11-12 (L01,6) EXCEL (Depreciation—SL, DDB, SYD, Act., and MACRS) On January 1, 2016, Locke Company, a small machine-tool manufacturer, acquired for $1,260,000 a piece of new industrial equipment. The new equipment had a useful life of 5 years, and the salvage value was estimated to be $60,000. Locke estimates that the new equipment can produce 12,000 machine tools in its first year. It estimates that production will decline by 1,000 units per year over the remaining useful life of the...