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

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

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!