Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Calculate the cost of debt, weights of equity and debt for AMD AMD Historical Data Date Open High Low Close Adj Close Volume Fiscal Year
Calculate the cost of debt, weights of equity and debt for 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