Question: Ive seen this formula : NET Rate for graduated annuity = (1+i)/(1+g)-1 used in the place of the rate when using the PV function but

 Ive seen this formula : NET Rate for graduated annuity =

Ive seen this formula : NET Rate for graduated annuity = (1+i)/(1+g)-1 used in the place of the rate when using the PV function but it doesnt give me the same values. Do you know why that happens and How can I solve in Excel so that it gives me the same value

HINT: While you could easily solve this on a spreadsheet, you may instead choose to use the formula below for the present value (V) of an initial end-of-year annuity payout of $C (growing at g%) per period, with an interest rate of 1%, for T periods 1+r

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!