Calum already answered this really.
In the example the payments are £100 on the first day of each month for 3 years. The first payment is on 01/01/05 and the last is on 01/12/07. The annuity in advance calc gives us the present value at 01/01/05 and then we can simply discount by V to get the present value at 01/01/04.
If we use a formula for an annuity in arrears (whether monthly or annual) your calculation start point on the timeline is 01/12/04. So for example using the annual arrears formula 1200 A_3(12 monthly) at 8% = [1200 * ((1-v^3) / i12] = [1200 * ((1-0.793832241) / 0.077208361)] = 3204.33 = the present value on 01/12/04. We have to multiply this by V^(11/12) to get the correct value of £2986 on 01/01/04.
Whether you use the arrears or advance formula you still have to calculate the pthly rate, so there's no speed advantage between the two in that regard. The advance method is quicker because you discount by v to get back to 01/01/04 and not some fraction of V.
Last edited by a moderator: Jul 28, 2012