Calculate the five year projected income

Reference no: EM131185978

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.

Attachment:- Assignment.rar

Reference no: EM131185978

Questions Cloud

Economic analyses of health administrative innovations : Analyze and comment on economic analyses of health administrative innovations that are germane to the provision of health services. How have these innovations become more important in health care delivery within the context of the Affordable Care ..

How does the strong swiss franc lead to a company : How does the strong Swiss franc lead to a company (in Switzerland) making less sales growth?

Analyze the organizations statement of cash flows : Analyze the organization's statement of cash flows. Explain the format that the organization utilizes, including any unique areas of emphasis that differ from-GAAP accounting format.

Reasons substantive tests of cost of salesare limited : Substantive tests of cost of sales are usually limited for tworeasons. Discuss the two reasons substantive tests of cost of salesare limited.

Calculate the five year projected income : 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. Calculate the 5-year projected income

Which independent variable contributes the most to sales : Determine what independent variables have an influence on dependent variables, such as sales.-Determine which independent variable contributes the most to sales; it could be quality or customer service or location.

Solve for the nominal rate : Suppose the nominalrate is 11.45% and the inflation rate is 5.65%. Solve for there al rate? Suppose there alrate is 5.08% and the inflation rate is 7.12%. Solve for the nominal rate?

What aspect of the german education system you like to know : Did you experience a change of opinion between completing your reading of the fact sheet and completing your reading of the opinion piece? What aspect of the German education system would you like to know more about?

Calculate the interest rate on 1-year treasury securities : a. Calculate the interest rate on 1-year Treasury securities. b. Calculate the interest rate on 2-year Treasury securities. c. Calculate the interest rate on 3-year Treasury securities. d. Calculate the interest rate on 4-year Treasury securities.

User Account

All Pages