The data for this task is preloaded into your Excel workbook. Methuselah clothes is planning to expand its clothing business by opening a factory overseas. The initial year 0 investment will be 35,000,000. It is expected to generate net revenues of 12,500,000 each year if the project goes ahead. Additional costs for the project will be 6,000,000 per year. [Cashflows occur at the end of each year] The companys weighted average cost of capital is 9% and the project will have a lifetime of 15 years. (a) Calculate the net present value (NPV) of the above proposal showing your workings in an excel spreadsheet including formulas. You should complete your answer on the Task 8 Data tab of the MBF Summative data.xlsx excel file.

\begin{tabular}{|c|c|c|c|c|} \hline Year & Cash in (fm) & Cash out (fm) & Net & NPV \\ \hline 0 & 0 & 35.00 & 35.00 & \\ \hline 1 & 12.5 & 6.00 & 6.50 & \\ \hline 2 & 12.5 & 6.00 & 6.50 & \\ \hline 3 & 12.5 & 6.00 & 6.50 & \\ \hline 4 & 12.5 & 6.00 & 6.50 & \\ \hline 5 & 12.5 & 6.00 & 6.50 & \\ \hline 6 & 12.5 & 6.00 & 6.50 & \\ \hline 7 & 12.5 & 6.00 & 6.50 & \\ \hline 8 & 12.5 & 6.00 & 6.50 & \\ \hline 9 & 12.5 & 6.00 & 6.50 & \\ \hline 10 & 12.5 & 6.00 & 6.50 & \\ \hline 11 & 12.5 & 6.00 & 6.50 & \\ \hline 12 & 12.5 & 6.00 & 6.50 & \\ \hline 13 & 12.5 & 6.00 & 6.50 & \\ \hline 14 & 12.5 & 6.00 & 6.50 & \\ \hline 15 & 12.5 & 6.00 & 6.50 & \\ \hline \end{tabular}