Guys
I want a standard formula for payback period calculation even if the the project is delayed and initial outflows occur in year 2 instead of year 0.
I have attached the spreadsheet. Like for example from B2 to K2 are year 1 to 10. This is constant line and i cant change it
Project one was started in year 1 so we calculate the payback perido in b5.
Whereas project 2 was started in year 2 for which i want to calculate the payback period using the same formula which i used in B5. Its because my projects gets delayed quite often and i just want to copy paste formula in B5 regardless of when the project ws started. it should calculate correct payback period.
Thanks in advance
Bookmarks