The team works for a company that is looking to make an acquisition of another company. The team must make...
mohasfadtapa2307The 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
- 8 years ago
- 999999.99
Purchase the answer to view it
- the_team_works_for_a_company.xlsx
Purchase the answer to view it
- answer-forecast.xlsx
- Google Only
- BUS 250 Week 3 DQ 1 ( Business & the Environment ) ~ 2 Different Answers ~ A + Tutorial With References
- 1. Internal control is: A) The act of stealing a business’ assets B) The preparation of fraudulent financial statements
- FOR A-PLUS WRITER ONLY
- HHS 460 Week 2 DQ 2 ( Research Venues ) ~ 2 Different Answers ~ A + Tutorial With References
- Should a person go against oneâs country to do the right thing? Why or why not? Be specific as to...
- ACCT346 Week 6 Quiz - 1
- ACC 490 Week 3 Individual Assignment Ch. 5, 6, & 7 Comprehensive Questions
- FOR A-PLUS WRITER ONLY
- spr drg