The Excel file Immunization Using Individual Bonds contains information about three bonds. Use this data to: Yield to maturity (Expected/Current) 7% Number of Years to Future Liability 8 Future Liability $ 3,000.00 Bond 1 Bond 2 Bond 3 Coupon rate 8.00% 9.000% 7.00% Maturity 9 24 15 Face value 1,000 1,000 1,000 Explain which bond you prefer to use to attempt to immunize this obligation which is due in 8 years. Analyze each bond’s performance in attempting to achieve immunization Please show work in excel and functions/equations used.

The Excel file Immunization Using Individual Bonds contains information about three bonds. Use this data to: Yield to maturity (Expected/Current) 7% Number of Years to Future Liability 8 Future Liability $ 3,000.00 Bond 1 Bond 2 Bond 3 Coupon rate 8.00% 9.000% 7.00% Maturity 9 24 15 Face value 1,000 1,000 1,000 Explain which bond you prefer to use to attempt to immunize this obligation which is due in 8 years. Analyze each bond’s performance in attempting to achieve immunization Please show work in excel and functions/equations used.

Excel Applications for Accounting Principles

4th Edition

ISBN:9781111581565

Author:Gaylord N. Smith

Publisher:Gaylord N. Smith

Chapter11: Bond Pricing And Amortization (bonds)

Section: Chapter Questions

Problem 3R

See similar textbooks

Similar questions

Calculate the value of each bond and discuss whether it sells at par, discount, or premium. (Annual interest rate) O A. Bond Bond Value A B C O B. Bond A B C O C. Bond A B с O D. Bond A B C $1,149.39 Discount $1,000.00 Par $85.60 Premium Bond Value Sells at par/discount/premium Bond Value $1,149.39 Premium $1,000.00 Par $85.60 Discount Sells at par/discount/premium Bond Value Sells at par/discount/premium $1,149.39 Premium $1,000.00 Par $85.60 Premium Sells at par/discount/premium $1,049.39 Premium $1,100.00 Premium $85.60 Discount Bond Par value Coupon interest Years to rate maturity JA B IC $1000 14% $1000 18% $100 10% 120 16 18 Required return 12% 8% 13%
a. Reset the Data Section to its initial values. The price of this bond is 1,407,831. What would it be if there were only 9 or 8 years to maturity? Use the worksheet to compute the bond issue prices and enter them in the spaces provided. Bond issue price (9 years to maturity) __________________ Bond issue price (8 years to maturity) __________________ b. Compare these prices to the bond-carrying values found in the effective interest amortization schedule you originally printed out in requirement 3. Explain the similarity. c. Click the Chart sheet tab. The chart presented shows the price behavior of this bond based on years to maturity. Explain what effect years to maturity has on bond prices. Check your explanation by trying 8% as the effective rate (cell E10) and clicking the Chart sheet tab again. Also try 9%. When the assignment is complete, close the file without saving it again. Worksheet. Modify the BONDS3 worksheet to accommodate bonds with up to 20-year maturity. Use your new model to determine the issue price and amortization schedules of a 2,000,000, 18-year, 10% bond issued to yield 9%. Preview the printout to make sure that the worksheet will print neatly, and then print the worksheet. Save the completed file as BONDST. Hint: Expand both amortization schedules to 20 years. Expand the scratch pad to 20 years. Modify FORMULA1 in cell F17 to include the new ranges. Chart. Using the BONDS3 file, prepare a line chart that plots annual interest expense over the 10-year life of this bond under both the straight-line and effective interest methods. No Chart Data Table is needed. Put A23 to A32 in the Label format and then select A23 to A32, D23 to D32, and B40 to B49 as a collection. Enter all appropriate titles, legends, formats, and so forth. Enter your name somewhere on the chart. Save the file again as BONDS3. Print the chart.
Use the worksheet to compute the bond issue price and amortization schedules if the effective interest rate is 8.2%. Save the file as BONDS5. Print the worksheet when done. Also, repeat requirement 4 in the space provided below for this bond.
Use the worksheet to compute the bond issue price if the effective interest rate is 9%. Bond issue price _____
From page 9-2 of the VLN, how do you determine the annuity cash flow (the bond interest payment) from an annual bond? Group of answer choices A. Bond payable x stated rate B. Bond liability x stated rate C. Bond payable x market rate D. Bond liability x market rate
Calculate the YTM for the following bonds.a. A 12 percent, 20‐year bond with a current price of $975b. A 6 percent, 10‐year bond with a current price of $836c. A 9 percent, 8‐year bond with a current price of $714
Given the information below, which bond(s) will be issued at a discount? Bond 1 Bond 2 Bond 3 Bond 4 Stated Rate of Return 5% 9% 11% 10% Market Rate of Return 7% 7% 11% 13% Multiple Choice Bond 1. Bond 2. Bond 3. Bonds 1 and 4.
Assume bonds payable are amortized using the straight-line amortization method unless stated otherwise. Pricing bonds Bond prices depend on the market rate of interest, stated rate of interest and time. Requirements Compute the price of the following 8% bonds of Country Telecom. a. $100,000 issued at 75.25 $100,000 issued at 94.50 b. $100,000 issued at 103 50 c. $100,000 issued at 94.50 d. $100,000 issued at 103.25 2. Which bond will Country Telecom have to pay the most to retire at maturity? Explain your answer.
Given the information below, which bond(s) will be issued at a premium? Bond 1 Bond 2 Bond 3 Bond 4 Stated Rate of Return 5% 10 % 15% 12% Market Rate of Return 5% 8% 12% 14% Bond 1. Bond 2. Bond 4. Bonds 2 and 3.
A bond is currently selling for $980. This is a _____ bond which will ultimately experience a capital _____. Premium; gain Premium; loss Discount; gain Discount; loss
Assume bonds payable are amortized using the straight-line amortization method unless stated otherwise. Pricing bonds Bond prices depend on the market rate of interest, stated rate of interest and time. Requirements Compute the price of the following 8% bonds of Country Telecom. $100,000 issued at 75.25 $100,000 issued at 94.50 $100,000 issued at 103 50 $100,000 issued at 94.50 $100,000 issued at 103.25 2. Which bond will Country Telecom have to pay the most to retire at maturity? Explain your answer.
A bond with a face amount of $12,000 has a current price quote of 107.15. What is thebond’s price?a. $12,107.15b. $1,285.80c. $12,858.00d. $128,580

