Question: Please help I did an excel sheet and still I'm coming up with the wrong answers. Freedom Corporation acquired a fixed asset for $260,000. Its

 Please help I did an excel sheet and still I'm coming

Please help I did an excel sheet and still I'm coming up with the wrong answers.

Freedom Corporation acquired a fixed asset for $260,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, and AppendixC. TABLE 2.) Required: 1. What is the incremental present value of the tax benefits resulting from calculating depreciation using the sum-of-theyears'-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 doubledeclining-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. Complete this question by entering your answers in the tabs below. 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. (Negative amount should be indicated by a minus sign. Round your answer to the nearest whole dollar.) Freedom Corporation acquired a fixed asset for $260,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, and AppendixC. TABLE 2.) Required: 1. What is the incremental present value of the tax benefits resulting from calculating depreciation using the sum-of-theyears'-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 doubledeclining-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. Complete this question by entering your answers in the tabs below. 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. (Negative amount should be indicated by a minus sign. Round your answer to the nearest whole dollar.)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!