Using ratios to evaluate a stock investment Learning Objective 4 1. 2018: e. 48.9% Comparative financial statement data of Sanfield, Inc. follow: SANFIELD, INC. Comparative Income Statement Year Ended December 31, 2018 and 2017 2018 2017 Net Sales Revenue $462,000 $430,000 Cost of Goods Sold 236,000 213,000 Gross Profit 226,000 217,000 Operating Expenses 135,000 133,000 Income From Operations 91,000 84,000 Interest Expenses 8,000 12,000 Income Before Income Tax 83,000 72,000 Income Tax Expense 18,000 22,000 Net Income $65,000 $50,000 SANFIELD, INC. Comparitive Income Statement Year Ended December 31, 2018 and 2017 2018 2017 2016* Assets Current Assets: Cash $99,000 $97,000 Accounts Receivable , Net 109,000 117,000 $100,000 Merchandise Inventory 142,000 164,000 $207,000 Prepaid Expenses 15,000 5,000 Total Current Assets 365,000 383,000 Property, Plant, and, Equipment, Net 215,000 177,000 Total Assets $580,000 $560,000 $599,000 Liabilities Total Current Liabilities $222,000 $244,000 Long-Term Liabilities 113,000 92,000 Total Liabilities 335,000 336,000 Stockholders' Equity Preferred Stock , 4% 92,000 92,000 Common Stockholders' Equity, no par 153,000 132,000 85,000 Total Liabilities and Stockholders' Equity $580,000 $560,000 Market price of Sanfield’s common stock: $51.48 at December 31, 2016, and $37.08 at December 31,2017. Common shares outstanding: 16,000 on December 31, 2018 and 15,000 on December 31, 2017 and 2016. All sales are on credit. Requirements 1. Compute the following ratios for 2018 and 2017: Current ratio Cash ratio Times-interest-earned ratio Inventory turnover Gross profit percentage Debt to equity ratio Rate of return on common stockholders' equity Earnings per share of common stock Price/earnings ratio 2. Decide (a) whether Sanfield’s ability to pay debts and to sell inventory improved or deteriorated during 2018 and (b) whether the investment attractiveness of its common stock appears to have increased or decreased.

Profitability Ratios Tinker Corporation operates in the highly competitive consulting industry. Tinkers balance sheet indicates the following balances as of December 31, 2019. Required: Calculate Tinkers return on equity if Tinkers 2019 net income is $90,000.

GIVE THE COMPARATIVE INCOME STATEMENT HORIZONTAL ANALYSIS FROM THE FOLLOWING INCOME STATEMENT BELOW JOLLIBEE INCOME STATEMENT ITEM 2016 2017 2018 2019 2020 Sales/Revenue 113.81B 133.61B 161.17B 179.63B 129.31B Sales Growth - 17.40% 20.62% 11.45% -28.01% Cost of Goods Sold (COGS) incl. D&A - - 132.96B 150.88B 115.39B COGS Growth - - - 13.47% -23.52% COGS excluding D&A 89.27B 105.39B 121.08B 137.38B 100.82B Depreciation & Amortization Expense 4B 4.75B 11.89B 13.5B 14.57B Depreciation 3.93B 4.66B 11.73B 13.34B 14.32B Amortization of Intangibles 68.99M 78.95M 151.82M 145.42M 245.23M Gross Income 20.54B 23.48B 28.21B 28.75B 13.92B Gross Income Growth - 14.30% 20.12% 1.93% -51.57% Gross Profit Margin - - - - 10.77% SG&A Expense - - 17.64B 20.21B 20.42B SGA Growth - - - 14.57% 1.02%…

Some selected financial statement items belonging to MNO Company are given in the table below. According to this information, which of the following is Return on Assets (ROA) in 2021? Inventory 12,500Total Assets in 2021 110,000Current Liabilities 40,000Total Assets in 2020 90,000Net Profit 12,000Shareholders' Equity 65,000 Select one:a. 0.12b. 0.10c. 0.18d. 0.13

