Black-hawk Urology Case Solution And Analysis, HBR Case Study Solution & Analysis of Harvard Case Studies

Black-hawk Urology Case Solution

Question 1

In order to calculate the cash flows, the income statement has been projected for a period of three years from 2015 to 2017. The sales are expected to grow by 20% (as mentionedin case) and the practice is not able to grow its sales beyond 20%, so the sales are assumed to be constant on wards. All of the expense items are taken as a percentage of sales, on the basis of percentages in the fiscal year 2014. The expenses are subtracted from revenues, which resulted in profits of $898.6 in 2015, $878.6 in 2016 and $853.6 in 2017.

The capital expenditures related to the equipment were $150,000, and the working capital is calculated by taking the average of the percentage change in working capital, in terms of sales during 2013 and 2014. The change in working capital and capital expenditures are subtracted from the profits, which has resulted in the cash flows of $511.192 in 2015, $641.176 in 2016 and $616.1557 in 2017. The doctors’ aim was to have a salary of $37500,with an inclusion of an additional salary expense of the physician assistants, i.e. $120,000. However, the cash flows are declining as the result of stagnant sales and an increasing operating costs. The doctors would not meet the objective of getting personal salaries alongside the cost of PA.

Pro-Forma Income Statement
	2015	2016	2017
Income
total revenue	2502.0	2502.0	2502.0
Expenses
Office: expenses	267.7	270.2	272.7

Medial eq supplies	165.1	170.1	175.1
Cancer meds	425.3	430.3	440.4
Rent and utilities	142.6	145.1	147.6
Staff salary	520.0	520.0	520.0

Physician malpractice	82.6	87.6	92.6
Total Expenses	1603.4	1623.4	1648.4
Profit	898.6	878.6	853.6

Projected Cash Flows
	2015	2016	2017
Profit	898.634	878.618	853.598
Less: NWC	237.442	237.442	237.4423
Less: CAPEX	150	0	0
Cash Flows	511.192	641.176	616.1557

Question 2

A scenario analysis has been performed, whereby the best and the worst scenarios are analysed. In the best scenario; the projected sales (as given in question 1) are increased by 10%, and the overall expenses are decreased by 10%. On the other side, the projected sales are decreased by 10% and the projected expenses are increased by 10% in the worst case.

Best Case

The best case shows a strong positive impact on profitability and cash flows as, the cash flows generated by the practice are quite higher as compared to cash flows in the normal case (See Question 1).

Pro-Forma Income Statement
	2015	2016	2017
Income
total revenue	2752.2	2752.2	2752.2
Expenses
Office: expenses	240.9	238.7	238.7

Medial eq supplies	148.6	153.1	157.6
Cancer meds	382.8	387.3	396.3
Rent and utilities	128.4	130.6	132.9
Staff salary	468.0	468.0	468.0

Physician malpractice	74.3	78.8	83.3
Total Expenses	1443.0	1456.5	1476.8
Profit	1309.2	1295.7	1275.4

Projected Cash Flows -Best Case
	2015	2016	2017
Profit	1309.2	1295.66	1275.394
Less: NWC	237.442	237.442	237.4423
Less: CAPEX	150	0	0
Cash Flows	921.728	1058.22	1037.951

Worst Case

The worst case scenario shows that the decrease in sales and the increase in expenses by 10% will reduce the company’s profitability.In fact, it can be seen that the company is generating very low cash flows as compared to the normal scenario in the question 1........................

Black-hawk Urology Case Solution

This is just a sample partial case solution. Please place the order on the website to order your own originally done case solution.