What data should be included in my spreadsheet, how would I set this up using the company information that I have attached? What page of this financial report can I use?

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).

Determine if the team would recommend acquiring this company based on the 4 calculations above; do you recommend acquiring this company?

• Download Attachments:
• MC DONALD ANNUAL REPORT 2015 (4) (1).pdf