a. Calculate Riverside's financial ratios for 2014. Assume that Riverside had $1,000,000 in lease payments and...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
a. Calculate Riverside's financial ratios for 2014. Assume that Riverside had $1,000,000 in lease payments and $1,400,000 in debt principal repayments in 2014. (Hint: Use the book discussion to identify the applicable ratios.) b. Interpret the ratios. Use both trend and comparative analyses. For the comparative analysis, assume that the industry average data presented in the book are valid for both 2014 and 2015. A B C D E F G H J K L 1 Particulars 2015 2014 Benchmark Particulars 2015 2014 Particulars 2015 2014 2 Total Margin 7.5% 2.3% Current Assets Gross Patient Service Revenue 1,06,502 95,398 3 Operating Margin 5.8% 0.4% 3.4% Cash and Cash Equivalents 2,263 3,095 Less Provision for Bad Debt -3,328 -3,469 4 Return on Assets 6% 2% 5% Short Investments 4,000 2,000 1,03,174 91,929 5 Return on Equity 8% 2% Net Patients Receivables 21,840 20,738 Premium Revenue 5,232 4,622 6 Days Cash on Hand 8.14 11.51 212.00 Inventories 3,177 2,982 Other Revenue 3,644 6,014 7 Debt Ratio 29% 34% 150% 31,280 28,815 1,12,050 1,02,565 8 Debt to Equity 28% 33% 200% Non Current Assets Expenses 9 Debt to Capitalisation 41% 50% 34% PPE 1,45,158 1,40,865 Nursing Services 58,285 56,752 10 Fixed Asset Turnover 93% 86% 150% Accumulated Depreciation -25,160 -21,030 Dietary Services 5,424 4,718 11 Total Asset Turnover 74% 69% 100% Net PPE 1,19,998 1,19,835 General Services 13,198 11,655 12 Days in Receivables 77 82 48 1,51,278 1,48,650 Admin 11,427 11,585 13 Average age of Plant 6.09 11.00 Current Liabilities Employee Health and Welfare 10,250 10,705 14 Accounts Payable 4,707 5,145 Malpractice 1,320 1,204 15 Particulars 2015 Accrued Expense 5,650 5,421 Depreciation 4,130 4,025 16 Operating Income 6,474 Notes Payable 2,975 6,237 Interest 1,542 1,521 17 Depreciation 4,130 13,332 16,803 1,05,576 1,02,165 18 WC Changes -1,506 Long Term Liabilities Operating Income 6,474 400 19 Operating Cash Flow 9,098 Long Term Debt 28,750 30,900 Non Operating Income 2,098 1,995 20 Capital Lease Obligations 1,832 2,155 Net Income 8,572 2,395 21 PPE -4,293 Net Assets 1,07,364 98,792 22 Short Investments -2,000 1,51,278 1,48,650 23 Investing Cash Flow -6,293 24 25 Non Operating Income 2,098 26 Repayment of Debt -2,150 27 Repayment of Notes -3,262 28 Repayment of Capital Lease -323 29 Financing Cash Flow -3,637 30 31 Net Change 32 Opening 33 Closing 34 -832 3,095 2,263 a. Calculate Riverside's financial ratios for 2014. Assume that Riverside had $1,000,000 in lease payments and $1,400,000 in debt principal repayments in 2014. (Hint: Use the book discussion to identify the applicable ratios.) b. Interpret the ratios. Use both trend and comparative analyses. For the comparative analysis, assume that the industry average data presented in the book are valid for both 2014 and 2015. A B C D E F G H J K L 1 Particulars 2015 2014 Benchmark Particulars 2015 2014 Particulars 2015 2014 2 Total Margin 7.5% 2.3% Current Assets Gross Patient Service Revenue 1,06,502 95,398 3 Operating Margin 5.8% 0.4% 3.4% Cash and Cash Equivalents 2,263 3,095 Less Provision for Bad Debt -3,328 -3,469 4 Return on Assets 6% 2% 5% Short Investments 4,000 2,000 1,03,174 91,929 5 Return on Equity 8% 2% Net Patients Receivables 21,840 20,738 Premium Revenue 5,232 4,622 6 Days Cash on Hand 8.14 11.51 212.00 Inventories 3,177 2,982 Other Revenue 3,644 6,014 7 Debt Ratio 29% 34% 150% 31,280 28,815 1,12,050 1,02,565 8 Debt to Equity 28% 33% 200% Non Current Assets Expenses 9 Debt to Capitalisation 41% 50% 34% PPE 1,45,158 1,40,865 Nursing Services 58,285 56,752 10 Fixed Asset Turnover 93% 86% 150% Accumulated Depreciation -25,160 -21,030 Dietary Services 5,424 4,718 11 Total Asset Turnover 74% 69% 100% Net PPE 1,19,998 1,19,835 General Services 13,198 11,655 12 Days in Receivables 77 82 48 1,51,278 1,48,650 Admin 11,427 11,585 13 Average age of Plant 6.09 11.00 Current Liabilities Employee Health and Welfare 10,250 10,705 14 Accounts Payable 4,707 5,145 Malpractice 1,320 1,204 15 Particulars 2015 Accrued Expense 5,650 5,421 Depreciation 4,130 4,025 16 Operating Income 6,474 Notes Payable 2,975 6,237 Interest 1,542 1,521 17 Depreciation 4,130 13,332 16,803 1,05,576 1,02,165 18 WC Changes -1,506 Long Term Liabilities Operating Income 6,474 400 19 Operating Cash Flow 9,098 Long Term Debt 28,750 30,900 Non Operating Income 2,098 1,995 20 Capital Lease Obligations 1,832 2,155 Net Income 8,572 2,395 21 PPE -4,293 Net Assets 1,07,364 98,792 22 Short Investments -2,000 1,51,278 1,48,650 23 Investing Cash Flow -6,293 24 25 Non Operating Income 2,098 26 Repayment of Debt -2,150 27 Repayment of Notes -3,262 28 Repayment of Capital Lease -323 29 Financing Cash Flow -3,637 30 31 Net Change 32 Opening 33 Closing 34 -832 3,095 2,263
Expert Answer:
Answer rating: 100% (QA)
a To calculate Riversides financial ratios for 2014 we need to use the provided data Here are the calculations for the given ratios Total Margin Total Margin Net Income Gross Patient Service Revenue T... View the full answer
Related Book For
Corporate Finance A Focused Approach
ISBN: 978-1133947530
5th edition
Authors: Michael C. Ehrhardt, Eugene F. Brigham
Posted Date:
Students also viewed these finance questions
-
Balanced Scorecard Data Setup- Format/Shell ACTION: To be completed with your Final Project as an Attachment And discussed within your paper and PPT. Balanced Scorecard Data Set Setup Balanced...
-
Riverside Memorials primary financial statements are presented in exhibits 17.1, 17.2, and 17.3. Calculate Riverside's financial ratios for 2019. Assume that Riverside had $1,000,000 in lease...
-
Park Ridge Homecare's financial statements are presented in Exhibits. we calculate selected ratios for 2008. a. Calculate the business's financial ratios for 2007. Assume that Park Ridge had $18,000...
-
Do you consider the Internet message boards that Anjali wishes to use to be public or private? How would you justify your answer? Anjali, was in her final year of study for an undergraduate business...
-
Explain relationships between common law and Romano-Germanic Civil Law.
-
The unadjusted trial balance of Clancy Inc., a private company following ASPE, at December 31, 2020, is as follows: Additional information: 1. Actual rent costs amounted to $1,500 per month. The...
-
Record entries for these transactions assuming the allowance method is used: Jan. 10 The $300 account of customer Cool Jam is determined uncollectible. April 12 Cool Jam unexpectedly pays in full the...
-
A random sample of size n = 50 is taken from a population with mean = - 9.5 and standard deviation =2. a. Calculate the expected value and the standard error for the sampling distribution of the...
-
A set has 10 outliers. If every value of this set is increased by 5 percent, how many outliers will there now be? (A) Fewer than 10 (B) 10 (C) 11 (D) More than 11 (E) It is impossible to determine...
-
?? Problems (4) to (8) below are based on Example Problem 13.4 Example Problem 13.4 FIGURE 13.41 System for Example Problem 13.4 80 ft Figure 13.41 shows a pumped fluid flow system that is being...
-
Potter Industries has a bond issue outstanding with an annual coupon of 6% and a 10-year maturity. The par value of the bond is $1,000. If the going annual interest rate is 7.6%, what is the value of...
-
Timberland got its name from the iconic yellow work boot introduced more than four decades ago. Nathan Swartz founded the company in South Boston as the Abington Shoe Company, and he set out to...
-
If you've ever wondered how much your boss or co-workers make, you would know if you worked at Whole Foods. While most companies keep salary information confidential, the Austin, Texasbased grocery...
-
Go online to research one of the following government agenciesits responsibilities, its budget, and mission. Then make the case for privatizing it: a. Veterans Administration b. Bureau of the Census...
-
Some businesses automatically experience seasonal unemployment. More and more, however, owners of these businesses are making efforts to increase demandand employmentduring the off season. Choose a...
-
With an anticipated population increase of 2 billion by 2050, global demand for food is increasing. Go online to conduct current research on supply and demand with regard to the agricultural market,...
-
Finance and Marketing will need to work very closely with Operations, to ensure the success of any business. Why do you think so?
-
Prove the formula for (d/dx)(cos-1x) by the same method as for (d/dx)(sin-1x).
-
The use of Torrens certificates, never large in the U.S., has diminished in recent years. Explain how marketable title laws, recently adopted in many states, might have made Torrens certificates less...
-
Why might it be advisable to require a survey in purchasing a 20-year-old home in an urban subdivision?
-
If a grantee obtains title insurance, what value, if any, is there in the covenant of seizen in a warranty deed?
-
Indirect on the Dollar. Calculate the forward premium on the dollar (the dollar is the home currency) if the spot rate is 1.3300/$ and the 3-month forward rate is 1.3400/$.
-
Around the Horn (A). Assuming the following quotes, calculate how a market trader at Citibank with $1,000,000 can make an intermarket arbitrage profit. Banks Spot Rates Citibank $1.6194/ National...
-
Direct on the Dollar. Calculate the forward discount on the dollar (the dollar is the home currency) if the spot rate is $1.5800/ and the 6-month forward rate is $1.5550/.
Study smarter with the SolutionInn App