ule (Straight-Line Amortizatio cal year, evalul on the last day of the year, Berur ve hired you to create schedules like those shown in shown in this Guch to your disappoint calculate bond Owen for some guidance. Much to your dir in this ating that he's gone skiing in N email messages for his advice for Chapter 9 you cate, market interest rate, face LOIO-ST S10-7 (Supplement 10A) Preparing a Bond Amortization Schedule (st. excel Assume the authors of a popular introductory accounting text spreadsheets that will calculate bond discount amortization scheda chapter. As usual, you email your friend Owen for some guidan ment, you receive an auto-reply message from Owen indicating Zealand After a bit of panicking, you realize you can refer to Ow spreadsheet advice that will help you complete this task. From hi decide to create a data input section for the stated interest rate value, issue price, and years to maturity. The spreadsheet file also will have a separate amortization tains only formulas, references to the cells in the data input sectio orksheet that con- arate amortization schedule worksheet + section, and references to other est dollar (using amounts will be rounded to the nearest doll IF function in Excel to eliminate any remaining at Owen showed in Chapter 9 for the Round function in Excel), which means the discount amortization in be off a few dollars (unless you use the IF function in Excel to oli count in the final year of the bond's life, in the same way that Owen sh declining-balance depreciation). ght-line bond discount amor- oth the completed spreadsheet and a Required: Prepare a worksheet that uses formulas to reproduce the straight-line bond dis tization schedule shown in Supplement 10A. Display both the completed Spreada "formulas revealed" (Ctrl ) version of it