\begin{tabular}{|c|c|c|c|c|c|c|} \hline \multicolumn{7}{|c|}{ Financial Analysis for Project Name } \\ \hline Created by: & & Date: & & & & \\ \hline \multicolumn{7}{|c|}{\begin{tabular}{l} Note: Change the inputs, such as discount rate, number of years, costs, and benefits. Be sure to \\ double-check the formulas based on the inputs. The discount factor is not rounded. \end{tabular}} \\ \hline Discount rate & 8% & & & & & \\ \hline \multirow{2}{*}{ Assume the project is completed in Year 0} & & & Year & & & \\ \hline & 0 & 1 & 2 & 3 & Total & \\ \hline Costs & 100 & 100 & 100 & 100 & & \\ \hline Discount factor & 1.00 & 0.93 & 0.86 & 0.79 & & \\ \hline Discounted costs & 100 & 93 & 86 & 79 & 358 & \\ \hline Benefits & 0 & 200 & 200 & 200 & & \\ \hline Discount factor & 1.00 & 0.93 & 0.86 & 0.79 & & \\ \hline Discounted benefits & 0 & 185 & 171 & 159 & 515 & \\ \hline Discounted benefits - costs & (100) & 93 & 86 & 79 & 158 & NPV \\ \hline \multirow[t]{2}{*}{ Cumulative benefits - costs } & (100) & (7) & 78 & 158 & & \\ \hline & & & & & & \\ \hline \multirow[t]{2}{*}{RO} & 44% & & & & & \\ \hline & \multirow{2}{*}{\multicolumn{3}{|c|}{ Payback in Year X }} & & & \\ \hline Assumptions & & & & & & \\ \hline Enter assumptions here & & & & & & \\ \hline \end{tabular}