Question

In: Finance

Complete the​ common-size balance sheet for these companies. Review each​ company's percentages of total assets. Are...

Complete the​ common-size balance sheet for these companies. Review each​ company's percentages of total assets. Are these companies operating with similar philosophies or in similar​ industries? What appears to be the major difference in financing for these two​ companies?

% of

% of

% of

% of

Balance

Total

Balance

Total

Balance

Total

Balance

Total

ASSETS

Co. 1

Assets

Co. 2

Assets

LIABILITIES

Co. 1

Assets

Co. 2

Assets

Current assets

Current liabilities

Cash

$5,304

%

$291

%

Accounts payable

$12,230

%

$668

%

Investments

$4,047

%

$342

%

Short-term debt

$1,173

%

$0

%

Accounts receivable

$8,173

%

$227

%

Other short-term

Inventory

$5,222

%

$490

%

liabilities

$0

%

$111

%

Total current assets

$22,746

%

$1,350

%

Total current liabilities

$13,403

%

$779

%

Long-term investments

$78

%

$293

%

Long-term debt

$2,960

%

$7

%

Net plant, property

Other liabilities

$4,970

%

$52

%

and equipment

$9,801

%

$1,359

%

Total liabilities

$21,333

%

$838

%

Goodwill

$5,276

%

$61

%

OWNERS’ EQUITY

Intangible

$6,051

%

$14

%

Common stock

$3,175

%

$923

%

Other

$3,635

%

$89

%

Treasury stock

$-6,643

%

$0

%

Retained earnings

$29,722

%

$1,405

%

Total owners’ equity

$26,254

%

$2,328

%

TOTAL LIABILITIES

TOTAL ASSETS

$47,587

100.00

%

$3,166

100.00

%

AND OWNERS’ EQUITY

$47,587

100.00

%

$3,166

100.00

%

Complete the table​ below:  ​(Round up to two decimal​ places.)

% of

% of

Balance

Total

Balance

Total

ASSETS

Co. 1

Assets

LIABILITIES

Co. 1

Assets

Current assets

Current liabilities

Cash

$5,304

%

Accounts payable

$12,230

%

Investments

$4,047

%

Short-term debt

$1,173

%

Accounts receivable

$8,173

%

Other short-term

Inventory

$5,222

%

liabilities

$0

%

Total current assets

$22,746

%

Total current liabilities

$13,403

%

Long-term investments

$78

%

Long-term debt

$2,960

%

Net plant, property

Other liabilities

$4,970

%

and equipment

$9,801

%

Total liabilities

$21,333

%

Goodwill

$5,276

%

OWNERS’ EQUITY

Intangible

$6,051

%

Common stock

$3,175

%

Other

$3,635

%

Treasury stock

$-6,643

%

Retained earnings

$29,722

%

Total owners’ equity

$26,254

%

TOTAL LIABILITIES

TOTAL ASSETS

$47,587

100.00

%

AND OWNERS’ EQUITY

$47,587

100.00

%

Solutions

Expert Solution

aThe two companies are operating with different philosophies and are in different industries.

This can be seen from the below ratio table which highlights that Company 2 is more capital intensive (Higher portion of assets in capital) while at the same time also has a higher money tied up in working capital. Also company 1's business has a much higher percentage of Intangible assets which indicate in the business of Company 1, intangible assets are more important than in 2's. The table for this analysis is :

Asset Balance Co 1 % of total Assets Balance Company 2 % of total Assets Liability Balance Co 1 % of total Liabilities Balance Company 2 % of total Liabilities
Cash 5304 11.15% 291 9.19% Accounts Payable 12230 25.7% 668 21.1%
Investments 4047 8.50% 342 10.80% Short Term Debt 1173 2.5% 0 0.0%
Accounts Receivable 8173 17.17% 227 7.17% Other Short Term Liabilities 0 0.0% 111 3.5%
Inventory 5222 10.97% 490 15.48% Total Current Liabilities 13403 28.2% 779 25%
Total Current Assets 22746 47.80% 1350 42.64% Long Term Debt 2960 6.2% 7 0.2%
Long Term Investments 78 0.16% 293 9.25% Other Liabilities 4970 10.4% 52 1.6%
Plant Property and Equipment 9801 20.60% 1359 42.92% Total Liabilities 21333 44.8% 838 26%
Goodwill 5276 11.09% 61 1.93% Owners Equity
Intangible 6051 12.72% 14 0.44% Common Stock 3175 6.7% 923 29.2%
Other 3635 7.64% 89 2.81% Treasury Stock -6643 -14.0% 0 0.0%
Retained Earnings 29722 62.5% 1405 44.4%
Total Owners Equity 26254 55.2% 2328 74%
Total 47587 3166 Total 47587 3166

Also as seen from the above table, we will find that Company 1 is more levered and has a higher debt financing than Company 2. This is also the major difference between the source of financing between the two companies.

The required table from the question is :

