-2
$\begingroup$

Consider you have $\$104107.4099$ in the bank with a $.33\%$ monthly effective interest rate. You plan to withdraw a fixed amount X every month for 40 years, such that you make 480 withdrawals in total, without making any deposits.

I need to find X such that there will be $\$0$ in the bank after the last withdrawal.

My (tentative) work:

So after the first month we have $(104107.4099-X)(1+.0033)=Y_1$. After the second month we have $(Y_1-X)(1+.0033)=Y_2$. After the third month we have $(Y_2-X)(1+.0033) = Y_3$, and so on until we get to the last withdrawal $(Y_{479}-X)$.

I was thinking of using the future cash flows formula in some way:

$P(480)=104107.4099-X\sum_{k=1}^{479}(1+.0033)^k=0$. But I know this does not work because we would only have interest on X.

Or

$P(480)=(104107.4099-X)\sum_{k=1}^{479}(1+.0033)^k$ but them solving for this gives you that $X=104107.4099$.

I am finding this problem very difficult, any help would be appreciated. Thank you.

$\endgroup$

closed as off-topic by LocalVolatility, Alex C, Helin, Raskolnikov, Bob Jansen Jan 29 '18 at 9:00

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "Basic financial questions are off-topic as they are assumed to be common knowledge for those studying or working in the field of quantitative finance." – LocalVolatility, Alex C, Helin, Raskolnikov, Bob Jansen
If this question can be reworded to fit the rules in the help center, please edit the question.

  • 1
    $\begingroup$ I am voting to close this question for being too basic as per quant.stackexchange.com/help/on-topic. This topic is covered in the early chapters of most introductory textbooks such as Hull's "Options, Futures and Other Derivatives" or Sundaresan's "Fixed Income Markets and Their Derivatives". $\endgroup$ – LocalVolatility Jan 28 '18 at 1:38
3
$\begingroup$

This is a annuity calculation.

Present Value of Annuity $= \text{Payment} \cdot \frac{1-(1+r)^{-n}}{r}$

Therefore:

Payment = Present Value of Annuity $\cdot \frac{r}{1-(1+r)^{-n}}$

Present Value of Annuity $= \$\,104,107.4099\,;\,\,\, r = 0.33\,\%;\,\,\, n = 480$

Monthly Payment $ = \$\, 432.5186$

$\endgroup$

Not the answer you're looking for? Browse other questions tagged or ask your own question.