Locate the following information on the selected company: (APPLE INC.) Revenues = increasing by 8% each year Expenses = increasing by 10% each year Tax rate = 25% Discount rate = 10%

Calculate a 5-year projected cash flow and net present value (NPV) for Apple Inc via Excel

Locate the following information on the selected company: (APPLE INC.)

  • 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).
  • Determine if the team would recommend acquiring this company based on items (a) through (d); do you recommend acquiring this company?

Identify a quantifiable measure for the company such as service time, percent of errors, etc. Select one of the following quality control tools to evaluate this data:

  • Flow chart

Last Completed Projects

# topic title discipline academic level pages delivered
6
Writer's choice
Business
University
2
1 hour 32 min
7
Wise Approach to
Philosophy
College
2
2 hours 19 min
8
1980's and 1990
History
College
3
2 hours 20 min
9
pick the best topic
Finance
School
2
2 hours 27 min
10
finance for leisure
Finance
University
12
2 hours 36 min