Company = Amazon
Compute and analyze the financial data using a MicrosoftÂ® ExcelÂ® spreadsheet. Make sure all calculations can be seen in the background of the applicable spreadsheet cells. In other words, leave an audit trail so others can see how you arrived at your calculations and analysis. Items should be submitted in MicrosoftÂ® ExcelÂ®; indicate your recommendation in the MicrosoftÂ® ExcelÂ® spreadsheet:
â–ªCalculate the 5-year projected income.
â–ªCalculate a 5-year projected cash flow.
â–ªCalculate net present value (NPV).
â–ªCalculate the internal rate of return (IRR).
Identify a quantifiable measure for the company such as service time, percent of errors, etc. Evaluate this data on a Scatter Diagram.
Provide two or three references.