Case Study: Pro Forma In Excel Attachment

1. Name the circulatory system that carries blood from the heart to the lungs and back to the heart.

The HCS 405 week 1 financial terms worksheet throws light on some of the most basic concepts of the healthcare business. Understanding health care financial terms is a prerequisite for both academic and professional success. The health care business helps the nation by providing the building blocks that the citizens need to live a successful and healthy life. The worksheet is intended to ensure that the students understand some of the basic terms used in the business world of the health care industry. The purpose of HCS 405 individual and team assignments is to make the students aware about the numerous strategies employed in the financial and other departments of a

The finance department has reported that Elijah Health Center is facing a potential working capital shortfall which means the hospital may not have enough cash to sustain itself. The reasons for this shortfall is due to huge discounts given to managed care companies, higher wages given to contract nurses, low Medicare reimbursement levels, growth in current liabilities, and unused equipment. I will provide the best strategy in order to sustain the cash flow problem that Elijah Heart Center is facing. My strategy will consist of three phases. These phases include: capital shortage, funding options for equipment acquisition and funding options for

$135,000 $90,000 TOTAL REVENUE $3,136,500 $2,352,375 $1,568,250 Expences TOTAL VARIABLE COSTS $454,000 $340,500 $227,000 TOTAL FIXED COSTS $1,403,000 $1,403,001 $1,403,002 TOTAL EXPENSE BEFORE IT $1,857,000 $1,743,501 $1,630,002 EBIT $1,279,500 $608,874 -$61,752 Depreciation $320,000 $320,001 $320,002 EBITDA $1,599,500 $928,875 $258,250 Furnishing Interest $110,000 $110,000 $110,000 20yr Mortgage Interest $182,000 $182,000 $182,000 TOTAL INTEREST $292,000 $292,000 $292,000 TAXES (40%) $395,000.00 $126,749.60 -$141,500.80 Furnishing Principal $180,160 $180,160 $180,160 20yr Mortgage Principal $49,713 $49,713 $49,713 TOTAL PRINCIPAL $229,873 $229,873 $229,873 NET INCOME $362,627 -$39,749 -$442,124 DIVIDEND PAYMENT $29,010 -$3,180 -$35,370 RETAINED EARNINGS $333,617 -$36,569 EBIT/INTEREST 4.38 2.09 (0.21) EBITDA/INTEREST 5.48 3.18 0.88 BURDEN $675,121.67 $675,121.67 $675,121.67 EBIT/BURDEN 1.90 0.90 (0.09) ROE= Net Income/OE (H1) 32.97% -3.61% -40.19% Revenue Estimates Revenue Item 100% Monthly 75%

1. “The healthcare borrower updates its capital plan, measures its debt capacity and attempts to get its house in order” (Zelman, McCue, & Glick, 2009)

Debt or equity financing. With annual free cash flow reaching levels of −$278,000, the business is burning a lot of cash. One should expect that if nothing is done to the business model, debt requirements will become larger and larger. It is unclear whether Maggie is interested in leveraging the business and risking possible default with an adverse weather event.

The major difference between healthcare finance terminology and business finance terminology is that these terms focus on factors unique to the health services industry. For example, the provision of health services is dominated by not-for-profit or¬ganizations (such as ours), which are inherently different from investor-owned businesses. Also, the majority of payments made to health¬care providers for services are not made by patients—the consumers of the services—but rather by some third-party payer (e.g., a commercial insurance company or a government program). Even the purchase of health insurance is dominated by employers rather than by the individuals who receive the services. These terms emphasize ways in which the unique features of the health services industry affect financial decisions. The healthcare industry is a service industry. It is not in the business of manufacturing, say, widgets. Instead its essential business is the delivery of healthcare services. It may have inventories of medical supplies and drugs, but those inventories are necessary to service delivery, not to manufacturing functions. Because the business of healthcare is a service, this overview of key healthcare terminology will focus on the practice of financial management in the services industry.

3. One source of MHHS’s cash flow problems are the steady staff salaries and benefits in the face of a seasonal industry. Ms. Ringer uses the promise of regular employment for full and part time staff as a recruitment tool, despite the variation in demand for home health services, which is higher in the winter months, but markedly decreased in summer. The seasonal nature of the home health industry, coupled with the steady labor expense, which she is actively expanding, requires Ms. Ringer to utilize a line of credit to cover her staff salaries, as they are not being covered by patient care.

Established in 1984, 210 full-time employees, 200 part-time employees. 2006 sales = $1.9 Billion. Dealing with an

The following pages present a brief analysis of sample data from one healthcare organization. Accompanying this written report are spreadsheets of the company's financial data its balance sheet and its statement of revenue and expenses that provide not only the figures from the audited reports of the hospital examined, but also show the change from year to year on each item as both a dollar amount and a percentage. Changes of more than five percent are considered worthy of discussion, and as these documents show much

Problem Losing Money: Astor Lodge & Suites, Inc., a 250 property hotel chain, is about to post its fifth consecutive unprofitable fiscal year. Requirements: Prepare Presentation for new President and CEO, Joseph James, describing each VPs 1) his or her initiatives, expenditures, and outcomes for each of the past two fiscal years, and 2) planned initiatives and budgetary needs for fiscal 2006. 3) Show how their staffs prior and planned initiatives and expenditures contributed the company's EBITDA (Earnings Before Interest, Taxes, Depreciation, and Amortization) - the corporate performance metric recently

The company currently faces serious financial challenges. It was struggling with declining sales and increasing costs. Since 2004, revenues had fallen by more than 40% while costs especially for employees health insurance, maintenance, and utilities climbed. Credits and loans had been borrowed to

Additionally, the unwillingness of the business office employees to accept onsite help from the hospital financial analyst team. They appear to be content with the status quo, which has resulted in their current financially precarious situation. They do not have the foundation needed, which should be as described by Weiss, Hassell, and Parks (2013) “…fertile enough to accept the seeds of change and to nurture them to grow” (p. 492).

Health care organisations do business on cash basis. They provide proper medical services to different people and they receive cash when operation ends and they don’t use any debt to finance their operating activities. The capital structure of this firm shows a zero inventory turnover and a huge amount of cash from the customers from which partially is used to pay current liabilities and the remaining is in the form of retain earning.

Our choices led to a constant increase in net income over the three years. Short term debt increase by approximately 100% percent but steadily reduced over the next three years. We were happy with the positive growth of the company and the fact that we were able to pay off most of the initial short term funding required by the increase in working capital requirement. Overall the current situation of the company in 2018 is good, although the total value created is less than 20% of that created in phase 1. From this we learned that the value of the firm can be significantly increased more through a reduction in working capital requirement than through increasing the firm’s sales and net income.