Please correct answer and don't use hand rating VideoExcel Online Structured Activity: Bond valuationAn investor has two bonds in her portfolio, Bond C and Bond Z. Each bond matures in 4 years, has a face value of $1,000, and has a yield to maturity of 8.9%. Bond Cpays a 11% annual coupon, while Bond Z is a zero coupon bond. The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and performthe required analysis to answer the questions below.XOpen spreadsheetAssuming that the yield to maturity of each bond remains at 8.9% over the next 4 years, calculate the price of the bonds at each of the following years to maturity. Donot round intermediate calculations. Round your answers to the nearest cent.Years to MaturityPrice of Bond CPrice of Bond Z4$ 1,067.62 X711.033$210$ 1,000.00$1,000.00

Step 1: Given Value for Calculation Bond C is Coupon BondBond Z is Zero Coupon BondFace Value = fv =…

Answered: Video Excel Online Structured Activity:…

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 7R

See similar textbooks

Similar questions

Imagine a market where two bonds are traded. Both have a face value of $1,000 and a single annual payment. The first bond is a 5% bullet bond maturing in one year and is traded at $1,034.48. The second bond is a 4% bullet bond maturing in two years and is traded at $1,019.71. Assume that fractions of bonds can be traded. a. Using these bonds, show how you can construct a zero - coupon bond with face value $1,000 maturing in one year and a zero - coupon bond with face value $1,000 maturing in two years.
The Excel file Portfolio Bond Immunization Data contains information about three bonds. Use this data to: Compute the amount to be invested to meet the future liability noted in the data. This future liability is due in 10 years. Find a combination of Bond 1 and Bond 2 having a target duration of 10 years. Find a combination of Bond 1 and Bond 3 having a target duration of 10 years. Perform an analysis using a data table and an accompanying graph to determine which of the following options (i.e., a portfolio consisting of Bond 1 and Bond 2, a portfolio consisting of Bond 1 and Bond 3, or a portfolio consisting of Bond 2) would be preferred to attempt to immunize this obligation. Construct a data table by varying the yield to maturity that shows the value of each option at the end of 10 years. Use yield to maturity values ranging from 0% to 15% in 1% increments. Based on your data table, construct a graph that demonstrates the performance of these 3 options. Analyze each…
Araya is hoping to make her first investment in bonds. She has found two bonds that have the same credit rating online and is now trying to calculate each bond's YTM. Both bonds mature in 15 years. Bond E has a coupon of 5% ; bond F has a coupon rate of 13%. Bond E is selling for $837. Bond F is selling for $391. Find the YTM for these bonds.
K corp has an existing bond that has a par value of $1,000 and an 7% coupon rate. The issue pays interest annually and has 10 years remaining to its maturity date. Bonds of similar risk have a yield of 11%. Calculate the value of these bonds and indicate if it is a discount bond or premium bond. Regardless whether you use calculator, formula or excel function in the calculation, you are required to show the input value for each relevant TVM variables, such as N, 1, PMT, PV, FV. (Here is a sample answer for a TVM calculation: N=1, 1-2,PMT=0, PV-100, compute FV FI's value is $102 Also answer the short answer questions if there are any)
Suppose a bond with no expiration date has a face value of $10,000 and annually pays a fixed amount of interest of $700. a. In the table provided below, calculate and enter either the interest rate that the bond would yield to a bond buyer at each of the bond prices listed below or the bond price at each of the interest yields shown. Instructions: Enter your answers in the gray-shaded cells. For bond prices, round your answers to the nearest hundred dollars. For interest yields, round your answers to 2 decimal places.
Excel Answer Please! An investor has two bonds in her portfolio, Bond C and Bond Z. Each bond matures in 4 years, has a face value of $1,000, and has a yield to maturity of 8.2%. Bond C pays a 10.5% annual coupon, while Bond Z is a zero coupon bond. Assuming that the yield to maturity of each bond remains at 8.2% over the next 4 years, calculate the price of the bonds at each of the following years to maturity. Round your answers to the nearest cent. Years to Maturity Price of Bond C Price of Bond Z 4 $ $ 3 $ $ 2 $ $ 1 $ $ 0 $ $
Find the purchase price of each bond bought on the given dividend date. Accomplish this task at the back of this page or on another sheet of paper. Interest Yield Соupon Dates Annually Annually Annually Annually Maturity Date 5 years 5 years 5 years 5 years Face Value Rate Rate P 1, 000 P1, 000 P 1, 000 P1, 000 5. P1, 000, 000 1. 3% 5% 5% 6% 2. 3. 5% 3% 4. 6% 5% 7.5% 5.5% Annually 10 years 6. P 800, 000 4.5% 6% Semi-annually 6 years 7. P 600, 000 4% 6.5% Quarterly 36 months 8. P1, 200, 000 3.5% 6.5% Annually 36 months 9. P1, 200, 000 Semi-annually 36 months 3.5% 6.5% 10. P 1, 200, 000 3.5% 6.5% Quarterly 36 months
Prepare the journal entries at the time of issuance, at the end of years 1, 2, and 3 for the issuance of a 3 year bond. the bond has the value of 1000,000, a stated coupon rate of 5% and a market rate of 3%. Cash coupon interest payments are made at the end of years 1, 2, 3 debit credit Journal entry at issuance, journal entry at end of year1 , journal entry at end of year 2, journal entry at end of year 3,
Please assist with the following question with full handwritten working: What is the value of a 10 year, 8.2% coupon bond with semiannual coupons. Assume the par value of the bond is $100 and it is redeemable at par. The interest rate (nominal, converted semiannually) is 10.6%.
Click here to view the factor table. https://education.wiley.com/content/Kieso_Intermediate_Accounting_17e/media/simulations/interest_rate_tables.pdf
You are called in as a financial analyst to appraise the bonds of Olsen's Clothing Stores. The $1,000 par value bonds have a quoted annual interest rate of 9 percent, which is paid semiannually. The yield to maturity on the bonds is 8 percent annual interest. There are 15 years to maturity. Use Appendix B and Appendix D for an approximate answer but calculate your final answer using the formula and financial calculator methods. Compute the price of the bonds based on semiannual analysis. Note: Do not round intermediate calculations. Round your final answer to 2 decimal places. With 10 years to maturity, if yield to maturity goes down substantially to 6 percent, what will be the new price of the bonds? Note: Do not round intermediate calculations. Round your final answer to 2 decimal places.
You are called in as a financial analyst to appraise the bonds of Olsen’s Clothing Stores. The $1,000 par value bonds have a quoted annual interest rate of 13 percent, which is paid semiannually. The yield to maturity on the bonds is 10 percent annual interest. There are 10 years to maturity. Use Appendix B and Appendix D for an approximate answer but calculate your final answer using the formula and financial calculator methods. a. Compute the price of the bonds based on semiannual analysis. (Do not round intermediate calculations. Round your final answer to 2 decimal places.) b. With 5 years to maturity, if yield to maturity goes down substantially to 8 percent, what will be the new price of the bonds? (Do not round intermediate calculations. Round your final answer to 2 decimal places.)

SEE MORE QUESTIONS

Recommended textbooks for you

Excel Applications for Accounting Principles

Accounting

ISBN:

9781111581565

Author:

Gaylord N. Smith

Publisher:

Cengage Learning

Excel Applications for Accounting Principles

Accounting

ISBN:

9781111581565

Author:

Gaylord N. Smith

Publisher:

Cengage Learning

SEE MORE TEXTBOOKS