SEE MORE QUESTIONS

Recommended textbooks for you

Excel Applications for Accounting Principles

Accounting

ISBN:

9781111581565

Author:

Gaylord N. Smith

Publisher:

Cengage Learning

Financial Accounting: The Impact on Decision Make…

Accounting

ISBN:

9781305654174

Author:

Gary A. Porter, Curtis L. Norton

Publisher:

Cengage Learning

Excel Applications for Accounting Principles

Accounting

ISBN:

9781111581565

Author:

Gaylord N. Smith

Publisher:

Cengage Learning

Financial Accounting: The Impact on Decision Make…

Accounting

ISBN:

9781305654174

Author:

Gary A. Porter, Curtis L. Norton

Publisher:

Cengage Learning

SEE MORE TEXTBOOKS

GET THE APP

About FAQ Academic Integrity Sitemap Document Sitemap

Contact Bartleby Contact Research (Essays)High School Textbooks Literature Guides Concept Explainers by Subject Essay Help Mobile App

GET THE APP

Privacy

Your CA Privacy Rights

Your NV Privacy Rights

About Ads

Manage My Data

bartleby, a Learneo, Inc. business

Yield to maturity (Expected/Current)	7%
Number of Years to Future Liability	8
Future Liability	$ 3,000.00


	Bond 1	Bond 2	Bond 3
Coupon rate	8.00%	9.000%	7.00%
Maturity	9	24	15
Face value	1,000	1,000	1,000