Question
I have an assignment which is Ratio Analysis report where, I have choose Google a publicly traded company for this assignment so can you just
I have an assignment which is Ratio Analysis report where, I have choose Google a publicly traded company for this assignment so can you just focus on that one traded company i choose which is Google in order to conclude the report and Can you please compose a four-five page report as a full paragraph, including Introduction part, Ratio analysis, Recommendations and Reflection part of Google company : Specifically, the primary question to answer is: will THE COMPANY ( Google) be financially viable over the next two to three years, and which steps should be taken to improve its financial stability? THE SPECIFIC ASSIGNMENT Using the information from the websites the students will develop ratio analysis of the financial performance for THE COMPANY (Google). 1- Introduction - Can you please compose with a short introduction, explains the purpose of the paper, and provides an overview of the contents that follow (one short paragraph) ? 2- Ratio analysis - In this part of the project you will complete ratio analysis of THE GOOGLE COMPANY. Please remember that you are the financial analyst of THE GOOGLE COMPANY and should prepare the report to be read by the chairman (CEO) of THE GOOGLE COMPANY. a) Collect the following ratios for Google COMPANY for the last 3 years. Present the ratios as the table(s) in your project. Compose a graphs for some ratios on your choice to show trends. If you are using published ratios you must cite the source ? * Liquidity ratios: current ratio, quick ratio * Operating efficiency ratios: Days of Sales in Inventory, Accounts Receivable Turnover, Inventory Turnover, Total Assets Turnover * Profitability ratios: Gross Profit Margin, Operating Profit Margin, Net Profit Margin * Debt-to-Equity, Time Interest Earned (TIE), Financial leverage (also called Equity Multiplier) * ROA, ROE Liquidity ratios, Debt-to-Equity, and Financial leverage ratios are available on www.morningstar.com > type the stock symbol in the Search window to get into the company's page. Click on Valuation and scroll down to Key Statisies > choose Financial Health tab ? Operating efficiency ratios, Profitability ratios, ROE, and ROA ratios are available on www.morningstar.com > type the stock symbol in the Search window to get into the company's page. Click on Valuation and scroll down to Key Statistics > choose Operating and Efficiency tab? c) Can you please compose about long paragraphs of analysis of the ratio results that you collected. In your analysis you should answer the following questions: * How liquid is the company? * Analyze operating efficiency ratios. What important information does this analysis provide? * Is management generating a substantial profit on the company's assets? * How is the company financing its assets? Discuss how much risk is associated with the financial structure the company ? * Have the company's ROA and ROE changed over the last three years? What was the main factor that influenced this change? To answer this question, apply DuPont analysis and three factors of the DuPont formula: Net profit margin, asset turnover, financial leverage. What ratio(s) has (have) been changed mostly over these three years and why? 3. Can you please develop a specific recommendation, with supporting rationale, as to whether the assigned company's recent results in ratio analysis is of sufficient financial strength, will THE GOOGLE COMPANY be financially sustainable over the next several years, and which steps should be done to improve its financial stability? If the management of the company would like to improve the company's financial performance, what should the management of THE GOOGLE COMPANY do? Your recommendations should be based on the results of your analysis in the project ? 4- Reflection - Can you please compose a full write a paragraph in your simple words reflecting on specifically what they learned from the assignment and how they think they could apply what they learned in the workplace ? 5. Can you please provide 2-3 sources for the Google company i choose for reference list and can you please include in-text citations in APA-7th edition style and Please note that you must reference the data you are using for the project ?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started