Assignment: Analyze Organizational Financial Data
You are an administrator at Arizona Health Services (AHS), a large hospital system. You have been asked to assist in evaluating the financial feasibility of purchasing Jiranna Healthcare, a managed care organization in the San Jose area. For this part of the Performance Task, you will conduct a 5-year analysis of Jiranna Healthcare's operational and financial data in order to determine whether or not it is an attractive acquisition. Refer to "Jiranna Finances" for financial statements to analyze.
Prepare a 2 to 3 pages financial analysis. The focus must be on the content and the depth of your analysis. Unless otherwise indicated, a 5-year trend analysis-including the most recent year of available data-is expected.
Complete your analysis as follows:
1) Calculate the 5-year net sales, operating expenses, operating income, and net income of Jiranna Healthcare. Once calculations are complete, interpret the resulting data and explain the significance of the trend results.
2) Calculate the 5-year total profit margin, asset turnover, return on assets, and return on net worth. Once calculations are complete, interpret the resulting data and determine the company's profitability.
3) Calculate the 5-year current ratio, day's cash on hand, and working capital. Once calculations are complete, interpret the resulting data and assess the company's liquidity.
4) Calculate the 5-year debt ratio and times interest earned ratio. Once calculations are complete, interpret the resulting data and explain the company's long term solvency.
5) Complete a DuPont analysis for each of the five most recent years. Once calculations are complete, interpret the resulting data and determine the company's individual DuPont characteristics (e.g., total margin, total asset turnover & equity multiplier) and trends across the analysis period.
6) Ultimately a decision has to be made. Would you recommend purchasing Jiranna Healthcare? Why?
Format your assignment according to the give formatting requirements:
• The answer must be using Times New Roman font (size 12), double spaced, typed, with one-inch margins on all sides.
• The response also includes a cover page containing the student's name, the title of the assignment, the course title, and the date. The cover page is not included in the required page length.
• Also include a reference page. The references and Citations should follow APA format. The reference page is not included in the required page length.
Attachment:- Jiranna-Finances.rar