Question

In: Economics

Module Four Homework Assignment Exhibit A James Trading Corporation Balance Sheet December 31, 20XX Assets $...

Module Four Homework Assignment

Exhibit A

James Trading Corporation

Balance Sheet

December 31, 20XX

Assets

$

Liabilities and Equity

$

Cash

23,015

Accounts receivable

141,258

Accounts payable

184,372

Inventory

212,444

Long term debt

168,022

Total current assets

376,717

Total liabilities

352,394

Net Plant and equipment

711,256

Common Stock

313,299

Other assets

89,879

Retained earnings

512,159

Total equity

825,458

Total Assets

$1,177,852

Total Liabilities and Equity

$1,177,852

James Trading Corporation

Income Statement

December 31, 20XX

Income Statement

$

Sales

$2,130,000

Cost of goods sold

(1,015,000)

Gross margin

1,115,000

Operating expenses

(878,000)

Depreciation

(16,030)

Operating income

220,970

Interest expense

(10,011)

Earnings before taxes

210,959

Income taxes

(54,000)

Net income

$156,959

Industry Average Ratios

Item

Ration

Current ratio

2.1

Quick ratio

0.8

Days in inventory

92

Days in accounts receivable

63

Gross margin

23.9%

Net margin

12.3%

Long term debt to equity ratio

1.0

Interest coverage

5.6

ROA

5.3%

ROE

18.8%

1. Using the Exhibit A document, compute the following ratio, compare it to the industry average, and comment. Compute the current ratio.

2. Using the Exhibit A document, compute the following ratio, compare it to the industry average, and comment. Compute the quick ratio.

3. Using the Exhibit A document, compute the following ratio, compare it to the industry average, and comment. Compute days outstanding in accounts receivable.

4. Using the Exhibit A document, compute the following ratio, compare it to the industry average, and comment. Compute the gross margin.

5. Using the Exhibit A document, compute the following ratio, compare it to the industry average, and comment. Compute the net income percentage.

6. Using the Exhibit A document, compute the following ratio, compare it to the industry average, and comment. Compute the long term debt to equity ratio.

7. Using the Exhibit A document, compute the following ratio, compare it to the industry average, and comment. Compute the interest coverage.

8. Using the Exhibit A document, compute the following ratio, compare it to the industry average, and comment. Compute the ROA.

9. Using the Exhibit A document, compute the following ratio, compare it to the industry average, and comment. Compute the ROE.

10. Using the Exhibit A document, compute the following ratio, compare it to the industry average, and comment. Compute the ROE using the DuPont Model.

Solutions

Expert Solution

Question 1

Current Assets = Cash + Accounts receivable + Inventory

Current Assets = $23,015 + $141,258 + $212,444

Current Assets = $376,717

Current Liabilities = Accounts payable = $184,372

Calculate the Current Ratio -

Current Ratio = Current Assets/Current Liabilities = $376,717/$184,372 = 2.04

The current ratio of James Trading Corporation is 2.04

The current ratio of Industry is 2.1

It can be seen that current ratio of James Trading Corporation is lower than the industry average.

This means while average firm in industry held $2.1 of current assets against the $1 of current liabilities, James Trading Corporation holds $2.04 of current assets against the $1 of current liabilities.

Thus, James Trading Corporation is less financially healthier than the average firm in the industry with respect to current ratio.

Question 2

Quick Assets = Cash + Accounts receivable

Current Assets = $23,015 + $141,258

Current Assets = $164,273

Current Liabilities = Accounts payable = $184,372

Calculate the Quick Ratio -

Quick Ratio = Quick Assets/Current Liabilities = $164,273/$184,372 = 0.89

The quick ratio of James Trading Corporation is 0.89

The quick ratio of Industry is 0.80

It can be seen that quick ratio of James Trading Corporation is higher than the industry average.

This means while average firm in industry held $0.80 of quick assets against the $1 of current liabilities, James Trading Corporation holds $0.89 of quick assets against the $1 of current liabilities.

Thus, James Trading Corporation is more financially healthier than the average firm in the industry with respect to quick ratio.


Related Solutions

