Maturity of the bond = 3 years After you input the correct formulas, YTM= 0.1...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Maturity of the bond = 3 years After you input the correct formulas, YTM= 0.1 <--- play with these two numbers, Coupon Rate Coupon Freq Per Year= 0.08 <--- see how the three curves change. 1 Par= 100 Column A Year(i) x Payment Date (year) Payment ($) 8 PV(i) of Payment ($) discounted by YTM -B8/(1+B2) Weight(i) PV(i)/ Sum[PV(i)] PV(i) / Price Column F Weight(i) -D8/$D$12 =A8*F8 8 -B9/(1+B2)^2 108 -B10/(1+B2)^3 -D9/$D$12 -D10/$D$12 -A9*F9 =A10*F10 Bond Price Sum [PV(i) of Payments] =sum(D8:D10) = Make sure the weights sum to 1: Sum[Weight(i)]=sum(F8:F10) - 0.00% Issue Date 1/1/2000 Maturity Date 1/1/2003 Coupon Rate 0.08 Old YTM 0.1 Price (Settlement Date, Marity Date, Coupon Rate, YTM, Redemption, Coupon Freq, Day Count Basis)= Duration = sum [Year(i) Weight(i)]=sum(H8:H10) - Modified duration - Duration/ (1+y)=H14/(1+B2)= Year(Year+1) t*(t+1) =A8*(A8+1) -A9 (A9+1) -A10*(A10+1) Column J X Column F -J8 F8 -J9*F9 -J10*F10 Year(i)[1+Year(i)] Weight(i) use this modified duration in the formula dP/P Convexity = sum { Year(i) * [Year(i)+1] *Weight(i)} =sum(L8:L10) = Modified convexity convexity/(1+y)^2 L16/(1+B2)^2= | <---use this modified convexity in the formula dP/P Redemption Coupon Freq Per Year Day Count Basis 100 Old Price ($) 95.03 Change in YTM New YTM Ay New Price ($) % change in price Actual % change in price based on duration rule % change in price based on duration + convexity 0 -0.1 124.00 0.01 -0.09 120.59 0.02 -0.08 117.30 0.03 -0.07 114.14 0.04 -0.06 111.10 0.05 -0.05 108.17 0.06 -0.04 105.35 0.07 -0.03 102.62 0.08 0.00 -0.02 -0.02 100.00 100.00 0.07 0.09 -0.01 97.47 0.01 91.41 0.1 0 95.03 9.I 95.03 0.11 0.01 92.67 92.07 0.12 0.02 90.39 70.57 0.13 0.03 88.19 0.14 0.04 86.07 0.15 0.05 84.02 0.16 0.06 82.03 0.17 0.07 60.11 80.11 0.18 0.08 78.26 0.19 0.09 76.46 0.2 0.1 74.72 1200.00% 1000.00% 800.00% 600.00% 400.00% 200.00% 0.00% 0 0.05 0.1 0.15 0.2 0.25 -Actual based on duration rule based on duration + convexity Maturity of the bond = 3 years After you input the correct formulas, YTM= 0.1 <--- play with these two numbers, Coupon Rate Coupon Freq Per Year= 0.08 <--- see how the three curves change. 1 Par= 100 Column A Year(i) x Payment Date (year) Payment ($) 8 PV(i) of Payment ($) discounted by YTM -B8/(1+B2) Weight(i) PV(i)/ Sum[PV(i)] PV(i) / Price Column F Weight(i) -D8/$D$12 =A8*F8 8 -B9/(1+B2)^2 108 -B10/(1+B2)^3 -D9/$D$12 -D10/$D$12 -A9*F9 =A10*F10 Bond Price Sum [PV(i) of Payments] =sum(D8:D10) = Make sure the weights sum to 1: Sum[Weight(i)]=sum(F8:F10) - 0.00% Issue Date 1/1/2000 Maturity Date 1/1/2003 Coupon Rate 0.08 Old YTM 0.1 Price (Settlement Date, Marity Date, Coupon Rate, YTM, Redemption, Coupon Freq, Day Count Basis)= Duration = sum [Year(i) Weight(i)]=sum(H8:H10) - Modified duration - Duration/ (1+y)=H14/(1+B2)= Year(Year+1) t*(t+1) =A8*(A8+1) -A9 (A9+1) -A10*(A10+1) Column J X Column F -J8 F8 -J9*F9 -J10*F10 Year(i)[1+Year(i)] Weight(i) use this modified duration in the formula dP/P Convexity = sum { Year(i) * [Year(i)+1] *Weight(i)} =sum(L8:L10) = Modified convexity convexity/(1+y)^2 L16/(1+B2)^2= | <---use this modified convexity in the formula dP/P Redemption Coupon Freq Per Year Day Count Basis 100 Old Price ($) 95.03 Change in YTM New YTM Ay New Price ($) % change in price Actual % change in price based on duration rule % change in price based on duration + convexity 0 -0.1 124.00 0.01 -0.09 120.59 0.02 -0.08 117.30 0.03 -0.07 114.14 0.04 -0.06 111.10 0.05 -0.05 108.17 0.06 -0.04 105.35 0.07 -0.03 102.62 0.08 0.00 -0.02 -0.02 100.00 100.00 0.07 0.09 -0.01 97.47 0.01 91.41 0.1 0 95.03 9.I 95.03 0.11 0.01 92.67 92.07 0.12 0.02 90.39 70.57 0.13 0.03 88.19 0.14 0.04 86.07 0.15 0.05 84.02 0.16 0.06 82.03 0.17 0.07 60.11 80.11 0.18 0.08 78.26 0.19 0.09 76.46 0.2 0.1 74.72 1200.00% 1000.00% 800.00% 600.00% 400.00% 200.00% 0.00% 0 0.05 0.1 0.15 0.2 0.25 -Actual based on duration rule based on duration + convexity
Expert Answer:
Answer rating: 100% (QA)
Here are the workings using the figures provided 1 Calcula... View the full answer
Related Book For
Posted Date:
Students also viewed these finance questions
-
ABC Company has the following mutually exclusive projects. If the company's payback period is 2 years, which of these projects should be chosen? Project A Year 0 -19,500 1 11,500 2 8,750 3 2,500...
-
Q1. You have identified a market opportunity for home media players that would cater for older members of the population. Many older people have difficulty in understanding the operating principles...
-
Which of the following statements is true aboutschizophrenia? a. People throughout the world suffer fromschizophrenia b. The symptoms associated with schizophrenia are the sameacross cultures c....
-
a) What is the ionization energy of a hydrogen atom that is in the n = 4 excited state? (b) For a hydrogen atom, determine the ratio of the ionization energy for the n = 4 excited state to the...
-
The following unadjusted trial balance is for Power Demolition Company as of the end of its April 30, 2017, fiscal year. The April 30, 2016, credit balance of the owner's capital account was $46,900,...
-
Why is the standard error of estimate or prediction higher when the predictive quality of variables is lower?
-
Carnival Confections, Inc. produces two popular southern food items, pork rinds and fried peanuts, which it sells at a local recreation area on weekends. The owners of the business have estimated...
-
Bob the Builder and Wendy were partners in their constructionbusiness and were general contractors. They submitted a bid toconstruct a new building for the the city. They includedLumberjack\'s quote...
-
Problem 2. (10 POINTS). REDUCTION OF ORDER, VARIATION OF PARAMETERS. Consider the following IVP: Sty"-2y=3t2-1, t21, y(1)=3, '(1)=0. (a) (4 points) Given that y(t) = t2 is a solution of the...
-
On April 1, Catherine's employer provided her with a $100,000 loan at an annual interest rate of 5%. Assume that the prescribed interest rate was 3% for the year. If Catherine paid interest on the...
-
3. Explain the following. a) Relationship between risk and rate of returns. b) How do you estimate a firm's cost of new debt financing? c) Does dividend policy affect stock price? Explain
-
Explore the intersection of typography and cognitive psychology, interrogating the perceptual and cognitive mechanisms that underpin the legibility, readability, and typographic processing of textual...
-
Since Ruth's primary goal is not to make an exorbitant profit, how low could her annual net operating cash flows be and still generate a 5% return (i.e., a zero NPV)? State this annual amount in...
-
QUESTION 8 Year 2 Year 1 For the year ended December 31 $8,500 $6,500 Revenues Expenses Net Income 5,500 4,000 At December 31 Year 2 Year 1 Assets $15,500 $9,000 Liabilities Stock Retained Earnings...
-
Equity analysts typically recast and adjust a companys reported earnings prior to developing earnings forecast and applying a valuation model to derive a valuation of its shares. Discuss the...
-
Prove the following D,(cos x) = - sin x (Hint: Apply the identity cos(A + B) = cos A cos B sin A sin B)
-
Which statement about portfolio diversification is correct? a. Proper diversification can reduce or eliminate systematic risk. b. Diversification reduces the portfolios expected return because it...
-
Abigail Grace has a $900,000 fully diversified portfolio. She subsequently inherits ABC Company common stock worth $100,000. Her financial adviser provided her with the following forecast...
-
What are the trade-offs facing an investor who is considering writing a call option on an existing portfolio?
-
Document the CRC card for the temptation EBT.
-
What are the classes and patterns involved in defining the stable pattern for temptation?
-
Is the temptation pattern incomplete without the use of other patterns? Explain briefly.
Study smarter with the SolutionInn App