Your employer, Wagner Inc., is a large Canadian public company that uses IFRS. You are working on a project to determine the effect of the proposed contract-based approach on the corporate accounting for leases. To get started on the project, you have collected the following information with respect to a lease for a fleet of trucks used by Wagner to transport completed products to warehouses across the country. The trucks have an economic life of eight years. The lease term is from July 1, 2011, to June 30, 2018, and the company intends to lease the equipment for this period of time, so the lease term is seven years. The lease payment per year is $545,000, payable in advance, with no other payments required, and no renewal option or bargain purchase option available. The expected value of the fleet of trucks at June 30, 2018, is $450,000; this value is guaranteed by Wagner. The leased trucks must be returned to the lessor at the end of the lease. Wagner’s management is confident that with an aggressive maintenance program, Wagner has every reason to believe that the asset’s residual value will be more than the guaranteed amount at the end of the lease term. Wagner’s incremental borrowing rate is 8%, and the rate implicit in the lease is not known. At the time the lease was signed, the fair value of the leased trucks was $3,064,470.
Instructions
(a) Based on the original information:
1. Using time value of money tables, a financial calculator, or computer spreadsheet functions, determine the contractual obligations and rights under the lease at July 1, 2011.
2. Prepare an amortization schedule for the obligation over the term of the lease.
3. Prepare the journal entries and any year-end (December 31) adjusting journal entries made by Wagner Inc. in 2011 and up to and including July 1, 2012.
(b) Immediately after the July 1, 2012 leased payments, based on the feedback of the staff in operations, management reassesses its expectations for the guaranteed residual value. Management now estimates the fleet of trucks to have a value of $400,000 with a 60% probability and $300,000 with a 40% probability.
1. Calculate the probability-weighted expected value of the residual at the end of the lease term. Also calculate the present value at July 1, 2012, of any additional cash flows related to the residual value guarantee.
2. Prepare any necessary entry to implement the revision to the contractual lease rights and obligation at July 1, 2012.
3. Revise the amortization schedule effective January 1, 2013, for the lease, including any liability related to the residual value guarantee.
4. Prepare the year-end adjusting journal entries made by Wagner Inc. for fiscal year 2012.
(a)
1. Contractual obligations and rights under lease, July 1, 2011.
Using tables:
PV of lease payments $545,000 X 5.62288* $3,064,470
* Annuity due Table A-5 at 8%
| Excel formula =PV(rate,nper,pmt,fv,type) |
| Using a financial calculator: | ||
| PV | $ ? | Yields $3,064,469.42 |
| I | 8% | |
| N | 7 | |
| PMT | $ 545,000 | |
| FV | $ 0 | |
| Type | 1 | |
2. Wagner Inc.
Lease Amortization Schedule
| Date | | Annual Lease Payments | | Interest (8%) on Unpaid Obligation | | Reduction of Lease Obligation | | Balance of Lease Obligation | |
| | | | | | | | | $3,064,470 | |
| July 1 | 2011 | $ 545,000 | | | | $545,000 | | 2,519,470 | |
| July 1 | 2012 | 545,000 | | $201,558 | | 343,442 | | 2,176,028 | |
| July 1 | 2013 | 545,000 | | 174,082 | | 370,918 | | 1,805,110 | |
| July 1 | 2014 | 545,000 | | 144,409 | | 400,591 | | 1,404,519 | |
| July 1 | 2015 | 545,000 | | 112,361 | | 432,639 | | 971,880 | |
| July 1 | 2016 | 545,000 | | 77,750 | | 467,250 | | 504,630 | |
| July 1 | 2017 | 545,000 | | 40,369 | * | 504,631 | | (0) | |
* one dollar rounding
3.
July 1, 2011
Contractual Lease Rights........ 3,064,470
Contractual Lease Obligations 3,064,470
Contractual Lease Obligations... 545,000
Cash ...................... 545,000
December 31, 2011
Interest Expense................ 100,779
Interest Payable........... 100,779
($201,558 X 6 / 12 = $100,779)
Amortization Expense........... 218,891
Contractual Lease Rights... 218,891
($3,064,470 ÷ 7 years X 6/ 12 = $218,891)
July 1, 2012
Interest Expense................ 100,779
Interest Payable................ 100,779
Contractual Lease Obligations... 343,442
Cash ...................... 545,000
(b)
1. Probability-weighted expected value of residual
$400,000 X 60% = $240,000
$300,000 X 40% = 120,000
Probability-weighted value 360,000
Guaranteed value 450,000
Liability July 1, 2018 $90,000
To calculate the present value of this additional cash outflow:
| Excel formula =PV(rate,nper,pmt,fv,type) |
| Using a financial calculator: | ||
| PV | $ ? | Yields $56,715 |
| I | 8% | |
| N | 5 | |
| PMT | $ 0 | |
| FV | $ 90,000 | |
| Type | 1 | |
2.
July 1, 2012
Contractual Lease Rights............ 56,715
Contractual Lease Obligations 56,715
The carrying amount of the lease obligation after the above entry is $2,232,743 (balance from the original amortization schedule $2,176,028 after the July 1, 2012 payment + $56,715)
3. Wagner Inc.
Lease Amortization Schedule—Revised July 1, 2012
| Date | | Annual Lease Payments | | Interest (8%) on Unpaid Obligation | | Reduction of Lease Obligation | | Balance of Lease Obligation | ||||||||
| | | | | | | | | $ 2,232,743 | ||||||||
| July 1 | 2013 | $ 545,000 | | $ 178,619 | | $366,381 | | 1,866,362 | ||||||||
| July 1 | 2014 | 545,000 | | 149,309 | | 395,691 | | 1,470,671 | ||||||||
| July 1 | 2015 | 545,000 | | 117,654 | | 427,346 | | 1,043,325 | ||||||||
| July 1 | 2016 | 545,000 | | 83,466 | | 461,534 | | 581,791 | ||||||||
| July 1 | 2017 | 545,000 | | 46,543 | | 498,457 | | 83,334 | ||||||||
| July 1 | 2018 | 90,000 | | 6,666 | * | 83,334 | | (0) | ||||||||
* one dollar rounding
4.
December 31, 2012
Interest Expense................ 89,310
Interest Payable........... 89,310
($178,619 X 6 ÷ 12 = $89,310)
Amortization Expense........... 483,716
Contractual Lease Rights... 483,716
($2,902,294* ÷ 6 years = $483,716)
* Original entry for the rights $3,064,470
Amortization recorded in 2011 (218,891)
Adjustment for residual value 56,715
Amortizable balance $2,902,294
No comments:
Post a Comment