Reference no: EM132450885

BA 211Fundamentals of Financial Accounting

Instructions:

1. The last digit of your student ID will equal the company you research from the Company List below
2. Analyze and present the required information in Excel
a. Use financial information found in the companies' most recent 10-K
b. Be aware that financial information and ratios are for current and prior year
3. Submit the Excel file to the D2L dropbox.

Objective

To utilize and apply financial accounting skills to make determinations about the health and performance of publicly traded companies by analyzing publicly available data. Students will:

• Look up company information on a company's website
• Look up company information on a government website
• Read and identify company information in the company's corporate filings
• Read and identify financial information in the company's financial statements
• Analyze financial information by calculating financial ratios
• Make reasoned conclusions on the relative health and performance of the company

Company List

0. Micron Technology
1. Expedia
2. Nautilus
3. Alaska Air Group
4. Costco
5. Nordstrom
6. Intel
7. Nike
8. Amazon
9. Flir Systems

Required information:

General Information"2 Points Each"

1. Exact legal name
2. Brief description of what the business does
3. Company's ticker symbol
4. What exchange is the company traded on
5. Fiscal year end

Income Statement (for current year and prior year)"2 Points Each"

1. Total Revenue
2. Total Cost of Sales
3. Gross Profit
4. Depreciation and Amortization
5. Income Tax Provision
6. Net Income

Balance Sheet (for current year and prior year)"2 Points Each"

1. Total Current Assets
2. Total Assets
3. Total Current Liabilities
4. Total Liabilities
5. Total Preferred Stock
6. Total Common Stock
7. Total Retained Earnings

Ratios (for current year and prior year)AND USE EXCEL DO TO THE CALCUALTIONS"2 Points Each"

1. Net Profit Margin
2. Gross Profit Margin
3. Fixed Asset Turnover
4. Return on Equity
5. Receivables Turnover
6. Current Ratio
7. Debt-to-Assets

Analysis"5 Points Each"

Question 1. Comment on the health of the company referencing the profitability, liquidity and solvency ratios that you have calculated.

Question 2. In what way did the company's financial health change from the prior year?

Question 3. Would you invest in the company and why?