Question

In: Accounting

Problem 4: a) The comparative balance sheet of X Company appears below: X Company Comparative Balance...

Problem 4:

a) The comparative balance sheet of X Company appears below:

X Company

Comparative Balance Sheet

December 31,

————————————————————————————————

Assets                                                                                      2018        2017

Current assets.................................................................... $   360,000 $300,000

Plant assets .......................................................................      640,000   500,000

Total assets ...................................................................... $1,000,000   $800,000

Liabilities and stockholders' equity

Current liabilities .............................................................. $   150,000 $120,000

Long-term debt ................................................................. 240,000    160,000

Common stock ................................................................. 350.000    280,000

Retained earnings .............................................................      260,000   240,000

     Total liabilities and stockholders' equity ..................... $1,000,000    $800,000

Instructions

(a)   Using horizontal analysis, show the percentage change for each balance sheet item using 2017 as a base year.

(b)   Using vertical analysis, prepare a common size comparative balance sheet.

  1. The financial statements of Ahmed Manufacturing Company appear below:

ABC Manufacturing Company

Comparative Balance Sheet

December 31,

————————————————————————————————

Assets                                                                                                         2019                   2018  

Cash................................................................................................... $ 250,000           $ 400,000

Short-term investments......................................................................      150,000              600,000

Accounts receivable (net)..................................................................      500,000              300,000

Inventory...........................................................................................      500,000              700,000

Property, plant and equipment (net).................................................. 2,600,000         3,000,000

      Total assets ................................................................................. $4,000,000         $5,000,000

Liabilities and stockholders' equity

Accounts payable............................................................................... $ 200,000           $ 300,000

Short-term notes payable...................................................................      300,000              900,000

Bonds payable...................................................................................      900,000           1,600,000

Common stock................................................................................... 1,500,000           1,500,000

Retained earnings.............................................................................. 1,100,000              700,000

Total liabilities and stockholders' equity                                         $4,000,000         $5,000,000

ABC Manufacturing Company

Income Statement

For the Year Ended December 31, 2013

Net sales.......................................................................                   $4,000,000

Cost of goods sold........................................................                   2,400,000

Gross profit..................................................................                     1,600,000

Expenses

     Operating expenses.................................................. $420,000

     Interest expense....................................................... 180,000

          Total expenses....................................................                      600,000

Income before income taxes..........................................                     1,000,000

Income tax expense......................................................                        300,000

Net income...................................................................                    $ 700,000

Additional information:

a.   Cash dividends of $230,000 were declared and paid in 2019.

b.   Weighted-average number of shares of common stock outstanding during 2019 was 300,000 shares.

c.   Market value of common stock on December 31, 2019, was $210 per share.

Instructions

Using the financial statements and additional information, compute the following ratios for Ahmed Manufacturing Company for 2013.

Show all computations.         

1. Current ratio;

2. Return on common stockholders' equity;

3. Price-earnings ratio;

4. Acid-test ratio;

5. Receivables turnover;

6. Times interest earned;

7. Profit margin;

8. Days in inventory

9. Payout ratio;

10. Return on assets.

Solutions

Expert Solution

Problem 4

Solution

a

Horizontal Analysis
2018 2017
(Base Year)
Increase/
(Decrease)
(2018 - 2017)
(a)
Analysis
Precentage
Change
(a) / 2017 * 100
Assets
Current Assets $360,000 $300,000 $60,000 20.00%
Plant Assets $640,000 $500,000 $140,000 28.00%
Total Assets $1,000,000 $800,000 $200,000 25.00%
Liabilities and Stockholder's Equity
Current Liability $150,000 $120,000 $30,000 25.00%
Long term debt $240,000 $160,000 $80,000 50.00%
Common Stock $350,000 $280,000 $70,000 25.00%
Retained Earnings $260,000 $240,000 $20,000 8.33%
Total Liabilities and Stockholder's Equity $1,000,000 $800,000 $200,000 25.00%

b

Vertical Analysis
2018 Analysis
(Percentage change)
2017 Analysis
(Percentage change)
Assets
Current Assets $360,000 36.00% $360000/$1000000 *100 $300,000 37.50% $300000/$800000 * 100
Plant Assets $640,000 64.00% $640000/$1000000 *100 $500,000 62.50% $500000/$800000 * 100
Total Assets $1,000,000 100.00% $1000000/$1000000 *100 $800,000 100.00% $800000/$800000 * 100
Liabilities and Stockholder's Equity
Current Liability $150,000 15.00% $150000/$$1000000 * 100 $120,000 15.00% $120000/$800000 * 100
Long term debt $240,000 24.00% $240000/$$1000000 * 100 $160,000 20.00% $160000/$800000 * 100
Common Stock $350,000 35.00% $350000/$$1000000 * 100 $280,000 35.00% $280000/$800000 * 100
Retained Earnings $260,000 26.00% $260000/$$1000000 * 100 $240,000 30.00% $240000/$800000 * 100
Total Liabilities and Stockholder's Equity $1,000,000 100.00% $1000000/$$1000000 * 100 $800,000 100.00% $800000/$800000 * 100
If you have any query, feel free to ask and if you are satisfied with the solution then please give me positive rating, it would really help me

