Exceptional Service Grading Company Expansion Analysis XLS

Diane's balance sheets as of December 31, 2016 and 2017 are presented below: 2016 310,000 300,000 0 2017 $443,456 430,000 100,000 17,356) 950,000 ( 318.100) $1.588.000 Cash Accounts receivable, net Long-term notes receivable Discount on long-term notes receivable Property, plant, and equipment at cost Accumulated depreciation 0) 750,000 325,000) $1035.000 TOTAL ASSETS 230,000 220,000 25,000 60,000 200,000 300,000 $1035.000 $175,000 310,000 15,000 110,000 315,000 663,000 $1.588.000 Accrued liabilities Unearned revenues Short-term debt Common stock, $1 par value Additional paid-in-capital Retained earnings TOTAL LIABILITIES & SE Diane's 2017 income statement is presented below: Service revenues Other revenues and gains/losses, net Selling, general, and administrative expenses Interest expense $1,800,000 1,987 1,209,000 1,000 588,013 125,013 463.000 Income before income taxes Income tax expense Net income SELECTED OTHER INFORMATION: 1 On January 1,2017, Diane provided services to a…

How to calculate Net Operating Asset from this balance sheet for fiscal year-end 2015 .

Balance Sheets At December 31 2018 2017 2018 2017 Liabilities: Accounts payable 29,400 Income taxes payable 61,710 Bonds payable 56,400Total liabilities Assets: Cash Accounts receivable Merchandise inventory Long-term investments Equipment Acc. depreciation Total assets $ 24,640 $ 23,040 32,180 73,125 55,900 175,500 145,500Equity: (33,550) (31.200) Common stock $327.795 $284.850 APIC $65,000 $ 40,380 10,725 10,200 48.750 66.000 $124,475 $116,580 96,000 9,000 63.270 $203.320 $168.270 Total liabilities and equity $327.795 $284.850 117,000 13,000 73,320 Retained earnings Total equity Eddy Inc. Income Statement For Year Ended December 31, 2018 $240,000 Sales Cost of goods sold Depreciation expense Other operating expenses Interest expense Other gains (losses): Loss on sale of equipment $80,900 29,400 48,000 2,000 (160,300) (8,400) 71,300 27,650 $ 43.650 Income before taxes Income taxes expense Net income

Use the current asset section of the balance sheets of the Waverley Company as of June 30, 2017 and 2016 presented below to answer the questions that follow.                                                               2017                                 2016Cash and cash equivalents                R 75,000                             R 58,800Trade accounts receivable, net          157,500                              193,200Inventory                                           208,200                              253,400Other current assets                         18,400                                 15,500Total current assets                           R 459,100                            R 520,900Total assets                                        R2,650,000                          R3,430,000Required:Complete a horizontal analysis of the current asset section of Waverley Company’s balance sheet for 2017. Your answers for “% Change” should be rounded to one decimal place, e.g.,…

Only typed solution

Quantitative Problem: Rosnan Industries' 2018 and 2017 balance sheets and income statements are shown below. Balance Sheets: Assets Cash and equivalents Accounts receivable Inventories Total current assets Net plant and equipment Total assets Liabilities and Equity Accounts payable Accruals Notes payable Total current liabilities Long-term debt Total liabilities Common stock Retained earnings Total comment 2018 $100 275 175 $750 2,300 $3,050 $150 75 150 $375 450 $825 1,225 1,000 #7:375 2017 $85 300 250 $635 1,490 $2,125 $85 50 75 $210 290 $500 1,225 400 41.61

Please input numbers in boxes below based on data provided for year 2018. Current assets - current liabilities = net working capital

Given the data in the following table, accounts receivable in 2023 was…

Baghiben

Please input numbers below based on data provided for the year 2017

