Reference no: EM132490591

The head office of Crane Central Ltd. has operated in the western provinces for almost 50 years. Crane Central uses ASPE. In 2004, new offices were constructed on the same site at a cost of $9.70 million. The new building was opened on January 4, 2005, and was expected to be used for 35 years, at which time it would have a value of approximately $2.20 million.

• In 2020, as competitors began to consider merger strategies among themselves, Crane Central felt that the time was right to expand the number of its offices throughout the region. This plan required significant financing and, as a source of cash, Crane Central looked into selling the building that housed its head office. On June 29, 2020, Rural Life Insurance Ltd. purchased the building (but not the land) for $8.60 million and immediately entered into a 20-year lease with Crane Central to lease back the occupied space. The terms of the lease were as follows.

Point 1: It is non-cancellable, with an option to purchase the building at the end of the lease for $1 million.

Point 2: The annual rental is $902,449, payable on June 29 each year, beginning on June 29, 2020.

Point 3: Rural Life expects to earn a return of 10% on its net investment in the lease, the same as Crane Central's incremental borrowing rate.

Point 4: Crane Central is responsible for maintenance, insurance, and property taxes.

Point 5: Estimates of useful life and residual value have not changed significantly since 2001. Straight-line depreciation is used by Crane Central.

Question 1: Calculate the lease payment that Rural Life would require from Crane Central. Implement an amortization schedule for the first two payments. (Hint: You may find the ROUND formula helpful for rounding in Excel.) Start with an amount rounded to the nearest thousand dollars. (Start the table with an amount rounded to the the nearest thousand dollars. Round answers to 0 decimal places, e.g. 5,275.)