Question

QUESTION 1 Co. XYZ Balance Sheet Assets: Cash and marketable securities                              &nbs

QUESTION 1

Co. XYZ Balance Sheet

Assets:

Cash and marketable securities                                $300,000

Accounts receivable                                                 1,125,000

Inventories                                                               1,837,500

Prepaid expenses                                                          24,000

Total current assets                                                $3,286,500

Fixed assets                                                              2,700,000

Less: accumulated depreciation                               1,087,500

Net fixed assets                                                      $1,612,500

Total assets                                                             $4,899,000

Liabilities:

Accounts payable                                                      $240,000

Notes payable                                                              825,000

Accrued taxes                                                                42,000

Total current liabilities                                           $1,107,000

Long-term debt                                                            975,000

Owner’s equity                                                         2,817,000

Total liabilities and owner’s equity                        $4,899,000

Co. XYZ Income Statement

Net sales (all credit)                                                $6,375,000

Less: Cost of goods sold                                           4,312,500

Selling and administrative expense                           1,387,500

Depreciation expense                                                  135,000

Interest expense                                                          127,000

Earnings before taxes                                               $ 412,500

Income taxes                                                                225,000

Net income                                                                $ 188,000

Common stock dividends                                          $ 97,500

Change in retained earnings                                     $ 90,500

Determine the financial  ratios. interpret the results

  1. Current Ratio
  2. Debt ratio
  3. Average collection period (using a year of 365 days)
  4. Times Interest Earned
  5. Gross Profit Margin
  6. Operational Profit Margin
  7. Net Profit Margin
  8. Inventory Turnover
  9. Fixed Asset Turnove
  10. Gross Profit Margin
  11. Return on Equity
Business   Finance   
0 0
Add a commentTranscribed image text
Next >

Homework Answers

Answer #1

Current ratio = current assets / current liabilities
= $3,286,500 / $1,107,000
= 2.97

Debt ratio = Total debt / Total assets
= ($1,107,000 + $975,000) / $4,899,000
= 0.4250 or 42.50%

Average collection period = (Accounts receivable / credit sales) * 365
= ($1,125,000 / $6,375,000) * 365
= 64.41 days

Times interest earned ratio = EBIT / interest expense
= ($412,500 + $127,000) / $127,000
= 4.25

Gross profit margin = (Sales - cost of goods sold) / Sales
= ($6,375,000 - $4,312,500) / $6,375,000
= 32.35%

Note: Post the rest of them separately.

0 0
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
     The following table shows Toshiba's financial statements Assets: Amount Cash and marketable securities $400,000 Accounts...
     The following table shows Toshiba's financial statements Assets: Amount Cash and marketable securities $400,000 Accounts receivable 1,415,000 Inventories    1,847,500 Prepaid expenses 24,000 Total current assets 3,686,500 Fixed assets        2,800,000 Less: accum. depr. (1,087,500) Net fixed assets 1,712,500 Total assets $5,399,000 Liabilities: Accounts payable $600,000 Notes payable   875,000 Accrued taxes 92,000 Total current liabilities $1,567,000 Long-term debt 900,000 Common Stock (100,000 shares) 700,000 Retained Earnings 2,232,000 Total liabilities and owner's equity $5,399,000 Net sales (all credit) $6,375,000 Less: Cost of...
