Answered step by step
Verified Expert Solution
Link Copied!

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,

image text in transcribed

Following is the attached MS Excel Data

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Finance questions