Calculating monthly loan repayments












1












$begingroup$


Apologies if this is a too trivial question but I'm teaching myself and can't get my answer to match the one in my text book.



The task is to calculate the monthly repayments of a £500 loan to be repaid in two years. Interest on the remaining debt is calculated monthly and charged at 11% p.a. First repayment a month after loan given.



Here's my attempt:
First I figured the monthly interest charge, M, as
$$M = 1.11^frac {1}{12}$$
After the first month, if a repayment of $chi$ is made the remaining debt would be
$$ 500M - chi $$
After two months
$$ (500M - chi)M - chi = $$



$$500M^2 - chi M - chi $$
After n months
$$ 500M^n - chi M^{n-1} - chi M^{n-2} ... chi M^1 - chi$$
Or
$$ 500M^n - frac{chi (M^n - 1)}{M - 1} $$



I reckon this should equal zero after 24 repayments so, rearranging
$$ chi = frac{500M^{24} (M - 1)}{M^{24} - 1} $$
which comes to £23.18 but the answer given is £23.31. I've tried different numbers of charges/payments and the nearest I got was
$$ chi = frac{500M^{25} (M - 1)}{M^{24} - 1} $$
equalling £23.38
Can anyone see where I'm going wrong? I guess it could be a typographical error but it'd be the only one I've spotted (so far.)
Here's the question exactly as stated in case I'm missing something there



A bank loan of £500 is arranged to be repaid in two years by equal monthly instalments. Interest, calculated monthly, is charged at 11% p.a. on the remaining debt. Calculate the monthly repayment if the first repayment is to be made one month after the loan is granted.










share|cite|improve this question











$endgroup$












  • $begingroup$
    Welcome to Math.SE! Please use MathJax. For some basic information about writing math at this site see e.g. basic help on mathjax notation, mathjax tutorial and quick reference, main meta site math tutorial and equation editing how-to.
    $endgroup$
    – GNUSupporter 8964民主女神 地下教會
    Dec 12 '18 at 17:08










  • $begingroup$
    I´ve got $£23.30$. Why do you think you´re wrong?
    $endgroup$
    – callculus
    Dec 12 '18 at 19:15










  • $begingroup$
    @callculus Yeah, bang on. Er, how you get that exactly? Sorry, maybe I'm making some simple mistake that I can't see. The above is correct, is it?
    $endgroup$
    – Andy Offgrid
    Dec 12 '18 at 20:30










  • $begingroup$
    @callculus I think I'm wrong because... well, because my result doesn't match the one in the text book. But yours does. Please, share how you managed to get it.
    $endgroup$
    – Andy Offgrid
    Dec 13 '18 at 14:09
















1












$begingroup$


Apologies if this is a too trivial question but I'm teaching myself and can't get my answer to match the one in my text book.



The task is to calculate the monthly repayments of a £500 loan to be repaid in two years. Interest on the remaining debt is calculated monthly and charged at 11% p.a. First repayment a month after loan given.



Here's my attempt:
First I figured the monthly interest charge, M, as
$$M = 1.11^frac {1}{12}$$
After the first month, if a repayment of $chi$ is made the remaining debt would be
$$ 500M - chi $$
After two months
$$ (500M - chi)M - chi = $$



$$500M^2 - chi M - chi $$
After n months
$$ 500M^n - chi M^{n-1} - chi M^{n-2} ... chi M^1 - chi$$
Or
$$ 500M^n - frac{chi (M^n - 1)}{M - 1} $$



I reckon this should equal zero after 24 repayments so, rearranging
$$ chi = frac{500M^{24} (M - 1)}{M^{24} - 1} $$
which comes to £23.18 but the answer given is £23.31. I've tried different numbers of charges/payments and the nearest I got was
$$ chi = frac{500M^{25} (M - 1)}{M^{24} - 1} $$
equalling £23.38
Can anyone see where I'm going wrong? I guess it could be a typographical error but it'd be the only one I've spotted (so far.)
Here's the question exactly as stated in case I'm missing something there



