Please give answers to data in excel file in accordance to the Balance sheet and other relevant data
Exhibit 2 balance on December March 2005 March 2006 March 2007 March 2008 March 2009 2009 Assets Cash and Equivalents 137,562 126,282 183,521 179,986 147,512 152,282 Short-term Investments 1,501 7,176 6,224 2,272 2,577 2,871 Accounts Receivable 218,252 230,524 256,669 238,439 167,951 175,722 Other Current Assets 182,571 252,548 295,660 269,185 211,574 129,997 Total Current Assets *539,886 V616,530 *742,074 V689,882 4529,614 X460,872 Operating Property and Equipment 1,999,094 1,927,669 2,463,566 2,363,769 2,372,257 2,352,356 Less: Accumulated Depreciation 1,176,476 1,139,897 1,369,543 1,335,091 1,341,048 1,342,411 Net Operating Property V822,618 V787,772 *1,094,023 *1,028,678 *1,031,209 *1,009,945 Other Long-term Assets 228,986 265,964 259,507 265,966 225,087 210,535 Total Assets *1,591,490 V1,670,266 2,095,604 *1,984,526 V1,785,910 V1,681,352 Liabilities Short-term Debt 18,448 57,459 150,594 148,430 107,588 75,878 Long-term Debt Maturing within One Year 77,715 102,476 171,569 151,901 175,716 285,144 Current Obligations under Capital Leases 0 0 0 4,143 5,117 Other Current Liabilities 335,465 384,139 472,319 493,344 466,493 387,981 Total Current Liabilities V431,628 4544,074 *794,482 V797,818 *755,114 *749,003 Long-term Debt 782,970 729,850 785.414 712,967 582,224 560.057 Long-term Obligations, Capital Leases 0 0 0 18,902 18,691 Pensions and other Benefits 105,038 94,943 126,706 94,201 94,785 97,023 127,581 159.001 189,477 119,032 Other Long-term Liabilities 56.900 142,886 Total Long-term Liabilities 944.908 1952,374 V1,071,121 1968,956 Y885,177 *776,112 Common Stock 188.550 188,550 100,000 100,000 200,000 251,000 15,210 (33,833) (13,532) (1.599) (64,602) (206,163) Retained Earnings Other Equity 11.194 19.101 143.533 114.873 10.221 111.400 Total Liabilities and Equity X1,591,490 1,670,266 2,095,604 V1,980,048 V1,785,910 V1,681,352Exhibit 1 Income Statement and Summary Financial Data in Millions of Y 12 Months Ending December March 2005 March 2006 March 2007 March 2008 March 2009 2009, TIM Total Revenue 1,537,986 1,600,486 2,120,623 2,197,416 1,949,187 1,640, 112 Cost of Goods Sold 1,238,626 1,388,350 1,761,986 1,760,483 1,690,173 1,548,387 Gross Profit *299,360 V212,136 *358,637 *436,933 *259,014 191,725 Operating Expenses 170,187 167,840 246,460 241,017 196,526 158,924 EBITDA 129,173 44,296 112,177 195,916 62,488 (67,199) Depreciation and Amortization 86,422 85,334 96,846 112,214 1 16,340 116,937 EBIT Y42,751 -V41,038 X15,331 V83,702 (453,852) (V184,136) Interest Income 2,690 3, 166 5,457 7,111 4,900 3,762 Interest Expense (19,137) (16,811) (17,192) (21,061) (18,691) (18,264) Non-Operating Income 44,968 7,374 38, 167 (48,676) 4,233 (27,759) EBT 71,272 (47,309 41.763 21,076 (63,410 (226,397) Income Tax Expense 12.000 (6,319) 56,937 8,766 2,288 5,960 Net Income V59,272 (V40,990) (V15,174) V12,310 (V65,698) (V232,357) Source: Adapted from S&P Capital IQ, Fiscal Years Ending in March; December data is the trailing 12 months (TIM).Exhibit 3 Cash Flow Statement in Millions of Y 12 Months Ending March March March March March December 2005 2006 2007 2008 2009 2009, TTM Net Income 59,272 (40,990) (15,174) 12,310 (65,698) (232,357) Depreciation and Amortization 86,422 85,334 96,846 112,214 116,340 116,937 Less: (Gain) Loss from Sale of Assets/Investments (562) 10,137 (28,796) 3,517 (6,302) 15, 185 Other Non-cash Items 10,168 (13,395 63,377 5,255 (964) (6,911) Change in Working Capital (86,978) 670 (13,804) 13,838 (15,588) 4,018 Cash from Operations V68,322 *41,756 102,449 147,134 427,788 (X103,128) Capital Expenditure (87,127) (102,303) (145,759) (178,533) (168,804) (131,303 Proceeds from Sale of PPE 91, 158 46,642 51,544 114,964 45.346 35,174 Other 21,370 6,671 33,99 24,855 16,741 23,639 Cash from Investing Activities *25,401 (48,990) (*60,224) (V38,714) (106,717) (72,490) Proceeds from Debt Issued 48,690 90,370 103,596 83,516 46,652 106,853 Repayment of Debt (109,415) (80,104) (116,245) (183.416) (194,366) (200,571) Other (7,262 (14,634) (5,250) (6.248) 192,517 192,490 Cash from Financing Activities (67,987) (V4,368) (V17,899) (#106,148) Y44.803 V98,772 FX & Cash Flow Adjustments (1,958 380 32,980 (5,332) 1, 182 1,530 Net Change In Cash V23,778 (V11,222) V57,306 (V3,060) (V32,944) (V75,316) Source: Adapted from S&P Capital IQ, Fiscal Years Ending in March; December data is the trailing 12 months (TTM).B 3 Profitability Ratios ROA 5 ROE Gross Profit Margin 7 Net Profit Margin 8 Operating Profit Margin 9 Efficiency Ratios 10 A/R Turnover 11 Avg Collection Period 12 Long-Term Debt Equity Ratio 13 Long-Term Debt Ratio 14 Leverage Ratios 15 Debt/Equity Ratio 16 Debt Ratio 17 Cash Coverage Ratio 18 Invest Coverage Ratio 19 Liquidity Ratios Cash Ratio Current Ratio Shootl
