Calculates total interest, payments and ending balance for fixed interest rate loans. You can also solve for LOAN AMOUNT, MONTHLY PAYMENT, INTEREST RATE, or # OF MONTHS to complete a loan. With a payment of zero you can calculate interest on deposited funds over time. Export to Excel with a formula driven schedule that you can add arbitrary additional payments each month and see the results. Spreadsheets in xlsx format have been tested with the following programs: Excel, Numbers, and OpenOffice Calc. Quickly enter amounts like 150,000.00 with 150K or 360 months with 30Y.
Updated to 64 bit. Improved rounding for better match with generated worksheets. Worksheets have been relocated to the sandboxed Documents directory.
OpenSSL License: Copyright (c) 1998-2016 The OpenSSL Project. All rights reserved. This product includes software developed by the OpenSSL Project for use in the OpenSSL Toolkit. (http://www.openssl.org/)
Original SSLeay License: Copyright (C) 1995-1998 Eric Young (firstname.lastname@example.org) All rights reserved. This product includes cryptographic software written by Eric Young (email@example.com)
Ratings and Reviews
SIMPLE & PERFECT!
Anyone who needs an amortization mortgage scheule, this is the perfect app! You can customize the monthly payments, length of loan, interest rate and best of all, this even allows you to calculate a balloon remainder balance. Great app!
Simple to The Point - As Needed
I was struggling with different spreadsheets and apps to produce an interest paid report for my accountant. The challenge was to match the payment, interest, and balance with my online banking account and statements. This worked to a tee…
I produced an excel spreadsheet in seconds. This would be great to combine with a snowball pay down app - with multiple accounts. Possible new features down the road?? I would be willing to pay more...
Works as advertized. COnnects directly to Excel.
COnnects nicely to Excel as I needed it to.
Its a bit clunky, but easy to learn and very usable.
With Family Sharing set up, up to six family members can use this app.