Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win


Interest Rates (Financing)

Posted on 2006-07-18
Medium Priority
Last Modified: 2011-10-03
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.
Question by:cgomiz
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
  • Learn & ask questions
LVL 35

Assisted Solution

Raynard7 earned 400 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]


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

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.


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
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

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
12 ln(x) = ln(1.18)
ln(x) = ln(1.18)/12
x = exp(ln(1.18)/12)
=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

After the 12th month's payment he owes $4023.74
LVL 18

Accepted Solution

JR2003 earned 800 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

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

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$


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

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

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

This article seeks to propel the full implementation of geothermal power plants in Mexico as a renewable energy source.
We are taking giant steps in technological advances in the field of wireless telephony. At just 10 years since the advent of smartphones, it is crucial to examine the benefits and disadvantages that have been report to us.
This is a video describing the growing solar energy use in Utah. This is a topic that greatly interests me and so I decided to produce a video about it.
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…

604 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question