Analyzing Financial Statements of United States Based Corporations Scenario Each student is to select a United...

Analyzing Financial Statements of United States Based Corporations
Scenario

Each student is to select a United States based public (shares are listed on a major stock exchange) company for this project. You will need to locate the company's income statement and balance sheet for the past two years. The project is to be completed Individually - this is not a group project.

Requirements

1. For each year please determine/calculate the following:
* Net income
* Net income before taxes
* Income tax rate
* Earnings per share
* Gross profit margin
* Net profit margin
* Operating income
* Non-operating income
* Total assets
* Current assets
* Total liabilities
* Current liabilities
* Current ratio
* Debt to total assets ratio
* Book value (owners equity)
2. Prepare a comparative financial statement analysis (horizontal analysis) for each of the 15 categories/financial measures.
3. Prepare a spreadsheet that shows all of the data, calculations, and analyses.
4. For each of the categories/financial measures that show a difference between the two years, determine what factors could have caused the differences.

use a companys income statement and balance sheets.

Expert Solution

1.

Particular	Remarks	For year ended June 30, 2019	For year ended June 30, 2018

* Net income	From the Income Statement (amount in million)	$ 39,240	$ 16,571
* Net income before taxes	From the Income Statement (amount in million)	$ 43,688	$ 36,474
* Income tax rate	Provision for Income taxes / Net income before taxes 2019 - 4,448 / 43,688 2018 - 19,903 / 36,474	10.18%	54.57%
* Earnings per share	From the Income statement (per share amount, Basic EPS)	$ 5.11	$ 2.15
* Gross profit margin	Gross margin / Total Revenue 2019 - 82,933 / 125,843 2018 - 72,007 / 110,360	65.90%	65.25%
* Net profit margin	Net Income / Total Revenue 2019 - 39,240 / 125,843 2018 - 16,571 / 110,360	31.18%	15.02%
* Operating income	From the Income Statement (amount in millions)	$ 42,959	$ 35,058
* Non-operating income	From the Income Statement (amount in millions)	$ 729	$ 1,416
* Total assets	From the Balance Sheet (amount in millions)	$ 286,556	$ 258,848
* Current assets	From the Balance Sheet (amount in millions)	$ 175,552	$ 169,662
* Total liabilities	From the Balance Sheet (amount in millions)	$ 184,226	$ 176,130
* Current liabilities	From the Balance Sheet (amount in millions)	$ 69,420	$ 58,488
* Current ratio	Current assets / current liabilities	2.53	2.90
* Debt to total assets ratio	Total Liabilities / Total assets	64.29%	68.04%
* Book value (owners equity)	From the Balance Sheet (amount in millions)	$ 102,330	$ 82,718

2.

Particular	Remarks	For year ended June 30, 2019	For year ended June 30, 2018

* Net income	From the Income Statement (amount in million)	$ 39,240	$ 16,571	$ 22,669
* Net income before taxes	From the Income Statement (amount in million)	$ 43,688	$ 36,474	$ 7,214
* Income tax rate	Provision for Income taxes / Net income before taxes 2019 - 4,448 / 43,688 2018 - 19,903 / 36,474	10.18%	54.57%	-44%
* Earnings per share	From the Income statement (per share amount, Basic EPS)	$ 5.11	$ 2.15	$ 3
* Gross profit margin	Gross margin / Total Revenue 2019 - 82,933 / 125,843 2018 - 72,007 / 110,360	65.90%	65.25%	1%
* Net profit margin	Net Income / Total Revenue 2019 - 39,240 / 125,843 2018 - 16,571 / 110,360	31.18%	15.02%	16%
* Operating income	From the Income Statement (amount in millions)	$ 42,959	$ 35,058	$ 7,901
* Non-operating income	From the Income Statement (amount in millions)	$ 729	$ 1,416	$ (687)
* Total assets	From the Balance Sheet (amount in millions)	$ 286,556	$ 258,848	$ 27,708
* Current assets	From the Balance Sheet (amount in millions)	$ 175,552	$ 169,662	$ 5,890
* Total liabilities	From the Balance Sheet (amount in millions)	$ 184,226	$ 176,130	$ 8,096
* Current liabilities	From the Balance Sheet (amount in millions)	$ 69,420	$ 58,488	$ 10,932
* Current ratio	Current assets / current liabilities	2.53	2.90	$ (0.37)
* Debt to total assets ratio	Total Liabilities / Total assets	64.29%	68.04%	-4%
* Book value (owners equity)	From the Balance Sheet (amount in millions)	$ 102,330	$ 82,718	$ 19,612

3 and 4.

Particular	Remarks	For year ended June 30, 2019	For year ended June 30, 2018		Reason

