FM007 Final Q

ExampleFM007JirannaFinancials11152021.xlsx

Home >Human Resource Management homework help >FM007 Final Q

Balance Sheet

Jiranna Healthcare Balance Sheet December 31, 2013 (in thousands)
	2009	2010	2011	2012	2013
Current assets	$ 280	$ 124	$ 136	$ 295	$ 355
Cash	30	45	50	75	88
Receivables, net	1,340	1,536	1,700	1,896	2,400
Inventory	140	175	250	276	266
Prepaid expenses	40	32	40	53	78
Total Current Assets	1,830	1,912	2,176	2,595	3,187
Short-term investments	600	1,010	1,200	1,300	1,510
Plant and equipment	6,580	6,780	6,900	7,200	7,500
Less accumulated depreciation	-1,660	-1750	-1,800	-1,950	-2,350
Plants and equipment, net	4,920	5,030	5,100	5,250	5,150
Total Assets	$ 7,350	$ 7,952	$ 8,476	$ 9,145	$ 9,847
Current liabilities
Accounts payable	370	302	356	370	375
Accrued expenses payable	220	208	212	210	215
Deferred revenues	60	77	87	87	94
Total current liabilities	650	587	655	667	684
Long-term liabilities	2,400	3,000	3,300	3,500	3,750
Total Liabilities	3,050	3,587	3,955	4,167	4,434
Net assets
Unrestricted	3,000	3,285	3,221	3,678	4,113
Temporarily restricted	700	700	700	700	700
Permanently restricted	600	600	600	600	600
Total Net Assets	4,300	4,585	4,521	4,978	5,413
Total Liabilities and Net Assets	7,350	8,172	8,476	9,145	9,847

Income Statement

Jiranna Healthcare Income Statement December 31, 2013 (in thousands)
	2009	2010	2011	2012	2013
Gross patient services revenues (non-GAAP)	8,870	9,490	10,400	11,200	12,050
Less deductions from revenues (non-GAAP)	(780)	(890)	(1,000)	(1,500)	(1,600)
Net patient service revenues	8,090	8,600	9,400	9,700	10,450
Other operating revenues	519	633	679	717	980
Total operating revenues	8,609	9,233	10,079	10,417	11,430
Operating expenses
Salaries and wages	5,497	5,678	5,890	6,170	6,800
Supplies	823	850	855	890	905
Utilities	558	576	590	595	620
Insurance	44	46	49	54	70
Depreciation	168	173	175	178	188
Interest	142	146	154	179	198
Bad debts	363	375	400	455	500
Other operating expenses	987	1,299	1,560	1,300	1,350
Total operating expenses	8,582	9,143	9,673	9,821	10,631
Operating income	27	90	406	596	799
Nonoperating income	154	195	245	220	290
Excess of revenue over expenses	$ 181	$ 285	$ 651	$ 816	$ 1,089
Change in net assets
Unrestricted	$ 181	$ 285	$ 651	$ 816	$ 1,089
Temporarily restricted	-	-	-	-	-
Permanently restricted	-	-	-	-	-
Total change in net assets	181	285	651	816	1,089

Cash Flows

Jiranna Healthcare Cash Flows, 2013 (in thousands)
Cash Flows from Operating Activities
Cash received from patient and third-party payers	$ 10,671
Cash received from operating revenue sources	800
Cash received from nonoperating revenue sources	270
Cash payments to employees	(5,600)
Cash payments to suppliers of goods and services	(4,800)
Net cash flow from operating activities		$ 1,341
Cash flows from Investing Activities
Cash payments for purchase of plant assets	(1,200)
Cash payments for purchase of long-term investments	(670)
Proceeds from sales of plant assets	80
Proceeds from sale of long-term investments	60
Net cash flow from investing activities		(1,730)
Cash flows from Financing Activities
Proceeds from issuance of 6% bonds payable	4,000
Principal payments on long-term debt	(300)
Cash payments to retire 7% bonds payable	(3,200)
Net cash flow from financing activities		500
Net increase/(decrease) in cash		$ 111

Part One

