Calculate the five-year projected income

Assignment Help Business Management

Reference no: EM131405908

Quality Management Assignment

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. APPLE
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. please no Google Docs. 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).

Reference no: EM131405908

Questions Cloud

Analyse the operation of magnetically coupled circuits : You are consultant electrical engineer. You have been asked to magnetically coupled circuits and document your findings in a technical report. Analyse the operation of magnetically coupled circuits

Discuss about the treatment of juvenile offenders : Provide a brief description of the topic to your instructor. Include a brief discussion of the treatment for the offender population. This could include the type of treatment-related assessment, the assessment instruments used and the treatment ap..

Analyze how you will address jims recent performance issues : Explain how you will address Jim's recent performance issues. Suggest both constructive and positive feedback designed so that Jim will leave motivated to do his best.

Articulate your personal clinical focus of systemic family : you will articulate your personal clinical focus (or PCF) of the systemic family therapy model of parent- child interaction for the course. You will also complete the PCF worksheet (attached) describing your PCF for course, which centers on a spe..

Calculate the five-year projected income : Compute and analyze the financial data using a Microsoft Excel spreadsheet. Calculate the 5-year projected income. Calculate a 5-year projected cash flow. Calculate net present value (NPV).

Indicate whether the potential bias is a selection bias : In each of the given situations, indicate whether the potential bias is a selection bias, a nonparticipation bias, or a response bias.

Consider the psychological career alternatives available : Consider the psychological career alternatives available and determine from which fields of expertise your two points of view will come.Select the two professionals you will use with expertise on the topic you selected. Your professionals' identi..

What you liked and did not like about the experience : What you liked and didn't like about the experience? How you've changed? How other people have reacted? What you are going to do differently (short-term AND long-term) in your life based on your experience.

What is the population of interest in given survey : To estimate the percentage of households in the United States that use a DVD player, a researcher surveys a randomly selected sample of 500 households and asks about DVD player usage.- What is the population of interest in this survey?- What is the..

User Account

All Pages