Create an Excel spreadsheet for Brief Exercise 12-20 and demonstrate that the PV of the depreciation deductions, when the income tax rate is 40%, is $3,218 (rounded to the nearest dollar). Given an after-tax discount rate of 12%, what tax rate (rounded to 2 decimal places, e.g., 38.712% = 38.71%) would be needed in order for the PV of the depreciation deductions to equal $4,000? Use the Goal Seek function of Excel.
Already registered? Login
Not Account? Sign up
Enter your email address to reset your password
Back to Login? Click here