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.

Survey of Accounting (Accounting I)

8th Edition

ISBN:9781305961883

Author:Carl Warren

Publisher:Carl Warren

Chapter15: Capital Investment Analysis

Section: Chapter Questions

Problem 15.5.1MBA

See similar textbooks

Similar questions

Computing Asset Ratios The following information relates to Nicke Inc. Total Fixed Total Net $ millions Assets Assets Revenue Income Fiscal Year 2016 $10,560 $64,188 $97,128 $11,280 Fiscal Year 2015 28,002 200,852 91,803 9,819 Fiscal Year 2014 8,502 55,782 Nicke's fiscal years 2016, 2015, and 2014, end on May 31, 2016, 2015, and 2014, respectively. Required a. Compute the asset turnover ratio for fiscal years 2016 and 2015. b. Compute the return on assets ratio for fiscal years 2016 and 2015. c. Compute the fixed asset turnover ratio for fiscal years 2016 and 2015. Note: Do not round until your final answers. Round final answers to two decimal places. Ratio 2016 2015 a. Asset turnover 0.73 v 0.72 v b. Return on assets 8.53 x 7.65 x c. Fixed asset turnover 5.04 v 5.03 v
Current Asset Current Liabilities COGS Inventory Total Liabilities Total Assets Net Sales Operating Income Gross Profit EBIT EBT Cash Flow Operation Retained Earning Owner's Equity 2018 80,073,836 26,882,064 51,678,144 14,854,944 80,133,248 124,776,768 160,099,728 75,249,200 108,421,584 56,436,900 45,149,520 49,716,192 28,967,893 44,643,520 2017 54,919,520 13,083,840 35,379,840 9,575,808 64,875,200 100,945,824 98,157,888 32,775,808 62,778,048 24,581,856 19,665,485 26,781,248 29,361,440 36,070,624
PE.17-09B - Return on total assets A company reports the following income statement and balance sheet information for the current year: Net income Interest expense Average total assets $410,000 90,000 5,000,000 Determine the return on total assets. I %
3: Chapter 03 Eukalayle Corporation's financial statements are provided here. Balance Sheet as of December 31, Cash and equivalents Accounts Receivable Inventories Net Plant and Equipment Total Assets Accounts Payable Notes Payable Accruals Long-Term Bonds Common Stock Retained Earnings Total Liabilities & Equity Income Statement as of December 31 Net Sales Operating Costs excluding depreciation and amortization Depreciation and Amortization Interest Taxes 40% Net Income WACC What was 2014 FCF? 2014 2013 40,000 48,000 80,000 80,000 60,000 38,400 220,000 153,600 400,000 320,000 2014 2013 20,000 19,200 28,000 9,600 12,000 22,400 104,000 76,800 165,200 134,400 70,800 57,600 400,000 320,000 2014 300,000.0 30,000.0 15,000.0 22,500.0 93,000.0 139,500.0 30.00%
Computing Asset Ratios The following information relates to Mazy's Inc. $ millions Total Assets Revenue Net Income Fiscal Year 2015 $47,325 $62,282 $2,461 Fiscal Year 2014 46,926 Mazy's fiscal years for 2015 and 2014 end on January 30, 2016, and January 31, 2015, respectively. Note: Carry all decimals in calculations; enter the answers rounded to two digits after the decimal; for example, enter 1.42 for 1.424, or 1.43 for 1.425. a. Compute the asset turnover ratio for fiscal year 2015. Answer b. Compute the return on assets ratio for fiscal year 2015. Answer
HCS/380: Week 4 - Horizontal and Vertical Analysis - Academic Resources HCS/380 Ratio Calculations Select the images below to enlarge. Balance Sheet Murawski Company Balance Sheet December 31 Current Assets Investments Cash and cash equivalents Accounts receivable (net) Property, plant, and equipment Intangibles and other assets Total assets Current liabilities Inventory Prepaid expenses Total current assets Sales Revenue Murawski Company Income Statement For the Years Ended December 31 Costs and expenses Cost of goods sold Selling and Administrative expenses Interest expense Total costs and expenses 2022 Income Statement Income before income taxes $330 470 460 120 1,380 Income tax expense Net Income 10 420 530 $2,340 Long-term liabilities Stockholder's equity - common 1,030 1,040 Total liabilities and stockholder's equity $2,340 $2,210 $900 410 2022 $3,800 955 2,400 25 3,380 2021 420 126 $294 $360 400 390 160 1,310 10 380 510 $2,210 $790 380 2021 $3,460 890 2,330 20 3,240 220 66 $154…
Pot Inc. acquired all Seed Inc.'s outstanding $27 par common stock on December 31, 20X3, in exchange for 41,000 shares of its $27 par common stock. Pot's common stock closed at $58.50 per share on a national stock exchange on December 31, 20X3. Both corporations continued to operate as separate businesses maintaining separate accounting records with years ending December 31. On December 31, 20X4, after year-end adjustments and the closing of nominal accounts, the companies had condensed balance sheet accounts. Assets Cash Accounts & Other Receivables Inventories Land Depreciable Assets (net) Investment in Seed Inc. Long-Term Investments & Other Assets Total Assets Liabilities and Stockholders' Equity Accounts Payable and Other Current Liabilities. Long-Term Debt Common Stock, $27 Par Value Additional Paid-In Capital Retained Earnings Total liahilities and Stockholders' Fruity Additional Information Common Stock Additional Paid-In Capital Retained Earnings Pot Inc. $830,000 $331,000…
Analyze, Forecast, and Interpret Income Statement and Balance SheetFollowing are the income statement and balance sheet of ADP Inc. DATA PROCESSING INC. Statement of Consolidated Earnings For Year Ended June 30, 2019, $ millions Total revenues $8,505.1 Operating expenses 4,287.5 Systems development and programming costs 381.8 Depreciation and amortization 182.6 Total cost of revenues 4,851.9 Selling, general, and administrative expenses 1,838.5 Interest expense 77.9 Total expenses 6,768.3 Other (income) expense, net (66.7) Earnings before income taxes 1,803.5 Provision for income taxes 427.7 Net earnings $1,375.8 DATA PROCESSING INC. Balance Sheet $ millions June 30, 2019 Current assets Cash and cash equivalents $1,169.5 Accounts receivable, net 1,463.6 Other current assets 311.8 Total current assets before funds held for clients 2,944.9 Funds half for clients 17,660.5 Total current assets 20,605.4 Long-term receivables,…
Assets Fixed assets: Property, plant and equipment (net) Total fixed assets Current assets: Inventory Accounts Receivable (net) Cash and cash equivalents Total current assets Total assets 20X3 1,687,500 1,125,000 862,200 353,400 121,800 1.337,400 2.462.400 ABC Corporation Comparative Balance Sheets in € December 31, 20X3 and 20X2 Liabilities Stockholders' Equity Stockholders' equity: Common stock 10 par value 20X2 1,080,000 1,080.000 892,200 343,800 61,200 1,297,200 2.377.200 Net Capital Expenditures Dividends Paid Common shares Outstanding Stock Price Retained earnings Total equity Long-term liabilities: stockholders' Bonds payable Total long-term liabilities Current liabilities: & Notes payable Accounts payable Total current liabilities Total liabilities Total liabilities stockholders' equity 20X3 60,000 66,000 60,000 27 20X3 600,000 561.000 1,161,000 600.000 20X2 97,500 51,000 60,000 45 600,000 300,000 401,400 701,400 1,301,400 2,462,400 20X2 600,000 461,400 1,061,400 600,000…
Return on Total Assets A company reports the following income statement and balance. sheet information for the current year: Net income Interest expense Average total assets $471,500 83,200 6,450,000 Determine the return on total assets. If required, round the answer to one decimal place. %
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 Sin Comparative Income Statements For Years Ended December 31 2021 $ 420,027 252,856 167,171 59,644 37,802 97,446 69,725 12,969 $ 56,756 Liabilities and Equity Current liabilities Common stock Other paid-in capital Retained earnings Total liabilities and equity Assets Current assets Long-term investments Plant assets, net. Total assets Liabilities and Equity Current liabaties Common stock Other paid-in capital Retained earnings Total liabilities and equity 2020 $ 321,775 202,718 KORBIN COMPANY Comparative Balance Sheets December 31 2021 119,057 44,405 28,316 72,721 46,336 9,499 $ 36,837 $ 55,286 0 102,674 $ 157,960 2020 3. Complete the below table to calculate the balance sheet data in trend percents with 2019 as answers to 2 decimal places.) 111.77 % 0.00 $ 37,003 700…
perience p....pptm ^ Type here to search w X # 3 E Coronado Company's condensed financial statements provide the following information. C Cash Accounts receivable (net) Short-term investments Inventory Prepaid expenses Total current assets Property, plant, and equipment (net) Total assets Current liabilities ACC341-2022-Ho....xlsx $ 4 Bonds payable R F % 5 O CORONADO COMPANY BALANCE SHEET T At O+ 6 V B ▶ music 2.jpeg n H & 7 Dec. 31, 2020 $52,100 197,700 80,800 442,700 3,000 $776,300 849,900 $1,626,200 237,700 401,800 U 20 8 J Dec. 31, 2019 $60,200 O 80,800 39,600 N M 360,200 $547,700 849,900 $1,397,600 6,900 155,700 ( 401,800 9 W K F11 ) O 0 888 P Home End C Rair Inse