Based on the financial statement of UNIVERSAL OFFICE FURNISHINGS INC. above,a) Prepare Two(2) financial ratios for each of Profitability, Liquidity, Efficiency/Activity andLeverage ratios. Show all workings.b) Provide your comment and analysis of the above ratios by comparing them for financialyear 2016 and 2015.c) Using the relevant Efficiency/Activity Ratios for the above, compute the Cash ConversionCycle (CCC) for UNIVERSAL OFFICE FURNISHINGS INC. for year 2016 and 2015. TABLE 7.3 CORPORATE BALANCE SHEETUniversal Office Furnishings, Inc. Comparative Balance Sheets December 31 ($ millions)2016AssetsCurrent assetsCash and equivalentsReceivablesInventoriesOther current assetsTotal current assetsNoncurent assetsProperty, plant, & equipment, grossAccumulated depreciationProperty, plant, & equipment, netOther noncurrent assetsTotal noncurrent assetsTotal assetsLlabilities and stockholders' equityCurrent liabilitiesAccounts payableShort-term debtOther current liabilitiesTotal current liabilitiesNoncurrent liabilitiesLong-term debtOther noncurrent liabilitiesTotal noncurrent liabilitiesTotal abilitiesStockholders' equityCommon sharesRetained earningsTotal stockholders' equityTotal llabilities and stockholders equitySales revenueCost of goods soldGross profitSelling, general, and administrative, and other operatingexpensesDepreciation & amortizationOther expensesTotal operating expensesEamings before Interest & taxes (EBIT)Interest expenseEarnings before taxesIncome taxesNet profit after taxes$ 95.8$227.2$103.7$ 73.6$500.3Dividends paid per shareEarnings per share (EPS)Number of common shares outstanding (in millions)$771.2($372.5)$398.7$ 42.2$440.9$941.2$114.2$174.3$ 85.5$374.0$1778$94.9$272.7$646.7$926$201.9$294.5$941.22016$1,938.0$1,128.5$ 809.6$ 496.7$$TABLE 7.4 CORPORATE INCOME STATEMENTUniversal Office Furnishings, Inc. Income Statements Fiscal Year Ended December 31 ($ millions)77.10.5$574.3$235.2ASS$ 13.4$ 221.882.1$$ 139.72015$ 0.15$2.2661.80$ 80.0$192.4$107.5$ 45.2$425.1$696.6($379.9)$316.7$ 19.7$336.4$761.5$ 82.4$ 79.3$89.6$251.3$190.9$110.2$301.1$552.4$137671.5$209.1$761.52015$1,766.2$1,034.5$ 731.7$ 419.5$ 62.1$ 12.9$ 494.5$ 237.2$ 7.3$ 229.9$ 88.1$ 141.8$$0.132.1765.30

Ratio Analysis - This is an analysis done in terms of an entity's financial statements. Such…

Based on the financial statement of UNIVERSAL OFFICE FURNISHINGS INC. above, a) Prepare Two(2) financial ratios for each of Profitability, Liquidity, Efficiency/Activity and Leverage ratios. Show all workings. b) Provide your comment and analysis of the above ratios by comparing them for financial year 2016 and 2015. c) Using the relevant Efficiency/Activity Ratios for the above, compute the Cash Conversion Cycle (CCC) for UNIVERSAL OFFICE FURNISHINGS INC. for year 2016 and 2015.

Based on the financial statement of UNIVERSAL OFFICE FURNISHINGS INC. above, a) Prepare Two(2) financial ratios for each of Profitability, Liquidity, Efficiency/Activity and Leverage ratios. Show all workings. b) Provide your comment and analysis of the above ratios by comparing them for financial year 2016 and 2015. c) Using the relevant Efficiency/Activity Ratios for the above, compute the Cash Conversion Cycle (CCC) for UNIVERSAL OFFICE FURNISHINGS INC. for year 2016 and 2015.

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

