How do I forecast Operating Lease Assets and Liabilities on the Balance Sheet?
Hey guys,
Ever since the FASB has made it mandatory to report Operating Lease Assets and Liabilities on the Balance Sheet, I've not been sure how to forecast it reasonably. I understand that you can find the PV of Lease Payments and subtract interest expense for liabilities, or subtract depreciation for assets, etc. But when the lease payment is actually due (current year), do we just count that as principal repayments and have the remaining lease payments PV on the balance sheet?
Would love clarity on forecasting this, if anyone should have the insight. Thanks!
bump. curious about this as well
your explanation sounds right to me, for ballpark figure. often times in my experience companies don’t bother estimating that and just flatline both the asset and liability side for their projections. usually fine for our purposes but not precise obviously
I go back 10 years and capitalize leases each year so I can get a sense for how their leased assets have changed over time (usually pretty consistent) and then going forward I grow leased assets as a percentage of sales and treat the change similar to capex. I add back the implied interest expense to EBIT and I assume that the lease liability is the same as the lease asset as a % of sales (usually the only difference is a deferred rent expense component that gets rolled into the lease liability, and the difference often is not very large). Even with companies beginning to report under the new lease accounting standard I still prefer to capitalize leases myself and then compare what I have to what the company has reported. I don't do anything with the rent expense, I assume that the non-interest component of rent expense is just a normal operating cost (cost of operating the asset) and already captured in my margin assumptions.
Can you screenshoot your excel model with lease assets and liabilites projections?
http://pages.stern.nyu.edu/~adamodar/
Go to tools > corporate finance > Scroll down to all-in-one valuation models > download fcffginzu.xls
In there he has a tab for capitalizing leases that is pretty good and very similar to what I have incorporated into my models. To forecast operating leases forward, go % of sales like you would for working capital items. Same with Lease Liabilities. Just note that if a company defers rent payments consistently, the lease liability will be larger than the ROU asset they report.
Aspernatur id quia aut nisi. Beatae nihil est occaecati saepe natus exercitationem aut. Ut maiores molestiae reiciendis placeat.
Tempore nihil nam incidunt est illum rerum facere. Exercitationem ipsa ut voluptatum modi quae. Libero et omnis voluptates sed. Sed dolor animi assumenda rerum. Earum aut odio qui impedit. Reiciendis doloremque est molestiae qui voluptatibus quia deserunt illo. Sit soluta maxime quasi non eveniet molestiae doloribus porro.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...