DIRECTION: Compute the following PROFITABILITY RATIOS Gross Margin= Gross Profit/Net Sales Net Profit Margin= Net Profit/ Net Sales Return on Equity= Profit/Shareholder's Equity Return on Asset= Profit/Total Asset TREND ANALYSIS Net Income Growth Rate Total Assets Growth Rate And also compute the percentage beside the columns December 31, December 31, PERCENTAGE 2021 2020 USD USD Assets Current assets Cash and cash equivalents 34,115,412 25,681,845 Short-term financial instruments 71,417,748 80,798,680 Short-term financial assets at amortized cost 2,944,705 2,409,853 Short-term financial assets at fair value through profit or loss 35,624 62,452 Trade receivables 35,585,565 27,065,012 Non-trade receivables 3,930,828 3,150,548 Prepaid expenses 2,042,001 1,980,685 Inventories 36,172,043 28,007,314 Other current assets 4,441,629 3,281,589 Assets held-for-sale - 812,370 Total Current Assets…

Compute DuPont Analysis Ratios Selected balance sheet and income statement information for Humana Inc., a health and well‑being company, follows. 2018 2017 2018 2018 Net 2018 2017 Stockholders’ Stockholders’ Company ($ millions) Ticker Revenue income Assets Assets Equity Equity Humana Inc HUM $66,610 $11,381 $35,111 $36,876 $19,859 $19,540 Compute the following 2018 ratios for Humana. a. Return on equity (ROE) Note: 1. Select the appropriate numerator and denominator used to compute ROE from the drop-down menu options. 2. Enter the numerator and denominator amounts to compute ROE. Numerator Denominator ROE Answer Answer Answer Answer b. Profit margin (PM) Note: 1. Select the appropriate numerator and denominator used to compute PM from the drop-down menu options. 2. Enter the numerator and denominator amounts to compute PM. Numerator Denominator PM Answer Answer Answer Answer c. Financial leverage…

Profitability and Asset Management Ratios You are thinking of investing in Tikki's Torches, Inc. You have only the following information on the firm at year-end 2018: net income = $680,000, total debt = $13.8 million, debt ratio = 43%. What is Tikki's ROE for 2018? Multiple Choice 4.93% 11.47% 2.12%% 3.72%

Some selected financial statement items belonging to Tower Company are given in the table below. According to this information, which of the following is Return on Assets (ROA) in 2021? Inventory 12,500 Total Assets in 2021 100,000 Current Liabilities 30,000 Total Assets in 2020 80,000 Net Profit 18,000 Shareholders' Equity 65,000 Select one: a. 24% b. 20% c. 11% d. 15%

Using ratios to evaluate a stock investment Comparative financial statement data of Garfield Inc. follow: Market price of Garfield’s common stock:$69.36 at December 31 2018 and $38.04 at December 31, 2017. Common shares outstanding 14, 000 on December 31, 2018 and 12,000 on December 31 2017 and 2016. All sales are on credit. Requirements Compute the following ratios tor 2018 and 2017: a. current ratio b. Cash ratio c. Times-interest-earned ratio d. Inventory turnover e. Gross profit percentage f. Debt to equity ratio g. Rate of return on common stockholder’s equity h. Earnings per share of common stock i. Price/earnings ratio 2. Decide (a) whether Garfield’s ability to pat debts and to sell inventory improved or deteriorated during 2018 and (b) whether the investment attractiveness of its common stock appears to have increased or decreased.

Excerpts from Dowling Company's December 31, 2021 and 2020, financial statements and key ratios are presented below (all numbers are in millions): 2021 2020 Accounts receivable (net) $ 20 $ 16 Net sales $ 115 100 Cost of goods sold $ 60 55 Net income $ 20 17 Inventory turnover 5.22 Return on assets 10.3 % Equity multiplier 2.36 Dowling's average total assets for 2021 is (rounded): Multiple Choice 32. 210. 115. 194.

