Calculates the present value of an annuity investment based on constant-amount periodic payments and a constant interest rate.

How To Use in Sheets

PV(rate, number_of_periods, payment_amount, [future_value], [end_or_beginning])

External Links

Google Sheets Finance Functions, Future Value & Present Value Explained,(FV, PV) Tutorial - Part 1

Learn how to use future value & presnet value financial functions in Google Sheets. This tutorial will explain step by step how to use FV & PV functions and what exactly you get when using different options of these functions.

0Better Sheets Tutorials

No videos yet. Stay tuned!