Lease Versus purchase - WITH ANSWERS (below question) just not sure where to put them in the Excel spreadsheet
Wooster Corporation can either lease or buy a small garage next to its business that will provide parking for its customers. The company can lease the building for a period of 12 years, which approximates the useful life of the facility and thus qualifies as a capital lease. The terms of the lease are payments of $24,000 per year for 12 years. Wooster currently is able to borrow money at a long-term interest rate of 9 percent. The company can purchase the building by signing an $160,000 long-term mortgage with monthly payments of $2,000. The mortgage also carries an interest rate of 9 percent.
1. With regard to the lease option:
a. Calculate the present value of the lease. (Round to the nearest dollar.)
b. Prepare the journal entry to record the lease agreement.
c. Prepare the journal entry to record depreciation of the building for the first year using the straight-line method.
d. Prepare the journal entries to record the lease payments for the first two years.
2. With regard to the purchase option:
a. Prepare a monthly payment schedule showing the monthly payment, the inter- est for the month, the reduction in debt, and the unpaid balance for the first three months. (Round to the nearest dollar.)
b. Prepare the journal entries to record the purchase and the first two monthly payments.
3. Business appliCation ?Based on your calculations, which option seems to be best? Aside from cost, name an advantage and a disadvantage of each option.
| Answer 1(a) |
|
|
| Years |
Lease payments |
Discount factor @ 9% |
Discounted Amount |
| 1 |
mce_markernbsp; 24,000 |
0.9174 |
mce_markernbsp; 22,018 |
| 2 |
mce_markernbsp; 24,000 |
0.8417 |
mce_markernbsp; 20,200 |
| 3 |
mce_markernbsp; 24,000 |
0.7722 |
mce_markernbsp; 18,532 |
| 4 |
mce_markernbsp; 24,000 |
0.7084 |
mce_markernbsp; 17,002 |
| 5 |
mce_markernbsp; 24,000 |
0.6499 |
mce_markernbsp; 15,598 |
| 6 |
mce_markernbsp; 24,000 |
0.5963 |
mce_markernbsp; 14,310 |
| 7 |
mce_markernbsp; 24,000 |
0.5470 |
mce_markernbsp; 13,129 |
| 8 |
mce_markernbsp; 24,000 |
0.5019 |
mce_markernbsp; 12,045 |
| 9 |
mce_markernbsp; 24,000 |
0.4604 |
mce_markernbsp; 11,050 |
| 10 |
mce_markernbsp; 24,000 |
0.4224 |
mce_markernbsp; 10,138 |
| 11 |
mce_markernbsp; 24,000 |
0.3875 |
mce_markernbsp; 9,301 |
| 12 |
mce_markernbsp; 24,000 |
0.3555 |
mce_markernbsp; 8,533 |
| |
Present Value |
|
mce_markernbsp; 171,857 |
| Answer 1(b) |
|
|
| Buildings |
mce_markernbsp; 160,000 |
|
| Capital Lease obligation |
|
mce_markernbsp; 160,000 |
| |
|
|
| Answer 1(c) |
|
|
| Depreciation |
mce_markernbsp; 13,333 |
|
| Accumulated Depreciation |
|
mce_markernbsp; 13,333 |
| ($ 160,000/12 years) |
|
|
| Answer 1(d) |
|
|
| Rent Expense |
mce_markernbsp; 24,000 |
|
| Cash |
|
mce_markernbsp; 24,000 |
| |
|
|
| Rent Expense |
mce_markernbsp; 24,000 |
|
| Cash |
|
mce_markernbsp; 24,000 |
| Answer 2(a) |
|
|
|
|
| Outstanding Loan |
Interest |
Principal |
Total |
Loan Balance |
| mce_markernbsp; 160,000 |
mce_markernbsp; 1,200 |
mce_markernbsp; 800 |
mce_markernbsp; 2,000 |
mce_markernbsp; 159,200 |
| mce_markernbsp; 159,200 |
mce_markernbsp; 1,194 |
mce_markernbsp; 806 |
mce_markernbsp; 2,000 |
mce_markernbsp; 158,394 |
| mce_markernbsp; 158,394 |
mce_markernbsp; 1,188 |
mce_markernbsp; 812 |
mce_markernbsp; 2,000 |
mce_markernbsp; 157,582 |
| Answer 2(b) |
|
|
| Buildings |
mce_markernbsp; 160,000 |
|
| Mortgage loan |
|
mce_markernbsp; 160,000 |
| |
|
|
| Mortgage loan |
mce_markernbsp; 800 |
|
| Interest expense |
mce_markernbsp; 1,200 |
|
| Cash |
|
mce_markernbsp; 2,000 |
| |
|
|
| Mortgage loan |
mce_markernbsp; 806 |
|
| Interest expense |
mce_markernbsp; 1,194 |
|
| Cash |
|
mce_markernbsp; 2,000
|