Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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 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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started