Reference no: EM131049340 , Length:
Your group will be assigned a publicly listed company in the USA and you need to compute the company's overall weighted average cost of capital (WACC). Write up your analysis (should not exceed 2 pages) adhering to the following steps:
Our company is The Coca-Cola Company
1) Estimation of the risk free rate (provide the value, source, date, as well as short explanation behind your choice)
2) Estimation of the equity market risk premium (you can use here 5.5% for the American publicly listed companies),
3) Estimation of beta (provide the value , the source, and date)
4) Estimation of the upcoming dividend and growth in dividends if applicable ( provide the value, source, as well as a short explanation behind your estimation)
5) Computation of your estimated cost of common equity
6) Computation of your estimated cost of preferred equity if applicable (provide the source and date of data as well as an explanation behind your estimation).
7) Estimation of cost of debt (provide the value as well as a short explanation behind that)
8) Estimation of the WACC (describing in detail how you got the target capital structure weights, including the sources and dates of when the information was gathered).
9) Explain what the WACC means, how can you use it in decisions, and do you think that you got a reasonable estimate.
Useful Data Sources:
- To get the US treasury bills and bonds rates go to :www.ustreas.gov
- To get the company's stock price and beta visit MSN money, Yahoo Finance, or any other finance web source of your choice
- To get the company's financial statements, go to the company's website, or the SEC website- Filings - Edgar search tools (https://www.sec.gov/edgar/searchedgar/webusers.htm#.U3Jnfv1OXIU). Search for form 10 K (annual report).
- To get the company's credit risk rating, go to Standard and Poors, or Moody's www.moodys.com . You will have to register first, it is free, they will send you an email, you can activate your account by clicking on the link that they will send to your email.
- To get the default risk premium rates go to Damodaran'swebsite ( https://damodaran.com ) , go to capital structure, and then Ratings, spreads, and Interest coverage rates.
Write a script that creates a cursor for a result set
: Write a script that creates a cursor for a result set that consists of the ProductName and ListPrice columns for each product with a list price that's greater than $700.
|
At what price is the stock selling
: Favored stock will pay a dividend this year of $2.88 per share. Its dividend yield is 8%. At what price is the stock selling? (Do not round intermediate calculations.)
|
Maturity of the bonds-what is the price of the bond now
: Several years ago, Castles in the Sand Inc. issued bonds at face value of $1,000 at a yield to maturity of 5.8%. Now, with 5 years left until the maturity of the bonds, the company has run into hard times and the yield to maturity on the bonds has in..
|
What was plylers equity multiplier
: Assuming that all Plyler’s sales are on credit, what was the company’s Days Sales Outstanding in 2015? (For balance sheet accounts, use the average of the beginning and end-of-year balances). What was Plyler’s Equity Multiplier for 2015?
|
Explain what the wacc means
: BUS 420 - Corporate Finance - Explain what the WACC means, how can you use it in decisions, and do you think that you got a reasonable estimate.
|
Write a program to test the functions by computing function
: Write a program to test the functions by computing F = 5 tanh(ax) + 4 cos(ax) where 0 ≤ x
|
Issue additional bonds to the public at face value
: General Matter’s outstanding bond issue has a coupon rate of 9%, and it sells at a yield to maturity of 7.40%. The firm wishes to issue additional bonds to the public at face value. What coupon rate must the new bonds offer in order to sell at face v..
|
Consider for a moment a midlevel manager
: Consider for a moment a midlevel manager at a multinational foods company, Fatima, who would seem to be at the top of her career. She's consistently making her required benchmarks and goals, she has built successful relationships with colleagues, ..
|
Explain the different transactions in inventory
: Explain the different Transactions in Inventory – Sub Inventory Transfers, Inter Org transfers, Miscellaneous Transactions and Move Orders. Explain the different Inventory Controls – Locator, Lot, Serial and Revision. Explain Receiving Functionality ..
|