• Perform a detailed stock price analysis on your company's stock, and
• Calculate and analyze the company's Weighted Average Cost of Capital (WACC)

1. Stock Price Analysis:
2. Monthly Stock Price Analysis:

• In Yahoo! Finance go to theHistorical Pricespage and import into Excel the last 5 years of monthly stock prices (use the ending date as of the end of the previous month). For the below activities use theadjusting closed price("Adj Close")
• What is the current stock price? What were the highest and lowest stock price values during this period?
• For the remaining items in this section you will analyze the Year-Over-Year returns. In your spreadsheet, calculate theYear-Over-Year(YoY) return for each month. (Please submit this worksheet in Excel with your written paper.) The calculation for this is:
• (month - same month prior year) / (same month prior year)
• What were the highest and lowest YoY returns during this period?
• Calculate the mean or average of these YoY returns from your sample.
• Calculate the standard deviation of the YoY returns. (In Excel, use the STDEV function.)

1. Graphical View of Variability:

• In Yahoo! Finance go to theBasic Chartfor your company. Select the 5 year ("5Y") Range of the chart. In the Compare line select theS&P 500and then press the "Compare" button.
• Copy and paste this chart into this section of your paper.
• Interpret your observations. Does the general movement of your company's returns follow that of the S&P 500? Is the company's stock price today higher than the company's stock price at the beginning of this 5 year period?

1. Analysis of WACC
2. Calculation of WACC for your company
3. You will need to identify each component of the WACC formula and calculate the overall WACC.
4. The WACC formula for a company that uses debt and equity is as follows:
5. WACC = % Debt * Cost of Debt * (1 - Tax Rate) + % Equity * Cost of Equity
7. You should use Yahoo! Finance and / or the company's most recent 10K report to identify all financial statement inputs. You can use the following guide for the inputs. The specific financial statement data are found on the relevant financial statement.

• Debt= Long-term Debt + Short-term Debt (on Yahoo! this is called, "Short/Current Long Term Debt")
• Equity= Market Cap. (This is on the Key Statistics page in Yahoo! Finance)
• % Debt= Debt / (Debt + Equity)
• % Equity= 1 - % Debt
• Cost of Debt= Interest Expense / Debt
• Tax Rate= Income Tax Expense / Income Before Tax
• Cost of Equity: Use the CAPM equation to calculate this
• Cost of Equity = Risk free rate + Beta * (Market Risk Premium)
• Risk free rate: look up the yield on 10 year US Treasury bonds
• Beta: This is on the Key Statistics page in Yahoo! Finance
• Market Risk Premium: Assume 11% minus the risk-free rate

What is the current stock price? The current stock price is 138.06. What were the highest and lowest stock price values during this period? 146.99 on February 14, 2020 . lowest stock price is Low93.93 during the 5-year time frame. What were the highest and lowest YoY returns during this period? The highest YoY return is xxxxxxx and the lowest YoY returns is xxxxxx. The mean of YoY is XXXXX.The standard deviation of the YoY returns is xxxxxxxx.

Graphical View of Variability

From the time series plot, we see that the stock price for the Pepsi Company has been increasing significantly for five years hence there is a positive trend in the costs of the Pepsi stock for the last five years. This is seen by the fact that at the beginning of the five-year period which is in the end of October 30 2015 the stock price was valued at 102.19 up to the current time which is on October 4, 2020, where the price is valued at 138.06 dollars.