Discounted Payback Period Excel Model
Originally published: 17/05/2019 14:35
Publication number: ELQ-41668-1
View all versions & Certificate

Discounted Payback Period Excel Model

A simple tool to calculate the Discounted PayBack Period when making a capital investment.

This tool calculates the payback period for making an investment and taking into account expected future cash flows. Basic information required is the discount factor, upfront capital investment and then yearly cash inflows. You have space to capture 10 periods of cash flows. As soon as the sum of net present value cash flows become positive it will calculate the payback period in years.

About the Author

Arno is a Senior Finance professional with more than 15 years experience in Financial Management and Accounting in various roles as CFO, Finance Manager and Finance Business Partner having work in South Africa and Australia.

He is a Chartered Accountant, Certified Financial Modeling and Valuation Analyst and holds a Diploma in Advanced Business Management. Key competencies include Business metrics, Reporting, Business Intelligence, Dashboards, Financial Analysis, Cash Flow, Profitability, Systems, Processes & Automation, Strategy, Planning, Forecasting, Financial Modelling & Troubleshooting

He is passionate about Finance creating value to help drive Business performance and has posted more than 150 articles on LinkedIn and on his blog at

His tools, templates and reading material are practical, easy to understand and are aligned to the Value Creation Framework of creating value through Intelligence, Improvements and Insights.

Arno mentors Accountants from time to time and is generous with sharing his knowledge with like minded professionals.

This Best Practice includes
1 Excel Tool

Arno Wakfer offers you this Best Practice for free!

download for free

Add to bookmarks


Further information

Calculate discounted payback period of a capital investment


  • Be the first to review this Downloadable Best Practice

    Write a review


More Best Practices from Arno Wakfer

See all

Any questions on Discounted Payback Period Excel Model?

The user community and author are here to help. Go ahead!

0.0 / 5 (0 votes)

please wait...