This sheet will provide summary for Total Monthly Principal and Total Interest Amounts data for all your Leases per period (month).

Again, every time you add new leases (loans) or change parameters of existing ones don’t forget to click on the “Refresh” button to get the data re-calculated.

excel not updating-47excel not updating-59

Once you make sure that it runs fine then you can buy it.

The Premium Version of the Lease Calculator looks and feels exactly the same as the Free Version, just allows you to maintain more leases (or loans) Using this calculator is pretty easy.

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.

What you need to work out are the principal and interest amounts for each lease and then summarize them.

At this point you can decide with which version you wish to continue.

With mouse-clicks you can transfer values from worksheet 1 to worksheet 2 or vice versa.

We have included Repayment Calendar to schedule your Lease payments.

With this handy report you will never miss a single repayment.

In this sheet you need to specify all entry parameters for your leases (or loans) as shown in the image below.

Here you can get details for individual amortization schedules. Every time you add new lease or change parameters for existing lease, click on “Refresh” button to get the calculation updated.

Last, but not least important for your work are graphs showing Repayments and Outstanding Balance Trends.