Company Analysis

profilesappymae
cf_FIN534_Company_Stock_Analysis_Template.xlsx

Company Analysis

FIN534: Financial Management Name: Click or tap here to enter text. Professor Name: Click or tap here to enter text. Date: Click or tap here to enter text.
Company Analysis
U.S. Stock exchange: Company Name: Company 1 Company 2
Determine the free cash flow for the last two most recent years for the two companies.
Explain how a company’s free cash flow (cash flow from operating activities minus capital expenditures) impacts its growth potential.
Instructions: Find the numbers for these calculations from the income statement or balance sheet for each company from the annual report or 10-K. Make sure the numbers are not from the 10-Q or quarterly report as you want to make apples to apples comparisons.
Your Name:
Industry:
Company 1 Name:
Company 2 Name:
Company 3 Name:
Income Statement Information
Total Revenue
Company 1 Name: $0.00
Company 2 Name: $0.00
Company 3 Name: $0.00
Gross Profit
Company 1 Name: $0.00
Company 2 Name: $0.00
Company 3 Name: $0.00
Net Income
Company 1 Name: $0.00 Note: Choose Net Income or EBITDA. Generally accepted accounting principles (GAAP) only requires the use of Net Income and EBITDA is optional. Foreign companies generally do not follow GAAP and use EBITDA because it normally makes the numbers look better.
Company 2 Name: $0.00
Company 3 Name: $0.00
EBITDA
Company 1 Name: $0.00
Company 2 Name: $0.00
Company 3 Name: $0.00
Balance Sheet Information
Total Assets
Company 1 Name: $0.00
Company 2 Name: $0.00
Company 3 Name: $0.00
Total Liabilities
Company 1 Name: $0.00
Company 2 Name: $0.00
Company 3 Name: $0.00
Total Stockholders' Equity
Company 1 Name: $0.00
Company 2 Name: $0.00
Company 3 Name: $0.00
Ratios Calculations
Calculate the Following Ratios:
Debt to Equity Ratio Formula (Total Debt/Total Equity) Total Debt Total Equity Debt to Equity Ratio
Company 1 Name: $0.00 $0.00 $0.00
Company 2 Name: $0.00 $0.00 $0.00
Company 3 Name: $0.00 $0.00 $0.00
Gross Margin Formula (Gross Profits/Sales) Gross Profits Sales Gross Margin
Company 1 Name: $0.00 $0.00 $0.00
Company 2 Name: $0.00 $0.00 $0.00
Company 3 Name: $0.00 $0.00 $0.00
Operating Margin Formula (Operating Income/Sales) Operating Income Sales Operating Margin
Company 1 Name: $0.00 $0.00 $0.00
Company 2 Name: $0.00 $0.00 $0.00
Company 3 Name: $0.00 $0.00 $0.00
Find the appropriate amounts from the 10K annual report and insert them into the formula to calculate.
Formulas Company A Company B Company C
Profitability ratios:
Profit margin = Net Income/Sales
Return on equity = Net Income/Shareholders' Equity
Efficiency ratios:
Inventory turnover = Cost of Goods Sold/Average Inventory
Accounts receivable turnover = Net Sales/Average Accounts Receivable
Leverage ratios:
Debt to equity ratio = Total Liabilities/Shareholders' Equity
Debt/Assets = Total Liabilities/Total Assets
Liquidity ratios:
Current ratio = Current Assets/Current Liabilities
Quick ratio = (Current Assets - Inventory)/Current Liabilities
Discuss three takeaways or an analysis of what you’ve learned about each company based on their financial data. Include at least one paragraph for each company.
Analysis
Company 1 Name:
Company 2 Name:
Company 3 Name:

Stock Analysis

Stock Analysis
Instructions: Find the numbers for these calculations from the income statement or balance sheet for each company from the annual report or 10-K. Make sure the numbers are not from the 10-Q or quarterly report as you want to make apples to apples comparisons.
Your Name:
Industry:
Company 1 Name:
Company 2 Name:
Company 3 Name:
Stock
Ticker Symbol
Company 1 Name:
Company 2 Name:
Company 3 Name:
Stock Price Include the stock price at the balance sheet date. (Stock prices fluctuate daily and are available in the Wall Street Journal)
Fiscal Year End Date:
Company 1 Name: $0.00
Company 2 Name: $0.00
Company 3 Name: $0.00
Market Cap Formula (Share Price/Number of Shares)
Company 1 Name: $0.00
Company 2 Name: $0.00
Company 3 Name: $0.00
Price to Earnings Ratio Formula (Share Price/EPS)
Company 1 Name: $0.00
Company 2 Name: $0.00
Company 3 Name: $0.00
Current Dividend Yield - Year End Formula (DPS/Share Price)
Company 1 Name: $0.00
Company 2 Name: $0.00
Company 3 Name: $0.00
Discuss the performance of the stocks, how the company's performance impacts the stock performance, and their investment potential. Include at least one paragraph for each company. You can consult the notes to the financial statements that appear right after the financial statements to find a detailed explanation or you can use Management's Discussion and Analysis in the Annual (10K) Report.
Analysis
Company 1 Name:
Company 2 Name:
Company 3 Name: