{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["General Instructions","Instructions Enabling Macros","Basic Information","COPA & ACO Checklist","Financial Information","Attestation","Phase I","Phase II","Glossary","Trend Analysis"],"not_rendered":{"charts":1,"images":6,"macros":1,"external_links":0,"defined_names":10,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"General Instructions","index":0,"n_rows":32,"n_cols":3,"rows_kept":32,"cut":false,"hidden":false,"merged":[[31,0,31,2],[11,0,11,2],[21,0,21,2],[22,0,22,1],[23,0,23,1],[28,0,28,1],[18,1,18,2],[19,1,19,2],[25,0,25,2],[26,0,26,1],[27,0,27,1]]}
[]
[]
[]
[null,null,"New York Department of Health"]
[null,null,"Delivery System Reform Incentive Payment (DSRIP) Program"]
[]
[null,null,"PPS Lead & Financial Stability Test"]
[null,null,"General Instructions"]
[]
[]
[]
["General Instructions"]
["Step","Description","Image or Link (if applicable)"]
[1,"Click \"Enable Content\" at the top of the screen. "]
[2,"Enter Basic Information - required fields are highlighted in blue","Click to Enter Basic Information"]
[3,"Complete COPA & ACO Checklist - Step 4 will ONLY become available upon checklist completion","Click to Complete COPA & ACO Checklist"]
[4,"Enter Financial Information -  required fields are highlighted in blue\n(COPA & ACO Checklist Must Be Completed to Access Financial Information Page)","Click to Enter Financial Information"]
[5,"Print and sign attestation and submit via email to DSRIPApp@health.ny.gov","Click to Sign Attestation"]
[6,"Save Financial Stability test using the following naming convention \"PPS Name_DSRIP Financial Stability Test_MM/DD/YYYY\""]
[7,"Email financial Stability test along with audited financial statements to DSRIPApp@health.ny.gov"]
[]
["Resources"]
["Resource",null,"Link or Contact"]
["Glossary of Terms and Formulas",null,"Click to View Glossary of Terms and Formulas"]
[]
["Stability Test Results"]
["Stability Test Phase",null,"Link"]
["Stability Test Phase I Results (available upon completion of Financial Information)",null,"Click to View Phase I Results"]
["Stability Test Phase II Results (availability contingent on passing Phase I)",null,"Click to View Phase II Results"]
[]
[]
["If you are having difficulty enabling macros, please click here for detailed instructions"]

{"sheet":"Instructions Enabling Macros","index":1,"n_rows":6,"n_cols":1,"rows_kept":6,"cut":false,"hidden":false,"merged":[[6,0,6,11],[7,0,7,11],[2,0,2,11],[0,0,0,11],[1,0,1,11],[3,0,3,11],[4,0,4,11],[5,0,5,11]]}
["If Security Warnings do not display automatically, please follow the instructions below:"]
["1. Click \"File\" or the Microsoft Office Button Button image"]
["2. From the File menu select \"Options\""]
["3. Select \"Trust Center\", then click \"Trust Center Settings\""]
[]
["4 Click \"Macro Settings\" and select Select \"Disable All Macros with Notification\""]

{"sheet":"Basic Information","index":2,"n_rows":49,"n_cols":5,"rows_kept":49,"cut":false,"hidden":true,"merged":[[16,0,16,1],[11,0,11,1],[22,0,22,1],[37,0,37,1]]}
[]
[]
[]
[null,"New York Department of Health"]
[null,"Delivery System Reform Incentive Payment (DSRIP) Program"]
[]
[null,"PPS Lead & Financial Stability Test"]
[null,"PPS Lead Description"]
[]
[]
[]
["(Group Lead Members/Lead Applicant) Lead Facility #1",null,null,"Please Select","Please Select"]
["PPS Name",null,null,"Yes","Group"]
["PPS Number",null,null,"No","Single"]
["Lead Applicant","Please Select"]
[]
["(Group Lead Members/Lead Applicant) Lead Facility #1"]
["Name"]
["Phone Number"]
["Phone Number Extension"]
["Email"]
[]
["(Group Lead Members/Lead Applicant) Lead Facility #1"]
["Organization Name"]
["Provider Type"]
["Public ","Please Select"]
["IAAF Recipient"]
["MMIS #"]
["Address"]
["City"]
["State"]
["Zip"]
["Fiscal Year Start Date:"]
["Fiscal Year End Date:"]
[]
[]
[]
["(Group Lead Members/Lead Applicant) Lead Facility #2"]
["Organization Name"]
["Provider Type: "]
["Public ","Please Select"]
["IAAF Recipient: "]
["MMIS #"]
["Address"]
["City"]
["State"]
["Zip"]
["Fiscal Year Start Date:"]
["Fiscal Year End Date:"]

{"sheet":"COPA & ACO Checklist","index":3,"n_rows":19,"n_cols":2,"rows_kept":19,"cut":false,"hidden":true,"merged":[[12,0,12,1],[14,0,14,1],[16,0,16,1],[18,0,18,1]]}
[]
[]
[]
[null,"New York Department of Health"]
[null,"Delivery System Reform Incentive Payment (DSRIP) Program"]
[]
[null,"PPS Lead & Financial Stability Test"]
[null,"PPS Lead Provider Financial Stability"]
[null,"COPA & ACO Checklist"]
[]
[]
[]
["Certificate of Public Advantage"]
["Is the PPS applying for a Certificate of Public Advantage (COPA) as part of the application?"]
["If yes, please ensure the PPS completes the COPA application to facilitate the necessary review."]
[]
["Accountable Care Organization (ACO)"]
["Is the PPS applying to become an Accountable Care Organization (ACO) as part of this application?"]
["If yes, please ensure the PPS completes the ACO application to facilitate the necessary review."]

{"sheet":"Financial Information","index":4,"n_rows":39,"n_cols":9,"rows_kept":39,"cut":false,"hidden":true,"merged":[[14,0,14,5],[24,0,24,5],[10,0,12,3]]}
[]
[]
[]
[null,null,null,"New York Department of Health"]
[null,null,null,"Delivery System Reform Incentive Payment (DSRIP) Program"]
[]
[null,null,null,"PPS Lead & Financial Stability Test"]
[null,null,null,"PPS Lead Provider Financial Stability"]
[null,null,null,"Required Financial Data"]
[]
["Note: PDF versions of the PPS Lead's audited 2012 and 2013 financial statements as well as 2014 Year to Date financial statement data must be submitted via email to DSRIPApp@health.ny.gov in addition to completed stress test tool. \nPlease complete all fields highlighted in light blue below. "]
[]
[]
[]
["INCOME STATEMENT"]
["Income Statement",2012,2013,"YTD 2014","Change 2012 – 2013","Change 2013 – 2014"]
["Total Operating Revenues",null,null,null,{"$f":"C17-B17","v":0},0]
["Total Revenues",null,null,null,0,0]
["Total Operating Expense",null,null,null,0,{"$f":"D19-C19","v":0},null,{"$f":"IF(I30=0,\"Complete\",\"Incomplete\")","v":"Incomplete"}]
["Depreciation & Amortization Expense",null,null,null,0,0]
["Interest Expense",null,null,null,0,0]
["Total Expense",null,null,null,0,0]
["Excess of Revenue Over Expenses (Net Income)",{"$f":"B18-B22","v":0},{"$f":"C18-C22","v":0},{"$f":"D18-D22","v":0},0,0]
[]
["BALANCE SHEET"]
["Balance Sheet",2012,2013,"YTD 2014","Change 2012 – 2013","Change 2013 – 2014"]
["Unrestricted Cash and Cash Equivalents",null,null,null,{"$f":"C27-B27","v":0},{"$f":"D27-C27","v":0}]
["Unrestricted Investments",null,null,null,{"$f":"C28-B28","v":0},{"$f":"D28-C28","v":0}]
["Net Patient Accounts Receivable",null,null,null,0,0]
["Current Assets",null,null,null,0,0,null,null,{"$f":"COUNTBLANK( B27:D38 )","v":33}]
["Gross Fixed Assets",null,null,null,0,0]
["Accumulated Depreciation",null,null,null,{"$f":"C32-B32","v":0},0]
["Net Fixed Assets",{"$f":"B31-B32","v":0},{"$f":"C31-C32","v":0},{"$f":"D31-D32","v":0},0,0]
["Unrestricted Net Assets",null,null,null,{"$f":"C34-B34","v":0},{"$f":"D34-C34","v":0}]
["Total Assets",null,null,null,0,0,{"$f":"IF(OR(D35=0,C35=0,B35=0),\"\",IF(OR(D35<SUM(D30,D33),C35<SUM(C30,C33),B35<SUM(B30,B33)),\"Error: Sum of Current Assets and Net Fixed Assets less than Total Assets\",\"\"))","v":""}]
["Current Liabilities",null,null,null,0,0]
["Long-term Debt",null,null,null,0,0]
["Total Liabilities",null,null,null,0,0,{"$f":"IF(OR(D38=0,C38=0,B38=0),\"\",IF(OR(D38<SUM(D36:D37),C38<SUM(C36:C37),B38<SUM(B36:B37)),\"Error: Sum of Current Liabilities and Long-term Debt less than Total Liabilities\",\"\"))","v":""}]
["Fund Balance",{"$f":"B35-B38","v":0},{"$f":"C35-C38","v":0},{"$f":"D35-D38","v":0},0,0]

{"sheet":"Attestation","index":5,"n_rows":25,"n_cols":2,"rows_kept":25,"cut":false,"hidden":true,"merged":[[19,0,19,1],[11,0,12,1],[15,1,16,1],[24,0,24,1],[25,0,25,1]]}
[]
[]
[]
[null,"New York Department of Health"]
[null,"Delivery System Reform Incentive Payment (DSRIP) Program"]
[]
[null,"PPS Lead & Financial Stability Test"]
[null,"PPS Lead Provider Financial Stability"]
[null,"Attestation"]
[]
[]
["The lead applicant of the Performing Provider System [PPS] must sign this attestation form in order for the project application to be valid. Print and sign attestation and submit via email to DSRIPApp@health.ny.gov"]
[]
[]
["Check the following:"]
[]
[]
[]
[]
["(Group Lead Members/Lead Applicant) Lead Facility #1"]
["Lead Provider Name"]
["Name of Authorized Officer"]
["Date"]
[]
["Authorized Officer Signature"]

{"sheet":"Phase I","index":6,"n_rows":32,"n_cols":19,"rows_kept":32,"cut":false,"hidden":true,"merged":[[31,0,32,9],[11,0,11,9],[26,0,26,9],[27,1,27,8],[29,1,29,8],[28,1,28,8],[18,0,18,9],[19,0,19,1],[24,0,24,1],[20,0,20,1],[22,0,22,1],[21,0,21,1],[23,0,23,1],[14,9,16,9]]}
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"New York Department of Health"]
[null,null,null,null,null,null,null,null,null,"Delivery System Reform Incentive Payment (DSRIP) Program"]
[]
[null,null,null,null,null,null,null,null,null,"PPS Lead & Financial Stability Test"]
[null,null,null,null,null,null,null,null,null,"PPS Lead Provider Financial Stability"]
[null,null,null,null,null,null,null,null,null,"Phase I: Current Provider Financial Stability Metrics"]
[]
[]
["PHASE I - MANDATORY (Must Pass ALL Four) "]
["Financial Metrics","NY Average","Threshold",2012,2013,"YTD 2014","2012 Results","2013 Results","2014 Results","Minimum One Year Positive Operating Margin"]
["Operating Margin",2.3999999999999998E-3,-5.96E-2,{"$f":"IFERROR(('Financial Information'!B17-'Financial Information'!B19)/'Financial Information'!B17,\"Missing Data\")","v":"Missing Data"},{"$f":"IFERROR(('Financial Information'!C17-'Financial Information'!C19)/'Financial Information'!C17,\"Missing Data\")","v":"Missing Data"},{"$f":"IFERROR(('Financial Information'!D17-'Financial Information'!D19)/'Financial Information'!D17,\"Missing Data\")","v":"Missing Data"},{"$f":"D14","v":"Missing Data"},{"$f":"E14","v":"Missing Data"},{"$f":"F14","v":"Missing Data"},{"$f":"IF(OR(D14=\"Missing Data\",E14=\"Missing Data\",F14=\"Missing Data\"),\"Missing Data\",IF(OR(D14>0,E14>0,F14>0),1,0))","v":"Missing Data"},{"$f":"IF(D14=\"Missing Data\",0,IF(D14>$C14,1,0))","v":0},{"$f":"IF(E14=\"Missing Data\",0,IF(E14>$C14,1,0))","v":0},{"$f":"IF(F14=\"Missing Data\",0,IF(F14>$C14,1,0))","v":0},{"$f":"IF(J14=1,1,0)","v":0}]
["Current Ratio",1.66,0.82,{"$f":"IFERROR('Financial Information'!B30/'Financial Information'!B36, \"Missing Data\")","v":"Missing Data"},{"$f":"IFERROR('Financial Information'!C30/'Financial Information'!C36, \"Missing Data\")","v":"Missing Data"},{"$f":"IFERROR('Financial Information'!D30/'Financial Information'!D36, \"Missing Data\")","v":"Missing Data"},{"$f":"D15","v":"Missing Data"},{"$f":"E15","v":"Missing Data"},"Missing Data",null,{"$f":"IF(D15=\"Missing Data\",0,IF(D15>$C15,1,0))","v":0},0,{"$f":"IF(F15=\"Missing Data\",0,IF(F15>$C15,1,0))","v":0}]
["Days Cash on Hand",64.819999999999993,20,{"$f":"IFERROR(('Financial Information'!B27+'Financial Information'!B28)/(('Financial Information'!B19-'Financial Information'!B20)/365),\"Missing Data\")","v":"Missing Data"},{"$f":"IFERROR(('Financial Information'!C27+'Financial Information'!C28)/(('Financial Information'!C19-'Financial Information'!C20)/365),\"Missing Data\")","v":"Missing Data"},{"$f":"IFERROR(('Financial Information'!D27+'Financial Information'!D28)/(('Financial Information'!D19-'Financial Information'!D20)/243),\"Missing Data\")","v":"Missing Data"},{"$f":"D16","v":"Missing Data"},"Missing Data","Missing Data",null,0,0,0]
["Cash Flow to Total Debt",7.8E-2,-4.9200000000000001E-2,{"$f":"IFERROR((('Financial Information'!B17-'Financial Information'!B19)+('Financial Information'!B20+'Financial Information'!B21))/('Financial Information'!B36+'Financial Information'!B37),\"Missing Data\")","v":"Missing Data"},{"$f":"IFERROR((('Financial Information'!C17-'Financial Information'!C19)+('Financial Information'!C20+'Financial Information'!C21))/('Financial Information'!C36+'Financial Information'!C37),\"Missing Data\")","v":"Missing Data"},{"$f":"IFERROR((('Financial Information'!D17-'Financial Information'!D19)+('Financial Information'!D20+'Financial Information'!D21))/('Financial Information'!D36+'Financial Information'!D37),\"Missing Data\")","v":"Missing Data"},{"$f":"D17","v":"Missing Data"},"Missing Data","Missing Data",null,0,0,0]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(K14:N17)","v":0}]
["PHASE I - ADDITIONAL (Must Pass Three of Five)"]
["Financial Metrics",null,"NY Average","Threshold",2012,2013,"YTD 2014","2012 Results","2013 Results","2014 Results"]
["Debt Ratio ",null,0.67100000000000004,0.95069999999999999,{"$f":"IFERROR(('Financial Information'!B38/'Financial Information'!B35),\"Missing Data\")","v":"Missing Data"},{"$f":"IFERROR(('Financial Information'!C38/'Financial Information'!C35),\"Missing Data\")","v":"Missing Data"},{"$f":"IFERROR(('Financial Information'!D38/'Financial Information'!D35),\"Missing Data\")","v":"Missing Data"},{"$f":"E21","v":"Missing Data"},{"$f":"F21","v":"Missing Data"},{"$f":"G21","v":"Missing Data"},{"$f":"IF(E21=\"Missing Data\",0,IF(E21<$D21,1,0))","v":0},0,0]
["Fixed Asset Financing Ratio",null,1.147,1.5315000000000001,{"$f":"IFERROR(('Financial Information'!B38-'Financial Information'!B36)/('Financial Information'!B35-'Financial Information'!B30), \"Missing Data\")","v":"Missing Data"},{"$f":"IFERROR(('Financial Information'!C38-'Financial Information'!C36)/('Financial Information'!C35-'Financial Information'!C30), \"Missing Data\")","v":"Missing Data"},{"$f":"IFERROR(('Financial Information'!D38-'Financial Information'!D36)/('Financial Information'!D35-'Financial Information'!D30), \"Missing Data\")","v":"Missing Data"},{"$f":"E22","v":"Missing Data"},"Missing Data","Missing Data",0,0,0,null,null,null,null,null,"A PPS lead that has failed a DSRIP Financial Stability test may potentially still serve as a PPS Lead.  If applicable, please submit documentation of any documentation that would support the proposed PPS Lead’s financial stability throughout the five year DSRIP demonstration period. This could include a binding agreement to provide financial support from another safety net provider or information outlining the recent purchasing and/or assuming some control of a fragile safety net provider, which has resulted in short term financial implications to a historically financial stable entity.  As applicable, this documentation should be submitted to the Independent Assessor for consideration and review."]
["Return on Total Assets",null,2E-3,-0.06,{"$f":"IFERROR(('Financial Information'!B17-'Financial Information'!B19)/('Financial Information'!B35),\"Missing Data\")","v":"Missing Data"},{"$f":"IFERROR(('Financial Information'!C17-'Financial Information'!C19)/('Financial Information'!C35),\"Missing Data\")","v":"Missing Data"},{"$f":"IFERROR(('Financial Information'!D17-'Financial Information'!D19)/('Financial Information'!D35),\"Missing Data\")","v":"Missing Data"},"Missing Data","Missing Data","Missing Data",{"$f":"IF(E23=\"Missing Data\",0,IF(E23>$D23,1,0))","v":0},0,0]
["Total Asset Turnover ",null,0.93,0.55000000000000004,{"$f":"IFERROR('Financial Information'!B17/'Financial Information'!B35,\"Missing Data\")","v":"Missing Data"},{"$f":"IFERROR('Financial Information'!C17/'Financial Information'!C35,\"Missing Data\")","v":"Missing Data"},{"$f":"IFERROR('Financial Information'!D17/'Financial Information'!D35,\"Missing Data\")","v":"Missing Data"},"Missing Data","Missing Data","Missing Data",0,0,0]
["Operating Cash Flow Margin  ",null,5.6399999999999999E-2,-1.1999999999999999E-3,{"$f":"IFERROR((('Financial Information'!B17-'Financial Information'!B19)+'Financial Information'!B20+'Financial Information'!B21)/'Financial Information'!B17,\"Missing Data\")","v":"Missing Data"},{"$f":"IFERROR((('Financial Information'!C17-'Financial Information'!C19)+'Financial Information'!C20+'Financial Information'!C21)/'Financial Information'!C17,\"Missing Data\")","v":"Missing Data"},{"$f":"IFERROR((('Financial Information'!D17-'Financial Information'!D19)+'Financial Information'!D20+'Financial Information'!D21)/'Financial Information'!D17,\"Missing Data\")","v":"Missing Data"},"Missing Data","Missing Data","Missing Data",0,0,0]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(K21:K25)","v":0},{"$f":"SUM(L21:L25)","v":0},{"$f":"SUM(M21:M25)","v":0}]
["PHASE I - OVERALL RESULTS"]
["Mandatory",{"$f":"IF(K18>12,\"Mandatory requirements met\",\"One or more mandatory requirements not met\")","v":"One or more mandatory requirements not met"},null,null,null,null,null,null,null,{"$f":"K28","v":0},{"$f":"IF(B28=\"Mandatory requirements met\",1,0)","v":0}]
["Additional",{"$f":"IF(AND(K26>2,L26>2,M26>2),\"Three or more additional requirements met\", \"A minimum of three out of five additional requirements not met\")","v":"A minimum of three out of five additional requirements not met"},null,null,null,null,null,null,null,{"$f":"K29","v":0},{"$f":"IF(B29=\"Three or more additional requirements met\",1,0)","v":0}]
["Final",{"$f":"IF(AND(B28=\"Mandatory requirements met\",B29=\"Three or more additional requirements met\"),\"PASS - Approved for Phase II Review\",\"FAIL - Will not proceed to Independent Assessor review\")","v":"FAIL - Will not proceed to Independent Assessor review"},null,null,null,null,null,null,null,{"$f":"K30","v":0},{"$f":"IF(B30=\"PASS - Approved for Phase II Review\",1,0)","v":0}]
[]
[{"$f":"IF(B30=\"FAIL - Will not proceed to Independent Assessor review\",S22,\"\")","v":"A PPS lead that has failed a DSRIP Financial Stability test may potentially still serve as a PPS Lead.  If applicable, please submit documentation of any documentation that would support the proposed PPS Lead’s financial stability throughout the five year DSRIP demonstration period. This could include a binding agreement to provide financial support from another safety net provider or information outlining the recent purchasing and/or assuming some control of a fragile safety net provider, which has resulted in short term financial implications to a historically financial stable entity.  As applicable, this documentation should be submitted to the Independent Assessor for consideration and review."}]

