Business Finance Homework Help

WORKPAPER #1

Create a workpaper in excel that produces the following:

1. A bond amortization schedule that
   1. Includes a defined section for the inputs
      1. No value should need to be input more than once
   2. Outputs the following:
      1. Period#
      2. Coupon Payment
      3. Effective Interest Method Interest Expense
      4. Amortization of Discount or Premium
      5. Bond Payable Balance
      6. Discount or Premium Balance
      7. Net Book Value of the Bond (aka Carrying Value
   3. Can handle Face value, Premium, and Discount bonds. This can be achieved in a single tab or different tabs for each type.
   4. Will calculate the price of a bond given face value, stated rate, and market rate. 
2. An installment note amortization table that
   1. Is on a different tab than the bond table(s)
   2. Includes a defined section for the inputs
      1. No value should need to be input more than once
   3. Outputs the following:
      1. Payment #
      2. Beginning principal balance
      3. Total payment amount
      4. Interest payment
      5. Principal payment
      6. Ending principal balance