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

WORKPAPER #1Create a workpaper in excel that produces the following:A bond amortization schedule thatIncludes a defined section for the inputsNo 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 thatIs on a different tab than the bond table(s)
Includes a defined section for the inputsNo 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
DO NOT use an existing Excel template to accomplish this. The point of the assignment is to build the tables yourself. If you turn in a template that your team did not create you will earn 0 points for this assignment.PLEASE format your numbers to be whole numbers, including commas, and no dollar signs.
Requirements: Excel spreadsheet for both schedules

Leave a comment

Your email address will not be published. Required fields are marked *