Question
Create a bond amortization table, which automatically adjusts to the value of input variables. The headings of the table should have (1) year, (2) interest
Create a bond amortization table, which automatically adjusts to the value of input variables. The headings of the table should have (1) year, (2) interest payment, (3) interest expense, (4) amortization of (premium)/discount, and (5) ending balance columns. Pay attention to discount or premium of bonds. You must construct the worksheet with the appropriate numeric format and professional layout. Round number values to the nearest whole dollar. The fixed variables for the assignment are as follows:
Term of bonds = 10 years
Interest Payments = semi-annual
Amortization of Premium or Discount = effective interest method
Bond issued = July 1, 2018
First interest payment due = December 31, 2018
I will test the accuracy of your worksheet with random input variables face value, stated rate of interest, market interest rate. Place your name in cell A1 of the worksheet. Review assignment rubric for specific grade evaluation.
**Please show in an excel worksheet with formulas**
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started