The EGG District is preparing to sell bonds to improve their campus. The cost of the project is $900,000 and the bond market has recently been unpredictable. They are offering a $900,000 bond with a 6% interest rate payable annually, Maturity will be in 10 years. They need to consider 2 possible outcomes and need information for both Case u1: The market interest rate at time of issuance is 6.5%. Proceeds from sale will be $850,000. Method of amortization is Straight Line. Case \#2: The market interest rate at time of issuance is 5.75%. Proceeds from sale will be $916,760. Method of amortization is Effective. 1 Create a master/reference table for Case 111 with all the required information needed to prepare a schedule. Create a bond amortization schedule using the Stralght-ine method of amortization for all 10 years. Include all columns on the schedule for the interest journal entry 2 and the individual accounts and carrying value that would be presented on the Balance Sheet. Link/reference the amortization schedule calculations to the master table and use Excel/sheets math functionality fully. 3 Create a master/reference table for Case $2 with all the required information needed to prepare a schedule. Create a bond amortization schedule using the Effective method of amortization for all 10 wears, include all columns on the schedule for the interest journal entry and 4 the individual accounts and carrying value that would be presented on the Balance sheet Link/reference the amortization schedule calculations to the master table and use Excel/sheets math functionalify fully: Using the schedules created and linking/referencing amounts to the individual cells: For CASE =1