I have a spreadsheet with a whole lot of different finance contract details and I would like a formula which auto calculates the outstanding loan balance as at today, or even just at the beginning of the current month, whichever is easier.
The information in the spreadsheet is;
-loan repayment (fixed amount)
-loan term
-balloon amount (if applicable)
-original loan amount
What is the best way of achieving this?
The information in the spreadsheet is;
-loan repayment (fixed amount)
-loan term
-balloon amount (if applicable)
-original loan amount
What is the best way of achieving this?