Present value of annuity calculation

This worked for me using your initial example:

$PMT$ * (1-(1/((1+$r$)^$n$)))/$r$

Where PMT, r, and n were all defined from an input table. To make it a bit more readable using your second inputs:

$Proposed EMI$ * (1-(1/((1+0.015)^12)))/0.015

2 Likes