Question

In: Finance

The following are the income statement and balance sheet of company X as at year 2015....

The following are the income statement and balance sheet of company X as at year 2015.

Income Statement

Sales

20,077,000

Cost of goods sold

14,985,000

Other Expenses

2,399,000

Depreciation

655,000

EBIT

2,038,000

Interest

362,000

Taxable income

1,676,000

Tax (40%)

670,400

Net income

1,006,600

Balance Sheet

Assets

Liability and Equity

Current Assets

Current liabilities

Cash

365,040 Account payable

715,680

Account Receivable

1,534,680 Notes payable

1,446,400

Inventory

1,238,500 Total current liabilities

2,162,080

Total current assets

3,138,220

Fixed Assets

Long-term debt

3,825,000

Net plant and equipment

12,315,680 Shareholder equity

Common stock

150,000

Retained earnings

9,316,820

Total equity

9,466,820

Total assets

15,453,900 Total liability and equity

15,453,900

Please calculate the following ratio:

a. Gross margin ratio

b. Quick ratio

c. Debt to Asset ratio

Solutions

Expert Solution

Income Statement

Sales 20,077,000
Cost of goods sold 14,985,000
Other Expenses 2,399,000
Depreciation 655,000
EBIT 2,038,000
Interest 362,000
Taxable income 1,676,000
Tax (40%) 670,400
Net income 1,006,600
Balance Sheet
Assets Liability and Equity
Current Assets Current liabilities
Cash 365040 Account payable 715,680
Account Receivable 1,534,680 Notes payable 1,446,400
Inventory 1,238,500 Total current liabilities 2,162,080
Total current assets 3,138,220
Long-term debt 3,825,000
Fixed Assets Shareholder equity
Common stock 150,000
Net plant and equipment 12,315,680 Retained earnings 9,316,820
Total equity 9,466,820
Total assets 15,453,900 Total liability and equity 15,453,900
Gross margin ratio= (Sale - cost of goods sold)/Sale
Gross margin ratio= (20077000-14985000)/20077000
Gross margin ratio= 25.36%
Quick ratio= (Total current asset - inventory)/Total current liability
Quick ratio= (3138220-1238500)/2162080
Quick ratio=                                              0.88
Debt to asset ratio= (Long term debt + total current liability)/Total asset
Debt to asset ratio= (2162080+3825000)/15453900
Debt to asset ratio= 38.74%

Related Solutions

