Company Chosen is APPLE Apple WACC: 8.3% -Please use this rate. Apple Inc. currently has property and equipment as $39,245,000,000.00 The firm is looking to expand its operations by 10% of the firm's net property, plant, and equipment. (Calculate this amount by taking 10% of the property, plant, and equipment figure that appears on the firm's balance sheet.) The estimated life of this new property, plant, and equipment will be 12 years. The salvage value of the equipment will be 5% of the property, plant and equipment's cost. The annual EBIT for this new project will be 18% of the project's cost. The company will use the straight-line method to depreciate this equipment. Also assume that there will be no increases in net working capital each year. Use 25% as the tax rate in this project.

Calculate The following capital budgeting results for the project:

1. Net present value

2. Internal rate of return

3. Discounted payback period

4. Should Purchase? If possible please provide a break down of calculations as well as excel sheet