Please hit LIKE button if this helped. For any further explanation, please put your query in comment, will get back to you. | ||||||
Year 2015 | Year 2016 | |||||
a. Current Ratio: | Current assets | $ 106 | $ 143 | |||
Current Liabilities | $ 65 | $ 64 | ||||
Current Ratio | Current assets/Current Liabilities | 1.63 | 2.23 | Times | ||
Current ratio has improved in Year 2016 compared to Year 2015. Low ratio indicates cash problems. | ||||||
Though high ratio is also indiative of too much of working capital, however comparative to 2015, 2016 is good. | ||||||
To have better idea, we should also check industry norms. | ||||||
b. Days Sales Outstanding | Accounts Receivable | $ 31 | $ 36 | |||
Sales | $ 500 | $ 600 | ||||
Days Sales Outstanding | Accounts Receivable/(Sales/365) | 22.63 | 21.90 | Days | ||
Days sales outstanding has improved in Year 2016. Earlier days sales outstnading was almost 23 days | ||||||
which now has reduced to 22 days | ||||||
c. Inventory Turnover Ratio | Inventory | $ 51 | $ 84 | |||
Sales | $ 500 | $ 600 | ||||
Inventory Turnover Ratio | Sales/Inventories | 9.80 | 7.14 | |||
This ratio shows how effectively inventory is being managed. Higher ratio is sign of ineffective management. | ||||||
Hence, there is improvement in Turn ratio in 2016 | ||||||
d. Total debt to Assets | Total Debt | $ 225 | $ 235 | |||
Total Assets | $ 392 | $ 438 | ||||
Total Debt to Assets | Total Debt/Total Assets | 0.57 | 0.54 | |||
There is improvement in the ratio since increase in debt is lesser than increase in assets. | ||||||
e. Return on Assets | Net Income | $ 42 | $ 58 | |||
Total Assets | $ 392 | $ 438 | ||||
Return on Assets | Net Income/Total Assets | 10.71% | 13.24% | |||
Return on assets has imprved in Year 2016 meaning deplyoment of assets is generating more income in 2016 | ||||||
f. Return on Equity | Net Income | $ 42 | $ 58 | |||
Total Equity | $ 167 | $ 203 | ||||
Return on Equity | Net Income/Total Equity | 25.15% | 28.57% | |||
Return on Equity has imprved in Year 2016 meaning there is more income being generated against capital invested. |
QUESTION 3 From following financial statements, calculate following ratios and analyse the current year and previous...
need help ? Selected year-end financial statements of Cabot Corporation follow. (All sales were on credit; selected balance sheet amounts at December 31, 2016, were inventory, $52.900; total assets, $229,400; common stock, $88,000; and retained earnings. $32,712.) CABOT CORPORATION Income Statement For Year Ended December 31, 2017 Sales $ 450, 600 Cost of goods sold 297,650 Gross profit 152,950 Operating expenses 99, 100 Interest expense 3,800 Income before taxes 50,050 Income taxes 20. 162 Net Income $ 29,888 $ 16,500...
Problem 13-4A Calculation of financial statement ratios LO P3 Selected year-end financial statements of Cabot Corporation follow. (All sales were on credit; selected balance sheet amounts at December 31, 2016, were inventory, $50,900; total assets, $249,400; common stock, $90,000; and retained earnings, $43,304.) CABOT CORPORATION Income Statement Por Year Ended December 31, 2017 Sales $ 451,600 Cost of goods sold 298,050 Gross profit 153,550 Operating expenses 99,000 Interest expense 3,900 Income before taxes 50,650 Income taxes 20,404 Net income $...
Problem 13-4A Calculating financial statement ratios LO P3 Selected current year-end financial statements of Cabot Corporation follow. (All sales were on credit; selected balance sheet amounts at December 31 of the prior year were inventory, $50,900; total assets, $169,400; common stock, $84,000; and retained earnings, $31,305.) CABOT CORPORATION Income Statement For Current Year Ended December 31 Sales $ 455,600 Cost of goods sold 297,350 Gross profit 158,250 Operating expenses 98,800 Interest expense 4,700 Income before taxes 54,750 Income tax expense...
urrent Attempt in Progress The condensed financial statements of Crane Company for the years 2016 and 2017 are presented below. CRANE COMPANY Balance Sheets December 31 (in thousands) 2017 2016 Current assets Cash and cash equivalents $330 $360 Accounts receivable (net) 530 460 Inventory 640 570 Prepaid expenses 130 160 Total current assets 1,630 1,550 Property, plant, and equipment (net) 410 380 Investments 70 70 Intangibles and other assets 530 510 Total assets $2,640 $2,510 Current liabilities $880 $850 Long-term...
The condensed financial statements of Ivanhoe Company for the years 2016 and 2017 are presented below. IVANHOE COMPANY Balance Sheets December 31 (in thousands) 2017 2016 Current assets Cash and cash equivalents $330 $360 Accounts receivable (net) 580 510 Inventory 550 480 Prepaid expenses 130 160 Total current assets 1,590 1,510 Property, plant, and equipment (net) 410 380 Investments 120 120 Intangibles and other assets 530 510 Total assets $2,650 $2,520 Current liabilities $930 $900 Long-term liabilities 570 470 Stockholders’...
Problem 13-4A Calculation of financial statement ratios LO P3 Selected year-end financial statements of Cabot Corporation follow. (All sales were on credit; selected balance sheet amounts at December 31, 2016, were inventory, $47,900; total assets, $209,400, common stock, $90,000; and retained earnings, $37,678.) CABOT CORPORATION Income Statement For Year Ended December 31, 2017 Sales $ 453,600 Cost of goods sold 298,450 Gross profit 155, 150 Operating expenses 99,200 Interest expense 4,000 Incone before taxes 51,950 Income taxes 20,928 Net Income...
[The following information applies to the questions displayed below.] Selected comparative financial statements of Korbin Company follow. 2815 $ 229,500 141, 120 79,388 29,106 18, 382 X KORDIN COMPANY Comparative Income statements For Years Ended December 31, 2017, 2016, and 2015 2017 2016 Sales $ 414,761 $ 317,741 Cost of goods sold 249,686 199,859 Gross profit 165, 075 117,882 Selling expenses 58,896 43.848 Administrative expenses 37,328 27,961 Total expenses 96,224 71, 809 Income before taxes 63,851 46,073 Income taxes 12,886...
Q-2 FINANCIAL RATIO FORMULAS Match each of the following financial ratios with its formula: Accounts Payable Tunover Ratio Fixed Asset Turnover Ratio Asset Turnover Ratio Cash Coverage Ratio Cash Ratio Current Ratio Average Age of Receivables Average Days Supply in Inventory Receivable Turnover Ratio Debt-to-Equity Ratio Earnings per Share (EPS) Financial Leverage Percentage Times Interest Earned Ratio Inventory Turnover Ratico Price/ Earnings (P/E) Ratio Profit Margin Quality of Income Quick Ratio Return on Equity (ROE) Return on Assets (ROA) A....
The condensed financial statements of Ivanhoe Company for the years 2016 and 2017 are presented below. IVANHOE COMPANY Balance Sheets December 31 (in thousands) 2017 2016 Current assets Cash and cash equivalents $330 $360 Accounts receivable (net) 630 560 Inventory 600 530 Prepaid expenses 130 160 Total current assets 1,690 1,610 Property, plant, and equipment (net) 410 380 Investments 170 170 Intangibles and other assets 530 510 Total assets $2,800 $2,670 Current liabilities $980 $950 Long-term liabilities 620 520 Stockholders’...
Problem 13-4A Calculating financial statement ratios LO P3 Selected current year-end financial statements of Cabot Corporation follow. (All sales were on credit; selo at December 31 of the prior year were inventory, $50,900; total assets, $209,400; common stock, $83,00 $54,315.) CABOT CORPORATION Income Statement For Current Year Ended December 31 Sales $ 452,600 Cost of goods sold 297,550 Gross profit 155,050 Operating expenses 99,500 Interest expense 4,500 Income before taxes 51,050 Income tax expense 20,565 Net income $ 30,485 $...