Ratios Compared with Industry Averages Because you own the common stock of Phantom Corporation, a paper manufacturer, you decide to analyze the firm's performance for the most recent year. The following data are taken from the firm's latest annual report: P12-8A. LO4 Dec. 31, 2020 Dec. 31, 2019 Quick assets. $ $ 700,000 372,000 4,788,000 552,000 312,000 Inventory and prepaid expenses Other assets. 4,200,00O $5,064,00O Total Assets $5,860,000 Current liabilities. 10% Bonds payable 8% Preferred stock, $1 00 par value Common stock, $10 par value Retained earnings $4 724,000 1,440,00o 480,000 2,700,00O 516,000 $5,860,000 564,000 1,440,000 480,000 2,160,00O 420,000 Total Liabilities and Stockholders' Equity $5,064,00o For 2020, net sales amount to $11,280,000, net income is $575,000, and preferred stock dividends paid are $42,000. Required Calculate the following ratios for 2020: 1. a. Profit margin 2. Return on assets 3. Return on common stockholders’ equity Quick ratio Current ratio 4. 5.…

OBJECTIVE: To enable learners to utilize financial ratios as a mechanism to evaluate the firm's financial performance and identify areas for making decisions for improvement REQUIREMENT: Financial Statement Analysis Question Refer to the following financial statements of Delima Corporation for 2019 and 2020: Delima Corporation Income Statements For the year ended 31 December (in millions) 2020 $13,198 7,750 2019 $12,397 7,108 Net sales Cost of goods sold Gross profit Selling and administrative expenses Income from operations 5,448 5,289 3,472 3,299 1,976 1,990 Interest expense 233 248 Other (income) expense, net 11 1,732 503 1,229 Income before income taxes 1,742 Income tax expense 502 Net income 1,240 Delima Corporation Balance Sheets 31 December (in millions) 2020 2019 Assets Current assets Cash $460 $444 Accounts receivables (net) 1,188 1,132 1,190 1,056 225 2,915 3,128 Inventories Other current assets 247 Total current assets 3,027 3,281 Property (net) 5,593 $11,901 Other assets…

KORBIN COMPANY Comparative Income Statements For Years Ended December 31 Sales Cost of goods sold Gross profit Selling expenses Administrative expenses Total expenses Income before taxes Income tax expense Net income Assets Current assets Long-term investments Plant assets, net Total assets Liabilities and Equity Current liabilities KORBIN COMPANY Comparative Balance Sheets Common stock Other paid-in capital Retained earnings 2021 2020 2019 $ 483,981 $ 370,769 $257,300 291,357 234,326 164,672 192,624 136,443 92,628 68,725 51,166 33,964 43,558 32,628 21,356 112,283 83,794 55,320 80,341 37,308 14,943 7,574 $ 65,398 $ 41,856 $ 29,734 Sales Cost of goods sold Gross profit Selling expenses Administrative expenses December 31 2021 Total expenses Income before taxes Income tax expense Net income $ 57,843 0 14.19 52,649 10,793 $ 20,253 $ 19 708 66,000 48,000 8,250 8,250 5,333 39,574 65,490 41,423 Total liabilities and equity $ 163,630 $ 135,926 $ 112,615 % $ 38,714 900 105,787 96,312 $ 163,630…

Videos

Chapter 17 Solutions

		SANFIELD, INC.
		Comparative Income Statement
		Year Ended December 31, 2018 and 2017
			2018	2017
Net Sales Revenue		$462,000	$430,000
Cost of Goods Sold		236,000	213,000
Gross Profit		226,000	217,000
Operating Expenses		135,000	133,000
Income From Operations	91,000	84,000
Interest Expenses		8,000	12,000
Income Before Income Tax	83,000	72,000
Income Tax Expense	18,000	22,000
Net Income		$65,000	$50,000

			SANFIELD, INC.
			Comparitive Income Statement
			Year Ended December 31, 2018 and 2017
				2018	2017	2016*
	Assets
Current Assets:
Cash				$99,000	$97,000
Accounts Receivable, Net		109,000	117,000	$100,000
Merchandise Inventory		142,000	164,000	$207,000
Prepaid Expenses			15,000	5,000
Total Current Assets		365,000	383,000
Property, Plant, and, Equipment, Net	215,000	177,000
Total Assets			$580,000	$560,000	$599,000

	Liabilities
Total Current Liabilities		$222,000	$244,000
Long-Term Liabilities		113,000	92,000
Total Liabilities			335,000	336,000

	Stockholders' Equity
Preferred Stock, 4%			92,000	92,000
Common Stockholders' Equity, no par	153,000	132,000	85,000
Total Liabilities and Stockholders' Equity	$580,000	$560,000