A bank loan of £500 is arranged to be repaid in two years by equal monthly instalments. Interest, calculated monthly, is charged at 11% p.a. on the remaining debt. Calculate the monthly repayment if the first repayment is to be made one month after the loan is granted.










share|cite|improve this question











$endgroup$












  • $begingroup$
    Welcome to Math.SE! Please use MathJax. For some basic information about writing math at this site see e.g. basic help on mathjax notation, mathjax tutorial and quick reference, main meta site math tutorial and equation editing how-to.
    $endgroup$
    – GNUSupporter 8964民主女神 地下教會
    Dec 12 '18 at 17:08










  • $begingroup$
    I´ve got $£23.30$. Why do you think you´re wrong?
    $endgroup$
    – callculus
    Dec 12 '18 at 19:15










  • $begingroup$
    @callculus Yeah, bang on. Er, how you get that exactly? Sorry, maybe I'm making some simple mistake that I can't see. The above is correct, is it?
    $endgroup$
    – Andy Offgrid
    Dec 12 '18 at 20:30










  • $begingroup$
    @callculus I think I'm wrong because... well, because my result doesn't match the one in the text book. But yours does. Please, share how you managed to get it.
    $endgroup$
    – Andy Offgrid
    Dec 13 '18 at 14:09














1












1








1





$begingroup$


Apologies if this is a too trivial question but I'm teaching myself and can't get my answer to match the one in my text book.



The task is to calculate the monthly repayments of a £500 loan to be repaid in two years. Interest on the remaining debt is calculated monthly and charged at 11% p.a. First repayment a month after loan given.



Here's my attempt:
First I figured the monthly interest charge, M, as
$$M = 1.11^frac {1}{12}$$
After the first month, if a repayment of $chi$ is made the remaining debt would be
$$ 500M - chi $$
After two months
$$ (500M - chi)M - chi = $$



$$500M^2 - chi M - chi $$
After n months
$$ 500M^n - chi M^{n-1} - chi M^{n-2} ... chi M^1 - chi$$
Or
$$ 500M^n - frac{chi (M^n - 1)}{M - 1} $$



I reckon this should equal zero after 24 repayments so, rearranging
$$ chi = frac{500M^{24} (M - 1)}{M^{24} - 1} $$
which comes to £23.18 but the answer given is £23.31. I've tried different numbers of charges/payments and the nearest I got was
$$ chi = frac{500M^{25} (M - 1)}{M^{24} - 1} $$
equalling £23.38
Can anyone see where I'm going wrong? I guess it could be a typographical error but it'd be the only one I've spotted (so far.)
Here's the question exactly as stated in case I'm missing something there



A bank loan of £500 is arranged to be repaid in two years by equal monthly instalments. Interest, calculated monthly, is charged at 11% p.a. on the remaining debt. Calculate the monthly repayment if the first repayment is to be made one month after the loan is granted.










share|cite|improve this question











$endgroup$




Apologies if this is a too trivial question but I'm teaching myself and can't get my answer to match the one in my text book.



The task is to calculate the monthly repayments of a £500 loan to be repaid in two years. Interest on the remaining debt is calculated monthly and charged at 11% p.a. First repayment a month after loan given.



Here's my attempt:
First I figured the monthly interest charge, M, as
$$M = 1.11^frac {1}{12}$$
After the first month, if a repayment of $chi$ is made the remaining debt would be
$$ 500M - chi $$
After two months
$$ (500M - chi)M - chi = $$



$$500M^2 - chi M - chi $$
After n months
$$ 500M^n - chi M^{n-1} - chi M^{n-2} ... chi M^1 - chi$$
Or
$$ 500M^n - frac{chi (M^n - 1)}{M - 1} $$



I reckon this should equal zero after 24 repayments so, rearranging
$$ chi = frac{500M^{24} (M - 1)}{M^{24} - 1} $$
which comes to £23.18 but the answer given is £23.31. I've tried different numbers of charges/payments and the nearest I got was
$$ chi = frac{500M^{25} (M - 1)}{M^{24} - 1} $$
equalling £23.38
Can anyone see where I'm going wrong? I guess it could be a typographical error but it'd be the only one I've spotted (so far.)
Here's the question exactly as stated in case I'm missing something there



