How to return the interest rate per period of an annuity using formulas
This Mhelp clip will show you how to use the RATE formula in Excel. This is useful if you want to calculate an annuity.
This Mhelp clip has twenty-five steps.
1 - Click cell A3.
2 - Enter the total number of payments.
3- Click cell B3.
4 - Enter the fixed payment per period.
5 - Click cell C3.
6 - Enter the present value.
7 - Click cell D3.
8 - Enter the future value.
9 - Click the cell where you want to display the answer.
10- Click the Formulas tab.
11 - Click Financial. A menu will appear.
12 - Click RATE. A dialog box will appear.
13 - Click the Nper button.
14 - Click cell A3.
15 - Click the formula button.
16 - Click the Pmt button.
17 - Click cell B3.
18 - Click the formula button.
19 - Click the Pv button.
20 - Click cell C3.
21- Click the formula button.
22 - Click the Fv button.
23- Click cell D3.
24 - Click the formula button.
25 - Click OK. The answer will be displayed in the cell selected.
1 - Click cell A3.
2 - Enter the total number of payments.
3- Click cell B3.
4 - Enter the fixed payment per period.
5 - Click cell C3.
6 - Enter the present value.
7 - Click cell D3.
8 - Enter the future value.
9 - Click the cell where you want to display the answer.
10- Click the Formulas tab.
11 - Click Financial. A menu will appear.
12 - Click RATE. A dialog box will appear.
13 - Click the Nper button.
14 - Click cell A3.
15 - Click the formula button.
16 - Click the Pmt button.
17 - Click cell B3.
18 - Click the formula button.
19 - Click the Pv button.
20 - Click cell C3.
21- Click the formula button.
22 - Click the Fv button.
23- Click cell D3.
24 - Click the formula button.
25 - Click OK. The answer will be displayed in the cell selected.
This concludes the Mhelp clip.