Answered step by step
Verified Expert Solution
Question
1 Approved Answer
this is my question that I am sending for the third time. please help me as much as possible since my time is running out!
this is my question that I am sending for the third time. please help me as much as possible since my time is running out!
Q: Find the 2020-2021 financial statements (Balance Sheet, Income Statement) for a publicly traded company in the Energy Sector: Oil, Gas & Consumable Fuels; Energy Equipment & Services; Renewable Energy from UHV Mergent Online database, Yahoo! Finance, Google Finance, or other financial sources. Each student should choose a different company at your choice. (1) Conduct a financial ratio analysis of the company. (2) Estimate the weights of capital (debt, preferred stock, and common stock) for the company. (3) Estimate the before-tax and after-tax component cost of debt for the firm, (4) Estimate the component cost of preferred stock (if applicable) for the firm (5) Estimate the component cost of common equity using CAPM for the firm. (6) Compute the firm's weighted average cost of capital (WACC), Discuss your findings f + c macrotrends.net/stocks/charts/XOM/exxon/income-statement Annual Data Millions of US $ except per share data 2020-12-31 2019-12-31 2018-12-31 Revenue Cost Of Goods Sold [ $181,502 $150,560 $30,942 $1,285 $10.168 EEEEEEE $264,938 $211,152 $53,786 $1,269 $11,398 $290,212 $225,517 $64,695 $1,466 $11.480 Gross Profit Research And Development Expenses SG&A Expenses Other Operating Income Or Expenses Operating Expenses Operating Income Total Non-Operating Income/Expense Pre Tax Income Income Taxes $210.385 $ 28,883 $244 882 $20,056 $259,259 $30,953 EEE $ 28,883 $-5,632 S-23.251 $20,056 $5282 $14.774 $30,953 $9,532 $21,421 Income After Taxes Other Income $ 23,251 $14,774 $21.421 $-22,440 $18,284 Income From Continuous Operations Income From Discontinued Operations Net Income EBITDA EBIT Basic Shares Outstanding Shares Outstanding Basic EPS EPS Earnings Per Share $20,840 $50,464 $31.719 EEEEEEE $-27,725 4,271 $14,340 $39,884 $20,886 4270 4270 $3.36 $3.36 4,271 S-5.25 S-5.25 4,270 4,270 $4.88 S4.88 Annual Data Millions of US $ except per share data 2020-12-31 2019-12-31 2018-12-31 lil $4,364 $3,089 $3,042 $18,850 $18,528 $18.958 Lail Lil $1,098 $44,893 $227,553 $43,515 $1,469 $50,052 $253,018 $43,164 $1,272 $47,973 $247 101 $40,790 [lil Lolil Cash On Hand Receivables Inventory Pre-Paid Expenses Other Current Assets Total Current Assets Property, Plant And Equipment Long-Term Investments Goodwill And Intangible Assets Other Long-Term Assets Total Long-Term Assets Total Assets Total Current Liabilities Long Term Debt Other Non-Current Liabilities Total Long Term Liabilities Total Liabilities Common Stock Net Retained Earnings (Accumulated Deficit) Comprehensive Income Other Share Holders Equity Share Holder Equity Total Liabilities And Share Holders Equity EEEEEEEEEEEEEE $16,789 $287 857 $332.750 $56,363 $47.182 $24.495 $112,257 $168,620 $15.688 $383,943 5-16 705 $16,363 $312,545 $362,597 $63,989 $26,342 $25,404 $99,670 $163,659 $15,637 $421.341 $-19.493 $10.332 $298,223 $346,196 $57 138 $20,538 $22.476 590,530 $147,668 $15.258 $421,653 5-19 564 $164,130 $332.750 $198.938 $362,597 $198.528 $346,196 Sterlinet Q: Find the 2020-2021 financial statements (Balance Sheet, Income Statement) for a publicly traded company in the Energy Sector: Oil, Gas & Consumable Fuels; Energy Equipment & Services; Renewable Energy from UHV Mergent Online database, Yahoo! Finance, Google Finance, or other financial sources. Each student should choose a different company at your choice. (1) Conduct a financial ratio analysis of the company. (2) Estimate the weights of capital (debt, preferred stock, and common stock) for the company. (3) Estimate the before-tax and after-tax component cost of debt for the firm, (4) Estimate the component cost of preferred stock (if applicable) for the firm (5) Estimate the component cost of common equity using CAPM for the firm. (6) Compute the firm's weighted average cost of capital (WACC), Discuss your findings f + c macrotrends.net/stocks/charts/XOM/exxon/income-statement Annual Data Millions of US $ except per share data 2020-12-31 2019-12-31 2018-12-31 Revenue Cost Of Goods Sold [ $181,502 $150,560 $30,942 $1,285 $10.168 EEEEEEE $264,938 $211,152 $53,786 $1,269 $11,398 $290,212 $225,517 $64,695 $1,466 $11.480 Gross Profit Research And Development Expenses SG&A Expenses Other Operating Income Or Expenses Operating Expenses Operating Income Total Non-Operating Income/Expense Pre Tax Income Income Taxes $210.385 $ 28,883 $244 882 $20,056 $259,259 $30,953 EEE $ 28,883 $-5,632 S-23.251 $20,056 $5282 $14.774 $30,953 $9,532 $21,421 Income After Taxes Other Income $ 23,251 $14,774 $21.421 $-22,440 $18,284 Income From Continuous Operations Income From Discontinued Operations Net Income EBITDA EBIT Basic Shares Outstanding Shares Outstanding Basic EPS EPS Earnings Per Share $20,840 $50,464 $31.719 EEEEEEE $-27,725 4,271 $14,340 $39,884 $20,886 4270 4270 $3.36 $3.36 4,271 S-5.25 S-5.25 4,270 4,270 $4.88 S4.88 Annual Data Millions of US $ except per share data 2020-12-31 2019-12-31 2018-12-31 lil $4,364 $3,089 $3,042 $18,850 $18,528 $18.958 Lail Lil $1,098 $44,893 $227,553 $43,515 $1,469 $50,052 $253,018 $43,164 $1,272 $47,973 $247 101 $40,790 [lil Lolil Cash On Hand Receivables Inventory Pre-Paid Expenses Other Current Assets Total Current Assets Property, Plant And Equipment Long-Term Investments Goodwill And Intangible Assets Other Long-Term Assets Total Long-Term Assets Total Assets Total Current Liabilities Long Term Debt Other Non-Current Liabilities Total Long Term Liabilities Total Liabilities Common Stock Net Retained Earnings (Accumulated Deficit) Comprehensive Income Other Share Holders Equity Share Holder Equity Total Liabilities And Share Holders Equity EEEEEEEEEEEEEE $16,789 $287 857 $332.750 $56,363 $47.182 $24.495 $112,257 $168,620 $15.688 $383,943 5-16 705 $16,363 $312,545 $362,597 $63,989 $26,342 $25,404 $99,670 $163,659 $15,637 $421.341 $-19.493 $10.332 $298,223 $346,196 $57 138 $20,538 $22.476 590,530 $147,668 $15.258 $421,653 5-19 564 $164,130 $332.750 $198.938 $362,597 $198.528 $346,196 Sterlinet these two pictures are the needed data of Exxon to answer above questions.
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