I need the answers to the blue colored cells.

Can you please show me how you would calculate the answers using excel, Thank you so much!

Solution 10% Cost of capital Estimated life Project Alpha Estimated life Project Beta a. Calculate the NPV for each project over its respective life. Rank the projects in descending order on the basis of NPV. Which one would you choose? Project Alpha Project Beta NPV Rank Choice of project Reason Project has a NPV. b. Use the annualized net present value (ANPV) approach to evaluate and rank the projects in descending order on the basis of ANPV. Which one would you choose? Project Alpha Project Beta ANPV Rank Choice of project Reason Project has a TANPV. Compare and contrast your findings in parts a and b. Which project would you recommend that the firm choose? Explain. The Net Present Value approach recommends that we select Project Alpha, whereas the Annualized Net Present Value approach suggests that we select Project Beta. NPV approach is more suitable when the lives of the projects under consideration are equal, however the annualized NPV approach takes into account the duration of the projects and converts the net present value into an equivalent annual amount. Project Beta should be recommended because the ANPV method should be used when deciding between mutually exclusive investments with unequal lives. Is the statement above true or false? The statement is Solution 10% Cost of capital Estimated life Project Alpha Estimated life Project Beta a. Calculate the NPV for each project over its respective life. Rank the projects in descending order on the basis of NPV. Which one would you choose? Project Alpha Project Beta NPV Rank Choice of project Reason Project has a NPV. b. Use the annualized net present value (ANPV) approach to evaluate and rank the projects in descending order on the basis of ANPV. Which one would you choose? Project Alpha Project Beta ANPV Rank Choice of project Reason Project has a TANPV. Compare and contrast your findings in parts a and b. Which project would you recommend that the firm choose? Explain. The Net Present Value approach recommends that we select Project Alpha, whereas the Annualized Net Present Value approach suggests that we select Project Beta. NPV approach is more suitable when the lives of the projects under consideration are equal, however the annualized NPV approach takes into account the duration of the projects and converts the net present value into an equivalent annual amount. Project Beta should be recommended because the ANPV method should be used when deciding between mutually exclusive investments with unequal lives. Is the statement above true or false? The statement is