The Gordon growth model, also known as the dividend discount model, is often applied in Microsoft Excel to determine the intrinsic value of a stock.

As with the present value of an annuity, you can calculate the future value of an annuity by turning to an online calculator, formula, spreadsheet or annuity table. You’ll need this information: ...

Everything you need to know to calculate an interest rate with the present value formula.