Choose your favorite publicly-traded company other than Facebook that we did in class. Then, do the...

Choose your favorite publicly-traded company other than Facebook that we did in class. Then, do the following: 1) Calculate its beta using three-year historical prices 2) Calculate its re (cost of equity) 3) Calculate its rd (cost of debt) 4) Find out how much debt is has (see balance sheet and the notes that accompany it) 5) Calculate its market capitalization 6) Using the above information, calculate its WACC Please show all of your computations and submit the Excel file.

Solutions

Expert Solution

Answer: I am choosing Amazon Inc.

Calculating Cost of Equity (Re) with the help of CAPM-

Re = Rf + Beta (Rm-Rf)

Where Re is cost of equity, Beta is the senstivity of return, Rf is risk free return, (Rm-Rf) is also called market risk premium.

Risk free rate of return = 10 year treasury constant maturity rate that is .62%

Market risk premium is 6% and Amazon's Beta is 1.54

Putting all the values in the formula, we get:

Re = .62% + 1.54 (6%)

Re = 9.86%

Calculating cost of debt (Rd)

Rd = Last year's interest expense / Book value of llast two years debt (Data as on Dec. 2019)

Rd = $1600 Million / $48175 Million

Rd = 3.3212%

Latest two years average Tax rate is 13.81%

Calculating WACC-

WACC = (% of Equity * cost of equity) + % of debt * Cost of debt (1-Tax rate)

WACC = .9517 * 9.86% + .0483 * 3.3212% (1-13.81%)

WACC = 9.52%

Note: Data is as per Dec. 2019.

Market capitalization = Number of shares outstanding * Current share price

Market capitalization = .504 Billion * 1900

As of today Amazon's market capitalization is $957.6 Billion.

ekkarill92 answered 1 year ago

Next > < Previous

Related Solutions

Choose a well-known publicly traded company that none of your other classmates have chosen, and explain...

Choose a well-known publicly traded company that none of your other classmates have chosen, and explain what costs would be included in each of the three manufacturing cost categories. Include a link to this financial statement in your post. ( Adidas would be a good choice). A minimum of 150 words please.

This week's assignment is to do a thorough financial statement review of the publicly-traded company Facebook....

This week's assignment is to do a thorough financial statement review of the publicly-traded company Facebook. To complete the analysis, you will need to run the five most applicable liquidity ratios, the two most appropriate solvency measures, and the five most appropriate profitability measures. Include these in an excel document. I was not given any financial information for facebook.

Choose a well-known, publicly-traded company that none of your other classmates have chosen, and explain what...

Choose a well-known, publicly-traded company that none of your other classmates have chosen, and explain what costs would be included in each of the three manufacturing cost categories. Include a link to this financial statement in your post.

Why do publicly traded stocks tend to see more price volatility than publicly traded corporate bonds?

Intermediate Accounting: RESEARCH PAPER You are going to choose a publicly traded company (Yum Brands). Publicly...

Intermediate Accounting: RESEARCH PAPER You are going to choose a publicly traded company (Yum Brands). Publicly traded companies who have their shares listed on stock exchanges are required to file regular financial statements and disclosures with regulators, such as the securities and exchange commission (SEC) in the United States. Among the most widely read of these are a company's annual report, which tells investors and analysts how the company has performed over the previous fiscal year (FY), how its businesses...

Company: Tesla 1. Identify a publicly-traded U.S.-based company (other than Target) in which you have some...

Company: Tesla 1. Identify a publicly-traded U.S.-based company (other than Target) in which you have some interest, and which has significant amounts of inventory. Such a company likely will be manufacturer (e.g., Tesla, Dover, Pfizer, Boeing, etc.) or (re)seller (e.g., McDonald’s, Costco, Home Depot, Kroger, CVS, etc.). 2. Obtain the latest audited annual financial statements for the company identified. Generally, that will mean either: a. Use the information in Appendix A of your text, Accessing the EDGAR Database through the...

Please choose a publicly traded company to work on. You may select a company whose securities...

Please choose a publicly traded company to work on. You may select a company whose securities are traded on the NYSE, AMEX or NASDAQ. Please do not select a company that is a financial institution or services company. The company should sell merchandise. Part I Fill in some basic information about your company. Name of company ______________________________________ Principal exchange where the company trades _______________ Market price of the stock ________________ as of _____________ (date) Annual dividend ________________________________________ Last dividend paid...

Choose a publicly traded company and answer the following questions: 1. Explain the importance of considering...

Choose a publicly traded company and answer the following questions: 1. Explain the importance of considering the financial risk of rivals, customers, suppliers, and other counter-parties. 2. Then discuss what company should take into consideration in terms of how it might affect their financial decisions. 3. Analyze and rank the level of time a company should spend on financial planning/protecting their business from risk and competitors.

Directions: Choose a publicly traded company and perform an expanded analysis on the financial statements. Use...

Directions: Choose a publicly traded company and perform an expanded analysis on the financial statements. Use the most current 10K statements available on SEC or annual statements in Yahoo Finance. Complete the following for your chosen firm in an Excel spreadsheet: The Company is TJ MAXX below is a link to the sec.com 10K statement. https://www.sec.gov/Archives/edgar/data/109198/000119312517099642/d269088d10k.htm https://www.sec.gov https://finance.yahoo.com/quote/TJX/financials?p=TJX If the first link does not work there is a second one and search for the company TJ MAXX Along with a...

Choose a publicly traded company, and identify the resources that you would use (besides the financial...

Choose a publicly traded company, and identify the resources that you would use (besides the financial statements) to analyze the financial position of this corporation for 2016-2017. Find at least two resources, other than the financial statements, that provide information regarding your chosen company. Prepare an overview (approximately 300 words) of what is revealed about the company by these resources, including any items that you find to be unusual about the company. Provide a link to each resource examined with...

Subjects