| REVENUE & EXPENSE TOTALS FOR – MOBILE LITHOTRIPSY NETWORK |
|
|
|
| 1st Project Year Ending |
|
| Inflation Assumption = _0_ % |
Year Ending |
|
|
|
| Net Project |
|
| REVENUE |
| Without Project |
conservative 800 procedures |
Moderate 900 procedures |
Aggressive 1,000 procedures |
Impact |
|
| Inpatient Routine Charges |
$740,267,000 |
$893,481,502 |
$893,481,502 |
$893,481,502 |
$893,481,502 |
$ - |
|
| Outpatient Service Charges |
$366,226,000 |
$438,774,197 |
$442,194,997 |
$442,622,597 |
$446,470,997 |
$3,420,800 |
|
| TOTAL PATIENT REVENUE |
$1,106,493,000 |
$1,332,255,699 |
$1,335,676,499 |
$1,336,104,099 |
$1,339,952,499 |
$3,420,800 |
|
| Bad Debt Expense |
$20,683,000 |
$35,304,776 |
$35,405,690 |
$35,418,304 |
$35,531,833 |
$100,914 |
|
| Contractual Allowances |
$362,569,000 |
$427,063,889 |
$428,110,653 |
$428,241,499 |
$429,419,108 |
$1,046,764 |
|
| NET PATIENT REVENUE |
$723,241,000 |
$869,887,034 |
$872,160,156 |
$872,444,296 |
$875,001,559 |
$2,273,122 |
|
| Other Operating Revenue |
$29,815,000 |
$40,214,720 |
$40,214,720 |
$40,214,720 |
$40,214,720 |
$ - |
|
| Other Revenue/Investment Income |
$18,807,000 |
$26,088,694 |
$26,243,333 |
$26,243,333 |
$26,436,632 |
$154,639 |
|
| TOTAL REVENUE |
$771,863,000 |
$936,190,448 |
$938,618,209 |
$938,902,349 |
$941,652,910 |
$2,427,761 |
|
| EXPENSE |
|
| Salaries and Wages |
$331,345,000 |
$392,152,406 |
$391,753,685 |
$392,600,967 |
$392,252,086 |
$398,721 |
|
| Fringe Benefits |
$81,634,000 |
$99,162,243 |
$99,058,171 |
$99,279,324 |
$99,188,261 |
$104,072 |
|
| Contractual Services |
$53,633,000 |
$60,734,688 |
$62,407,241 |
$62,616,310 |
$64,497,932 |
$1,672,553 |
|
| Maintenance |
$ - |
$ - |
$50,000 |
$50,000 |
$50,000 |
$50,000 |
|
| Utilities |
| $ - |
$ - |
|
| $ - |
|
| Supplies |
$160,345,000 |
$191,409,583 |
$191,318,391 |
$191,512,174 |
$191,432,381 |
$91,192 |
|
| Lease Expense |
$ - |
$ - |
$167,447 |
$167,447 |
$167,447 |
$167,447 |
|
| Interest Expense |
$6,952,000 |
$21,485,718 |
$21,485,718 |
$21,485,718 |
$21,485,718 |
$ - |
|
| Depreciation/Amortization |
$48,701,000 |
$65,884,010 |
$65,884,010 |
$65,884,010 |
$65,884,010 |
$ - |
|
| Insurance |
$ - |
$ - |
$ - |
|
| $ - |
|
| Other Expense |
$75,677,000 |
$84,027,908 |
$84,027,908 |
$84,027,908 |
$84,027,908 |
$ - |
|
| SUBTOTAL - OPERATING EXPENSE |
$758,287,000 |
$914,856,558 |
$916,052,573 |
$916,202,075 |
$917,547,592 |
$1,196,015 |
|
| Indirect Cost |
$ - |
$ - |
$ - |
|
| $ - |
|
| Professional fees |
$ - |
$ - |
$ - |
|
| $ - |
|
| TOTAL OPERATING EXPENSE |
$758,287,000 |
$914,856,558 |
$916,052,573 |
$916,202,075 |
$917,547,592 |
$1,196,015 |
|
| MARGIN |
|
| REVENUE OVER (UNDER) EXPENSE |
$13,576,000 |
$21,333,890 |
$22,565,635 |
$22,700,274 |
$24,105,319 |
$1,231,745 |
|
| PERCENT REVENUE OVER EXPENSE |
1.79% |
2.33% |
2.46% |
2.48% |
2.63% |
0.13% |
|
| PERCENT DISTRIBUTION OF REVENUE |
|
| Medicaid |
13.30% |
12.90% |
12.90% |
12.90% |
12.90% |
0% |
|
| Medicare |
32.30% |
34.20% |
33.20% |
33.20% |
33.20% |
0% |
|
| Blue Cross |
16.30% |
14.80% |
14.80% |
14.80% |
14.80% |
0% |
|
| Private Pay |
3.80% |
3.80% |
3.80% |
3.80% |
3.80% |
0% |
|
| HMO |
16.00% |
16.00% |
16.00% |
16.00% |
16.00% |
0% |
|
| Other |
18.30% |
18.30% |
18.30% |
18.30% |
18.30% |
0% |
|
| Lithotripsy Procedures |
1,000 |
800 |
800 |
900 |
1,000 |
0 |
|
| Average Charge Per Procedure |
$4,276 |
$4,276 |
$4,276 |
$4,276 |
$4,276 |
$ - |
|
| Average Net Revenue Per Procedure |
$2,841 |
$2,841 |
$2,841 |
$2,841 |
$2,841 |
$ - |
|
| Average Cost Per Procedure |
$2,532 |
$2,532 |
$2,014 |
$2,014 |
$2,014 |
($518) |
|
| Average Profit Per Procedure |
$309 |
$309 |
$828 |
$828 |
$828 |
$519 |
LaraRoelofs1
proformalithofinances-1.xlsx
