Commercial Loan Amortization Schedule
Save, fill-In The Blanks, Print, Done!
Download Commercial Loan Amortization Schedule
Adobe Acrobat (.pdf)- This Document Has Been Certified by a Professional
- 100% customizable
- This is a digital download (318.87 kB)
- Language: English
- We recommend downloading this file onto your computer.
How to draft a Commercial Loan Amortization Schedule? An easy way to start completing your document is to download this Commercial Loan Amortization Schedule template now!
Every day brings new projects, emails, documents, and task lists, and often it is not that different from the work you have done before. Many of our day-to-day tasks are similar to something we have done before. Don't reinvent the wheel every time you start to work on something new!
Instead, we provide this standardized Commercial Loan Amortization Schedule template with text and formatting as a starting point to help professionalize the way you are working. Our private, business and legal document templates are regularly screened by professionals. If time or quality is of the essence, this ready-made template can help you to save time and to focus on the topics that really matter!
Using this document template guarantees you will save time, cost and efforts! It comes in Microsoft Office format, is ready to be tailored to your personal needs. Completing your document has never been easier!
Download this Commercial Loan Amortization Schedule template now for your own benefit!
The annual summary for the example is shown below: Annual Cutoff Date (enter Jan 1 for calendar year) Month Jan Jan Day 1 Main Menu Sens itivity 1 Annual Summary Year Jan - Dec 2003 2004 2005 2006 2007 2008 Payment Is To Be Made 1 2 2 2 2 1 Initial Balance 100,000.00 91,276.95 73,037.92 53,688.14 33,159.96 11,381.61 Sum Interest 3,000.00 5,207.07 4,096.32 2,917.92 1,667.75 341.45 17,230.51 Principal 8,723.05 18,239.03 19,349.78 20,528.18 21,778.35 11,381.61 100,000.00 Total Payment 11,723.05 23,446.10 23,446.10 23,446.10 23,446.10 11,723.06 Ending Balance 91,276.95 73,037.92 53,688.14 33,159.96 11,381.61 - 117,230.51 In calendar-year 2005, two loan payments will be made for a total of 23,446.10.. Fast Tools Resources Interest Rate Per Period Principal and Interest Payments 5.00 5.50 6.00 6.50 7.00 3.00 18,155 18,307 18,460 18,613 18,767 semiannual payments Loan Length: years 4.00 5.00 13,947 11,426 14,096 11,574 14,246 11,723 14,396 11,873 14,548 12,024 6.00 9,749 9,897 10,046 10,197 10,348 7.00 8,554 8,702 8,853 9,004 9,157 6.00 16,985 18,762 20,554 22,361 24,181 7.00 19,751 21,834 23,937 26,058 28,199 Interest Rate Lifetime Interest Paid 5.00 5.50 6.00 6.50 7.00 3.00 8,930 9,842 10,759 11,678 12,601 semiannual payments Loan Length: years 4.00 5.00 11,574 14,259 12,766 15,740 13,965 17,231 15,170 18,731 16,381 20,241 Additional Principal Payments This section analyzes how making additional principal payments on each payment date reduces the loan length and lifetime interest paid.. Fast Tools Resources Impact of Additional Principal Payments Fixed amount per payment Percentage increase (Example: Pay an extra 100 per payment) (Example: Pay 10 extra each payment) Additional amount per payment ( ) Loan length: years Reduction in loan length: years Lifetime Interest Reduced lifetime interest 1000 Adjusted 4.55 Loan length: years 0.45 Reduction in loan length: years Original 5.00 17,231 Increase in payment 15,767 Lifetime Interest 1,463.88 Reduced lifetime interest
DISCLAIMER
Nothing on this site shall be considered legal advice and no attorney-client relationship is established.
Leave a Reply. If you have any questions or remarks, feel free to post them below.
Related templates
Latest templates
Latest topics
- Hourly Weekly Schedule Template
How do I make an hourly schedule? Streamline your daily planning with our versatile hourly daily weekly schedule templates - Excel Templates
Where do I find templates for Excel? How do I create a template in Excel? Check these editable and printable Excel Templates and download them directly! - GDPR Compliance Templates
What do you need to become GDPR compliant? Are you looking for useful GDPR document templates to make you compliant? All these compliance documents will be available to download instantly... - Daily Report Sheets For Preschool
How do you create a kindergarten schedule or write a daily report for a preschool? Check out these preschool templates here. - Celcius To Farenheit Chart
How to Download our temperature Celsius to Fahrenheit conversion charts and streamline your temperature calculations and conversions here.
cheese
