Hello,
I'm trying to solve something that might be quite simple. I would like to know how much is left of an initial amount to this days date. The table is as follows: A3 = Monthly payment, B3 = Total amount, C3 = Start month, D3 = Amount of months to pay, F3 = End month
How would I go around to calculate this? I'm lost :)
Thanks!
MacBook Pro 16″, macOS 14.5
If this is an interest-free loan, then the calculations are simple - you know what the loan value was, and can either a) subtract how many payments (months) have been made from inception, or b) calculate how many payments (months) are left.
For this, add a new column for either Payments made:
=DATEDIF (C3, NOW(), "M")
or for number of remaining payments:
=DATEDIF ( NOW(), F3, "M")
for reference, DATEDIF() takes a start and an end date (one of which is NOW(), or the current date), and calculates the difference. The "M" value at the end returns the number of months (you can also use "D" or "Y" to return the difference in Days or Years).
Now you know either how many payments have been made (assuming they've all been made on time), or how many payments are remaining. Multiplying this by A3 gives you the answer you're looking for.
If this is an interest-free loan, then the calculations are simple - you know what the loan value was, and can either a) subtract how many payments (months) have been made from inception, or b) calculate how many payments (months) are left.
For this, add a new column for either Payments made:
=DATEDIF (C3, NOW(), "M")
or for number of remaining payments:
=DATEDIF ( NOW(), F3, "M")
for reference, DATEDIF() takes a start and an end date (one of which is NOW(), or the current date), and calculates the difference. The "M" value at the end returns the number of months (you can also use "D" or "Y" to return the difference in Days or Years).
Now you know either how many payments have been made (assuming they've all been made on time), or how many payments are remaining. Multiplying this by A3 gives you the answer you're looking for.
Numbers Calculate what's left of a no interest loan right now
