$**$Please answer in it's entirety with current stats, Thank you$**$

To start off, pick an S&P $500$ company that has paid a dividend in the last year ${?}^1.$ For your chosen

company, proceed to answer the questions below. The questions are a mix of qualitative and

quantitative questions. For questions requiring calculations, be sure to show your work. If you do

not show your work you will not get full credit. Please let me know if you have any questions.

Section $1$: Getting to Know Your Company

What is your company, and what is its ticker symbol?

What industry is your company in$?$ What are two or three of its biggest competitors?

Briefly describe what the company does.

Compare your company's stock performance to the performance of the overall stock

market $($i$.$e$.$ S&P $500).$

Did your company under$-$perform or over$-$perform the overall stock market? Why do you

think this happened?

Section $2$: Your Company's Future

Look for recent news stories about your company. What are some major projects or

initiatives your company is considering? Why do you think your company is considering

these projects?

Do you think these potential investments would make sense for your company? Why or

why not? $($Note: For this question, you don't need to do any calculations. You just need

to discuss the project$($s$)$ from a business perspective.$)$

How do you think the overall stock market will perform over the next year? Be sure to

provide evidence to support your answer.

How do you think your company will perform compared to the overall stock market over

the next year? Be sure to provide evidence to support your answer.

Section $3$: Your Company's Capital Structure

Find the amount of long$-$term debt for your company based upon its latest $10$Q filing.

Find the book value of equity based on the company's latest $10Q$ filing.

Find the current market value $($i$.$e$.$ market capitalization$)$ of your company.

Why might the book value and market value of equity differ?

What is the weight of debt and equity in your company's capital structure?

Section $4$: Your Company's Debt Profile

What is your company's long$-$term credit rating?

What does the company's credit rating tell you about the company's risk of default?

How many different bonds does the company currently have outstanding?

Pick $3$ bonds. What is the maturity date of each bond?

Do any of the company's bonds have any special features $($e$.$g$.$ call provisions, sinking

fund requirements, conversions, etc.$)?$

What is the current yield$-$to$-$maturity for the most recently issued bond?

Section $5$: Your Company's Dividend History

What is your company's current annual dividend? $($Note: Most companies pay dividends

quarterly. You will need to add up the prior four dividends to get the annual amount.$)$

Determine the annual dividend for the past five years.

Is there a pattern to the dividends? Are the dividends constant, growing, or uneven?

What has been the average dividend growth rate over the last five years.

$25.$ Find the company's current stock price.

Using the information above, calculate the cost of equity using the dividend discount

model $($DDM$).$

Section $6$: Systematic Risk and Your Company

Estimate your company's beta. $($Note: You can download the historical stock return and

market return from Yahoo! Finance$)$

Find the current risk$-$free rate. How did you estimate the risk$-$free rate?

Assume the market risk premium is $5\mathrm{.}6\%.$ Using the information above, calculate the cost

of equity using the capital asset pricing model $($CAPM$).$

Section $7$: Calculating Your Company's Weighted Average Cost of Capital

Compare the cost of equity that you found using the DDM and the CAPM. Why might

you get two different estimates using the two different models?

Do you believe the DDM or the CAPM provides a better estimate of the cost of equity for

your company? Why?

Based on your company's most recent $10Q$ filing, what is its tax rate?

What is the WACC for your company?

Section $8$: Capital Budgeting

Suppose your company is considering two projects $($Project A & Project B$)$

Project A: This project is the introduction of a new product. It will require an upfront

investment of $10$ million dollars. At the end of year $1,$ the project will generate $2\mathrm{.}5$

million dollars in FCFs$.$ At the end of year $2,$ the project will generate $2\mathrm{.}6$ million dollars

in FCFs$.$ At the end of year $3,$ the project will generate $2\mathrm{.}7$ million dollars in FCFs$.$ At the

end of year $4,$ the project will generate $2\mathrm{.}8$ million dollars in FCFs$.$ At the end of year $5,$

the project will generate $3\mathrm{.}0$ million dollars in FCFs$.$ The project will generate no more

FCFs after year $5.$

Project B: This is an expansion of the company's main office. This project will require an

upfront investment of $4\mathrm{.}5$ million dollars. In year $1,$ the expansion will generate $0\mathrm{.}5$

million dollars in$.$ After the first year, FCFs will grow by $2\%$ each year forever.

Calculate the IRR of each project.

Calculate the NPV of each project

Calculate the Payback Period