Velarion Records

Public registries, as they were filed.

Medicare cost report · CMS certification number 520204

WHEATON FRANCISCAN - FRANKLIN

FRANKLIN, Wisconsin · short-term acute care hospital

Figures for 1 July 2017 to 31 May 2018 — a reporting period of 334 days, on form CMS-2552-10, settled.

Finances, as filed

From this hospital’s Medicare cost report for the year ended 31 May 2018.

FigureAs filedWhere it comes from
Total patient revenue$249,883,957CMS-2552-10 worksheet G300000 line 100 column 100
Contractual allowances$160,950,150CMS-2552-10 worksheet G300000 line 200 column 100
Net patient revenue$88,933,807CMS-2552-10 worksheet G300000 line 300 column 100
Total operating expenses$59,137,898CMS-2552-10 worksheet G300000 line 400 column 100
Income from service to patients$29,795,909CMS-2552-10 worksheet G300000 line 500 column 100
Charity care, at charges$2,439,866CMS-2552-10 worksheet S100000 line 2000 column 300
Charity care, at cost$1,124,155CMS-2552-10 worksheet S100000 line 2300 column 300
Bad debt expense$3,885,017CMS-2552-10 worksheet S100000 line 2600 column 100
Bad debt other than Medicare, at cost$1,061,403CMS-2552-10 worksheet S100000 line 2900 column 100
Uncompensated care, at cost$2,185,558CMS-2552-10 worksheet S100000 line 3000 column 100
Total facility beds44CMS-2552-10 worksheet S300001 line 1400 column 200
Cost-to-charge ratio0.2683CMS-2552-10 worksheet S100000 line 100 column 100

Cost report filed under CMS certification number 520204 for 1 July 2017 to 31 May 2018, settled. The public file it was read from.

Where this hospital sits among its peers

A position, not a score: the hospitals are counted, not ranked. Each line names the hospitals the position was taken over.

  • 87thpercentile of 68 hospitals in WI, same facility class, 25 to 49 bedsNet patient revenue

Net patient revenue across every hospital filing for 2018, with this one marked.

This hospital$9,722,859$450,008,741

Middle half between $19,078,025 and $184,735,005, midpoint $51,731,588, across 5,809 hospitals.

  • 78thpercentile of 68 hospitals in WI, same facility class, 25 to 49 bedsTotal operating expenses

Total operating expenses across every hospital filing for 2018, with this one marked.

This hospital$11,109,652$445,400,155

Middle half between $20,131,699 and $180,047,211, midpoint $53,821,376, across 5,994 hospitals.

  • 63rdpercentile of 16 hospitals in WI, same facility class, 25 to 49 bedsCharity care, at cost
  • 59thpercentile of 17 hospitals in WI, same facility class, 25 to 49 bedsUncompensated care, at cost
  • 81stpercentile of 68 hospitals in WI, same facility class, 25 to 49 bedsTotal facility beds

Total facility beds across every hospital filing for 2018, with this one marked.

This hospital20329

Middle half between 25 and 172, midpoint 66, across 5,989 hospitals.

  • 33rdpercentile of 18 hospitals in WI, same facility class, 25 to 49 bedsCost-to-charge ratio

Cost-to-charge ratio across every hospital filing for 2018, with this one marked.

This hospital0.14270.7042

Middle half between 0.2017 and 0.4774, midpoint 0.2956, across 4,702 hospitals.

Every cost report on file

One row per filing, oldest first until you say otherwise. Every column orders both ways. Reporting periods differ between filings and the length of each is shown, because revenue over three months set beside revenue over twelve is a wrong number that looks right.

10 hospitals, ordered by Fiscal year
Fiscal year Period ended Days Form Status Beds Net patient revenue Total operating expenses Income from service to patients Charity care, at cost Uncompensated care, at cost Bad debt expense Cost-to-charge ratio Stamped by CMS
20092009-06-30312CMS-2552-96settled10$25,949,389$33,000,689−$7,051,3002010-09-24
20102010-06-30364CMS-2552-96settled10$32,081,148$34,476,548−$2,395,4002013-11-27
20112011-06-30364CMS-2552-10settled19$41,150,551$40,223,513$927,038$964,737$2,204,4270.44552013-11-27
20122012-06-30365CMS-2552-10settled24$53,317,560$49,743,133$3,574,427$617,286$1,473,334$2,589,7300.34082014-07-23
20132013-06-30364CMS-2552-10settled32$63,214,634$61,569,009$1,645,625$530,029$1,507,975$3,091,3010.32722015-06-12
20142014-06-30364CMS-2552-10settled37$64,968,732$64,351,207$617,525$1,120,753$3,614,216$7,584,0270.33282016-02-10
20152015-06-30364CMS-2552-10reopened37$71,651,539$70,242,321$1,409,218$602,302$1,991,421$4,257,0150.32542018-01-24
20162016-06-30365CMS-2552-10settled44$84,013,483$81,584,518$2,428,965$660,626$1,824,889$3,576,6020.32422018-10-13
20172017-06-30364CMS-2552-10settled44$86,000,718$79,944,057$6,056,661$953,740$1,716,203$2,603,0220.29012021-03-23
20182018-05-31334CMS-2552-10settled44$88,933,807$59,137,898$29,795,909$1,124,155$2,185,558$3,885,0170.26832021-10-20

Take these figures as a spreadsheet The full report for this hospital

Every figure on this page is printed as it appears in this hospital’s Medicare cost report, filed under CMS certification number 520204 on form CMS-2552-10, publication year 2017, file HOSP10FY2017.ZIP.

The full report for WHEATON FRANCISCAN - FRANKLIN

Every figure on this page as a document you can keep, file or send on: the finances as filed with the worksheet, line and column each one came from, five hospitals of a similar size in the same state, the contract-pharmacy network year by year, and what changed on the record.