Question

Income Statement                                        &nbs

Income Statement                                           Balance Sheet

Sales $20,000,000   Assets:

Cost of Goods Sold 8,000,000 Cash $ 5,000,000

12,000,000 Marketable Securities 12,500,000

Selling and Administrative 1,600,000 Accounts Receivable, net 2,500,000

Depreciation 3,000,000 Inventory 30,000,000

7,400,000 Prepaid Expenses 5,000,000

Interest 2,000,000 Plant & Equipment 30,000,000

5,400,000                

Taxes (40%) 2,160,000   Total Assets 85,000,000

3,240,000                

Common Stock Div. 600,000 Liabilities and Equity:

$2,640,000 Accounts Payable $20,000,000

Notes Payable                 5,000,000

Accrued Expenses          5,000,000

Bonds                            25,000,000

Common Stock                5,000,000

Capital in Excess of Par 10,000,000

Retained Earnings          15,000,000

                                                                        Total Liabilities and Equity

   $85,000,000

Shares outstanding of common stock = 1,000,000

Market price of common stock = $18.

Please answer the following questions using the table above:

1.        The Current Ratio is:

2.         The Net Profit margin is:

3.         The Quick Ratio is:

4.         The Times Interest Earned ratio is:

5.         The Earnings Per Share is:

6.         The Gross Profit Margin is:

7.         The Total Debt to Total Asset ratio is:

8.         Return on Assets ratio is:

9.         The Total Asset Turnover ratio is:

10.       The Operating Profit Margin is:

11.       The Average Collection Period (365 day year) is:

12.       The Market to Book ratio is:

13.       The Debt to Equity ratio is:

14.       The Inventory Turnover ratio is:

15.       The Return on Equity is:

Homework Answers

Answer #1

(1) Current Assets = Total Assets - Plant and Equipment = 85 - 30 = $ 55 million

Current Liability = Accounts Payable + Notes Payable + Accrued Expenses = 20 + 5 + 5 = $ 30 million

Current Ratio = 55 / 30 = 1.833

(2) Net Profit Margin = Net Income / Sales = (3.24 / 20) x 100 = 16.2 %

(3) Quick Ratio = (Cash + Marketable Securities + Accounts Receivable) / Current Liabilities = (5+12.5+2.5) / 30 = (20/30) = 0.66

(4) EBIT = $ 7.4 million and Interest Expense = $ 2 million

Times Interest Earned Ratio (Interest Coverage Ratio) = 7.4 / 2 = 3.7

NOTE: Please raise seprate queries for answers to the remaining subparts.

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Income Statement Balance Sheet Sales $20,000,000 Assets: Cost of Goods Sold 8,000,000 Cash $5,000,000 12,000,000 Marketable...
Income Statement Balance Sheet Sales $20,000,000 Assets: Cost of Goods Sold 8,000,000 Cash $5,000,000 12,000,000 Marketable Securities 12,500,000 Selling and Administrative 1,600,000 Accounts Receivable, net 2,500,000 Depreciation 3,000,000 Inventory 30,000,000 EBIT 7,400,000 Prepaid Expenses 5,000,000 Interest 2,000,000 Plant & Equipment 30,000,000 5,400,000 Taxes (40%) 2,160,000 Total Assets 85,000,000 3,240,000 Common Stock Div. 600,000 Liabilities and Equity: $2,640,000 Accounts Payable $20,000,000 Notes Payable 5,000,000 Shares outstanding of common stock = 1,000,000 Accrued Expenses 5,000,000 Market price of common stock = $18...
Compute Profit margin, current ratio, debt to asset, and asset turnover ratios. Balance Sheet As on...
Compute Profit margin, current ratio, debt to asset, and asset turnover ratios. Balance Sheet As on April 30 $ $ ASSETS Lanscaping Equipment 15,000 Cash 55,300 Prepaid Insurance 3,300 Landscaping supplies 300 Accounts Receivable 600 Total Assets 74,500 Equity and Liabilities Equity Common Stock 50,000 Retained Earnings 20,750 Total Equity 70,750 Liabilities Accounts Payable 3,750 Total Equity and Liabilities 74,500
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...
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...
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...
The following income statement and balance sheets for Laser World are provided: LASER WORLD Income Statement...
The following income statement and balance sheets for Laser World are provided: LASER WORLD Income Statement For the year ended December 31, 2018   Sales revenue $ 2,380,400   Cost of goods sold 1,560,000      Gross profit 820,400   Expenses:       Operating expenses 343,000       Depreciation expense 61,000       Loss on sale of land 4,400       Interest expense 22,000       Income tax expense 54,000             Total expenses 484,400      Net income $   336,000 LASER WORLD Balance Sheet December 31   2018   2017   Assets   Current assets:       Cash $ 128,000   ...
Question 1 1a) A company has $1 billion of sales and $50 million of net income.  Its...
Question 1 1a) A company has $1 billion of sales and $50 million of net income.  Its total assets are $500 million, financed half by debt and half by common equity.  What is its profit margin?  What is its ROA? 4 Sales ($M) Net income ($M) Total assets ($M) Debt ratio Profit margin Sales ($M) Net income ($M) Total assets ($M) Debt ratio ROA 1b) A company has a profit margin of 6%, a total asset turnover ratio of 2, and an equity...
Income statement and balance sheet data for The Sports Shack are provided below. The Sports Shack...
Income statement and balance sheet data for The Sports Shack are provided below. The Sports Shack Income Statements For the years ended December 31 2019 2018 Sales revenue $8,200,000 $6,600,000 Cost of goods sold 6,100,000 4,700,000 Gross profit 2,100,000 1,900,000        Expenses:            Operating expenses 1,450,000 1,400,000            Depreciation expense 90,000 100,000            Interest expense 25,000 50,000            Income tax expense 95,000 80,000                Total expenses 1,660,000 1,630,000 Net income $440,000 $270,000 The Sports Shack Balance Sheets December 31 Assets 2019 2018 2017 Current assets:         Cash...
Ivanhoe Corporation recently filed the following financial statements with the SEC. Ivanhoe Corporation Income Statement for...
Ivanhoe Corporation recently filed the following financial statements with the SEC. Ivanhoe Corporation Income Statement for the Fiscal Year Ended July 31, 2017 Net sales $58,589 Cost of products sold 41,674 Gross profit $16,915 Selling, general, and administrative expenses 7,466 Depreciation 848 Operating income (loss) $8,601 Interest expense 519 Earnings (loss) before income taxes $8,082 Income taxes 2,829 Net earnings (loss) $5,253 Ivanhoe Corporation Balance Sheet as of July 31, 2017 Assets Liabilities and Stockholders’ Equity Cash and marketable securities...
The balance sheet and income statement shown below are for Big D Café: Balance Sheet (millions...
The balance sheet and income statement shown below are for Big D Café: Balance Sheet (millions of $) Assets Cash and securities                                                          2,500 Accounts receivable                                                        11,500 Inventories                                                                        16,000 Total current assets                                                        30,000 Net plant and equipment                                             20,000 Total assets 50,000 Liabilities and Equity Accounts payable                                                             9,500 Notes payable                                                                   7,000 Accruals                                                                               5,500 Total current liabilities                                                    22,000 Long-term debt                                                                15,000 Total liabilities                                                                   37,000 Common stock                                                                  2,000 Retained earnings                                                            11,000 Total common equity                                                     13,000 Total liabilities and equity                                            50,000 Income Statement (millions of $) Sales                                                                                      87,500 Operating costs except...