Question

In: Accounting

Balance sheet data for Alvarez Company on December 31, the end of two recent fiscal years,...

Balance sheet data for Alvarez Company on December 31, the end of two recent fiscal years, follows:

Current Year Previous Year
Current assets $250,200 $156,500
Property, plant, and equipment 483,720 419,420
Intangible assets 100,080 50,080
Current liabilities 191,820 100,160
Long-term liabilities 316,920 256,660
Common stock 100,080 87,640
Retained earnings 225,180 181,540

Prepare a comparative balance sheet for both years, stating each asset as a percent of total assets and each liability and stockholders' equity item as a percent of the total liabilities and stockholders' equity. If required, round percentages to one decimal place.

Alvaraz Company
Comparative Balance Sheet
For the Years Ended December 31
Current
year
Amount
Current
year
Percent
Previous
year
Amount
Previous
year
Percent
Current assets $250,200 % $156,500 %
Property, plant, and equipment 483,720 % 419,420 %
Intangible assets 100,080 % 50,080 %
Total assets $834,000 % $626,000 %
Current liabilities $191,820 % $100,160 %
Long-term liabilities 316,920 % 256,660 %
Common stock 100,080 % 87,640 %
Retained earnings 225,180 % 181,540 %
Total liabilities and stockholders' equity $834,000 % $626,000 %

Solutions

Expert Solution

Alvarez Company
Common Size Balance Sheet
Current Year Percent Working Previous Year Percent Working
Assets
Current Assets $              2,50,200.00 $       0.30 ($250200/$834000) $          1,56,500.00 $      0.25 ($156500/$626000)
Property,Plant and Equipment $              4,83,720.00 $       0.58 ($483720/$834000) $          4,19,420.00 $      0.67 ($419420/$626000)
Intangible Assets $              1,00,080.00 $       0.12 ($10080/$834000) $             50,080.00 $      0.08 ($50080/$626000)
Total Assets $              8,34,000.00 $       1.00 ($834000/$834000) $          6,26,000.00 $      1.00 ($626000/$626000)
Liabilities & Stockholder's Equity
Current Liabilities $              1,91,820.00 $       0.23 ($191820/$834000) $          1,00,160.00 $      0.16 $100160/$626000)
Long Term Liabilities $              3,16,920.00 $       0.38 ($316920/$834000) $          2,56,660.00 $      0.41 ($256660/$626000)
Common Stock $              1,00,080.00 $       0.12 ($10080/$834000) $             87,640.00 $      0.14 ($87640/$626000)
Retained Earnings $              2,25,180.00 $       0.27 ($225180/$834000) $          1,81,540.00 $      0.29 ($181540/$626000)
Total Liabilities & Stockholder's Equity $              8,34,000.00 $       1.00 ($834000/$834000) $          6,26,000.00 $      1.00 ($626000/$626000)

Related Solutions

