{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Financial Report Template"],"not_rendered":{"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"Financial Report Template","index":0,"n_rows":70,"n_cols":28,"rows_kept":70}
["Use Annual Financial Report Instructions to complete this document"]
["MORRIS FAMILY FUND"]
["Annual Financial Report Template"]
["Section I: Organizational Information"]
["Current  Project Year"]
["Organization Name"]
["Project Title"]
["Total Grant Amount"]
["Date"]
["Reporting Period Start Date"]
["Reporting Period End Date"]
[]
["Section II:  Full Project Budget, Expenditures and Forecast  "]
["Section IIa: Budgeted Project Costs",{"$nulls":7},"Section IIb: Actual Project Expenditure",{"$nulls":6},"Section IIc: Project Budget Reforecast",{"$nulls":6},"Section IId:  Project Variance "]
[null,"Year 1","Year 2","Year 3","Year 4","Year 5","Total - All Years",null,"Year 1","Year 2","Year 3","Year 4","Year 5","Total - All Years",null,"Year 1","Year 2","Year 3","Year 4","Year 5","Total - All Years",null,"Year 1","Year 2","Year 3","Year 4","Year 5","Total - All Years"]
["Direct Costs"]
["Personnel:",{"$nulls":5},{"$f":"SUM(B17:F17)","v":0},{"$nulls":6},{"$f":"SUM(I17:M17)","v":0},{"$nulls":6},{"$f":"SUM(P17:T17)","v":0},null,{"$f":"(P17-B17)/B17","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["Travel:",{"$nulls":5},{"$f":"SUM(B18:F18)","v":0},{"$nulls":6},{"$f":"SUM(I18:M18)","v":0},{"$nulls":6},{"$f":"SUM(P18:T18)","v":0},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["Equipment:",{"$nulls":5},{"$f":"SUM(B19:F19)","v":0},{"$nulls":6},{"$f":"SUM(I19:M19)","v":0},{"$nulls":6},{"$f":"SUM(P19:T19)","v":0},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["Sub-grants:",{"$nulls":5},{"$f":"SUM(B20:F20)","v":0},{"$nulls":6},{"$f":"SUM(I20:M20)","v":0},{"$nulls":6},{"$f":"SUM(P20:T20)","v":0},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["Other direct costs:",{"$nulls":5},{"$f":"SUM(B21:F21)","v":0},{"$nulls":6},{"$f":"SUM(I21:M21)","v":0},{"$nulls":6},{"$f":"SUM(P21:T21)","v":0},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[]
["Total Direct Costs:",{"$f":"SUM(B17:B21)","v":0},0,0,0,0,0,null,{"$f":"SUM(I17:I21)","v":0},{"$f":"SUM(J17:J21)","v":0},0,0,0,0,null,{"$f":"SUM(P17:P21)","v":0},{"$f":"SUM(Q17:Q21)","v":0},0,0,0,0,null,{"$f":"(P23-B23)/B23","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["Total Indirect Costs:",{"$nulls":12},{"$f":"SUM(I24:M24)","v":0},{"$nulls":6},{"$f":"SUM(P24:T24)","v":0},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["Total Project Costs:",{"$f":"B23+B24","v":0},0,0,0,0,0,null,{"$f":"SUM(I23:I24)","v":0},{"$f":"SUM(J23:J24)","v":0},0,0,0,{"$f":"N23+N24","v":0},null,{"$f":"SUM(P23:P24)","v":0},{"$f":"SUM(Q23:Q24)","v":0},0,0,0,{"$f":"U23+U24","v":0},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[]
["Indirect Cost Rate:",{"$f":"B24/B25","v":{"$error":"#DIV/0!"}},{"$f":"C24/C25","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$nulls":8},{"$f":"P24/P25","v":{"$error":"#DIV/0!"}},{"$f":"Q24/Q25","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"(P27-B27)/B27","v":{"$error":"#DIV/0!"}},{"$f":"(Q27-C27)/C27","v":{"$error":"#DIV/0!"}},{"$f":"(R27-D27)/D27","v":{"$error":"#DIV/0!"}},{"$f":"(S27-E27)/E27","v":{"$error":"#DIV/0!"}},{"$f":"(T27-F27)/F27","v":{"$error":"#DIV/0!"}},{"$f":"(U27-G27)/G27","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
["Section III:  Budget, Expenditures and Forecast for Grant from Douglas B. Marshall Jr. Family Foundation"]
["Section IIIa: Budgeted DBMJr Costs",{"$nulls":7},"Section IIIb: Actual DBMJr Expenditure",{"$nulls":6},"Section IIIc: DBMJr Budget Reforecast",{"$nulls":6},"Section IIId:  DBMJr Variance "]
[null,"Year 1","Year 2","Year 3","Year 4","Year 5","Total - All Years",null,"Year 1","Year 2","Year 3","Year 4","Year 5","Total - All Years",null,"Year 1","Year 2","Year 3","Year 4","Year 5","Total - All Years",null,"Year 1","Year 2","Year 3","Year 4","Year 5","Total - All Years"]
["Direct Costs"]
["Personnel:",{"$nulls":5},{"$f":"SUM(B35:F35)","v":0},{"$nulls":6},{"$f":"SUM(I35:M35)","v":0},{"$nulls":6},{"$f":"SUM(P35:T35)","v":0},null,{"$f":"(P35-B35)/B35","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["Travel:",{"$nulls":5},{"$f":"SUM(B36:F36)","v":0},{"$nulls":6},{"$f":"SUM(I36:M36)","v":0},{"$nulls":6},{"$f":"SUM(P36:T36)","v":0},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["Equipment:",{"$nulls":5},{"$f":"SUM(B37:F37)","v":0},{"$nulls":6},{"$f":"SUM(I37:M37)","v":0},{"$nulls":6},{"$f":"SUM(P37:T37)","v":0},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["Sub-grants:",{"$nulls":5},{"$f":"SUM(B38:F38)","v":0},{"$nulls":6},{"$f":"SUM(I38:M38)","v":0},{"$nulls":6},{"$f":"SUM(P38:T38)","v":0},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["Other direct costs:",{"$nulls":5},{"$f":"SUM(B39:F39)","v":0},{"$nulls":6},{"$f":"SUM(I39:M39)","v":0},{"$nulls":6},{"$f":"SUM(P39:T39)","v":0},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[]
["Total Direct Costs:",{"$f":"SUM(B35:B39)","v":0},0,0,0,0,0,null,{"$f":"SUM(I35:I39)","v":0},{"$f":"SUM(J35:J39)","v":0},0,0,0,0,null,{"$f":"SUM(P35:P39)","v":0},{"$f":"SUM(Q35:Q39)","v":0},0,0,0,0,null,{"$f":"(P41-B41)/B41","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["Total Indirect Costs:",{"$nulls":12},{"$f":"SUM(I42:M42)","v":0},{"$nulls":6},{"$f":"SUM(P42:T42)","v":0},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["Total Project Costs:",{"$f":"B41+B42","v":0},0,0,0,0,0,null,{"$f":"SUM(I41:I42)","v":0},{"$f":"SUM(J41:J42)","v":0},0,0,0,{"$f":"N41+N42","v":0},null,{"$f":"SUM(P41:P42)","v":0},{"$f":"SUM(Q41:Q42)","v":0},0,0,0,{"$f":"U41+U42","v":0},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[]
["Indirect Cost Rate:",{"$f":"B42/B43","v":{"$error":"#DIV/0!"}},{"$f":"C42/C43","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$nulls":8},{"$f":"P42/P43","v":{"$error":"#DIV/0!"}},{"$f":"Q42/Q43","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"(P45-B45)/B45","v":{"$error":"#DIV/0!"}},{"$f":"(Q45-C45)/C45","v":{"$error":"#DIV/0!"}},{"$f":"(R45-D45)/D45","v":{"$error":"#DIV/0!"}},{"$f":"(S45-E45)/E45","v":{"$error":"#DIV/0!"}},{"$f":"(T45-F45)/F45","v":{"$error":"#DIV/0!"}},{"$f":"(U45-G45)/G45","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
["Section IV:  Other Sources of Project Funding "]
[]
["IVa: Funding Gap"]
[null,"Year 1","Year 2","Year 3","Year 4","Year 5","Total - All Years"]
["Budget (current Annual Report)",{"$f":"P25","v":0},{"$f":"Q25","v":0},0,0,0,{"$f":"SUM(B53:F53)","v":0}]
["Funding Secured (last annual report)",{"$nulls":5},{"$f":"SUM(B54:F54)","v":0}]
["New Funding Secured (past year)",{"$nulls":5},{"$f":"SUM(B55:F55)","v":0}]
["Total Funding Secured",{"$f":"B54+B55","v":0},{"$f":"C54+C55","v":0},{"$f":"D54+D55","v":0},{"$f":"E54+E55","v":0},{"$f":"F54+F55","v":0},{"$f":"SUM(B56:F56)","v":0}]
["Funding Gap",{"$f":"B53-B56","v":0},{"$f":"C53-C56","v":0},{"$f":"D53-D56","v":0},{"$f":"E53-E56","v":0},{"$f":"F53-F56","v":0},{"$f":"SUM(B57:F57)","v":0}]
[]
["IVb: Details on New Funding Secured  and in Process"]
["Name of Grant/Funding Secured ","Amount","Source/ Donor"]
[]
[]
[]
["Total Funding Secured",{"$f":"SUM(B61:B63)","v":0}]
[]
["Name of Grant in Progress","Amount","Source/ Donor"]
[]
[]
[]
["Total Funding in Process",{"$f":"SUM(B67:B69)","v":0}]