Related Solutions

) The comparative balance sheet of Ahmed & Company appears below: Ahmed & Company Comparative Balance...
) The comparative balance sheet of Ahmed & Company appears below: Ahmed & Company Comparative Balance Sheet December 31, Assets                                                                                                                 2019            2018                                                                                                                          (‘000)           (‘000) Current assets ..........................................................................................        $   450             $280 Plant assets ..............................................................................................             550             520       Total assets ........................................................................................        $1,000             $800 Liabilities and stockholders' equity Current liabilities .....................................................................................        $   180             $120 Long-term debt .......................................................................................             250               160 Common stock ........................................................................................             310               320 Retained earnings ...................................................................................             260             200       Total liabilities and stockholders'...
Question 12 A comparative balance sheet for Rocker Company appears below: ROCKER COMPANY Comparative Balance Sheet...
Question 12 A comparative balance sheet for Rocker Company appears below: ROCKER COMPANY Comparative Balance Sheet Dec. 31, 2020 Dec. 31, 2019 Assets Cash $34,000 $11,000 Accounts receivable 18,000 13,000 Inventory 25,000 17,000 Prepaid expenses 6,000 9,000 Long-term investments 0 17,000 Equipment 60,000 33,000 Accumulated depreciation—equipment (20,000 ) (15,000 )     Total assets $123,000 $85,000 Liabilities and Stockholder's Equity Accounts payable $17,000 $7,000 Bonds payable 36,000 45,000 Common stock 40,000 23,000 Retained earnings 30,000 10,000     Total liabilities and stockholders' equity $123,000...
Krech Corporation's comparative balance sheet appears below: Comparative Balance Sheet Ending Balance Beginning Balance Assets: Current...
Krech Corporation's comparative balance sheet appears below: Comparative Balance Sheet Ending Balance Beginning Balance Assets: Current assets: Cash and cash equivalents $ 31,000 $ 28,000 Accounts receivable 18,000 20,000 Inventory 58,000 56,000 Prepaid expenses 12,000 10,000 Total current assets 119,000 114,000 Property, plant, and equipment 374,000 354,000 Less accumulated depreciation 190,000 165,000 Net property, plant, and equipment 184,000 189,000 Total assets $ 303,000 $ 303,000 Liabilities and stockholders' equity: Current liabilities: Accounts payable $ 13,000 $ 9,000 Accrued liabilities 52,000...
Krech Corporation's comparative balance sheet appears below: Comparative Balance Sheet Ending Balance Beginning Balance Assets: Current...
Krech Corporation's comparative balance sheet appears below: Comparative Balance Sheet Ending Balance Beginning Balance Assets: Current assets: Cash and cash equivalents $ 32,000 $ 25,800 Accounts receivable 18,500 21,000 Inventory 60,000 57,500 Prepaid expenses 12,200 10,100 Total current assets 122,700 114,400 Property, plant, and equipment 386,000 366,000 Less accumulated depreciation 193,000 164,700 Net property, plant, and equipment 193,000 201,300 Total assets $ 315,700 $ 315,700 Liabilities and stockholders' equity: Current liabilities: Accounts payable $ 14,700 $ 10,000 Accrued liabilities 53,000...
Krech Corporation's comparative balance sheet appears below: Comparative Balance Sheet Ending Balance Beginning Balance Assets: Current...
Krech Corporation's comparative balance sheet appears below: Comparative Balance Sheet Ending Balance Beginning Balance Assets: Current assets: Cash and cash equivalents $ 33,000 $ 26,300 Accounts receivable 19,000 22,000 Inventory 62,000 59,000 Prepaid expenses 12,400 10,200 Total current assets 126,400 117,500 Property, plant, and equipment 398,000 378,000 Less accumulated depreciation 199,000 170,100 Net property, plant, and equipment 199,000 207,900 Total assets $ 325,400 $ 325,400 Liabilities and stockholders' equity: Current liabilities: Accounts payable $ 16,200 $ 11,000 Accrued liabilities 54,000...
Illies Corporation's comparative balance sheet appears below: Comparative Balance Sheet Ending Balance Beginning Balance Assets: Current...
Illies Corporation's comparative balance sheet appears below: Comparative Balance Sheet Ending Balance Beginning Balance Assets: Current assets: Cash and cash equivalents $ 45,000 $ 38,000 Accounts receivable 24,000 26,500 Inventory 72,000 74,500 Total current assets 141,000 139,000 Property, plant, and equipment 373,000 349,000 Less accumulated depreciation 166,000 137,000 Net property, plant, and equipment 207,000 212,000 Total assets $ 348,000 $ 351,000 Liabilities and stockholders' equity: Current liabilities: Accounts payable $ 23,000 $ 24,500 Accrued liabilities 59,000 64,500 Income taxes payable...
Krech Corporation's comparative balance sheet appears below: Comparative Balance Sheet Ending Balance Beginning Balance Assets: Current...
Krech Corporation's comparative balance sheet appears below: Comparative Balance Sheet Ending Balance Beginning Balance Assets: Current assets: Cash and cash equivalents $ 39,000 $ 29,300 Accounts receivable 22,000 28,000 Inventory 74,000 68,000 Prepaid expenses 13,600 10,800 Total current assets 148,600 136,100 Property, plant, and equipment 470,000 450,000 Less accumulated depreciation 235,000 202,500 Net property, plant, and equipment 235,000 247,500 Total assets $ 383,600 $ 383,600 Liabilities and stockholders' equity: Current liabilities: Accounts payable $ 25,800 $ 17,000 Accrued liabilities 60,000...
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...
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...
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...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT