excel needs to be in this format,help me with this

Q.2. The updated report needs to explain how Annual worth, Present worth and Internal Rate of Return (IRR) are used in capital investment decisions. A manufacturing process can be designed for varying degrees of automation/ capacity with different costs of operations, energy consumption and service requirements including warranties. Generally, with higher costs the expected benefits are also higher. However, comparison of alternatives are not easy due to different expected life and cost parameters associated with each alternative. The following is relevant cost information table for a simple analysis: Alternatives Cost for procurement & installation Annual Labour Cost Annual Power and Maintenance Cost A C D Organisations generally have a contract/ demand to supply certain number of units per year with a contract sale price of certain value per unit. You need to apply appropriate tools to determine the best option after-tax analyses using a tax rate of 22/2 % and a minimum acceptable after-tax rate of return of 7/2 % and straight-line depreciation of the asset for at least three alternatives. You need to consider expected life of each alternative and salvage value, if any after end of the life. Use each of the following methods for recommending the best option: (a) Annual worth. (b) Present worth. (c) Internal Rate of Return (IRR). Q.2. The updated report needs to explain how Annual worth, Present worth and Internal Rate of Return (IRR) are used in capital investment decisions. A manufacturing process can be designed for varying degrees of automation/ capacity with different costs of operations, energy consumption and service requirements including warranties. Generally, with higher costs the expected benefits are also higher. However, comparison of alternatives are not easy due to different expected life and cost parameters associated with each alternative. The following is relevant cost information table for a simple analysis: Alternatives Cost for procurement & installation Annual Labour Cost Annual Power and Maintenance Cost A C D Organisations generally have a contract/ demand to supply certain number of units per year with a contract sale price of certain value per unit. You need to apply appropriate tools to determine the best option after-tax analyses using a tax rate of 22/2 % and a minimum acceptable after-tax rate of return of 7/2 % and straight-line depreciation of the asset for at least three alternatives. You need to consider expected life of each alternative and salvage value, if any after end of the life. Use each of the following methods for recommending the best option: (a) Annual worth. (b) Present worth. (c) Internal Rate of Return (IRR). Q.2. The updated report needs to explain how Annual worth, Present worth and Internal Rate of Return (IRR) are used in capital investment decisions. A manufacturing process can be designed for varying degrees of automation/ capacity with different costs of operations, energy consumption and service requirements including warranties. Generally, with higher costs the expected benefits are also higher. However, comparison of alternatives are not easy due to different expected life and cost parameters associated with each alternative. The following is relevant cost information table for a simple analysis: Alternatives Cost for procurement & installation Annual Labour Cost Annual Power and Maintenance Cost A C D Organisations generally have a contract/ demand to supply certain number of units per year with a contract sale price of certain value per unit. You need to apply appropriate tools to determine the best option after-tax analyses using a tax rate of 22/2 % and a minimum acceptable after-tax rate of return of 7/2 % and straight-line depreciation of the asset for at least three alternatives. You need to consider expected life of each alternative and salvage value, if any after end of the life. Use each of the following methods for recommending the best option: (a) Annual worth. (b) Present worth. (c) Internal Rate of Return (IRR). Q.2. The updated report needs to explain how Annual worth, Present worth and Internal Rate of Return (IRR) are used in capital investment decisions. A manufacturing process can be designed for varying degrees of automation/ capacity with different costs of operations, energy consumption and service requirements including warranties. Generally, with higher costs the expected benefits are also higher. However, comparison of alternatives are not easy due to different expected life and cost parameters associated with each alternative. The following is relevant cost information table for a simple analysis: Alternatives Cost for procurement & installation Annual Labour Cost Annual Power and Maintenance Cost A C D Organisations generally have a contract/ demand to supply certain number of units per year with a contract sale price of certain value per unit. You need to apply appropriate tools to determine the best option after-tax analyses using a tax rate of 22/2 % and a minimum acceptable after-tax rate of return of 7/2 % and straight-line depreciation of the asset for at least three alternatives. You need to consider expected life of each alternative and salvage value, if any after end of the life. Use each of the following methods for recommending the best option: (a) Annual worth. (b) Present worth. (c) Internal Rate of Return (IRR)