I thought I was able to figure this out, but unfortunately my numbers did not work. If someone would please help with this scenario, then that would be greatly appreciated.
Say I'm taking out a $110,000 loan at 5% (compounded monthly) to be paid back on a 60 month term (it will commence on the 1st of the month, so interim does not play a role here). My first three payments are deferred, but I will owe three contact payments of $100 each. How would I properly calculate the amount of the other 57 payments?
My goal is to turn this into an Excel spreadsheet that calculates after plugging in the variables above, but I fear my =PV and =PMT formulas are incorrect. Any insight there, as well, would be very helpful.