income protection calculation table

[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

 

[Norman Harker]

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.