Solved

Calculating a monthly repayment

Posted on 2013-12-30
1
285 Views
Last Modified: 2014-01-06
Hello
As you may see from my previous questions I am reading a booklet about loan calculations and not really understanding it.

This is the booklet and I am looking at an example on page 35
http://www.creditunion.ie/files/file_20050316024652OFT%20-%20Credit%20Charges%20and%20APR.pdf

Please could you explain how they calculate a monthly repayment of £206.67

I used this formula here
http://www.wikihow.com/Calculate-a-Loan-Payment
and entered 0.01125 for the montly interest rate and 50 for the number of months and got a loan repayment amount of 196.

Thanks
0
Comment
Question by:andieje
[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
  • Learn & ask questions
1 Comment
 
LVL 25

Accepted Solution

by:
nickg5 earned 500 total points
ID: 39750422
If you read the terms you see that no payment is due until three months have passed. You are calculating the payment for 50 months when it is calculated on page 40 over 48 months. That's where the difference lies.

You started August 15, 2000 in the example but the first payment was not due until November 15, 2000.

Their monthly payment calculated is higher because they are using 48 months and you are using 50.

Using months 3 thru 50 you get a total of 48 months.
3-4-5-6-7 etc. to 50 = 48.
0

Featured Post

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!

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Two list de-cypher 6 102
Volume Calculation 14 74
Whisker Plot 1 45
Simple Calculation for Value of Availablity 5 98
Introduction On a scale of 1 to 10, how would you rate our Product? Many of us have answered that question time and time again. But only a few of us have had the pleasure of receiving a stack of the filled out surveys and being asked to do somethi…
This article seeks to propel the full implementation of geothermal power plants in Mexico as a renewable energy source.
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…

733 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