How to Calculate Payback Period

Solar and wind are common projects on which payback period analysis is performed.

The payback period is the time it takes for a project to recover its investment expenditures. For example, a set of solar panels may be essentially free to operate from month to month, but the initial cost is high. It may take years or even decades to recover the initial cost.

Step 1

Determine the costs of the project, above what you would otherwise be spending if you hadn't done the project at all during the time of construction. Denote this total with the letter C.

For example, if you installed solar panels, you'd need to add up not only the cost of the panels and the labor of installation but also the cost of additional electricity used above normal monthly levels in order to work the construction equipment to install them.

Step 2

Calculate the difference between your monthly expenditures after completion of the project and what your monthly expenditures would be if you hadn't done the project at all. Denote this monthly difference with the letter D.

Continuing with the above example, suppose the cost of maintaining the solar panels is $0 (though unlikely) and the cost of electricity after installing them is minus-$10 per month because you're selling energy back to the grid. Suppose that you were paying $120 in electrical costs before the project. Therefore, D is $120 - (-$10), or $130. In other words, you're spending $130 less per month because you now have solar panels.

Step 3

Solve the equation n = C/D to determine how many months, n, must pass to "break even." This is the payback period.

Suppose in the above example that C is $10,000. Then n is C/D = $10000/$130 = 76.9 months or 6.4 years.

Step 4

Adjust your results for the "time value of money," or the fact that a dollar in the future has less value than a dollar in the present. Adjusting for the time value of money gives you a more useful result from a business perspective.

Continuing with the above example, suppose an annual cost of money of 2%, which works out to (1.02)^(1/12) - 1 = 0.00165. This is the monthly depreciation rate of money. The formula that you therefore want to solve is C = D [1 - 1/(1+i)^n]/i, where i is 0.00165 and n is the unknown number of months. (Here, the caret ^ indicates exponentiation.) If you use a financial calculator enter C as present value PV, D as monthly payment PMT, i as the periodic rate and then compute n. The same result can be found by using logarithms. For this example, n is 84.8 months, or 7.1 years, somewhat longer than the initial estimate.

references