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.