Question

In: Accounting

   US Corporation Balance sheet 2015 (In Millions) Assets Cuurrent Assets Cash $ 104 Account Receivable...

  

US Corporation

Balance sheet 2015

(In Millions)

Assets

Cuurrent Assets

Cash $ 104

Account Receivable $455

inventory $ 553

total assets $ $1,112

Fixed Assets

Net Plant and Equipment $ 1,644

Liabilities and Capital

current liabilities $232

account payable $ 196

total liabilities $ 428

Long Term Debt $408

Ownership equity   

common stock $600

retained earnings $1,320

Total Liabilities and Capital $2756

  

US Corporation

Income Statement 2015

(In millions)

Net Sales    $ 1500

Cost of Goods Sold $750

Operating expenses $ 625

Net profit before taxes $ 125

Taxes $ 25

Net Profit after tax $ 100

Based the information given above Calculate

1. Net profit margin (1.5 points)

2. Asset Turnover (1.5 points)

3. Return on Assets (1.5 points)

4. Gross profit (1.5 points)

5. Gross profit margin (1 point)

6. Operating expense % (1.5 points)

7. Inventory turnover (1.5 points)

Solutions

Expert Solution

Answer:-1)-Net profit margin =(Net profit/Net sales)*100

=($100/$1500)*100 =6.67%

2)- Asset turnover ratio =Turnover/Average total assets

                                        =$1500/$2756 =.54 Times

3)-Return on assets =($100/$2756)*100 =3.63%

4)-Gross profit =Net sales-Cost of goods sold

=$1500-$750 =$750

5)-Gross profit margin =(Gross profit/Net sales)*10

=($750/$1500)*100 =50%

6)- Operating expenses % =($625/$1500)*100

=41.67%

7)-Inventory turnover = Inventory turnover ratio= Cost of goods sold/Average inventory

                                          = $750/$753

                                         = .996 times


Related Solutions

