please follow the instructions to help me with the assignment

Part A: Update Bond Amortization Schedule for ASU 2015-03 In April 2015, the FASB issued ASU 2015-03 simplifying the presentation of debt issuance costs. All companies were required to implement this standard after 2017. This new standard requires that debt issuance costs be deducted from the carrying value of the financial liability and not recorded as a separateasset. It was determined that debt issuance costs are similar to debtdiscounts and reduce the proceeds of borrowing, thereby increasing theeffective interest rate. Your manager has asked you to update the bond amortization schedule for the new ASU 2015- 03. First, review the current spreadsheet and formulas. Add issue costs to the input area. Add another line to output for cash proceeds after bond issuance costs. You will then need to calculate a new effective interest rate and then change the formulas in the bond amortization schedule to reflect the change. At the end of the amortization period your bond should have a value equal to the face value of the bond. Bond Amortization Schedule 3 Input 4 Bond Data: 5 Maturity Value 6 Bond Issue Date 7 Stated Interest Rate 8 Market Interest Rate 9 Years Outstanding 10 Times Interest Paid During the Year 100,000.00 1/1/20119 3.00% 4.00% 11 12 Output 13 Bond Report: 14 Present Value of Future Cash Flows: $91.791.33 19 Bond Amortization Schedule 20 Interest Payment Cash Payment Interest Expense CR DR Bond Carrying Value 21 Amortization DR (CR) 23 Initial A A A A A 750.00 $ 750.00 $ 750.00 $ 750.00 $ 750.00 750.00 750.00 750.00 750.00 750.00 750.00 750.00 NOWN- 917.91 $ 919.59 $ 921.29 $ 923.00 $ 924.73 $ 926.48 $ 928.24 $ 930.03 $ 931.83 % 933.64 $ 935.48 $ 937.34 $ (167.91) (169.59) (171.29) (173.00) (174.73) (176.48) (178.24) (180.03) (181.83) (183.64) (185.48) (18734) $91,791.33 $91,959.24 $92, 128.83 $92,300.12 $92,473.12 $92,647.85 $92.824.33 $93.002.58 $93,182.60 $93,364.43 $93.548.07 $93,733.55 $93.920.89 A A A en on - 9 e