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

Financial Data

26/08/2020 Client: user_3wd25t 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.

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:

Buy Coursework Help
Writer Writer Name Offer Chat
Buy Coursework Help

ONLINE

Buy Coursework Help

I can help you with your project. I will make sure to provide you exceptional quality work within the required timeframe. Please message me so we can discuss the further details over chat.

$10 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

Discussion question - Case Study on Biomedical Ethics in the Christian Narrative - The life-cycle of a typical moss includes - All else equal, the contribution margin must increase as: - Hermetically sealed transformer maintenance - "I was passed over for promotion for the third time. Our company is under fire for sex discrimination, and each time a woman gets the job over me. I know it's not my fault at all, but somehow I feel inadequate." - 900 words plus 2 pages - 2.16535 inches to fraction - Translational Research And Population Health Management - Noe employee training and development 5th edition - Biology - Week 5 Assignment: Ethical and Cultural Perspectives of Inquiry Paper - Google project oxygen do managers matter - Splitting and Joining Strings - Writing Exercise - Maslow's hierarchy of needs assignment - Does history repeat itself evidence from the course - LEGAL Forum Week 3# - Mbsa and security audits - A sickeningly sweet baby boy - Copper silver nitrate copper ii nitrate silver - Toy bonnie made a somewhat large mistake - How to know if functions are inverses of each other - Kendall county women's shelter - Drugged high on alcohol - Cadillac it is a weak man who urges compromise - Vhi health plus extra plan b options - “malabar! malabar! did i say malabar, mother?” - Unit V Essay - Discussion response - Should the electoral college be abolished pros and cons - Total words in quran - Forecasting ticket revenue for orlando magic basketball games - National institute of oceanography kochi - Estimating can be challenged by - Organizational behaviour understanding and managing life at work pdf - Netstumbler access denied windows 7 - Chakmak stone in english - Mh connect spanish - Entire classes work - Red hill greek church easter - Policy and legal_Week 12 - Mills 3 questions sociological imagination - Haunting in connecticut story - Shipping forecast fair isle - Marketplace simulation tips - Scleroderma renal crisis wiki - The donaldson company uses a job order costing system - Bangladesh high commission canberra police clearance - Glossary of poetry terms - Who won the battle of hastings - Stream c job seekers - Dulux fine texture paint - How does institutional isomorphism affect individual workers in the economy - Assignment 1 -1Edu - Unnatural balance accounting - 400 words discussion post regards Dante's inferno (Chapter 25-30) - Macroeconomics institutions instability and the financial system solutions - Genesis account of creation powerpoint - Nothing gold can stay - Create Home Care Non-Medical Business Plan - What is campaign for action - Counseling Case Study - The tesseract by alex garland guide questions and answers - Yarra ranges building surveyors - 1a farnham street parnell - Ikea organisational structure and culture - Blue gate field infant school - The element from period iii with the largest atomic radius - Aswan high dam location - PSY 6-1 - Wabco trailer abs codes - The role of a social worker - Camera shots and angles - Strayer university acc 100 syllabus - Sample fba write up - Library management system slideshare - Tribute to parents speech - Bates visual guide to physical examination pdf - Vera bradley case study - Professional Assignment 1 – CLO 1, C LO 2 - Woofer pet foods produces a low calorie dog food - Crime fighter vs public servant - 250 word answer - BA 4010 MOD 1 Questions - Ethos in the gettysburg address - Mackay coastal waters forecast - Orientation phase of a therapeutic nurse patient relationship - Axe peace print advert - Best method to discipline your child - Master slave power board - Vce psychology study design 2020 - Research methods in psychology morling pdf download - POB Home Work - Velocity of an electron through a potential difference - Topic 6 Thread 1 and 2 - The blau & berg company - Lickable nail polish - Shadow health tina jones musculoskeletal - Mirror and lens ray diagram worksheet