Question Details

[solution] » Using Excel and WorldCom's income statement and balance sheet

Brief item decscription

Step-by-step solution file

Item details:

Using Excel and WorldCom's income statement and balance sheet

Using Excel and WorldCom?s income statement and balance sheet for 2001, provided on pages F-2 and F-3 of Form 10-K, prepare a common-size balance sheet and income statement for the years 2000 and 2001. Using formulas, compute the following ratios: gross margin percent, return on sales, return on assets, return on equity, total asset turnover, accounts receivable turnover, accounts receivable days, debt to assets, equity to assets, debt to equity, equity multiplier, current ratio, acid test, net working capital, book value per share, earnings per share, and price earnings.

Address the following questions and include your Excel spreadsheets in your submission as exhibits.

  1. What did you learn about the relationship between the income statement and balance sheet?
  2. Does your analysis raise any questions that might lead to a fraud hypothesis? Explain.

For additional details, please refer to the Module Four Activity Guidelines and Rubric document in the Assignment Guidelines and Rubrics section of the course.


About this question:

This question was answered on: Feb 21, 2020

PRICE: $24 (18.37 KB)

Buy this answer for only: $24

This attachment is locked

We have a ready expert answer for this paper which you can use for in-depth understanding, research editing or paraphrasing. You can buy it or order for a fresh, original and plagiarism-free copy (Deadline assured. Flexible pricing. TurnItIn Report provided)

Pay using PayPal (No PayPal account Required) or your credit card. All your purchases are securely protected by PayPal.

Need a similar solution fast, written anew from scratch? Place your own custom order

We have top-notch tutors who can help you with your essay at a reasonable cost and then you can simply use that essay as a template to build your own arguments. This we believe is a better way of understanding a problem and makes use of the efficiency of time of the student. New solution orders are original solutions and precise to your writing instruction requirements. Place a New Order using the button below.

Order Now