Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please can someone help Me this question Please show the formula and the answe. Park Ridge Homecare Statement of Income Year Ended December 31, 2015

Please can someone help Me this question
Please show the formula and the answe.
image text in transcribed
image text in transcribed
image text in transcribed
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 Depreciation 649 15 Total Operating Expenses Operating Income 684 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) Calculate the following Ratios below and compare with the ratio in 2016 and the Industry 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 a. Total (profit) Margin in 2015 Total (profit) Margin in 2016 Industry Average 40% 5.9% b. Operating Margin in 2015 3.2% 5.6% Operating Margin in 2016 Industry Average c. Return on Assets (ROA) in 2015 Industry Average d. Return on Equity (ROE) in 2015 Industry Average 13.4% 12.7% Return on Assets (ROA) in 2016 34.1% 36.5% Return on Equity (ROE) in 2016 e. Current Ratio in 2015 Current Ratio in 2016 Industry Average 1.9 days 24.7 days 22.6 days f. Days Cash on Hand in 2015 Days Cash on Hand in 2016 Industry Average h. Debt Ratio in 2015 Debt Ratio in 2016 Industry Average 60.8% 63.9% i. Debt to Capitalization Ratio in 2015 Debt to Capitalization Ratio in 2016 Industry Average 24.4% 31.2% j. Times Interest Earned (TIE) Ratio in 2015 Times Interest Earned (TIE) Ratio in 2016 Industry Average times 13.3 times 10.4 times times 50.4 times 63.1 times k. Fixed Asset Turnover Ratio in 2015 Fixed Asset Turnover Ratio in 2016 Industry Average times 3.3 times 3.4 times I. Total Asset Turnover Ratio in 2015 Total Asset Turnover Ratio in 2016 Industry Average days 66.5 days 37.1 days m. Days in Accounts Receivable in 2015 Days in Accounts Receivable in 2016 Industry Average Interpret at least three Ratios by comparing the ratios in 2015, 2016 and the industry average. Is Park Ridge Homecare profitable? What areas should management be concerned about? Explain your

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Currency Wars Offense And Defense Through Systemic Thinking

Authors: Jeffrey Yi-Lin Forrest , Yirong Ying , Zaiwu Gong

1st Edition

3319677640,3319677659

More Books

Students also viewed these Finance questions