Balance sheet data for Alvarez Company on December 31, the end of two recent fiscal years,...
Balance sheet data for Alvarez Company on December 31, the end of two recent fiscal years, follows: Current Year Previous Year Current assets $270,300 $148,720 Property, plant, and equipment 504,560 473,200 Intangible assets 126,140 54,080 Current liabilities 216,240 128,440 Long-term liabilities 324,360 270,400 Common stock 90,100 81,120 Retained earnings 270,300 196,040 Prepare a comparative balance sheet for both years, stating each asset as a percent of total assets and each liability and stockholders' equity item as a percent of the...
Balance sheet data for Alvarez Company on December 31, the end of two recent fiscal years,...
Balance sheet data for Alvarez Company on December 31, the end of two recent fiscal years, follows: Current Year Previous Year Current assets $313,480 $193,760 Property, plant, and equipment 488,660 435,960 Intangible assets 119,860 62,280 Current liabilities 175,180 83,040 Long-term liabilities 396,460 332,160 Common stock 101,420 96,880 Retained earnings 248,940 179,920 Prepare a comparative balance sheet for both years, stating each asset as a percent of total assets and each liability and stockholders' equity item as a percent of the...
Balance sheet data for Alvarez Company on December 31, the end of two recent fiscal years,...
Balance sheet data for Alvarez Company on December 31, the end of two recent fiscal years, follows: Current Year Previous Year Current assets $327,600 $189,540 Property, plant, and equipment 477,360 435,240 Intangible assets 131,040 77,220 Current liabilities 205,920 112,320 Long-term liabilities 346,320 301,860 Common stock 84,240 77,220 Retained earnings 299,520 210,600 Prepare a comparative balance sheet for both years, stating each asset as a percent of total assets and each liability and stockholders' equity item as a percent of the...
Balance sheet data for Alvarez Company on December 31, the end of two recent fiscal years,...
Balance sheet data for Alvarez Company on December 31, the end of two recent fiscal years, follow: 1 Current Year Previous Year 2 Current assets $1,262,500.00 $955,500.00 3 Property, plant, and equipment 2,878,500.00 3,185,000.00 4 Intangible assets 909,000.00 409,500.00 5 Current liabilities 858,500.00 728,000.00 6 Long-term liabilities 1,464,500.00 1,729,000.00 7 Common stock 505,000.00 455,000.00 8 Retained earnings 2,222,000.00 1,638,000.00 Prepare a comparative balance sheet for both years, stating each asset as a percent of total assets and each liability and...
Balance sheet data for Alvarez Company on December 31, the end of two recent fiscal years,...
Balance sheet data for Alvarez Company on December 31, the end of two recent fiscal years, follows: Current Year Previous Year Current assets $326,120 $205,140 Property, plant, and equipment 578,600 512,850 Intangible assets 147,280 71,010 Current liabilities 231,440 126,240 Long-term liabilities 431,320 355,050 Common stock 94,680 102,570 Retained earnings 294,560 205,140 Prepare a comparative balance sheet for both years, stating each asset as a percent of total assets and each liability and stockholders' equity item as a percent of the...
Vertical Analysis of Balance Sheet Balance sheet data for Alvarez Company on December 31, the end...
Vertical Analysis of Balance Sheet Balance sheet data for Alvarez Company on December 31, the end of two recent fiscal years, follows: Current Year Previous Year Current assets $254,100 $139,700 Property, plant, and equipment 499,730 450,850 Intangible assets 93,170 44,450 Current liabilities 177,870 107,950 Long-term liabilities 330,330 266,700 Common stock 67,760 63,500 Retained earnings 271,040 196,850 Prepare a comparative balance sheet for both years, stating each asset as a percent of total assets and each liability and stockholders' equity item...
Vertical Analysis of Balance Sheet Balance sheet data for Alvarez Company on December 31, the end...
Vertical Analysis of Balance Sheet Balance sheet data for Alvarez Company on December 31, the end of two recent fiscal years, follows: Current Year Previous Year Current assets $302,470 $187,680 Property, plant, and equipment 594,510 508,300 Intangible assets 146,020 86,020 Current liabilities 239,890 140,760 Long-term liabilities 406,770 320,620 Common stock 93,870 86,020 Retained earnings 302,470 234,600 Prepare a comparative balance sheet for both years, stating each asset as a percent of total assets and each liability and stockholders' equity item...
Vertical Analysis of Balance Sheet Balance sheet data for Alvarez Company on December 31, the end...
Vertical Analysis of Balance Sheet Balance sheet data for Alvarez Company on December 31, the end of two recent fiscal years, follows: Current Year Previous Year Current assets $339,140 $197,040 Property, plant, and equipment 623,580 558,280 Intangible assets 131,280 65,680 Current liabilities 251,620 147,780 Long-term liabilities 404,780 295,560 Common stock 98,460 106,730 Retained earnings 339,140 270,930 Prepare a comparative balance sheet for both years, stating each asset as a percent of total assets and each liability and stockholders' equity item...
Vertical Analysis of Balance Sheet Balance sheet data for Alvarez Company on December 31, the end...
Vertical Analysis of Balance Sheet Balance sheet data for Alvarez Company on December 31, the end of two recent fiscal years, follows: Current Year Previous Year Current assets $249,300 $149,520 Property, plant, and equipment 465,360 404,950 Intangible assets 116,340 68,530 Current liabilities 149,580 87,220 Long-term liabilities 349,020 274,120 Common stock 99,720 99,680 Retained earnings 232,680 161,980 Prepare a comparative balance sheet for both years, stating each asset as a percent of total assets and each liability and stockholders' equity item...
Vertical Analysis of Balance Sheet Balance sheet data for Alvarez Company on December 31, the end...
Vertical Analysis of Balance Sheet Balance sheet data for Alvarez Company on December 31, the end of two recent fiscal years, follows: Current Year Previous Year Current assets $304,500 $182,840 Property, plant, and equipment 461,100 437,510 Intangible assets 104,400 32,650 Current liabilities 174,000 84,890 Long-term liabilities 330,600 261,200 Common stock 87,000 91,420 Retained earnings 278,400 215,490 Prepare a comparative balance sheet for both years, stating each asset as a percent of total assets and each liability and stockholders' equity item...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT