Preview

Problema de en excel

Satisfactory Essays
Open Document
Open Document
547 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Problema de en excel
Michelle_Perez_ADCO5190_CH1_P08

4/2/2003

Chapter 1. Ch 01 P08 Build a Model
a. Suppose you are considering two possible investment opportunities, a 12-year Treasury bond and a 7-year,
A-rated corporate bond. The current real risk-free rate is 4%. Inflation is expected to be 2% for the next two years, 3% for the following four years, and 4% thereafter. The maturity risk premium is estimated by this formula:MRP = 0.1% ( t-1) %. The liquidity premium for the corporate bond is estimated to be 0.7%. Finally, you may determine the default risk premium, given the company’s bond rating, from the default risk premium table in the text. What yield would you predict for each of these two investments?
Treasury Bond
Risk-free rate

=

4.00%

Maturity:
Expected inflation:
Expected inflation:
Expected inflation:

12 for the next for the next for the next

Inflation premium =

2 years =
4
years =
6
years =
12
((G17*D17)+(G18*D18)+(G19*D19))/D20

3.33%

Maturity risk premium

=

1.1%

0.1*(C16-1)%

12-year Treasury yield=

2%
3%
4%

8.43%

7-year corporate bond
Rating :
A
Risk-free rate

=

Maturity:
Expected inflation:
Expected inflation:
Expected inflation:
Inflation premium =

4%
7
for the next for the next for the next

2 years =
4
years =
1
years =
7
((G33*D33)+(G34*D34)+(G35*D35))/D36

2%
3%
4%
2.86%

Maturity risk premium= 0.1*(C32-1)%
0.60%
Liquidity premium=
0.7%
Default risk premium= IF(B28=H38,I38,IF(B28=H39,I39,IF(B28=H40,I40,IF(B28=H41,I41))))
1.5%
(see screen to right for an alternative way to find the default risk premium.)
7 year Corporate yield=
9.66%
Yield Spread = Corporate - Treasury =
R:econciliation:
Default premium
Liquidity premium
Inflation premium
Maturity premium

1.224%
1.500%
0.700%
-0.476%
-0.500%
1.224%

Default Risk from text table:
Rating
DRP
AAA
1.0%
AA
1.2%
A
1.5%
BBB
1.9%
BB+
3.7%

b. Given the following Treasury

You May Also Find These Documents Helpful

  • Powerful Essays

    20-year current yields should be used as market risk free rate since it has the longest period, which is equal to 5.74%…

    • 776 Words
    • 4 Pages
    Powerful Essays
  • Powerful Essays

    1. Currently Teletech Corporation (TC) uses a single hurdle rate for both their Telecommunications Services (TS) and Products and Services (P&S) divisions. This hurdle rate obtained by an estimate of TC Weighted Average Cost of Capital (WACC), which is calculated at 9.3%. When analyzing critically at this point, TS is underperforming with a return on capital (ROC) of 9.1%, whereas, P&S segment is well over the required rate of return as it is gaining a ROC of 11.0%. As a result, the firm’ share price is inactive. Their price-to-earning is far below investor’s expectation in comparison to the firm’s risk. The use of a single constant hurdle rate brings about an uncorrelation between risk and return. With an approx. $2 billion being invested in the upcoming years, the discount rate is significantly important in order to make investment decision on profitable projects, that will increase shareholder’s value.…

    • 937 Words
    • 4 Pages
    Powerful Essays
  • Good Essays

    Investment Test Questions

    • 3071 Words
    • 13 Pages

    3. Which one of the following had the smallest standard deviation of returns for the period 1926-2006?…

    • 3071 Words
    • 13 Pages
    Good Essays
  • Satisfactory Essays

    Homework: Zero Coupon Bond

    • 1493 Words
    • 6 Pages

    the prices quoted in part B. Which bond has a higher yield to maturity at these prices?…

    • 1493 Words
    • 6 Pages
    Satisfactory Essays
  • Good Essays

    Bond Valuation

    • 694 Words
    • 3 Pages

    Bond C has an 11% annual coupon, matures in 12 years, and has a $1000 face value.…

    • 694 Words
    • 3 Pages
    Good Essays
  • Satisfactory Essays

    Lyon Case

    • 337 Words
    • 2 Pages

    What is the current market value of the bonds outstanding at the current effective interest rate of 6%?…

    • 337 Words
    • 2 Pages
    Satisfactory Essays
  • Good Essays

    Calaveras Vineyards

    • 733 Words
    • 3 Pages

    The risk premium used was the expected return of small companies less the return of long term government bonds, which was 7.4% historically from 1926 to 1992.…

    • 733 Words
    • 3 Pages
    Good Essays
  • Satisfactory Essays

    Midland Energy Resources

    • 541 Words
    • 4 Pages

    We assume that the company will run for next 30years, so the rate of risk free is 4.98%…

    • 541 Words
    • 4 Pages
    Satisfactory Essays
  • Satisfactory Essays

    By doing this we assume: the Market risk premium during 2001 would be 6.4%. Acctually, according to the lecturer, the risk premium during year 1998-2008 should be within the range of 4% to 8%. Therefore the assumption of 6.5% seems probable.…

    • 380 Words
    • 2 Pages
    Satisfactory Essays
  • Good Essays

    Income statement

    • 562 Words
    • 3 Pages

    9. Compare the value of the Sleeping and Napping bonds for market yields to maturity from 2% to 20%.…

    • 562 Words
    • 3 Pages
    Good Essays
  • Satisfactory Essays

    Stock and Ans

    • 1069 Words
    • 5 Pages

    11. If the real rate is 4% and the inflation rate is 10%, what is the…

    • 1069 Words
    • 5 Pages
    Satisfactory Essays
  • Good Essays

    FIN 203 Final Review

    • 1193 Words
    • 5 Pages

    You are considering adding another stock, DNKN, with a beta of 1.3 to the portfolio. The market risk…

    • 1193 Words
    • 5 Pages
    Good Essays
  • Good Essays

    Borrowing Cost

    • 556 Words
    • 3 Pages

    The market yield on the purchase date expressed at a simple rate of interest (% p.a.).;…

    • 556 Words
    • 3 Pages
    Good Essays
  • Satisfactory Essays

    Filmore Enterprises

    • 1413 Words
    • 6 Pages

    c. The returns on corporate bonds that Filmore Enterprises might issue are all higher than T-bonds, which is 7.70%, 8.90% respectively; my answer would dependent on the potential bond rating of Filmore Enterprises.…

    • 1413 Words
    • 6 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Stock Market and Cost

    • 1084 Words
    • 5 Pages

    2) A 10 year, 8% Rs.1,000 per bond sold at Rs.950 less 4% underwriting commission. -C…

    • 1084 Words
    • 5 Pages
    Satisfactory Essays