![openoffice calculate remaining payments of loan openoffice calculate remaining payments of loan](https://www.openoffice.org/product/pix/calc-big.png)
After N payments, the balance is:īalance_n= v0*r^n + p*r^(n-1) + p*r^(n-2) +. The next month you pay the interest on the balance:īalance_4= (((v0 r - p)r - p)r - p) r - p When you get a loan, after the first month you incurr interest on the whole loan v0, and make one payment of p. V is remaining loan after some period (e.g. The implementation of the payment function in StarOffice BASIC is extracted for your convenience in:
OPENOFFICE CALCULATE REMAINING PAYMENTS OF LOAN DOWNLOAD
![openoffice calculate remaining payments of loan openoffice calculate remaining payments of loan](https://www.business-plans.com/t/wp-content/uploads/2014/03/Free-Loan-Amortization-Template-for-Excel-2007-%E2%80%93-2016.jpg)
It is usefull to calculate, among other things, whether you should pay mortgage points up front, or go with a higher mortgage rate.
![openoffice calculate remaining payments of loan openoffice calculate remaining payments of loan](https://openofficetemplates.net/wp-content/uploads/2010/08/BMR-Calculator.jpg)
It includes a set of payoff functions in StarOffice Basic. This spreadsheet (in Open Office format) calculates payoff period, remaining loan after 5, 7, and 10 years, total interest paid, etc. Mortgage Points vs.Rate Calculator Spreadsheet Mortgage Points vs.Rate Calculator Spreadsheet What is Mortgage Points vs.Rate Calculator Spreadsheet?