solved WORKPAPER #1 Create a workpaper in excel that produces the

WORKPAPER #1
Create a workpaper in excel that produces the following:

A bond amortization schedule that

Includes a defined section for the inputs

No value should need to be input more than once

Outputs the following:

Period#
Coupon Payment
Effective Interest Method Interest Expense
Amortization of Discount or Premium
Bond Payable Balance
Discount or Premium Balance
Net Book Value of the Bond (aka Carrying Value

Can handle Face value, Premium, and Discount bonds. This can be achieved in a single tab or different tabs for each type.
Will calculate the price of a bond given face value, stated rate, and market rate. 

An installment note amortization table that

Is on a different tab than the bond table(s)
Includes a defined section for the inputs

No value should need to be input more than once

Outputs the following:

Payment #
Beginning principal balance
Total payment amount
Interest payment
Principal payment
Ending principal balance