Question
a. Marketing: Prepare a five-year sales forecast for the company. List and explain/quantify each factor that went into your forecast (e.g., past three year company
a.Marketing: Prepare a five-year sales forecast for the company. List and explain/quantify each factor that went into your forecast (e.g., past three year company sales trends). Do not rely solely upon past sales trends. Make this a high level forecast and include broad items that would affect strategy. Show your calculations in a table and, if needed, explain your calculations so they are clear. Analyze your marketing efforts in terms of product, price, place, and promotion.
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