I need help to build a spreadsheet that can track multiple payments, late fees, interest, multiple and varying payment dates, etc. pertaining to owner financed properties. I manage the office for an elderly man who over the years has personally financed numerous properties for people, but I have no way to see where these people are in their payment schedules and some would like to buy out their mortgage with a bank financed loan for better interest rates.
Can anyone help me or should I see if he can afford to purchase some kind of a program to do this for us??
Thank you