Spreadsheet: f523062b-3e71-4d1b-9239-d2ba5da67608
Sheet: Sheet1

FINANCIAL RATIO ANALYSIS EXCEL TEMPLATE | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
A Microsoft Excel Spreadsheet To Accompany Melicher & Norton's
Introduction to Finance: Markets, Investments, and Financial Management, 14e
Instructions: | Choose a company whose stock is publicly traded.
 | Go to www.finance.yahoo.com.
 | Type in the name of your company next to GET QUOTES.
 | In the left-hand column, go to the bottom, Financials.
 | Click on the balance sheet and enter information into this file.
 | Enter values for blue font cells, allowing black font cells to automatically calculate.
 | Enter data for each of three years.
 | Consolidate or expand terms as necessary, but be sure the asset
 | total in the spreadsheet agrees with your source total.
 | Be certain that total assets equal total liabilities and equity.
 | Enter data for the income statement.
 | Examine your ratios. Some may not calculate due to missing data.
 | Repeat for a major competitor to your company.
 | Use the ratios to do a trend (time series) analysis.
 | Use the ratios to do a cross-sectional analysis.
 | Refer to the textbook, pages 388 to 402 for help in the analysis.
 | Complete the Discussion section provided below.
 | Make sure your discussion is formatted properly (readable).
 | Submit to your instructor for feedback before final submission.
 | COMPANY:(insert name) |  |  |  | COMPETITOR: (insert name)
 | 2010 | 2009 | 2008 |  | 2010 | 2009 | 2008
BALANCE SHEETS
ASSETS
Cash & marketable securities | 0 | 0 | 0 |  | 0 | 0 | 0
Accounts receivable | 0 | 0 | 0 |  | 0 | 0 | 0
Inventories | 0 | 0 | 0 |  | 0 | 0 | 0
Total current assets | 0 | 0 | 0 |  | 0 | 0 | 0
Gross plant & equipment | 0 | 0 | 0 |  | 0 | 0 | 0
Less: accumulated depreciation | 0 | 0 | 0 |  | 0 | 0 | 0
Net plant & equipment | 0 | 0 | 0 |  | 0 | 0 | 0
Land | 0 | 0 | 0 |  | 0 | 0 | 0
Total fixed assets | 0 | 0 | 0 |  | 0 | 0 | 0
Total assets | 0 | 0 | 0 |  | 0 | 0 | 0
LIABILITIES & EQUITY
Accounts payable | 0 | 0 | 0 |  | 0 | 0 | 0
Notes payable | 0 | 0 | 0 |  | 0 | 0 | 0
Accrued liabilities | 0 | 0 | 0 |  | 0 | 0 | 0
Total current liabilities | 0 | 0 | 0 |  | 0 | 0 | 0
Long-term debt | 0 | 0 | 0 |  | 0 | 0 | 0
Total liabilities | 0 | 0 | 0 |  | 0 | 0 | 0
Common stock par | 0 | 0 | 0 |  | 0 | 0 | 0
Paid-in capital | 0 | 0 | 0 |  | 0 | 0 | 0
Retained earnings | 0 | 0 | 0 |  | 0 | 0 | 0
Total stockholders equity | 0 | 0 | 0 |  | 0 | 0 | 0
Total liabilities & equity | 0 | 0 | 0 |  | 0 | 0 | 0
INCOME STATEMENTS
Net revenues or sales | 0 | 0 | 0 |  | 0 | 0 | 0
Cost of goods sold | 0 | 0 | 0 |  | 0 | 0 | 0
Gross profit | 0 | 0 | 0 |  | 0 | 0 | 0
Operating expenses:
General & administrative | 0 | 0 | 0 |  | 0 | 0 | 0
Selling & marketing | 0 | 0 | 0 |  | 0 | 0 | 0
Depreciation | 0 | 0 | 0 |  | 0 | 0 | 0
Operating income | 0 | 0 | 0 |  | 0 | 0 | 0
Interest | 0 | 0 | 0 |  | 0 | 0 | 0
Income before taxes | 0 | 0 | 0 |  | 0 | 0 | 0
Income taxes | 0 | 0 | 0 |  | 0 | 0 | 0
Net income | 0 | 0 | 0 |  | 0 | 0 | 0
Number of shares outstanding | 0 | 0 | 0 |  | 0 | 0 | 0
Earnings per share
[NAME]
Current ratio (times)
Quick ratio (times)
Average payment period (days)
ASSET MANAGEMENT RATIOS
Total asset turnover (times)
Fixed asset turnover (times)
Average collection period (days)
Inventory turnover (times)
FINANCIAL LEVERAGE RATIOS
Total debt to total assets
Equity multiplier (times)
Interest coverage (times)
PROFITABILITY RATIOS
Operating profit margin
Net profit margin
Operating return on assets
Return on total assets
Return on equity
Discussion: Do you recommend buying stock in the company?
Issues: ([NAME] your understanding of the assignment)
Concepts: (Explain in your own words the financial tools you are using)
Perspectives: (Use each ratio to point out strong and weak points of your company and its competitor)
Assumptions: (Bring in outside information such as from the annual report to ponder the future of your company)
Recommendation: (State whether or not you recommend a stock purchase in your company and why)