1
answer
0
watching
180
views
11 Jan 2018
Using the company you have selected for your current event paper [or any publicly traded company of your choice], construct or set up an equation to calculate the expected or required rate of return for the company using the APT model. You may use hypothetical or estimated numbers to complete this conceptual problem. HINT:The goal here is for you to assess the relative significance of each of the factors that will affect the required or expected rate of return specific to your company and demonstrate you understand how this equation is actually used for investment analysis.
Using the company you have selected for your current event paper [or any publicly traded company of your choice], construct or set up an equation to calculate the expected or required rate of return for the company using the APT model. You may use hypothetical or estimated numbers to complete this conceptual problem. HINT:The goal here is for you to assess the relative significance of each of the factors that will affect the required or expected rate of return specific to your company and demonstrate you understand how this equation is actually used for investment analysis.
1
answer
0
watching
180
views
For unlimited access to Homework Help, a Homework+ subscription is required.
Tod ThielLv2
14 Jan 2018
Related questions
Suppose a beverage company is considering adding a new productline. | ||||||
Currently the company sells apple juice and they are consideringselling a fruit drink. | ||||||
Thefruit drink will have a selling price of $1.00 per jar. The planthas excess capacity in a | ||||||
fullydepreciated building to process the fruit drink. The fruit drinkwill be discontinued in four years. | ||||||
The newequipment is depreciated to zero using straight line depreciation.The new fruit drink requires | ||||||
anincrease in working capital of $25,000 and $5,000 of this increaseis offset with accounts payable. | ||||||
Projected sales are 150,000 jars of fruit drink the first year,with a 20 percent growth for the following years. | ||||||
Variablecosts are 55% of total revenues and fixed costs are $10,000 eachyear. The new equipment costs | ||||||
$195,000and has a salvage value of $25,000. | ||||||
Thecorporate tax rate is 35 percent and the company currently has1,000,000 shares of stock outstanding | ||||||
at acurrent price of $15. The company also has 50,000 bondsoutstanding, with a current price of $985. The | ||||||
bondspay interest semi-annually at the coupon rate is 6%. The bonds havea par value of $1,000 and will | ||||||
maturein twenty years. | ||||||
Eventhough the company has stock outstanding it is not publicly traded.Therefore, there is no publicly | ||||||
available financial information. However, management believes thatgiven the industry they | ||||||
are inthe most reasonable comparable publicly traded company is CottCorporation (ticker symble | ||||||
is COT).In addition, management believes the S&P 500 is a reasonableproxy for the market portfolio. | ||||||
Therefore, the cost of equity is calculated using the beta from COTand the market risk premium based on the | ||||||
S&P500 annual expected rate of return. (We calculated a monthlyexpected return for the market | ||||||
in thereturn exercise. You can simply multiply that rate by 12 for anexpected annual rate on the | ||||||
market.)The WACC is then calculated using this information and the otherinformation provided | ||||||
above.Clearly show all your calculations and sources for all parameterestimates used in the WACC. | ||||||
Required | ||||||
1.Calculate the WACC for the company. | ||||||
2.Create a partial income statement incremental cash flows from thisproject in the | ||||||
Blank Template worksheet using the tabbelow. | ||||||
3. Enterformulas to calculate the NPV by finding the PV of the cash flowsover the next four years. | ||||||
(You can either use the EXCEL formula PV() or usemathmatical formula for PV of a lump sum.) | ||||||
4. Setup the EXCEL worksheet so that you are able to change theparameters in E3 to E12. | ||||||
Run three cases best, most likely, and worstcase where the growth rate is 30%, 20%, and 5%, | ||||||
respectfully. | ||||||
5.Create a NPV profile for the most likely case scenario. (See NPVCalculation tab below.) | ||||||
6. Statewhether the company should accept or reject the project for eachcase scenario. |