The EastTN Company sells computer parts through a retail store that it operates. The firm's comparative income statement and balance sheet for the years 2016 and 2015 are shown below. |
THE EASTTN COMPANY Comparative Income Statement For Years Ended December 31, 2016 and 2015 |
||||
Amounts | ||||
2016 | 2015 | |||
Revenue | ||||
Sales | 1,025,000 | 818,400 | ||
Less Sales Returns and Allowances | 25,000 | 18,400 | ||
Net Sales | 1,000,000 | 800,000 | ||
Cost of Goods Sold | ||||
Merchandise Inventory, January 1 | 90,000 | 88,800 | ||
Net Purchases | 369,500 | 297,600 | ||
Total Merchandise Available for Sale | 459,500 | 386,400 | ||
Less Merchandise Inventory, December 31 | 96,000 | 90,000 | ||
Cost of Goods Sold | 363,500 | 296,400 | ||
Gross Profit on Sales | 636,500 | 503,600 | ||
Operating Expenses | ||||
Selling Expenses | ||||
Sales Salaries Expenses | 89,000 | 80,000 | ||
Payroll Tax Expense—Selling | 9,000 | 8,800 | ||
Other Selling Expenses | 31,600 | 24,000 | ||
Total Selling Expenses | 129,600 | 112,800 | ||
General and Administrative Expenses | ||||
Officers Salaries Expense | 156,000 | 121,600 | ||
Payroll Tax Expense—Administrative | 17,000 | 11,200 | ||
Depreciation Expense | 8,000 | 8,000 | ||
Other General and Administrative Expenses | 16,000 | 11,200 | ||
Total General and Administrative Expenses | 197,000 | 152,000 | ||
Total Operating Expenses | 326,600 | 264,800 | ||
Net Income before Income Taxes | 309,900 | 238,800 | ||
Income Tax Expense | 92,970 | 71,640 | ||
Net Income after Income Taxes | 216,930 | 167,160 | ||
THE EASTTN COMPANY Comparative Balance Sheet December 31, 2016 and 2015 |
||||||
Amounts | ||||||
2016 | 2015 | |||||
Assets | ||||||
Current Assets | ||||||
Cash | 130,900 | 65,000 | ||||
Accounts Receivable | 117,000 | 107,000 | ||||
Merchandise Inventory | 96,000 | 90,000 | ||||
Prepaid Expenses | 11,500 | 6,000 | ||||
Supplies | 2,100 | 1,000 | ||||
Total Current Assets | 357,500 | 269,000 | ||||
Property, Plant, and Equipment | ||||||
Land | 95,000 | 95,000 | ||||
Building and Equipment | 102,000 | 102,000 | ||||
Less Accumulated Depreciation | (32,000) | (24,000) | ||||
Net Book Value—Building and Equipment | 70,000 | 78,000 | ||||
Total Property, Plant, and Equipment | 165,000 | 173,000 | ||||
Total Assets | 522,500 | 442,000 | ||||
Liabilities and Stockholders' Equity | ||||||
Current Liabilities | ||||||
Accounts Payable | 49,000 | 77,000 | ||||
Sales Tax Payable | 3,000 | 8,000 | ||||
Payroll Taxes Payable | 3,100 | 2,800 | ||||
Income Taxes Payable | 3,000 | 8,000 | ||||
Total Current Liabilities | 58,100 | 95,800 | ||||
Long-Term Liabilities | ||||||
Mortgage Payable | 61,000 | 65,000 | ||||
Total Long-Term Liabilities | 61,000 | 65,000 | ||||
Total Liabilities | 119,100 | 160,800 | ||||
Stockholders' Equity | ||||||
Common Stock ($1 par, 10,000 shares
authorized; 10,000 shares issued and outstanding) |
10,000 | 10,000 | ||||
Paid-in Capital—Common Stock | 10,000 | 10,000 | ||||
Retained Earnings | 383,400 | 261,200 | ||||
Total Stockholders' Equity | 403,400 | 281,200 | ||||
Total Liabilities and Stockholders' Equity | 522,500 | 442,000 | ||||
Assume all sales are credit sales. |
Part I |
1. |
Calculate the current ratio for 2015 and 2016. |
2. |
Calculate the acid-test ratio for 2015 and 2016. |
3. |
Calculate the inventory turnover for 2015 and 2016. |
4. |
Calculate the return on sales for 2015 and 2016. |
5. |
Calculate the earnings per share of common stock for 2015 and 2016. |
Ans. 1 | Current ratio = Total current assets / Total current liabilities | |||
2015 | $269,000 / $95,800 | 2.81 : 1 | ||
2016 | $357,500 / $58,100 | 6.15 : 1 | ||
Ans. 2 | Acid test ratio = (Total current assets - Inventory - Prepaid expenses) / Total current liabilities | |||
2015 | ($269,000 - $90,000 - $6,000) / $95,800 | 1.81 : 1 | ||
2016 | ($357,500 - $96,000 - $11,500) / $58,100 | 4.30 : 1 | ||
Ans. 3 | Inventory turnover = Cost of goods sold / Inventory | |||
2015 | $296,400 / $90,000 | 3.29 | times | |
2016 | $363,500 / $96,000 | 3.79 | times | |
Ans. 4 | Return on sales = Net income / Net sales * 100 | |||
2015 | $167,160 / $800,000 * 100 | 20.90% | ||
2016 | $216,930 / $1,000,000 * 100 | 21.69% | ||
Ans. 5 | Earning per share = Net income / no. of shares outstanding | |||
2015 | $167,160 / 10,000 | $16.72 | per share | |
2016 | $216,930 / 10,000 | $21.69 | per share | |
The EastTN Company sells computer parts through a retail store that it operates. The firm's comparative...
Problem 23.1A Horizontal and vertical analysis of income
statement and balance sheet. LO 23-1, 23-2
The EastTN Company sells computer parts through a retail store
that it operates. The firm’s comparative income statement and
balance sheet for the years 2016 and 2015 are shown below.
1-a.
Complete both a horizontal and a vertical analysis of
comparative income statement for the years 2016 and 2015.
(Round your percentage answers to 1 decimal place. i.e.,
0.123 should be entered as 12.3.)
1-b....
LOGIC COMPANY Comparative Income Statement For Years Ended December 31, 2016 and 2017 2017 2016 Gross sales $ 19,000 $ 15,000 Sales returns and allowances 1,000 100 Net sales $ 18,000 $ 14,900 Cost of merchandise (goods) sold 12,000 9,000 Gross profit $ 6,000 $ 5,900 Operating expenses: Depreciation $ 700 $ 600 Selling and administrative 2,200 2,000 Research 550 500 Miscellaneous 360 300 Total operating expenses $ 3,810 $ 3,400 Income before interest and taxes $ 2,190 $ 2,500...
Saved Selected comparative financial statements of Korbin Company follow! KORBIN COMPANY Comparative Income Statements For Years Ended December 31, 2017, 2016, and 2015 2017 2016 2015 Sales $ 480,784 $ 368, 320 $ 255,600 Cost of goods sold 289,432 230,937 163,584 Gross profit 191,352 137, 383 92,016 Selling expenses 68,271 52,828 33,739 Administrative expenses 43,271 32,412 21, 215 Total expenses 111,542 83,240 54,954 Income before taxes 79,810 54, 143 37,062 Income taxes 14,845 11,099 7,524 Net income $ 64,965 $...
1 2
Complete the comparative income statement and balance sheet for Logic Company. (Input all answers as positive values except decrease answers which should be indicated by a minus sign. Round your"percent" answers to the nearest hundredth percent.) LOGIC COMPANY Comparative Income Statement For Years Ended December 31, 2016 and 2017 INCREASE (DECREASE Amount 2017 2016 Gross sales Sales returns and allowances Net sales Cost of merchandise (goods) sold Gross profit Operating expenses $ 19,000 15,000 100 $ 18,000...
Selected comparative financial statements of Korbin Company follow: KORBIN COMPANY Comparative Income Statements For Years Ended December 31, 2017, 2016, and 2015 2017 2016 2015 Sales $ 412,503 $ 316,011 $ 219,300 Cost of goods sold 248,327 197,823 140,352 Gross profit 164,176 118,188 78,948 Selling expenses 58,575 43,610 28,948 Administrative expenses 37, 125 27,809 18, 202 Total expenses 95,700 71,419 47,150 Income before taxes 68, 476 46,769 31,798 Income taxes 12,737 9,588 9,588 6,455 Net income $ 55,739 $ 37,181...
Selected comparative financial statements of Korbin Company follow: KORBIN COMPANY Comparative Income Statements For Years Ended December 31, 2017, 2016, and 2015 2017 2016 2015 Sales $ 442,787 $ 339,211 $ 235, 400 Cost of goods sold 266,558 215,060 150,656 Gross profit 176,229 124, 151 84,744 Selling expenses 62,876 46,811 31,073 Administrative expenses 39,851 29,851 19,538 Total expenses 102,727 76,662 50,611 Income before taxes 73,502 47,489 34,133 Income taxes 13,671 9,735 6,929 Net income $ 59,831 $ 37,754 $ 27,204...
LOGIC COMPANY Comparative Income Statement For Years Ended December 31, 2016 and 2017 2017 2016 Gross sales $ 19,200 $ 15,150 Sales returns and allowances 900 100 Net sales $ 18,300 $ 15,050 Cost of merchandise (goods) sold 11,950 8,950 Gross profit $ 6,350 $ 6,100 Operating expenses: Depreciation $ 720 $ 610 Selling and administrative 2,350 2,100 Research 570 510 Miscellaneous 380 310 Total operating expenses $ 4,020 $ 3,530 Income before interest and taxes $ 2,330 $ 2,570...
LOGIC COMPANY Comparative Income Statement For Years Ended December 31, 2019 and 2020 2019 2020 Gross sales $19,000 1,000 $18,000 12,000 $6,000 $15,000 100 Sales returns and allowances Net sales Cost of merchandise (goods) sold Gross profit Operating expenses: Depreciation Selling and administrative Research $14,900 9,000 $5,900 $ $ 2,000 500 600 700 2,200 550 Miscellaneous Total operating expenses Income before interest and taxes Interest expense Income before taxes Provision for taxes 360 300 $3,810 $ 2,190 $3,400 2,500 560...
Selected comparative financial statements of Korbin Company
follow:
KORBIN COMPANY
Comparative Income Statements
For Years Ended December 31, 2017, 2016, and
2015
2017
2016
2015
Sales
$
554,143
$
424,519
$
294,600
Cost of goods sold
333,594
269,145
188,544
Gross profit
220,549
155,374
106,056
Selling expenses
78,688
58,584
38,887
Administrative expenses
49,873
37,358
24,452
Total expenses
128,561
95,942
63,339
Income before taxes
91,988
59,432
42,717
Income taxes
17,110
12,184
8,672
Net income
$
74,878
$
47,248
$
34,045
KORBIN COMPANY...
Comparative financial statements for Weller Corporation, a merchandising company, for the year ending December 31 appear below. The company did not issue any new common stock during the year. A total of 700,000 shares of common stock were outstanding. The interest rate on the bonds, which were sold at their face value, was 10%. The income tax rate was 40% and the dividend per share of common stock was $0.40 this year. The market value of the company's common stock...