Calculating monthly loan repayments
$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.
sequences-and-series finance
$endgroup$
add a comment |
$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.
sequences-and-series finance
$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
add a comment |
$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.
sequences-and-series finance
$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
sequences-and-series finance
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
add a comment |
$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
add a comment |
2 Answers
2
active
oldest
votes
$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$$
$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
add a comment |
$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.
$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
add a comment |
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
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
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
$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$$
$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
add a comment |
$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$$
$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
add a comment |
$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$$
$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$$
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
add a comment |
$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
add a comment |
$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.
$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
add a comment |
$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.
$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
add a comment |
$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.
$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.
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
add a comment |
$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
add a comment |
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.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
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
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
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
$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