Please help answer Chp 2 Problem 2A & 2B by using excel formulas

PROBLEM-SOLVING EXERCISES 1. Identify three companies that make the highest quality products or services for an industry of your choice. Find the number of employees, total sales, total profits, and earnings growth rate for these three firms. Using a database program, enter this information for the last year. Use the database to generate a report of the three com- panies with the highest earnings growth rate. Use your word processor to create a document that describes these firms and why you believe they make the highest-quality products and services. What other measures would you use to determine the best company in terms of future profit potential? Does high quality always mean high profits? 2. A new IS project has been proposed that is expected to produce not only cost savings but also an increase in revenue. The initial capital cost to establish the system is estimated to be $500,000. The remaining cash flow data is presented in Table 2.10. a. Using a spreadsheet program, calculate the payback period, internal rate of return, and net present value for this project. Assume that the cost of capital is 7 percent and the effective tax rate is 40 percent b. How would the payback, internal rate of return, and net present value change if the capital cost for the project was $750,000 and the cost savings and increased revenue were decreased by 25 percent each year? 3. Using a database program, develop a table listing five popular Internet sites for a job search. The table should include columns on any costs of using the site, any requirements such as salary and job type, important features, advantages, and disadvantages. YABLE 2.10 Problem solving exercise 1 2 5 $500 Capital Increased revenue Cost savings Depreciation expense Operating and maintenance expense Nendreds of thousand w $50 $110 $150 $75 $75 $125 $125 $50 $100 $125 $100 $50 $115 $125 $75 $50 $130 $125 $50 $50