You are reading a single comment by @dt and its replies.
Click here to read the full conversation.
-
I'm doing something similar for my mortgage repayments.
Get daily average by dividing the amount i've paid off, by number of days since start of mortgage.
Using that average work out the number of days left to pay off the rest by dividing the remaining balance by the daily average.
Than add that number of days to todays date.
dt
@christianSpaceman
nice and simple. That's me.
I guess you could muck around with it
https://docs.google.com/spreadsheets/d/1Pm3Ttnen4ggZ5gv4Bl4XAHs1fknmWVD04GT26hB8laA/edit?usp=sharing
In that you add up what's been paid already, subtract that from your outstanding, and then divide that by the rough number you want to pay back a month.
(i'm not busy today)