{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["License Agreement","Name and version info","Instructions","assets","liabilities","coverage","All money market fund detail","Checking P-1 Rated Bank","Repo","TreasAgen<2yrs","2yrs<=TreasAgen<10yrs","TreasAgen>=10yrs","Other Daily Assets"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":12,"defined_names":320,"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":"License Agreement","index":0,"n_rows":216,"n_cols":2,"rows_kept":216,"cut":false,"hidden":false,"merged":[[0,1,0,14],[215,1,215,14]]}
[null,"Please take a moment to read the license agreement now.  If you accept the terms below, tick \"I AGREE\" at the bottom of the agreement."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"=============================================================================================================================="]

{"sheet":"Name and version info","index":1,"n_rows":11,"n_cols":2,"rows_kept":11,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
["Qtools ID",2236]
["Type of tool or model","Other Quantitative Tool"]
[]
[]
[]
[{"$f":"+B6&\" Name:\"","v":"Other Quantitative Tool Name:"},"Self-Liquidity Worksheet"]
[{"$f":"+B6&\" Version:\"","v":"Other Quantitative Tool Version:"},"2.1"]

{"sheet":"Instructions","index":2,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":true,"merged":[[0,0,27,0]]}
["Enclosed please find Moody's self-liquidity reporting worksheet. If you have any questions on completing the worksheet, please feel free to contact your lead analyst.\nFor more detail on Moody's self-liquidity rating methodology, please refer  to \"Short-term Debt of US States, Municipalities, and Nonprofits Methodology\", published July 10, 2020.\n\nThe worksheet has four formatted tabs: \n1) Assets, which captures daily liquid assets available to support the self liquidity program; \n2) Liabilities, which includes debt liabilities supported by the self-liquidity program; \n3) Coverage, which calculates self-liquidity coverage ratios;\n4) Money market fund detail.\n\nThe worksheet pages are protected (locked) in order to prevent inadvertent adjustments of the calculated formulas.\n\nAfter completing the four formatted tabs, please provide detail of each asset category (including a list of the actual securities, maturities, amount) in the remaining corresponding tabs of the worksheet. \n\nInstructions for Assets tab: \n\n1) Please fill in only the yellow shaded cells.  \n2) All amounts should be net of amounts held by swap counterparties as collateral as of the reporting date, and should be net  \n    of amounts held by swap counterparties as collateral, as of the reporting date. \n3) All daily liquidity amounts should exclude securities held in a third party LLC or LP structure. \n4) Daily Liquidity: Amounts should only include asset that can be liquidated and accessed on a same-day basis \n5) Backup Bank Facilities: This section should capture bank facilities or credit agreements with P-1 rated banks and that meet Moody's criteria for inclusion as a source of daily liquidity (specifically limited automatic termination events).  This section should NOT include general operating lines of credit, standby bond purchase agreements or letters of credit.\n\nInstructions for Liabilities tab: \n\n1) Please fill in only the yellow shaded cells.  \n2) Variable rate bonds with frequent tenders: Only include debt amounts that are supported by your institution's own self liquidity program.  Variable rate demand bonds directly supported by a standby bond purchase agreement or letter of credit should not be included on this worksheet.\n3) Commercial paper: Only include commercial paper which is supported by self-liquidity. This section also includes variable rate demand bonds which are in a commercial paper (or like) mode.\n\nInstructions for All money market fund detail tab: \n\n1) Please fill in only the yellow shaded cells.\n2) Provide full name of money market fund in first column and ticker symbol in second column. Sponsor is the parent mutual fund company.\n"]

{"sheet":"assets","index":3,"n_rows":39,"n_cols":5,"rows_kept":39,"cut":false,"hidden":true,"merged":[[0,1,0,4],[8,1,8,4],[5,2,5,4],[1,2,1,4],[2,2,2,4],[3,2,3,4],[4,2,4,4]]}
[null,"       Moody's Self-Liquidity Worksheet"]
[null,"Institution Name:"]
[null,"Date of reported information (mm/dd/yy):"]
[null,"Name of person completing this form:"]
[null,"     Title:"]
[null,"     Phone Number/Email:"]
[]
[null,"ASSETS","Amount ($000)","Discount %","Discounted ($000)"]
[null,"DAILY LIQUIDITY-only include investments which can be liquidated on a same day basis; should not include securities held by third party LP or LLCs"]
[null,"Money Market Funds: SEC 2a-7, rated Aaa-mf by Moody’s",{"$f":"'All money market fund detail'!$B$22","v":0},0,{"$f":"C10*(1-D10)","v":0}]
[null,"Checking and deposit accounts at P-1 rated bank",null,0,0]
[null,"Repurchase Agreements: Overnight and collateralized by Treasuries/Agencies; P-1 rated counterparty",null,0.06,0]
[null,"US Treasuries & Agencies with less than 2-year maturity which have daily liquidity",null,0.06,0]
[null,"US Treasuries & Agencies with 2 to 10-year maturity which have daily liquidity",null,0.1,0]
[null,"US Treasuries & Agencies with 10-year or longer maturity which have daily liquidity",null,0.15,0]
[null,"Other",null,"Moody's determined",{"$f":"IF(D16=\"Moody's determined\",0,C16*(1-D16))","v":0}]
[null,"Total",{"$f":"SUM(C10:C16)","v":0},null,{"$f":"SUM(E10:E16)","v":0}]
[]
[]
[null," BACKUP BANK FACILITIES"]
[null,"Bank facilities (excluding standby bond purchase agreements and letters of credit)","Amount ($000)"]
[null,"Combined committed amount under bank facilities, provided by P-1 rated banks, that have been reviewed by Moody's ",{"$f":"SUM(C26:C36)","v":0}]
[null,"Combined amount drawn as of reporting date",{"$f":"SUM(D26:D36)","v":0}]
[null,"Remaining available amount",{"$f":"C22-C23","v":0}]
[null,"Name of Bank Provider","Committed Amount ($000)","Amount Drawn as of Reporting Date ($000)","Expiration Date of Bank Facility (mm/dd/yy)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"\"Version: v\" & Model_Version","v":"Version: v2.1"}]

{"sheet":"liabilities","index":4,"n_rows":17,"n_cols":3,"rows_kept":17,"cut":false,"hidden":true,"merged":[[8,4,10,4],[8,5,10,5],[15,2,15,3],[16,2,16,3]]}
["SHORT-TERM SELF-LIQUIDITY DEBT "]
["Variable Rate Demand Bonds with Frequent Tenders","Amount ($000)"]
["VRDBs in daily mode"]
["VRDBs in weekly mode"]
[]
["Commercial Paper (including VRDBs in CP mode)","Amount ($000)"]
["Combined full authorized amount of CP programs "]
["Amount of CP currently outstanding"]
["Maximum amount of CP that can mature within 5 business days (this number should be the full program authorized amount unless there are restrictions on maturities in issuing and paying agent agreement or indenture)"]
["Maximum amount of CP that has been outstanding at any point in time during the past 12 months"]
["Expected maximum amount of CP outstanding at any point over the next 6 months"]
["Expected maximum amount of CP outstanding at any point over the next 12 months"]
[]
[]
["DEBT TOTALS USED IN COVERAGE RATIOS"]
["Coverage Ratio","Amount ($000)","Description"]
["Coverage Ratio #1 and #1a",{"$f":"B3+B4+MIN(MAX($B$8,$B$11),$B$9)","v":0},"100% Daily & Weekly VRDBs + CP (higher outstanding or expected within 6 months; 5-day limit if lower)"]

{"sheet":"coverage","index":5,"n_rows":8,"n_cols":5,"rows_kept":8,"cut":false,"hidden":true,"merged":[[7,1,7,4]]}
["COVERAGE RATIOS"]
[null,"Discounted Assets in Ratio","With Backup Bank Facilities","Without Backup Bank Facilities","Sources of Liquidity"]
["Coverage Ratio #1: Short-term Self-Liquidity Debt with Frequent Tenders/Maturities","Daily liquidity",{"$f":"IF(ISERROR((DiscountedDailyLiquidity+AvailableBankFacility)/liabilities!$B$17),\"Not Specified\",(DiscountedDailyLiquidity+AvailableBankFacility)/LiabilitiesCoverageRatio1And1aAmount)","v":"Not Specified"},{"$f":"IF(ISERROR((DiscountedDailyLiquidity)/liabilities!$B$17),\"Not Specified\",(DiscountedDailyLiquidity)/LiabilitiesCoverageRatio1And1aAmount)","v":"Not Specified"},"Internal liquidity"]
["Coverage Ratio #1a (excluding largest money market investment with one sponsor) ","Daily liquidity",{"$f":"IF(ISERROR((DiscountedDailyLiquidity+AvailableBankFacility-LargestMoneyMarketHolding)/liabilities!$B$17),\"Not Specified\",(DiscountedDailyLiquidity+AvailableBankFacility-LargestMoneyMarketHolding)/LiabilitiesCoverageRatio1And1aAmount)","v":"Not Specified"},{"$f":"IF(ISERROR((DiscountedDailyLiquidity-LargestMoneyMarketHolding)/liabilities!$B$17),\"Not Specified\",(DiscountedDailyLiquidity-LargestMoneyMarketHolding)/LiabilitiesCoverageRatio1And1aAmount)","v":"Not Specified"},"Internal liquidity"]
[]
[]
["FAILED REMARKETINGS"]
["Have you had any failed remarketings of VRDBs or failed rollover of commercial paper over the past 12 months which required you to provide liquidity? If so, please provide details in the box to the right."]

{"sheet":"All money market fund detail","index":6,"n_rows":22,"n_cols":7,"rows_kept":22,"cut":false,"hidden":true,"merged":[]}
["MONEY MARKET FUND DETAIL"]
["Full Name of Money Market Fund","Ticker","Type of Fund","Sponsor","Amount as of reporting date ($000)"]
[null,null,{"$f":"A22","v":"SEC 2a-7, rated Aaa-mf by Moody's"},null,null,{"$f":"MoneyMarketFundDetailAmount1","v":0},{"$f":"SUMIF($D$3:$D$16,D3,$F$3:$F$16)","v":0}]
[null,null,"SEC 2a-7, rated Aaa-mf by Moody's",null,null,{"$f":"MoneyMarketFundDetailAmount2","v":0},0]
[null,null,"SEC 2a-7, rated Aaa-mf by Moody's",null,null,{"$f":"MoneyMarketFundDetailAmount3","v":0},0]
[null,null,"SEC 2a-7, rated Aaa-mf by Moody's",null,null,{"$f":"MoneyMarketFundDetailAmount4","v":0},0]
[null,null,"SEC 2a-7, rated Aaa-mf by Moody's",null,null,{"$f":"MoneyMarketFundDetailAmount5","v":0},0]
[null,null,"SEC 2a-7, rated Aaa-mf by Moody's",null,null,{"$f":"MoneyMarketFundDetailAmount6","v":0},0]
[null,null,"SEC 2a-7, rated Aaa-mf by Moody's",null,null,{"$f":"MoneyMarketFundDetailAmount7","v":0},0]
[null,null,"SEC 2a-7, rated Aaa-mf by Moody's",null,null,{"$f":"MoneyMarketFundDetailAmount8","v":0},0]
[null,null,"SEC 2a-7, rated Aaa-mf by Moody's",null,null,{"$f":"MoneyMarketFundDetailAmount9","v":0},0]
[null,null,"SEC 2a-7, rated Aaa-mf by Moody's",null,null,{"$f":"MoneyMarketFundDetailAmount10","v":0},0]
[null,null,"SEC 2a-7, rated Aaa-mf by Moody's",null,null,{"$f":"MoneyMarketFundDetailAmount11","v":0},0]
[null,null,"SEC 2a-7, rated Aaa-mf by Moody's",null,null,{"$f":"MoneyMarketFundDetailAmount12","v":0},0]
[null,null,"SEC 2a-7, rated Aaa-mf by Moody's",null,null,{"$f":"MoneyMarketFundDetailAmount13","v":0},0]
[null,null,"SEC 2a-7, rated Aaa-mf by Moody's",null,null,{"$f":"MoneyMarketFundDetailAmount14","v":0},0]
["Total",null,null,null,{"$f":"SUM(E3:E16)","v":0}]
[]
["Summary of Money Market Funds ($000):"]
[]
["Largest investment with one sponsor that is Aaa-mf rated",{"$f":"MAX(G3:G16)","v":0}]
["SEC 2a-7, rated Aaa-mf by Moody's",{"$f":"SUMIF($C$3:$C$16,$A22,$E$3:$E$16)","v":0}]

{"sheet":"Checking P-1 Rated Bank","index":7,"n_rows":28,"n_cols":3,"rows_kept":28,"cut":false,"hidden":true,"merged":[]}
["Name of the Bank","Type of Account","Amount in the account as of reporting date ($000)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Total",null,{"$f":"SUM(C2:C22)","v":0}]
[]
[]
[]
[]
["Note:The total amount must match the amount on the \"Assets\" sheet Cell C11"]

{"sheet":"Repo","index":8,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"TreasAgen<2yrs","index":9,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"2yrs<=TreasAgen<10yrs","index":10,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"TreasAgen>=10yrs","index":11,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Other Daily Assets","index":12,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}