Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Calculate a beta, cost of equity of AMD AMD Historical Data Date Open High Low Close Adj Close Volume Fiscal Year 2018-12-01 22.48 23.75 16.030001
Calculate a beta, cost of equity of AMD
AMD | ||||||||
Historical Data | ||||||||
Date | Open | High | Low | Close | Adj Close | Volume | Fiscal Year | |
2018-12-01 | 22.48 | 23.75 | 16.030001 | 18.459999 | 18.459999 | 1981674300 | ||
2019-01-01 | 18.01 | 25.139999 | 16.940001 | 24.41 | 24.41 | 2311913200 | ||
2019-02-01 | 24.610001 | 25.52 | 22.27 | 23.530001 | 23.530001 | 1301360800 | ||
2019-03-01 | 23.969999 | 28.110001 | 21.040001 | 25.52 | 25.52 | 1499160400 | ||
2019-04-01 | 26.42 | 29.950001 | 25.83 | 27.629999 | 27.629999 | 1275793800 | ||
2019-05-01 | 28.950001 | 29.67 | 26.030001 | 27.41 | 27.41 | 1675142900 | ||
2019-06-01 | 28.75 | 34.299999 | 27.290001 | 30.370001 | 30.370001 | 1578306600 | ||
2019-07-01 | 31.790001 | 34.860001 | 30.1 | 30.450001 | 30.450001 | 1155856000 | ||
2019-08-01 | 30.5 | 35.549999 | 27.65 | 31.450001 | 31.450001 | 1645672800 | ||
2019-09-01 | 30.83 | 32.049999 | 28.35 | 28.99 | 28.99 | 1012749700 | ||
2019-10-01 | 29.049999 | 34.34 | 27.43 | 33.93 | 33.93 | 1067281800 | ||
2019-11-01 | 34.369999 | 41.790001 | 34.099998 | 39.150002 | 39.150002 | 1202279900 | ||
2019-12-01 | 39.32 | 47.310001 | 37.150002 | 45.860001 | 45.860001 | 982440800 | ||
Income Statement | ||||||||
Breakdown | TTM | 12/31/2019 | 12/31/2018 | 12/31/2017 | 12/31/2016 | |||
Total Revenue | 746,000 | 6,731,000 | 6,475,000 | 5,329,000 | 4,272,000 | |||
Cost of Revenue | 4,254,000 | 3,863,000 | 4,028,000 | 3,506,000 | 3,274,000 | |||
Gross Profit | 3,392,000 | 2,868,000 | 2,447,000 | 1,823,000 | 998,000 | |||
Operating Expense | 2,508,000 | 2,237,000 | 1,996,000 | 1,619,000 | 1,380,000 | |||
Operating Income | 884,000 | 631,000 | 451,000 | 204,000 | -382,000 | |||
Net Non Operating Interest | -54,000 | -79000 | -103,000 | -120,000 | -154,000 | |||
Other Income Expense | -171,000 | -180000 | -18,000 | -15,000 | 88,000 | |||
Pretax Income | 659,000 | 372,000 | 330,000 | 69,000 | -448,000 | |||
Tax Provision | 52,000 | 31,000 | -9,000 | 19,000 | 39,000 | |||
Earnings from Equity Interest | 2,000 | 0 | -2,000 | -7000 | -10,000 | |||
Net Income Common Stockholders | 609,000 | 341,000 | 337,000 | 43,000 | -497,000 | |||
Diluted NI Available to Common Stock | 616,000 | 341,000 | 337,000 | 43,000 | -497,000 | |||
Basic EPS | - | 0 | 0 | 0 | 0 | |||
Diluted EPS | - | 0 | 0 | 0 | 0 | |||
Basic Average Shares | - | 1,091,000 | 982,000 | 952,000 | 835,000 | |||
Diluted Average Shares | - | 1,120,000 | 1,064,000 | 1,039,000 | 835,000 | |||
Total Operating Income as Reported | 884,000 | 631,000 | 451,000 | 204,000 | -372,000 | |||
Total Expenses | 6,672,000 | 6,100,000 | 6,024,000 | 5,125,000 | 4,654,000 | |||
Net Income from Continued/Discontinued Operations | 609,000 | 341,000 | 337,000 | 43,000 | -497,000 | |||
Normalized Income | 609,000 | 502,333 | 345,760 | 49,522 | -549,800 | |||
Interest Income | - | 15,000 | 18,000 | 6,000 | 2,000 | |||
Interest Expense | 69,000 | 94,000 | 121,000 | 126,000 | 156,000 | |||
Net Interest Income | -54000 | -79,000 | -103,000 | -120,000 | -154,000 | |||
EBIT | 728,000 | 466,000 | 451,000 | 195,000 | -292,000 | |||
EBITDA | 1,030,000 | - | - | - | - | |||
Reconciled Cost of Revenue | 4,254,000 | 3,863,000 | 4,028,000 | 3,506,000 | 3,141,000 | |||
Reconciled Depreciation | 302,000 | 258,000 | 170,000 | 144,000 | 133,000 | |||
Net Income from continuing operation net minority Interest | 609,000 | 341,000 | 337,000 | 43,000 | -497,000 | |||
Total Unusual Items Exluding Goodwill | - | -176,000 | -12,000 | -9,000 | 88,000 | |||
Total Unusual Items | - | -176,000 | -12,000 | -9,000 | 88,000 | |||
Normalized EBITDA | 1030000 | 900,000 | 633,000 | 348,000 | -247,000 | |||
Tax Rate for Calcs | 0 | 0 | 0 | 0 | 0 | |||
Tax Effect of Unusual Items | 0 | -14,667 | -3,240 | -2,478 | 35,200 | |||
Balance Sheet | ||||||||
Breakdown | 12/31/2019 | 12/31/2018 | 12/31/2017 | 12/31/2016 | ||||
Total Assets | 6,028,000 | 4,556,000 | 3,540,000 | 3,321,000 | ||||
Total Liabilities Net Minority Interest | 3,201,000 | 3,290,000 | 2,929,000 | 2,905,000 | ||||
Total Equity Gross Minority Interest | 2,827,000 | 1,266,000 | 611,000 | 416,000 | ||||
Total Capitalization | 3,313,000 | 2,380,000 | 1,936,000 | 1,851,000 | ||||
Common Stock Equity | 2,827,000 | 1,266,000 | 611,000 | 416,000 | ||||
Capital Lease Obligations | 242,000 | - | - | - | ||||
Net Tangible Assets | 2,328,000 | 751,000 | 83,000 | -105,000 | ||||
Working Capital | 2,238,000 | 1,556,000 | 1,136,000 | 1,184,000 | ||||
Invested Capital | 3,313,000 | 2,516,000 | 2,006,000 | 1,851,000 | ||||
Tangible Book Value | 2,328,000 | 751,000 | 83,000 | -105,000 | ||||
Total Debt | 728,000 | 1,250,000 | 1,395,000 | 1,435,000 | ||||
Net Debt | - | 172,000 | 210,000 | 171,000 | ||||
Share Issued | 1,175,000 | 1,010,000 | 979,000 | 949,000 | ||||
Ordinary Shares Number | 1,170,000 | 1,005,000 | 967,000 | 935,000 | ||||
Treasury Shares Number | 5,000 | 5,000 | 12,000 | 14,000 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started