I am a newbie to excel. I would love to create a spreadsheet to track mortgage notes that I hold. I have a few clients that are not paying their notes and would like to impose a late fee. I have one that his note started back in 2008 and has only made 20 payments. What I am looking for is something to be able to enter the actual date the payment was made, the amount being paid, if 15 days late add a late fee and still track the amount of principle and interest being paid. Is this possible. Is there a formula to do this.
At wits ends!!!!
Bookmarks