A bank loan of £500 is arranged to be repaid in two years by equal monthly instalments. Interest, calculated monthly, is charged at 11% p.a. on the remaining debt. Calculate the monthly repayment if the first repayment is to be made one month after the loan is granted.







sequences-and-series finance






share|cite|improve this question















share|cite|improve this question













share|cite|improve this question




share|cite|improve this question








edited Dec 13 '18 at 17:26









callculus

18.2k31427




18.2k31427










asked Dec 12 '18 at 17:05









Andy OffgridAndy Offgrid

83




83












  • $begingroup$
    Welcome to Math.SE! Please use MathJax. For some basic information about writing math at this site see e.g. basic help on mathjax notation, mathjax tutorial and quick reference, main meta site math tutorial and equation editing how-to.
    $endgroup$
    – GNUSupporter 8964民主女神 地下教會
    Dec 12 '18 at 17:08










  • $begingroup$
    I´ve got $£23.30$. Why do you think you´re wrong?
    $endgroup$
    – callculus
    Dec 12 '18 at 19:15










  • $begingroup$
    @callculus Yeah, bang on. Er, how you get that exactly? Sorry, maybe I'm making some simple mistake that I can't see. The above is correct, is it?
    $endgroup$
    – Andy Offgrid
    Dec 12 '18 at 20:30










  • $begingroup$
    @callculus I think I'm wrong because... well, because my result doesn't match the one in the text book. But yours does. Please, share how you managed to get it.
    $endgroup$
    – Andy Offgrid
    Dec 13 '18 at 14:09


















  • $begingroup$
    Welcome to Math.SE! Please use MathJax. For some basic information about writing math at this site see e.g. basic help on mathjax notation, mathjax tutorial and quick reference, main meta site math tutorial and equation editing how-to.
    $endgroup$
    – GNUSupporter 8964民主女神 地下教會
    Dec 12 '18 at 17:08










  • $begingroup$
    I´ve got $£23.30$. Why do you think you´re wrong?
    $endgroup$
    – callculus
    Dec 12 '18 at 19:15










  • $begingroup$
    @callculus Yeah, bang on. Er, how you get that exactly? Sorry, maybe I'm making some simple mistake that I can't see. The above is correct, is it?
    $endgroup$
    – Andy Offgrid
    Dec 12 '18 at 20:30










  • $begingroup$
    @callculus I think I'm wrong because... well, because my result doesn't match the one in the text book. But yours does. Please, share how you managed to get it.
    $endgroup$
    – Andy Offgrid
    Dec 13 '18 at 14:09
















$begingroup$
Welcome to Math.SE! Please use MathJax. For some basic information about writing math at this site see e.g. basic help on mathjax notation, mathjax tutorial and quick reference, main meta site math tutorial and equation editing how-to.
$endgroup$
– GNUSupporter 8964民主女神 地下教會
Dec 12 '18 at 17:08




$begingroup$
Welcome to Math.SE! Please use MathJax. For some basic information about writing math at this site see e.g. basic help on mathjax notation, mathjax tutorial and quick reference, main meta site math tutorial and equation editing how-to.
$endgroup$
– GNUSupporter 8964民主女神 地下教會
Dec 12 '18 at 17:08












$begingroup$
I´ve got $£23.30$. Why do you think you´re wrong?
$endgroup$
– callculus
Dec 12 '18 at 19:15




$begingroup$
I´ve got $£23.30$. Why do you think you´re wrong?
$endgroup$
– callculus
Dec 12 '18 at 19:15












$begingroup$
@callculus Yeah, bang on. Er, how you get that exactly? Sorry, maybe I'm making some simple mistake that I can't see. The above is correct, is it?
$endgroup$
– Andy Offgrid
Dec 12 '18 at 20:30




$begingroup$
@callculus Yeah, bang on. Er, how you get that exactly? Sorry, maybe I'm making some simple mistake that I can't see. The above is correct, is it?
$endgroup$
– Andy Offgrid
Dec 12 '18 at 20:30












