Question
Finance: Prepare financial analyses using data from the financial statements. Use specific ratios or other measures to assess the financial strengths and weaknesses of your
Finance: Prepare financial analyses using data from the financial statements. Use specific ratios or other measures to assess the financial strengths and weaknesses of your company using appropriate baseline comparisons. Provide this in table form. Provide the formula for each item used. Address any other issues in the case that might affect the current financial position. Be sure to address Liquidity, Safety (e. g., leverage), Profitability, and Efficiency ratios.
ATTACHMENT 1 COMPANY CASE FINANCIAL | |||||||||
AND COMPETITOR/INDUSTRY INFORMATION | |||||||||
| |||||||||
INCOME STATEMENTS | Smith Last Year | Smith Percent of Sales | Smith 2 Years Ago | Smith Percent of Sales | Smith 3 years Ago | Smith Percent of Sales | Global Market Leader | Global Market Leader | Industry Average |
| $Million |
| $Million |
| $Million |
| $Million |
|
|
Revenue | 48.127 | 100.0% | 48.992 | 100.0% | 52.102 | 100.0% | 348,650 | 100.0% | $25.00 |
Cost of Goods Sold | 38.453 | 79.9% | 39.292 | 80.2% | 41.786 | 80.2% | 265,152 | 76.1% | 80.0% |
Gross Profit | 9.674 | 20.1% | 9.700 | 19.8% | 10.316 | 19.8% | 83,498 | 23.9% | 20.0% |
Operating Expense | 7.893 | 16.4% | 8.132 | 16.6% | 7.659 | 14.7% | xxxxxxx | xxxxxx | xxxxxxx |
General & Administrative | 1.059 | 2.2% | .686 | 1.4% | .625 | 1.2% | xxxxxxx | xxxxxx | xxxxxxx |
Marketing | .193 | 0.4% | .245 | 0.5% | .313 | 0.6% | xxxxxxx | xxxxxx | xxxxxxx |
Operating, Gen., Sell, & Admin. | xxxxxxx | xxxxxx | xxxxxxx | xxxxxx | xxxxxxx | xxxxxx | 64,320 | 18.4% | 15.0% |
Interest Expense | .385 | 0.8% | .193 | 0.4% | .312 | 0.6% | 1,529 | 0.4% | 1.6% |
COGS and Total Expenses | 47.983 | 99.7% | 48.548 |
99.1% | 50.695 | 97.3% | 331,001 | 94.9% | 96.6% |
Net Income Before Taxes | .144 | 0.3% | .444 | 0.9% | 1.407 | 2.7% | 17,649 | 5.1% | 3.4% |
Taxes | .048 | 0.1% | .147 | 0.3% | .469 | 0.9% | 6,365 | 1.8% | 0.9% |
Net Income After Taxes | .096 | 0.2% | .297 | 0.6% | .936 | 1.8% | 11,284 | 3.3% | 2.5% |
BALANCE SHEETS | $Million |
% Total Assets | $Million | % Total Assets | $Million | % Total Assets | $Million | % Total Assets |
|
Cash & Equivalents | .288 | 1.0% | .440 | 1.5% | 2.421 | 7.9% | 8,373 | 5.5% | 1.7% |
Receivables | .548 | 1.9% | .469 | 1.6% | .429 | 1.4% | 3,840 | 2.5% | 2.2% |
Inventory | 7.694 | 26.7% | 8.155 | 27.8% | 8.582 | 28.0% | 34,375 | 22.8% | 24.6% |
Total Current Assets | 8.530 | 29.6% | 9.064 | 30.9% | 11.432 | 37.3% | 46,588 | 30.8% | 28.5% |
Land, Stores, Equipment, Distribution Centers, & Trucks | 20.289 | 70.4% | 20.268 | 69.1% | 19.216 | 62.7% | 104,605 | 69.2% | 71.5% |
|
|
|
|
|
|
|
|
|
|
Total Assets | 28.819 | 100.0% | 29.332 | 100.0% | 30.648 | 100.0% | 151,193 | 100.0% | $13.457 |
|
|
|
|
|
|
|
|
|
|
Accounts Payable | 7.407 | 25.7% | 6.921 | 23.6% | 3.287 | 10.7% | 28,371 | 18.8% | 12.1% |
Other Current Liabilities | 5.043 | 17.5% | 8.151 | 27.8% | 6.554 | 21.4% | 23,363 | 15.4% | 10.1% |
Total Current Liabilities | 12.450 | 43.2% | 15.072 | 51.4% | 9.831 | 32.1% | 51,734 | 34.2% | 22.2% |
Long Term Debt | 4.813 | 16.7% | 2.407 | 8.2% | 3.900 | 12.7% | 37,886 | 25.1% | 39.3% |
Stockholder's Equity | 11.556 | 40.1% | *11.853 | 40.4% | 16.917 | 55.2% | 61,573 | 40.7% | 38.5% |
Total Liabilities & Stockholder Equity | 28.819 | 100.0% | 29.332 | 100.0% | 30.648 | 100.0% | 151,193 | 100.0% | $13.457 |
|
|
|
|
|
|
|
|
|
|
Year End Stock Price | $6.25 |
| $10.00 |
| $13.13 |
|
|
|
|
Dividends | $0.00 |
| $0.00 |
| $0.00 |
|
|
|
|
*Equity withdrawal in 2 years ago |
|
|
|
|
|
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started