Question

In: Accounting

Using Excel and WorldCom's income statement and balance sheet for 2001, provided on pages F-2 and...

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.

http://www.sec.gov/Archives/edgar/data/723527/000100547702001226/d02-36461.txt

Solutions

Expert Solution

ekkarill92 answered 1 year ago
Next > < Previous

Related Solutions

Using the formulas provided for the exam, and the balance sheet and income statement shown below,...
Using the formulas provided for the exam, and the balance sheet and income statement shown below, calculate the ratios (1 point each): CORRIGAN CORPORATION: BALANCE SHEET AS OF DECEMBER 31: Cash                                                         72,000 Accounts Receivable                              439,000 Inventory                                                 894,000             Total Current Assets               1,405,000 Land and Building                                  238,000 Machinery                                               132,000 Other Fixed Assets                                    61,000 Total Assets                                         1,836,000                                                           ========== Accounts Payable                                     80,000 Accrued Liabilities                                    45,010 Notes Payable                                         476,990             Total Current Liabilities            602,000 Long-term Debt                                       404,290              Total Liabilities                       1,006,290 Common Stock                                       ...
Using Microsoft Excel, create a balance sheet and an income statement using the relevant information below...
Using Microsoft Excel, create a balance sheet and an income statement using the relevant information below Calculate the Net Working Capital and the Net Operating Working Capital for both years Perform vertical analysis on both statements, for both years Perform Horizontal analysis on both statements for the most current year What was the Net Operating Profit After Taxes for both years? 2016 Accounts Receivable 400 Sales 5000 Accounts Payable 650 Inventory 1400 COGS 3000 Common Stock 1500 Cash 1600 Oper....
Prepare the Income Statement, Balance Sheet and Statement of Owner's Equity in an Excel File. (1)....
Prepare the Income Statement, Balance Sheet and Statement of Owner's Equity in an Excel File. (1). Mr. Sheng sought an attorney for legal advice to help him start a company, The Sheng Enterprise, which sells native rattan bags. On January 1, 2010, Mr. Sheng invested P2,000,000.00 cash in the business. The attorney advised him to hire an accountant for his bookkeeping. Mr. Sheng paid P1,000.00 for the legal services. However, Mr. Sheng was preoccupied with the product development that was...
A) You are provided with the balance sheet and income statement of the Neuman Corporation: Construct...
A) You are provided with the balance sheet and income statement of the Neuman Corporation: Construct a cash flow statement for the year ended Dec 31, 2008. Note that this company has also paid dividends on the common stock, but you need to find out how much by yourself. Hint: take a look at retained earnings. The company had no preferred stock (50% of exam grade) BALANCE SHEET ASSETS 2007 2008 Cash 45,000 50,000 Marketable Securities 275,000 160,000 Accounts Receivable...
A) You are provided with the balance sheet and income statement of the Neuman Corporation: Construct...
A) You are provided with the balance sheet and income statement of the Neuman Corporation: Construct a cash flow statement for the year ended Dec 31, 2008. Note that this company has also paid dividends on the common stock, but you need to find out how much by yourself. Hint: take a look at retained earnings. The company had no preferred stock (50% of exam grade) BALANCE SHEET ASSETS 2007 2008 Cash 45,000 50,000 Marketable Securities 275,000 160,000 Accounts Receivable...
4) Using the balance sheet from #3, construct an income statement and balance sheet for     ...
4) Using the balance sheet from #3, construct an income statement and balance sheet for      the first month of operation, given the following information:     Sales $104,000.00 Collections $77,000.00 Purchases (paid for half) $60,000.00 Ending inventory $57,000.00 Equipment Depreciation $18,000.00 Vehicle Depreciation $2,000.00 Heat (due next month) $450.00 Electricity $325.00 Telephone $230.00 Advertising $1,200.00 Salaries $15,500.00 Payroll Tax Expense $1,700.00 Office Supplies $200.00 Insurance (due next month) $1,250.00 Loan payment $3,500.00     principal $1,500.00     interest $2,000.00 Legal fees...
Describe the information provided by each of these financial statements: Income Statement, Balance Sheet, Statement of...
Describe the information provided by each of these financial statements: Income Statement, Balance Sheet, Statement of Cash Flow. Identify ten business questions that can be answered by using financial accounting information. For each question, indicate which financial statement (or statements) would be most helpful in answering the question, and why. Identify ten business questions that can be answered by using financial accounting information. For each question, indicate which financial statement (or statements) would be most helpful in answering the question,...
Income statement and balance sheet data for Great Adventures, Inc., are provided below.
Income statement and balance sheet data for Great Adventures, Inc., are provided below. GREAT ADVENTURES, INC. Income Statement For the year ended December 31, 2022 Net sales revenues       $ 193,410   Interest revenue         400   Expenses:             Cost of goods sold $ 39,900         Operating expenses   68,480         Depreciation expense   18,650         Interest expense   10,276  ...
Edman Company is a merchandiser that has provided the following balance sheet and income statement for...
Edman Company is a merchandiser that has provided the following balance sheet and income statement for this year. Beginning Balance Ending Balance Assets Cash $ 62,800 $ 150,000 Accounts receivable 160,000 180,000 Inventory 230,000 240,000 Property, plant & equipment (net) 833,000 793,000 Other assets 37,000 37,000 Total assets $ 1,322,800 $ 1,400,000 Liabilities & Stockholders’ Equity Accounts payable $ 70,000 $ 80,000 Bonds payable 550,000 550,000 Common stock 410,000 410,000 Retained earnings 292,800 360,000 Total liabilities & stockholders’ equity $...
Edman Company is a merchandiser that has provided the following balance sheet and income statement for...
Edman Company is a merchandiser that has provided the following balance sheet and income statement for this year. Beginning Balance Ending Balance Assets Cash $ 62,800 $ 150,000 Accounts receivable 160,000 180,000 Inventory 230,000 240,000 Property, plant & equipment (net) 833,000 793,000 Other assets 37,000 37,000 Total assets $ 1,322,800 $ 1,400,000 Liabilities & Stockholders’ Equity Accounts payable $ 70,000 $ 80,000 Bonds payable 550,000 550,000 Common stock 410,000 410,000 Retained earnings 292,800 360,000 Total liabilities & stockholders’ equity $...
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT