Companies:

Amazon.com Inc.[AMZN]

Best Buy Co. Inc.[BBY]

1. How do i 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.

Profit margin.

Asset turnover.

Return on assets.