Home / Questions / Bond Valuation with Ratings Array Term Bond rating Calculate the Coupon Payment and Price ...
Bond Valuation with Ratings Array Term Bond rating Calculate the Coupon Payment and Price of the Bond do not round any calculations all calculations should result in positive numbers Be sure to watch the video for this exercise. Row # A 1.10% 1.20% 1.50% 1.60% 1.80% 2.00% 2.20% 2.30% 2.40% 2. 3 1.40% 2.60% Par Value: Coupon Rate: Bond Term (choose): Bond Rating (choose): 1,000.00 3.10% 2.80% 3.00% 4 1.60% 1.80% 6. 20 see rows 31 & 10 3.10% 3.50% 4.30% 32 below 3.50% 4.90% 3.90% 5.30% 6.00% 15 4.70% 6.10% 6.80% Issue Date Maturity date: 8/1/15 30 5.60% 10 8/1/35 calculate maturity date for chosen tem" Table row 9 use MATCH() function 6.10% use HLOOKUP() function Yield to Maturity: Coupon pmts p/year: 40 How many interest payments remain to be paid? What is the amount of each semiannual coupon payment? Calculate all of these as if the 15.50 bond pays two interest payments What is the PV of the Par Value of the bond? What is the PV of the semiannual coupon payments?* 300.66 per year 355.40 What is the Price of the Bond today? 656.06 if the tem is less than 5 years, assume it's a 0-Coupon Bond, otherwise there are 2 interest payments per year** Set Tem to 15, Bond rating to A... Value should be: Set Tem to 3, Bond rating to B.. Value should be: 953.63 947.66 LEAVE cells E11 & E12 set to 3 and B respectively for SELF GRADING and before turning in * Assume the first coupon payment is exactly 6 months from today unless the bond is 0-Coupon ** Use the Date(year,month,day) function. Add years of tem to year of issue date. Month and Day should be the same. = Date(Year)+tem, Month(),Day() a* Use the IF() function
Aug 16 2020 Read more Less More
The quantity of a drug in the bloodstream t hours after a tablet is swallowed is given, in mg, by the equation: q(t) = 20(e^-t - e^-2t) a) How much of the drug is in the ...
Mar 25 2020Comparative balance sheets for 2021 and 2020, a statement of income for 2021, and additional information from the accounting records of Red, Inc., are provided below.
Aug 29 2020Kieron is currently working as an automobile detailer who earns $45,000/year. He currently has living costs of $30,000lyear. Kieron has recently received a job offer inte...
Apr 21 2020(Working with financial statements) Based on the information for T. P. Jarmon Company for the year ended December 31, 2012: a. How much is the firm’s net working capital...
May 03 2020A 1.55-µm continuous-wave signal with 6-dBm power is launched into a fiber with 50-µm2 effective mode area. After what fiber length would the nonlinear phase shift induce...
Jul 29 2020Matches the balance of cash in the bank account with the balance of cash in the company’s own records.04_166169. ____ Withdraws funds directly from the user’s account at...
Jan 27 2020Orwell Company accumulates the following adjustment data at December 31.1. Services provided but not recorded total $1,420.2. Supplies of $300 have been used.3. Utility e...
May 22 2020Discuss the “Title VII of Civil Rights Act of 1964” How it influenced the area of human resources and compensation What the future holds for the act How it affected th...
Feb 04 2020This paper will require you to take at least one of the texts from either Unit Two the Romantic Period (Weeks 4-5) or Unit Three The Realistic Period (Weeks 6-7) and give...
Mar 14 2020Welcome to MyCourseHelp Services, World's leading Academic solutions provider with Millions of Happy Students.