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.
