Question

In: Finance

Using this data on how to calculate the approximate formula, without the bond prices

	India
1Y	5.69%
2Y	5.78%
5Y	6.29%
10Y	6.60%
20Y	7.03%
30Y	7.06%

Using this data on how to calculate the approximate formula, without the bond prices, we can calculate future discount rates / forward rates in excel

(1+ DR1) (1+ DR2) = (1+YTM₂)²

Expert Solution

The Discount or Forward Rates can be calculated from the Spot rates using the Expectation hypothesis.

The Forward rate for 1 year prevailing after 1 year 1f1 can be calculated as

1f1= (1+ 2 year spot rate)^2/(1+1 year spot rate) -1

= 1.0578^2/1.0569 -1

=0.0587008 or 5.87%

Similarly

The Forward rate for 3 year prevailing after 2 years 2f3 can be calculated as

2f3= ((1+ 5 year spot rate)^5/(1+2year spot rate)^2)^(1/3) -1

= (1.0629^5/1.0578^2)^(1/3) -1

=0.06631 or 6.63%

In general

The Forward rate for n year prevailing after x years xfn can be calculated as

xfn = ((1+(x+n) year spot rate)^(x+n)/(1+x year spot rate)^x)^(1/n)-1

jeff jeffy answered 2 years ago

using this, approximate formula, without the bond prices, how can we calculate future discount rates / forward rates in excel and I am stuck in (DR 11/20) in excel

1Y0.03832Y0.0515Y0.055910Y0.069120Y0.074630Y0.0744using this, approximate formula, without the bond prices, how can we calculate future discount rates / forward rates in excel and I am stuck in (DR 11/20) in excel(1+ DR1) (1+ DR2) = (1+YTM2)2

Using bond prices to calculate duration and convexity: A 20-year bond with a 6.5% coupon paid...

Using bond prices to calculate duration and convexity: A 20-year bond with a 6.5% coupon paid semiannually has a yield of 6.24%. Using a 1 bp change in yield, compute the approximate modified duration and approximate convexity of the bond. Using these, compute the approximate change in bond price when the bond yield increases by 150 bps. Calculate the exact change in bond price when the bond yield increases by 150 bps, and compare the two.

Using the below data calculate the quadratic formula. Then calculate the following: i) Fixed cost ii)...

Using the below data calculate the quadratic formula. Then calculate the following: i) Fixed cost ii) Average total cost iii) Marginal cost d) Using your answers from part c) calculate fixed cost, average total cost, and marginal cost if 25 units Coefficient Std. Error t-ratio p-value const 2.22486 2.29906 0.9677 0.3347 q 0.00434763 0.000230941 18.83 <0.0001 sq_q 1.63160e-08 2.79915e-09 5.829 <0.0001

What is Mirr? how do you find it using excel without using excel formula? Below is...

What is Mirr? how do you find it using excel without using excel formula? Below is cash flow. I found IRR is 15.59% and required return is 12% CF Y0 Y1 Y2 Y3 Y4 Y5 Y6 Capital spen $ (30,000,000.00) $ 15,062,400.00 Opp cost $ (5,000,000.00) NWC $ (1,120,000.00) $ (150,000.00) $ (170,000.00) $ 140,000.00 $ 1,300,000.00 OCF $ 9,015,600.00 $ 11,392,500.00 $ 12,193,200.00 $ 10,435,800.00 $ (2,640,000.00) $ (3,960,000.00) CF $ (36,120,000.00) $ 8,865,600.00 $ 11,222,500.00 $ 12,333,200.00 $...

Calculate the value of r using the computation formula (6.1) for the following data. X Y...

Calculate the value of r using the computation formula (6.1) for the following data. X Y 2 8 4 6 5 2 3 3 1 4 7 1 2 4 quan stat

1. Using bond market explain how the following events impact the bond prices and the interest...

1. Using bond market explain how the following events impact the bond prices and the interest rate: a) A war leads the government to increase spending on the military. (Assume taxes do not change). b) Someone invents a new kind of computer that makes firms more productive. Many firms want to buy the computer. Higher productivity also increases people’s confidence in the economy, so consumers see less need to save. c) The economy experiences a business cycle expansion. d) The...

Using the below question and values how do you calculate the standard deviation without using a...

Using the below question and values how do you calculate the standard deviation without using a calculator (by hand) of (s1^2/n1+s2^2/n2) with the standard deviation answer being 1.4938 and 1.1361 /sqrt(1.4938^2/10 + 1.1361^2/10) Choose two competing store and compare the prices of 10 items at both stores. Preform a two-sample hypothesis test to try an prove if one store is more expensive than the other based on your sample. Store A item #1-$5.49, #2 $3.77, #3 $0.87, #4 $3.29, #5...

(Try to work this question WITHOUT using Excel, get answer by using the formula and show...

(Try to work this question WITHOUT using Excel, get answer by using the formula and show the calculations in detail) Question (Retirement planning) You have just graduated Hofstra University at age 22. You hard work has paid off as you already have a job as an investment banker at Goldman Sachs waiting for you. You plan to work continuously until age 65 and retire exactly on that day. You expect to live until exactly 90 and enjoy your golden years...

How to read stock and bond prices? how do you evaluate stock dividends, bond prices, and...

How to read stock and bond prices? how do you evaluate stock dividends, bond prices, and ROI of mutual funds.

How to calculate Return on Equity？（I just want to learn the formula, no specific data） If...

How to calculate Return on Equity？（I just want to learn the formula, no specific data） If the return on equity is low, how can it be improved? Net Earnings per share Retained earnings, beginning of the year Dividends paid Selling and Admin Expense Operating Profit Interest Expense Income Taxes Net Earnings Retained earnings, end of year Net Sales Cost of goods sold Other income (expense), net Earnings before income taxes