Excel amortization chart

Create an amortization table in excel. You should assume the users will be two year accounting graduate (so they know terms but are not versed in bonds). You will not be able to train them in person make sure your directions on how to use the table are clear. You will be heavily penalized for unclear directions. The table will show the interest expense, amortization (effective rate method), and carrying value for each period of the bond’s life. The table should be able to handle a premium or a discount. Note: I should be able to know what information is input and how the information needs to be input within ten seconds. If I get confused, you lose points. IMPORTANT The spreadsheet is capable of amortizing bonds annually, or semiannually, or quarterly, etc. The spreadsheet is capable of amortizing using straight line method or effective method. The spreadsheet is capable of calculating the amount of the premium or discount.