Question: Question 5 (1 point) Retake question Please see this attached Excel spreadsheet with cash flows for a potential project. Calculate the payback period of the

Question 5 (1 point) Retake question Please see this attached Excel spreadsheet with cash flows for a potential project. Calculate the payback period of the project. Report your answer in years rounded to two decimal places. Your Answer: Answer units \begin{tabular}{c|c|c} \multicolumn{1}{c|}{} & A & \multicolumn{1}{c}{ B } \\ \cline { 2 - 3 } 1 & Period & Cash Flows \\ \cline { 2 - 3 } 2 & 0 & (60,000) \\ 3 & 1 & 5,000 \\ 4 & 2 & 15,000 \\ 5 & 3 & 12,000 \\ 6 & 4 & 23,000 \\ 7 & 5 & 15,000 \\ 8 & 6 & 20,000 \\ 9 & 7 & 23,000 \\ 10 & 8 & 24,000 \\ 11 & & \\ 12 & Discount Rate & 11% \\ 13 & & \\ 14 & & \\ 15 & & \\ 16 & & \end{tabular}
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
