the first picture is for table,the second pic is the questions

The questions is all together,please solve all branches;because this homework is very hard and has a very big degrees.

Take your time

This question is from financial statement analysis course

($ in millions, except per share amounts) 409 2.898 Assets December December Vertical Common Horizontal 31, 2007 31, 2006 Size for 2007 Common Size Current Assets Cash and cash equivalents $ 1,205 $ 748 Short-term investments 2,588 3.041 Receivables 548 449 Merchandise inventories 4,028 3,338 Other current assets 712 Total current assets 9,081 7,985 Property and Equipment Land and buildings 705 580 Leasehold improvements 1,540 1,325 Fixtures and equipment 2,627 Property under capital lease 32 33 Total Property and equipment 4.904 4,836 Less accumulated depreciation 1,966 2.124 Net property and equipment 2.938 2.712 Goodwill 919 557 Trade names 81 44 Long-Term Investments 318 218 Other Assets 233 348 Total Assets $ 13,570 $ 11,864 Liabilities and Shareholders' Equity Current Liabilities Accounts payable $ 3,934 $ 3,234 Unredeemed gift card liabilities 496 469 Accrued compensation and related expenses 332 354 Accrued liabilities 990 878 Accrued income taxes 489 703 Short-term debt 41 Current portion of long-term debt 19 418 Total current liabilities 6,301 6,056 Non Current Liabilities Long-Term Liabilities 443 373 Long-Term Debt 590 178 Minority Interests 35 Total Non Current Liabilities 1,068 551 Shareholders' Equity Preferred stock, $1.00 par value: Authorized-400,000 shares; Issued and outstanding-none Common stock, $.10 par value; Authorized-1 billion shares; Issued and 48 outstanding-480,655,000 and 485,098,000 shares, respectively Additional paid-in capital 430 643 Retained earnings 5,507 4,304 Accumulated other comprehensive income 216 261 Total shareholders' equity 6,201 5,257 Total Liabilities and Shareholders' Equity $13,570 $11,864 Assume that net sales for the year of 2007 as of Dec. 31, was $60,000 and that cost of goods sold was $38,000. DE ENTRE LE 49 Q3 (20 Points) A- For the Balance Sheet above do the vertical and horizontal analysis as shown in the right columns. B- Calculate Accounts Receivable Turnover Ratio? Write your comment C- Calculate Accounts Receivable Turnover in days Ratio? Write your comment D- Inventory Turnover ratio? Write your comment E- Inventory Turnover in Days? Write your comment F- Calculate how long an investment is locked up in production before turning into cash? "calculate the operating cycle" G- Current Ratio? Write your comment H- Acid-Test Ratio ? Write your comment