PLEASE BE CLEAR WHEN USING EXCEL! (FORMULAS/EQUATIONS/CALCULATIONS) THANK YOU! (EXCEL PREFERRED)

09.06-PR002 A subsidiary of AEP places in service electric generating and transmission equipment at a cost of $3,000,000. It is expected to last 30 years with a salvage value of $250,000. The equipment will increase net income by $500,000 in the first year, increasing by 2.4% each year thereafter. The subsidiary's tax rate is 25% and the after-tax MARR is 9%. There is some concern that the need for this equipment will last only 10 years and will need to be sold off for $550,000 at that time. Develop tables using a spreadsheet to determine the ATCF for each year and the after-tax PW, AW, IRR, and ERR after only 10 years to see if the venture would be worthwhile economically. a. Use MACRS-GDS(20) alone. b. Use MACRS-GDS(20) with the Section 179 expense deduction. c. Comment on the percentage differences in PW AT for these two analyses. 09.06-PR002 A subsidiary of AEP places in service electric generating and transmission equipment at a cost of $3,000,000. It is expected to last 30 years with a salvage value of $250,000. The equipment will increase net income by $500,000 in the first year, increasing by 2.4% each year thereafter. The subsidiary's tax rate is 25% and the after-tax MARR is 9%. There is some concern that the need for this equipment will last only 10 years and will need to be sold off for $550,000 at that time. Develop tables using a spreadsheet to determine the ATCF for each year and the after-tax PW, AW, IRR, and ERR after only 10 years to see if the venture would be worthwhile economically. a. Use MACRS-GDS(20) alone. b. Use MACRS-GDS(20) with the Section 179 expense deduction. c. Comment on the percentage differences in PW AT for these two analyses