Calculating interest income is a simple percentage calculation. Suppose you need
$2000/month of income, and you expect to make 5%/yr on your money. The capital
you would need is:
=(2000*12)/.05
If you want to spend both the interest and principal, you would calculate the
present value required, as in:
=PV(5%/12,#months required,2000)