Thank you!

Net present value: Independent projects. Using a 10% cost of capital, calculate the net present value for each of the independent projects shown in the following table, and indicate whether each is acceptable. Important Do not use cell references to cells in rows 7 to 17 . For all required answers, use cell references to values starting in row 22 . Project A \begin{tabular}{|l|r|} \hline Discount rate & 10% \\ \hlineCF0 & $250 \\ \hlineCF1 & $50 \\ \hlineCF2 & $90 \\ \hlineF3 & 140 \\ \hlineF4 & $80 \\ \hline NPV of project A & \\ \hline The project will be & \\ \hline \end{tabular} Project B Discount rate CF0 CF1 CF2 CF3 CF4 CF5 CF6 CF7 CF8 CF9 NPV of project B The project will be \begin{tabular}{|r|} \hline 10% \\ \hline$375 \\ \hline$45 \\ \hline$55 \\ \hline$65 \\ \hline$55 \\ \hline$45 \\ \hline$35 \\ \hline$25 \\ \hline$15 \\ \hline$5 \\ \hline \\ \hline \end{tabular} Project C Discount rate CF0 CF1 CF2 CF3 CF4 CF5 CF6 NPV of project C The project will be \begin{tabular}{|r|} \hline 10% \\ \hline$550 \\ \hline$350 \\ \hline$210 \\ \hline$165 \\ \hline$55 \\ \hline$45 \\ \hline$10 \\ \hline \\ \hline \end{tabular} Project D Discount rate CF0 CF1 CF2 CF3 CF4 CF5 CF6 NPV of project D The project will be \begin{tabular}{|r|} \hline 10% \\ \hline$750 \\ \hline$200 \\ \hline$235 \\ \hline$250 \\ \hline$265 \\ \hline$100 \\ \hline$50 \\ \hline \\ \hline \end{tabular} Project E Discount rate CF0 CF1 CF2 CF3 CF4 CF5 CF6 CF7 CF8 CF9 CF10 NPV of project E The project will be \begin{tabular}{|r|} \hline 10% \\ \hline$1,150 \\ \hline$80 \\ \hline$135 \\ \hline$190 \\ \hline$255 \\ \hline$315 \\ \hline$380 \\ \hline$275 \\ \hline$100 \\ \hline$45 \\ \hline$25 \\ \hline \end{tabular}