0
$\begingroup$

I want to calculate how much I would pay monthly.

$X$ = Amount borrowed. $I$= Interest Rate. $Y$ = number of years

This is what I have so far, but it's wrong; I'm getting a larger value.

$\frac{X\left(1 + \frac{I}{100}\right)^{Y}\left(\frac{I}{Y}\right)}{12\left(\left(1 + \frac{I}{100}\right)^Y - 1\right)}.$

  • 0
    Actually, Ross edited the tags.2011-03-17

2 Answers 2

0

Well, we know the amount borrowed, the interest (I'm going to assume it is the effective rate per year), and the amount of time we have to pay it off. Simplifying some things first off, we must be able to find the effective rate of interest per month, $i$, which can be gleaned from the equation

$(1+i)^{12} = 1+I$

Now, in the language of annuities, we are trying to solve an equation for the present value of $X$, which is given by

$X = Pa_{\overline{12Y}|i}$

where $a_{\overline{12Y}|i} = \left[\frac{1-\left(1+i\right)^{-12Y}}{i}\right]$

Now, it is quite simple to solve for the amount of each payment, $P$.

2

The present value is $X$. The future value is $0$. We know $I/Y$. So you can compute the payment (which would be negative assuming that positive amounts imply money is coming to you and negative amounts mean that you are paying money). In particular, suppose $a_{\overline{12Y}|i^{(12)}} = \frac{1-v^{12y}}{i^{(12)}}$ where $v = \frac{1}{1+i^{(12)}}$ and $i^{(12)}$ is the monthly effective interest rate. So $1+i = \left(1+i^{(12)} \right)^{12}$ Then the level monthly payment would be $P = \frac{X}{a_{\overline{12Y}|i^{(12)}}}$

You can do this easily on a BA-II-PLUS calculator as well.

  • 0
    Shouldn't $i$ be the effective rate of interest per payment period (month)?2011-03-17