$begingroup$
@callculus I think I'm wrong because... well, because my result doesn't match the one in the text book. But yours does. Please, share how you managed to get it.
$endgroup$
– Andy Offgrid
Dec 13 '18 at 14:09




$begingroup$
@callculus I think I'm wrong because... well, because my result doesn't match the one in the text book. But yours does. Please, share how you managed to get it.
$endgroup$
– Andy Offgrid
Dec 13 '18 at 14:09










2 Answers
2






active

oldest

votes


















0












$begingroup$

If the interest is payed m times a year then you usually use the period interest rate $i_m=frac{i}{m}$. With $m=12$ and $i=0.11$ we get $i_{12}=frac{0.11}{12}$ Therefore the equation is



$$500cdot left(1+frac{0.11}{12} right)^{24}=xcdot frac{left(1+frac{0.11}{12} right)^{24}-1}{frac{0.11}{12} }$$



$$x=500cdot left(1+frac{0.11}{12} right)^{24}cdot frac{0.11}{12cdot left(left(1+frac{0.11}{12} right)^{24}-1right)}=23.30391approx 23.30$$






share|cite|improve this answer









$endgroup$













  • $begingroup$
    Ah, got it! Thanks for explaining that, I was going spare trying to see the mistake. I thought "12th root of 1.11 multiplied 12 times works out to 11% p.a". but I get how things are calculated now. More expensively. Well, that's usury.
    $endgroup$
    – Andy Offgrid
    Dec 13 '18 at 22:02





















0












$begingroup$

Let's look at this in general. We need to pay someone $x$ money units over $n$ payments with an interest rate of $r>1$ after each payment. We want to pay an equal amount, say $y$ money units, every payment. Let $x_i$ denote the amount of money we need to pay after $i$ payments. Then we find



$$
x_0=x
\x_1=r(x_0-y)=rx-ry
\x_2=r(x_1-y)=r^2x-(r^2+r)y
\...
\x_i=r^ix-(r^i+r^{i-1}+...+r)y.
$$



This gets quite messy. However, there is a formula for $r^i+r^{i-1}+...+r$. To derive this, let's say that $S=r^i+r^{i-1}+...+r$. Then $rS=r^{i+1}+r^i+r^{i-1}+...+r^2$, so $rS+r=r^{i+1}+S$. Hence $r-r^{i+1}=S-rS=(1-r)S$, so we find $S=frac{r-r^{i+1}}{1-r}$. Plugging this into $x_i$ we find



$$x_i=r^ix-frac{r-r^{i+1}}{1-r}y.$$



We want to be done with paying after $n$ payments, so we need to find $y$ such that $x_n=0$. So we finally just need to do some algebra.



$$
0=x_n=r^nx-frac{r-r^{n+1}}{1-r}y
\r^nx=frac{r-r^{n+1}}{1-r}y
\y=frac{1-r}{r-r^{n+1}}r^nx.
$$



In your case $x=500$ and $n=24$ and $r=1.11^{frac1{12}}$, so you can just plug it into the formula.






share|cite|improve this answer









$endgroup$













  • $begingroup$
    Thanks for your very complete and prompt answer. Too prompt in fact - I should have made it clearer that I'd only posted to see how the MathJax was being formatted as I can't seem to get a preview on my phone. Anyway, as you can see (now that I've finished grappling the MathJax and finished my post) I had made a mistake but even using your formula the result doesn't agree with the text book. Perhaps I'm reading the question wrong? It's copied it in full at the bottom of my post. Despite Occam's razor I'd like too exhaust all avenues before concluding it's a typo.
    $endgroup$
    – Andy Offgrid
    Dec 12 '18 at 20:01











Your Answer





StackExchange.ifUsing("editor", function () {
return StackExchange.using("mathjaxEditing", function () {
StackExchange.MarkdownEditor.creationCallbacks.add(function (editor, postfix) {
StackExchange.mathjaxEditing.prepareWmdForMathJax(editor, postfix, [["$", "$"], ["\\(","\\)"]]);
});
});
}, "mathjax-editing");

StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "69"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});