1. Calculate the cash operating cycle of Stone Limited for the year ended 30 April, 2018 and 2019.2. Calculate the comparative ratios for Stone limited for the year ended 30 April 2019. (to two decimal places where appropriate).3. Based on the result of the previous year end and the industry average. Draft a report addressed to the Board of Directors of Stone Limited analysing the performance of the company for the year 2019
1. Solve the following ratios from year 2018-2020. Show complete solutions/computations. -CURRENT RATIO -QUICK RATIO -OPERATING MARGIN -PROFIT MARGIN - RETURN ON TOTAL ASSETS (ROA) - BASIC EARNINGS POWER -RETURN ON EQUITY (ROE) -INVENTORY TURNOVER RATIO -DAYS SALES OUTSTANDING -FIXED ASSETS TURNOVER -TOTAL ASSETS TURNOVER -INVENTORY CONVERSION PERIOD -TOTAL DEBT TO TOTAL ASSETS -TOTAL DEBT TO TOTAL CAPITAL -TIMES-INTEREST-EARNED RATIO -EARNINGS PER SHARE -PRICE EARNINGS RATIO -MARKET BOOK VALUE RATIO
Using the fiscal year end 2019 annual report for General Mills, Inc. and the figures from the 2017 annual report as noted below, calculate the financial ratios for 2019 and 2018 indicated using the EXCEL template provided: Gross profit percentage Return on sales Asset turnover Return on assets Return on common stockholders’ equity Current ratio Quick ratio Operating-cash-flow-to-current-liabilities ratio Accounts receivable turnover Average collection period Inventory turnover Days’ sales in inventory Debt-to-equity ratio Times-interest-earned ratio Operating-cash-flow-to-capital-expenditures ratio Earnings per share Price-earnings ratio Dividend yield Dividend payout ratio Total assets 2017 = $21,812.6 Total stockholders’ equity 2017 = $4,327.9 Total current liabilities 2017 = $5,330.8 Accounts receivable 2017 = $1,430.1 Inventory 2017 = $1,483.6 Year-end closing stock price May 2019 = $50.93 Year-end closing stock price May 2018 = $39.37 Perform a comparative analysis of the…
A Comparison of Firm Performance 1 2 2013 Financials 3 Net operating revenues 4 Cost of goods sold 5 Gross profit 6 Selling, general, and administrative expense 7 Other costs 8 Operating income 9 Interest expense 10 Other income (loss) - net 11 Income before income taxes 12 Income taxes 13 Net income 14 Assets 15 Cash and cash equivalents 16 Net receivables 17 Inventories 18 Prepaid expenses and other 19 Total current assets 20 Property, plant and equipment 21 Goodwill 22 Other assets 23 Total assets 24 Liabilities and Stockholder Equity 25 Accounts payable 26 Short-term debt 27 Total current liability 28 Long-term debt 29 Other liabilities 30 Total liabilities 31 Stockholder equity 32 B Walmart 469,162 352,488 116,674 88,873 27,801 2,251 187 25,737 7,981 17,756 7,781 6,768 43,803 1,588 59,940 116,681 20,497 5,987 203,105 59,099 12,719 71,818 41,417 113,235 89,870 C Macy's 27,931 16,725 11,206 8,440 88 2,678 388 (134) 2,156 767 1,389 1,836 371 5,308 361 7,876 8,196 3,743 1,176 20,991…
The DuPont equation shows the relationships among asset management, debt management, and -Select- ROE = Profit margin x Total assets turnover x Equity multiplier Ratio analysis is important to understand and interpret financial statements; however, sound financial analysis involves more than just calculating and interpreting numbers. -Select- Quantitative Problem: Rosnan Industries' 2019 and 2018 balance sheets and income statements are shown below. Balance Sheets: Cash and equivalents Accounts receivable Inventories Total current assets Net plant and equipment Total assets Accounts payable Accruals Notes payable Total current liabilities Long-term debt Common stock Retained earnings Total liabilities and equity Sales Operating costs excluding depreciation EBITDA Depreciation and amortization EBIT Interest EBT Taxes (25%) Net income Income Statements: Dividends paid Addition to retained earnings Shares outstanding Price WACC 2019 $100 Ś 85 275 300 375 350 750 $ 735 2,000 1,490 $2,750…
VII. Direction: Compute and interpret. The following comparative financial statements are provided by Avatar Industries. You were asked to compute the different financial ratios and provide your interpretations with regards to profitability, efficiency, liquidity and solvency of the company. Use the Answer Sheet template below to input your answer and solution. AVATAR INDUSTRIES AVATAR INDUSTRIES Comparative Statement of Financial Position For the years 2019 and 2018 Comparative Income Statement For the years 2019 and 2018 2019 2018 2019 2018 ASSETS Current Assets: Sales P200,000 P210,000 Cash & Cash Equivalent P65,000 P70,000 Sales Returns and Allowances 40,000 25,000 Accounts Receivable 40,000 35,000 Net Sales 160,000 185,000 Marketable Secuities 40,000 35,000 Cost of Goods Sold 100,000 115,625 Inventory 100,000 80,000 Gross Profit 60,000 69,375 Total Current Assets 220,000 200,000 160,000 P445,000 P380,000 245,000 Operating Expenses: Fixed Assets Selling Expenses 22,000 25,000 Total…
Calculate the following ratios for F. Raser for the year ended 31 May 2016. State clearly the formulae used for each ratio. Return on capital employed Gross profit percentage Net profit percentage Quick/Acid test ratio Receivables collection period Earnings per share Using the additional information given and the ratios you calculated in part (a), write a brief report on the financial performance of F. Raser. Indicate in your report what additional information might be useful to help interpret the ratios. © List two factors F. Raser should consider in deciding whether to raise finance by issuing loan notes rather than issuing shares
Use Table 1 and the following information on Company X to perform a pro-forma financial modeling using a percentage sales method, and answers the next questions. Note: When applying the percentage sales method, you should assume that the 2024 percentage values with respect to sales of the (i) costs except depreciation, (ii) depreciation, (iii) cash and equivalents, (iv) accounts receivable, (v) inventories, (vi) property, plant and equipment, and (vi) accounts payable will remain equal to those percentages of 2023. Sales in 2024 are expected to grow at a rate of 20%, with respect to the values of 2023. Assume also that the total values in 2024 of interest expense and debt will not change from its 2023 values; income tax will remain at 30% of the Pretax Income; and that Company X initially plans to payout 35% of its net income to its shareholders. 1. What is the forecasted value of sales for 2024? 2. What is the forecasted value of EBITDA for 2024? 3. What is the forecasted value of…
Please donot provide solution in image format provide solution in step by step format and fast solution Using the information from Part I, comment on the following financial elements of Target Corporation:
The image uploaded is the calculation of Cal Bank's Profitability ratios, shorter liquidity ratios, long-term liquidity ratios, and investment ratios for 2020, 2021, 2022. A base year of 2019 was also added. Evaluate the financial performance by comparing the three (3) years' financial performance that is 2020, 2021, and 2022 I have provided in the table with the base year.
You are provided with the Income Statement and the Balance Sheet of HTS software, Inc. for 2011.Required: (a) Calculate the ratios stated in the table below for HTS Software, Inc. for 2011 (b) Analyze the current financial position for the company from a time series and cross section viewpoint. (c) Break your analysis into an evaluation of the firm’s liquidity, activity, debt, profitability and market ratios.