Get instant access to this case solution for only $15
Menotomy Home Health Services Case Solution
To prepare the cash flows of the company, the expenditures are estimated as per the information given in the case study. The cash inflows are determined which are primarily the positive cash flows which are supposed to reduce the cash needs of the company. The cash inflows are the revenue which the company receives from the patients. It is important to mention that these revenues are net revenues. The net revenues are the revenues which are excluded from all the direct patient cost. The reason for using the net revenue instead of total revenue are that net revenue are already excluded from the cost of goods sold and this method does not require the cost of goods sold deduct from it.
Following questions are answered in this case study solution
-
Prepare the cash flow worksheet contained in Exhibit 4. What does this tell you about the operations of MHHS?
-
Prepare pro forma financial statements for FY 2011. What do these tell you about the operations of MHHS? How can you reconcile the information in the cash flow worksheet with that in the financial statement?
-
What is the cause of MHHS’s cash flow problems? What solutions are available to Ms. Ringer?
-
What recommendations would you make to Ms. Ringer?
Case Analysis for Menotomy Home Health Services
The other inflows are depreciation which is a non-cash charge. Depreciation is an inflow because of the fact that it increases the operating expense of the company. As a result the taxable income of the company is understated and hence the company has to pay fewer taxes because of it. It is apparently provides tax shield to the company. In this case, $33,000 is the initial depreciation expense which is added in the month of October. Moreover, the company purchased Vans costing $18,000 which will be paid off in four equal instalments. The depreciation will be charge from the next month of the purchase. Hence this is another cash inflow.
The cash outflows of the company include various expenses such as salaries and benefits, overhead & admin, payment of accounts, contract service, Misc. expense, Vehicle expense, equipment lease, mortgage principal and third party payable. All these expenses depend upon the terms of the payments and incur accordingly. For example salaries & benefits are same in every month except for July. This is because of the fact that most of the employees go on the vocation in June and therefore the Salaries of July are reduced. Overhead & admin payments are same in all the months amounting to $15,000 per month.
The different lease and loan payments are also cash out flows of the firm which are expensed in the month of maturity. By aggregating the total outflow and inflow, the result is net cash flow of the company which is positive in few months and negative in others. The cash flows are positive in most of the period which shows that the operations of the company are very effective and the efficient use of resources is the strategy.
2. Prepare pro forma financial statements for FY 2011. What do these tell you about the operations of MHHS? How can you reconcile the information in the cash flow worksheet with that in the financial statement?
Performa Income Statement
|
$ |
|
|
|
Performa Financial Statement |
|
FY 2010 |
% |
FY2011 |
Gross Patient Revenue |
|
838,524 |
|
810,000 |
Less: Contractual Allowance & Uncollectable Accounts |
|
140,034 |
16.70% |
135,270 |
|
|
|
|
- |
Operating Expense |
|
|
|
- |
Salaries & Benefits |
|
421,200 |
50.23% |
406,872 |
Overhead & Admin |
|
136,310 |
16.26% |
131,673 |
Cost of Medical Supplies |
|
34,471 |
4.11% |
33,298 |
Contract Services |
|
10,230 |
1.22% |
9,882 |
Equipment Rental |
|
19,650 |
2.34% |
18,982 |
Depreciation |
|
33,000 |
3.94% |
31,877 |
Interest |
|
14,935 |
1.78% |
14,427 |
Other Expenses |
|
14,332 |
1.71% |
13,844 |
Total operating Expenses |
|
684,128 |
|
660,856 |
|
|
|
|
|
Net Profit |
|
14,362 |
|
13,873 |
Performa Balance Sheet
FY 2010 |
% |
FY2011 |
|
Cash |
22,860 |
3.47% |
25,146.00 |
Accounts Receivables |
68,100 |
10.35% |
74,910.00 |
Inventory |
39,960 |
6.07% |
43,956.00 |
Prepaid Expense |
41,585 |
6.32% |
45,743.50 |
Total Current Assets |
172,505 |
26.21% |
189,755.50 |
Property & Equipment |
468,946 |
71.26% |
515,840.60 |
Other Assets |
16,650 |
2.53% |
18,315.00 |
Total Assets |
658,101 |
|
723,911 |
|
|
|
|
Liabilities & Net Worth |
|
|
|
Line of Credit |
65,400 |
9.94% |
71,940 |
Accounts Payable |
2,925 |
0.44% |
3,218 |
Salaries & Benefits Payable |
35,100 |
5.33% |
38,610 |
Due to Third Party |
14,086 |
2.14% |
15,495 |
Note Payable Current |
29,070 |
4.42% |
31,977 |
Mortgage Current |
11,250 |
1.71% |
12,375 |
Total Current Liabilities |
157,831 |
23.98% |
173,614 |
|
|
|
- |
Mortgage Payable |
146,250 |
22.22% |
160,875 |
Other Long Term Debt |
270,000 |
41.03% |
297,000 |
Total Liabilities |
574,081 |
87.23% |
631,489 |
Unrestricted Net Assets |
84,020 |
12.77% |
92,422 |
Total Liabilities & Net Assets |
658,101 |
100.00% |
723,911 |
Get instant access to this case solution for only $15
Get Instant Access to This Case Solution for Only $15
Standard Price
$25
Save $10 on your purchase
-$10
Amount to Pay
$15
Different Requirements? Order a Custom Solution
Calculate the Price
Related Case Solutions
- Ken Private Limited Digitization Project Case Solution
- BAE Automated Systems A Denver International Airport Baggage Handling System Case Solution
- Orion Bus Industries Contract Bidding Strategy Case Solution
- Mountain Man Brewing Co Bringing The Brand To Light Case Solution
- Timbercreek Investment Inc Case Solution
Get More Out of This
Our essay writing services are the best in the world. If you are in search of a professional essay writer, place your order on our website.