Compute and give the complete solution. Activity 3. Financial Ratios (continuation.)Required: Compute the following ratios at December 31, 2017:1. Current ratio2. Quick ratio3. Accounts receivable turnover4. Collection period5. Inventory turnover6. Inventory conversion period7. Debt-to-equity ratio8. Debt ratio9. Gros profit ratio10.Return on assets11.Return on equity Activity 3. Financial RatiosR6 CompanyComparative Balance SheetOK, LET'S TRY THIS.December 31, 2017 and 201620172016ASSETSCash30,000.0045,000.00Accounts Receivable (net)97,500.0090,000.0090,000.00Additional informatiu.i for 2017:Inventory75,000.00300,000.00 270,000.00517,500.00 480,000.00Property, palnt and equipment (net)a. Income before interest expenseTOTAL ASSETSand income taxes was P168,000.b. Sales on account were P990,000.c. Sales returns and allowancesamounted to P5,625.d. Cost of goods sold was P676,500.e. Interest expense totaled P12,000.LIABILITIES AND STOCKHOLDERS' EQUITY75,000.00150,000.00 150,000.00210,000.00 180,000.00Accounts Payable90,000.00Mortgage PayableCommon Stock, P10 parRetained Earnings82,500.0060,000.00TOTAL LIABILITIES AND STOCKHOLDERS' EQUITY 517,500.00 480,000.00f.Income tax rate is 30%

Ratio analysis is referred to as the quantitative method for gaining an insight in to the…

Answered: Activity 3. Financial Ratios R6 Company…

Cornerstones of Financial Accounting

4th Edition

ISBN:9781337690881

Author:Jay Rich, Jeff Jones

Publisher:Jay Rich, Jeff Jones

Chapter12: Fainancial Statement Analysis

Section: Chapter Questions

Problem 89PSB

See similar textbooks

Similar questions