Quantitative Problem: Rosnan Industries' 2018 and 2017 balance sheets and income statements are shown below. Balance Sheets:   2018 2017 Cash and equivalents $70   $55   Accounts receivable 275   300   Inventories 375   350         Total current assets $720   $705   Net plant and equipment 2,000   1,490   Total assets $2,720   $2,195         Accounts payable $150   $85   Accruals 75   50   Notes payable 120   145         Total current liabilities $345   $280   Long-term debt 450   290   Common stock 1,225   1,225   Retained earnings 700   400   Total liabilities and equity $2,720   $2,195   Income Statements:   2018 2017 Sales $2,000   $1,500   Operating costs excluding depreciation 1,250   1,000   EBITDA $750   $500   Depreciation and amortization 100   75   EBIT $650   $425   Interest 62   45   EBT $588   $380   Taxes (40%) 235   152   Net income $353   $228         Dividends paid $53   $48   Addition to retained…

Find return on financial leverage and return of financial leverage ratio for years 2017, 2018, and 2019.

M7Q1 Redo

Calculate Debt/(Debt + Equity) and Liabilities/Assets for Dec 2018 and 2019.    Dec 31 2018   Dec-31-2019  Debt / (Debt + Equity)     Liabilities / Assets

Carla Vista Co. has these comparative balance sheet data: CARLA VISTA CO.Balance SheetsDecember 31     2022   2021 Cash   $ 16,140   $ 32,280 Accounts receivable (net)   75,320   64,560 Inventory   64,560   53,800 Plant assets (net)   215,200   193,680     $371,220   $344,320 Accounts payable   $ 53,800   $ 64,560 Mortgage payable (15%)   107,600   107,600 Common stock, $10 par   150,640   129,120 Retained earnings   59,180   43,040     $371,220   $344,320 Additional information for 2022: 1.   Net income was $32,500. 2.   Sales on account were $392,900. Sales returns and allowances amounted to $27,300. 3.   Cost of goods sold was $217,300. 4.   Net cash provided by operating activities was $57,200. 5.   Capital expenditures were $30,000, and cash dividends were $19,000. Compute the following ratios at December 31, 2022. (Round current ratio and inventory turnover to 2 decimal…

Table 1: Revenue and expense information for the year 2017 and balance sheet items at 31 December 2017 Cash Net fixed assets Interest paid Creditors Debtors Accumulated retained profit - end of 2017 Costs of goods sold Sales revenue Short-term loans Overdraft balance Expenses Share capital Dividends paid Long-term liabilities Stock of toy parts $1000 $27000 $250 $4000 $3500 $10000 $7500 $27250 $1500 $2000 $7000 $13500 $2500 $5000 $4500

Calculate Debt Ratios and Debt to Equity Ratio for 2016

Assets Current assets Net fixed assets INCOME STATEMENT, 2022 (Figures in $ millions) Revenue Cost of goods sold Depreciation Interest expense 2021 $ 101 2022 $ 195 910 1,010 $ 2,005 1,085 405 251 Req A and B Req C and D BALANCE SHEET AT END OF YEAR (Figures in $ millions) Liabilities and Shareholders' Equity Current liabilities Long-term debt Req E Complete this question by entering your answers in the tabs below. a&b. What is shareholders' equity in 2021 and 2022? c&d. What is net working capital in 2021 and 2022? e. What are taxes paid in 2022? Assume the firm pays taxes equal to 21% of taxable income. f. What is cash provided by operations during 2022? g.Net fixed assets increased from $910 million to $1,010 million during 2022. What must have been South Sea's gross investment in fixed assets during 2022? Answer is complete but not entirely correct. h. If South Sea reduced its outstanding accounts payable by $46 million during the year, what must have happened to its other current…

Seminole Corporation reported the following items at December 31, 2021, and 2020: (Click the icon to view the comparative financial information.) Read the requirements. Requirement 1. Compute the company's (a) quick (acid-test) ratio and (b) days' sales outstanding for 2021. Evaluate each ratio value as strong or weak. All sales are on account with terms of net 30 days. (a) Enter the formula and calculate the quick (acid-test) ratio for 2021. (Abbreviation used: Cash* = Cash and cash equivalents. Round your final answer to two decimal places.) Cash* + Short-term investments + Net current receivables + Total current liabilities = Quick (acid-test) ratio $ Seminole's quick (acid-test) ratio is considered fairly weak. (b) Select the formula and calculate Seminole's days' sales outstanding for 2021. (Round interim calculations to two decimal places, XX.XX. Round the days' sales outstanding up to the next whole day.) Accounts receivable turnover = + Days' sales outstanding Seminole's days'…

Find current ratio for years 2017, 2018, and 2019.

All the figures are in millions.  Please calculate: debt ratio and times interest earned ratio Please written down the formulas used and use excel.   BKW Current Asset Current Liabilities Total Liabilities Total Assets 2016 344,168 145,498 678,726 2,517,211 2017 356,979 160,215 752,063 2,719,903 2018 368,473 177,655 804,059 2,875,137 2019 495,024 261,798 925,626 3,092,984 2020 637,416 232,882 1,428,922 3,832,933 2021 579,863 268,282 1,546,085 4,025,832 BKW Net Cash Provided by operating activities Operating Income Before Tax Finance Costs   Cash and cash eqiv & Accounts receivables 2016 148,507 121,756 - 14,080   19,641 + 133,225 2017 115,422 256,583 - 12,436 19,641 + 133,225 2018 170,948 244,453 - 14,456 21,167 + 122,216 2019 123,080 314,475                                 - 23,883 74,881 + 133,319 2020 75,259 417,117 -…

Calculate the following ratios  from the income statement and balance sheet all are required 1:Current ratio 2--:Quick Ratio 3-Cash Ratio 4 Receivable Turnover Ratio (RTR)  5:Inventory Turnover Ratio (ITR) Statement of financial positionas at 31 December 2018       2018 2017   Note   RO     RO ASSETS             Non-current assets             Property, plant and equipment 14 8,407,572 9,300,442 Deferred tax assets 12 40,977 18,550                   8,448,549 9,318,992 Current assets             Inventories 15 430,885 422,421 Trade and other receivables 16 1,129,440 1,235,724 Due from related parties 24 70,300 73,050 Cash and bank balances 17 6,856,734 6,439,709             Total current assets   8,487,359 8,170,904           Total assets   16,935,908 17,489,896 EQUITY…

Sandhill Co. has these comparative balance sheet data: SANDHILL CO.Balance SheetsDecember 31     2020   2019 Cash   $ 29,205   $ 58,410 Accounts receivable (net)   136,290   116,820 Inventory   116,820   97,350 Plant assets (net)   389,400   350,460     $671,715   $623,040 Accounts payable   $ 97,350   $ 116,820 Mortgage payable (15%)   194,700   194,700 Common stock, $10 par   272,580   233,640 Retained earnings   107,085   77,880     $671,715   $623,040 Additional information for 2020: 1.   Net income was $34,900. 2.   Sales on account were $378,200. Sales returns and allowances amounted to $29,600. 3.   Cost of goods sold was $204,700. 4.   Net cash provided by operating activities was $57,300. 5.   Capital expenditures were $28,200, and cash dividends were $13,800. Compute the following ratios at December 31, 2020. (Round current ratio and inventory turnover to 2 decimal places, e.g. 1.83…

Sandhill Co. has these comparative balance sheet data: SANDHILL CO.Balance SheetsDecember 31     2020   2019 Cash   $ 29,205   $ 58,410 Accounts receivable (net)   136,290   116,820 Inventory   116,820   97,350 Plant assets (net)   389,400   350,460     $671,715   $623,040 Accounts payable   $ 97,350   $ 116,820 Mortgage payable (15%)   194,700   194,700 Common stock, $10 par   272,580   233,640 Retained earnings   107,085   77,880     $671,715   $623,040 Additional information for 2020: 1.   Net income was $34,900. 2.   Sales on account were $378,200. Sales returns and allowances amounted to $29,600. 3.   Cost of goods sold was $204,700. 4.   Net cash provided by operating activities was $57,300. 5.   Capital expenditures were $28,200, and cash dividends were $13,800. Only the first 3 were answered the last time, I need all of these answered now.  Compute the following ratios at December 31,…

Calculate Debt-to-equity Times interest earned Return on Financial leverage

answer quickly

Calculate following ratios  If you are not able to calculate with the given the information shown, indicate what is missing.  After calculating each ratio indicate whether the trend from 2017 to 2018 is good or bad and why.     Year 2018 Year 2017 Net Profit Margin     Total Asset turnover     Debt to Tangible Net Worth Ratio     Operating Cash Flow / Total Debt