Company Name: Alphabet Symbol: GOOG Please answer Part A, Part

Company Name: Alphabet
Symbol: GOOG 

Please answer Part A, Part B and Part C

I have attached the PPT for ratios calculation please use that PPT for calculating the ratios

Part A: Compute the following ratios for two years. You may use Excel to compute your ratios.

1.     Debt ratio

2.     Gross profit margin

3.     Free cash flow

4.     Times interest earned

5.     Accounts receivable turnover

6.     Inventory turnover

Part B: Prepare a DuPont Analysis of ROE for two years, including computations of

1.     Return on Sales

2.     Asset Turnover

3.     Return on Assets

4.     Financial Leverage

5.     Return on Equity

Evaluate the ratio trends. Your evaluation should be consistent with your calculations for the two (2) years.

Part C: 

Write a 5-6 page report evaluating trends in all of the above ratios. Discuss whether your company’s profitability, efficiency, liquidity, and solvency are improving or deteriorating. Suggest ways the company can improve the ratios that show problems. The report should be well written with a cover page, introduction, the body of the paper (with appropriate subheadings), conclusion, and reference page. References must be appropriately cited. Use APA throughout.

Format: Double-spaced, one-inch margins, using a 12-point Times New Roman font.

Table of Contents

Calculate your order
Pages (275 words)
Standard price: $0.00

Latest Reviews

Impressed with the sample above? Wait there is more

Related Questions

Do not attach a cover sheet

For this assignment, you are to address the question(s) that follow and submit your response as per the guidelines stated in the syllabus. Please submit

New questions

Don't Let Questions or Concerns Hold You Back - Make a Free Inquiry Now!