Understanding Payback Periods

The payback period is the length of time between an initial investment and the recovery of the investment from its annual cash flow. Suppose, for example, that you purchase a store for $500,000. Taking into account the income from the store, your expenses and depreciation, and your taxes, it takes you 48 months to earn back the $500,000. The payback period for your investment is 48 months.

Figures 12.1 and 12.2 show the full cash flow statement from the case study presented in the previous chapter, including the discounting, payback, and other numbers you'll learn about in this chapter.

Figure 12.1. The cash flow statement's benefits and costs summarize the relevant business case inputs.
Figure 12.2. The cash flow ...

Get Business Analysis with Microsoft® Excel, Second Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.