Answered step by step
Verified Expert Solution
Question
1 Approved Answer
please answer it and write the steps f or goal seek A company purchases an asset that costs $13,000. This asset qualifies as three-year property
please answer it and write the steps for goal seek
A company purchases an asset that costs $13,000. This asset qualifies as three-year property under MACRS. The company uses an after-tax discount rate of 10% and faces a 34% income tax rate. (Use Table 1, Table 2 and Exhibit 12.4.) 1. Demonstrate that the PV of the depreciation deductions, when the income tax rate is 34%, is $3,677. 2. Given an after-tax discount rate of 10%, what tax rate would be needed in order for the PV of the depreciation deductions to equal $4,420? Use the Goal Seek function of Excel. Answer is not complete. Complete this question by entering your answers in the tabs below. Required 1 Required 2 Demonstrate that the PV of the depreciation deductions, when the income tax rate is 34%, is $3,677. (Do not round intermediate calculations. Round "PV factor" to 3 decimal places and other answers to 2 decimal places.) Year MACRS % 1 $ % % 33.33 44.45 14.81 7.41 N Depreciation Deduction $ 4,332.90 5,778.50 1,925.30 963.30 $ 13,000.00 Tax Savings $ 1,473.19 1,964.69 654.60 327.52 $ 4,420.00 PV Factor 0.909 0.826 0.751 0.683 Present Values 1,339.13 1,622.83 491.60 223.70 3,677.26 3 3 4 % % 100.00 $ A company purchases an asset that costs $13,000. This asset qualifies as three-year property under MACRS. The company uses an after-tax discount rate of 10% and faces a 34% income tax rate. (Use Table 1, Table 2 and Exhibit 12.4.) 1. Demonstrate that the PV of the depreciation deductions, when the income tax rate is 34%, is $3,677. 2. Given an after-tax discount rate of 10%, what tax rate would be needed in order for the PV of the depreciation deductions to equal $4,420? Use the Goal Seek function of Excel. Complete this question by entering your answers in the tabs below. Required 1 Required 2 Given an after-tax discount rate of 10%, what tax rate would be needed in order for the PV of the depreciation deductions to equal $4,420? Use the Goal Seek function of Excel. (Round your answer to 2 decimal places.) Marginal income tax rate : % A company purchases an asset that costs $13,000. This asset qualifies as three-year property under MACRS. The company uses an after-tax discount rate of 10% and faces a 34% income tax rate. (Use Table 1, Table 2 and Exhibit 12.4.) 1. Demonstrate that the PV of the depreciation deductions, when the income tax rate is 34%, is $3,677. 2. Given an after-tax discount rate of 10%, what tax rate would be needed in order for the PV of the depreciation deductions to equal $4,420? Use the Goal Seek function of Excel. Answer is not complete. Complete this question by entering your answers in the tabs below. Required 1 Required 2 Demonstrate that the PV of the depreciation deductions, when the income tax rate is 34%, is $3,677. (Do not round intermediate calculations. Round "PV factor" to 3 decimal places and other answers to 2 decimal places.) Year MACRS % 1 $ % % 33.33 44.45 14.81 7.41 N Depreciation Deduction $ 4,332.90 5,778.50 1,925.30 963.30 $ 13,000.00 Tax Savings $ 1,473.19 1,964.69 654.60 327.52 $ 4,420.00 PV Factor 0.909 0.826 0.751 0.683 Present Values 1,339.13 1,622.83 491.60 223.70 3,677.26 3 3 4 % % 100.00 $ A company purchases an asset that costs $13,000. This asset qualifies as three-year property under MACRS. The company uses an after-tax discount rate of 10% and faces a 34% income tax rate. (Use Table 1, Table 2 and Exhibit 12.4.) 1. Demonstrate that the PV of the depreciation deductions, when the income tax rate is 34%, is $3,677. 2. Given an after-tax discount rate of 10%, what tax rate would be needed in order for the PV of the depreciation deductions to equal $4,420? Use the Goal Seek function of Excel. Complete this question by entering your answers in the tabs below. Required 1 Required 2 Given an after-tax discount rate of 10%, what tax rate would be needed in order for the PV of the depreciation deductions to equal $4,420? Use the Goal Seek function of Excel. (Round your answer to 2 decimal places.) Marginal income tax rate : %Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started