Question;Instructions:1. You may discuss this assignment with other students however, submission must be completedINDIVIDUALLY and be your own work.2. You must use Excel (.xls/.xlsx) to complete your assignment. Include your name in thefilename.3. Show work neatly. State any assumptions needed.4. Hand in your assignment in hard copy in class on November 25.. The entire project must betyped and presented in a professional manner.You must use Google Inc Financial Statements for the year ended 2008. Make sure youuse the audited annual financial statements or your answers may not be correct! (Youwill also need the 2007 balance sheet to calculate some prior year averages. Allinformation must come from these statements.1)Complete the horizontal analysis of the balance sheet for 2007-2008. Show the balancesheet figures and the $ change and % change.2) Complete the horizontal analysis of the income statement for 2007-2008 Show thebalance sheet figures and the $ change and % change.3) Complete the vertical analysis of the income statement for 2007-2008 Show the incomestatement figures and the appropriate %s.4) Complete the ratio calculations for 2007-2008 for all ratios as provided in the classhandout.- Show a complete reference to all calculations (this must be outside of the formulas inExcel).- State any assumptions you make.- You will need 2008 balance sheet for some of the averages.- If some ratios are not-applicable, state so and why.- If a ratio is already calculated within the GAAP statements, you can just state it andreference where you found it.- Use year-end closing market price for shares and quote your source.5) Provide a discussion of the competitive position of the firm and its financial health. Youranalysis should include a qualitative and quantitative analysis. Support your analysiswith the above quantitative analysis including ratio analysis, vertical and horizontalanalysis.6) The library project conducted during this term to access the position Google is in, alongwith their economic and competitive environment., will provide you the detail tocomplete the qualitative analysis. You may use the current information reviewed in thisassignment as part of your analysis along with anything you feel is relevant from theearlier time frame. However, you are only responsible for the current review of Google asoutlined in your library assignment.Google Inc.The term project worth 15% of your final grade in this course is comprised of three (3) distinctparts:Part 1: Library Assignment on GooglePart 2:____/5% - ratio analysis ? including:horizontal analysis of the balance sheetHorizontal analysis of the income statementVertical analysis of the income statementRatio calculations ? for two (2) yearsThis part is graded by the faculty assistant with emphasis on correct calculation of ratios.????Part 3:____/5% - report on Google Inc.. The main body of the report will discuss your opinionabout the financial health of the company.Your opinion will include a discussion of all ramifications of your findings ? for example,assume Google has a huge amount of debt ? your debt ratio says 75%. What are theconsequences of this? Can they service this level of debt? Where can they get funds from? Canthey pay their current liabilities? Can they get funds from creditors or investors? How, in troubleare they?Your findings must be supported by the relevant parts of the analysis conducted in Part 2. Finally,your report will provide a conclusion. Your conclusion must provide your final opinion ? is this afinancially healthy or unhealthy company? You conclusion will be supported by a summary ofthe facts that made you formulate this opinion.
Paper#52582 | Written in 18-Jul-2015Price : $56