For December 31, 20X1, the balance sheet of Baxter Corporation was as follows:    Current Assets...
For December 31, 20X1, the balance sheet of Baxter Corporation was as follows:    Current Assets Liabilities Cash $ 17,000 Accounts payable $ 19,000 Accounts receivable 22,000 Notes payable 27,000 Inventory 32,000 Bonds payable 57,000 Prepaid expenses 12,700 Fixed Assets Stockholders’ Equity Gross plant and equipment $ 257,000 Preferred stock $ 27,000 Less: Accumulated depreciation 51,400 Common stock 62,000 Paid in Capital 32,000 Net plant and equipment $ 205,600 Retained earnings 65,300 Total assets $ 289,300 Total liabilities and stockholders’...
For December 31, 20X1, the balance sheet of Baxter Corporation was as follows:    Current Assets...
For December 31, 20X1, the balance sheet of Baxter Corporation was as follows:    Current Assets Liabilities Cash $ 30,000 Accounts payable $ 32,000 Accounts receivable 35,000 Notes payable 40,000 Inventory 45,000 Bonds payable 70,000 Prepaid expenses 14,000 Fixed Assets Stockholders’ Equity Gross plant and equipment $ 270,000 Preferred stock $ 40,000 Less: Accumulated depreciation 54,000 Common stock 75,000 Paid in Capital 45,000 Net plant and equipment $ 216,000 Retained earnings 38,000 Total assets $ 340,000 Total liabilities and stockholders’...
For December 31, 20X1, the balance sheet of Baxter Corporation was as follows:    Current Assets...
For December 31, 20X1, the balance sheet of Baxter Corporation was as follows:    Current Assets Liabilities Cash $ 13,000 Accounts payable $ 15,000 Accounts receivable 18,000 Notes payable 23,000 Inventory 28,000 Bonds payable 53,000 Prepaid expenses 12,300 Fixed Assets Stockholders’ Equity Gross plant and equipment $ 253,000 Preferred stock $ 23,000 Less: Accumulated depreciation 50,600 Common stock 58,000 Paid in Capital 28,000 Net plant and equipment $ 202,400 Retained earnings 73,700 Total assets $ 273,700 Total liabilities and stockholders’...
For December 31, 20X1, the balance sheet of Baxter Corporation was as follows:    Current Assets...
For December 31, 20X1, the balance sheet of Baxter Corporation was as follows:    Current Assets Liabilities Cash $ 30,000 Accounts payable $ 32,000 Accounts receivable 35,000 Notes payable 40,000 Inventory 45,000 Bonds payable 70,000 Prepaid expenses 14,000 Fixed Assets Stockholders’ Equity Gross plant and equipment $ 270,000 Preferred stock $ 40,000 Less: Accumulated depreciation 54,000 Common stock 75,000 Paid in Capital 45,000 Net plant and equipment $ 216,000 Retained earnings 38,000 Total assets $ 340,000 Total liabilities and stockholders’...
For December 31, 20X1, the balance sheet of Baxter Corporation was as follows: Current Assets Liabilities...
For December 31, 20X1, the balance sheet of Baxter Corporation was as follows: Current Assets Liabilities Cash $ 15,000 Accounts payable $ 17,000 Accounts receivable 20,000 Notes payable 25,000 Inventory 30,000 Bonds payable 55,000 Prepaid expenses 12,500 Fixed Assets Stockholders’ Equity Gross plant and equipment $ 255,000 Preferred stock $ 25,000 Less: Accumulated depreciation 51,000 Common stock 60,000 Paid in Capital 30,000 Net plant and equipment $ 204,000 Retained earnings 69,500 Total assets $ 281,500 Total liabilities and stockholders’ equity...
On December 31, Starstruck Corporation reported, on its balance sheet, the following (in millions): Total assets...
On December 31, Starstruck Corporation reported, on its balance sheet, the following (in millions): Total assets $14,329.5 Total stockholders’ equity $5,890.7 Total current liabilities $4,546.9 What did Starstruck report as total liabilities on December 31? Select one: a. None of the these are correct. b. $15,673.3 million c. $9,782.6 million d. $8,439.8 million e. $3,891.9 million
A comparative balance sheet for Carla Corporation is presented as follows. December 31 Assets 2020 2019...
A comparative balance sheet for Carla Corporation is presented as follows. December 31 Assets 2020 2019 Cash $ 72,880 $ 22,000 Accounts receivable 84,590 68,710 Inventory 182,590 191,710 Land 73,590 112,710 Equipment 262,590 202,710 Accumulated Depreciation-Equipment (71,590 ) (44,710 )    Total $604,650 $553,130 Liabilities and Stockholders' Equity Accounts payable $ 36,590 $ 49,710 Bonds payable 150,000 200,000 Common stock ($1 par) 214,000 164,000 Retained earnings 204,060 139,420    Total $604,650 $553,130 Additional information: 1. Net income for 2020 was $130,180. No...
A comparative balance sheet for Pharoah Corporation is presented as follows. December 31 Assets 2020 2019...
A comparative balance sheet for Pharoah Corporation is presented as follows. December 31 Assets 2020 2019 Cash $ 72,800 $ 22,000 Accounts receivable 83,260 67,460 Inventory 181,260 190,460 Land 72,260 111,460 Equipment 261,260 201,460 Accumulated Depreciation-Equipment (70,260 ) (43,460 )    Total $600,580 $549,380 Liabilities and Stockholders' Equity Accounts payable $ 35,260 $ 48,460 Bonds payable 150,000 200,000 Common stock ($1 par) 214,000 164,000 Retained earnings 201,320 136,920    Total $600,580 $549,380 Additional information: 1. Net income for 2020 was $127,520. No...
A comparative balance sheet for Sarasota Corporation is presented as follows. December 31 Assets 2020 2019...
A comparative balance sheet for Sarasota Corporation is presented as follows. December 31 Assets 2020 2019 Cash $ 72,680 $ 22,000 Accounts receivable 84,360 68,680 Inventory 182,360 191,680 Land 73,360 112,680 Equipment 262,360 202,680 Accumulated Depreciation-Equipment (71,360 ) (44,680 )    Total $603,760 $553,040 Liabilities and Stockholders' Equity Accounts payable $ 36,360 $ 49,680 Bonds payable 150,000 200,000 Common stock ($1 par) 214,000 164,000 Retained earnings 203,400 139,360    Total $603,760 $553,040 Additional information: 1. Net income for 2020 was $129,720. No...
A comparative balance sheet for Blossom Corporation is presented as follows. December 31 Assets 2020 2019...
A comparative balance sheet for Blossom Corporation is presented as follows. December 31 Assets 2020 2019 Cash $ 72,800 $ 22,000 Accounts receivable 83,260 67,460 Inventory 181,260 190,460 Land 72,260 111,460 Equipment 261,260 201,460 Accumulated Depreciation-Equipment (70,260 ) (43,460 ) Total $600,580 $549,380 Liabilities and Stockholders' Equity Accounts payable $ 35,260 $ 48,460 Bonds payable 150,000 200,000 Common stock ($1 par) 214,000 164,000 Retained earnings 201,320 136,920 Total $600,580 $549,380 Additional information: 1. Net income for 2020 was $127,520. No...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT