Finance Basics 12 - Perpetuity Calculation in Excel

Опубликовано: 14 Январь 2025
на канале: TeachExcel

79,089

183

Visit http://www.TeachExcel.com for more, including Excel Consulting, Macros, and Tutorials.

This Excel Video Tutorial shows you how to calculate a perpetuity in Microsoft Excel. You will learn the mathematical formula for calculating a perpetuity as well as how to calculate a perpetuity using the PV() or present value function in Excel.

This is a must see tutorial for people studying finance or those who need to understand perpetuity payments. Basically, a perpetuity is just a series of payments that is never ending or that goes out for a very long time into the future - such as a series of payments for the rest of a person's life.

For Excel consulting, classes, or to get the spreadsheet or macro used here visit the website http://www.TeachExcel.com There, you can also get more free Excel video tutorials, macros, tips, and a forum for Excel.

Have a great day!