Solved

# Interest Rates (Financing)

Posted on 2006-07-18
461 Views
I am not sure how to tackle this problem. Could one explain how to do this the long way (like finding all the interests and subtracting) and how to do it with a formula. I just want to learn how to do this.

"Robyn borrows \$10000 from a bank. Interest at 18% per annum is calculated monthly on the amount of money still owing. Robyn repays \$600 each month. How much does Robyn owe the bank after the first 12 repayments?"

I am not sure if one should first find the interest and then subtract 600 or the other way around. And then where to go from this. If anyone can help me grab the idea behind this finance problems it will really be helpful.
0
Question by:cgomiz
[X]
###### Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

• Help others & share knowledge
• Earn cash & points

LVL 35

Assisted Solution

Raynard7 earned 100 total points
ID: 17135875
Mortgage Payments Components: Let where P = principal, r = interest rate per period, n = number of periods, k = number of payments, R = monthly payment, and D = debt balance after K payments, then

R = P × r / [1 - (1 + r)-n]

and

D = P × (1 + r)k - R × [(1 + r)k - 1)/r]

0

LVL 45

Expert Comment

ID: 17135921
Hi cgomiz,

P = principal
Ins = installment

The basic idea is

At end of first month, borrower owes P + interest (for one month) on P
Of this amount he pays back Ins ... A part of Ins would make up for interest on P (say X) and remaining (Ins-X) would repay the principal
Hence, after first month, principal comes down to (P - (Ins - X))

For month2
borrower owes (P-(Ins-X)) + interest (for one month) on (P-(Ins-X))
And so on so forth ...

As you might have observed, as time progresses, the interest component in the repayment goes down.

Cheers!
sunnycoder
0

Author Comment

ID: 17136170
Raynard7 could you please proceed to show how my numbers fit into the equation? For example when trying out http://home.ubalt.edu/ntsbarsh/Business-stat/otherapplets/CompoundCal.htm#rjava4 it does not ask for my monthly payment. When checking the answer in the back of the book i have for this question it says 4131.45\$ I am lost
0

LVL 18

Expert Comment

ID: 17136210
Robyn borrows \$10000 from a bank. Interest at 18% per annum is calculated monthly on the amount of money still owing. Robyn repays \$600 each month. How much does Robyn owe the bank after the first 12 repayments

You need to calculate the monthly interest x.
x^12 = 1.18
so
12 ln(x) = ln(1.18)
so
ln(x) = ln(1.18)/12
x = exp(ln(1.18)/12)
=1.013888
=1.3888% per month

Month       Carried Fwd               Interest                     Reypayment
1      10000                      138.8843035      600
2      9538.884303      132.4801303      600
3      9071.364434      125.9870131      600
4      8597.351447      119.4037168      600
5      8116.755164      112.7289887      600
6      7629.484152      105.9615592      600
7      7135.445712      99.10014077      600
8      6634.545852      92.14342796      600
9      6126.68928      85.09009734      600
10      5611.779378      77.93880702      600
11      5089.718185      70.6881965      600
12      4560.406381      63.33688639      600
4023.743268

After the 12th month's payment he owes \$4023.74
0

LVL 18

Accepted Solution

JR2003 earned 200 total points
ID: 17136242
The answer in you book has not used compund interest just 1.5% per month which is just 18%/12 . This would give you this:

Month       Carried Fwd               Interest                     Reypayment
1      10000              150                 600
2      9550               143.25             600
3      9093.25           136.39875       600
4      8629.64875      129.4447313      600
5      8159.093481      122.3864022      600
6      7681.479883      115.2221983      600
7      7196.702082      107.9505312      600
8      6704.652613      100.5697892      600
9      6205.222402      93.07833603      600
10      5698.300738      85.47451107      600
11      5183.775249      77.75662874      600
12      4661.531878      69.92297817      600
4131.454856

After the 12th month's payment he owes \$4131.45
0

Author Comment

ID: 17136480
yes, you are right. JR 2003. I just fiddle with that 1.5% and i got it through this formula

10,000(1.015^12) -600(1+1.015+1.015^2+...+1.015^11)

K=1+1.015+1.015^2+...+1.015^11= (1-1.015^12)/(1-1.015)

plugged in the values in my calculator and got 4131.454856\$

thanks.

Question: what is the standard way to find the monthly interests (the way my book does it or the way JR2003 does it?)
0

## Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

### Suggested Solutions

Question of probability 6 148
Simplify expression 3 131
Simple Calculation for Value of Availablity 5 102
Just learning algebra / need solution explained 4 80
How to Win a Jar of Candy Corn: A Scientific Approach! I love mathematics. If you love mathematics also, you may enjoy this tip on how to use math to win your own jar of candy corn and to impress your friends. As I said, I love math, but I gu…
Have you ever thought of installing a power system that generates solar electricity to power your house? Some may say yes, while others may tell me no. But have you noticed that people around you are now considering installing such systems in their …
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…
###### Suggested Courses
Course of the Month7 days, 1 hour left to enroll