* Net income	From the Income Statement (amount in million)	$ 39,240	$ 16,571	$ 22,669	This is due to higher taxes in 2018
* Net income before taxes	From the Income Statement (amount in million)	$ 43,688	$ 36,474	$ 7,214	This is due to increase in revenue
* Income tax rate	Provision for Income taxes / Net income before taxes 2019 - 4,448 / 43,688 2018 - 19,903 / 36,474	10.18%	54.57%	-44%	This is on account of TCJA impact taken in 2018
* Earnings per share	From the Income statement (per share amount, Basic EPS)	$ 5.11	$ 2.15	$ 3	Due to increase in Net Income in the current year
* Gross profit margin	Gross margin / Total Revenue 2019 - 82,933 / 125,843 2018 - 72,007 / 110,360	65.90%	65.25%	0.65%	Negligble difference.
* Net profit margin	Net Income / Total Revenue 2019 - 39,240 / 125,843 2018 - 16,571 / 110,360	31.18%	15.02%	16.17%	This is due to higher taxes in 2018
* Operating income	From the Income Statement (amount in millions)	$ 42,959	$ 35,058	$ 7,901	This is due to increase in revenue
* Non-operating income	From the Income Statement (amount in millions)	$ 729	$ 1,416	$ (687)
* Total assets	From the Balance Sheet (amount in millions)	$ 286,556	$ 258,848	$ 27,708	The increase is due to the following 1. Higher receivables due to higher sales - 3,043 2. Purchase of assets - 7,017 3. New acquistions (Goodwill) - 6,343 4. Remaining is due to other assets
* Current assets	From the Balance Sheet (amount in millions)	$ 175,552	$ 169,662	$ 5,890	The increase is due to higher receivables due to higher sales
* Total liabilities	From the Balance Sheet (amount in millions)	$ 184,226	$ 176,130	$ 8,096	Major increase is on account of taxes payable and unearned revenue
* Current liabilities	From the Balance Sheet (amount in millions)	$ 69,420	$ 58,488	$ 10,932	Major increase is on account of taxes payable and unearned revenue
* Current ratio	Current assets / current liabilities	2.53	2.90	$ (0.37)	Decrease is because increase in current liabilities is higher than the increase in current assets
* Debt to total assets ratio	Total Liabilities / Total assets	64.29%	68.04%	-4%	Decrease is because increase in assets is higher than the increase in liabilities
* Book value (owners equity)	From the Balance Sheet (amount in millions)	$ 102,330	$ 82,718	$ 19,612	The increase is due to net income earned during the year net off dividends

ekkarill92 answered 7 months ago

Compare GASB financial statement requirements of United States with United Kingdom. Would the same financial statements...

Compare GASB financial statement requirements of United States with United Kingdom. Would the same financial statements be used and why?

financial community in the United States

The financial community in the United States has become increasingly concerned with the quality of reported company earnings.Required:1. Define the term earnings quality.2. Explain the distinction between permanent and transitory earnings as it relates to the concept of earnings quality.3. How do earnings management practices affect the quality of earnings?4. Assume that a manufacturing company's annual income statement included a large gain from the sale of investment securities. What factors would you consider in determining whether or not this gain...

There are three major forms of business organizations in the United States; proprietorships, partnerships and corporations....

There are three major forms of business organizations in the United States; proprietorships, partnerships and corporations. Describe the advantages and disadvantages of each form.

Among the benefits offered by corporations, at least in the United States, is health insurance. One...

Among the benefits offered by corporations, at least in the United States, is health insurance. One explanation for why corporations offer such insurance is that this benefit is tax favored: Companies can compensate employees with health-insurance benefits that are treated as nontaxable income. Also, health care providers and insurers (such as Blue Shield) have historically offered better rates to employers for their employees than to individuals who ask for the same coverage. Why is this?

Analyzing and Reporting Financial Statement Effects of Bond Transactions Lundholm, Inc., reports financial statements each December...

Analyzing and Reporting Financial Statement Effects of Bond Transactions Lundholm, Inc., reports financial statements each December 31 and issues $600,000, 7%, 15-year bonds dated May 1, 2012, with interest payments on October 31 and April 30. Assuming the bonds are sold at par on May 1, 2012, complete the financial statement effects template to reflect the following events: (a) bond issuance, (b) the first semiannual interest payment, and (c) retirement of $200,000 of the bonds at 101 on November 1,...

Return to the opening scenario and the Citizens United case. Is political advertising purchased by corporations appropriate?

Return to the opening scenario and the Citizens United case. Is political advertising purchased by corporations appropriate? Do you agree with the five members of the Supreme Court who voted to allow it, or with the four who dissented and would have drawn distinctions between free speech by individuals and organizations? Why?

Consider two companies: United States steel (X) and Facebook (FB). Look at the profiles (financial statements...

Consider two companies: United States steel (X) and Facebook (FB). Look at the profiles (financial statements for 2016) of each on yahoo finance and discuss the followings (you need to calculate these values yourself and show details of your calculations): How many outstanding shares the company has? What is the market value of the company? What is the book value of the company? What is the beta for the company? How do you find the risk free rate? (consider the...

The value of money in the United States is based on, and backed by the stocks...

The value of money in the United States is based on, and backed by the stocks of precious metals held by the United States government. T/F?

Explain the team-based approach to work in the United States.

1) Based on the following assumptions and financial information, select all the true statements. Year 1...

1) Based on the following assumptions and financial information, select all the true statements. Year 1 Year 2 Year 3 Year 4 Production in units 4,000 6,000 8,000 4,000 Sales in units 4,000 3,000 3,000 11,000 (1) Selling price per unit, variable cost per unit, and total fixed costs do not change during the four years. (2) There is no beginning inventory at Year 1. A. The combined four year net operating income would be the same under variable and...

Question