Question

In: Accounting

Presented below is the comparative balance sheet for Windsor Company. Windsor Company Comparative Balance Sheet As...

Presented below is the comparative balance sheet for Windsor Company.

Windsor Company
Comparative Balance Sheet
As of December 31, 2021 and 2020

December 31

2021

2022

Assets

Cash

$178,300 $276,000

Accounts receivable (net)

219,900 154,300

Short-term investments

269,400 149,700

Inventories

1,069,600 982,200

Prepaid expenses

24,900 24,900

Plant & equipment

2,604,600 1,968,800

Accumulated depreciation

(990,000) (752,100)
$3,376,700 $2,803,800
Liabilities and Stockholders’ Equity

Accounts payable

$49,900 $74,700

Accrued expenses

170,100 198,600

Bonds payable

446,600 188,900

Capital stock

2,109,800 1,777,900

Retained earnings

600,300 563,700
$3,376,700 $2,803,800

Prepare a comparative balance sheet of Windsor Company showing the percent each item is of the total assets or total liabilities and stockholders’ equity. (Round percentages to 2 decimal places, e.g. 2.25%.)

WINDSOR COMPANY
Comparative Balance Sheet
December 31, 2021 and 2020

December 31

Assets

2021

2020

Cash

$178,300 % $276,000 %

Accounts receivable (net)

219,900 % 154,300 %

Short-term investments

269,400 % 149,700 %

Inventories

1,069,600 % 982,200 %

Prepaid expenses

24,900 % 24,900 %

Plant and equipment

2,604,600 % 1,968,800 %

Accumulated depreciation

(990,000 ) % (752,100 ) %

     Total

$3,376,700 % $2,803,800

enter percentages rounded to 2 decimal places

%

Liabilities and Stockholders’ Equity

Accounts payable

$49,900 % $74,700 %

Accrued expenses

170,100 % 198,600 %

Bonds payable

446,600 % 188,900 %

Capital stock

2,109,800 % 1,777,900 %

Retained earnings

600,300 % 563,700 %

     Total

$3,376,700

enter percentages rounded to 2 decimal places

% $2,803,800 %

eTextbook and Media

  

  

Prepare a comparative balance sheet of Windsor Company showing the dollar change and the percent change for each item. (If there is a decrease from 2020 to 2021, then enter the amounts and percentages with either a negative sign, i.e. -92,000, -25.25 or parenthesis, i.e. (92,000), (25.25).)

WINDSOR COMPANY
Comparative Balance Sheet
December 31, 2021 and 2020

December 31

Increase or (Decrease)

Assets

2021

2020

$ Change

% Change

Cash

$178,300 $276,000 %

Accounts receivable (net)

219,900 154,300 %

Investments

269,400 149,700 %

Inventories

1,069,600 982,200 %

Prepaid expenses

24,900 24,900 %

Plant and equipment

2,604,600 1,968,800 %

Accumulated depreciation

(990,000 ) (752,100 ) %

     Total

$3,376,700 $2,803,800 enter percentages %

Liabilities and Stockholders’ Equity

Accounts payable

$49,900 $74,700 %

Accrued expenses

170,100 198,600 %

Bonds payable

446,600 188,900 %

Capital stock

2,109,800 1,777,900 %

Retained earnings

600,300 563,700 %

     Total

$3,376,700 $2,803,800 enter percentages %

Solutions

Expert Solution

Answer :

1. Comparative balance sheet of Windsor Company showing the percent each item is of the total assets or total liabilities and stockholders’ equity :

December 31, 2021 % December 31, 2021 December 31, 2020 % December 31, 2020
Assets
Cash 178,300 5.28% 276,000 9.84%
Accounts receivable (net) 219,900 6.51% 154,300 5.50%
Investments 269,400 7.98% 149,700 5.34%
Inventories 1,069,600 31.67% 982,200 35.03%
Prepaid expenses 24,900 0.74% 24,900 0.89%
Plant and equipment 2,604,600 77.13% 1,968,800 70.22%
Less : Accumulated depreciation (990,000) (29.32%) (752,100) (26.82%)
Total 3,376,700 100% 2,803,800 100%
Liabilities and Stockholders’ Equity
Accounts payable 49,900 1.48% 74,700 2.66%
Accrued expenses 170,100 5.04% 198,600 7.08%
Bonds payable 446,600 13.22% 188,900 6.74%
Capital stock 2,109,800 62.48% 1,777,900 63.41%
Retained earnings 600,300 17.78% 563,700 20.10%
Total 3,376,700 100% 2,803,800 100%

Percentage of assets column are calculated taking total assets as base and Percentage of liability column are calculated taking Liabilities and Stockholders’ Equity as base.

2. Comparative balance sheet of Windsor Company showing the dollar change and the percent change for each item :

