Question

In: Accounting

Submit your solution to the problem in an Excel file. Explain your answer as necessary and...

Submit your solution to the problem in an Excel file. Explain your answer as necessary and be sure your calculations are clearly shown.

ABC Corporation is large and profitable. This year it is considering buying factory equipment for $100,000,000. ABC’s cost of capital is 7%.

Required:

a) What is the after-tax cost of the equipment if it qualifies for 100% bonus depreciation?

b) What is the after-tax cost of the equipment if it is depreciated using MACRS (7 year recovery period)?

c)How might the tax treatment of the purchase affect ABC’s decision?

d) Comment on the economic policy purpose of Congress in enacting bonus depreciation.

Solutions

Expert Solution

Answer :

Assumption :

Tax rate assumed as 30%

Depreciation under 7 year recovery on half year convention and GDS

(a).

100% bonus depreciation means tax deduction of full value

Tax savings = 100,000,000 * 30% = 30,000,000

PV of benefit = 30,000,000*(1+7%)^ -1 = 28037383

Net investment cost after tax = 100,000,000 - 28037383 = 71,962,617

(b).

working (dep rate from MACRS table)

Year Dep Y1 Dep allowed Tax Benefit PV of tax benefit
1 14.29% 14290000 4287000 4006542
2 24.49% 24490000 7347000 6417154
3 17.49% 17490000 5247000 4283115
4 12.49% 12490000 3747000 2858568
5 8.93% 8930000 2679000 1910090
6 8.92% 8920000 2676000 1783132
7 8.93% 8930000 2679000 1668347
8 4.46% 4460000 1338000 778728
- - - - 23705676

Net investment cost after tax = 100,000,000 - 23705676 = 76,294,324

(c).

As is evident under 100% bonus depreciation the present value of investment is lower as compared to standard 7 years and hence if it is available it is preferred

(d).

The purpose of this bonus depreciation was to help business recover investment spendings quick and in process this incentive facilitating simulate economy.


Related Solutions

Create an Excel spreadsheet to organize your answers to the following problem, and submit your Excel...
Create an Excel spreadsheet to organize your answers to the following problem, and submit your Excel file as an attachment by clicking on the appropriate button on this page. A firm that is in the 35% tax bracket forecasts that it can retain $4 million of new earnings plans to raise new capital in the following proportions: 60% from 30-year bonds with a flotation cost of 4% of face value. Their current bonds are selling at a price of 91...
create an Excel spreadsheet to organize your answers to the following problem, and submit your Excel...
create an Excel spreadsheet to organize your answers to the following problem, and submit your Excel file as an attachment by clicking on the appropriate button on this page. A company is evaluating the purchase of a machine to improve product quality and output levels. The new machine would cost $1.6 million and would be depreciated for tax purposes using the straight-line method over an estimated six-year life to its expected salvage value of $100,000. The new machine would require...
Create an Excel spreadsheet to organize your answers to the following problem, and submit your Excel...
Create an Excel spreadsheet to organize your answers to the following problem, and submit your Excel file as an attachment by clicking on the appropriate button on this page. A company with EBIT of $6,000,000 is considering two financing alternatives. The first alternative would have interest expense of $2,000,000 and 1,000,000 common shares outstanding, whereas the second would have interest expense of $3,800,000 but only 750,000 shares outstanding. The company is in the 35% tax bracket. Part 1: Construct the...
Create an Excel spreadsheet to organize your answers to the following problem, and submit your Excel...
Create an Excel spreadsheet to organize your answers to the following problem, and submit your Excel file as an attachment by clicking on the appropriate button on this page. A firm had the following abbreviated income statement for 2020 and abbreviated balance sheets at the end of 2020 and 2021. 2020 Sales $600,000 Less Cost of goods sold 320,000 Gross Profit 280,000 Less Operating expenses 190,000 Less Depreciation 30,000 Operating Income (EBIT) 60,000 Less Interest expense 20,000 Earnings Before Taxes...
Create an Excel spreadsheet to organize your answers to the following problem, and submit your Excel...
Create an Excel spreadsheet to organize your answers to the following problem, and submit your Excel file as an attachment by clicking on the appropriate button on this page. A company with EBIT of $6,000,000 is considering two financing alternatives. The first alternative would have $25 million of bonds at 8% interest and 1,000,000 common shares outstanding, whereas the second would have $47.5 million of bonds at 8% interest and only 750,000 shares outstanding. The company is in the 35%...
Use Excel file to submit your work During Evaluation of internal operations, the administrator is concerned...
Use Excel file to submit your work During Evaluation of internal operations, the administrator is concerned that the use of labor and consumable supplies fail to vary directly with the volume of service. To examine the situation, the following data were assembled Volume (Visits) Labor (Hours) Supplies (Units) 7 4 1 8 4 1 12 7 2 11 7 2 17 9 5 20 12 8 22 13 9 24 14 9 1.Use the multiple regression analysis to examine the...
Please submit your Excel file and highlight your answers in color. Brief Case Has Gold Lost...
Please submit your Excel file and highlight your answers in color. Brief Case Has Gold Lost its Luster? In 2011, when the Gallup organization polled investors, 34% rated gold the best long-term investment. However, in April of 2013 Gallup surveyed a random sample of U.S. adults. Respondents were asked to select the best long-term investment from a list of possibilities. Only 241 of the 1005 respondents chose gold as the best long-term investment. A. With 95% confidence, compute the margin...
Using your Excel TVM Calculators answer the following questions, be sure to submit your spreadsheet with...
Using your Excel TVM Calculators answer the following questions, be sure to submit your spreadsheet with your answers highlighted. At what annual interest rate must $137,000 be invested so that it will grow to be $475,000 in 10 years? If you wish to accumulate $175,000 in 13 years, how much must you deposit today in an account that pays an annual interest rate of 15%? How many years will it take for $125,000 to grow to be $500,000 if it...
Please finish the following assignments in Excel and submit the Excel file onto Pilot. Please use...
Please finish the following assignments in Excel and submit the Excel file onto Pilot. Please use the data in “GPS.XSLS” to: Q1. Estimate the parameter p and q in Bass Model. Q2. Compute the time and value of peak sales. Year Sales (00s) 1990 164 1991 276 1992 578 1993 1604 1994 3435 1995 5785 1996 8500 1997 12000 1998 15000 1999 18000 2000 20000 Please show the steps thank you
. You must use Excel (submit either a pdf, word or Excel file only). . You...
. You must use Excel (submit either a pdf, word or Excel file only). . You must identify the 5 steps (you must address each in detail). Problem: Use the given data to complete a t-test using Excel. Question: Is there a difference in group means between the number of words spelled correctly for two groups of fourth graders? Group Assignment Score 1 3 1 4 1 10 2 14 2 7 2 8 2 10 2 15 2 9...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT