How To Calculate

Learn how to calculate anything
Menu
  • bmi
Home
Cost
How to Calculate Payback Period in Excel.
Cost

How to Calculate Payback Period in Excel.

Rosemary Njeri

The payback period refers to the amount of time it takes to recover the cost of an investment or simply the length of time an investment reaches a break-even point.

Formula to calculate payback period.

The formula used to calculate the payback period is:

 Payback Period in Excel.

This formula is used where you have a constant cash inflow.

Example:

Suppose the initial investment amount of a project is $60,000, Calculate the payback period if the cash inflows is $ 20,000 per year for 5 years.

We begin by transferring the data to an excel spreadsheet.

 Payback Period in Excel.

Then divide B1 by 20,000 to get the payback period.

 Payback Period in Excel.

Therefore, your payback period is 3 years.

Share
Tweet
Reddit
Pinterest
Email
Prev Article
Next Article

Related Articles

How to Calculate Goodwill.
Before we get into discussing how to calculate goodwill, let …

How to Calculate Goodwill.

How to Calculate Commission.
Commission is a form of an incentive pay made to …

How to Calculate Commission.

Popular Posts

    Categories

    learntocalculate.com is a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for sites to earn advertising fees by advertising and linking to amazon.com.

    How To Calculate

    Learn how to calculate anything

    Pages

    • About Us
    • Contact Us
    • Privacy Policy
    Copyright © 2025 How To Calculate

    Ad Blocker Detected

    Our website is made possible by displaying online advertisements to our visitors. Please consider supporting us by disabling your ad blocker.

    Refresh