Case Facts: Monterey Company owns a majority voting interest in Del Rey, Inc. On January $1,2019,$ Monterey issued $$1,000,000$ of $6$ percent $10-$year bonds at $$929,764\mathrm{.}18$ to yield $7$ percent. On January $1,2021,$ Del Rey purchased all of these bonds in the open market at a price of $$885,067\mathrm{.}22$ with an effective yield of $8$ percent. Requirements: Using the template on the $$Template$$ tab in this provided Excel file, complete the following: In the space provided, prepare amortization schedules for the Monterey Company bonds payable and the Investment in Monterey Bonds for Del Rey, Inc. In the space provided, prepare consolidation worksheet entry $$B$$ required at December $31,2021$ to reflect the effective retirement of the Monterey bonds.Excel Case$-$Intra$-$entity Bonds Guiding notes $-$ the bond issued is a liability with interest expense$\_$ Bonds issued January $1,2019$ with a stated rate of $6\%$ sold to yield $7\%$ You will prepare two amortization tables, one for each bond in the problem. See Exhibit $6\mathrm{.}5$ on page $277$ for a completed amortization schedule to guide you. While the bond purchased & retired, is an investment w ith interest income$\_$ Bonds retired by affiliate on January $1,2021$ vith a stated rate of $6\%$ and an effective rate of $8\%$ Consolidated Horksheet Entry $12/31121$ You will also prepare Consolidation Worksheet Entry $"$B$"($see page $279)$ relating to the bonds. Notes: $(1)$ All of the values you use in the journal entry will be derived from the two tables above. $(2)$ You need to use account balances after the $2021$ amortization adjustment. $(3)$ "Gain $/$ Loss on Retirement of Bonds"$\text{'}$ is a "plug amount", that is the amount required to balance the journal entry. MAY I PLEASE GET THE EXCEL FORMULAS WITH THE ANSWERS?????