What is the value of a company based on the following data and a discount rate of 8%?

PLEASE SHOW EXCEL CALCULATIONS

\begin{tabular}{|l|l|l|l|l|l|} \hline Year & After-tax earnings & depreciation & Change in working capital needed & Fixed asset investment & Residual value \\ \hline 1 & 100,000 & 30,000 & Increase 3,000 & 0 & \\ \hline 2 & 110,000 & 30,000 & Increase 4,000 & 0 & \\ \hline 3 & 130,000 & 30,000 & Increase 8,000 & Cost 50,000 & \\ \hline 4 & 180,000 & 30,000 & Increase 10,000 & Cost 30,000 & \\ \hline 5 & 220,000 & 30,000 & Increase 15,000 & 0 & 10,500,000 \\ \hline \end{tabular}