Fictishus Inc. Balance Sheet As of December 31, 2019 ASSETS                                &nb
Fictishus Inc. Balance Sheet As of December 31, 2019 ASSETS                                                                                                                LIABILITIES AND SHAREHOLDERS EQUITY Current Assets                                                                                                 Current Liabilities                                     Cash                                                                  600                                           Accounts Payable                                        800                   Accounts Receivable                                  400                                           Notes Payable                                              200                   Inventory                                                     1,400                                           Total Current Liabilities                         1,000                   Investments                                               1,200                         Long Term Debt                                                          2,800                   Total Current Assets                               3,600                         TOTAL LIABILITIES                                                      3,800 Fixed Assets                                                                 2,200 TOTAL ASSETS                                                             5,800                         Shareholders Equity                                                                                                                                                 Common Stock                                         2,000 Select 2019 Income Statement information: Revenue:                                            $8,100 Cost of Goods Sold:     ...
Consider the following company’s balance sheet and income statement. Balance Sheet Assets Liabilities and Equity Cash...
Consider the following company’s balance sheet and income statement. Balance Sheet Assets Liabilities and Equity Cash $ 10,000 Accounts payable $ 31,000 Accounts receivable 72,000 Notes payable 25,000 Inventory 53,000 Total current assets 135,000 Total current liabilities 56,000 Fixed assets 81,000 Long-term debt 30,000 Equity 130,000 Total assets $ 216,000 Total liabilities and equity $ 216,000 Income Statement Sales (all on credit) $ 290,000 Cost of goods sold 180,000 Gross margin 110,000 Selling and administrative expenses 43,000 Depreciation 7,000 EBIT...
Common-Size Balance Sheet 2016 Cash and marketable securities $ 490 1.5 % Accounts receivable 6,000 18.2...
Common-Size Balance Sheet 2016 Cash and marketable securities $ 490 1.5 % Accounts receivable 6,000 18.2 Inventory 9,490 28.8 Total current assets $ 15,980 48.4 % Net property, plant, and equipment 17,020 51.6 Total assets $ 33,000 100.0 % Accounts payable $ 7,210 21.8 % Short-term notes 6,790 20.6 Total current liabilities $ 14,000 42.4 % Long-term liabilities 6,970 21.1 Total liabilities $ 20,970 63.5 % Total common shareholders’ equity 12,030 36.5 Total liabilities and shareholders’ equity $ 33,000 100.0...
The balance sheet and income statement for the A. Thiel Mfg. Company are as follows: Balance...
The balance sheet and income statement for the A. Thiel Mfg. Company are as follows: Balance Sheet ($000) Cash $ 500 Accounts receivable 2,000 Inventories 1,000 Current assets $3,500 Net fixed assets 4,500 Total assets $8,000 Accounts payable $1,100 Accrued expenses 600 Short-term notes payable 300 Current liabilities $2,000 Long-term debt 2,000 Owners’ equity 4,000 Total liabilities and owners’ equity $8,000 Income Statement ($000) Sales (all credit) $8,000 Cost of goods sold (3,300) Gross profit $4,700 Operating expenses (includes $500...
4) Common-Size Balance Sheet 2016 Cash and marketable securities $ 450 1.4 % Accounts receivable 5,980...
4) Common-Size Balance Sheet 2016 Cash and marketable securities $ 450 1.4 % Accounts receivable 5,980 18.1 Inventory 9,530 28.9 Total current assets $ 15,960 48.3 % Net property, plant, and equipment 17,050 51.7 Total assets $ 33,010 100.0 % Accounts payable $ 7,220 21.9 % Short-term notes 6,850 20.8 Total current liabilities $ 14,070 42.6 % Long-term liabilities 7,010 21.2 Total liabilities $ 21,080 63.9 % Total common shareholders’ equity 11,930 36.1 Total liabilities and shareholders’ equity $ 33,010...
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...
BALANCE SHEETS: 2016 2017 Assets:                         Cash             &nbs
BALANCE SHEETS: 2016 2017 Assets:                         Cash                                        120,000                       160,000                         Accounts Receivable               520,000                       620,000                         Inventory                                305,000                       290,000                         Fixed Assets, net                    410,000                       510,000                         Total Assets                           1,355,000                    1,580,000 Liabilities and Equity:                         Accounts Payable                   350,000                       $375,000                         Long-term Debt                      500,000                       625,000                         Common Stock                       50,000                         75,000                         Retained Earnings                   455,000                       505,000                         Total Liabilities and Equity    1,355,000                    1,580,000 INCOME STATEMENT:             Revenue                                                                                  3,500,000             Cost of Goods Sold                                                                2,275,000...
Given the financial statements for Jones Corporation and Smith Corporation: JONES CORPORATION Current Assets Liabilities Cash...
Given the financial statements for Jones Corporation and Smith Corporation: JONES CORPORATION Current Assets Liabilities Cash $ 29,400 Accounts payable $ 103,000 Accounts receivable 88,300 Bonds payable (long term) 80,100 Inventory 54,500 Long-Term Assets Stockholders' Equity Gross fixed assets $ 508,000 Common stock $ 150,000 Less: Accumulated depreciation 156,800 Paid-in capital 70,000 Net fixed assets* 351,200 Retained earnings 120,300 Total assets $ 523,400 Total liabilities and equity $ 523,400 Sales (on credit) $ 1,845,000 Cost of goods sold 757,000 Gross...
The Balance Sheet and the Income Statement for ABC Manufacturing Corporation are as follows: DATA (All...
The Balance Sheet and the Income Statement for ABC Manufacturing Corporation are as follows: DATA (All amounts in SAR unless otherwise indicated, all sales are on credit and no hard keys.) Balance Sheet: ABC Corporation Balance Sheet Other current assets Total current assets Gross fixed assets Accumulated depreciation Net fixed assets Total assets LIABILITIES (DEBT) AND EQUITY Accounts payable Short-term notes payable Total current liabilities Long-term debt Total liabilities Common stock (par & paid in capital) Retained earnings Total common...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT