Lease Computations (Lessee)
Part 1:
On December 31, Year 1, Lessee Inc. signed a 5-year lease with Lessor Leasing Co. for equipment having a remaining 6-year useful life. Annual lease payments of $20,000 begin at the signing date. There is a purchase option which is expected to be exercised at the end of the lease.
On December 31, Year 1, Lessee Inc. signed a 5-year lease with Lessor Leasing Co. for equipment having a remaining 6-year useful life. Annual lease payments of $20,000 begin at the signing date. There is a purchase option which is expected to be exercised at the end of the lease.
Complete the lessee’s lease amortization schedule below by entering the appropriate dollar amounts in the indicated cells, rounded to the nearest whole dollar. All amounts should be entered as positive numbers. If the amount is $0, you must enter “0” in the cell to receive credit.
| Payment Number | Payment Amount | Interest Expense | Principal Reduction | Outstanding Balance |
$ 91,544
| ||||
| 1 |
$ 20,000
|
$ 0
|
$ 20,000
| 71,544 |
| 2 | 20,000 | 4,293 | 15,707 | 55,837 |
| 3 | 20,000 | 3,350 | 16,650 | 39,187 |
| 4 | 20,000 | 2,351 | 17,649 | 21,538 |
| 5 |
$ 20,000
|
$ 1,292
|
$ 18,708
|
$ 2,830
|
| 6 |
$ 3,000
|
$ 170
|
$ 2,830
|
0
|
Part 2:
Answer the following questions by entering the appropriate amount or selecting the appropriate answer in the cells indicated. Round all amounts to the nearest whole dollar and enter all amounts as positive values. If the answer is a percentage, enter to one decimal place (e.g., “10.5”); do not use a “%” sign.
Answer the following questions by entering the appropriate amount or selecting the appropriate answer in the cells indicated. Round all amounts to the nearest whole dollar and enter all amounts as positive values. If the answer is a percentage, enter to one decimal place (e.g., “10.5”); do not use a “%” sign.
| Question | Amount/Answer |
| 1. What are the total cash payments for the term of the lease? |
$ 103,000
|
| 2. What is the total interest expense for the term of the lease? |
$ 11,456
|
| 3. What is the amount of the annual straight-line amortization of the right-of-use asset? |
*$ 15,257
|
| 4. What was the effective interest rate for the lease? |
**6.0
|
| 5. Assume that Lessee Inc. had a return on assets of 15% and a debt/equity ratio of 2 to 1. What impact would the lease have on these ratios at commencement, respectively? |
***Decrease; increase
|
| 6. The lessee’s statement of cash flows for the year in which the first payment was made, using the direct method, will report cash outflow from which activity? |
Financing
|
| 7. How would the lessee reflect the right-of-use asset and the lease liability of the statement of cash flows, using the direct method? |
****Non-cash Investing and Financing
|
*Annual straight-line amortization on the right-of-use (ROU) asset is $15,257 ($91,544 ÷ 6 years). Since it is expected that the purchase option will be exercised, the amortization is over the life of the asset of 6 years, not the lease term of 5 years.
***A finance lease increases assets and liabilities the same amount and thus has no effect on equity. Return on assets (ROA) is generally computed as net income divided by total assets. ROA decreases because the denominator increases while earnings (i.e., net income) remain the same. In the debt/equity ratio, the numerator (debt) is increased with no effect on the denominator (equity); therefore, the ratio increases.