Please provide the formula when you solve for each cell. The portions that I need solved are intermediate calculation for payback and payback using intermediate calculations and payback using percentrant.
Please provide the solutions for only the sections I wrote. I already did the rest. Please provide the formula when you solve for each cell.
For section G project A intermediate calculations for payback and payback using intermediate calculations.
Project B intermediate calculation for payback and payback using intermediate calculations
Gardial Fisheries is considering two mutually exclusive investments. The projects' expected net cash flows are as follows: Expected Net Cash Flows \begin{tabular}{|c|c|c|} \hline Time & Project A & Project B \\ \hline 0 & ($375) & ($575) \\ \hline 1 & ($300) & $190 \\ \hline 2 & ($200) & $190 \\ \hline 3 & ($100) & $190 \\ \hline 4 & $600 & $190 \\ \hline 5 & $600 & $190 \\ \hline 6 & $926 & $190 \\ \hline 7 & ($200) & $0 \\ \hline \end{tabular} \begin{tabular}{l|l} 90 & \\ 91 Project B \end{tabular} \begin{tabular}{r|l|l|l|l|l|l|l|l} Time period & 0 & 1 & 2 & 3 & 4 & 5 & 6 & 7 \\ \hline Cash flow & & & & & & & \end{tabular} Cumulative cash flow Intermediate calculation 96 Payback using Ok because cash flows follow normal pattern. 99 g. At a cost of capital of 12%, what is the discounted payback period for these two projects? Disc. cash flow Disc. cum. cash flow Intermediate calculation Payback using Project B \begin{tabular}{r|l|l|l|l|l|l|l|l|} Time period & 0 & 1 & 2 & 3 & 4 & 5 & 6 & 7 \\ \hline Cash flow & & & & & & & & \end{tabular} Disc. cash flow Disc. cum. cash flow Intermediate calculation 117 Payback using using PERCENTRANK Ok because cash flows follow normal pattern. 119 120h. What is the profitability index for each project if the cost of capital is 12% ? 121 122 PV of future cash flows for A: 123 PI of A: 124 125 PV of future cash flows for B: 126 PI of B: Gardial Fisheries is considering two mutually exclusive investments. The projects' expected net cash flows are as follows: Expected Net Cash Flows \begin{tabular}{|c|c|c|} \hline Time & Project A & Project B \\ \hline 0 & ($375) & ($575) \\ \hline 1 & ($300) & $190 \\ \hline 2 & ($200) & $190 \\ \hline 3 & ($100) & $190 \\ \hline 4 & $600 & $190 \\ \hline 5 & $600 & $190 \\ \hline 6 & $926 & $190 \\ \hline 7 & ($200) & $0 \\ \hline \end{tabular} \begin{tabular}{l|l} 90 & \\ 91 Project B \end{tabular} \begin{tabular}{r|l|l|l|l|l|l|l|l} Time period & 0 & 1 & 2 & 3 & 4 & 5 & 6 & 7 \\ \hline Cash flow & & & & & & & \end{tabular} Cumulative cash flow Intermediate calculation 96 Payback using Ok because cash flows follow normal pattern. 99 g. At a cost of capital of 12%, what is the discounted payback period for these two projects? Disc. cash flow Disc. cum. cash flow Intermediate calculation Payback using Project B \begin{tabular}{r|l|l|l|l|l|l|l|l|} Time period & 0 & 1 & 2 & 3 & 4 & 5 & 6 & 7 \\ \hline Cash flow & & & & & & & & \end{tabular} Disc. cash flow Disc. cum. cash flow Intermediate calculation 117 Payback using using PERCENTRANK Ok because cash flows follow normal pattern. 119 120h. What is the profitability index for each project if the cost of capital is 12% ? 121 122 PV of future cash flows for A: 123 PI of A: 124 125 PV of future cash flows for B: 126 PI of B
