Loan Amortization Schedule

Use this loan amortization calculator to determine the payment amount for any loan.

This tool creates an Excel spreadsheet you can store on your computer, or print, to track your loan balance and the total amount of interest you will pay.

The spreadsheet also allows you to enter the payment date and check number as payments are made.

Use this tool as a mortgage calculator, for business loans, car loans, or any debt requiring an interest calculation.

Loan Name:
Loan Amount: $
Interest Rate: %
Number of Months:

Don't have Microsoft Excel?

Download Microsoft's Excel Viewer (free)
or
Download Open Office Suite (free)



Attention Webmasters:
Add This Tool To Your Website Free!
Simply copy and paste this code anywhere on your site.
This code is for a plain table (like on this page above).

<div> <form action="http://www.pole-barn.info/loan-amortization-calculator.php" method="post"> <table style="text-align:left"> <tr> <th colspan="3" style="text-align:center"> Loan Amortization Calculator </th> </tr> <tr> <td> <label>Loan Name: </label> </td> <td> <input type="text" name="name" size="40" /> </td> </tr> <tr> <td> <label>Loan Amount: $</label> </td> <td> <input type="text" name="amount" size="40" /> </td> </tr> <tr> <td> <label>Interest Rate: %</label> </td> <td> <input type="text" name="rate" size="10" /> </td> </tr> <tr> <td> <label>Number of Months: </label> </td> <td> <input type="text" name="months" size="10" /> </td> </tr> </table> <p> <input type="submit" value="Calculate" /> </p> </form> Powered by APB <a href="http://www.pole-barn.info/">Pole Barns</a> </div>



Widget for blog sidebars (less suitable for customization).
<div> <img src="http://www.pole-barn.info/images/widget-top.gif" style="vertical-align:bottom" alt="" /> <div style="background-color: #e9e9e9;width:200px;border-top: 2px solid #adc2ce;border-bottom: 1px solid #adc2ce;font-size:10px"> <form action="http://www.pole-barn.info/loan-amortization-calculator.php" method="post"> <table style="text-align:left;font-size:10px;font-weight:bold;margin-left:10px"> <tr> <th colspan="2" style="text-align:center"> Calculate Your Payment<br/> Download Amortization Spreadsheet </th> </tr> <tr><td colspan="2"></td></tr> <tr> <td> <label>Loan Name: </label> </td> <td> <input type="text" name="name" size="10" value="Citibank Mortgage" onclick="this.value=''" style="color:#808080;font-size:12px" /> </td> </tr> <tr> <td> <label>Loan Amount: $</label> </td> <td> <input type="text" name="amount" size="10" value="175000" onclick="this.value=''" style="color:#808080;font-size:12px"/> </td> </tr> <tr> <td> <label>Interest Rate: %</label> </td> <td> <input type="text" name="rate" size="6" value="5.65" onclick="this.value=''" style="color:#808080;font-size:12px"/> </td> </tr> <tr> <td> <label>No. of Months: </label> </td> <td> <input type="text" name="months" size="6" value="360" onclick="this.value=''" style="color:#808080;font-size:12px"/> </td> </tr> </table> <div> <input type="submit" value="Calculate" style="font-size:10px;margin:10px 0px 0px 10px" /> </div> </form> <div style="text-align:center;padding-bottom:6px;color:blue"> Powered by APB <a href="http://www.pole-barn.info/">Pole Barns</a> </div> </div> <img src="http://www.pole-barn.info/images/widget-bottom.gif" alt="" style="vertical-align:top" /> </div>


If you have a Wordpress blog this plugin will make installation of our widget a breeze.