You should turn interes in ONE Esed document, financial formulas itt Exeed to show work for Requirement #1 al 45 of each pari. Ant assignment submitted that doesn't demonstrate your formulas within Excel will receive an unsatisfactory grade. PARTA Spurly Curpurativa insed seven-yeze, 8% boods with a lulal Cace value of 31.000.000 de Jury 1, 2000 Interest is paid a cually un Daxober 31. The moral of interest a this dates 6% Sparly uses the active interest cote method (bbc method we mai in class) Regebed: 1. Using Excel, determine the proceeds the bed sale o 1/1.30 2. Using the prical valuv of six (Lodi Apprait of your wxl-link) and to prsta, value of an unsury annuity c.31 labie (Cound in Appadix Ect your caluro-lib, ballaw.us would you use lo calculate le prixen valik of the Incu value of tbx bund and the coupun paxns? Fur yolu own beneli, may want to demonstexte that the price or the balss same ting Die Gelets om te lubis that you golin Excel Your Godalilisremix due to sounding 3. Did this bond sell at a premium or discount? 4. Using Cxcel, prepare a seven year bond metization schedule for these hands. There are examples in your notes we posted on D2L. Use formulas and reference cells in Lxcel to show how you calculve your numbers. 3. Prepare own2 entries to record (1) the initial sale of the bonds on January 1, 21:20, (2) the interest payment for the period ended December 31, 20201 (5) the final interest and face value payment ar maburic; on December 31, 2026 6. Show low the balancesco wuld put the band lisaility and real promedisco.clon Demba 31, 202). PART B Bill Crporation-year, 8% bonds will loalle sue of $1,000,000 on Satury 1, 2020. Dices is paid sellyo June 30 and Dasztiber 31. The mackerele oficicrested this ale w 10% Bill use the clixtise interes nocthod, Required 1. Decermine the proceeds of the bond sols on 1.1.20. lxplain your method of calculation 2. Using the present value of $1 table food in Afreex of your text or an lines and deprese value of an arcenary annuity S1 table (found in Appendix yer text or c-line, atat facers would you use to calculate the present value of the face value of die hand and the coupon ymments? For your own benelit, giray want to demonstrate that the price of the words the same ning the actor from the tale that you got in Excel. You wilinda diferente de la rounding 3. Did this bonds a promis ordini? 4. Using Excel, prepara l-car bual muriva schiul lic thusetunds. The anamfks in your pics and pusai un D2L. Uw liculas en tur culls i Exal low how you calculate your nunbias. 3. Prepare journz entries to record (1) de sale of the bonds en Jermary 1, 2020. (2) the interest forment for the period ended June 30, 2000 and, (c) the final interest and face vale poyment at maturity on Lecember 31, 2023. 6. Show how the balance she would react the hand liability and related preman discount on December 31, 2021. You should turn interes in ONE Esed document, financial formulas itt Exeed to show work for Requirement #1 al 45 of each pari. Ant assignment submitted that doesn't demonstrate your formulas within Excel will receive an unsatisfactory grade. PARTA Spurly Curpurativa insed seven-yeze, 8% boods with a lulal Cace value of 31.000.000 de Jury 1, 2000 Interest is paid a cually un Daxober 31. The moral of interest a this dates 6% Sparly uses the active interest cote method (bbc method we mai in class) Regebed: 1. Using Excel, determine the proceeds the bed sale o 1/1.30 2. Using the prical valuv of six (Lodi Apprait of your wxl-link) and to prsta, value of an unsury annuity c.31 labie (Cound in Appadix Ect your caluro-lib, ballaw.us would you use lo calculate le prixen valik of the Incu value of tbx bund and the coupun paxns? Fur yolu own beneli, may want to demonstexte that the price or the balss same ting Die Gelets om te lubis that you golin Excel Your Godalilisremix due to sounding 3. Did this bond sell at a premium or discount? 4. Using Cxcel, prepare a seven year bond metization schedule for these hands. There are examples in your notes we posted on D2L. Use formulas and reference cells in Lxcel to show how you calculve your numbers. 3. Prepare own2 entries to record (1) the initial sale of the bonds on January 1, 21:20, (2) the interest payment for the period ended December 31, 20201 (5) the final interest and face value payment ar maburic; on December 31, 2026 6. Show low the balancesco wuld put the band lisaility and real promedisco.clon Demba 31, 202). PART B Bill Crporation-year, 8% bonds will loalle sue of $1,000,000 on Satury 1, 2020. Dices is paid sellyo June 30 and Dasztiber 31. The mackerele oficicrested this ale w 10% Bill use the clixtise interes nocthod, Required 1. Decermine the proceeds of the bond sols on 1.1.20. lxplain your method of calculation 2. Using the present value of $1 table food in Afreex of your text or an lines and deprese value of an arcenary annuity S1 table (found in Appendix yer text or c-line, atat facers would you use to calculate the present value of the face value of die hand and the coupon ymments? For your own benelit, giray want to demonstrate that the price of the words the same ning the actor from the tale that you got in Excel. You wilinda diferente de la rounding 3. Did this bonds a promis ordini? 4. Using Excel, prepara l-car bual muriva schiul lic thusetunds. The anamfks in your pics and pusai un D2L. Uw liculas en tur culls i Exal low how you calculate your nunbias. 3. Prepare journz entries to record (1) de sale of the bonds en Jermary 1, 2020. (2) the interest forment for the period ended June 30, 2000 and, (c) the final interest and face vale poyment at maturity on Lecember 31, 2023. 6. Show how the balance she would react the hand liability and related preman discount on December 31, 2021