J
jtuckerjr
Hello all,
I am building an Excel spreadsheet that deatils our annuit
obligations.
I need to build a formula that calculates our liability at a certai
date based on the present value of an annuity that begins payments at
date in the future.
For example:
Client gives us $2000 in a deferred annuity. Interest rate is 4.2%.
Payments of $25.50 each quarter beginning 3/29/2036 for 16 quarters.
What is the present value as of 6/30/2004?
I have tried to use the PV function but cannot get a sum that agree
with my other calculator.
Any help is greatly appreciated. Thank you!
Ji
I am building an Excel spreadsheet that deatils our annuit
obligations.
I need to build a formula that calculates our liability at a certai
date based on the present value of an annuity that begins payments at
date in the future.
For example:
Client gives us $2000 in a deferred annuity. Interest rate is 4.2%.
Payments of $25.50 each quarter beginning 3/29/2036 for 16 quarters.
What is the present value as of 6/30/2004?
I have tried to use the PV function but cannot get a sum that agree
with my other calculator.
Any help is greatly appreciated. Thank you!
Ji