The head office of Carla Vista Central Ltd. has operated in the western provinces for almost 50 years. Carla Vista Central uses ASPE. In 2007, new offices were constructed on the same site at a cost of $9.20 million. The new building was opened on January 4,2008, and was expected to be used for 35 years, at which time it would have a value of approximately $2.00 million. In 2023, as competitors began to consider merger strategies among themselves, Carla Vista 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, Carla Vista Central looked into selling the building that housed its head office. On June 29,2023, Rural Life Insurance Ltd. purchased the building (but not the land) for $9.30 million and immediately entered into a 20-year lease with Carla Vista Central to lease back the occupied space. The terms of the lease were as follows: 1. It is non-cancellable, with an option to purchase the building at the end of the lease for $1 million. 2. The annual rental is $977,196, payable on June 29 each year, beginning on June 29,2023 . 3. Rural Life expects to earn a return of 10% on its net investment in the lease, the same as Carla Vista Central's incremental borrowing rate. 4. Carla Vista Central is responsible for maintenance, insurance, and property taxes. 5. Estimates of useful life and residual value have not changed significantly since 2004. Straight-line depreciation is used by Carla Vista Central. Click here to view the factor table PRESENT VALUE OF 1. Click here to view the factor table PRESENT VALUE OF AN ANNUITY DUE. (a) Using (1) time value of money tables, (2) a financial calculator, or (3) Excel functions, calculate the lease payment that Rural Life would require from Carla Vista Central. Use Excel and prepare a lease 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. (Round factor values to 5 decimal places, e.g. 1.25124 and final answers to 0 decimal places, e.g. 5,275.)