The spreadsheet formulas every entrepreneur should know, Part 5: What is payback?
March 3rd, 2010
Introduction
1.) Internal Rate of Return
1a.) Modified Internal Rate of Return
2.) Net present value
3.) Payback (What Is Payback?, Spreadsheet Payback, Discounted Payback, Spreadsheet Discounted Payback)
4.) Average
5.) Standard deviation
Bonus!) Excel Solver
Our epic little mini-series on must-know spreadsheet formulas has covered some pretty advanced topics, mind-benders like the internal rate of return and net present value, painful but powerful math for discovering the financial prospects of a startup or business project. In comparison to these textbook beasties, calculating a payback period is literally a walk in the math park. Really — the only business math harder to calculate than payback is counting your money. And, like IRR’s and present values, startup investors, including venture capitalists, set a great deal of store by paybacks — an attractive (that is, short) payback period is yet another reason for folks with money to throw a bit your way.
Because payback is both critically important and mindlessly simple, you’d think it would be easy to do on your spreadsheet, right? Well, see, you’re trapped by your earthling way of thinking there. Spreadsheet designers in their infinite wisdom have transported payback to the twelfth dimension, so setting up a formula to automatically determine the payback period for your prospective business or project financials requires a bit of zigging and sagging.
Which is why this is such a great blog post. Because we’re going to do all the zigging and zagging for you and give you a nice, clean formula that you can paste into your financial projections.



