Once you make sure that it runs fine then you can buy it. We advise you download the free version and make sure that you can run it on your computer without problems. Just the List of Values boxes may not work properly, so you will need to type Loan Term manually instead of picking it from the Drop-down List. The calculator may also run on Excel 2007. To be able to run the calculator you ideally need to have Microsoft Excel 2010 or later version installed on your computer. Just the opening and processing times will slightly increase. This should not be a problem, Excel can easily handle files even few dozen MB large. Extending it for more leases means that the Excel file will get bigger. We will be glad to explain it.Ĭurrent limit of this calculator is 80 leases (or loans). In case you have any questions about this calculator then please talk to us. Try it and if it suits your needs then you can purchase the full version. With this calculator you can manage all your leases (or loans) in one Excel file, getting individual and consolidated schedules in one place.įree Version of our Capital / Finance Lease Calculator includes all functionality, except for locked interest rate. Our Excel Calculator that can take away all your headaches during the month-ends or year-ends. We thought so, too! Therefore, we developed this: Multiple Lease Amortization Calculator in Excel Wouldn’t it be nice to have all Individual and Consolidated lease schedules in a single Spreadsheet? Sometimes it even crashes.Īnd what about the missing links? How often do you move a file to another place on your Disk and the link gets broken? Now you need to fix the formulas. With dozens of files open at the same time your PC performance goes down. Sometimes you must open all files at once in order for the numbers to get updated correctly. As we all know, this process in Excel doesn’t work smoothly all the time. The hard part here is interlinking all these individual sheets. Your second option is to interlink all spreadsheets and calculate the summary in one master spreadsheet. One way to sum up all individual amounts is doing so manually. Then at the month-end you take the principal and interest amounts of each lease and sum it up.Īnd here is where the problem starts. The typical scenario is like that: You maintain separate amortization spreadsheets for each lease. How Capital / Finance Lease Accounting Usually Works In case of just few loans or leases this isn’t a big issue.īut if you maintain several dozens of amortization schedules then the task can become quite time consuming. What you need to work out are the principal and interest amounts for each lease and then summarize them. If you are an Accountant for a small or medium sized company with multiple leases (or loans) then you probably experience problems with generating accounting entries every month.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |