Cash Outflow for Projec Cash Inflow for Project PBP per project: Pay Back Period in EXCEL - SEE THE FIRST TAB for Instructions Year Discount Rate Project 1 Cash Flow 20000 30000 40000 50000 100000 100000 150000 250000 Project 2 Cash Flow 20% Project 3 Project 4 Cash Flow Cash Flow 0 $(500,000) $(500,000) $(500,000) $(500,000) $(500,000) 1 250000 140000 2 150000 600000 3 100000 4 100000 5 50000 6 40000 7 30000 20000 92500 92500 92500

92500 92500 92500 92500 92500 Project 5 Cash Flow 240000 500000

\begin{tabular}{|c|c|c|c|c|c|c|} \hline & & Project 1 & Project 2 & Project 3 & Project 4 & Project 5 \\ \hline & Year & Cash Flow & Cash Flow & Cash Flow & Cash Flow & Cash Flow \\ \hline Cash Outflow for Projec & 0 & $(500,000) & $(500,000) & $(500,000) & $(500,000) & $(500,000) \\ \hline \multirow{10}{*}{ Cash Inflow for Project } & 1 & 20000 & 250000 & 92500 & & 140000 \\ \hline & 2 & 30000 & 150000 & 92500 & & 600000 \\ \hline & 3 & 40000 & 100000 & 92500 & & \\ \hline & 4 & 50000 & 100000 & 92500 & & \\ \hline & 5 & 100000 & 50000 & 92500 & & \\ \hline & 6 & 100000 & 40000 & 92500 & & \\ \hline & 7 & 150000 & 30000 & 92500 & 240000 & \\ \hline & 8 & 250000 & 20000 & 92500 & 500000 & \\ \hline & & & & & & \\ \hline & Discount Rate & 20% & & & & \\ \hline \multicolumn{7}{|l|}{ PBP per project: } \\ \hline & & & & & & \\ \hline \multicolumn{7}{|l|}{ Analysis per project: } \\ \hline \multicolumn{7}{|l|}{ Project 1} \\ \hline \multicolumn{7}{|l|}{ Project 2} \\ \hline \multicolumn{7}{|l|}{ Project 3} \\ \hline \multicolumn{7}{|l|}{ Project 4} \\ \hline Project 5 & & & & & & \\ \hline \end{tabular}