function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
noCode: true, onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});


}
});














draft saved

draft discarded


















StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmath.stackexchange.com%2fquestions%2f3036952%2fcalculating-monthly-loan-repayments%23new-answer', 'question_page');
}
);

Post as a guest















Required, but never shown

























2 Answers
2






active

oldest

votes








2 Answers
2






active

oldest

votes









active

oldest

votes






active

oldest

votes









0












$begingroup$

If the interest is payed m times a year then you usually use the period interest rate $i_m=frac{i}{m}$. With $m=12$ and $i=0.11$ we get $i_{12}=frac{0.11}{12}$ Therefore the equation is



$$500cdot left(1+frac{0.11}{12} right)^{24}=xcdot frac{left(1+frac{0.11}{12} right)^{24}-1}{frac{0.11}{12} }$$



$$x=500cdot left(1+frac{0.11}{12} right)^{24}cdot frac{0.11}{12cdot left(left(1+frac{0.11}{12} right)^{24}-1right)}=23.30391approx 23.30$$






share|cite|improve this answer









$endgroup$













  • $begingroup$
    Ah, got it! Thanks for explaining that, I was going spare trying to see the mistake. I thought "12th root of 1.11 multiplied 12 times works out to 11% p.a". but I get how things are calculated now. More expensively. Well, that's usury.
    $endgroup$
    – Andy Offgrid
    Dec 13 '18 at 22:02


















0












$begingroup$

If the interest is payed m times a year then you usually use the period interest rate $i_m=frac{i}{m}$. With $m=12$ and $i=0.11$ we get $i_{12}=frac{0.11}{12}$ Therefore the equation is



$$500cdot left(1+frac{0.11}{12} right)^{24}=xcdot frac{left(1+frac{0.11}{12} right)^{24}-1}{frac{0.11}{12} }$$



$$x=500cdot left(1+frac{0.11}{12} right)^{24}cdot frac{0.11}{12cdot left(left(1+frac{0.11}{12} right)^{24}-1right)}=23.30391approx 23.30$$






share|cite|improve this answer









$endgroup$













  • $begingroup$
    Ah, got it! Thanks for explaining that, I was going spare trying to see the mistake. I thought "12th root of 1.11 multiplied 12 times works out to 11% p.a". but I get how things are calculated now. More expensively. Well, that's usury.
    $endgroup$
    – Andy Offgrid
    Dec 13 '18 at 22:02
















0












0








0





$begingroup$

If the interest is payed m times a year then you usually use the period interest rate $i_m=frac{i}{m}$. With $m=12$ and $i=0.11$ we get $i_{12}=frac{0.11}{12}$ Therefore the equation is



$$500cdot left(1+frac{0.11}{12} right)^{24}=xcdot frac{left(1+frac{0.11}{12} right)^{24}-1}{frac{0.11}{12} }$$



$$x=500cdot left(1+frac{0.11}{12} right)^{24}cdot frac{0.11}{12cdot left(left(1+frac{0.11}{12} right)^{24}-1right)}=23.30391approx 23.30$$






share|cite|improve this answer









$endgroup$



If the interest is payed m times a year then you usually use the period interest rate $i_m=frac{i}{m}$. With $m=12$ and $i=0.11$ we get $i_{12}=frac{0.11}{12}$ Therefore the equation is



$$500cdot left(1+frac{0.11}{12} right)^{24}=xcdot frac{left(1+frac{0.11}{12} right)^{24}-1}{frac{0.11}{12} }$$



$$x=500cdot left(1+frac{0.11}{12} right)^{24}cdot frac{0.11}{12cdot left(left(1+frac{0.11}{12} right)^{24}-1right)}=23.30391approx 23.30$$







share|cite|improve this answer












share|cite|improve this answer



share|cite|improve this answer










answered Dec 13 '18 at 17:20









callculuscallculus

18.2k31427