The following Income Statement and Balance Sheet should be used: Creative Analysis, Inc. 2015 Income Statement...
The following Income Statement and Balance Sheet should be used: Creative Analysis, Inc. 2015 Income Statement Net sales $8,500 Cost of goods sold 7,210 Depreciation 400 Earnings before interest and taxes 890 Interest paid 40 Taxable Income $850 Taxes 310 Net Income $540 Dividends $324 Addition to retained earnings $216 Creative Analysis, Inc. 2015 Balance Sheet Cash $1,600 Accounts Payable $2,075 Accounts Rec. 975 Long-term debt 425 Inventory 2,425 Common stock 3,000 Total $5,000 Retained earnings 1,700 Net fixed assets...
INCOME STATEMENT AND BALANCE SHEET FOR 2015 SELECTED U.S. INDUSTRIES FOR 2015 (Figures in $ millions)...
INCOME STATEMENT AND BALANCE SHEET FOR 2015 SELECTED U.S. INDUSTRIES FOR 2015 (Figures in $ millions) Food Pharmaceuticals Oil and Coal Computers and Peripherals Food Stores Income Statement Data: Sales $ 676.7 $ 396.8 $ 1,049.2 $ 206.1 $ 463.7 Cost of goods sold 614.2 328.9 990.6 166.3 439.8 Balance Sheet Data: Inventory $ 64.1 $ 52.4 $ 49.5 $ 8.8 $ 25.1 Accounts receivable 51.4 60.6 73.2 20.2 5.7 Accounts payable 41.8 39.2 76.3 28.3 21.6 Note: Cost of...
Blendy Company provides the following balance sheet and income statement for the year of 2018.                           &nb
Blendy Company provides the following balance sheet and income statement for the year of 2018.                                                             HARVEY COMPANY                                                           BALANCE SHEET                                                   AS OF 31 DECEMBER, 2018                        ASSETS                                                                                     “$”                  Current Assets:                 Cash in hand                                                                              100,000                 Inventory                                                                                      90,000                Debtors                                                                                        145,000              Total current assets                                                                    3, 35,000             Non-Current Assets:                         Total non-current assets                                                             2,530,000               Total Assets                                                                                  2,865,000                  LIABILITIES            Current Liabilities:          Total Current liabilities                                                                     5,22,000           Non-Current Liabilities:           Long term loan...
Use the 2015 income statement and balance sheet (next page) to construct a statement of cash...
Use the 2015 income statement and balance sheet (next page) to construct a statement of cash flows for Laguna Surf Board Company. Determine the amount of financing they will need to raise in the capital markets. Remember to calculate subtotals for operating activities, investing activities and financing activities. Laguna Surf Board 2015 Income Statement $M Sales 700 Less COGS 400 Gross Profit 300 Depreciation 40 Operating Expenses 105 EBIT (Operating Profit) 155 Interest 25 EBT (Pretax Income) 130 Taxes 30...
Analyzing, Forecast, and Interpret Income Statement and Balance Sheet Following are the income statement and balance...
Analyzing, Forecast, and Interpret Income Statement and Balance Sheet Following are the income statement and balance sheet of Whole Foods Market Inc. WHOLE FOODS MARKET INC. Consolidated Statement of Operations Fiscal Years Ended (in millions) Sept 25, 2016 Sept 27, 2015 Sales $15,724 $15,389 Cost of goods sold and occupancy costs 10,313 9,973 Gross profit 5,411 5,416 Selling, general and administrative expenses 4,477 4,472 Pre-opening expenses 64 67 Relocation, store closures and lease termination costs 13 16 Operating income 857...
Analyzing, Forecast, and Interpret Income Statement and Balance Sheet Following are the income statement and balance...
Analyzing, Forecast, and Interpret Income Statement and Balance Sheet Following are the income statement and balance sheet of Whole Foods Market Inc. WHOLE FOODS MARKET INC. Consolidated Statement of Operations Fiscal Years Ended (in millions) Sept 25, 2016 Sept 27, 2015 Sales $15,724 $15,389 Cost of goods sold and occupancy costs 10,313 9,973 Gross profit 5,411 5,416 Selling, general and administrative expenses 4,477 4,472 Pre-opening expenses 64 67 Relocation, store closures and lease termination costs 13 16 Operating income 857...
Use the following Income Statement and Balance Sheet of firm X to answers Questions (1) &...
Use the following Income Statement and Balance Sheet of firm X to answers Questions (1) & (2) Income Statement, 2016 Balance Sheet, 2016 Sales 5,000,000 Assets Costs except Depr. -3,500,000 Cash and Equivalents 1,096,000 EBITDA 1,500,000 Accounts Receivable 960,000 Depreciation -10,900 Inventories 90,000 EBIT 1,489,100 Total Current Assets 2,146,000 Interest Expense (net) -100,500 Property Plant & Equipment 2,190,000 Pretax Income 1,388,600 Total Assets 4,336,000 Income Tax -486,010 Liabilities &Equity Net Income 902,590 Accounts Payable 900,000 Debt 950,000 Total Liabilities 1,850,000...
Use the following Income Statement and Balance Sheet of firm X to answers Questions (1) &...
Use the following Income Statement and Balance Sheet of firm X to answers Questions (1) & (2) Income Statement, 2016 Balance Sheet, 2016 Sales 5,000,000 Assets Costs except Depr. -3,500,000 Cash and Equivalents 1,096,000 EBITDA 1,500,000 Accounts Receivable 960,000 Depreciation -10,900 Inventories 90,000 EBIT 1,489,100 Total Current Assets 2,146,000 Interest Expense (net) -100,500 Property Plant & Equipment 2,190,000 Pretax Income 1,388,600 Total Assets 4,336,000 Income Tax -486,010 Liabilities &Equity Net Income 902,590 Accounts Payable 900,000 Debt 950,000 Total Liabilities 1,850,000...
Following are the income statement and balance sheet for Texas Roadhouse for the year ended December...
Following are the income statement and balance sheet for Texas Roadhouse for the year ended December 29, 2015. a. Assume the following forecasts for TXRH’s sales, NOPAT, and NOA for 2016 through 2019. Forecast the terminal period values assuming a 1% terminal period growth rate for all three model inputs: Sales, NOPAT, and NOA. Round your answers to the nearest dollar. Reported Forecast Horizon Terminal $ thousands 2015 2016 2017 2018 2019 Period Sales $1,807,368 $2,078,473 $2,390,244 $2,581,464 $2,787,981 Answer...
The Extra Surplus Company's Balance Sheet for December 31, 2015 and the Income Statement for 2016...
The Extra Surplus Company's Balance Sheet for December 31, 2015 and the Income Statement for 2016 are shown below. Extra Surplus Company Balance Sheet December 31, 2015 Assets Cash $ 13,500 Accounts Receivable 6,750 Inventory 16,200 Property and Equipment, Net 27,000 $ 63,450 Liabilities and Stockholders’ Equity Accounts Payable $ 13,500 Notes Payable, Long-Term 6,750 Common Stock 27,000 Retained Earnings 16,200 $ 63,450 Extra Surplus Company Income Statement For the Year Ended December 31, 2016 Sales $ 22,100 Cost of...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT