Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-12-2013, 03:31 AM
BritBiker2 BritBiker2 is offline Mortgage repayment calculations Windows 7 64bit Mortgage repayment calculations Office 2010 64bit
Novice
Mortgage repayment calculations
 
Join Date: Jan 2013
Posts: 10
BritBiker2 is on a distinguished road
Default Mortgage repayment calculations

I want to compare the effect differing amounts of repayments will make to the length of my mortgage.



the calcs I have tried don't look right.

If for instance the loan is say £70,000 and the interest rate is 5.4%, the basic repayment is around £360, but I want to compare how much quicker the loan can be paid off with various amounts of overpayment.
Reply With Quote
  #2  
Old 10-12-2013, 07:21 PM
BobBridges's Avatar
BobBridges BobBridges is offline Mortgage repayment calculations Windows 7 64bit Mortgage repayment calculations Office 2010 32bit
Expert
 
Join Date: May 2013
Location: USA
Posts: 700
BobBridges has a spectacular aura aboutBobBridges has a spectacular aura about
Default

So what calc are you using, BritBiker, and in what way don't the results look right? You gotta give us something to work with.
Reply With Quote
  #3  
Old 10-14-2013, 10:55 PM
macropod's Avatar
macropod macropod is offline Mortgage repayment calculations Windows 7 32bit Mortgage repayment calculations Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,366
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

With the mortgage in A1, Annual Interest Rate as a % in B1, Monthly Instalment in C1, the formula for calculating the number of months to pay off the mortgage is:
=NPER(B1/12,-C1,A1,0,0)
For your data, the result is 463.14 months.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
How to do Calculations In a Text Box? SteveF Word 4 09-27-2013 08:34 AM
Mortgage repayment calculations Using Reference Tables in calculations BritBiker2 Excel 5 02-15-2013 04:19 AM
Mortgage repayment calculations Perform Calculations using List boxes Jennifer_Falcon Word VBA 6 07-26-2011 10:49 AM
Mortgage repayment calculations Can I do calculations with times? cubsfan_1 Excel 1 01-14-2010 06:55 PM
Mortgage repayment calculations Having problems with Duration calculations. bgane Project 1 03-20-2006 06:36 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:58 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft