Get documents about "Loan Calculator
W
Description
Loan and mortgage calculator or also known as a loan repayment calculator which helps to understand how does your loan or mortgage actually works and whether you can afford to make your monthly repayments on the amount that you wish to borrow.
Document Sample
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!!!