December 31, 2021 December 31, 2020 Dollar change % change
Assets
Cash 178,300 276,000 (97,700) (35.40%)
Accounts receivable (net) 219,900 154,300 65,600 42.51%
Investments 269,400 149,700 119,700 79.96%
Inventories 1,069,600 982,200 87,400 8.90%
Prepaid expenses 24,900 24,900 0 0
Plant and equipment 2,604,600 1,968,800 635,800 32.29%
Less : Accumulated depreciation (990,000) (752,100) (237,900) (31.63%)
Total 3,376,700 2,803,800 572,900 20.43%
Liabilities and Stockholders’ Equity
Accounts payable 49,900 74,700 (24,800) (33.20%)
Accrued expenses 170,100 198,600 (28,500) (14.35%)
Bonds payable 446,600 188,900 257,700 136.42%
Capital stock 2,109,800 1,777,900 331,900 18.67%
Retained earnings 600,300 563,700 36,600 6.49%
Total 3,376,700 2,803,800 572,900 20.43%

Dollar change  = Amount of December 31, 2021 - Amount of December 31, 2020

% change = Dollar change / Amount of December 31, 2020


Related Solutions

Presented below is the comparative balance sheet for Martinez Company. Martinez Company Comparative Balance Sheet As...
Presented below is the comparative balance sheet for Martinez Company. Martinez Company Comparative Balance Sheet As of December 31, 2021 and 2020 December 31 2021 2022 Assets Cash $181,000 $272,500 Accounts receivable (net) 218,100 155,200 Short-term investments 271,100 149,100 Inventories 1,066,900 978,500 Prepaid expenses 24,800 24,800 Plant & equipment 2,604,700 1,948,400 Accumulated depreciation (1,003,600) (743,000) $3,363,000 $2,785,500 Liabilities and Stockholders’ Equity Accounts payable $49,800 $74,700 Accrued expenses 168,900 200,700 Bonds payable 452,100 189,100 Capital stock 2,108,600 1,782,200 Retained earnings 583,600...
Comparative balance sheet accounts of Splish Company are presented below. SPLISH COMPANY COMPARATIVE BALANCE SHEET ACCOUNTS...
Comparative balance sheet accounts of Splish Company are presented below. SPLISH COMPANY COMPARATIVE BALANCE SHEET ACCOUNTS AS OF DECEMBER 31 Debit Balances 2020 2019 Cash $70,600 $50,500 Accounts Receivable 155,100 130,000 Inventory 75,600 61,100 Debt investments (available-for-sale) 55,100 84,300 Equipment 70,300 48,400 Buildings 144,400 144,400 Land 39,600 25,300      Totals $610,700 $544,000 Credit Balances Allowance for Doubtful Accounts $10,000 $7,900 Accumulated Depreciation—Equipment 21,000 14,100 Accumulated Depreciation—Buildings 37,300 28,200 Accounts Payable 66,400 60,600 Income Taxes Payable 11,900 9,900 Long-Term Notes Payable 62,000...
Comparative balance sheet accounts of Carla Company are presented below. CARLA COMPANY COMPARATIVE BALANCE SHEET ACCOUNTS...
Comparative balance sheet accounts of Carla Company are presented below. CARLA COMPANY COMPARATIVE BALANCE SHEET ACCOUNTS AS OF DECEMBER 31 Debit Balances 2020 2019 Cash $69,900 $50,600 Accounts Receivable 154,800 130,300 Inventory 75,700 61,400 Debt investments (available-for-sale) 55,100 84,600 Equipment 69,300 48,400 Buildings 145,700 145,700 Land 40,200 25,200      Totals $610,700 $546,200 Credit Balances Allowance for Doubtful Accounts $10,100 $7,900 Accumulated Depreciation—Equipment 21,000 14,000 Accumulated Depreciation—Buildings 36,800 28,100 Accounts Payable 65,600 59,500 Income Taxes Payable 12,000 10,100 Long-Term Notes Payable 62,000...
Comparative balance sheet accounts of Sweet Company are presented below. SWEET COMPANY COMPARATIVE BALANCE SHEET ACCOUNTS...
Comparative balance sheet accounts of Sweet Company are presented below. SWEET COMPANY COMPARATIVE BALANCE SHEET ACCOUNTS AS OF DECEMBER 31 Debit Balances 2020 2019 Cash $69,600 $51,100 Accounts Receivable 156,500 130,000 Inventory 75,700 60,800 Debt investments (available-for-sale) 55,000 85,300 Equipment 69,600 47,800 Buildings 144,900 144,900 Land 39,600 25,200      Totals $610,900 $545,100 Credit Balances Allowance for Doubtful Accounts $10,000 $8,000 Accumulated Depreciation—Equipment 20,800 14,100 Accumulated Depreciation—Buildings 37,000 27,900 Accounts Payable 66,500 59,800 Income Taxes Payable 11,900 10,000 Long-Term Notes Payable 62,000...
Comparative balance sheet accounts of Pina Company are presented below. PINA COMPANY COMPARATIVE BALANCE SHEET ACCOUNTS...
Comparative balance sheet accounts of Pina Company are presented below. PINA COMPANY COMPARATIVE BALANCE SHEET ACCOUNTS AS OF DECEMBER 31 Debit Balances 2017 2016 Cash $69,500 $50,900 Accounts Receivable 153,400 131,000 Inventory 75,300 60,900 Debt investments (available-for-sale) 54,800 85,600 Equipment 70,300 48,300 Buildings 143,900 143,900 Land 40,000 24,900 Totals $607,200 $545,500 Credit Balances Allowance for Doubtful Accounts $10,100 $7,900 Accumulated Depreciation—Equipment 20,800 14,000 Accumulated Depreciation—Buildings 36,900 27,700 Accounts Payable 66,500 59,600 Income Taxes Payable 11,900 10,100 Long-Term Notes Payable 62,000...
Presented below is a condensed version of the comparative balance sheets for Windsor Corporation for the...
Presented below is a condensed version of the comparative balance sheets for Windsor Corporation for the last two years at December 31. 2017 2016 Cash $ 309,750 $ 136,500 Accounts receivable 315,000 323,750 Investments 91,000 129,500 Equipment 521,500 420,000 Accumulated Depreciation-Equipment (185,500 ) (155,750 ) Current liabilities 234,500 264,250 Common stock 280,000 280,000 Retained earnings 537,250 309,750 Additional information: Investments were sold at a loss of $17,500; no equipment was sold; cash dividends paid were $52,500; and net income was...
A comparative balance sheet for the Stanley Corporation is presented below: Corporation Comparative Balance Sheet   2019...
A comparative balance sheet for the Stanley Corporation is presented below: Corporation Comparative Balance Sheet   2019   2018 Assets Cash $  37,000 $  31,000 Accounts receivable (net) 80,000 60,000 Prepaid insurance 22,000 17,000 Land 18,000 40,000 Equipment 70,000 60,000 Accumulated depreciation    (20,000)     (13,000) Total Assets $207,000 $195,000 Liabilities and Stockholders' Equity Accounts payable $  12,000 $   6,000 Bonds payable 27,000 19,000 Common stock 140,000 115,000 Retained earnings     28,000     55,000 Total liabilities and stockholders' equity $207,000 $195,000 Additional information: 1.     Net loss for 2019 is $12,000. Depreciation...
Presented below is the comparative balance sheet for Grouper Company. PLEASE SHOW WORK Grouper Company Comparative...
Presented below is the comparative balance sheet for Grouper Company. PLEASE SHOW WORK Grouper Company Comparative Balance Sheet As of December 31, 2021 and 2020 December 31 2021 2022 Assets Cash $181,000 $272,500 Accounts receivable (net) 218,100 155,200 Short-term investments 271,100 149,100 Inventories 1,066,900 978,500 Prepaid expenses 24,800 24,800 Plant & equipment 2,604,700 1,948,400 Accumulated depreciation (1,003,600) (743,000) $3,363,000 $2,785,500 Liabilities and Stockholders’ Equity Accounts payable $49,800 $74,700 Accrued expenses 168,900 200,700 Bonds payable 452,100 189,100 Capital stock 2,108,600 1,782,200...
Problem 23-08 Comparative balance sheet accounts of Coronado Company are presented below. CORONADO COMPANY COMPARATIVE BALANCE...
Problem 23-08 Comparative balance sheet accounts of Coronado Company are presented below. CORONADO COMPANY COMPARATIVE BALANCE SHEET ACCOUNTS AS OF DECEMBER 31 Debit Balances 2020 2019 Cash $69,600 $51,100 Accounts Receivable 156,500 130,000 Inventory 75,700 60,800 Debt investments (available-for-sale) 55,000 85,300 Equipment 69,600 47,800 Buildings 144,900 144,900 Land 39,600 25,200      Totals $610,900 $545,100 Credit Balances Allowance for Doubtful Accounts $10,000 $8,000 Accumulated Depreciation—Equipment 20,800 14,100 Accumulated Depreciation—Buildings 37,000 27,900 Accounts Payable 66,500 59,800 Income Taxes Payable 11,900 10,000 Long-Term Notes...
Problem 23-08 Comparative balance sheet accounts of Oriole Company are presented below. ORIOLE COMPANY COMPARATIVE BALANCE...
Problem 23-08 Comparative balance sheet accounts of Oriole Company are presented below. ORIOLE COMPANY COMPARATIVE BALANCE SHEET ACCOUNTS AS OF DECEMBER 31 Debit Balances 2020 2019 Cash $70,700 $50,900 Accounts Receivable 154,500 131,300 Inventory 75,000 61,600 Debt investments (available-for-sale) 55,200 84,600 Equipment 69,700 47,600 Buildings 144,200 144,200 Land 39,800 24,800      Totals $609,100 $545,000 Credit Balances Allowance for Doubtful Accounts $9,900 $8,000 Accumulated Depreciation—Equipment 20,800 13,800 Accumulated Depreciation—Buildings 37,300 28,100 Accounts Payable 66,700 59,700 Income Taxes Payable 11,900 9,900 Long-Term Notes...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT