Compute and analyze the financial data

Assignment Help Business Management
Reference no: EM131251331

Please advise how much it will cost.  The selected company is APPLE.

The team works for a company that is looking to make an acquisition of another company. The team must make a recommendation as to whether or not the company should make an offer based on the information below. The team must present their recommendation and all supporting information to the executive team.

Select a company with which the team is familiar. This should be a publicly traded company with sufficient financial data available online.

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).
  • Determine if the team would recommend acquiring this company based on the 4 calculations above; 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
  • Cause and Effect (Fishbone) Diagram
  • Pareto Chart
  • Control Charts
  • Histograms
  • Scatter Diagrams

Reference no: EM131251331

How would you approach the development of a training program

How would you approach the development of a training program to address management's deficiencies? For the purpose of this assignment, let us assume that the manager is stru

Organizational research and theory

1. Describe how emotional intelligence and understanding personality types are important for developing relationships. 2. Examine the extent to which you believe that personal

Helpful in generating and refining topics

This assignment should be helpful in generating and refining topics for your upcoming Narrative essay (look ahead to the Narrative Essay writing criteria). This practice als

Simplified management processes

Technological advances have greatly simplified management processes. However, technology has complicated some of the "control" issues between the employee and the employer.

Sound project management practices

"1. Report your assessment of the current project status. 2. Compare your assessment with sound project management practices. 3. Recommend steps to bring the project to a clos

How you would coordinate both the individual employees plan

Explain how you would coordinate both the individual employee's plan and the company's needs assessment into a comprehensive development plan. Be sure to identify overlaps o

Required to pick a current economic topic

For the term paper, you are required to pick a current economic topic that relates to the material we have covered or will cover in this course. You will research and find a

Analyzing the marketing research process

Analyzing the marketing research process and ethical concerns that marketing research managers must consider while conducting research. Write a 2-3 page APA style formatte

Reviews

Write a Review

 
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd