1. Prepare an amortization table using an excel spreadsheet. Use the same titles as Graphic 14-6 or Graphic 14-9 whichever is appropriate. CJ Monkey wants an amortization table that can be easily used for their next bond issue. Make an amortization table that is generic enough that it can be used for any bond by changing no more than: 1. Face value of the bond 2. Stated rate and market interest rate. 3. PV factor. Please round to nearest whole number

2. Prepare the journal entry to record the bonds issuance by CJ on January 1, 2020.

3. Prepare the journal entry to record interest on June 30, 2020.

4. Prepare the journal entry to record interest on December 31, 2020.

5. Prepare the journal entry to record interest on June 30, 2039.

6. Prepare the journal entries to record the payment of interest and principle on December 31, 2039.

7. When you have finished part 1-6, determine the selling price of the bond using the PV function in Excel.

8. An excel spreadsheet with the formulas for each cell from the amortization table. In other words, turn in the same excel spreadsheet except instead of numbers, it will have each cells formula. (Use the Excel help function to find out how to do this). Please format to fit on no more than 2 pages.

9. The Excel formula used to determine #7. (Use the Excel help function to find out how to do this, else its in your book)