Explore BrainMass
Share

# Calculate Net Present Value before and after tax of an investment

This content was STOLEN from BrainMass.com - View the original, and get the already-completed solution here!

In considering an investment, the cost of new equipment is \$2 million each and installation is \$1.3 million each. The company is considering purchasing 5 units. This purchase will allow service to 300 more customers, but the additional services are only needed 40 days a year. The cost to run extra equipment will be \$500 per day for each of the 200 days that the business is open each year. Customer tickets are \$55 a day and added expenses to each customer will be \$5. Economic life of new equipment is 20 years.

How to find the before tax NPV with required rate of return of 14%, and also after tax NPV with required rate of return of 8% when income tax rate is 40% and MACRS recovery period is 10 years.

Will the investments be profitable?

#### Solution Summary

In Excel, the solution is laid out and calculated with explanation.

\$2.19

## Capital Budgeting

1. The capital budgeting department is contemplating whether to purchase a piece of equipment. The new piece of equipment costs \$900,000. The equipment currently being used b the firm would be replaced by the new and would e sold for \$100,000 which is the firms book value fort he asset. The estimated useful life of the new equipment is 3 years. The firm's capital gain tax rate is 20% and their ordinary tax rate is 40%. The new equipment is not expected to have a salvage value at the end of its useful life and the firm uses straight-line depreciation.

Estimated Earnings
Year Without the new equipment With the new equipment
1 \$500,000 \$1,200,000
2 \$700,000 \$1,500,000
3 \$900,000 \$1,900,000

Depreciation Information
Year Without the new equipment With the new Equipment
1 \$200,000 \$500,000
2 \$250,000 \$550,000
3 \$300,000 \$600,000

Calculate the net investment, net cash flows, the net present value and the Internal Rate of Return on this project assuming an 8% cost of capital. (25 points)

1. Net Investment = \$900,000 - 100,000*(1-40%) = \$840,000
2. Net Cash Flows = Increase in cash flow*(1-t) + Increase in depreciation * t
Year Cash flow:
1 (1,200, -500,)*(1-40%) + (500, - 200,)*40% = 540,000
2 (1,500,-700,)*(1-40%) + (550, - 250,)*40% = 600,000
3 (1,900, -900,)*(1-40%) + (600, - 300,)*40% = 720,000

3. Net Present Value
The present of each cash flow is computed by:
PVi = CF / (1+r)^i
Where r = 8% and i is the number of years.
By a financial calculator, NPV = \$745,963

4. Internal Rate of Return
By a financial calculator, IRR = 38.9%, which is higher than the cost of capital.

2.How would your answer to number 1 change if the existing asset that is being replaced was sold at \$125,000. The assets original purchase price was \$500,000 Remember the assets book value is \$100,000. Assume all other facts are the same as in question number 2. ( make sure to calculate the net investment, net cash flows, net present value and IRR.)
Net Investment \$_______________________________
Net Cash Flows \$_______________________________
Net Present Value \$_______________________________
Internal Rate of Return ___________________________%

View Full Posting Details