Filetype Excel XLSX | Posted on 18 Aug 2022 | 3 years ago
Authentication
digital resources
206x Filetype XLSX File size 0.07 MB Source: www.ablebits.com
Sheet 1: Present value - examples
| Calculate Present Value in Excel | ||||||
| The workbook shows how to use a PV formula to calculate the present value of annuity in Excel. | ||||||
| Author | Ablebits.com | |||||
| Last update | 8-Dec-20 | |||||
| Tutorial URL | How to calculate present value in Excel | |||||
| Examples: | ||||||
| • | PV formula for a single payment | |||||
| • | PV formula for a series of payments | |||||
| • | PV formula for different annuity types | |||||
| • | Present value calculator | |||||
| Description | Value |
| Annual interest rate | 10% |
| No. of years | 1 |
| Future value | $11,000 |
| Compounding periods per year | 12 |
| Present value | -$9,957.34 |
| Description | Value |
| Annual interest rate | 10% |
| No. of years | 3 |
| Periodic payment | -$100 |
| Periods per year | 12 |
| Present value | $3,099.12 |
no reviews yet
Please Login to review.
