Loading...

Messages

Proposals

Stuck in your homework and missing deadline? Get urgent help in $10/Page with 24 hours deadline

Get Urgent Writing Help In Your Essays, Assignments, Homeworks, Dissertation, Thesis Or Coursework & Achieve A+ Grades.

Privacy Guaranteed - 100% Plagiarism Free Writing - Free Turnitin Report - Professional And Experienced Writers - 24/7 Online Support

Data Finance

14/09/2020 Client: ericsermon1000 Deadline: 2 Day

 


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 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.

  • 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?


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 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.


Edit question's body



Edit question's attachments 

Homework is Completed By:

Writer Writer Name Amount Client Comments & Rating
Instant Homework Helper

ONLINE

Instant Homework Helper

$36

She helped me in last minute in a very reasonable price. She is a lifesaver, I got A+ grade in my homework, I will surely hire her again for my next assignments, Thumbs Up!

Order & Get This Solution Within 3 Hours in $25/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 3 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 6 Hours in $20/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 6 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 12 Hours in $15/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 12 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

6 writers have sent their proposals to do this homework:

Top Essay Tutor
Top Grade Tutor
Study Master
University Coursework Help
Writing Factory
Homework Guru
Writer Writer Name Offer Chat
Top Essay Tutor

ONLINE

Top Essay Tutor

I feel, I would be the best choice for this project, I have more than 10 years of working experience in writing essys, reports, case studies and dissertations. Give me your work and get relax

$150 Chat With Writer
Top Grade Tutor

ONLINE

Top Grade Tutor

I am highly qualified expert, working from 2008-9 in this industry. I have all relevant skills and expertise related to your project. To ensure my potential must visit my profile to check my ratings and uploaded samples. Thanks :--)

$140 Chat With Writer
Study Master

ONLINE

Study Master

I am highly qualified expert, working from 2008-9 in this industry. I have all relevant skills and expertise related to your project.

$135 Chat With Writer
University Coursework Help

ONLINE

University Coursework Help

Greetings! I’m very much interested to write for attendance systems. I am a Professional Writer with over 5 years of experience, therefore, I can easily do this job. I will also provide you with TURNITIN PLAGIARISM REPORT. You can message me to discuss the details.

$140 Chat With Writer
Writing Factory

ONLINE

Writing Factory

I can help you with creating a presentation of one slide for The Word of William Hunter. I will be happy to offer you 100% original work with high-quality standard, professional research and writing services of various complexities.

$125 Chat With Writer
Homework Guru

ONLINE

Homework Guru

I am a Ph.D. writer with more than 9 years of working experience in Writing. I have successfully completed more than 4500 projects for my clients with their full amount of satisfaction. I will provide you super quality work according to your given requirements and deadline with ZERO plagiarism.

$140 Chat With Writer

Let our expert academic writers to help you in achieving a+ grades in your homework, assignment, quiz or exam.

Similar Homework Questions

Advantages and disadvantages of level production strategy - Rough Draft Cyber Security - Research paper - Name and explain two types of prewriting - North staffs pigeon federation - Diet Analysis - Kid sampson catch 22 - Philosophy-Discussion - Pcos soap note - Journel - The unadjusted trial balance columns of a worksheet total 84000 - Blue bananas book bands - Binocular cues ap psychology - FREEMASON How to join 666 illuminati secret society for money +27734818506 Gibraltar,Palestine , UAE Ireland Swaziland - Responses - Definite integral absolute value - 107 witty road moggill - Pom qm version 4 download - Vehicle management system project in java - Dulux durebild ste application - Bea gov table 1.1 5 - Comparison of twisted pair coaxial cable and optical fiber - Quarter sawing advantages and disadvantages - Powerpoint - Gsm services in mobile computing - Hawthorn drive surgery ipswich - Kn mm to joules - Dissociation reaction in aqueous solution - Ethics in accounting the consequences of the enron scandal - William f baxter addresses environmental ethics by noting - Alyeska services company a division of a major oil company - Gold coast city council property search - Plant cell analogy amusement park - Conch republic electronics mini case - Information systems organizations and strategy chapter 3 - Elysium of the blue sky sheet music - Howard university hospital security breach - Semi quantitative test for lipids - Non volatile residue test - Explain who and what demand and supply represent - Pat fenlon coronation street - To a design theorist a beneficial mutation - Largest private companies in atlanta - Negotiation lewicki 7th edition pdf - Wendy kaufman balancing life's issues - It planning at modmeters - Dna replication worksheet true or false answers - Reynolds number experiment lab report - Do intrinsic and extrinsic motivation relate differently to employee outcomes - Certificate ii in hospitality kitchen operations online - Viking sagas ks2 planning - Finding Reliable Wikipedia Page Help - Tv recycling atlanta ga - Support sas com training - Marquis de sade justine english pdf - Principle of effective communication - Taxonomy lab to show organism relationships - Lead and manage organisational change answers - Tenix alliance new zealand - server virtualization and cloud computing - POLICE REFORM - Discussion 7 - A ball attached to a string is whirled around - Moles of hcl neutralized by naoh - Voltmeter galvanic cell - Swinburne senior secondary college staff - Mid digital hair - Organizational culture survey tool for ebp - How many protons are in a boron atom - Milestones in language and literacy chart k 8 - Economics paper - Brief written statements containing main conceptual ideas from the assigned reading material in your own words - Evidence-Based Practice and the Quadruple Aim - Army chapter 14 12c - The metamorphosis family relationships - Is orpheus a demigod - Conscious capitalism - Bofa merch svcs des interchng - Which of these sentences describes one of ezra pound's rules - CT1 Essay - Act 3 scene 5 macbeth summary - The dramatic structure of hamlet - According to duska, what two things does a business do in the free enterprise system? - Business law principles for today's commercial environment 5th edition pdf - Nbaa tanzania examination form final stage - Worldview and nursing process personal statement - What are the four components of health care - Home Syllabus Announcements Modules Discussions Assignments Grades Entrepreneurial Behaviors Self-assessment - David patchell evans net worth - Empire of the summer moon essay - Charles perkins quotes freedom rides - How are photosynthesis and cellular respiration alike - The negative effects of homework - Emerging contemporary readings for writers 4th edition free pdf - Money for nothing inside the federal reserve answers - Cpc10111 certificate 1 in construction - Bohr formula for radius of electron orbit - Chapter 2 business ethics and social responsibility ferrell - HR_GLOB_FIN (U3) - Use transformations to graph the function