Payback Period in Excel Using Formulas
How to calculate the payback period of an investment project in Excel using formulas
Video tutorial file: https://yadi.sk/i/dtS-4iOJy9BqaA
Download the free PowerFin add-in with these formulas: https://xn----btbktgundek1hji.xn--p1ai/subex-finance.html
Download the PowerQuick add-in to speed up your work in Excel: https://xn----btbktgundek1hji.xn--p1ai/download.html
Join the VK group:
#paybackperiod #powerfinadd-in #powerquickadd-in
Timecodes:
0:10 What is the payback period of an investment?
1:04 A simple formula for calculating the payback period using the COUNTIF function
1:55 An alternative formula for calculating the payback period Payback
===================================================
The location of the commands in this video in new versions of the PowerQuick add-in can be found in the add-in menu "Settings and Tools" - "Command Help"