Question

In: Accounting

Comparative financial statement data of Lannister Inc. are as follows: Lannister Inc. Comparative Income Statement Years...

Comparative financial statement data of Lannister Inc. are as follows:

Lannister Inc.
Comparative Income Statement
Years Ended December 31, 2016 and 2015
	2016	2015
Net sales	$687,000	$595,000
Cost of goods sold	375,000	276,000
Gross profit	312,000	319,000
Operating expenses	129,000	142,000
Income from operations	183,000	177,000
Interest expense	37,000	45,000
Income before income tax	146,000	132,000
Income tax expense	36,000	51,000
Net income	$110,000	$81,000

Lannister Inc.
Comparative Balance Sheet
December 31, 2016 and 2015
	2016	2015	2014
Current assets:
Cash	$45,000	$49,000
Current receivables, net	212,000	158,000	$200,000
Inventories	297,000	281,000	181,000
Prepaid expenses	4,000	29,000
Total current assets	558,000	517,000
Property, plant and equipment, net	285,000	277,000
Total assets	$843,000	$794,000	$700,000
Accounts payable	150,000	105,000	112,000
Other current liabilities	135,000	188,000
Total current liabilities	$285,000	$293,000
Long-term liabilities	243,000	231,000
Total liabilities	528,000	524,000
Common shareholders’ equity, no par	315,000	270,000	199,000
Total liabilities and shareholders’ equity	$843,000	$794,000

Other information:

Market price of Lannister common stock: $102.17 at December 31, 2016; and $77.01 at December 31, 2015.
Common shares outstanding: 18,000 during 2016 and 17,500 during 2015.
All sales on credit.

Compute the following ratios for 2016 and 2015
- Current ratio
- Quick ratio (acid test)
- Receivables turnover and days’ sales outstanding (rounded to the nearest whole day)
- Inventory turnover and days inventory outstanding (rounded to the nearest whole day)
- Accounts payable turnover and days’ payable outstanding (rounded to the nearest whole day).
- Cash conversion cycle (in days)
- Times-interest-earned ratio
- Return on assets
- Return on common shareholders’ equity
- Earnings per share of common stock
- Price/earnings ratio.
Decide whether (a) Lannister’s financial position improved or deteriorated during 2016 and (b) the investment attractiveness of Lannister’s common stock appears to have increased or decreased.

Expert Solution

Current ratio = Current assets / Current Liabilities

2016 = 558,000 / 285,000 = 1.96

2015 = 517,000 / 293,000 = 1.76

Quick ratio = Quick Assets / Current Liabilities

2016 = (45000 + 212000 ) / 285,000 = 0.902

2015 = ( 49000 + 158000 ) / 293000 = 0.706

Receivables turnover = Sales / Avg. Receivables

2016 = 687,000 / ( 212,000 + 158000 ) / 2 = 687000 / 185000 = 3.71

2015 = 595,000 / ( 158000 + 200000 ) / 2 = 595000 / 179000 = 3.32

Days’ Sales Outstanding = 365 / Receivables turnover

2016 = 365 / 3.71 = 98.38 Days

2015 = 365 / 3.32 = 109.94 Days

Inventory turnover = Cost of goods sold / Avg. Inventory

2016 = 375,000 / ( 297,000 + 281000 ) / 2 = 375000 / 289000 = 1.30

2015 = 276,000 / ( 281000 + 181,000 ) / 2 = 276000 / 231000 = 1.19

Days Inventory Outstanding = 365 / Inventory turnover

2016 = 365 / 1.30 = 280.77 Days

2017 = 365/ 1.19 = 306.72 Days

Accounts payable turnover = Cost of goods sold / Avg. Accounts Payables

2016 = 375,000 / ( 150,000 + 105000 ) / 2 = 375000 / 127500 = 2.94

2015 = 276,000 / ( 105000 + 112,000 ) / 2 = 276000 / 108500 = 2.54

Days’ Payable Outstanding = 365 / Accounts payable turnover

2016 = 365 / 2.94 = 124.15 Days

2015 = 365 / 2.54 = 143.7 Days

Cash conversion cycle = Days Inventory Outstanding + Days’ Sales Outstanding - Days’ Payable Outstanding

2016 = 280.77 + 98.38 - 124.15 = 255 Days

2015 = 306.72 + 109.94 - 143.7 = 272.96 Days