Asset Balance Co 1 % of total Assets Liability Balance Co 1 % of total Liabilities
Cash 5304 11.15% Accounts Payable 12230 25.7%
Investments 4047 8.50% Short Term Debt 1173 2.5%
Accounts Receivable 8173 17.17% Other Short Term Liabilities 0 0.0%
Inventory 5222 10.97% Total Current Liabilities 13403 28.2%
Total Current Assets 22746 47.80% Long Term Debt 2960 6.2%
Long Term Investments 78 0.16% Other Liabilities 4970 10.4%
Plant Property and Equipment 9801 20.60% Total Liabilities 21333 44.8%
Goodwill 5276 11.09% Owners Equity
Intangible 6051 12.72% Common Stock 3175 6.7%
Other 3635 7.64% Treasury Stock -6643 -14.0%
Retained Earnings 29722 62.5%
Total Owners Equity 26254 55.2%
Total 47587 100.00% Total 47587 100.0%

Related Solutions

A common size balance sheet expresses the balance sheet items as a percentage of total assets....
A common size balance sheet expresses the balance sheet items as a percentage of total assets. Select one: True False
Below is the balance sheet information on two companies. Prepare a common-size balance sheet for each...
Below is the balance sheet information on two companies. Prepare a common-size balance sheet for each company. Review each company's percentage of total assets. Are these companies operating with similar philosophies or in similar industries? What appears to be the major difference in financing for these two companies? Account Balance Sheet Company 1 Balance. Sheet Company 2 Current Assets Cash $5,377 $299 Investments $4,146 $354 Accts. Rec. $8,100 $221 Inventory $5,372 $494 Total Current $22,995 $1,368 Long Inv. $84 $307...
A common size balance sheet or common size income statement expresses everything in percentages rather than...
A common size balance sheet or common size income statement expresses everything in percentages rather than in numbers. Your manager has just asked you why you need to spend the time and money to have your analyst create both a common size and a regular balance sheet and income statement. How would you respond to her?
You are examining a company's balance sheet and find that it has total assets of $21,156,...
You are examining a company's balance sheet and find that it has total assets of $21,156, a cash balance of $2,424, inventory of $5,169, current liabilities of $6,341 and accounts receivable of $2,935. What is the company's net working capital? Multiple Choice $4,187 $1,763 $982 $6,151 $14,815
At the beginning of the year, Sigma Company's balance sheet reported Total Assets of $204,000 and...
At the beginning of the year, Sigma Company's balance sheet reported Total Assets of $204,000 and Total Liabilities of $78,500. During the year, the company reported total revenues of $237,000 and expenses of $183,500. Also, owner withdrawals during the year totaled $50,000. Assuming no other changes to owner's capital, the balance in the owner's capital account at the end of the year would be: Multiple Choice $176,000. $129,000. $201,500. $123,000. $126,000.
At the beginning of the year, a company's balance sheet reported the following balances: Total Assets...
At the beginning of the year, a company's balance sheet reported the following balances: Total Assets = $165,000; Total Liabilities = $24,300; Total Paid-in capital of $56,700; and Retained earnings = $84,000. During the year, the company reported revenues of $49,600 and expenses of $32,400. In addition, dividends for the year totaled $21,600. Assuming no other changes to Retained earnings, the balance in the Retained earnings account at the end of the year would be:
At the beginning of the year, Sigma Company's balance sheet reported Total Assets of $294,000 and...
At the beginning of the year, Sigma Company's balance sheet reported Total Assets of $294,000 and Total Liabilities of $113,500. During the year, the company reported total revenues of $347,000 and expenses of $268,500. Also, owner withdrawals during the year totaled $70,000. Assuming no other changes to owner's capital, the balance in the owner's capital account at the end of the year would be: Multiple Choice $189,000. $256,000. $186,000. $296,500. $183,000.
To create a common size balance sheet ____________ all items on the balance sheet by ____________....
To create a common size balance sheet ____________ all items on the balance sheet by ____________. 1. multiply; owners equity 2. multiply; total assets 3. divide; owners equity 4. divide; total assets 5. multiply; debt
Rajan Company's most recent balance sheet reported total assets of $1.98 million, total liabilities of $0.76...
Rajan Company's most recent balance sheet reported total assets of $1.98 million, total liabilities of $0.76 million, and total equity of $1.22 million. Its Debt to equity ratio is: 0.47 0.38 1.61 0.62 1.00
Complete the following Balance Sheet           ASSETS           Current Assets           Cash    
Complete the following Balance Sheet           ASSETS           Current Assets           Cash                                                                                                   $   250,000           Accounts Receivable           ($_________ less allowance for Doubtful Accounts)                        $1,320,000           Inventory                                                                                             $1,410,000                       Total Current Assets                                                               $_________           Land                                                                                                    $_________           Plant & Equipment ($2,800,000 less                       Accumulated Depreciation ________)                                   $2,110,000           TOTAL ASSETS                                                                               $5,390,000 LIABILITIES AND STOCKHOLDERS EQUITY           Current Liabilities           Accounts Payable                                                                              $   620,000           Notes Payable to banks                                                                      $   130,000           Accrued Wages                                                                                 $________                            Total...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT