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...
-
Your client, Connie, won $12,000 in a football office pool. She sees no reason to include it in her income for several reasons. First, the amount won will not be reported to the IRS. Second, as an...
-
The variable Y is normally distributed. Given that 10 = 3 and P(Y < 10) = 0.75, find P(Y 6).
-
Is there a relationship between the number of accounting standards issued and demand for accounting and auditing services? Explain this relationship. Given this relationship, should environmental...
-
Calculating EAR with Points you are looking at a one-year loan of $10,000. The interest rate is quoted as 9 percent plus three points. A point on a loan is simply 1 percent (one percentage point) of...
-
Spinners, Co. manufactures wheel rims. The accounting office will be following ABC allocation rates for 2021. Activity Allocation Base Predetermined Overhead Allocation Rate Materials Handling Number...
-
Bob Burley and his brother Buford ran the best restaurant in Dallas, Texas. Many out-of-towners would visit Dallas and go to Burleys Biscuits, Beef, and Veggies for a good wholesome meal. One thing...
-
The first production department of Stone Incorporated reports the following for April. Direct Materials. Conversion Units Beginning work in process inventory 82,000 Percent Complete 70% Percent...
-
(2 points) Suppose a bank is holding the following portfolio of over-the-counter options on a certain stock: Type 3-m call Position Long 500 units Delta of option Gamma of option 0.50 0.16 6-m put...
-
BMX Company has one employee. FICA Social Security taxes are 6.2% of the first $137,700 paid to its employee, and FICA Medicare taxes are 1.45% of gross pay. For BMX, its FUTA taxes are 0.6% and SUTA...
-
How can validity and reliability of an outcome associated with changes you might introduce in this problem area context, and how an outcome might be impacted by the relatively short time window in...
-
Lasil Payments Check Number Cash Credit 5901 1,846 5902 740 5903 399 5904 2,044 5905 935 5906 1,040 5907 244 5908 384 5909 1,882 9,514 Cash Account Number 101 Date August 31 Explanation PR Debit...
-
Sheridan Company is considering three capital expenditure projects. Relevant data for the projects are as follows. Project Investment Annual Income Life of Project 22A $242,200 $16,890 6 years 23A...
-
(SF) Credit Union was incorporated in Ghana in July P the authorized capital of 2,000,000 equity shares of no-par value, of which 1,000,000 shares have been issued for a cash consideration of GH9.5...
-
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?
-
The life \(T\) in hours of a vibration transducer is found to follow exponential distribution \[p_{T}(t)= \begin{cases}\lambda e^{-\lambda t}, & t \geq 0 \\ 0, & t <0\end{cases}\] where \(\lambda\)...
-
Fill in the Blank. If any parameter of a vibrating system is not known precisely, the resulting vibration is called ____________ vibration.
-
The probability distribution function, \(P(\widetilde{x})\), denotes a. \(P(x \leq \tilde{x})\) b. \(P(x>\widetilde{x})\) c. \(P(\tilde{x} \leq x \leq \tilde{x}+\Delta x)\)
Study smarter with the SolutionInn App