Question
BALANCE SHEETS 2005 2006 2007 2008 2009 Cash 310,630,300 790,419,373 1,437,227,573 1,366,526,361 1,413,474,400 A/R 316,972,950 758,988,750 1,201,094,250 1,328,523,975 1,503,560,340 Parts Inventory 253,578,360 607,191,000 960,875,400 1,062,819,180
BALANCE SHEETS
2005 2006 2007 2008 2009
Cash 310,630,300 790,419,373 1,437,227,573 1,366,526,361 1,413,474,400
A/R 316,972,950 758,988,750 1,201,094,250 1,328,523,975 1,503,560,340
Parts Inventory 253,578,360 607,191,000 960,875,400 1,062,819,180 1,201,345,530
WIP Inventory 26,789,180 45,354,460 66,650,675 75,640,210 89,575,400
Finished Goods Inventory 359,340,630 960,187,250 1,451,230,215 1,605,660,505 1,805,340,520
Total Current Assets 1,267,311,420 3,162,140,833 5,117,078,113 5,439,170,231 6,013,296,190
L,P,&E, Net 710,727,625 812,956,891 1,317,388,220 2,281,077,095 3,363,891,508
Intangibles 103,416,660 411,698,984 561,903,428 601,083,781 580,509,006
Total Assets 2,081,455,705 4,386,796,708 6,996,369,761 8,321,331,107 9,957,696,704
A/P 422,630,600 1,011,985,000 1,305,530,320 1,509,430,300 1,564,430,450
Current Portion of LT Debt 147,920,710 341,394,916 607,184,919 651,47,287 785,532,620
Total Current Liabilities 570,551,310 1,353,379,916 1,912,715,239 2,161,277,587 2,349,963,070
Long-term Debt 739,603,550 1,706,974,582 3,035,924,595 3,259,236,437 3,927,663,101
Shareholders Equity 771,300,845 1,326,442,210 2,047,729,927 2,900,817,082 3,680,070,533
Total Liabilities and Equities 2,081,455,705 4,386,796,708 6,996,369,761 8,321,331,107 9,957,696,704
INCOME STATEMENT
2005 2006 2007 2008 2009
Sales 2,142,659,000 5,413,625,000 8,671,715,000 12,175,476,500 13,664,714,160
Cost of Goods Sold 1,323,957,000 3,120,000,500 5,032,513,200 7,886,796,000 8,974,149,576
Gross Profit 818,702,000 2,293,624,500 3,639,201, 800 4,288,680,500 4,690,564,584
Operating Costs Selling and Distribution 212,340,640 545,980,400 854,300,000 934,532,230 1,001,234,530
R&D 93,640,450 220,340,340 365,660,340 476,350,230 785,774,340
Administration 95,003,300 405,340,300 832,740,300 999,453,230 980,340,500
Amortization 81,414,429 122,465,588 187,929,165 288,216,088 394,440,051
Operating Profit 336,303,182 999,497,873 1,398,571,995 1,590,128,722 1,528,775,163
Interest 53,251,456 145,434,234 288,898,584 277,686,944 329,923,700
Earnings before Taxes 283,051,726 854,063,638 1,109,673,411 1,312,441,778 1,198,851,462
Taxes 99,068,104 298,922,273 388,385,694 459,354,622 419,598,012
Net Income 183,983,622 555,141,365 721,287,717 853,087,156 779,253,450
Required:
Analyze financial conditions of the company and make recomendations related to company expensions.
Prepare an asset management table based on above numbers. Please include all ratios used. Common size analysis on the income statement, balance sheet, cash flow , DuPont equation on ROE. Use year end totals.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started