**** PLEASE ADD EXCEL FORUMLAS TO EACH YELLOW BOX. E22 IS THE FIRST YELLOW BOX.

Net present value: Independent projects Using a 10% cost of capital and the NPV function, calculate the net present value for each of the independent projects shown in the following table, and indicate whether each is acceptable. Answers (insert your answers in the highlighted cells; use cell references, equations, and functions wherever possible) Hint: Remember to add the CF0 after the NPV function. \begin{tabular}{l} 29 \\ 30 \\ 31 \\ 32 \\ 33 \\ 34 \\ 35 \\ 36 \\ 37 \\ 38 \\ 39 \\ 40 \\ 41 \\ 42 \\ 43 \\ 44 \\ 45 \\ 46 \\ 47 \\ 48 \\ 49 \\ 50 \\ 51 \\ 52 \\ 53 \\ \hline 5 \end{tabular} Project B CF0 CF1 CF2 CF3 CF4 CF5 CF6 CF7 CF8 CF9 NPV Acceptable? \begin{tabular}{|} \hline \\ \hline \\ \hline \\ \hline \\ \hline \\ \hline \\ \hline \\ \hline \\ \hline \\ \hline \\ \hline \\ \hline \end{tabular} Project C CF0 CF1 CF2 CF3 CF4 CF5 CF6 NPV Acceptable? \begin{tabular}{|} \hline \\ \hline \\ \hline \\ \hline \\ \hline \\ \hline \\ \hline \\ \hline \\ \hline \\ \hline \end{tabular} Project D \begin{tabular}{l|l|} CF0 \\ CF1 & \\ CF2 & \\ CF3 & \\ CF4 \\ CF5 \\ CF6 \\ NPV \\ Acceptable? & \\ \hline \end{tabular} Project E CF0 CF1 CF2 CF3 CF4 CF5 CF6 CF7 CF8 CF9 CF10 NPV Acceptable? \begin{tabular}{|} \hline \\ \hline \\ \hline \\ \hline \\ \hline \\ \hline \\ \hline \\ \hline \\ \hline \\ \hline \\ \hline \\ \hline \end{tabular}