Profitability ratios The following selected data were taken from the financial statements of Robinson Inc. for December 31, 2016, 2015 and 2014: December31 2016 2015 2014 Total assets......................................... 4,800,000 4,400,000 4,000,000 Notes payable (8% interest)........................... 2,250,000 2,250,000 2,250,000 Common stock...................................... 250,000 250,000 250,000 Preferred 4% stock, 100 par (no change during year)........................... 500,000 500,000 500,000 Retained earnings................................... 1,574,000 1,222,000 750,000 The 2016 net income was 372,000, and the 2015 net income was 492,000. No dividends on common stock were declared between 2014 and 2016. a. Determine the rate earned on total assets, the rate earned on stockholders equity, and the rate earned on common Stockholders equity for the years 2015 and 2016. Round to one decimal place. b. What conclusions can be drawn from these data as to the companys profitability?
FINANCIAL STATEMENTS, CASH FLOW, AND TAXES Laiho Industriess 2017 and 2018 balance sheets (in thousands of dollars) are shown. 2018 2017 Cash 102,850 89,725 Accounts receivable 103,365 85,527 Inventories 38,444 34,982 Total current assets 244,659 210,234 Net fixed assets 67,165 42,436 Total assets 311,824 252,670 Accounts payable 30,761 23,109 Accruals 30,477 22,656 Notes payable 16,717 14,217 Total current liabilities 77,955 59,982 Long-term debt 76,264 63,914 Total liabilities 154,219 123,896 Common stock 100,000 90,000 Retained earnings 57,605 38,774 Total common equity 157,605 128,774 Total liabilities and equity 311,824 252,670 a. Sales for 2018 were 455,150,000, and EBITDA was 15% of sales Furthermore, depreciation and amortization were 11%. of net fixed assets, interest was 8,575,000, the corporate tax rate was 40%, and Laiho pays 40% of its net income as dividends Given this information. construct the firms 2018 income statement. b. Construct the statement of stockholders equity for the year ending December 31, 2018, and the 2018 statement of cash flows. c. Calculate 2017 and 2018 net operating working capital (NOWC) and 2018 free cash flow (FCF). Assume the firm has no excess cash. d. If Laiho increased its dividend payout ratio, what effect would this have on corporate taxes paid What effect would this have on taxis, paid by the companys shareholders? e. Assume that the firms after-tax cost of capital is 10 5%. What is the firms 2018 EVA? f. Assume that the firms stock price is S22 per share and that at year-end 2018 the firm has 10 million shares outstanding. What is the firms MVA at year-end 2018?
Financial statement analysis The financial statements for Nike, Inc., are presented in Appendix D at the end of the text. Use the following additional information (in thousands): Instructions 1. Determine the following measures for the fiscal years ended May 31, 2016, and May 31, 2015. Round ratios and percentages to one decimal place. a. Working capital b. Current ratio c. Quick ratio d. Accounts receivable turnover e. Number of days sales in receivables f. Inventory turnover g. Number of days sales in inventory h. Ratio of liabilities to stockholders equity i. Asset turnover j. Return on total assets. k. Return on common stockholders equity l. Price-earnings ratio, assuming that the market price was 54.90 per share on May 29, 2016, and 52.81 per share on May 30, 2015 m. Percentage relationship of net income to sales 2. What conclusions can be drawn from these analyses?
Income Statement for Year Ended December 31, 2018 (Millions of Dollars) Net sales 795.0 Cost of goods sold 660.0 Gross profit 135.0 Selling expenses 73.5 EBITDA 61.5 Depreciation expenses 12.0 Earnings before interest and taxes (EBIT) 49.5 Interest expenses 4.5 Earnings before taxes (EBT) 45.0 Taxes (40%) 18.0 Net income 27.0 a. Calculate the ratios you think would be useful in this analysis. b. Construct a DuPont equation, and compare the companys ratios to the industry average ratios. c. Do the balance-sheet accounts or the income statement figures seem to be primarily responsible for the low profits? d. Which specific accounts seem to be most out of line relative to other firms in the industry? e. If the firm had a pronounced seasonal sales pattern or if it grew rapidly during the year, how might that affect the validity of your ratio analysis? How might you correct for such potential problems?
Changes in current operating assets and liabilities-indirect method Alpenrose Corporations comparative balance sheet for current assets and liabilities was as follows: Dec. 31, 2016 Dec. 31, 2015 Accounts receivable 27,000 32,400 Inventory 18,000 15,480 Accounts payable 16,200 14,220 Dividends payable 49,500 53,100 Adjust net income of 207,000 for changes in operating assets and liabilities to arrive at net cash flow from operating activities.
Problem no 19, (Ref. 3) The following are the financial statements of Bagmati Bitumin Limited. Bagmati Bitumin Limited Balance Sheet as of December 31, 2016 and 2017 Assets 2016 2017 Liabilities and Equity 2016 2017 Cash Accounts receivable Inventory Rs 650 2,382 4,408 Rs 710 2,106 4,982 Accounts payable Notes payable Other Rs 987 640 90 Rs 1215 718 230 Total current assets Rs 7,440 Rs 7,798 Total current liabilities Long–term debt Rs 1,717 4,318 Rs 2,163 4,190 Fixed assets Rs 13,992 Rs 18,584 Total debt Rs 6,035 Rs 6,353 Owners’ equity (1,250 shares outstanding) Rs 15,397 Rs 20,029 Total assets Rs 21,432 Rs 26,382 Total liabilities and equity Rs 21,432 Rs 26,382 Bagmati Bitumin Limited Income Statement for the Year Ended December 31, 2017 Sales Cost of goods sold Depreciation Rs 28,000 11,600 2,140 Earnings before interest and taxes Interest paid Rs 14,260 980 Taxable income…
Just Dew It Corporation reports the following balance sheet information for 2017 and 2018. JUST DEW IT CORPORATION2017 and 2018 Balance SheetsAssetsLiabilities and Owners' Equity 20172018 20172018 Current assets Current liabilities Cash$ 10,400 $ 10,450 Accounts payable$ 72,250 $ 62,750 Accounts receivable28,000 27,200 Notes payable47,000 47,750 Inventory63,900 63,100 Total $ 119,250 $ 110,500 Total $ 102,300 $ 100,750 Long-term debt$ 63,000 $ 64,700 Owners' equity Common stock and paid-in surplus$ 83,000 $ 83,000 Fixed assets Retained earnings 157,050 190,550 Net plant and equipment$ 320,000 $ 348,000 Total$ 240,050 $ 273,550 Total assets $ 422,300 $ 448,750 Total liabilities and owners' equity $ 422,300 $ 448,750 Based on the balance sheets given for Just Dew It, calculate the following financial…
How do I determine the NNO for 2014? Dec. 31, 2016 Dec. 31, 2015 Dec. 31, 2014 Operating Assets 1,447,869 1,513,139 Operating liabilities 1,094,173 1,158,007 Net operating assets (NOA) 353,696 355,132 $ 397,299.00 NNO $ 490,548 $ 473,323 Equity $ 844,244 $ 828,455 $ 726,328.00 NOA= NNO + Equity $ 1,334,792 $ 1,301,778

Recommended textbooks for you

Cornerstones of Financial Accounting

Accounting

ISBN:

9781337690881

Author:

Jay Rich, Jeff Jones

Publisher:

Cengage Learning

Fundamentals of Financial Management (MindTap Cou…

Finance

ISBN:

9781337395250

Author:

Eugene F. Brigham, Joel F. Houston

Publisher:

Cengage Learning

Financial & Managerial Accounting

Accounting

ISBN:

9781285866307

Author:

Carl Warren, James M. Reeve, Jonathan Duchac

Publisher:

Cengage Learning

Cornerstones of Financial Accounting

Accounting

ISBN:

9781337690881

Author:

Jay Rich, Jeff Jones

Publisher:

Cengage Learning

Fundamentals of Financial Management (MindTap Cou…

Finance

ISBN:

9781337395250

Author:

Eugene F. Brigham, Joel F. Houston

Publisher:

Cengage Learning

Financial & Managerial Accounting

Accounting

ISBN:

9781285866307

Author:

Carl Warren, James M. Reeve, Jonathan Duchac

Publisher:

Cengage Learning

Financial Accounting

Accounting

ISBN:

9781337272124

Author:

Carl Warren, James M. Reeve, Jonathan Duchac

Publisher:

Cengage Learning

Accounting (Text Only)

Accounting

ISBN:

9781285743615

Author:

Carl Warren, James M. Reeve, Jonathan Duchac

Publisher:

Cengage Learning

College Accounting, Chapters 1-27 (New in Account…

Accounting

ISBN:

9781305666160

Author:

James A. Heintz, Robert W. Parry

Publisher:

Cengage Learning

SEE MORE TEXTBOOKS