Microsoft Spreadsheet



Professional spreadsheet templates, for any occasion - by Alex Bejanishvili of Spreadsheet123.com
  1. Microsoft Spreadsheet Icon
  2. Microsoft Spreadsheet Login
  3. Microsoft Spreadsheet Online
  4. Microsoft Spreadsheet Templates
  5. Microsoft Spreadsheet App

If you are looking for a free Microsoft Excel® templates, below you will find a comprehensive list of excel spreadsheet templates and calculators created by Spreadsheet123.com. Vast majority of spreadsheet templates on this page are created with purpose to become a solution for practically any occasion in your life, whether your are moving home or placing kids to college, getting ready for your retirement or simply trying to figure out ways to save money, sorting out your personal finance or taking care of your growing business paperwork, spreadsheets always were and will still be, by far the best and most affordable to start.

Professional spreadsheet templates, for any occasion - by Alex Bejanishvili of Spreadsheet123.com. If you are looking for a free Microsoft Excel® templates, below you will find a comprehensive list of excel spreadsheet templates and calculators created by Spreadsheet123.com. Vast majority of spreadsheet templates on this page are created with.

Want to Calculate Mortgage Payments Offline?

Microsoft SpreadsheetMicrosoftMicrosoft spreadsheets excel
  • Create a spreadsheet document by providing a file name Delete text from a cell in a spreadsheet document Get a column heading in a spreadsheet document Get worksheet information from an Open XML package.
  • Microsoft Office 2007 Spreadsheet free download - Microsoft Office Basic 2007, Microsoft Office Professional 2007, Microsoft Office Word 2007 Update, and many more programs.

We have offered a downloadable Windows application for calculating mortgages for many years, but we have recently had a number of people request an Excel spreadsheet which shows loan amortization tables.

Our Excel mortgage calculator spreadsheet offers the following features:

  • works offline
  • easily savable
  • allows extra payments to be added monthly
  • shows total interest paid & a month-by-month amortization schedule

Microsoft Excel Mortgage Calculator Spreadsheet Usage Instructions

The calculator updates results automatically when you change any input.

loan amount - the amount borrowed, or the value of the home after your down payment.

2

interest rate - the loan's stated APR. For your convenience, we publish local Los Angeles mortgage rates below to help you see currently available rates.

3

loan term in years - most fixed-rate home loans across the United States are scheduled to amortize over 30 years. Other common domestic loan periods include 10, 15 & 20 years. Some foreign countries like Canada or the United Kingdom have loans which amortize over 25, 35 or even 40 years.

Microsoft Spreadsheet Icon

4

payments per year - defaults to 12 to calculate the monthly loan payment which amortizes over the specified period of years. If you would like to pay twice monthly enter 24, or if you would like to pay biweekly enter 26.

5

Microsoft spreadsheet software

loan start date - the date which loan repayments began, typically a month to the day after the loan was originated.

Microsoft spreadsheet compare

6

optional extra payment - if you want to add an extra amount to each monthly payment then add that amount here & your loan will amortize quicker. If you add an extra payment the calculator will show how many payments you saved off the original loan term and how many years that saved.

Enable Your Worksheet to Calculate Your Loan Payments

Microsoft Spreadsheet Login

How to Enable Your Mortgage Calculation Spreadsheet

When you download Excel spreadsheets from the web they download in PROTECTED VIEW.
You need to click on [Enable Editing] in the yellow banner at the top of the spreadsheet to change variable amounts.

Microsoft Spreadsheet Online

By default this calculator is selected for monthly payments and a 30-year loan term. A person could use the same spreadsheet to calculate weekly, biweekly or monthly payments on a shorter duration personal or auto loan.

Microsoft Spreadsheet Templates

Some of Our Software Innovation Awards!

Microsoft Spreadsheet App

Since its founding in 2007, our website has been recognized by 10,000's of other websites. A few of our software innovation awards are listed below: