Notices
Non Scooby Related Anything Non-Scooby related

Anyone got a formula for....

Thread Tools
 
Search this Thread
 
Old 03 July 2003, 09:38 PM
  #1  
Olly
Scooby Regular
Thread Starter
 
Olly's Avatar
 
Join Date: Apr 1999
Posts: 1,300
Likes: 0
Received 0 Likes on 0 Posts
Post

working out monthly mortgage payments, based on APR, length of term in months, and loan amount?

Olly (U in A level maths).
Old 03 July 2003, 11:19 PM
  #2  
MartinM
Scooby Regular
 
MartinM's Avatar
 
Join Date: Jun 1999
Posts: 1,496
Likes: 0
Received 0 Likes on 0 Posts
Post

http://new.egg.com/visitor/0,2388,3_...w_1028,00.html
Old 04 July 2003, 12:39 AM
  #3  
rallycol
Scooby Regular
iTrader: (4)
 
rallycol's Avatar
 
Join Date: Apr 2001
Posts: 2,153
Likes: 0
Received 0 Likes on 0 Posts
Post

Try this site http://www.mortgageseekers.co.uk/
Old 04 July 2003, 12:43 AM
  #4  
yoza
BANNED
 
yoza's Avatar
 
Join Date: Mar 2002
Location: LIVERPOOL THE CENTRE OF EXCELLENCE
Posts: 8,511
Likes: 0
Received 0 Likes on 0 Posts
Post

Olly stay at home with your mum, you know it makes sence.

£20 a week is a good deal, even if you do have to feed the cows at 0500hrs

Or is this a business move, buy and rent off ?
Old 04 July 2003, 09:10 AM
  #5  
Olly
Scooby Regular
Thread Starter
 
Olly's Avatar
 
Join Date: Apr 1999
Posts: 1,300
Likes: 0
Received 0 Likes on 0 Posts
Post

Cheers chaps.

£20 a month? Robbery

Already into the BTL game, looking at adding to the collection.

Old 04 July 2003, 09:13 AM
  #6  
Olly
Scooby Regular
Thread Starter
 
Olly's Avatar
 
Join Date: Apr 1999
Posts: 1,300
Likes: 0
Received 0 Likes on 0 Posts
Post

PS Anyone know a pen 'n paper version? Egg very slow.
Old 04 July 2003, 09:17 AM
  #7  
Nikko2
Scooby Regular
 
Nikko2's Avatar
 
Join Date: Aug 2001
Posts: 929
Likes: 0
Received 0 Likes on 0 Posts
Post

http://www.jeacle.ie/mortgage/

Try that one its pretty quick when loaded.

Old 04 July 2003, 09:22 AM
  #8  
fast bloke
Scooby Regular
 
fast bloke's Avatar
 
Join Date: Nov 2000
Posts: 26,619
Likes: 0
Received 0 Likes on 0 Posts
Exclamation

Take care...not all APR's are worked on the same basis by different companies
Old 04 July 2003, 02:44 PM
  #9  
Nikko2
Scooby Regular
 
Nikko2's Avatar
 
Join Date: Aug 2001
Posts: 929
Likes: 0
Received 0 Likes on 0 Posts
Post

Your best bet might be to fiddle around with numbers at the money supermarket or charcols website then.
Old 04 July 2003, 04:01 PM
  #10  
boxst
Scooby Regular
 
boxst's Avatar
 
Join Date: Nov 1998
Posts: 11,905
Likes: 0
Received 0 Likes on 0 Posts
Post

Hello

You can do it in Excel if you have it?

=PMT((A/12),B*12,C)*-1

where:

A = Annual interest (e.g. 3.75%)
B = Number of Years (e.g. 25)
C = Amount Borrowed (e.g. £100,000)

and it gives a negative result so multiply it by -1 !

Steve.


Related Topics
Thread
Thread Starter
Forum
Replies
Last Post
Ganz1983
Subaru
5
02 October 2015 09:22 AM
DJZsti
Subaru Parts
9
01 October 2015 05:05 PM
MeisterR
Car Parts For Sale
1
15 September 2015 07:07 PM
Octane Man
ScoobyNet General
2
25 July 2001 05:40 PM



Quick Reply: Anyone got a formula for....



All times are GMT +1. The time now is 01:49 PM.