{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Grantee Input","Graphics"],"not_rendered":{"charts":7,"images":1,"macros":1,"external_links":0,"defined_names":2,"comments":1,"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":"Grantee Input","index":0,"n_rows":73,"n_cols":15,"rows_kept":73,"cut":false,"hidden":false,"merged":[[48,1,48,2],[48,3,48,4],[48,5,48,6],[8,11,8,12],[9,1,9,2],[9,3,9,4],[9,5,9,6],[9,7,9,8],[9,9,9,10],[9,11,9,12],[8,1,8,2],[8,3,8,4],[8,5,8,6],[8,7,8,8],[8,9,8,10],[47,1,47,2],[8,13,8,14],[9,13,9,14],[47,3,47,4],[47,5,47,6],[0,0,0,14],[2,0,2,14],[3,0,3,14],[4,0,4,14],[5,0,5,14],[1,0,1,14]]}
["FINANCIAL ANALYSIS TEMPLATE"]
["Populate only the white cells. Enter numbers only (no text). Hover your mouse over cells that have red triangles in the upper right-hand corner to view additional information/instructions."]
["Organization Name: "]
["Project Name: "]
["Date: "]
["Fiscal Year: "]
[]
[]
[null,"-2",null,"-1",null,"Current Fiscal Year",null,"+1",null,"+2",null,"+3",null,"+4 (if applicable)"]
["INCOME STATEMENT",{"$f":"IFERROR(D10-1,\"\")","v":""},null,{"$f":"IFERROR(F10-1,\"\")","v":""},null,"YYYY",null,{"$f":"IFERROR(F10+1,\"\")","v":""},null,{"$f":"IFERROR(H10+1,\"\")","v":""},null,{"$f":"IFERROR(J10+1,\"\")","v":""},null,{"$f":"IFERROR(L10+1,\"\")","v":""}]
[null,"$","%","$","%","$","%","$","%","$","%","$","%","$","%"]
["Revenue"]
["Operating Revenue"]
["Government Funding ",null,{"$f":"IFERROR(B14/B20,\"\")","v":""},null,{"$f":"IFERROR(D14/D20,\"\")","v":""},null,{"$f":"IFERROR(F14/F20,\"\")","v":""},null,{"$f":"IFERROR(H14/H20,\"\")","v":""},null,{"$f":"IFERROR(J14/J20,\"\")","v":""},null,{"$f":"IFERROR(L14/L20,\"\")","v":""},null,{"$f":"IFERROR(N14/N20,\"\")","v":""}]
["S. D. Bechtel, Jr. Foundation Grants",null,{"$f":"IFERROR(B15/B20,\"\")","v":""},null,{"$f":"IFERROR(D15/D20,\"\")","v":""},null,{"$f":"IFERROR(F15/F20,\"\")","v":""},null,{"$f":"IFERROR(H15/H20,\"\")","v":""},null,{"$f":"IFERROR(J15/J20,\"\")","v":""},null,{"$f":"IFERROR(L15/L20,\"\")","v":""},null,{"$f":"IFERROR(N15/N20,\"\")","v":""}]
["Foundation & Corporate Giving",null,{"$f":"IFERROR(B16/B20,\"\")","v":""},null,{"$f":"IFERROR(D16/D20,\"\")","v":""},null,{"$f":"IFERROR(F16/F20,\"\")","v":""},null,{"$f":"IFERROR(H16/H20,\"\")","v":""},null,{"$f":"IFERROR(J16/J20,\"\")","v":""},null,{"$f":"IFERROR(L16/L20,\"\")","v":""},null,{"$f":"IFERROR(N16/N20,\"\")","v":""}]
["Individual Giving",null,{"$f":"IFERROR(B17/B20,\"\")","v":""},null,{"$f":"IFERROR(D17/D20,\"\")","v":""},null,{"$f":"IFERROR(F17/F20,\"\")","v":""},null,{"$f":"IFERROR(H17/H20,\"\")","v":""},null,{"$f":"IFERROR(J17/J20,\"\")","v":""},null,{"$f":"IFERROR(L17/L20,\"\")","v":""},null,{"$f":"IFERROR(N17/N20,\"\")","v":""}]
["Special Event Proceeds",null,{"$f":"IFERROR(B18/B20,\"\")","v":""},null,{"$f":"IFERROR(D18/D20,\"\")","v":""},null,{"$f":"IFERROR(F18/F20,\"\")","v":""},null,{"$f":"IFERROR(H18/H20,\"\")","v":""},null,{"$f":"IFERROR(J18/J20,\"\")","v":""},null,{"$f":"IFERROR(L18/L20,\"\")","v":""},null,{"$f":"IFERROR(N18/N20,\"\")","v":""}]
["Earned Income",null,{"$f":"IFERROR(B19/B20,\"\")","v":""},null,{"$f":"IFERROR(D19/D20,\"\")","v":""},null,{"$f":"IFERROR(F19/F20,\"\")","v":""},null,{"$f":"IFERROR(H19/H20,\"\")","v":""},null,{"$f":"IFERROR(J19/J20,\"\")","v":""},null,{"$f":"IFERROR(L19/L20,\"\")","v":""},null,{"$f":"IFERROR(N19/N20,\"\")","v":""}]
["Total Operating Revenue\n(% Change Year-To-Year)",{"$f":"IF(SUM(B14:B19)=0,\"\",SUM(B14:B19))","v":""},"N/A",{"$f":"IF(SUM(D14:D19)=0,\"\",SUM(D14:D19))","v":""},{"$f":"IFERROR((D20-B20)/B20,\"\")","v":""},{"$f":"IF(SUM(F14:F19)=0,\"\",SUM(F14:F19))","v":""},{"$f":"IFERROR((F20-D20)/D20,\"\")","v":""},{"$f":"IF(SUM(H14:H19)=0,\"\",SUM(H14:H19))","v":""},{"$f":"IFERROR((H20-F20)/F20,\"\")","v":""},{"$f":"IF(SUM(J14:J19)=0,\"\",SUM(J14:J19))","v":""},{"$f":"IFERROR((J20-H20)/H20,\"\")","v":""},{"$f":"IF(SUM(L14:L19)=0,\"\",SUM(L14:L19))","v":""},{"$f":"IFERROR((L20-J20)/J20,\"\")","v":""},{"$f":"IF(SUM(N14:N19)=0,\"\",SUM(N14:N19))","v":""},{"$f":"IFERROR((N20-L20)/L20,\"\")","v":""}]
[]
["Non-operating Revenue"]
["S. D. Bechtel, Jr. Foundation Capital Grants",null,{"$f":"IFERROR(B23/B25,\"\")","v":""},null,{"$f":"IFERROR(D23/D25,\"\")","v":""},null,{"$f":"IFERROR(F23/F25,\"\")","v":""},null,{"$f":"IFERROR(H23/H25,\"\")","v":""},null,{"$f":"IFERROR(J23/J25,\"\")","v":""},null,{"$f":"IFERROR(L23/L25,\"\")","v":""},null,{"$f":"IFERROR(N23/N25,\"\")","v":""}]
["Other Non-operating",null,{"$f":"IFERROR(B24/B25,\"\")","v":""},null,{"$f":"IFERROR(D24/D25,\"\")","v":""},null,{"$f":"IFERROR(F24/F25,\"\")","v":""},null,{"$f":"IFERROR(H24/H25,\"\")","v":""},null,{"$f":"IFERROR(J24/J25,\"\")","v":""},null,{"$f":"IFERROR(L24/L25,\"\")","v":""},null,{"$f":"IFERROR(N24/N25,\"\")","v":""}]
["Total Non-Operating Revenue\n(% Change Year-To-Year)",{"$f":"IF(B23+B24=0,\"\",B23+B24)","v":""},"N/A",{"$f":"IF(D23+D24=0,\"\",D23+D24)","v":""},{"$f":"IFERROR((D25-B25)/B25,\"\")","v":""},{"$f":"IF(F23+F24=0,\"\",F23+F24)","v":""},{"$f":"IFERROR((F25-D25)/D25,\"\")","v":""},{"$f":"IF(H23+H24=0,\"\",H23+H24)","v":""},{"$f":"IFERROR((H25-F25)/F25,\"\")","v":""},{"$f":"IF(J23+J24=0,\"\",J23+J24)","v":""},{"$f":"IFERROR((J25-H25)/H25,\"\")","v":""},{"$f":"IF(L23+L24=0,\"\",L23+L24)","v":""},{"$f":"IFERROR((L25-J25)/J25,\"\")","v":""},{"$f":"IF(N23+N24=0,\"\",N23+N24)","v":""},{"$f":"IFERROR((N25-L25)/L25,\"\")","v":""}]
[]
["Total Revenue\n(% Change Year-To-Year)",{"$f":"IFERROR(B20+B25,\"\")","v":""},"N/A",{"$f":"IFERROR(D20+D25,\"\")","v":""},{"$f":"IFERROR((D27-B27)/B27,\"\")","v":""},{"$f":"IFERROR(F20+F25,\"\")","v":""},{"$f":"IFERROR((F27-D27)/D27,\"\")","v":""},{"$f":"IFERROR(H20+H25,\"\")","v":""},{"$f":"IFERROR((H27-F27)/F27,\"\")","v":""},{"$f":"IFERROR(J20+J25,\"\")","v":""},{"$f":"IFERROR((J27-H27)/H27,\"\")","v":""},{"$f":"IFERROR(L20+L25,\"\")","v":""},{"$f":"IFERROR((L27-J27)/J27,\"\")","v":""},{"$f":"IFERROR(N20+N25,\"\")","v":""},{"$f":"IFERROR((N27-L27)/L27,\"\")","v":""}]
[]
["Expenses"]
["Operating Expenses"]
["Personnel",null,{"$f":"IFERROR(B31/B36,\"\")","v":""},null,{"$f":"IFERROR(D31/D36,\"\")","v":""},null,{"$f":"IFERROR(F31/F36,\"\")","v":""},null,{"$f":"IFERROR(H31/H36,\"\")","v":""},null,{"$f":"IFERROR(J31/J36,\"\")","v":""},null,{"$f":"IFERROR(L31/L36,\"\")","v":""},null,{"$f":"IFERROR(N31/N36,\"\")","v":""}]
["Consultants and Contractors",null,{"$f":"IFERROR(B32/B36,\"\")","v":""},null,{"$f":"IFERROR(D32/D36,\"\")","v":""},null,{"$f":"IFERROR(F32/F36,\"\")","v":""},null,{"$f":"IFERROR(H32/H36,\"\")","v":""},null,{"$f":"IFERROR(J32/J36,\"\")","v":""},null,{"$f":"IFERROR(L32/L36,\"\")","v":""},null,{"$f":"IFERROR(N32/N36,\"\")","v":""}]
["Occupancy",null,{"$f":"IFERROR(B33/B36,\"\")","v":""},null,{"$f":"IFERROR(D33/D36,\"\")","v":""},null,{"$f":"IFERROR(F33/F36,\"\")","v":""},null,{"$f":"IFERROR(H33/H36,\"\")","v":""},null,{"$f":"IFERROR(J33/J36,\"\")","v":""},null,{"$f":"IFERROR(L33/L36,\"\")","v":""},null,{"$f":"IFERROR(N33/N36,\"\")","v":""}]
["Interest",null,{"$f":"IFERROR(B34/B36,\"\")","v":""},null,{"$f":"IFERROR(D34/D36,\"\")","v":""},null,{"$f":"IFERROR(F34/F36,\"\")","v":""},null,{"$f":"IFERROR(H34/H36,\"\")","v":""},null,{"$f":"IFERROR(J34/J36,\"\")","v":""},null,{"$f":"IFERROR(L34/L36,\"\")","v":""},null,{"$f":"IFERROR(N34/N36,\"\")","v":""}]
["Other Operating Expenses",null,{"$f":"IFERROR(B35/B36,\"\")","v":""},null,{"$f":"IFERROR(D35/D36,\"\")","v":""},null,{"$f":"IFERROR(F35/F36,\"\")","v":""},null,{"$f":"IFERROR(H35/H36,\"\")","v":""},null,{"$f":"IFERROR(J35/J36,\"\")","v":""},null,{"$f":"IFERROR(L35/L36,\"\")","v":""},null,{"$f":"IFERROR(N35/N36,\"\")","v":""}]
["Total Operating Expenses \nBefore Depreciation (% Change Year-To-Year)",{"$f":"IF(SUM(B31:B35)=0,\"\",SUM(B31:B35))","v":""},"N/A",{"$f":"IF(SUM(D31:D35)=0,\"\",SUM(D31:D35))","v":""},{"$f":"IFERROR((D36-B36)/B36, \"\")","v":""},{"$f":"IF(SUM(F31:F35)=0,\"\",SUM(F31:F35))","v":""},{"$f":"IFERROR((F36-D36)/D36, \"\")","v":""},{"$f":"IF(SUM(H31:H35)=0,\"\",SUM(H31:H35))","v":""},{"$f":"IFERROR((H36-F36)/F36, \"\")","v":""},{"$f":"IF(SUM(J31:J35)=0,\"\",SUM(J31:J35))","v":""},{"$f":"IFERROR((J36-H36)/H36, \"\")","v":""},{"$f":"IF(SUM(L31:L35)=0,\"\",SUM(L31:L35))","v":""},{"$f":"IFERROR((L36-J36)/J36, \"\")","v":""},{"$f":"IF(SUM(N31:N35)=0,\"\",SUM(N31:N35))","v":""},{"$f":"IFERROR((N36-L36)/L36, \"\")","v":""}]
[]
["Depreciation",null,"N/A",null,"N/A",null,"N/A",null,"N/A",null,"N/A",null,"N/A",null,"N/A"]
["Non-operating Expenses",null,"N/A",null,"N/A",null,"N/A",null,"N/A",null,"N/A",null,"N/A",null,"N/A"]
[]
["Total Expenses\n(% Change Year-To-Year)",{"$f":"IFERROR(B36+B38+B39,\"\")","v":""},"N/A",{"$f":"IFERROR(D36+D38+D39,\"\")","v":""},{"$f":"IFERROR((D41-B41)/B41, \"\")","v":""},{"$f":"IFERROR(F36+F38+F39,\"\")","v":""},{"$f":"IFERROR((F41-D41)/D41, \"\")","v":""},{"$f":"IFERROR(H36+H38+H39,\"\")","v":""},{"$f":"IFERROR((H41-F41)/F41, \"\")","v":""},{"$f":"IFERROR(J36+J38+J39,\"\")","v":""},{"$f":"IFERROR((J41-H41)/H41, \"\")","v":""},{"$f":"IFERROR(L36+L38+L39,\"\")","v":""},{"$f":"IFERROR((L41-J41)/J41, \"\")","v":""},{"$f":"IFERROR(N36+N38+N39,\"\")","v":""},{"$f":"IFERROR((N41-L41)/L41, \"\")","v":""}]
[]
["Operating Surplus/(Deficit)\nBefore Depreciation (% of total operating expenses)",{"$f":"IFERROR(B20-B36,\"\")","v":""},{"$f":"IFERROR(B43/B36, \"\")","v":""},{"$f":"IFERROR(D20-D36,\"\")","v":""},{"$f":"IFERROR(D43/D36, \"\")","v":""},{"$f":"IFERROR(F20-F36,\"\")","v":""},{"$f":"IFERROR(F43/F36, \"\")","v":""},{"$f":"IFERROR(H20-H36,\"\")","v":""},{"$f":"IFERROR(H43/H36, \"\")","v":""},{"$f":"IFERROR(J20-J36,\"\")","v":""},{"$f":"IFERROR(J43/J36, \"\")","v":""},{"$f":"IFERROR(L20-L36,\"\")","v":""},{"$f":"IFERROR(L43/L36, \"\")","v":""},{"$f":"IFERROR(N20-N36,\"\")","v":""},{"$f":"IFERROR(N43/N36, \"\")","v":""}]
[]
["Total Surplus/(Deficit)\nBefore Depreciation (% of total expenses)",{"$f":"IFERROR(B27-B41+B38,\"\")","v":""},{"$f":"IFERROR(B45/(B41-B38), \"\")","v":""},{"$f":"IFERROR(D27-D41+D38,\"\")","v":""},{"$f":"IFERROR(D45/(D41-D38), \"\")","v":""},{"$f":"IFERROR(F27-F41+F38,\"\")","v":""},{"$f":"IFERROR(F45/(F41-F38), \"\")","v":""},{"$f":"IFERROR(H27-H41+H38,\"\")","v":""},{"$f":"IFERROR(H45/(H41-H38), \"\")","v":""},{"$f":"IFERROR(J27-J41+J38,\"\")","v":""},{"$f":"IFERROR(J45/(J41-J38), \"\")","v":""},{"$f":"IFERROR(L27-L41+L38,\"\")","v":""},{"$f":"IFERROR(L45/(L41-L38), \"\")","v":""},{"$f":"IFERROR(N27-N41+N38,\"\")","v":""},{"$f":"IFERROR(N45/(N41-N38), \"\")","v":""}]
[]
[]
[null,"-2",null,"-1",null,"Current Fiscal Year"]
["BALANCE SHEET",{"$f":"IFERROR(D49-1,\"\")","v":""},null,{"$f":"IFERROR(F49-1,\"\")","v":""},null,{"$f":"F10","v":"YYYY"}]
[null,"$","%","$","%","$","%"]
["Assets"]
["Cash & Investments",null,{"$f":"IFERROR(B52/B56,\"\")","v":""},null,{"$f":"IFERROR(D52/D56,\"\")","v":""},null,{"$f":"IFERROR(F52/F56,\"\")","v":""}]
["Receivables",null,{"$f":"IFERROR(B53/B56,\"\")","v":""},null,{"$f":"IFERROR(D53/D56,\"\")","v":""},null,{"$f":"IFERROR(F53/F56,\"\")","v":""}]
["Property & Equipment (P&E)",null,{"$f":"IFERROR(B54/B56,\"\")","v":""},null,{"$f":"IFERROR(D54/D56,\"\")","v":""},null,{"$f":"IFERROR(F54/F56,\"\")","v":""}]
["Other",null,{"$f":"IFERROR(B55/B56,\"\")","v":""},null,{"$f":"IFERROR(D55/D56,\"\")","v":""},null,{"$f":"IFERROR(F55/F56,\"\")","v":""}]
["Total Assets\n(% Change Year-To-Year)",{"$f":"IF(SUM(B52:B55)=0,\"\",SUM(B52:B55))","v":""},"N/A",{"$f":"IF(SUM(D52:D55)=0,\"\",SUM(D52:D55))","v":""},{"$f":"IFERROR((D56-B56)/B56, \"\")","v":""},{"$f":"IF(SUM(F52:F55)=0,\"\",SUM(F52:F55))","v":""},{"$f":"IFERROR((F56-D56)/D56, \"\")","v":""}]
[]
["Liabilities"]
["Short-term (excluding P&E)",null,{"$f":"IFERROR(B59/B63,\"\")","v":""},null,{"$f":"IFERROR(D59/D63,\"\")","v":""},null,{"$f":"IFERROR(F59/F63,\"\")","v":""}]
["Long-term (excluding P&E)",null,{"$f":"IFERROR(B60/B63,\"\")","v":""},null,{"$f":"IFERROR(D60/D63,\"\")","v":""},null,{"$f":"IFERROR(F60/F63,\"\")","v":""}]
["Property & Equipment (P&E) Debt",null,{"$f":"IFERROR(B61/B63,\"\")","v":""},null,{"$f":"IFERROR(D61/D63,\"\")","v":""},null,{"$f":"IFERROR(F61/F63,\"\")","v":""}]
["Other",null,{"$f":"IFERROR(B62/B63,\"\")","v":""},null,{"$f":"IFERROR(D62/D63,\"\")","v":""},null,{"$f":"IFERROR(F62/F63,\"\")","v":""}]
["Total Liabilities\n(% Change Year-To-Year)",{"$f":"IF(SUM(B59:B62)=0,\"\",SUM(B59:B62))","v":""},"N/A",{"$f":"IF(SUM(D59:D62)=0,\"\",SUM(D59:D62))","v":""},{"$f":"IFERROR((D63-B63)/B63, \"\")","v":""},{"$f":"IF(SUM(F59:F62)=0,\"\",SUM(F59:F62))","v":""},{"$f":"IFERROR((F63-D63)/D63, \"\")","v":""}]
[]
["Net Assets"]
["Unrestricted",null,{"$f":"IFERROR(B66/B69,\"\")","v":""},null,{"$f":"IFERROR(D66/D69,\"\")","v":""},null,{"$f":"IFERROR(F66/F69,\"\")","v":""}]
["Temporarily Restricted",null,{"$f":"IFERROR(B67/B69,\"\")","v":""},null,{"$f":"IFERROR(D67/D69,\"\")","v":""},null,{"$f":"IFERROR(F67/F69,\"\")","v":""}]
["Permanently Restricted",null,{"$f":"IFERROR(B68/B69,\"\")","v":""},null,{"$f":"IFERROR(D68/D69,\"\")","v":""},null,{"$f":"IFERROR(F68/F69,\"\")","v":""}]
["Total Net Assets\n(% Change Year-To-Year)",{"$f":"IF(SUM(B66:B68)=0,\"\",SUM(B66:B68))","v":""},"N/A",{"$f":"IF(SUM(D66:D68)=0,\"\",SUM(D66:D68))","v":""},{"$f":"IFERROR((D69-B69)/B69, \"\")","v":""},{"$f":"IF(SUM(F66:F68)=0,\"\",SUM(F66:F68))","v":""},{"$f":"IFERROR((F69-D69)/D69, \"\")","v":""}]
[]
["Months of Cash",{"$f":"IFERROR(B52/(B36/12),\"\")","v":""},"N/A",{"$f":"IFERROR(D52/(D36/12),\"\")","v":""},"N/A",{"$f":"IFERROR(F52/(F36/12),\"\")","v":""},"N/A"]
["Months of ULNA",{"$f":"IFERROR((B66-(B54-B61))/(B36/12),\"\")","v":""},"N/A",{"$f":"IFERROR((D66-(D54-D61))/(D36/12),\"\")","v":""},"N/A",{"$f":"IFERROR((F66-(F54-F61))/(F36/12),\"\")","v":""},"N/A"]
["Total ULNA",{"$f":"IF(B66-(B54-B61)=0,\"\",B66-(B54-B61))","v":""},"N/A",{"$f":"IF(D66-(D54-D61)=0,\"\",D66-(D54-D61))","v":""},"N/A",{"$f":"IF(F66-(F54-F61)=0,\"\",F66-(F54-F61))","v":""},"N/A"]

{"sheet":"Graphics","index":1,"n_rows":17,"n_cols":40,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Reference Data for Graphs",-2,-1,"YYYY",1,2,3,4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Operating Revenue",{"$f":"IF('Grantee Input'!B20=\"\",NA(),'Grantee Input'!B20)","v":{"$error":"#N/A"}},{"$f":"IF('Grantee Input'!D20=\"\",NA(),'Grantee Input'!D20)","v":{"$error":"#N/A"}},{"$f":"IF('Grantee Input'!F20=\"\",NA(),'Grantee Input'!F20)","v":{"$error":"#N/A"}},{"$f":"IF('Grantee Input'!H20=\"\",NA(),'Grantee Input'!H20)","v":{"$error":"#N/A"}},{"$f":"IF('Grantee Input'!J20=\"\",NA(),'Grantee Input'!J20)","v":{"$error":"#N/A"}},{"$f":"IF('Grantee Input'!L20=\"\",NA(),'Grantee Input'!L20)","v":{"$error":"#N/A"}},{"$f":"IF('Grantee Input'!N20=\"\",NA(),'Grantee Input'!N20)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Operating Expense",{"$f":"IF('Grantee Input'!B36=\"\",NA(),'Grantee Input'!B36)","v":{"$error":"#N/A"}},{"$f":"IF('Grantee Input'!D36=\"\",NA(),'Grantee Input'!D36)","v":{"$error":"#N/A"}},{"$f":"IF('Grantee Input'!F36=\"\",NA(),'Grantee Input'!F36)","v":{"$error":"#N/A"}},{"$f":"IF('Grantee Input'!H36=\"\",NA(),'Grantee Input'!H36)","v":{"$error":"#N/A"}},{"$f":"IF('Grantee Input'!J36=\"\",NA(),'Grantee Input'!J36)","v":{"$error":"#N/A"}},{"$f":"IF('Grantee Input'!L36=\"\",NA(),'Grantee Input'!L36)","v":{"$error":"#N/A"}},{"$f":"IF('Grantee Input'!N36=\"\",NA(),'Grantee Input'!N36)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Revenue",{"$f":"IF('Grantee Input'!B27=\"\",NA(),'Grantee Input'!B27)","v":{"$error":"#N/A"}},{"$f":"IF('Grantee Input'!D27=\"\",NA(),'Grantee Input'!D27)","v":{"$error":"#N/A"}},{"$f":"IF('Grantee Input'!F27=\"\",NA(),'Grantee Input'!F27)","v":{"$error":"#N/A"}},{"$f":"IF('Grantee Input'!H27=\"\",NA(),'Grantee Input'!H27)","v":{"$error":"#N/A"}},{"$f":"IF('Grantee Input'!J27=\"\",NA(),'Grantee Input'!J27)","v":{"$error":"#N/A"}},{"$f":"IF('Grantee Input'!L27=\"\",NA(),'Grantee Input'!L27)","v":{"$error":"#N/A"}},{"$f":"IF('Grantee Input'!N27=\"\",NA(),'Grantee Input'!N27)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Expense",{"$f":"IF('Grantee Input'!B41=\"\",NA(),'Grantee Input'!B41)","v":{"$error":"#N/A"}},{"$f":"IF('Grantee Input'!D41=\"\",NA(),'Grantee Input'!D41)","v":{"$error":"#N/A"}},{"$f":"IF('Grantee Input'!F41=\"\",NA(),'Grantee Input'!F41)","v":{"$error":"#N/A"}},{"$f":"IF('Grantee Input'!H41=\"\",NA(),'Grantee Input'!H41)","v":{"$error":"#N/A"}},{"$f":"IF('Grantee Input'!J41=\"\",NA(),'Grantee Input'!J41)","v":{"$error":"#N/A"}},{"$f":"IF('Grantee Input'!L41=\"\",NA(),'Grantee Input'!L41)","v":{"$error":"#N/A"}},{"$f":"IF('Grantee Input'!N41=\"\",NA(),'Grantee Input'!N41)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Operating Surplus/Deficit",{"$f":"IF('Grantee Input'!B43=\"\",NA(),'Grantee Input'!B43)","v":{"$error":"#N/A"}},{"$f":"IF('Grantee Input'!D43=\"\",NA(),'Grantee Input'!D43)","v":{"$error":"#N/A"}},{"$f":"IF('Grantee Input'!F43=\"\",NA(),'Grantee Input'!F43)","v":{"$error":"#N/A"}},{"$f":"IF('Grantee Input'!H43=\"\",NA(),'Grantee Input'!H43)","v":{"$error":"#N/A"}},{"$f":"IF('Grantee Input'!J43=\"\",NA(),'Grantee Input'!J43)","v":{"$error":"#N/A"}},{"$f":"IF('Grantee Input'!L43=\"\",NA(),'Grantee Input'!L43)","v":{"$error":"#N/A"}},{"$f":"IF('Grantee Input'!N43=\"\",NA(),'Grantee Input'!N43)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Grantee Input'!A14","v":"Government Funding "},{"$f":"IF('Grantee Input'!C14=\"\",NA(),'Grantee Input'!C14)","v":{"$error":"#N/A"}},{"$f":"IF('Grantee Input'!E14=\"\",NA(),'Grantee Input'!E14)","v":{"$error":"#N/A"}},{"$f":"IF('Grantee Input'!G14=\"\",NA(),'Grantee Input'!G14)","v":{"$error":"#N/A"}},{"$f":"IF('Grantee Input'!I14=\"\",NA(),'Grantee Input'!I14)","v":{"$error":"#N/A"}},{"$f":"IF('Grantee Input'!K14=\"\",NA(),'Grantee Input'!K14)","v":{"$error":"#N/A"}},{"$f":"IF('Grantee Input'!M14=\"\",NA(),'Grantee Input'!M14)","v":{"$error":"#N/A"}},{"$f":"IF('Grantee Input'!O14=\"\",NA(),'Grantee Input'!O14)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Grantee Input'!A15","v":"S. D. Bechtel, Jr. Foundation Grants"},{"$f":"IF('Grantee Input'!C15=\"\",NA(),'Grantee Input'!C15)","v":{"$error":"#N/A"}},{"$f":"IF('Grantee Input'!E15=\"\",NA(),'Grantee Input'!E15)","v":{"$error":"#N/A"}},{"$f":"IF('Grantee Input'!G15=\"\",NA(),'Grantee Input'!G15)","v":{"$error":"#N/A"}},{"$f":"IF('Grantee Input'!I15=\"\",NA(),'Grantee Input'!I15)","v":{"$error":"#N/A"}},{"$f":"IF('Grantee Input'!K15=\"\",NA(),'Grantee Input'!K15)","v":{"$error":"#N/A"}},{"$f":"IF('Grantee Input'!M15=\"\",NA(),'Grantee Input'!M15)","v":{"$error":"#N/A"}},{"$f":"IF('Grantee Input'!O15=\"\",NA(),'Grantee Input'!O15)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Grantee Input'!A16","v":"Foundation & Corporate Giving"},{"$f":"IF('Grantee Input'!C16=\"\",NA(),'Grantee Input'!C16)","v":{"$error":"#N/A"}},{"$f":"IF('Grantee Input'!E16=\"\",NA(),'Grantee Input'!E16)","v":{"$error":"#N/A"}},{"$f":"IF('Grantee Input'!G16=\"\",NA(),'Grantee Input'!G16)","v":{"$error":"#N/A"}},{"$f":"IF('Grantee Input'!I16=\"\",NA(),'Grantee Input'!I16)","v":{"$error":"#N/A"}},{"$f":"IF('Grantee Input'!K16=\"\",NA(),'Grantee Input'!K16)","v":{"$error":"#N/A"}},{"$f":"IF('Grantee Input'!M16=\"\",NA(),'Grantee Input'!M16)","v":{"$error":"#N/A"}},{"$f":"IF('Grantee Input'!O16=\"\",NA(),'Grantee Input'!O16)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Grantee Input'!A17","v":"Individual Giving"},{"$f":"IF('Grantee Input'!C17=\"\",NA(),'Grantee Input'!C17)","v":{"$error":"#N/A"}},{"$f":"IF('Grantee Input'!E17=\"\",NA(),'Grantee Input'!E17)","v":{"$error":"#N/A"}},{"$f":"IF('Grantee Input'!G17=\"\",NA(),'Grantee Input'!G17)","v":{"$error":"#N/A"}},{"$f":"IF('Grantee Input'!I17=\"\",NA(),'Grantee Input'!I17)","v":{"$error":"#N/A"}},{"$f":"IF('Grantee Input'!K17=\"\",NA(),'Grantee Input'!K17)","v":{"$error":"#N/A"}},{"$f":"IF('Grantee Input'!M17=\"\",NA(),'Grantee Input'!M17)","v":{"$error":"#N/A"}},{"$f":"IF('Grantee Input'!O17=\"\",NA(),'Grantee Input'!O17)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Grantee Input'!A18","v":"Special Event Proceeds"},{"$f":"IF('Grantee Input'!C18=\"\",NA(),'Grantee Input'!C18)","v":{"$error":"#N/A"}},{"$f":"IF('Grantee Input'!E18=\"\",NA(),'Grantee Input'!E18)","v":{"$error":"#N/A"}},{"$f":"IF('Grantee Input'!G18=\"\",NA(),'Grantee Input'!G18)","v":{"$error":"#N/A"}},{"$f":"IF('Grantee Input'!I18=\"\",NA(),'Grantee Input'!I18)","v":{"$error":"#N/A"}},{"$f":"IF('Grantee Input'!K18=\"\",NA(),'Grantee Input'!K18)","v":{"$error":"#N/A"}},{"$f":"IF('Grantee Input'!M18=\"\",NA(),'Grantee Input'!M18)","v":{"$error":"#N/A"}},{"$f":"IF('Grantee Input'!O18=\"\",NA(),'Grantee Input'!O18)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Grantee Input'!A19","v":"Earned Income"},{"$f":"IF('Grantee Input'!C19=\"\",NA(),'Grantee Input'!C19)","v":{"$error":"#N/A"}},{"$f":"IF('Grantee Input'!E19=\"\",NA(),'Grantee Input'!E19)","v":{"$error":"#N/A"}},{"$f":"IF('Grantee Input'!G19=\"\",NA(),'Grantee Input'!G19)","v":{"$error":"#N/A"}},{"$f":"IF('Grantee Input'!I19=\"\",NA(),'Grantee Input'!I19)","v":{"$error":"#N/A"}},{"$f":"IF('Grantee Input'!K19=\"\",NA(),'Grantee Input'!K19)","v":{"$error":"#N/A"}},{"$f":"IF('Grantee Input'!M19=\"\",NA(),'Grantee Input'!M19)","v":{"$error":"#N/A"}},{"$f":"IF('Grantee Input'!O19=\"\",NA(),'Grantee Input'!O19)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Liabilities as a % of Total Assets",{"$f":"IFERROR('Grantee Input'!B63/'Grantee Input'!B56,NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR('Grantee Input'!D63/'Grantee Input'!D56,NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR('Grantee Input'!F63/'Grantee Input'!F56,NA())","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Net Assets as a % of Total Assets",{"$f":"IFERROR('Grantee Input'!B69/'Grantee Input'!B56,NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR('Grantee Input'!D69/'Grantee Input'!D56,NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR('Grantee Input'!F69/'Grantee Input'!F56,NA())","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Months of Cash",{"$f":"IF('Grantee Input'!B71=\"\",NA(),'Grantee Input'!B71)","v":{"$error":"#N/A"}},{"$f":"IF('Grantee Input'!D71=\"\",NA(),'Grantee Input'!D71)","v":{"$error":"#N/A"}},{"$f":"IF('Grantee Input'!F71=\"\",NA(),'Grantee Input'!F71)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Months of ULNA",{"$f":"IF('Grantee Input'!B72=\"\",NA(),'Grantee Input'!B72)","v":{"$error":"#N/A"}},{"$f":"IF('Grantee Input'!D72=\"\",NA(),'Grantee Input'!D72)","v":{"$error":"#N/A"}},{"$f":"IF('Grantee Input'!F72=\"\",NA(),'Grantee Input'!F72)","v":{"$error":"#N/A"}}]