18.2k31427












  • $begingroup$
    Ah, got it! Thanks for explaining that, I was going spare trying to see the mistake. I thought "12th root of 1.11 multiplied 12 times works out to 11% p.a". but I get how things are calculated now. More expensively. Well, that's usury.
    $endgroup$
    – Andy Offgrid
    Dec 13 '18 at 22:02




















  • $begingroup$
    Ah, got it! Thanks for explaining that, I was going spare trying to see the mistake. I thought "12th root of 1.11 multiplied 12 times works out to 11% p.a". but I get how things are calculated now. More expensively. Well, that's usury.
    $endgroup$
    – Andy Offgrid
    Dec 13 '18 at 22:02


















$begingroup$
Ah, got it! Thanks for explaining that, I was going spare trying to see the mistake. I thought "12th root of 1.11 multiplied 12 times works out to 11% p.a". but I get how things are calculated now. More expensively. Well, that's usury.
$endgroup$
– Andy Offgrid
Dec 13 '18 at 22:02






$begingroup$
Ah, got it! Thanks for explaining that, I was going spare trying to see the mistake. I thought "12th root of 1.11 multiplied 12 times works out to 11% p.a". but I get how things are calculated now. More expensively. Well, that's usury.
$endgroup$
– Andy Offgrid
Dec 13 '18 at 22:02













0












$begingroup$

Let's look at this in general. We need to pay someone $x$ money units over $n$ payments with an interest rate of $r>1$ after each payment. We want to pay an equal amount, say $y$ money units, every payment. Let $x_i$ denote the amount of money we need to pay after $i$ payments. Then we find



$$
x_0=x
\x_1=r(x_0-y)=rx-ry
\x_2=r(x_1-y)=r^2x-(r^2+r)y
\...
\x_i=r^ix-(r^i+r^{i-1}+...+r)y.
$$



This gets quite messy. However, there is a formula for $r^i+r^{i-1}+...+r$. To derive this, let's say that $S=r^i+r^{i-1}+...+r$. Then $rS=r^{i+1}+r^i+r^{i-1}+...+r^2$, so $rS+r=r^{i+1}+S$. Hence $r-r^{i+1}=S-rS=(1-r)S$, so we find $S=frac{r-r^{i+1}}{1-r}$. Plugging this into $x_i$ we find



$$x_i=r^ix-frac{r-r^{i+1}}{1-r}y.$$



We want to be done with paying after $n$ payments, so we need to find $y$ such that $x_n=0$. So we finally just need to do some algebra.



$$
0=x_n=r^nx-frac{r-r^{n+1}}{1-r}y
\r^nx=frac{r-r^{n+1}}{1-r}y
\y=frac{1-r}{r-r^{n+1}}r^nx.
$$



In your case $x=500$ and $n=24$ and $r=1.11^{frac1{12}}$, so you can just plug it into the formula.






share|cite|improve this answer









