income protection calculation table

  • Thread starter Thread starter aiden
  • Start date Start date
A

aiden

i want to make an income protection calculation table using excel. i
want to calculate the captial required providing $10 per month for a
specific period utilizing capital and interest. which function shall i
use and how?

marco
 
Hi Marco!

Try:

=PV(6%/12,20*12,10,0,0)

Assumes
APR12 of 6% (6%/12 per month effective)
Withdrawal period of 20 years (20*12 months)
Drawings of $10 per period
End balance of 0
Withdrawals start one period from commencement.
 
Back
Top