Operating Lease Converter Excel Model
Originally published: 20/06/2016 12:11
Last version published: 02/02/2018 14:50
Publication number: ELQ-98831-3
View all versions & Certificate

Operating Lease Converter Excel Model

An Excel Model allowing you to convert lease commitments to debt.

Operating lease expenses are really financial expenses, and should be treated as such. Accounting standards allow them to be treated as operating expenses. This Excel Model will convert commitments to make operating leases into debt and adjust the operating income accordingly, by adding back the imputed interest expense on this debt.

- Prof. Aswath Damodaran

Side note: If you have appreciated this model, feel free to give it a rating/review!

This Best Practice includes
1 Excel Model File

Prof. Aswath Damodaran offers you this Best Practice for free!

download for free

Add to bookmarks


Further information

The objective of this model is to get the following output values:
- Debt value of leases
- Operating income with operating leases reclassified as debt
- Debt with Operating leases reclassified as debt



More Best Practices from Prof. Aswath Damodaran

See all

Any questions on Operating Lease Converter Excel Model?

The user community and author are here to help. Go ahead!

4.6 / 5 (5 votes)

please wait...