Investment Research Assignment
xiaoran1919
investment_analysis_report.xlsBalance sheet analysis
| BLMN-Bloomin' Brands | ||||
| Balance Sheet - Two-Year Comparison | ||||
| Year | 2015 | 2014 | Variance | Percentage variance |
| Assets | ||||
| Current assets | ||||
| Cash and equivalents | $ 1,634.80 | $ 2,077.90 | $ (443.10) | -21% |
| Accounts and notes receivable | $ 1,091.80 | $ 1,214.40 | $ (122.60) | -10% |
| Inventories, at cost, not in excess of market | $ 98.80 | $ 110.00 | $ (11.20) | -10% |
| Prepaid expenses and other current assets | $ 767.40 | $ 783.20 | $ (15.80) | -2% |
| Total current Assets | $ 3,592.80 | $ 4,185.50 | $ (592.70) | -14% |
| Other assets | ||||
| Investments in and advances to affiliates | $ 900.50 | $ 1,004.50 | $ (104.00) | -10% |
| Goodwill | $ 2,593.50 | $ 2,735.30 | $ (141.80) | -5% |
| Miscellaneous | $ 1,767.10 | $ 1,798.60 | $ (31.50) | -2% |
| Total other assets | $ 5,261.10 | $ 5,538.40 | $ (277.30) | -5% |
| Property and equipment | ||||
| Property and equipment, at cost | $ 37,551.00 | $ 39,126.10 | $ (1,575.10) | -4% |
| Accumulated depreciation and amortization | $ (14,249.30) | $ (14,568.60) | $ 319.30 | -2% |
| Net property and equipment | $ 23,301.70 | $ 24,557.50 | $ (1,255.80) | -5% |
| Total assets | $ 32,155.60 | $ 34,281.40 | $ (2,125.80) | -6% |
| Liabilities and shareholders’ equity | ||||
| Current liabilities | ||||
| Accounts payable | $ 702.00 | $ 860.10 | $ (158.10) | -18% |
| Income taxes | $ 372.10 | $ 166.80 | $ 205.30 | 123% |
| Other taxes | $ 317.00 | $ 330.00 | $ (13.00) | -4% |
| Accrued interest | $ 182.40 | $ 233.70 | $ (51.30) | -22% |
| Accrued payroll and other liabilities | $ 1,178.40 | $ 1,157.30 | $ 21.10 | 2% |
| Total current liabilities | $ 2,751.90 | $ 2,747.90 | $ 4.00 | 0% |
| Long-term debt | $ 14,291.80 | $ 14,989.70 | $ (697.90) | -5% |
| Other long-term liabilities | $ 1,997.60 | $ 2,065.90 | $ (68.30) | -3% |
| Deferred income taxes | $ 1,711.00 | $ 1,624.50 | $ 86.50 | 5% |
| Shareholders’ equity | $ - 0 | $ - 0 | $ - 0 | |
| Preferred stock, no par value; authorized – 165.0 million shares; issued – none | $ - 0 | $ - 0 | $ - 0 | |
| Common stock, $.01 par value; authorized – 3.5 billion shares; issued – 1,660.6 million shares | $ 16.60 | $ 16.60 | $ - 0 | 0% |
| Additional paid-in capital | $ 6,312.30 | $ 6,239.10 | $ 73.20 | 1% |
| Retained earnings | $ 43,290.00 | $ 43,294.50 | $ (4.50) | -0% |
| Accumulated other comprehensive income | $ (2,482.00) | $ (1,519.70) | $ (962.30) | 63% |
| Common stock in treasury, at cost; 702.1 and 697.7 million shares | $ (35,733.60) | $ (35,177.10) | $ (556.50) | 2% |
| Total shareholders’ equity | $ 29,403.70 | $ 31,533.50 | $ (2,129.80) | -7% |
| Total liabilities and shareholders’ equity | $ 32,155.60 | $ 34,281.40 | $ (2,125.80) | -6% |
Industry analysis
| Indus | ||||
| Year | 2015 | |||
| Assets | Assets% | Industry % | % Variance | |
| Current assets | ||||
| Cash and equivalents | $ 1,634.80 | 5% | 8.0% | -2.9% |
| Accounts and notes receivable | $ 1,091.80 | 3% | 2.0% | 1.4% |
| Inventories, at cost, not in excess of market | $ 98.80 | 0.31% | 1.30% | -1.0% |
| Prepaid expenses and other current assets | $ 767.40 | 2% | 3% | -0.6% |
| Total current Assets | $ 3,592.80 | 11% | 13% | -1.8% |
| Other assets | 0.0% | |||
| Investments in and advances to affiliates | $ 900.50 | 3% | 4% | -1.2% |
| Goodwill | $ 2,593.50 | 8% | 10% | -1.9% |
| Miscellaneous | $ 1,767.10 | 5% | 6% | -0.5% |
| Total other assets | $ 5,261.10 | 16% | 17% | -0.6% |
| Property and equipment | 0.0% | |||
| Property and equipment, at cost | $ 37,551.00 | 117% | 0% | |
| Accumulated depreciation and amortization | $ (14,249.30) | -44% | 0% | |
| Net property and equipment | $ 23,301.70 | 72% | 80% | -7.5% |
| Total assets | $ 32,155.60 | 0.0% | ||
| Liabilities and shareholders’ equity | 0.0% | |||
| Current liabilities | 0.0% | |||
| Accounts payable | $ 702.00 | 2.2% | 3% | -0.8% |
| Income taxes | $ 372.10 | 1.2% | 1% | 0.2% |
| Other taxes | $ 317.00 | 1.0% | 3% | -2.0% |
| Accrued interest | $ 182.40 | 0.6% | 1% | -0.4% |
| Accrued payroll and other liabilities | $ 1,178.40 | 3.7% | 3% | 0.7% |
| Total current liabilities | $ 2,751.90 | 0.0% | ||
| Long-term debt | $ 14,291.80 | 44.4% | 32% | 12.4% |
| Other long-term liabilities | $ 1,997.60 | 6.2% | 7% | -0.8% |
| Deferred income taxes | $ 1,711.00 | 5.3% | 2% | 3.3% |
| Shareholders’ equity | $ - 0 | 0.0% | ||
| Preferred stock, no par value; authorized – 165.0 million shares; issued – none | $ - 0 | 0.0% | ||
| Common stock, $.01 par value; authorized – 3.5 billion shares; issued – 1,660.6 million shares | $ 16.60 | 0.1% | 3% | -2.9% |
| Additional paid-in capital | $ 6,312.30 | 19.6% | 20% | -0.4% |
| Retained earnings | $ 43,290.00 | 134.6% | 80% | 54.6% |
| Accumulated other comprehensive income | $ (2,482.00) | -7.7% | 3% | -10.7% |
| Common stock in treasury, at cost; 702.1 and 697.7 million shares | $ (35,733.60) | -111.1% | -111.1% | |
| Total shareholders’ equity | $ 29,403.70 | 91.4% | 91.4% | |
| Total liabilities and shareholders’ equity | $ 32,155.60 | 0.0% |
Ratio analysis
| MCD LIMITED | ||
| Balance Sheet - Two-Year Comparison | ||
| Year | 2015 | 2014 |
| Assets | ||
| Current assets | ||
| Cash and equivalents | $ 1,634.80 | $ 2,077.90 |
| Accounts and notes receivable | $ 1,091.80 | $ 1,214.40 |
| Inventories, at cost, not in excess of market | $ 98.80 | $ 110.00 |
| Prepaid expenses and other current assets | $ 767.40 | $ 783.20 |
| Total current Assets | $ 3,592.80 | $ 4,185.50 |
| Other assets | ||
| Investments in and advances to affiliates | $ 900.50 | $ 1,004.50 |
| Goodwill | $ 2,593.50 | $ 2,735.30 |
| Miscellaneous | $ 1,767.10 | $ 1,798.60 |
| Total other assets | $ 5,261.10 | $ 5,538.40 |
| Property and equipment | ||
| Property and equipment, at cost | $ 37,551.00 | $ 39,126.10 |
| Accumulated depreciation and amortization | $ (14,249.30) | $ (14,568.60) |
| Net property and equipment | $ 23,301.70 | $ 24,557.50 |
| Total assets | $ 32,155.60 | $ 34,281.40 |
| Liabilities and shareholders’ equity | ||
| Current liabilities | ||
| Accounts payable | $ 702.00 | $ 860.10 |
| Income taxes | $ 372.10 | $ 166.80 |
| Other taxes | $ 317.00 | $ 330.00 |
| Accrued interest | $ 182.40 | $ 233.70 |
| Accrued payroll and other liabilities | $ 1,178.40 | $ 1,157.30 |
| Total current liabilities | $ 2,751.90 | $ 2,747.90 |
| Long-term debt | $ 14,291.80 | $ 14,989.70 |
| Other long-term liabilities | $ 1,997.60 | $ 2,065.90 |
| Deferred income taxes | $ 1,711.00 | $ 1,624.50 |
| Shareholders’ equity | $ - 0 | $ - 0 |
| Preferred stock, no par value; authorized – 165.0 million shares; issued – none | $ - 0 | $ - 0 |
| Common stock, $.01 par value; authorized – 3.5 billion shares; issued – 1,660.6 million shares | $ 16.60 | $ 16.60 |
| Additional paid-in capital | $ 6,312.30 | $ 6,239.10 |
| Retained earnings | $ 43,290.00 | $ 43,294.50 |
| Accumulated other comprehensive income | $ (2,482.00) | $ (1,519.70) |
| Common stock in treasury, at cost; 702.1 and 697.7 million shares | $ (35,733.60) | $ (35,177.10) |
| Total shareholders’ equity | $ 29,403.70 | $ 31,533.50 |
| Total liabilities and shareholders’ equity | $ 32,155.60 | $ 34,281.40 |
| 2015 | 2014 | |
| Current Ratio | 1.3055706966 | 1.5231631428 |
| Quick ratio | $ 1.00 | $ 1.20 |