{"sheet":"Phase II","index":7,"n_rows":17,"n_cols":10,"rows_kept":17,"cut":false,"hidden":true,"merged":[[14,1,14,3],[16,0,17,3]]}
[]
[]
[]
[null,null,null,"New York Department of Health"]
[null,null,null,"Delivery System Reform Incentive Payment (DSRIP) Program"]
[]
[null,null,null,"PPS Lead & Financial Stability Test"]
[null,null,null,"PPS Lead Provider Financial Stability"]
[null,null,null,"Phase II: Predicted Provider Financial Stability Metrics"]
[]
[]
["Financial Metrics","Metric",2013,"2013 Results"]
["Financial Strength Index (FSI)",-9,{"$f":"(((('Financial Information'!C18-'Financial Information'!C22)/'Financial Information'!C18)-0.04)/0.04)+(('Phase I'!E16-50)/50)-(((('Financial Information'!C35-'Financial Information'!C39)/'Financial Information'!C35)-0.5)/0.5)-(('Financial Information'!C32/'Financial Information'!C20-9)/9)","v":{"$error":"#DIV/0!"}},{"$f":"C13","v":{"$error":"#DIV/0!"}},null,null,{"$f":"IF((C13>$B13),\"Pass\",\"Fail\")","v":{"$error":"#DIV/0!"}}]
["Altman Z Score",-2,{"$f":"6.56*(('Financial Information'!C30-'Financial Information'!C36)/'Financial Information'!C35)+3.26*('Financial Information'!C39/'Financial Information'!C35)+6.72*('Financial Information'!C23/'Financial Information'!C35)+1.05*'Financial Information'!C39/'Financial Information'!C38","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,null,{"$f":"IF((C14>$B14),\"Pass\",\"Fail\")","v":{"$error":"#DIV/0!"}}]
["Final",{"$f":"IF(G15=\"1\",\"PASS - Approved for Independent Assessor review\",\"FAIL - Will not proceed to Independent Assessor review\")","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"IF(AND(G13=\"Pass\",G14=\"Pass\"),\"1\",\"0\")","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,"A PPS lead that has failed a DSRIP Financial Stability test may potentially still serve as a PPS Lead.  If applicable, please submit documentation of any documentation that would support the proposed PPS Lead’s financial stability throughout the five year DSRIP demonstration period. This could include a binding agreement to provide financial support from another safety net provider or information outlining the recent purchasing and/or assuming some control of a fragile safety net provider, which has resulted in short term financial implications to a historically financial stable entity.  As applicable, this documentation should be submitted to the Independent Assessor for consideration and review."]
[{"$f":"IF(B15=\"FAIL - Will not proceed to Independent Assessor review\",J16,\"\")","v":{"$error":"#DIV/0!"}}]

{"sheet":"Glossary","index":8,"n_rows":33,"n_cols":2,"rows_kept":33,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[null,"New York Department of Health"]
[null,"Delivery System Reform Incentive Payment (DSRIP) Program"]
[]
[null,"PPS Lead & Financial Stability Test"]
[null,"Glossary of Terms and Formulas"]
[]
[]
["Phase I Ratios","Formula"]
["Operating Margin","(Total Operating Revenue - Total Operating Expense)/Total Operating Revenue"]
["Current Ratio","Current Assets/Current Liabilities"]
["Days Cash on Hand","(Unrestricted Cash & Cash Equivalents + Unrestricted Investments)/((Total Operating Expense - Depreciation)/365)"]
["Cash Flow to Total Debt","((Total Operating Revenue - Total Operating Expense)+Depreciation+Interest)/(Current Liabilities + Long Term Debt)"]
["Debt Ratio","(Total Liabilities/Total Assets)*100"]
["Fixed Asset Financing Ratio","(Total Liabilities - Current Liabilities)/(Total Assets - Total Current Assets)"]
["Return on Total Assets","(Total Operating Revenue - Total Operating Expense)/(Total Assets)"]
["Total Asset Turnover","Total Operating Revenue/Total Assets"]
["Operating Cash Flow Margin","((Total Operating Revenue-Total Operating Expenses)+Depreciation+Interest)/Total Operating Revenue"]
[]
["Phase II Models","Formula"]
["Financial Strength Index (FSI)","((Total Margin -4)/4) +((Days Cash on Hand-50)/50) - ((Debt Financing %-50)/50) - ((Age of Plant-9)/9)"]
["Altman Z-Score","6.56(Net Working Capital/Total Assets)+3.26(Net Assets/Total Assets)+6.72(Excess Revenue over Expenses/Total Assets)+1.05(Fund Balance/Total Liabilities)"]
[]
["Ratios used in Phase II Models","Formula"]
["Total Margin","(Total Revenue - Total Expense)/Total Revenue*100"]
["Days Cash on Hand","(Unrestricted Cash & Cash Equivalents + Unrestricted Investments)/((Total Operating Expense - Depreciation)/365)"]
["Debt Financing %","(Total Assets - Net Assets)/Total Assets*100"]
["Age of Plant","Accumulated Depreciation/Depreciation Expense"]
["Net Working Capital","Current Assets - Current Liabilities"]
["Excess Revenue over Expenses","Total Revenue - Total Expenses"]
["Fund Balance","Total Assets - Total Liabilities"]

{"sheet":"Trend Analysis","index":9,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":true,"merged":[[0,0,0,2]]}
["Trend Analysis"]
["Financial Metrics","Variance 2012 - 2013","Variance 2013 - 2014"]
["Operating Margin",{"$f":"IFERROR(('Phase I'!E14-'Phase I'!D14)/'Phase I'!D14,\"Missing Data\")","v":"Missing Data"},{"$f":"IFERROR(('Phase I'!F14-'Phase I'!E14)/'Phase I'!E14,\"Missing Data\")","v":"Missing Data"}]
["Current Ratio",{"$f":"IFERROR(('Phase I'!E15-'Phase I'!D15)/'Phase I'!D15,\"Missing Data\")","v":"Missing Data"},{"$f":"IFERROR(('Phase I'!F15-'Phase I'!E15)/'Phase I'!E15,\"Missing Data\")","v":"Missing Data"}]
["Days Cash on Hand*",{"$f":"IFERROR(('Phase I'!E16-'Phase I'!D16)/'Phase I'!D16,\"Missing Data\")","v":"Missing Data"},{"$f":"IFERROR(('Phase I'!F16-'Phase I'!E16)/'Phase I'!E16,\"Missing Data\")","v":"Missing Data"}]
["Cash Flow to Total Debt",{"$f":"IFERROR(('Phase I'!E17-'Phase I'!D17)/'Phase I'!D17,\"Missing Data\")","v":"Missing Data"},{"$f":"IFERROR(('Phase I'!F17-'Phase I'!E17)/'Phase I'!E17,\"Missing Data\")","v":"Missing Data"}]
["Debt Ratio ",{"$f":"IFERROR(('Phase I'!F21-'Phase I'!E21)/'Phase I'!E21,\"Missing Data\")","v":"Missing Data"},{"$f":"IFERROR(('Phase I'!G21-'Phase I'!F21)/'Phase I'!F21,\"Missing Data\")","v":"Missing Data"}]
["Fixed Asset  Financing Ratio",{"$f":"IFERROR(('Phase I'!F22-'Phase I'!E22)/'Phase I'!E22,\"Missing Data\")","v":"Missing Data"},{"$f":"IFERROR(('Phase I'!G22-'Phase I'!F22)/'Phase I'!F22,\"Missing Data\")","v":"Missing Data"}]
["Return on Total Assets",{"$f":"IFERROR(('Phase I'!F23-'Phase I'!E23)/'Phase I'!E23,\"Missing Data\")","v":"Missing Data"},{"$f":"IFERROR(('Phase I'!G23-'Phase I'!F23)/'Phase I'!F23,\"Missing Data\")","v":"Missing Data"}]
["Total Asset Turnover ",{"$f":"IFERROR(('Phase I'!F24-'Phase I'!E24)/'Phase I'!E24,\"Missing Data\")","v":"Missing Data"},{"$f":"IFERROR(('Phase I'!G24-'Phase I'!F24)/'Phase I'!F24,\"Missing Data\")","v":"Missing Data"}]
["Operating Cash Flow Margin  ",{"$f":"IFERROR(('Phase I'!F25-'Phase I'!E25)/'Phase I'!E25,\"Missing Data\")","v":"Missing Data"},{"$f":"IFERROR(('Phase I'!G25-'Phase I'!F25)/'Phase I'!F25,\"Missing Data\")","v":"Missing Data"}]