$endgroup$













  • $begingroup$
    Thanks for your very complete and prompt answer. Too prompt in fact - I should have made it clearer that I'd only posted to see how the MathJax was being formatted as I can't seem to get a preview on my phone. Anyway, as you can see (now that I've finished grappling the MathJax and finished my post) I had made a mistake but even using your formula the result doesn't agree with the text book. Perhaps I'm reading the question wrong? It's copied it in full at the bottom of my post. Despite Occam's razor I'd like too exhaust all avenues before concluding it's a typo.
    $endgroup$
    – Andy Offgrid
    Dec 12 '18 at 20:01
















0












$begingroup$

Let's look at this in general. We need to pay someone $x$ money units over $n$ payments with an interest rate of $r>1$ after each payment. We want to pay an equal amount, say $y$ money units, every payment. Let $x_i$ denote the amount of money we need to pay after $i$ payments. Then we find



$$
x_0=x
\x_1=r(x_0-y)=rx-ry
\x_2=r(x_1-y)=r^2x-(r^2+r)y
\...
\x_i=r^ix-(r^i+r^{i-1}+...+r)y.
$$



This gets quite messy. However, there is a formula for $r^i+r^{i-1}+...+r$. To derive this, let's say that $S=r^i+r^{i-1}+...+r$. Then $rS=r^{i+1}+r^i+r^{i-1}+...+r^2$, so $rS+r=r^{i+1}+S$. Hence $r-r^{i+1}=S-rS=(1-r)S$, so we find $S=frac{r-r^{i+1}}{1-r}$. Plugging this into $x_i$ we find



$$x_i=r^ix-frac{r-r^{i+1}}{1-r}y.$$



We want to be done with paying after $n$ payments, so we need to find $y$ such that $x_n=0$. So we finally just need to do some algebra.



$$
0=x_n=r^nx-frac{r-r^{n+1}}{1-r}y
\r^nx=frac{r-r^{n+1}}{1-r}y
\y=frac{1-r}{r-r^{n+1}}r^nx.
$$



In your case $x=500$ and $n=24$ and $r=1.11^{frac1{12}}$, so you can just plug it into the formula.






share|cite|improve this answer









$endgroup$













  • $begingroup$
    Thanks for your very complete and prompt answer. Too prompt in fact - I should have made it clearer that I'd only posted to see how the MathJax was being formatted as I can't seem to get a preview on my phone. Anyway, as you can see (now that I've finished grappling the MathJax and finished my post) I had made a mistake but even using your formula the result doesn't agree with the text book. Perhaps I'm reading the question wrong? It's copied it in full at the bottom of my post. Despite Occam's razor I'd like too exhaust all avenues before concluding it's a typo.
    $endgroup$
    – Andy Offgrid
    Dec 12 '18 at 20:01














0












0








0





$begingroup$

Let's look at this in general. We need to pay someone $x$ money units over $n$ payments with an interest rate of $r>1$ after each payment. We want to pay an equal amount, say $y$ money units, every payment. Let $x_i$ denote the amount of money we need to pay after $i$ payments. Then we find



$$
x_0=x
\x_1=r(x_0-y)=rx-ry
\x_2=r(x_1-y)=r^2x-(r^2+r)y
\...
\x_i=r^ix-(r^i+r^{i-1}+...+r)y.
$$



This gets quite messy. However, there is a formula for $r^i+r^{i-1}+...+r$. To derive this, let's say that $S=r^i+r^{i-1}+...+r$. Then $rS=r^{i+1}+r^i+r^{i-1}+...+r^2$, so $rS+r=r^{i+1}+S$. Hence $r-r^{i+1}=S-rS=(1-r)S$, so we find $S=frac{r-r^{i+1}}{1-r}$. Plugging this into $x_i$ we find



$$x_i=r^ix-frac{r-r^{i+1}}{1-r}y.$$



We want to be done with paying after $n$ payments, so we need to find $y$ such that $x_n=0$. So we finally just need to do some algebra.



$$
0=x_n=r^nx-frac{r-r^{n+1}}{1-r}y
\r^nx=frac{r-r^{n+1}}{1-r}y
\y=frac{1-r}{r-r^{n+1}}r^nx.
$$



In your case $x=500$ and $n=24$ and $r=1.11^{frac1{12}}$, so you can just plug it into the formula.






share|cite|improve this answer









$endgroup$



Let's look at this in general. We need to pay someone $x$ money units over $n$ payments with an interest rate of $r>1$ after each payment. We want to pay an equal amount, say $y$ money units, every payment. Let $x_i$ denote the amount of money we need to pay after $i$ payments. Then we find



$$
x_0=x
\x_1=r(x_0-y)=rx-ry
\x_2=r(x_1-y)=r^2x-(r^2+r)y
\...
\x_i=r^ix-(r^i+r^{i-1}+...+r)y.
$$



This gets quite messy. However, there is a formula for $r^i+r^{i-1}+...+r$. To derive this, let's say that $S=r^i+r^{i-1}+...+r$. Then $rS=r^{i+1}+r^i+r^{i-1}+...+r^2$, so $rS+r=r^{i+1}+S$. Hence $r-r^{i+1}=S-rS=(1-r)S$, so we find $S=frac{r-r^{i+1}}{1-r}$. Plugging this into $x_i$ we find



$$x_i=r^ix-frac{r-r^{i+1}}{1-r}y.$$



We want to be done with paying after $n$ payments, so we need to find $y$ such that $x_n=0$. So we finally just need to do some algebra.



$$
0=x_n=r^nx-frac{r-r^{n+1}}{1-r}y
\r^nx=frac{r-r^{n+1}}{1-r}y
\y=frac{1-r}{r-r^{n+1}}r^nx.
$$



In your case $x=500$ and $n=24$ and $r=1.11^{frac1{12}}$, so you can just plug it into the formula.







share|cite|improve this answer












share|cite|improve this answer



share|cite|improve this answer










answered Dec 12 '18 at 17:29









SmileyCraftSmileyCraft

3,611517




3,611517












  • $begingroup$
    Thanks for your very complete and prompt answer. Too prompt in fact - I should have made it clearer that I'd only posted to see how the MathJax was being formatted as I can't seem to get a preview on my phone. Anyway, as you can see (now that I've finished grappling the MathJax and finished my post) I had made a mistake but even using your formula the result doesn't agree with the text book. Perhaps I'm reading the question wrong? It's copied it in full at the bottom of my post. Despite Occam's razor I'd like too exhaust all avenues before concluding it's a typo.
    $endgroup$
    – Andy Offgrid
    Dec 12 '18 at 20:01


















  • $begingroup$
    Thanks for your very complete and prompt answer. Too prompt in fact - I should have made it clearer that I'd only posted to see how the MathJax was being formatted as I can't seem to get a preview on my phone. Anyway, as you can see (now that I've finished grappling the MathJax and finished my post) I had made a mistake but even using your formula the result doesn't agree with the text book. Perhaps I'm reading the question wrong? It's copied it in full at the bottom of my post. Despite Occam's razor I'd like too exhaust all avenues before concluding it's a typo.
    $endgroup$
    – Andy Offgrid
    Dec 12 '18 at 20:01
















$begingroup$
Thanks for your very complete and prompt answer. Too prompt in fact - I should have made it clearer that I'd only posted to see how the MathJax was being formatted as I can't seem to get a preview on my phone. Anyway, as you can see (now that I've finished grappling the MathJax and finished my post) I had made a mistake but even using your formula the result doesn't agree with the text book. Perhaps I'm reading the question wrong? It's copied it in full at the bottom of my post. Despite Occam's razor I'd like too exhaust all avenues before concluding it's a typo.
$endgroup$
– Andy Offgrid
Dec 12 '18 at 20:01




$begingroup$
Thanks for your very complete and prompt answer. Too prompt in fact - I should have made it clearer that I'd only posted to see how the MathJax was being formatted as I can't seem to get a preview on my phone. Anyway, as you can see (now that I've finished grappling the MathJax and finished my post) I had made a mistake but even using your formula the result doesn't agree with the text book. Perhaps I'm reading the question wrong? It's copied it in full at the bottom of my post. Despite Occam's razor I'd like too exhaust all avenues before concluding it's a typo.
$endgroup$
– Andy Offgrid
Dec 12 '18 at 20:01


















draft saved

draft discarded




















































Thanks for contributing an answer to Mathematics Stack Exchange!


  • Please be sure to answer the question. Provide details and share your research!

But avoid



  • Asking for help, clarification, or responding to other answers.

  • Making statements based on opinion; back them up with references or personal experience.


Use MathJax to format equations. MathJax reference.


To learn more, see our tips on writing great answers.




draft saved


draft discarded














StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmath.stackexchange.com%2fquestions%2f3036952%2fcalculating-monthly-loan-repayments%23new-answer', 'question_page');
}
);

Post as a guest















Required, but never shown





















































Required, but never shown














Required, but never shown












Required, but never shown







Required, but never shown

































Required, but never shown














Required, but never shown












Required, but never shown







Required, but never shown







Popular posts from this blog

Bundesstraße 106

Le Mesnil-Réaume

Ida-Boy-Ed-Garten