Question: Following is the attached MS Excel Data The data for this task is preloaded into you Excel workbook. Cantor-Hilbert LLP (CL) is a medium-sized audit,

 Following is the attached MS Excel Data The data for this

Following is the attached MS Excel Data

task is preloaded into you Excel workbook. Cantor-Hilbert LLP (CL) is a

The data for this task is preloaded into you Excel workbook. Cantor-Hilbert LLP (CL) is a medium-sized audit, tax and consultancy firm. So far, the firm has operated primarily in the UK working with technology companies. It now sees an opportunity to start operations on the west coast of America, with a new US headquarters in San Francisco. It will go ahead with the project if the payback period is under six years. (a) Calculate the payback period for the project in years and months assuming no discounting. (4 marks) (b) Calculate the payback period for the project in years and months assuming a constant project risk-adjusted discount rate of 6% (4 marks) (c) Based on your calculations above and other considerations, should the project go ahead in your view? Give two points. (2 marks) \begin{tabular}{|c|c|c|c|c|} \hline Year & Cash in ($m) & Cash out ($m) & Net & Cumulative \\ \hline 0 & 0 & (2.00) & 2.00 & \\ \hline 1 & 0.5 & (1.00) & 1.50 & \\ \hline 2 & 0.5 & (0.90) & 1.40 & \\ \hline 3 & 0.7 & (0.50) & 1.20 & \\ \hline 4 & 1 & (0.10) & 1.10 & \\ \hline 5 & 2 & (0.10) & 2.10 & \\ \hline 6 & 2 & (0.10) & 2.10 & \\ \hline 7 & 2 & (0.10) & 2.10 & \\ \hline 8 & 2 & (0.10) & 2.10 & \\ \hline 9 & 2 & (0.10) & 2.10 & \\ \hline 10 & 2 & (0.10) & 2.10 & \\ \hline \end{tabular}

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!