Why do you need a good prepayment schedule?
- Compute the amortisation amount automatically
- Ensure that you don't miss a single item
- Provide proof of the balance
- Expense forecast
- Double up as contract tracker
Follow me no OT!
Need an upgrade to amortisation by days? Subscribe to the channel AND email me at mike@rcs.asia or PM me on Facebook/LinkedIn
#prepayment
#XLS4ACCT
#excelforaccountants
#datedif
#if
#sumifs
#conditionalfunctions
#conditionalformulas
Ещё видео!