Company is looking for opportunities to grow. Management is currently considering

project proposals that will help expand the business. Several ventures were pre$-$

screened and the team in$-$charge of evaluating proposals focused on two projects.

The following data are given for two mutually exclusive project proposals:

Assuming that the firm's required rate of return is $20\%,$ compute the following:

a$)$ Accounting Rate of Return

b$)$ Accounting Payback

c$)$ Net Present Value

d$)$ Internal Rate of Return

e$)$ Discounted Payback Period

f$)$ Profitability Index

Please provide a detailed response by using Excel to answer the question as precisely as possible. Ensure that your Excel solution is complete and thoroughly demonstrates the steps taken. Show all excel fromulas