solve using excel

7. If each projecfs coat of capital is 12%, which projest should be selected? if the ceat of capieal is is\%. what project is the sroper choice? Construct APV Proties for Preject A And B d. What is the crossever rate, and what is its significance? \begin{tabular}{ll} Crossover rate & = \\ \hline \end{tabular} The efensever rate represents the cost of eapital at which the foo prejecta valoe, at a cost of eapital of 12.14% is: 1. What is the regular payback peried for thase twe projects? What is the prefiability index for eash project if the eost of capital is 12%