Economics: Ford Motor company

Economics: Ford Motor company

Economics
Question:
For Ford Motor company.  Excel spreadsheet Identify the following information on the selected company: Revenues = increasing by 8% each year Expenses = increasing by 10% each year Tax rate = 25% Discount rate = 10% Part I 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). and one of these: Cause and Effect (Fishbone) Diagram Pareto Chart Control Charts Histograms Scatter Diagrams