Jiranna Financials	2009	2010	2011	2012	2013
Net Sales
Operating Expenses	8,582	9,143	9,673	9,821	10,631	*example of how pull numbers from other worksheets
Operating Income
Net Income
Profitability	2009	2010	2011	2012	2013
Total Profit Margin
Asset Turnover
Return on Assets
Return on Net Worth
Liquidity Analysis	2009	2010	2011	2012	2013
Current Ratio
Days Cash on Hand
Working Capital
Longterm Solvency	2009	2010	2011	2012	2013
Debt Ratio
Times Interest Earned
DuPont	2009	2010	2011	2012	2013
Net Profit Margin
Asset Turnover
Equity Multiplier
DuPont Analysis

Part Two

	Year 0	Year 1	Year 2	Year 3	Year 4	Year 5
Nurse Triage Salaries	$ 523,800	$ 549,990	$ 577,490	$ 606,364	$ 636,682	$ 668,516
Forecasted ER Cost Reductions	$ 400,000	$ 800,000	$ 848,000	$ 900,577	$ 955,512	$ 1,013,798
New IT Specialist's Salary	$ 150,000	$ 154,500	$ 159,135	$ 163,909	$ 168,826	$ 173,891
Costs of Facility Renovations	$ 30,000	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Necessary Capital Equipment Purchases	$ 117,000	$ 3,510	$ 3,510	$ 3,510	$ 3,510	$ 3,510
Net Cash Flow:
Present Values of Net Cash Flows:
Net Present Value:
Internal Rate of Return (IRR):
Modified Internal Rate of Return (MIRR):
Payback Period (# years):
Discounted Payback Period (# years):
Calculation for Discounted Payback Period
	Breakeven/Payback Period Years Based on PV of Net Cash Flows	Disc cum cash flow	Cum Cash Flow
	0
Net Cash Flow:	1
PV cash flow	2
Cumulative cash flow	3
	4
	5
	Discounted PayBack Period in Years

Variance Analysis Case Study

Jiranna Healthcare Expenses Worksheet, Mid-Year Review
Outpatient
Outpatient Product Line	Unit Expense (FY10)	Actual Units (FY10)	Total OP Expenses (FY10)	Unit Forecast (FY11)	Unit Expence (Budget FY11)	FY11 Budget (FY10+6% Inflation)	Acutal Mid Year Units (FY11)	Actual OP Expenses (FY11 YTD)
CARDIOLOGY	$ 5,478.81	645	$ 3,533,832	677	$5,807.54	$ 3,931,704	197	$ 1,144,085
ENDOCRINOLOYGY	$ 5,478.81	217	$ 1,188,902	228	$5,807.54	$ 1,324,119	112	$ 650,444
FAMILY MED	$ 5,476.81	1,105	$ 6,051,875	1,161	$5,802.92	$ 6,737,188	636	$ 3,690,656
GYN	$ 5,478.81	208	$ 1,139,592	219	$5,794.28	$ 1,268,947	116	$ 672,136
ENT	$ 5,475.81	690	$ 3,778,309	724	$5,804.36	$ 4,202,356	421	$ 2,443,635
MENTAL HEALTH	$ 498.78	1,287	$ 641,930	1,351	$528.71	$ 714,283	736	$ 389,128
NEWBORN	$ 5,478.81	698	$ 3,824,209	733	$5,807.54	$ 4,256,926	433	$ 2,514,664
OB	$ 5,478.81	1,430	$ 7,834,698	1,501	$5,807.54	$ 8,717,115	868	$ 5,040,943
ORTHO	$ 5,478.81	601	$ 3,292,765	631	$5,807.54	$ 3,664,557	274	$ 1,591,266
PEDIATRICS	$ 5,477.81	124	$ 679,248	130	$5,806.48	$ 754,842	72	$ 418,066
PODIATRY	$ 5,478.81	2,050	$ 11,231,561	2,152	$5,807.54	$ 12,497,823	800	$ 4,646,031
Total Expenses	$55,281	9,055	$43,196,921	9,507	$58,582	$48,069,860	4,665	$23,201,056
Jiranna Healthcare Revenues Worksheet, Mid-Year Review
Outpatient
Outpatient Product Line	Unit Price (FY10)	Actual Units (FY10)	Total OP Revenue (FY11)	Unit Forecasted For (FY11)	Unit Price (Budget FY11)	Projected OP Revenue For FY11	Actual (FY11 YTD)	Actual OP Revenue (FY11 YTD)
CARDIOLOGY	$ 6,118.73	645	$ 3,946,580.85	677	$6,118.73	$ 4,142,380	197	$ 1,205,390
ENDOCRINOLOYGY	$ 6,103.65	217	$ 1,324,492.05	228	$6,103.65	$ 1,391,632	112	$ 683,609
FAMILY MED	$ 6,021.65	1,105	$ 6,653,923.25	1,161	$6,019.06	$ 6,988,125	636	$ 3,828,120
GYN	$ 6,013.65	208	$ 1,250,839.20	219	$5,999.92	$ 1,313,983	116	$ 695,991
ENT	$ 6,010.65	690	$ 4,147,348.50	724	$6,010.65	$ 4,351,711	421	$ 2,530,484
MENTAL HEALTH	$ 502.99	1,287	$ 647,348.13	1,351	$502.99	$ 679,539	736	$ 370,200
NEWBORN	$ 7,014.71	698	$ 4,896,267.58	733	$7,014.71	$ 5,141,782	433	$ 3,037,369
OB	$ 5,713.65	1,430	$ 8,170,519.50	1,501	$5,713.65	$ 8,576,189	868	$ 4,959,448
ORTHO	$ 6,084.18	601	$ 3,656,592.18	631	$6,084.18	$ 3,839,118	274	$ 1,667,066
PEDIATRICS	$ 6,001.65	124	$ 744,204.60	130	$6,001.65	$ 780,215	72	$ 432,119
PODIATRY	$ 6,018.14	2,050	$ 12,337,187.00	2,152	$6,018.14	$ 12,951,037	800	$ 4,814,512
Total Revenue	$61,604	9,055	$47,775,303	9,507	$61,587	$50,155,711	4,665	$24,224,308
Product Line	MDC DescrOPtion
CARDIOLOGY	Diseases and Disorders of the Circulatory System (Hypertension, Heart Disease, etc.)
ENDOCRINOLOYGY	Diseases and Disorders of the Endocrin System (Diabetes Type 1 & 2, Thyroid Disorders, etc)
FAMILY MED	Family Primary Care and Disease Preventative Services
GYN	Diseases and Disorders of Women's Reproductive Health
ENT	Diseases and Disorders of the Ear, Nose, Mouth, and Throat
MENTAL HEALTH	Mental Diseases and Disorders
NEWBORN	Newborns and Other Neonates with Conditions Originating in Perinatal Period
OB	Pregnancy, Childbirth, and the Puerperium
ORTHO	Diseases and Disorders of the Musculoskeletal System and Connective Tissue
PEDIATRICS	Pediatric Primary Care and Disease Prevention Services (0 - 18 years)
PODIATRY	Diseases and Disorders of the Feet and Lower Limbs

Part Three

Jiranna Healthcare
Projected Profit
	Projected (FY11)	Projected (mid-year)	Actual (mid-year)	Revised FY11 Projection
Revenue
Expenses
Profit
Jiranna Healthcare
FY11 YTD Expense Variances
	I	II	III	IV
Outpatient Product Line	FY11 YTD Budget	Actual OP Expenses (FY11 YTD)	Expense Variance (I-II)	Favorable / Unfavorable
CARDIOLOGY
ENDOCRINOLOYGY
FAMILY MED
GYN
ENT
MENTAL HEALTH
NEWBORN
OB
ORTHO
PEDIATRICS
PODIATRY
Total Outpatient Expenses
Jiranna Healthcare
Revenue Variances
	I	II	III	IV
Outpatient Product Line	FY11 YTD Budget	Actual OP Revenue (FY11 YTD)	Revenue Variance (I-II)	Favorable / Unfavorable
CARDIOLOGY
ENDOCRINOLOYGY
FAMILY MED
GYN
ENT
MENTAL HEALTH
NEWBORN
OB
ORTHO
PEDIATRICS
PODIATRY
Total Outpatient Revenues
Jiranna Healthcare
Profit Variances
	I	II	III	IV
Outpatient Product Line	FY11 YTD Budget Profit	Actual OP Profit (FY11 YTD)	Profit Variance (I-II)	F/U
CARDIOLOGY
ENDOCRINOLOYGY
FAMILY MED
GYN
ENT
MENTAL HEALTH
NEWBORN
OB
ORTHO
PEDIATRICS
PODIATRY
Total Profit