Reference no: EM131093865
Quality Management and Quality Control
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.
Locate 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. How do I do this
- 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
- 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
https://www.4-traders.com/GOOGLE-INC-9469/financials/
I Need to create a Calculate the 5-year projected income. I'm using Google financial statement.
This is the financials I'm using to create the income projection. Do I start by using the data in 2015 -2019, or 2016-2020. And are these the financial income data I need to use for the income projection.
Sales
Operating profit
Net income
Net Margin
Operating Margin
|
Assess the political and economic risks
: Consider recent event and the prevailing political and economic condition in the Russian Federation. As a manager who has been considering investment there . How do you assess the political and economic risks at this time?
|
|
Customer requirement analysis and advice to acquisition team
: You may complete this exercise individually or as a group. Students will form their own groups with some other students. Groups will work through the week to answer the questions relating to the exercise below.
|
|
Find the competitive allocation of families over lots
: Consider land prices in a rectangular country. The northern edge of the country is a desirable seacoast, which is 100 indivisible lots wide. Find the competitive allocation of families over lots, and the price of each lot
|
|
Do we have sufficient evidence to reject the hypothesis
: Fear of darkness is a common emotion. The following data were obtained by asking 200 individuals in each age group whether they had serious fears of darkness. At α = 0.01, do we have sufficient evidence to reject the hypothesis that "The same prop..
|
|
Quality management and quality control
: 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 recommend..
|
|
Set up differential equation which describes dv/dt in term v
: You decide to start a 401k account. You begin with an initial investment of $5000, and you continuously add to it at a rate of $1000 per year. At the same time, the account accrues interest at a continuous rate of 5% annually. Let V (t) be the val..
|
|
Derive the marshallian labor supply curve
: Suppose a worker chooses consumption, C, and leisure, l, to maximize the utility function U(C, l) = α((C- γ)ρ -1/ρ) + ((l- γ0)ρ_0-1/ρ0). Suppose ρ = 0. Derive the Marshallian labor supply curve
|
|
Determining the break-even analysis
: When expenses and revenues are equal, this is known as the "break-even point" or BEP. To determine break-even, an examination of fixed and variable costs (expenses) in relationship to revenues is necessary. Understanding where the BEP is for a giv..
|
|
The impact of sunk-opportunity and accounting costs
: To prepare for this Discussion, "Shared Practice: The Impact of Sunk, Opportunity, and Accounting Costs," refer to your Learning Resources for this week, research in the Walden library, and your professional experience.
|