Loan or Mortgage Calculator
For more loan & mortgage templates visit: Spreadsheet123.com
© 2009 Spreadsheet123.com. All rights reserved http://www.spreadsheet123.com/ExcelTemplates/loan-mortgage.html
Enter Values Loan Amount £ Annual Interest Rate Loan Period in Years Number of Payments Per Year Loan Start Date Optional Extra Payments Lender Name:
1,000.00 6.50 % 1 12 1/1/2010
Loan Summary Scheduled Payment Scheduled Number of Payments Actual Number of Payments Total Early Payments Total Interest Total Amount To Pay Saved Interest Total Saved Amount
£
£ £ £ £ £
86.30 12 12 35.56 1,035.56 0.00 0.00
Pmt No. 1 2 3 4 5 6 7 8 9 10 11 12
Payment Date 2/1/2010 £ 3/1/2010 4/1/2010 5/1/2010 6/1/2010 7/1/2010 8/1/2010 9/1/2010 10/1/2010 11/1/2010 12/1/2010 1/1/2011
Beginning Balance 1,000.00 919.12 837.80 756.04 673.84 591.20 508.10 424.56 340.56 256.11 171.20 85.83 £
Scheduled Payment 86.30 86.30 86.30 86.30 86.30 86.30 86.30 86.30 86.30 86.30 86.30 86.30 £
Extra Payment £
Total Payment 86.30 86.30 86.30 86.30 86.30 86.30 86.30 86.30 86.30 86.30 86.30 85.83 £
Principal 80.88 81.32 81.76 82.20 82.65 83.09 83.54 84.00 84.45 84.91 85.37 85.37 £
Interest 5.42 4.98 4.54 4.10 3.65 3.20 2.75 2.30 1.84 1.39 0.93 0.46 £
Ending Balance 919.12 837.80 756.04 673.84 591.20 508.10 424.56 340.56 256.11 171.20 85.83 0.00
END-USER LICENSE AGREEMENT
For more loan & mortgage templates visit: Spreadsheet123.com
© 2009 Spreadsheet123.com.All rights reserved
IMPORTANT—READ CAREFULLY:
This End-User License Agreement (”EULA”) is a legal agreement between you and Spreadsheet123.com that covers all Microsoft Excel and OpenOffice.org templates or spreadsheets (”TEMPLATES”) made by Spreadsheet123.com. By downloading, copying, accessing or otherwise using any TEMPLATES, you agree to be bound by the terms of this EULA.
TEMPLATES LICENSE
This TEMPLATE is protected by copyright laws and international copyright treaties, as well as other intellectual property laws and treaties. Each TEMPLATE is licensed, not sold.
1. GRANT OF LICENSE.
This EULA grants you the right to download the TEMPLATES free of charge for personal use only. You may customize this template with you personal information and use it to calculate your personal or family finance, but you may not remove or alter any logo, trademark, copyright, hyperlinks, disclaimers, terms of use, or other proprietary notices within the TEMPLATES. You may not sell, resell, license, rent, lease, lend, or place on the public server (Internet) or otherwise transfer for value without the express written permission of SPREADSHEET123.COM
2. TERMINATION.
Without prejudice to any other rights, Spreadsheet123.com may terminate this EULA if you fail to comply with the terms and conditions of this EULA. In such event, you must destroy all copies of any TEMPLATE.
3. NOTICE SPECIFIC TO TEMPLATES.
SPREADSHEET123.COM MAKE NO REPRESENTATIONS ABOUT THE SUITABILITY OF THE TEMPLATES FOR ANY PURPOSE. ALL TEMPLATES ARE PROVIDED “AS IS” WITHOUT WARRANTY OF ANY KIND. SPREADSHEET123.COM HEREBY DISCLAIM ALL WARRANTIES AND CONDITIONS WITH REGARD TO THE TEMPLATES, INCLUDING ALL IMPLIED WARRANTIES AND CONDITIONS OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE, TITLE AND NON-INFRINGEMENT. IN NO EVENT SHALL SPREADSHEET123.COM BE LIABLE FOR ANY SPECIAL, INDIRECT OR CONSEQUENTIAL DAMAGES OR ANY DAMAGES WHATSOEVER RESULTING FROM LOSS OF USE, DATA OR PROFITS, WHETHER IN AN ACTION OF CONTRACT, NEGLIGENCE OR OTHER TORTIOUS
4. MISCELLANEOUS.
Some states do not allow the limitation or exclusion of liability for incidental or consequential damages, so the above limitation may not apply to you.
For more loan & mortgage templates visit: Spreadsheet123.com © 2009 Spreadsheet123.com. All rights reserved http://www.spreadsheet123.com/ExcelTemplates/loan-mortgage.html
Personal Budget Planner
Household Monthly Budget Planning Template
Weekly Time Table (Staff Rota) Schedules Template
Download this template!!!
Download this template!!!
Download this template!!!
Employee Payroll Calculator Template with HR Dashboards
Timesheet Template with Breaks
Service Invoice Template
Download this template!!!
Download this template!!!
Download this template!!!
Purchase Order Form Template
Customer Account Statement Template
Restaurant Monthly Profit and Loss Statement
Download this template!!!
Download this template!!!
Download this template!!!
ownload this template!!!
Purchase Order Form Template
Customer Account Statement Template
Restaurant Monthly Profit Loss Statement
Download this template!!!
Download this template!!!
Download this template!!!
Download this template!!!
Download this template!!!
Download this template!!!
& mortgage templates Spreadsheet123.com
et123.com. All rights reserved xcelTemplates/loan-mortgage.html
eekly Time Table (Staff ta) Schedules Template
wnload this template!!!
ervice Invoice Template
wnload this template!!!
staurant Monthly Profit and Loss Statement
wnload this template!!!
wnload this template!!!