Times-interest-earned = Income from operations / Interest expense

2016 = 183,000 / 37000 = 4.95

2015 = 177,000 / 45000 = 3.93

Return on assets = Net Income / Avg. Total assets

2016 = 110,000 / ( 843,000 + 794000 ) / 2 = 110000 / 818500 = 13.44%

2015 = 81000 / ( 794000 + 700000 ) / 2 = 81000 / 747000 = 10.84%

Return on common shareholders’ equity = Net Income / Avg. Total common shareholders’ equity

2016 = 110000 / ( 315,000 + 270000 ) / 2 = 110000 / 292500 = 37.61%

2015 = 81000 / ( 270000 + 199000 ) / 2 = 81000 / 234500 = 34.54%

Earnings per share of common stock = Net Income / Common shares outstanding

2016 = 110000 / 18000 = $6.11

2015 = 81000 / 17500 = $4.63

Price/earnings ratio. = Market Price / Earnings per share

2016 = 102.17 / 6.11 = 16.72

2015 = 77.01 / 4.63 = 16.63

Lannister’s financial position has improved in 2016 and the investment attractiveness have increased .

ekkarill92 answered 1 year ago

Question 4 Comparative financial statement data of Lannister Inc. are as follows: Lannister Inc. Comparative Income...

Question 4 Comparative financial statement data of Lannister Inc. are as follows: Lannister Inc. Comparative Income Statement Years Ended December 31, 2016 and 2015 2016 2015 Net sales $687,000 $595,000 Cost of goods sold 375,000 276,000 Gross profit 312,000 319,000 Operating expenses 129,000 142,000 Income from operations 183,000 177,000 Interest expense 37,000 45,000 Income before income tax 146,000 132,000 Income tax expense 36,000 51,000 Net income $110,000 $81,000 Lannister Inc. Comparative Balance Sheet December 31, 2016 and 2015 2016 2015...

A comparative statement of financial position for Nathalina Industries Inc. follows: NATHALINA INDUSTRIES INC. Statement of...

A comparative statement of financial position for Nathalina Industries Inc. follows: NATHALINA INDUSTRIES INC. Statement of Financial Position December 31, 2020 December 31 Assets 2020 2019 Cash $ 21,000 $ 34,000 Accounts receivable 114,000 54,000 Inventory 220,000 189,000 Land 71,000 110,000 Equipment 240,000 200,000 Accumulated depreciation—equipment (69,000) (42,000) Total $597,000 $545,000 Liabilities and Shareholders' Equity Accounts payable. 52,000. 59,000 Long term liabilities 25,000 0 Bonds payable 125,000 200,000 Common shares 204,000 164,000 Retained earnings 191,000 ...

A comparative statement of financial position for Sheffield Industries Inc. follows: SHEFFIELD INDUSTRIES INC. Statement of...

A comparative statement of financial position for Sheffield Industries Inc. follows: SHEFFIELD INDUSTRIES INC. Statement of Financial Position December 31, 2020 December 31 Assets 2020 2019 Cash $22,500 $35,500 Accounts receivable 117,000 55,300 Inventory 231,000 199,000 Land 86,000 130,000 Equipment 278,000 204,000 Accumulated depreciation—equipment (70,500 ) (42,900 ) Total $664,000 $580,900 Liabilities and Shareholders’ Equity Accounts payable $52,700 $60,200 Bonds payable 164,400 218,400 Common shares 234,000 180,000 Retained earnings 212,900 122,300 Total $664,000 $580,900 Additional information: 1. Net...

Question 3 Comparative financial statement data of Tardis Plc follow: Tardis Plc Comparative Income Statement For...

Question 3 Comparative financial statement data of Tardis Plc follow: Tardis Plc Comparative Income Statement For the year ended 30 June 2020 2020 2019 Net Sales 667,000 599,000 Cost of Goods Sold (378,000) (283,000) Gross Profit 289,000 316,000 Operating Expenses 129,000 147,000 Interest Expense 57,000 41,000 Total Expenses 186,000 188,000 Profit Before Incoming Tax 103,000 128,000 Income Tax Expense 34,000 53,000 Net Profit 69,000 75,000 Tardis Plc Comparative Balance Sheet As of 30 June 2020 2020 2019 2018 Current Assets:...

Revenue and expense data for Searle Technologies Co. are as follows: The following comparative income statement...

