Notices
Non Scooby Related Anything Non-Scooby related

repayment calculation

Thread Tools
 
Search this Thread
 
Old 14 September 2005, 09:18 PM
  #1  
wwp8
Scooby Regular
Thread Starter
 
wwp8's Avatar
 
Join Date: Nov 2001
Location: sheffield
Posts: 4,093
Likes: 0
Received 0 Likes on 0 Posts
Default repayment calculation

is there a such way(formula) to calculate repayments on a basic calculator
if someone gave you info like this

9%apr
over 36 months
and borrow for example £30k

cos i can do + and - VAT using a normal calc without the % sign

but wondering is there a formula for that as it could be handy.
Old 14 September 2005, 09:35 PM
  #2  
NotoriousREV
Scooby Regular
 
NotoriousREV's Avatar
 
Join Date: Jan 2002
Posts: 11,581
Likes: 0
Received 0 Likes on 0 Posts
Default

APR is tricky as it must take into account any fees you pay as well as interest, it's easier using flat rate to work it out.

Alternatively, use a site like www.moneysupermarket.com to compare loans
Old 15 September 2005, 12:24 AM
  #3  
MattN
Scooby Regular
 
MattN's Avatar
 
Join Date: Nov 2000
Posts: 2,174
Likes: 0
Received 0 Likes on 0 Posts
Default

By paying off the loan in installments, the amount you have borrowed is reducing each month. The interest you are paying is in fact more than xx% of the money owed throughout the year. The APR will take this into account, and it will be a figure higher than xx% when worked out.

So no you can't.
Old 15 September 2005, 07:52 AM
  #4  
DPat
Scooby Regular
 
DPat's Avatar
 
Join Date: Jun 2002
Location: Hampshire / Val d'Isere / Verbier
Posts: 409
Likes: 0
Received 0 Likes on 0 Posts
Default

Originally Posted by wwp8

9%apr
over 36 months
and borrow for example £30k
30*1.09*1.09*1.09/36
Old 15 September 2005, 12:01 PM
  #5  
Reffro
Scooby Regular
 
Reffro's Avatar
 
Join Date: Apr 2001
Location: Bushey
Posts: 2,542
Likes: 0
Received 0 Likes on 0 Posts
Default

The formula to work out the repayments based on a flat rate is as follows:-

(Loan Amount * ((Flat rate expressed as a decimal of one*no.of years)+1))/ No.of months = Monthly repayment.

Flat rate is usually about half the APR. To work out the repayments for your example you should do the following:-

(30000*((0.045*3)+1))/36 If the APR is 9, half that to get 4.5 and divide that 4.5 by 100 to get 0.045.
=>
(30000*(0.135+1))/36 Multiply the flat rate by the no.of years of the loan 0.045 * 3 = 0.135
=>
(30000*1.135)/36 Add one to 0.135 to get 1.135 and multiply this 1.135 by the amount borrowed which gives you the total amount to be repaid.
=>
34050/36 = £945.83 pm Divide the total amount to be repaid by the number of months the loan is to be paid over, to get you approx monthly repayment.

Follow that and the answer will be correct to about £2-3 pounds per month.

For £20000 over 4 years at 11%APR you get the following:-

(20000*((0.055*4)+1))/48 = £508.33pm
Related Topics
Thread
Thread Starter
Forum
Replies
Last Post
ossett2k2
Engine Management and ECU Remapping
12
17 September 2015 08:47 PM
SamUK
Non Scooby Related
1
07 September 2015 02:06 PM
GranTurismo
Non Scooby Related
4
21 June 2001 08:47 AM
ric
ScoobyNet General
3
15 July 2000 01:39 AM



Quick Reply: repayment calculation



All times are GMT +1. The time now is 11:52 AM.