• Amazon.com Inc.[AMZN]
• Best Buy Co. Inc.[BBY]

1. Evaluate the financial opportunity presented by the companies. If i was the creditor, which company should i lend money to?
2. Which company should i recommend as an investment?
3. At which company should i prefer a management position and why?
4. What is the base year for a trend analysis?
5. What is the percentage used for the base year and how do i calculate the percentages for the other years?

IN EXCEL:

Make a 5-year trend analysis for each company:

Net sales.

Net income.

Compute forthe two most recent yearsthe:

Debt to assets ratio.

Compute fortwo most recent yearsthe:

Profit margin.

Asset turnover.

Return on assets.