Category Archives: Present Value of Lease Payments with varying lease payments

Using Excel to Calculate Present Value of Minimum Lease Payments

This is the ONE thing you MUST be able to do under the new lease accounting rules: The new lease accounting rules require the vast majority of leases to be capitalized, and the capitalized amount is calculated as the present … Continue reading

Posted in Lease Accounting, Minimum Lease Payments Using Excel, Present Value of Lease Payments with varying lease payments, Present Value of Minimum Lease Payments | Tagged , , | Leave a comment

Excel Template to Calculate Present Value of Minimum Lease Payments

This is free excel tool you can use to calculate the present value of future minimum lease payments. It is a template that works for periods up to 120 years. To calculate using your own numbers, change the values in … Continue reading

Posted in Minimum Lease Payments Using Excel, Present Value of Lease Payments with varying lease payments, Present Value of Minimum Lease Payments | Leave a comment

How to use Excel to Calculate the Present Value of Minimum Lease Payments when the payment amount changes each period

This post by George Azih explains how to use excel to calculate the present value of minimum lease payments when each payment is different. To see how to use excel to calculate the present value of lease payments when the … Continue reading

Posted in Lease Accounting, Minimum Lease Payments Using Excel, Present Value of Lease Payments with varying lease payments, Present Value of Minimum Lease Payments | Tagged | Leave a comment