\begin{tabular}{|l|l|l|l|l|l|} & & & & & \\ \hline DEPRECIATION (+) & & & & & \\ \hline TAXES (ON EBIT) & & & & & \\ \hline \begin{tabular}{l} OPERATING CASH \\ FLOW \end{tabular} & & & & & \\ \hline PRESENT VALUE @10\% & & & & & \\ \hline PV OF CASH INFLOWS & & & & & \\ \hline & & & & & \\ \hline PV OF CASH INFLOWS & & & & & \\ \hline \begin{tabular}{l} PV OF CASH \\ OUTFLOWS \end{tabular} & & & & & \\ \hline NET PRESENT VALUE & & & & & \\ \hline \end{tabular} \begin{tabular}{|l|l|l|l|l|l|} & & & & & \\ \hline DEPRECIATION (+) & & & & & \\ \hline TAXES (ON EBIT) & & & & & \\ \hline \begin{tabular}{l} OPERATING CASH \\ FLOW \end{tabular} & & & & & \\ \hline PRESENT VALUE @10\% & & & & & \\ \hline PV OF CASH INFLOWS & & & & & \\ \hline & & & & & \\ \hline PV OF CASH INFLOWS & & & & & \\ \hline \begin{tabular}{l} PV OF CASH \\ OUTFLOWS \end{tabular} & & & & & \\ \hline NET PRESENT VALUE & & & & & \\ \hline \end{tabular} Example NPV Template A company is considering to buy a major project worth $22 million. It is a five year project. The sales and cost data are provided here: Price per unit =$400 Variable cost per unit =$200 Fixed costs per year =$800,000 Depreciation/CCA per year =$40,000 Tax rate =30% Discount rate =10%