Question
For the excel assignment, I would like for you to complete two amortization tables. Follow these instructions (meant to make sure you can use excel).
For the excel assignment, I would like for you to complete two amortization tables.
Follow these instructions (meant to make sure you can use excel).
Create each table on a separate worksheet (not file).
Name the worksheets Discount and Premium
assume the following for the bond:
- 10 year term
- bond payments happen semi-annually
- Principal amount of bond is 10,000,000;
- Stated rate on the bond is 8%
- Market rate of interest is 6% for one table and 10 % for the other (name the worksheets appropriately) Note that the two worksheets will have identical formulas if you use excel to its full power.
The first 5 lines of the worksheet should have the following information with labels in column A and the numerical value (or formula to calculate the numerical value in column B.
Number of payments
Principal amount
Stated Rate of Interest
Market rate of interest
Semi-annual payment (use a formula to calculate this referencing other cells)
The sixth line of the worksheet should have calculation of the present value of the bond. Hint: use the PV function
Lines 8-27 should include the amortization table. The table shall contain 5 columns.
Col 1: Beginning Book Value
Col 2: Interest Expense
Col 3: Cash flow or payment
Col 4: Reduction in Principal
Col 5: Ending book value
Step by Step Solution
There are 3 Steps involved in it
Step: 1
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-text-image.webp)
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Step: 3
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started