Free tool
Would you like a free spreadsheet tool that will save a lot of time for your staff or external accountant when calculating the book entries for finance leases and loans? In one minute this spreadsheet will calculate all the entries for a loan. It includes;
- Up to 60 month loan term
- Fixed monthly journal entries for each 12 month period
- Allows for planned irregular payments
- Balloon residual payments
A big time saver
Here is a sample calculation. For a free usable copy send your request in the form below.
Note: This spreadsheet contains a VBA macro to calculate interest.