0 A new renewable energy company, Cleantech, is building its first plant in the Tampa Bay area where algae farms will turn sunlight into automotive biofuel. Selena, an IE working for CleanTech, has been tasked to evaluate 2 different mutually exclusive plans with a 15-year horizon analysis period). Cleantech seeks a MARR of 12.89%. The federal corporate income tax rate is 21.00%, and Florida's state corporate income tax rate is 3.533. Determine the best course of action for CleanTech Plan A: This plan will yield 6.A million gallons of biofuel per year. Initially, the green technology Equipment A la 5-year property class, but a useful le of 15 years will cost $2.5 million plus installation costs of $125.000 Equipment A will receive a 40 bonus depreciation in Year 1. First-year annual operating costs will be $22.5 million and increase each year after that by $250,000. This plan will produce biofuel worth $38.9 million in revenue the first year and will increase in revenue by 9% each year thereafter Plan B: This plan will yield 8.4 million gallons of biofuel per year. Initially, the green technology Equipment B 5-year property class, but a useful le of 15 years) will cost $1.5 milion plus installation costs of $325.000. Equipment will receive a 40 bonus depreciation in Year 1. First year annual operating costs will be $33.5 million and increase each year after that by $150,000. This plan will produce biofuel worth $45.7 million in revenue the first year and will increase in in revenue by 9% each year thereafter Answer the following questions in your Excel file: 911 Calculate the combined incremental tax rate. Show your work 021 Calculate the value of the bonus depreciation for both Equipment A and Coupment 8. Then, calculate the new Cost Basis for both Equipment A and Equipment & that will be subject to MACRS depreciation Show your work for both Equipment A and Equipment. 3) in a table, determine the After Tax Cash Flow for Plan A. Be sure to include and/or calculate: 1) Before-Tex Cash Flow unted and table. 2) Bonus Depreciation 3 MACRS Rates 41 MACRS Depreciation 5) Taxable income. 61 income Taxes se combined incremental tax rated and 7) After Cash Flow as vertical columns 41 inatible determine the After-Tax Cash Flow for Plan B. Be sure to include and/or calculate 1) Before Tax Cash Flow (unteed and tablel 21 Bonus Depreciation 31 MACRS Rates 4 MACRS Depreciation, 5) Table income, 6 Income Taxes use combined incremental tax rate, and 7) Alter Tax Cash Flow as vertical columns 5) Which Pan should nech choose according to After-Tax Present Worth Analysis? WHY? You must show all cautions and explain to receive full credit Q. Which Plan should Cleantec choose according to After-Tax Annual Cash Flow Analysis? WHY? You must show all calculations and explain to receive full credit on Which Plan should Cleanilech choose according to After-Tax Rate of Return Analysis? WHY? You must show al calculations and explain to receive all credit