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

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


Part II

Create a 16-slide Microsoft® PowerPoint® presentation, including detailed speaker notes or voiceover:

  • Define the answers you calculate in Part I.
  • Analyze the results you arrived at in Part I.
  • Interpret the answers you calculated.
  • Present the rationale behind each item and why it supports the team’s decision.
  • Describe the relationship between NPV and IRR. Hint: The key factor is the discount rate used.

Format your assignment consistent with APA guidelines.

Click the Assignment Files tab to submit your assignment.

Note: Submit both the presentation and the Excel® spreadsheet with all calculations.

MATERIALS

Copyright ©2016 by University of Phoenix. All rights reserved.

Please site you rreferences and use apa format

Learning Team: Quality Management and Quality Control

Purpose of Assignment

The Week 6 assignment combines aspects of quality management and control while synthesizing concepts learned throughout the course to make effective decisions.

Grading Guide

Content Met Partially Met Not Met Comments:
The team computed and analyzed the financial data for the selected company including the following:

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.

The team identified a quantifiable measure for the company such as service time, percent of errors, etc. and 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

The team defined the answers you calculate in Part I.
The team analyzed the answers calculated in Part I.
The team interpreted the results arrived at in Part I.
The team presented the rationale behind each item and why it supported the team’s decision.
The team described the relationship between NPV and IRR.
The presentation consists of 16 slides and is appropriate for the audience.
The presentation includes relevant media and visual aids that are consistent with the content.
Total Available Total Earned
X X/X
Presentation Guidelines Met Partially Met Not Met Comments:
The presentation uses a proper layout with effective headings, fonts, styles, font sizes, and white spaces.
The presentation recognizes intellectual property using in-text citations and a reference slide.
The presentation includes an introduction and conclusion which previews and reviews major points.
The presentation includes major points that are stated clearly, organized logically, and supported by specific details, examples, or analysis.
The presentation follows proper rules of grammar and usage including spelling and punctuation.
find the cost of your paper
Order now to get your homework done

Clarify the role of each legally mandated attendee on the Individualized Education Program team

This discussion assesses your ability to clarify the role of each legally mandated attendee on the Individualized Education Program team. This assessment also supports your achievement of Course Learning Outcome….

Describe the performance of “Salt Peanuts” provided in your Module 3 Playlist

n 100 words or more, describe the performance of “Salt Peanuts” provided in your Module 3 Playlist. Being a live performance, there are certain characteristics that we don’t have in….

Analyze the fixed and variable costs of a firm, how those costs have changed over time, and how those changes have impacted the firm’s overall health and sustainability

The purpose of this milestone is for students to explore the various costs their firm faces and to describe their firm’s market. Using the concepts and tools developed in Modules….