You are considering making an investment in a project in the foods and beverages industry. You determine that the project has the same level of non-diversifiable risk as investing in Coca-Cola stock. (Use the annual risk free rate of 1%.)
| Factors | Factor Betas (Annual) | Factor Risk Premium Annual (%) |
|
Market Risk |
0.80 | 0.51 |
| Size | 0.76 | 0.27 |
| Value | 0.55 | 0.36 |
| RMW | 0.23 | 0.25 |
| MOM | -0.28 | 0.69 |
| CMA | 0.45 | 0.32 |
(a) Calculate the expected return of Coca-Cola based on single index model (alpha=0.01)?
(b) Calculate the expected returns of Coca-Cola based on Fama-French 3 factor model?
(c) Calculate the expected returns of Coca-Cola based on Fama-French-Carhart model?
(d) Calculate the expected returns of Coca-Cola based on Fama-French 5 factor model?
You are considering making an investment in a project in the foods and beverages industry. You...
I would like to know how to solve these questions step by step
on excel. How do you do that?
Consider the data contained in the table below, which lists 30
monthly excess returns to two different actively managed stock
portfolios (A and B) and three different common risk factors (1, 2,
and 3). (Note: You may find it useful to use a computer spreadsheet
program such as Microsoft Excel to calculate your answers.)
Period Porttolio A Porttolio B Factor...
I need assistance answering the following questions based on the
Coca Cola's Debt-To-Equity, Interest Coverage, and
Debt-To-Total-Asset ratios attached from the last 5 years which i
highlighted. Thanks in advance...
How is Coca Cola financing its assets? How much risk is
associated with the bonds issued by the company? How can this risk
be measured? Please explain.
Profitability TTM Tax Rate % Net Margin % 2009-12 22.80 22.02 0.69 15.30 1.96 30.15 20.79 26.20 Asset Turnover (Average) Return on Assets...
Beta Expected Return (%) 16.0 12.9 12.2 11.4 11.3 10.1 10.0 9.8 9.6 U.S. Steel Disney Ford General Electric Monsanto Boeing Union Pacific Alphabet Exxon Mobil Amazon Intel Pfizer Starbucks IBM McDonald's Coca-Cola Campbell Soup Walmart Newmont Mining PG&E 1.85 1.42 1.31 1.20 1.19 1.01 1.00 0.96 0.94 0.93 0.91 0.90 0.79 0.59 0.51 0.49 0.47 0.26 0.24 0.23 9.5 9.4 9.3 8.5 7.1 6.6 6.4 6.3 4.8 4.7 4.6 - UNIPUL PULJ ( (0) W uPorn 13. CAPM and...
Beta Expected Return (%) 16.0 12.9 12.2 11.4 11.3 10.1 10.0 9.8 9.6 U.S. Steel Disney Ford General Electric Monsanto Boeing Union Pacific Alphabet Exxon Mobil Amazon Intel Pfizer Starbucks IBM McDonald's Coca-Cola Campbell Soup Walmart Newmont Mining PG&E 1.85 1.42 1.31 1.20 1.19 1.01 1.00 0.96 0.94 0.93 0.91 0.90 0.79 0.59 0.51 0.49 0.47 0.26 0.24 0.23 9.5 9.4 9.3 8.5 7.1 6.6 6.4 6.3 4.8 4.7 4.6 - UNIPUL PULJ ( (0) W uPorn 13. CAPM and...
solve without using excel.
show work please.
Beta Expected Return (%) 16.0 12.9 12.2 11.4 11.3 10.1 10.0 9.8 U.S. Steel Disney Ford General Electric Monsanto Boeing Union Pacific Alphabet Exxon Mobil Amazon Intel Pfizer Starbucks IBM McDonald's Coca-Cola Campbell Soup Walmart Newmont Mining PG&E 1.85 1.42 1.31 1.20 1.19 1.01 1.00 0.96 0.94 0.93 0.91 0.90 0.79 0.59 0.51 0.49 0.47 0.26 0.24 0.23 9.6 9.5 9.4 9.3 8.5 7.1 6.6 6.4 6.3 4.8 4.7 4.6 c. Now repeat...
You and your team are financial consultants who have been hired by a large, publicly traded electronics firm, Brilliant Electronics (BE), a leader in its industry. The company is looking into manufacturing its new product, a machine using sophisticated state of the art technology developed by BE’s R&D team, overseas. This overseas project will last five years. They’ve asked you to evaluate this project and to make a recommendation about whether or not the company should pursue it. BE’s management...
Comprehensive/Spreadsheet Problem 12-18 NEW PROJECT ANALYSIS You must analyze a potential new product-a caulking com- pound that Cory Materials' R&D people developed for use in the residential construction industry Cory's marketing manager thinks the company can sell 115,000 tubes per year at a price of $3.25 each for 3 years, after which the product will be obsolete. The purchase price of the required equipment, including shipping and installation costs, is $175,000, and the equipment is eligible for 100% bonus depreciation...
Please show workings. Thank you 1 Company A has a capital structure as shown below. Calculate its weighted average cost of capital. K Dollars Retained Earnings 13.25% 5,000 Common Stock 10.35% 13,500 Preferred Stock 7.25% 2,500 Debt (before tax) 6.81% 6,375 27,375 a 11.05% b 10.52% c 10.27% d 9.77% 2 A bond with a $1,000 par value has an 6.25% coupon rate. It will mature in 5 years, and coupon payments are made semi-annually. The current price is 873.50....