Question

In: Accounting

The balance sheet data below for Randolph Company for two recent years. Assets Year 2 Year...

The balance sheet data below for Randolph Company for two recent years.

Assets

Year 2

Year 1

Current assets

$445

    $280

Plant assets

  680

     520

Total assets

$1,125   

    $800

Liabilities & Stockholders' Equity
Current liabilities

$285

$120

Long-term debt

  255

  160

Common stock

  325

  320

Retained earnings

  260

  200

Total liabilities and stockholders' equity

$1,125  

$800

Required:

a. Using horizontal analysis, show the percentage change for each balance sheet item using Year 1 as a base year. If required, round percentage to one decimal place. If required, use the minus sign to indicate decreases in amounts and percents (negative values).

  1. Randolph Company
    Comparative Balance Sheet
    December 31, Year 2 and Year 1
    Assets Year 2 Year 1 Increase/Decrease Amount Increase/Decrease Percentage
    Current assets $445 $280 $ %
    Plant assets 680 520 %
    Total assets $1,125 $800 $ %
    Liabilities & stockholders' equity
    Current liabilities $285 $120 $ %
    Long-term debt 255 160 %
    Common stock 325 320 %
    Retained earnings 260 200 %
    Total liabilities and stockholders' equity $1,125 $800 $ %

    b. Using vertical analysis, prepare a comparative balance sheet. If required, round your answers to one decimal place.

    Randolph Company
    Comparative Balance Sheet
    December 31, Year 2 and Year 1
    Assets Year 2 Amount Year 2 Percent Year 1 Amount Year 1 Percent
    Current assets $445 % $280 %
    Plant assets 680 % 520 %
    Total assets $1,125 % $800 %
    Liabilities & stockholders' equity
    Current liabilities $285 % $120 %
    Long-term debt 255 % 160 %
    Common stock 325 % 320 %
    Retained earnings 260 % 200 %
    Total liabilities and stockholders' equity $1,125 % $800 %

Solutions

Expert Solution

Answer-a)-

RANDOLPH COMPANY
HORIZONTAL ANALYSIS
PARTICULARS YEAR 2 YEAR 1 INCREASE/DECREASE %
$ $ $
ASSETS
Current assets 445 280 165 58.9
Plant assets 680 520 160 30.8
Total assets 1125 800 325 40.6
LIABILITIES AND EQUITY
Current Liabilities 285 120 165 137.5
Long-term debt 255 160 95 59.4
Common stock 325 320 5 1.6
Retained earnings 260 200 60 30.0
Total liabilities and stockholders' equity 1125 800 325 40.6

b)-

RANDOLPH COMPANY
VERTICAL ANALYSIS
PARTICULARS YEAR 2 % YEAR 1 %
$ $
ASSETS
Current assets 445 39.6 280 35.0
Plant assets 680 60.4 520 65.0
Total assets 1125 100.0 800 100.0
LIABILITIES AND EQUITY
Current Liabilities 285 25.3 120 15.0
Long-term debt 255 22.7 160 20.0
Common stock 325 28.9 320 40.0
Retained earnings 260 23.1 200 25.0
Total liabilities and stockholders' equity 1125 100.0 800 100.0

Related Solutions

The balance sheet data below for Randolph Company for two recent years. Assets Year 2 Year...
The balance sheet data below for Randolph Company for two recent years. Assets Year 2 Year 1 Current assets $445     $280 Plant assets   680      520 Total assets $1,125        $800 Liabilities & Stockholders' Equity Current liabilities $285 $120 Long-term debt   255   160 Common stock   325   320 Retained earnings   260   200 Total liabilities and stockholders' equity $1,125   $800 Required: a. Using horizontal analysis, show the percentage change for each balance sheet item using Year 1 as a base year. If required, round...
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, 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...
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...
Carriveau Corporation's most recent balance sheet appears below: Comparative Balance Sheet Ending Balance Beginning Balance Assets:...
Carriveau Corporation's most recent balance sheet appears below: Comparative Balance Sheet Ending Balance Beginning Balance Assets: Current assets: Cash and cash equivalents $ 41 $ 30 Accounts receivable 38 26 Inventory 51 65 Total current assets 130 121 Property, plant, and equipment 772 551 Less accumulated depreciation 283 262 Net property, plant, and equipment 489 289 Total assets $ 619 $ 410 Liabilities and stockholders' equity: Current liabilities: Accounts payable $ 56 $ 71 Accrued liabilities 21 18 Income taxes...
The balance sheet for AG Company is shown below. AG Company Balance Sheet 2016 Assets Liabilities...
The balance sheet for AG Company is shown below. AG Company Balance Sheet 2016 Assets Liabilities and Equity Cash…………………… $     60,000 Accounts payable…………….. $   220,000 Accounts receivable…... 240,000 Accrued taxes………………… 30,000 Inventory……………… 350,000 Bonds payable (long-term)…………………… 150,000 Plant and equipment…...    410,000 Common stock……………….. 80,000 Paid-in capital………………… 200,000 Retained earnings……………..     380,000 Total assets………... $1,060,000 Total liabilities and equity… $1,060,000 The Net Sales is 900,000, and Cost of Goods Sold is 400,000 for the year 2016, and the Beginning inventory...
Following is the balance sheet of Munoz Company for Year 3: MUNOZ COMPANY Balance sheet Assets...
Following is the balance sheet of Munoz Company for Year 3: MUNOZ COMPANY Balance sheet Assets Cash $ 15,200 Marketable securities 7,580 Accounts receivable 13,400 Inventory 11,200 Property and equipment 169,500 Accumulated depreciation (12,200 ) Total assets $ 204,680 Liabilities and Stockholders’ Equity Accounts payable $ 8,690 Current notes payable 3,320 Mortgage payable 4,550 Bonds payable 21,240 Common stock 114,400 Retained earnings 52,480 Total liabilities and stockholders’ equity $ 204,680 The average number of common stock shares outstanding during Year...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT