Assignment Week 2: Financial Data Update
Assignment Week 2: Financial Data Update
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-page 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:
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 company’s profitability.
ORDER NOW FOR CUSTOMIZED, PLAGIARISM-FREE PAPERS
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.
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.
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.
Ultimately a decision has to be made. Would you recommend purchasing Jiranna Healthcare? Why? Assignment Week 2: Financial Data Update
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)
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 hospital’s original profit forecast (assume away any issues with depreciation, taxes, etc.)? Halfway through the fiscal year, what is the hospital’s 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. Assignment Week 2: Financial Data Update
Clients' Reviews about Our Services
Client ID 45637
Brilliant services. I ordered a 4 page essay and it was delivered in less than 24hours with every detail intact!
Client ID 45783
Aceassignment is the way to go. The writers are humble and patient with clients. I know this after using the website for about an year
Client ID 45214
My writer did a brilliant job. Not only did she delivered the paper on time and it was superb as my professor granted me an A without any criticism
Client ID 45009
I was running late with my assignment. I run into aceassignment on google, placed my order and within less than 18 hours my page essay was delivered. Thank you Aceassignment.
Client ID 45870
I've been using Aceassignment for about 2 years. My writer always delivers quality work. Mind you whenever I request for a revision it's always done ASAP and free of charge
Client ID 44218
At first, I was scared and hesitant about using this website. Didn't know if they would deliver, but they assured me they will. And for sure they did. I will definitely continue to use their service!
Client ID 45622
Easy to use website. You simply give your essay's instructions, make payment and before you known it the paper is delivered to you.
Client ID 43964
Unlike other platforms, this website is quite cheap and the quality is high. I have them manage my whole class and everything has been smooth this far.
Client ID 41996
Thanks for the excellent job. Swift and on the subject, just the way I like it. The Support team was quite nice to me, helped me with the order placing process.
Client ID 47654
They are a marvel. I love their support team, they are so polite, it’s like speaking to a butler or something. Very pleasant people and good service of course.
Client ID 45670
Thank you for the help, I took my time and ordered a 14 days long essay. It came much earlier, around 7 days after I ordered it. Oh, and it was good, of course. I like the writer who did that, will definitely use again.
Client ID 22368
What I received was great. I forgot to mention in the instructions field that I needed reference page and by default, there was 0 in the number of references. I was surprised to see a full-fledged reference page in my paper with relevant citations. Bravo!
Client ID 46325
I was bombarding him with fine tuning and he handled it professionally. Thank you I will hire again the writer
Client ID 456820
Provided exceptional essay writing help in a short period of time. I plan to work with writer on many more projects!
Client ID 36890
Awesome paper in such a short amount of time. Was in a jam with another service who didn't deliver, but my writer did the job correctly. I will use her again to do my essays for sure!
Client ID 41427
Pretty good essay writer. I only made a couple of adjustments. She caught some instructions for the essay writing assignment that I didn't even notice, including them which was a pleasant surprise. Definitely recommend.
Client ID 45009
It was a very long paper, but the writer followed all the instructions, and she even finished the paper 5 days before the due date. Will write an essay with her again, thanks!
Client ID 36984
Writer was timely and proficient. I had to ask for a revision, but I got it back quickly with no other issues. Would use this essay writing service again.
Client ID 42960
Paper writing was prepared and submitted prior to the completed request date, and there were changes made quickly after I requested. This paper writer was accurate with numbers.
Client ID 31638
The first time I ordered here and it was a success. I received my order on time and according to my instructions. Thank you!
Client ID 46041
When I first discovered this website I was hesitant on whether they will deliver a plag free paper. The support team reassured me of their plagiarism policy. In deed they kept their word as the paper I got was authentic and plagiarism free.