Financial Statement Impact of Treating Operating Leases as Finance Leases for the Lessee
CEC Entertainment, Inc. (NYSE: CEC) has significant commitments under capital (finance) and operating leases. Following is selected financial statement information and note disclosure to the financial statements for the company.
Commitments and Contingencies Footnote from CEC’s Financial Statements:
8. Commitments and contingencies:
The company leases certain restaurants and related property and equipment
under operating and capital leases. All leases require the company to pay property
taxes, insurance, and maintenance of the leased assets. The leases generally
have initial terms of 10 to 20 years with various renewal options.
Scheduled annual maturities of the obligations for capital and operating leases as of 28 December 2008 are as follows (US$ thousands):
(Table 1)
1. A. Calculate the implicit interest rate used to discount the “scheduled annual maturities” under capital leases to obtain the “present value of future minimum lease payments” of $12,208 disclosed in the Commitments and Contingencies footnote. To simplify the calculation, assume that future minimum lease payments on the company’s capital leases for the “thereafter” lump sum are as follows: $1,586 on 31 December of each year from 2014 to 2019, and $454 in 2020. Assume annual lease payments are made at the end of each year.
B. Why is the implicit interest rate estimate in Part A important in assessing a company’s leases?
2. If the operating lease agreements had been treated as capital leases, what additional amount would be reported as a lease obligation on the balance sheet at 28 December 2008? To simplify the calculation, assume that future minimum lease payments on the company’s operating leases for the “thereafter” lump sum are as follows: $63,872 on 31 December each year from 2014 to 2020, and $27,650 in 2021. Based on the implicit interest rate obtained in Part 1A, use 7.245 percent to discount future cash flows on the operating leases.
3. What would be the effect on the debt-to-equity ratio of treating all operating leases as finance leases (i.e., the ratio of total liabilities to equity) at 28 December 2008?
Years | Capital | Operating |
2009 | $1,683 | $66,849 |
2010 | 1,683 | 66,396 |
2011 | 1,683 | 66,558 |
2012 | 1,600 | 65,478 |
2013 | 1,586 | 63,872 |
Thereafter | 9,970 | 474,754 |
Minimum future lease payments | 18,205 | \underline{\underline{\$803,907}} |
Less amounts representing interest | (5,997) | |
Present value of future minimum lease payments | 12,208 | |
Less current portion | (806) | |
Long-term finance lease obligation | \underline{\underline{\$11,402}} |
Selected Financial Statement Information for CEC:
28 December 2008 | 30 December 2007 | |
Total liabilities | $608,854 | $519,900 |
Shareholders’ equity | $128,586 | $217,993 |
(Table 1) |
to 1A: The implicit interest rate on finance leases is 7.245 percent. The implicit interest rate used to discount the finance lease payments is the internal rate of return on the stream of cash flows; that is, the interest rate that will make the present value of the lease payments equal to $12,208. You can use an Excel spreadsheet or a financial calculator for the computations. Set the cash flow at time zero equal to $12,208 (note on Excel and on most financial calculators, you will input this amount as a negative number), input each of the annual payments on the finance leases, and solve for the internal rate of return.
To demonstrate how the internal rate of return corresponds to the individual present values, refer to the following schedule of the undiscounted minimum lease payments based on information from footnote 8 and the assumptions given. Exhibit 12 presents the present value computations.
The interest rate of 7.245 percent approximately equates the future minimum lease payments with the present value of future minimum lease payments of $12,208 that CEC reports.
to 1B: The implicit interest rate is important because it will be used to estimate the present value of the lease obligations reported as a liability, the value of the leased assets on the balance sheet, the interest expense, and the lease amortization on the income statement. For instance, by selecting a higher rate a company could, if desired, opportunistically reduce the present value of its finance leases and thus its reported debt. The reasonableness of the implicit interest rate can be gauged by comparing it to the interest rates of the company’s other debt instruments outstanding, which are disclosed in financial statement footnotes, and by considering recent market conditions. Note, however, that the interest rate implicit in capitalization of the finance lease obligations reflects the interest rate at the time the lease occurred and thus may differ from current rates.
to 2: If the operating leases had been treated as finance leases, the additional amount that would be reported as a lease obligation on the balance sheet at 28 December 2008, using a discount rate of 7.245 percent determined in Part 1 given earlier, is $520,256. Exhibit 13 presents the present value computations. An alternative short cut approach is to divide the discounted finance lease cash flows of $12,208 by the undiscounted finance lease cash flows of $18,205 and then apply the resulting percentage of 67.06 percent to the undiscounted operating lease cash flows of $803,907. The shortcut approach estimates the present value of the operating lease payments as $539,100, which is close to the estimate obtained using the longer method. It is likely to be most accurate when the timing and relative quantities of the two sets of cash flows are similar.
to 3: The debt-to-equity ratio almost doubles, increasing to 8.78x from 4.74x when capitalizing the operating leases. The adjusted debt-to-equity ratio is computed as follows:
(Table 2)
EXHIBIT 12 Present Value Computations | ||||
Implicit Interest Rate (Internal Rate of Return) based on Capital Leases (7.245%) | ||||
Fiscal Year | Years to Discount | Minimum Capital Lease Payment | Times Present Value Factor | Equals Present Value |
2009 | 1 | 1,683 | 1/(1 + interest rate)^1 | 1,569 |
2010 | 2 | 1,683 | 1/(1 + interest rate)^2 | 1,463 |
2011 | 3 | 1,683 | 1/(1 + interest rate)^3 | 1,364 |
2012 | 4 | 1,600 | 1/(1 + interest rate)^4 | 1,210 |
2013 | 5 | 1,586 | 1/(1 + interest rate)^5 | 1,118 |
2014 | 6 | 1,586 | 1/(1 + interest rate)^6 | 1,042 |
2015 | 7 | 1,586 | 1/(1 + interest rate)^7 | 972 |
2016 | 8 | 1,586 | 1/(1 + interest rate)^8 | 906 |
2017 | 9 | 1,586 | 1/(1 + interest rate)^9 | 845 |
2018 | 10 | 1,586 | 1/(1 + interest rate)^{10} | 788 |
2019 | 11 | 1,586 | 1/(1 + interest rate)^{11} | 735 |
2020 | 12 | 454 | 1/(1 + interest rate)^{12} | 196 |
Undiscounted sums of minimum future lease payments |
$18,205 | |||
Present value of future minimum lease payments | $12,208 | $12,208 |
EXHIBIT 13 Present Value Computations | ||||
(Implicit Interest Rate: 7.245%) | ||||
Fiscal Year | Years to Discount | Operating Lease Payments | Times Present Value Factor | Equals Present Value |
2009 | 1 | 66,849 | 1/(1 + 0.07245)^1 | $62,333 |
2010 | 2 | 66,396 | 1/(1 + 0.07245)^2 | 57,728 |
2011 | 3 | 66,558 | 1/(1 + 0.07245)^3 | 53,960 |
2012 | 4 | 65,478 | 1/(1 + 0.07245)^4 | 49,498 |
2013 | 5 | 63,872 | 1/(1 + 0.07245)^5 | 45,022 |
2014 | 6 | 63,872 | 1/(1 +0.07245)^6 | 41,981 |
2015 | 7 | 63,872 | 1/(1 + 0.07245)^7 | 39,145 |
2016 | 8 | 63,872 | 1/(1 + 0.07245)^8 | 36,500 |
2017 | 9 | 63,872 | 1/(1 +0.07245)^9 | 34,034 |
2018 | 10 | 63,872 | 1/(1 + 0.07245)^{10} | 31,735 |
2019 | 11 | 63,872 | 1/(1 +0.07245)^{11} | 29,591 |
2020 | 12 | 63,872 | 1/(1 +0.07245)^{12} | 27,592 |
2021 | 13 | 27,650 | 1/(1 + 0.07245)^{13} | 11,138 |
Undiscounted sums of minimum future lease payments |
$803,907 | |||
Present value of future minimum lease payments | $520,256 |
Unadjusted for Operating Leases | Adjustment to Capitalize Operating Leases | Adjusted to Capitalize Operating Leases | |
Total liabilities | $608,854 | $520,256 | $1,129,110 |
Common shareholders’ equity | 128,586 | 128,586 | |
Debt-to-equity ratio | 4.74x | 8.78x | |
(Table 2) |