{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

Yahoo Excel (version 1)

Yahoo Excel (version 1) - RATIO ANALYSIS Yahoo Income...

Info iconThis preview shows pages 1–5. Sign up to view the full content.

View Full Document Right Arrow Icon
RATIO ANALYSIS Yahoo! Current Year Prior Year 3 Years Ago 4 Years Ago 5 Years Ago $ Percent $ Percent $ $ $ Income Statement Revenue 6,969 100.0% 6,425 100.0% 5,257 3,574 Cost of Goods Sold 2,838 40.7% 2,675 41.6% 2,096 Interest Expense 150 2.2% 112 1.7% 128 Tax Expense 337 4.8% 458 7.1% 767 Income from Cont Operations 695 10.0% 940 14.6% 1,107 Net Income 767 11.0% 458 7.1% Balance Sheet Cash 1,513 12.4% 1,569 13.6% 1,429 Short Term Investments 487 4.0% 1,031 9.0% 1,131 Accounts Receivable 1,055 8.6% 930 8.1% 721 Inventory 0 0.0% 0 0.0% 0 Current Assets 3,237 26.5% 3,750 32.6% 3,449 Long Term Investments 361 3.0% 935 8.1% Net Fixed Assets 1,331 10.9% 1,101 9.6% Other Assets 7,296 59.7% 5,723 49.7% Total Assets 12,229 100.0% 11,513 100.0% 10,831 Current Liabilities 2,300 18.8% 1,473 12.8% 1,204 Total Liabilities 2,697 22.1% 2,353 20.4% Total Stockholders' Equity 9,532 77.9% 9,160 79.6% 8,566 Cash Flow Cash Flow from Operations 1,918 1,371 1,711 Dividends Paid 0 0 0 Interest Paid 0 0 0 Share Information Market Price at Year End 23.26 25.54 39.18 Earnings Per Share - Basic 0.49 0.54 1.35 Shares Outstanding 1,330 1,360 1,430
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
RATIO ANALYSIS Growth Ratios Sales Growth 8.5% 22.2% Income Growth -26.1% -15.1% Asset Growth 6.2% 6.3% Activity Ratios Receivable Turnover 7.0 7.8 Inventory Turnover #DIV/0! #DIV/0! Fixed Asset Turnover 5.2 5.8 Profitability Ratios Profit Margin 10.0% 14.6% Return on Assets 5.9% 8.4% Return on Equity 7.4% 10.6% Dividend Payout Ratio 0.0% 0.0% Price Earnings Ratio 47.5 47.3 Liquidity Ratios Current Ratio 1.41 2.55 Quick Ratio 1.33 2.40 Solvency Ratios Debt to Total Assets 0.22 0.20 Times Interest Earned (Accrual) 7.88 13.48 Times Interest Earned (Cash) #DIV/0! #DIV/0! © 2008 William R. Pasewark
Background image of page 2
PRIMARY COMPETITOR ANALYSIS Yahoo! Google $ $ Income Statement Revenue 6,969 16,593 Cost of Goods Sold 2,838 6,649 Interest Expense 150 1 Tax Expense 337 1,470 Income from Cont Op 695 5,084 Net Income 767 4,203 Prior Year Revenue 6,425 10,604 Prior Year Income from Continuing Operations 940 3,549 Balance Sheet Cash 1,513 6,081 Short Term Investments 487 8,137 Accounts Receivable 1,055 2,161 Inventory 0 0 Current Assets 3,237 17,289 Long Term Investments 361 1,261 Net Fixed Assets 1,331 4,039 Other Assets 7,296 25,335 Total Assets 12,229 Current Liabilities 2,300 2,035 Total Liabilities 2,697 2,646 Total Stockholders' Equity 9,532 22,689 Prior Year Accounts Receivable 930 1,332 Prior Year Inventory 0 0 Prior Year Assets 11,513 Prior Year Liabilities 2,353 1,433 Prior Year Stockholders' Equity 9,160 17,039 Cash Flow Cash Flow from Operations 1,918 5,775 Dividends Paid 0 0 Interest Paid 0 0
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
RATIO ANALYSIS Income Statement Common-Size Data Gross Profit/Sales 59.3% 59.9% Income from Continuing Operations/Sales 10.0% 30.6% Balance Sheet Common-Size Data Current Assets/Total Assets 26.5% #DIV/0! Current Liabilities/Total Assets 18.8% #DIV/0! Liabilities/Total Assets 22.1% #DIV/0! Equity/Total Assets 77.9% #DIV/0! Profitabilty Ratios Profit Margin 10.0% 30.6% Return on Assets 5.9% #DIV/0! Return on Equity 7.4% 25.6% Dividend Payout Ratio 0.0% 0.0% Liquidity Ratios Current Ratio 1.41 8.50 Quick Ratio 1.33 8.05 Solvency Ratios Debt/Total Assets 0.22 #DIV/0!
Background image of page 4
Image of page 5
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}