Sales and Lease back - flow through 3 FS

Hi guys

Got an accounting question as I am trying to get my head around sales-lease accounting mechanics and the flow through 3FS:

Assuming:
- FV of $20m
- 10 years lease
- Lease interest 5%
- Lease payment / year 1.8m
- BV 15m
- D&A assuming 0.5m
- PV lease liability @ 5% (via NPV formula) = 13.9m = lease liability

First question, I see two different approaches calculating RoU assets i) assuming same amount as lease liability (13.9m), or ii) calculating as PV/FV x BV ($10.4m). From a practical perspective, which methodology be used?

Instantly:

IS
- Gain on sales (20-15m) = 5m -> for now I assume RoU = lease liability
- Tax = assuming 0
- NI = 5.0m
CF
- NI = 5.0m
- Gain on sales= -5m
- Cash inflow =20m
- C&c equiv. = 20m

BS
- Cash = 20m
PPE = (15m)
- RoU = 13.9m
- Total asset= 18.9m
///
- Lease = 13.9m
- NI= 5.0m
- Total lease = 18.9m

Year end
IS
- Interest = -0.7m (based on 5%)
- D&A = -0.5m
- NI = -1.2m

CF
- NI = -1.2m
- D&A = +0.5m
- Lease = -1.8m
- C&c equiv = -2.5m

BS
- Cash = -2.5m
- RoU = 13.4 (13.9 – 0.5m D&A)
- Total asset= 10.9m
///
- Lease = 12.1 (- 1.8m lease principal)
- NI= -1.2m
- Total lease = 10.9m

Many thanks monkeys!

 

ROU asset is calculated taking the NPV of contractural rental obligations, discounted back at a secured rate equivalent to where the company can borrow on a coterminous basis. If a 10Y lease, where could they hypothetically borrow on a 10Y basis, etc. Not a science but needs to be defensible. This is how auditors and ratings agencies will account for the ROU. 

 

What is the cap rate? Not following your FV vs. BV vs. PV. The sale price = year 1 rent / cap rate and that is what determines your gain. 
 

you shouldn’t assume $0 tax liability. In this scenario if they have a $5 million gain they’re going to pay taxes on that gain 

 

This is not true. A sale/leaseback can be recognized by the lessee as an operating lease or a capital lease depending on whether it passes the 90% test, among other metrics (does it have a repurchase option, is there ongoing involvement that constitutes quasi-ownership, etc.).  
 

A Capital lease is a designation for lessee recognition; a sales-type lease for lessor for recognition. 
 

A cap rate is a valuation metric, yes, but it determines sale price and rent which impact gain recognition and income statement impact. 
 

source: I structured sale/leasebacks in a prior life. 

 
Most Helpful

The above is correct, need to see if it qualifies as a sales leaseback in the first place...see below URL for a full walkthrough.

https://www.journalofaccountancy.com/issues/2020/jul/accounting-for-sal…

To the original poster, I think your answer is close but the interest component is non-cash and would presumably be baked into the $1.8mm lease payment. You'd have to use effective interest rate method so numbers may differ but using your stated assumptions above:

Your initial assumptions and YE I/S assumptions are right but when it comes to YE CF I would say you need to add back both the D&A and Implied Interest so its a wash and the cash outflow is the lease payment. As such, cash is down $1.8mm and, assuming the $13.4mm RoU asset and a net position of $11.6mm on the asset side, it would would be balanced on the liability/equity side as the lease would only be down by $1.1mm ($1.8mm payment but the liability increases by the implied interest so offset by $0.7) to $12.8mm with the net loss of $1.2mm balancing it out to $11.6mm.

I may be making it too complicated but that's what jumps to mind.

 

Totam eos accusantium maiores. Eaque quibusdam enim id aut. Possimus vero numquam dolor quod laboriosam vel et iste. Explicabo nam non rerum laudantium dolorem sunt ullam dolore. Id incidunt commodi qui ipsam dolores dolorum.

Nesciunt repellendus fugiat dignissimos cupiditate iure a sapiente minima. Voluptatem sequi accusantium voluptas voluptatibus aut. Officia autem consectetur adipisci dolore nemo ea. Quam tenetur distinctio cum beatae et aperiam.

Career Advancement Opportunities

April 2024 Investment Banking

  • Jefferies & Company 02 99.4%
  • Goldman Sachs 19 98.8%
  • Harris Williams & Co. New 98.3%
  • Lazard Freres 02 97.7%
  • JPMorgan Chase 03 97.1%

Overall Employee Satisfaction

April 2024 Investment Banking

  • Harris Williams & Co. 18 99.4%
  • JPMorgan Chase 10 98.8%
  • Lazard Freres 05 98.3%
  • Morgan Stanley 07 97.7%
  • William Blair 03 97.1%

Professional Growth Opportunities

April 2024 Investment Banking

  • Lazard Freres 01 99.4%
  • Jefferies & Company 02 98.8%
  • Goldman Sachs 17 98.3%
  • Moelis & Company 07 97.7%
  • JPMorgan Chase 05 97.1%

Total Avg Compensation

April 2024 Investment Banking

  • Director/MD (5) $648
  • Vice President (19) $385
  • Associates (87) $260
  • 3rd+ Year Analyst (14) $181
  • Intern/Summer Associate (33) $170
  • 2nd Year Analyst (66) $168
  • 1st Year Analyst (205) $159
  • Intern/Summer Analyst (146) $101
notes
16 IB Interviews Notes

“... there’s no excuse to not take advantage of the resources out there available to you. Best value for your $ are the...”

Leaderboard

1
redever's picture
redever
99.2
2
Secyh62's picture
Secyh62
99.0
3
BankonBanking's picture
BankonBanking
99.0
4
Betsy Massar's picture
Betsy Massar
99.0
5
CompBanker's picture
CompBanker
98.9
6
GameTheory's picture
GameTheory
98.9
7
kanon's picture
kanon
98.9
8
dosk17's picture
dosk17
98.9
9
Linda Abraham's picture
Linda Abraham
98.8
10
DrApeman's picture
DrApeman
98.8
success
From 10 rejections to 1 dream investment banking internship

“... I believe it was the single biggest reason why I ended up with an offer...”