Aa2/AA A2/A Rating Aaa/AAA 21 30 32 58 43 Baal/BBB+ 96 111 Ba2/BB 172 272 Daily...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Aa2/AA A2/A Rating Aaa/AAA 21 30 32 58 43 Baal/BBB+ 96 111 Ba2/BB 172 272 "Daily Treasury Yield Curve Rates" as the type of interest rate and "Current Month" as the time period. Highlight the entire data table including the headers, copy and paste it into Excel. Remember to use "Match Destination Formatting (M)" as the paste option. 2. The current yield spreads for the various bond ratings are shown below. 1 2 3 year years years years 7 8 9 10 years years years years 55 61 65 70 76 26 38 45 53 72 83 95 121 79 92 102 115 147 144 153 160 178 204 230 253 277 269 269 240 200 331 346 343 335 336 341 349 361 364 364 304 4 5 6 years years 53 42 71 132 65 88 108 131 12 15 20 25 30 years years years years years 84 99 122 127 121 137 149 153 146 114 165 175 175 162 141 Copy the table above and paste it to the same file as the Treasury yields from previous step. 3. Find the current bond rating for Enel Generacion Chile. Go to Standard & Poor's Web site (www. standardandpoors.com), select "Find a Rating" from the list at the left of the page, then select "Credit Ratings Search." At this point, you will have to register (it's free) or enter a username and password provided by your instructor. Next, you will be able to search by organization name - enter Enel Generacion Chile and select accordingly. Use the credit rating of the organization, not the specific issue ratings. 4. Return to Excel and create a time with the cash flows and discount rates you will need to value the new bond issue. a. To create the required spot rates for the Enel Generacion Chile issue, add the appropriate spread to the Treasury yield of the same maturity. b. The yield curve and spread rates you have found do not cover every year that you will need for the new bonds. Fill in these by linearly interpolating the given yields and spreads. For ex- ample, the four-year spot rate and spread will be the average of the three- and five-year rates. c. To compute the spot rates for Enel Generacion Chile's current debt rating, add the yield spread to the Treasury rate for each maturity. However, note that the spread is in basis points, which are 1/100th of a percentage point. d. Compute the cash flows that would be paid to bondholders each year and add them to the timeline. 5. Use the spot rates to calculate the present value of each cash flow paid to the bondholders. 6. Compare the issue price of the bond and its initial yield to maturity. 7. Repeat Steps 4-6 based on the assumption that Enel Generacion Chile is able to raise its bond rating by one level. Compute the new yield based on the higher rating and the new bond price that would result. 8. Compute the additional cash proceeds that could be raised from the issue if the rating were improved. Data Case Corporate Yield Curves You are an intern with Enel Generacion Chile, the largest electric utility company in Chile, in their corporate finance division. The firm is planning to issue $100 million of 7.875% annual coupon bonds with a 10-year maturity in the United States. The firm anticipates an increase in its bond rating. Your immediate superior wants you to determine the gain in the proceeds of the new issue if the issue is rated above the firm's current bond rating. To prepare the necessary information, you will need to determine Enel Generacion Chile's current debt rating and the yield curve of their particular rating. 1. You begin by finding the current U.S. Treasury yield curve. At the Treasury Web site (www.treas .gov), search using the term "yield curve" and select "Daily Treasury Yield Curve Rates." Choose Aa2/AA A2/A Rating Aaa/AAA 21 30 32 58 43 Baal/BBB+ 96 111 Ba2/BB 172 272 "Daily Treasury Yield Curve Rates" as the type of interest rate and "Current Month" as the time period. Highlight the entire data table including the headers, copy and paste it into Excel. Remember to use "Match Destination Formatting (M)" as the paste option. 2. The current yield spreads for the various bond ratings are shown below. 1 2 3 year years years years 7 8 9 10 years years years years 55 61 65 70 76 26 38 45 53 72 83 95 121 79 92 102 115 147 144 153 160 178 204 230 253 277 269 269 240 200 331 346 343 335 336 341 349 361 364 364 304 4 5 6 years years 53 42 71 132 65 88 108 131 12 15 20 25 30 years years years years years 84 99 122 127 121 137 149 153 146 114 165 175 175 162 141 Copy the table above and paste it to the same file as the Treasury yields from previous step. 3. Find the current bond rating for Enel Generacion Chile. Go to Standard & Poor's Web site (www. standardandpoors.com), select "Find a Rating" from the list at the left of the page, then select "Credit Ratings Search." At this point, you will have to register (it's free) or enter a username and password provided by your instructor. Next, you will be able to search by organization name - enter Enel Generacion Chile and select accordingly. Use the credit rating of the organization, not the specific issue ratings. 4. Return to Excel and create a time with the cash flows and discount rates you will need to value the new bond issue. a. To create the required spot rates for the Enel Generacion Chile issue, add the appropriate spread to the Treasury yield of the same maturity. b. The yield curve and spread rates you have found do not cover every year that you will need for the new bonds. Fill in these by linearly interpolating the given yields and spreads. For ex- ample, the four-year spot rate and spread will be the average of the three- and five-year rates. c. To compute the spot rates for Enel Generacion Chile's current debt rating, add the yield spread to the Treasury rate for each maturity. However, note that the spread is in basis points, which are 1/100th of a percentage point. d. Compute the cash flows that would be paid to bondholders each year and add them to the timeline. 5. Use the spot rates to calculate the present value of each cash flow paid to the bondholders. 6. Compare the issue price of the bond and its initial yield to maturity. 7. Repeat Steps 4-6 based on the assumption that Enel Generacion Chile is able to raise its bond rating by one level. Compute the new yield based on the higher rating and the new bond price that would result. 8. Compute the additional cash proceeds that could be raised from the issue if the rating were improved. Data Case Corporate Yield Curves You are an intern with Enel Generacion Chile, the largest electric utility company in Chile, in their corporate finance division. The firm is planning to issue $100 million of 7.875% annual coupon bonds with a 10-year maturity in the United States. The firm anticipates an increase in its bond rating. Your immediate superior wants you to determine the gain in the proceeds of the new issue if the issue is rated above the firm's current bond rating. To prepare the necessary information, you will need to determine Enel Generacion Chile's current debt rating and the yield curve of their particular rating. 1. You begin by finding the current U.S. Treasury yield curve. At the Treasury Web site (www.treas .gov), search using the term "yield curve" and select "Daily Treasury Yield Curve Rates." Choose
Expert Answer:
Answer rating: 100% (QA)
1 Here is the Daily Treasury Yield Curve Rates table copied from the US Treasury website and pasted into Excel using Match Destination Formatting Dail... View the full answer
Related Book For
Fundamentals Of Corporate Finance
ISBN: 9780135811603
5th Edition
Authors: Jonathan Berk, Peter DeMarzo, Jarrad Harford
Posted Date:
Students also viewed these finance questions
-
Tim Trepid is highly risk-averse while Mike Macho actually enjoys taking a risk. Returns: Expected Investments Value Standard Deviation Buy stocks $ 8,880 $ 6,030 Buy bonds 7,720 2,050 Buy commodity...
-
Dana, runs an illegal gambling joint and here are her expenses and income. Gross income $300,000 Expenses: Rent $30,000 Maintenance $6000 Bribes to police $20,000 Supplies. $4,000 Food and drink...
-
Identify two specific examples of Jim Crow Legislation in the South during the early Twentieth Century.
-
Bingl is one the provinces in Turkey with a very high earthquake risk, since the city center is located on the fault and is very close to the East Anatolian Fault Zone, which is also one of the most...
-
Aluminum trichloride (AICI3) dissolves in ether with the evolution of a large amount of heat. (In fact, this reaction can become rather violent if it gets too warm.) Show the structure of the...
-
Liu Corporation had the following transactions in debt instruments purchased to earn interest during ended December 31, 2017: Jan. 1 Purchased a 180-day (six-month) Government of Canada treasury bill...
-
Overhead cost of products Florette Company applies manufacturing overhead using di- rect labor hours as the application base. In 1992, budgeted overhead was $868,000 and budgeted direct labor was...
-
Kimberly is a developer of apartment complexes. Two years ago, she formed Deckside Apartments, a partnership, and initiates development of the Deckside Apartments complex. The Staten Investment Fund...
-
Steve and Mark operate a partnership selling cricket equipment. They are equal partners in a partnership. The partnership has an accounting net profit of $ 1 5 0 , 0 0 0 . Relevant figures in...
-
Apple Corporation uses customers served as its measure of activity. Its budget assumption and actual customers served are shown below as well as the static budget assumptions for the month...
-
Identify the ratios that may be used in applying analytical procedures to stockholders' equity balances.
-
What is sampling?
-
We are the market leader in our field, said Mark Hansen, CEO of Gosport Shipbuilding Inc. (GSI). I built this company from the ground up. I know more about constructing gambling ships than anybody in...
-
What is a point estimate?
-
Ill stick with you through thick and thin, or What have you done for me lately? Which best describes the attitude of customers in todays marketplace? Two quality managers are debating the concept of...
-
NVIDIA Corporation provided the following financial data for the fiscal year ending January 31, 2023: Total Revenue of $29,460 million, Cost of Goods Sold (COGS) of $11,380 million, Operating...
-
After looking at the resources, explain what a spirit image is. Why might looking at a god and/or a human in terms of their spirit be helpful if you want to eliminate some of the divisions between...
-
The Jones Company has just completed the third year of a five-year MACRS recovery period for a piece of equipment it originally purchased for $300,000. a. What is the book value of the equipment? b....
-
If your bank pays you 1.5% interest and you deposit $500 today, what will your balance be in 5 years?
-
What is GAAP and who oversees it?
-
Might financial value creation be an appropriate goal for not-for-profit businesses? Explain.
-
Richmond Clinic has obtained the following estimates for its costs of debt and equity at various capital structures: What is the firms optimal capital structure? (Hint: Calculate its corporate cost...
-
Describe four indicators commonly used in operating indicator analysis.
Study smarter with the SolutionInn App