The payback period is the amount of time needed to recover the initial outlay for an investment. Learn how to calculate it with Microsoft Excel.

Download a free dividend payback period excel spreadsheet calculator in this article. Imagine you bought a vending machine for $2,000. This vending machine made you profits of $100 a year, after ...

Calculating the payback period in Excel is the simplest when the annual cash flows are the same for each year. Here is a brief outline of the steps to calculate the payback period in Excel.