![]() ![]() ![]() For now, here are the steps to follow to calculate the present value of lease payments AND the lease liability amortization schedule using excel, when the payment amounts are different. Next week’s blog will feature a comprehensive example of how to transition from current lease accounting rules to the new lease accounting standards, and we will be referencing the methods utilized in this blog for our calculations. With the method we explain below, you will have everything you need to comply with the new lease rules powered only by an excel spreadsheet. ![]() It is also a useful tool for those of you that plan on using lease accounting and lease management software, as you can use the information in this blog to ensure that your chosen software provider is actually performing this calculation accurately. ![]() Let us stress that this information is important not just for companies that plan on continuing to use excel spreadsheets for lease management. This week, we will show you how to calculate the present value of minimum lease payments AND prepare the liability amortization schedule for the lease liability in the same step, using excel. Last week’s blog focused on one important thing: How to calculate the present value of lease payments using excel spreadsheets. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |