1. Business
  2. Operations Management
  3. please i just need anyone to answer the e f...

Question: please i just need anyone to answer the e f...

Question details
Please I just need anyone to answer the
E, f, h, I, j please with the formula answer
Park Ridge Homecares financial statements are presented in exhibits 13.1, 13.2, and 13.3 in the textbook. In Chapter 13, selected ratios were calculated for 2016. Park Ridges Homecares Statement of Income and Balance Sheet for 2015 are reproduced below. a. Calculate the businesss financial ratios for 2015. Assume that Park Ridge had $18,000 in lease payments in 2015. b. Interpret the ratios. For the analysis, assume that the sector average data presented in the ratio anaysis section are valid for 2015 Park Ridge Homecare Balance Sheet December 31, 2015 (in Thousands) ASSETS Current Assets Cash and cash equivalents Short-term Investments Accounts Receivable, net Inventories 67 137 476 Total Current Assets Investments Property and Equipment 702 100 Medical and office equipment Vehicles 54 47 101 -24 Total Less: Accumulated Depreciation Net Property and Equipment or Net Fixed Asset TOTAL ASSETS 879 LIABILITIES AND EQUITY Current Liabilities Notes Payable Accounts Payable Accrued Expenses 13 21 363 Total Current Liabilities 397 167 564 Long-term Debt Total Liabilities Equity TOTAL LIABILITIES AND EQUITY 879

Park Ridge Homecare Statement of Income Year Ended December 31, 2015 (in Thousands) Net Service Revenues Cost of Service Revenues 2666 1944 Gross Profit 722 General and Administrative Expenses 649 15 Total Operating Expenses Operating Income 664 58 Interest Income Interest Expense 86 19 Total Interest Income, net Income Before Income Taxes 67 125 26 Income Tax Expense Net Income (Excess of Revenues over Expenses) Calculat average. Insert Excel formula in the cells. Make sure you put the parenthesis in the formula to specify the order of operations to be done by the Excel formula te the following Ratios below and compare with the ratio in 2016 and the Industry a. Total (profit) Margin in 2015 Total (profit) Margin in 2016 Industry Average 40% 5.9% b. Operating Margin in 2015 Operating Margin in 2016 Industry Average 3.2% 5.6% c. Return on Assets (ROA) in 2015 Return on Assets (ROA) in 2016 Industry Average 13.4% 12.7% d. Return on Equity (ROE) in 2015 Return on Equity (ROE) in 2016 Industry Average 34.1% 36.5% e. Current Ratio in 2015 Current Ratio in 2016 Industry Average 1.7 1.9 f. Days Cash on Hand in 2015 Days Cash on Hand in 2016 Industry Average 24.7 days 22.6 days
Solution by an expert tutor
Blurred Solution
This question has been solved
Subscribe to see this solution