"Offering free computer help, hints, and tips to the Internet populace." Now with over 3,820 tips!

Windows 7

Mortgage Calculations

SUMMARY: Calculate the monthly payment, down payment, purchase price, or years of a mortgage with Windows 7.


 

Even in uncertain economic times, some people are still able to purchase condos and houses. These usually require mortgages, and calculating the dollar amounts is a necessity. Instead of relying on web sites or third-party software, let Windows 7 's calculator handle some of the needed tasks.

1. Open the Calculator - click the Start button, select "All Programs", "Accessories", then "Calculator".


2. The Windows Calculator appears. Open the "Mortage Worksheets" pane by selecting "View" - "Worksheets" - "Mortgage".


3. The Mortgage Worksheets pane appears to the right. Underneath "Select the value you want to calculate", click the pull-down and choose from the following:

* Down payment
* Monthly payment
* Purchase price
* Term (years)

Underneath, enter the necessary information that will depend on the type of calculation desired. Then click the "Calculate" button.

For example (see the below screenshot), to calculate the monthly payment for a $250,000 mortgage with a $75,000 down payment and a 30-year term at 5% interest, the calculator's result would be $939.4378402712432 (rounded to $939.44).


Example monthly payment calculation for a mortgage via Windows 7's Calculator




You can highlight the result with your mouse, then select "Edit" - "Copy" (or press Ctrl + C) to copy the resulting value. It can then be pasted into the main calculator pane, Notepad, a word processing document, etc.

This tip was written for Windows 7 RC. Screenshots and information are subject to change between this and the official release of Windows 7.




 

Got something to add? Post a comment!

Everyone is invited to submit comments. Registered users also receive their own visitor profile page with a summary of recent posts.
Register | Login

1. accountant (10/22/2009 04:17:40)  

Please note that the calculator Mortgage calculator only caters for simplistic mortages, and does not corretly calculate, for example, ANY Canadian mortgage, which by law calculates the interest calculated 6-monthly
Therefore what is missing is a formula to calculate the EFFECTIVE interest rate

35 total posts | view profile

2. Andrew Malek (01/26/2010 03:55:47)  

Quite true.

I have not tried this myself, but the following website claims to offer an Excel spreadsheet that calculates Canadian mortgages:

http://www.vertex42.com/Calculators/Canadian-mortgage.html
Your name:
 E-mail:
* Home/Blog Page:
Comment:
(Max chars: 5000)

* = optional field

 


Print This Tip

Get E-Mail When New Tips are Online

Return to the Windows 7 page.

 


New in MalekTips:

RSS Feeds- Subscribe!

You want the latest tech tips and tricks in your e-mail Inbox - FREE? Type your e-mail address below and click 'Get Tips!'.
 


( sample / details )
( opt-out instructions )