The head office of Wildhorse Central Ltd. has operated in the western provinces for almost 50 years. Wildhorse Central uses ASPE. In 2004, new offices were constructed on the same site at a cost of $9.80 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. Vildhorse 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, Wildhorse 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 $7.70 million and immediately entered into a 20-year lease with Wildhorse Central to lease back the occupied space. The terms of the lease were as follows. 1. 2. 3. 4. 5. It is non-cancellable, with an option to purchase the building at the end of the lease for $1 million. The annual rental is $806,345, payable on June 29 each year, beginning on June 29, 2020. Rural Life expects to earn a return of 10% on its net investment in the lease, the same as Wildhorse Central's incremental borrowing rate. Wildhorse Central is responsible for maintenance, insurance, and property taxes. Estimates of useful life and residual value have not changed significantly since 2001. Straight-line depreciation is used by Wildhorse Central. Click here to view the factor table PRESENT VALUE OF 1. Click here to view the factor table PRESENT VALUE OF AN ANNUITY OF 1. Using time value of money tables, a financial calculator, or Excel functions, calculate the lease payment that Rural Life would require from Wildhorse 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. (Start the table with an amount rounded to the the nearest thousand dollars. Round answers to O decimal places, e.g. 5,275. Partial Lease Amortization Schedule Annual Lease Payment Date Interest Amortization Balance 6/29/20 6/29/20 $ $ 6/29/21 Prepare all entries for Wildhorse Central Ltd. from June 29, 2020, to December 31, 2021. Wildhorse Central has a calendar year fiscal period. (Credit account titles are automatically indented when the amount is entered. Do not indent manually. If no entry is required, select "No Entry" for the account titles and enter o for the amounts. Round answers to 0 decimal places, e.g. 5,275.) Debit Credit Date Account Titles and Explanation June 29, 2020 (To record sale of building.) June 29, 2020 (To record inception of lease and first lease payment.) Dec. 31, 2020 (To record amortization of deferred gross profit.) Dec. 31, 2020 (To record depreciation expense.) Dec. 31, 2020 (To record interest.) June 29, 2021 (To record lease payment.) Dec. 31, 2021 (To record amortization of deferred gross profit.) Dec. 31, 2021 (To record depreciation expense.) Dec. 31, 2021 (To record interest.) The head office of Wildhorse Central Ltd. has operated in the western provinces for almost 50 years. Wildhorse Central uses ASPE. In 2004, new offices were constructed on the same site at a cost of $9.80 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. Vildhorse 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, Wildhorse 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 $7.70 million and immediately entered into a 20-year lease with Wildhorse Central to lease back the occupied space. The terms of the lease were as follows. 1. 2. 3. 4. 5. It is non-cancellable, with an option to purchase the building at the end of the lease for $1 million. The annual rental is $806,345, payable on June 29 each year, beginning on June 29, 2020. Rural Life expects to earn a return of 10% on its net investment in the lease, the same as Wildhorse Central's incremental borrowing rate. Wildhorse Central is responsible for maintenance, insurance, and property taxes. Estimates of useful life and residual value have not changed significantly since 2001. Straight-line depreciation is used by Wildhorse Central. Click here to view the factor table PRESENT VALUE OF 1. Click here to view the factor table PRESENT VALUE OF AN ANNUITY OF 1. Using time value of money tables, a financial calculator, or Excel functions, calculate the lease payment that Rural Life would require from Wildhorse 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. (Start the table with an amount rounded to the the nearest thousand dollars. Round answers to O decimal places, e.g. 5,275. Partial Lease Amortization Schedule Annual Lease Payment Date Interest Amortization Balance 6/29/20 6/29/20 $ $ 6/29/21 Prepare all entries for Wildhorse Central Ltd. from June 29, 2020, to December 31, 2021. Wildhorse Central has a calendar year fiscal period. (Credit account titles are automatically indented when the amount is entered. Do not indent manually. If no entry is required, select "No Entry" for the account titles and enter o for the amounts. Round answers to 0 decimal places, e.g. 5,275.) Debit Credit Date Account Titles and Explanation June 29, 2020 (To record sale of building.) June 29, 2020 (To record inception of lease and first lease payment.) Dec. 31, 2020 (To record amortization of deferred gross profit.) Dec. 31, 2020 (To record depreciation expense.) Dec. 31, 2020 (To record interest.) June 29, 2021 (To record lease payment.) Dec. 31, 2021 (To record amortization of deferred gross profit.) Dec. 31, 2021 (To record depreciation expense.) Dec. 31, 2021 (To record interest.)