This assessment has three-parts. Click each of the items below to complete this assessment. Part I: 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 Healthcares 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-page financial analysis. The focus must be on the content and the depth of your analysis. Unless otherwise indicated, a 5-year trend analysisincluding the most recent year of available datais expected. Complete your analysis as follows: 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. 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 companys profitability. Calculate the 5-year current ratio, days cash on hand, and working capital. Once calculations are complete, interpret the resulting data and assess the companys liquidity. Calculate the 5-year debt ratio and times interest earned ratio. Once calculations are complete, interpret the resulting data and explain the companys long term solvency. Complete a DuPont analysis for each of the five most recent years. Once calculations are complete, interpret the resulting data and determine the companys individual DuPont characteristics (e.g., total margin, total asset turnover & equity multiplier) and trends across the analysis period. Ultimately a decision has to be made. Would you recommend purchasing Jiranna Healthcare? Why? Part II: Case Study #2 For the next part of this Performance Task, you are expected to complete a number of calculations, and then interpret the numbers to provide recommendations based on these analyses. It is essential both to show your work and calculations, and to demonstrate how these calculations support your conclusions. Be sure to explain your reasoning. You will be assessed on the accuracy of your quantitative analyses and the quality of the evidence you use to support your conclusions. Imagine that you are an administrator at Jiranna Healthcare who has been asked to analyze cash-flow data to determine the costs and benefits of implementing a new capital project. For background, read Capital Project Case Study, Part 1. Then, complete the Capital Project Case Study, Part 2 spreadsheet, which provides cash-flow data (costs and benefits) for the proposal. Download and save the Excel spreadsheet, and use the information provided to complete the following: Calculate the cash inflows and outflows for each year. Calculate the following metrics: Net present value (NPV) Internal rate of return (IRR) Modified internal rate of return (MIRR) Payback period Discounted payback period In a 1- to 2-page report, provide your recommendation with rationale, as to whether the project is acceptable, assuming Jiranna has a corporate policy of not accepting projects that take more than 3.5 years to pay for themselves, and assuming an 11% cost of capital Part III: Conduct a Budgeting Evaluation You are an administrator at Jiranna Healthcare. You have been asked to conduct a budget variance analysis: analyzing performance by comparing budgeted workload, revenue, and expenses for a range of different service lines, with actual workload, revenue, and expenses for those service lines. Open the document Variance Analysis Case Study, where you will find data on the expenses, revenue, and inpatient product lines at Jiranna Healthcare. Analyze the data and prepare a 3- to 4-page report. In your report, address each of the five following questions. In each case, show the calculations that you conducted to answer the question. Then, explain your conclusion and how your calculations support your reasoning. What was the hospitals original profit forecast (assume away any issues with depreciation, taxes, etc.)? Halfway through the fiscal year, what is the hospitals revised projection for FY11 profits? Which inpatient service lines are over budget? Which inpatient service lines are over budget after accounting for workload increases? What two actions would you recommend be taken at the mid-year point if you oversaw a fee-for-service hospital? In other words, where are the problem areas on which you would focus your attention, and who might provide ideas for best practices based on their performance? What two actions would you recommend be taken at the mid-year point if you oversaw a capitated hospital? In this case, the revenue spreadsheet would be replaced with an overall budget of $50 million with which to operate (rather than being able to bill for each episode of patient care). Federal, state, county, and city hospitals normally operate under a capped budget. Additionally, many HMOs also operate under a fixed per member, per month (PMPM) capitated process. Edit questions body FM007_Assessment_VarianceAnalysisCaseStudy.pdf FM007_Assessment_JirannaFinances.xlsx FM007_Assessment_CapitalProjectCaseStudyPart2.xlsx Assessment_Writing_Checklist8.docx FM007_Assessment_JirannaFinances.xlsx Edit questions attachments
Top Quality and Well-Researched Papers
We always make sure that writers follow all your instructions precisely. You can choose your academic level: high school, college/university or professional, and we will assign a writer who has a respective degree.
Professional and Experienced Academic Writers
We have a team of professional writers with experience in academic and business writing. Many are native speakers and able to perform any task for which you need help.
Free Unlimited Revisions
If you think we missed something, send your order for a free revision. You have 10 days to submit the order for review after you have received the final document. You can do this yourself after logging into your personal account or by contacting our support.
Prompt Delivery and 100% Money-Back-Guarantee
All papers are always delivered on time. In case we need more time to master your paper, we may contact you regarding the deadline extension. In case you cannot provide us with more time, a 100% refund is guaranteed.
Original & Confidential
We use several writing tools checks to ensure that all documents you receive are free from plagiarism. Our editors carefully review all quotations in the text. We also promise maximum confidentiality in all of our services.
24/7 Customer Support
Our support agents are available 24 hours a day 7 days a week and committed to providing you with the best customer experience. Get in touch whenever you need any assistance.
If you ever find yourself buried by an ever-growing mound of schoolwork and need assistance, we are the people to call. We don't ask questions on our site; instead, we simply publish the project and let our expert homework helpers submit their bids. Choose your favorite writer after evaluating each proposal based on their writer's profile. Isn't that straightforward? Well, it is in our team's best interests to assist you in passing your exams. All you have to do now is pay for the assistance.
We are always willing to assist with any type of job. It makes no difference what time it is, where you are, or what language you speak. Our homework helpers come from many walks of life and speak a variety of languages, so simply post the task in a language you are comfortable with and let them submit their bids. So, whether you need Physics help, Biology aid, Chemistry help, Economics help, Finance help, English homework help, or Computer assignment help, you've come to the right place.
No matter what kind of academic paper you need and how urgent you need it, you are welcome to choose your academic level and the type of your paper at an affordable price. We take care of all your paper needs and give a 24/7 customer care support system.
Admission Essays & Business Writing Help
An admission essay is an essay or other written statement by a candidate, often a potential student enrolling in a college, university, or graduate school. You can be rest assurred that through our service we will write the best admission essay for you.
Editing and Proofreading
Our academic writers and editors make the necessary changes to your paper so that it is polished. We also format your document by correctly quoting the sources and creating reference lists in the formats APA, Harvard, MLA, Chicago / Turabian.
If you think your paper could be improved, you can request a review. In this case, your paper will be checked by the writer or assigned to an editor. You can use this option as many times as you see fit. This is free because we want you to be completely satisfied with the service offered.