Freedom Corporation acquired a fixed asset for $230,000. Its estimated life at time of purchase was 4 years, with no estimated salvage value. Assume a discount rate of 5% 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 SYD and SLN functions in Excel to calculate depreciation charges. 2. What is the incremental present value of the tax benefits resulting from calculating depreciation using the double-declining-balance (DDB) method rather than the straight-line (SLN) method on this asset? Use the SLN and DDB functions in Excel to calculate depreciation charges. 3. What is the incremental present value of the tax benefits resulting from using MACRS rather than straight-line (SLN) depreciation? The asset qualifies as a 3-year asset. Use the half-year convention. Exhibit 12.4 MACRS Depreciation Rates Year 3-year 5 year 7 year 10 year 15 year 20 year 1 33.33 20.00 14.29 10.00 5.00 3.75 2 44.45 32.00 24.49 18.00 9.50 7.22 3 14.81 19.20 17.49 14.40 8.55 6.68 4 7.31 11.52* 12.49 11.52 7.70 6.18 5 11.52 8.93 * 9.22 6.93 5.71 6 5.76 8.92 7.37 6.23 5.28 7 8.92 6.55* 5.90* 4.89 8 4.47 6.55 5.90 4.52 9 6.56 5.91 4.46* 10 6.55 5.90 4.46 11 3.28 etc etc
Freedom Corporation acquired a fixed asset for $230,000. Its estimated life at time of purchase was 4 years, with no estimated salvage value. Assume a discount rate of 5% 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
2. What is the incremental present value of the tax benefits resulting from calculating depreciation using the double-declining-balance (DDB) method rather than the straight-line (SLN) method on this asset? Use the SLN and DDB functions in Excel to calculate depreciation charges.
3. What is the incremental present value of the tax benefits resulting from using MACRS rather than straight-line (SLN) depreciation? The asset qualifies as a 3-year asset. Use the half-year convention.
Exhibit 12.4 MACRS Depreciation Rates
Year | 3-year | 5 year | 7 year | 10 year | 15 year | 20 year |
1 | 33.33 | 20.00 | 14.29 | 10.00 | 5.00 | 3.75 |
2 | 44.45 | 32.00 | 24.49 | 18.00 | 9.50 | 7.22 |
3 | 14.81 | 19.20 | 17.49 | 14.40 | 8.55 | 6.68 |
4 | 7.31 | 11.52* | 12.49 | 11.52 | 7.70 | 6.18 |
5 | 11.52 | 8.93 * | 9.22 | 6.93 | 5.71 | |
6 | 5.76 | 8.92 | 7.37 | 6.23 | 5.28 | |
7 | 8.92 | 6.55* | 5.90* | 4.89 | ||
8 | 4.47 | 6.55 | 5.90 | 4.52 | ||
9 | 6.56 | 5.91 | 4.46* | |||
10 | 6.55 | 5.90 | 4.46 | |||
11 | 3.28 | etc | etc |
*First year of switching to the Straight-line method
Trending now
This is a popular solution!
Step by step
Solved in 4 steps with 6 images