New to version 2.0 of Lender Spreadsheet is a full Amortization Schedule.
This shows you all the key information you need to know for the entire life of your loan.
Key to the Amortization Schedule is the Annual Percentage Rate (APR) calculation. Learn more about APR and how we calculate it.
It is easy to print your Amortization Schedule or save it as a pdf file. Learn more about printing and saving to pdf.
The Amortization Schedule below is for the interest only example we are using in this User Guide.
There are two options for your Amortization Schedule.
When you click on the dropdown you can choose between the two options.
In the example below still using our Interest Only example from above, there is an interest rate change from December 1 2021 from 7% to 6% which is now shown on the Amortization Schedule once the CURRENT INTEREST RATES option is selected from the dropdown menu. The Interest Rate change is shown from January 1 2022.
In the example below, the example loan is now fully amortising over 30 years. As you can see this has completely changed the schedule and that there are now payments towards principal.
Get in touch if you’re having problems, need something specific or have questions about our spreadsheet.
Existing customers of Lender Software Pro v1.7.x claim a FREE upgrade to v2.0.x
Get started for FREE Today. Register and Download NOW!
Want to Upgrade from Lite to PRO?. Upgrade and Unlock for $79.99
Microsoft® Windows® and Microsoft® Excel® are registered trademarks of Microsoft Corporation in the United States and other countries.
Mac® and macOS® are trademarks of Apple Inc., registered in the U.S. and other countries.
By continuing to browse or by clicking 'Dismiss' you agree to the storing of cookies on your device to enhance your site experience and for analytical purposes. To learn more about how we use cookies, please see our Cookies Policy and Privacy Policy.