O'Reilly logo

Business Analysis with Microsoft® Excel, Second Edition by Conrad Carlberg

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required