Question: Calculate the payback period in a table. Include the headings Year, Cash flow and Cumulative Cash flow. Be sure to calculate the final payback period
Calculate the payback period in a table. Include the headings Year, Cash flow and Cumulative Cash flow. Be sure to calculate the final payback period including partial years.
In Excel Please!!!!! With Equations!!!
| Year | Cash Flow |
| 0 | -250,000 |
| 1 | 41,000 |
| 2 | 48,000 |
| 3 | 63,000 |
| 4 | 79,000 |
| 5 | 88,000 |
| 6 | 64,000 |
| 7 | 41,000 |
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock