Part 1 On November 1, 2022, Great Adventures purchased land by issuing a $500,000, 6%, 10-year installment note to the seller. Great Adventures will pay back this note in monthly installments. In Excel, prepare the following: Tab 1 - Prepare an amortization schedule for the life of the loan. Tab 2 - Prepare the journal entry for the purchase of the land and the first 4 payments. Tab 3 - Create a schedule showing what would be shown on the balance sheet for the current and long term portion of the note each year. Part 2 On January 1, 2021, a company issued 10-year, $3,000,000, 6% bonds with semiannual interest payments. The market interest rate for these bonds is 7%. Tab 1 - Prepare an amortization schedule for the life of the bond. Tab 2 - Prepare the journal entry for the bond issuance and the first 4 payments. Tab 3 - Create a schedule showing what would be shown on the balance sheet for the current and long term portion of the note each year. Key the original data from the problem into the spreadsheet. All remaining numbers must be calculated with formulas and linking. All work must be professionally formatted using the guidelines from Connie Column. Part 1 On November 1, 2022, Great Adventures purchased land by issuing a $500,000, 6%, 10-year installment note to the seller. Great Adventures will pay back this note in monthly installments. In Excel, prepare the following: Tab 1 - Prepare an amortization schedule for the life of the loan. Tab 2 - Prepare the journal entry for the purchase of the land and the first 4 payments. Tab 3 - Create a schedule showing what would be shown on the balance sheet for the current and long term portion of the note each year. Part 2 On January 1, 2021, a company issued 10-year, $3,000,000, 6% bonds with semiannual interest payments. The market interest rate for these bonds is 7%. Tab 1 - Prepare an amortization schedule for the life of the bond. Tab 2 - Prepare the journal entry for the bond issuance and the first 4 payments. Tab 3 - Create a schedule showing what would be shown on the balance sheet for the current and long term portion of the note each year. Key the original data from the problem into the spreadsheet. All remaining numbers must be calculated with formulas and linking. All work must be professionally formatted using the guidelines from Connie Column