Revenue and expense data for Searle Technologies Co. are as follows: The following comparative income statement (in thousands of dollars) for two recent years was adapted from the annual report of Speedway Motorsports, Inc. (TRK), owner and operator of several major motor speedways, such as the Atlanta, Bristol, Charlotte, Texas, and Las Vegas Motor Speedways. Year 2 Year 1 Revenues: Admissions $100,798 $106,050 Event-related revenue 146,849 145,749 NASCAR broadcasting revenue 207,369 199,014 Other operating revenue 29,293 29,836 Total revenue $484,309...

A comparative statement of financial position for Blue Spruce Industries Inc. follows: BLUE SPRUCE INDUSTRIES INC....

A comparative statement of financial position for Blue Spruce Industries Inc. follows: BLUE SPRUCE INDUSTRIES INC. Statement of Financial Position December 31, 2020 December 31 Assets 2020 2019 Cash $22,800 $35,800 Accounts receivable 122,000 55,600 Inventory 234,000 191,000 Land 77,000 125,000 Equipment 269,000 216,000 Accumulated depreciation—equipment (70,300 ) (43,500 ) Total $654,500 $579,900 Liabilities and Shareholders’ Equity Accounts payable $52,400 $59,500 Bonds payable 163,800 213,800 Common shares 233,000 183,000 Retained earnings 205,300 123,600 Total $654,500 $579,900 Additional information:...

A comparative statement of financial position for Ayayai Corporation follows: AYAYAI CORPORATION Statement of Financial Position...

A comparative statement of financial position for Ayayai Corporation follows: AYAYAI CORPORATION Statement of Financial Position December 31 Assets 2020 2019 Cash $48,100 $21,460 Accounts receivable 64,380 43,660 Inventory 98,420 59,940 FV-OCI investments in shares 46,620 62,160 Land 48,100 76,220 Equipment 288,600 318,200 Accumulated depreciation—equipment (86,580 ) (63,640 ) Goodwill 91,760 128,020 Total $599,400 $646,020 Liabilities and Shareholders’ Equity Accounts payable $8,880 $37,740 Dividends payable 11,100 23,680 Notes payable 162,800 247,900 Common shares 196,100 92,500 Retained earnings 213,120 210,160 Accumulated...

P5.11 A comparative statement of financial position for Spencer Corporation follows: Spencer Corporation Statement of Financial...

P5.11 A comparative statement of financial position for Spencer Corporation follows: Spencer Corporation Statement of Financial Position December 31 Assets 2020 2019 Cash $ 65,000 $ 29,000 Accounts receivable 87,000 59,000 Inventory 133,000 81,000 FV-OCI investments in shares 63,000 84,000 Land 65,000 103,000 Equipment 390,000 430,000 Accumulated depreciation—equipment (117,000) (86,000) Goodwill 124,000 173,000 Total $810,000 $873,000 Liabilities and Shareholders' Equity Accounts payable $ 12,000 $ 51,000 Dividends payable 15,000 32,000 Notes payable 220,000 335,000 Common shares 265,000 125,000 Retained...

The following are income statement and comparative statement of financial position for Rabies Corporation for the...

The following are income statement and comparative statement of financial position for Rabies Corporation for the year ended 31/12/2019. Sales 1,915,000 C.G.S (965,000) gross income 950,000 Operating expenses (721,000) income from operating 229,000 Other gain or losses ( 2,000) Interest expenses (12,000) Tax (65,000) net income 150,000 Comparative statement of financial positions for the year ended 31/12/2019 ASSETS 2019 2018 L. S. Equity 2019 2018 Cash 104,000 57,000 Accounts payable 69,000 75,000 Accounts receivable 82,000 36,000 Accrued expenses 15,700 16000...

The income statement and additional data of Bayleaf Pty Ltd are as follows: Income statement for...

The income statement and additional data of Bayleaf Pty Ltd are as follows: Income statement for the year ended 31 December 2016 Revenue: Service Revenue R225 000 Dividend Revenue R6 300 (231 300) Expenses: Cost of goods sold R100 000 Salary Expense R52 000 Depreciation Expense R23 000 Advertising Expense R2 300 Interest Expense R2 400 Income tax expense R5 000 (R184 700) Net income R46 600 Additional Data: a) Acquisition of PPE was R170 000. Of this amount ,...