• 100% Satisfaction Guarantee
linda_us, Master's Degree
Category: Multiple Problems
Satisfied Customers: 1402
Experience:  A tutor for Business, Finance, Accounts and other related topics.
19873544
Type Your Multiple Problems Question Here...
linda_us is online now

# Select a company with which the team is familiar. This

### Customer Question

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: Starbuck
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?
Submitted: 9 months ago.
Category: Multiple Problems
Customer: replied 9 months ago.
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: StarbuckRevenues = increasing by 8% each year
Expenses = increasing by 10% each year
Tax rate = 25%
Discount rate = 10%Part ICompute 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?
Expert:  F. Naz replied 9 months ago.

Hello

Is this your assignment question or home work question?