Now is the time we will really put our formulas to work and prepare the base for

Question

Now is the time we will really put our formulas to work and prepare the base for a detailed Financial Analysis of Yahoo and Google. Prepare a document showing each of the ratios from Chapter 3 (this chapter will be invaluable for this submission and even gives you an example) along with the book value per share and DuPont analysis for both companies for each of the last five fiscal years; use the Financial Statements filed with the SEC. This submission can be an Excel spreadsheet containing the calculated values. With book value per share, 13 ratios from Chapter Three, and the DuPont anlaysis, there are 15 calculations per year per company, so with two companies and 5 years for each we will have about 150 calculations. The best way to approach the assignment is to use Excel to work the calucations for you. This will help you save time since you only have to build the formulas once and then use that template for the other years.

Explanation / Answer

Project instructions:
Now is the time we will really put our formulas to work and prepare the base for a detailed Financial Analysis of our two companies in preparation for submitting our recommendations in Week Seven. Prepare a document showing each of the ratios from Chapter 3 (this chapter will be invaluable for this submission and even gives you an example) along with the book value per share and DuPont analysis for both companies for each of the last five fiscal years; use the Financial Statements filed with the SEC. This submission can be an Excel spreadsheet containing the calculated values.

With book value per share, 13 ratios from Chapter Three, and the DuPont anlaysis, there are 15 calculations per year per company, so with two companies and 5 years for each we will have about 150 calculations. The best way to approach the assignment is to use Excel to work the calucations for you. This will help you save time since you only have to build the formulas once and then use that template for the other years.

This piece of the project is all about the numbers, so it is the only one of the four parts you can submit in Excel (in fact, Excel can make this much easier for you!).

Scoring

Ratios shown (all applicable ratios from Chapter Three and book value per share), including data for the last five years 35 pts.
DuPont Analysis 15 pts.
Total Points Possible 50 pts.

Yahoo vs. Google Financial Analysis

Leakhena Williams

Introduction
Yahoo and Google are all IT based firms which provide numerous services online. The two companies are competitors in the technology services sector and are dominant stakeholders on the internet software and service business. The two are among the giants of search online and, therefore, make an excellent study for comparison. Both companies boast of a number of products which are in use in the current market ranging from search (Yahoo Answers, Google Books) to Communication services (Gmail and Yahoo Mail)
As they serve their clients, both companies have financial obligation that they strive to achieve. Shareholders are always concerned about how their companies are performing financially, and the shareholders in Yahoo and Google are not any different. They are concerned about the companies

Related Questions

Navigate

• Browse (All)
• Browse N
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.