Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please show the formulas in the excel You are to calculate the CAPM cost of equity (as we did in class) for P&G (ticker: PG).

Please show the formulas in the excel

You are to calculate the CAPM cost of equity (as we did in class) for P&G (ticker: PG). Use data for the S&P500 for the market return (ticker: ^GSPC). Use data for the 10 year treasury note for the risk-free rate (ticker: ^TNX). Download all of this data from Yahoo! Finance. Remember that you will need to make adjustments to this data, as we did in class (when we used Apple's stock prices as a starting point to calculate the CAPM CoE for our fake company). You want to use the most recent 60 months of data for stock returns to estimate the CAPM CoE, like we did in class. You also need to calculate P&G's cost of debt, as we did in class. Download P&G's bond data from Morningstar (if you have trouble finding it, google "morningstar PG bond data" and it should be the first result). For the debt and equity weights, use the reported debt % on morningstar (as we did in class), but calculate the equity weight as 1 minus the debt weight (or add the preferred stock % to the equity %, and use that total as the Equity %). Assume an effective tax rate of 35%. Then calculate P&G's WACC,

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Finance questions