Reference no: EM131147073
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.
• 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.
|
Raytheon financial document
: Find a line item listed on either the income statement or balance sheet that would indicate an adjusting entry was necessary and describe the entry.
|
|
Public police agency and private security agency
: What are the differences between a public police agency, i.e. Police Department, and a private security agency? What are the advantages of using a private security force over a public police agency (and vice versa)
|
|
How diversity is beneficial in law enforcement employment
: The effect community policing has on diversity relations. How diversity is beneficial in law enforcement employment and retention practices and At least one diversity in policing concept discussed in the video clips from this week
|
|
How is this used in the community
: Explain crime mapping. How is this used in the community? In your discussion be sure to include information about the place theories, street theories, and neighborhood theories
|
|
Identify a quantifiable measure for the 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:
|
|
Create a gantt chart
: Create a Gantt chart that displays 36 months, using the Office Timeline tool or any other tool to produce a Gantt chart.
|
|
What are the cons of using such a system
: What are "good time" credits? How do the use of good time credits and "voluntary" prison programs aimed at rehabilitation help the corrections system to reduce the length of time an offender serves? What are the other benefits of this practice for..
|
|
Briefly explain choice theory and routine activities theory
: Briefly explain choice theory and routine activities theory and the relevance to digital crime
|
|
Prepare a metes-and-bounds description for the parcel
: Prepare a metes-and-bounds description for the parcel shown in the accompanying figure. Assume all corners are marked with 1-in.-diameter steel rods, and a 20-ft meander line setback from Indian Lake.
|