Steps Regarding Annuity Calculator In Excel Listed

Asked By Menges trv 10 points N/A Posted on - 06/21/2017

I want to know how to calculate present value of a annuity in Excel. Can anyone of you help me with annuity calculator in Excel? Guys please help help and tell me the formula how to do it.

• Status: Open
• Question Views: 284
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS Excel
• Question Tags: annuity calculator | Excel

Answered By rhian goldsmith 0 points N/A #299795

Steps Regarding Annuity Calculator In Excel Listed

In order to compute a fixed annuity’s present value in Excel, you need to follow the given steps-

1. Enter the value of interest rate in A1
2. Enter no. of periods in A2
3. Then enter payment amount in the cell A3
4. Enter the formula =PV(A1,A2,A3) in cell B1

This will give you the desired value.

About rhian goldsmith

Questions
8

Answers
2

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 06/21/2017
• Question Category: MS Excel