CONSOLIDATED BALANCE SHEET (millions of dollars) 2016 2015 Assets 2016 2015 Current assets 2016 2015 Cash...
CONSOLIDATED BALANCE SHEET (millions of dollars) 2016 2015 Assets 2016 2015 Current assets 2016 2015 Cash and cash equivalents 3,657 3,705 Notes and accounts receivable 21,394 19,875 Inventories: Crude oil, products and merchandise 10,877 12,037 Materials and supplies 4,203 4,208 Other current assets 1,285 2,798      Total current assets 41,416 42,623 Crude oil, products and merchandise inventories are carried at the lower of current market value or cost (generally determined under the last-in, first-out method – LIFO). Inventory costs include...
Devin E Corporation Balance Sheet As of December 31, 2015 2014 Assets: Cash & Cash Equivalents...
Devin E Corporation Balance Sheet As of December 31, 2015 2014 Assets: Cash & Cash Equivalents $41,900 $25,000 Accounts Receivable 24,000 6,250 Inventory 30,000 36,000      Current Assets 95,900 67,250 Land 25,000 10,000 Equipment 42,000 38,500 Less: Accumulated Depreciation (14,000) (7,000) 53,000 41,500 Total Assets 148,900 108,750 Liabilities: Accounts Payable 17,500 22,500 Accrued Salaries Payable 5,500 8,000 Rent Expense Payable 2,200 1,000 Income Tax Payable 6,900 4,000 Current Liabilities 32,100 35,500 Long-term notes payable 50,000 30,000 Total Liabilities 82,100 65,500...
Rowan Company Comparative Balance Sheet (dollars in millions) Ending Balance Beginning Balance Assets Current assets: ?Cash...
Rowan Company Comparative Balance Sheet (dollars in millions) Ending Balance Beginning Balance Assets Current assets: ?Cash and cash equivalents $70 $91 ?Accounts receivable 536 572 ?Inventory ??620 ??580 Total current assets ?1,226 ?1,243 Property, plant, and equipment 1,719 1,656 ?Less accumulated depreciation ??640 ??480 Net property, plant, and equipment ?1,079 ?1,176 Total assets $2,305 $2,419 Liabilities and Stockholders’ Equity Current liabilities: ?Accounts payable $205 $180 ?Accrued liabilities 94 105 ?Income taxes payable ???72 ???88 Total current liabilities 371 373 Bonds...
balance sheet 12/31/2014 12/31/2015 Assets Current Assets Cash in bank $     57,000 $    65,000 Accounts receivable         75,00
balance sheet 12/31/2014 12/31/2015 Assets Current Assets Cash in bank $     57,000 $    65,000 Accounts receivable         75,000        82,000 Inventory         66,000        75,000 Prepaid expenses           6,000          8,000 Total Current Assets $   204,000 $   230,000 Fixed Assets Machinery & equipment $     25,200 $    18,000 Total Fixed Assets (net of depreciation) $     25,200 $    18,000 TOTAL Assets $   229,200 $   248,000 Liabilities and Equity Current Liabilities Accounts payable $     89,000 $    90,000 Total Current Liabilities $     89,000 $    90,000 Long-term Debt Bank loans payable $     62,000 $    50,000 Total Long-term Debt $     62,000 $    50,000 Total Liabilities $   151,000 $   140,000 Owners' Equity         78,200...
Consider the following balance sheet (in $millions): Assets consisting of Cash of $2 and Loans of...
Consider the following balance sheet (in $millions): Assets consisting of Cash of $2 and Loans of $10; Liabilities consisting of Deposits of $8, Debt of $2 and Equity of $2 (Total Assets of $12). The average interest earned on the loans is 7% and the average cost of deposits is 6%. Rising interest rates are expected to reduce the deposits by $3 million. Borrowing more debt will cost the bank 6.5% in the short term. A. What will be the...
Squash Delight Inc. has the following balance sheet: cash $45,00 Account receivable $295,000. fix assets 772,000....
Squash Delight Inc. has the following balance sheet: cash $45,00 Account receivable $295,000. fix assets 772,000. total $1,112 000 Liabilities Account payable $296 000, Note payable 54 000, Common stock (100,000 share, @$2 par) 200 000. Capital in excess of par 100,000, Retained earnings 462 000. Total liabilities & owner's equity $1,112,000. The Firm's stock sells for $14 a share. a. show the effect on the capital account of a two-for-one stock split. b. show the effect on the capital...
Ratio Analysis: Balance Sheet (Millions of $)       Assets   Liabilities and Equity   Cash and securities $  1,554.0...
Ratio Analysis: Balance Sheet (Millions of $)       Assets   Liabilities and Equity   Cash and securities $  1,554.0 Accounts payable $  7,980.0 Accounts receivable 9660.00 Notes payable 5880.00 Inventories   13,440.0 Accruals     4,620.0 Total current assets 24654.00 Total current liabilities 18480.00 Net plant and equipment   17,346.0 Long-term bonds   10,920.0 Total assets 42000.00 Total debt 29400.00     Common stock 3360.00     Retained earnings     9,240.0     Total common equity 12600.00     Total liabilities and equity 42000.00 Income Statement (Millions of $)   Other data:   Sales 58800.00 Shares outstanding (millions) 175.00...
The balance sheet for Bostick Corporation? follows: Ending balance Beginning balance ?Assets: Current? assets: Cash and...
The balance sheet for Bostick Corporation? follows: Ending balance Beginning balance ?Assets: Current? assets: Cash and cash equivalents $52,600 ?$44,600 Accounts receivable $18,300 ?$22,300 Inventory $48,500 ?$53,000 Total current assets $119,400 ?$119,900 ?Property, plant, and equipment ?$287,800 ?$275,300 Less accumulated depreciation $109,000 ?$101,550 Net? property, plant, and equipment $178,800 ?$173,750 Total assets $298,200 ?$293,650 Liabilities and? stockholders' equity: Current? liabilities: Accounts payable ?$26,030 ?$29,580 Wages payable ?$41,600 ?$47,100 Other accounts payable $42,200 ?$35,400 Notes payable ?$24,200 ?$25,200 Total current liabilities...
The Balance Sheet of the Illini as of 12/31/20X0: Assets Current Assets: Cash 1,500,000 Accounts receivable,...
The Balance Sheet of the Illini as of 12/31/20X0: Assets Current Assets: Cash 1,500,000 Accounts receivable, net 18,000 Inventory 50,000 Total current assets 1,568,000 Equipment 90,000 Goodwill 20,000 Total assets $1,678,000 Liabilities and shareholders' equity Shareholders' equity: Common stock, 20,000 shares outstanding, $1 par 20,000 Additional paid-in capital 280,000 Retained earnings 1,378,000 Total shareholders' equity 1,678,000 Total liabilities and shareholders' equity 1,678,000 Note that all additional paid-in capital (APIC) sub accounts (e.g., APIC-options and APIC-treasury stock), if any, are tracked...
The Balance Sheet of the Illini as of 12/31/20X0: Assets Current Assets: Cash 1,500,000 Accounts receivable,...
The Balance Sheet of the Illini as of 12/31/20X0: Assets Current Assets: Cash 1,500,000 Accounts receivable, net 18,000 Inventory 50,000 Total current assets 1,568,000 Equipment 90,000 Goodwill 20,000 Total assets $1,678,000 Liabilities and shareholders' equity Shareholders' equity: Common stock, 20,000 shares outstanding, $1 par 20,000 Additional paid-in capital 280,000 Retained earnings 1,378,000 Total shareholders' equity 1,678,000 Total liabilities and shareholders' equity 1,678,000 Note that all additional paid-in capital (APIC) sub accounts (e.g., APIC-options and APIC-treasury stock), if any, are tracked...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT