I took this photo of Mick Jagger when I was a photojournalism major at the University of South Florida. It made the cover of a small time music magazine, and I had visions of eventually getting my work on the cover of Rolling Stone. Just like the song.
Around the same time, I took an elective real estate course and showed the photo to my professor. The unimpressed professor said, “If your photos are great, your photojournalism degree won’t matter. And if you photos are bad, your photojournalism degree won’t matter. Why don’t you change it to a finance degree in case the photos don’t work out?”
They didn’t, and fortunately, I did. The most fortunate part was that I developed a life-long obsession with discounted present value formulas, which is a bit odd, I know. Almost all NPV formulas built into spreadsheets and various analyses presume payments at the end of a period. This works fine for annuities, promissory notes or mortgage payments. Lease payments, however, are made at the beginning of a period, not the end. So if you use most standard NPV, PV, and IRR formulas the result is close, but not correct. Which absolutely drives me crazy.
The new FASB and IFRS Lease Accounting rules require that lease rent payments be shown as a liability on the Balance Sheet. The liability is calculated with a discounted NPV using the lessee’s incremental borrowing rate, excludes operating expenses and, in some but not all cases, taxes and insurance. If a termination right exists, you calculate based on the shortest likely term including any termination fee. This liability is offset on the Balance Sheet by a Right of Use Asset, which is generally the same value as the liability plus any “initial lease costs”. Not too complex, really.
I recently came across a “Big 5” commercial real estate brokerage firm’s online lease calculator that proposed to display the new FASB or IFRS balance sheet impact. The calculator uses an end of period assumption (wrong for leases!) and annual payments instead of monthly (again wrong for leases!). Almost all of the FASB/IFRS calculators that I’ve found online do exactly the same thing. Most also neglect to provide inputs for initial lease costs or termination fees. Making them, well, worthless.
So, while no online calculator can ever replace the experience of a competent CPA and the blessing of your auditors, I asked our team to create one. You can see it at FASBLeaseCalculator.com.
Don’t use it for your SEC filing, but it is a quick and convenient way to see an approximate balance sheet impact of existing or proposed real estate leases under consideration. Payments are calculated at the beginning of the term, and monthly. The way it should be.
Photo and article ©1979, 2018 Walt Batansky