{"text_format":"2","workbook":"xls","n_sheets":1,"sheets":["Financial Plan-Long Form"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":17,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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","formulas":"cached_only"}

{"sheet":"Financial Plan-Long Form","index":0,"n_rows":190,"n_cols":14,"rows_kept":190,"cut":false,"hidden":false,"merged":[[185,0,185,13],[187,0,187,13],[189,0,189,13],[183,6,183,7],[186,0,186,13],[188,0,188,13],[178,0,179,13],[147,0,149,13],[151,0,152,13],[154,0,155,13],[157,0,158,13],[174,0,176,12],[160,0,161,13],[163,0,164,13],[166,0,167,13],[172,0,172,13],[137,0,139,13],[141,0,142,13],[169,0,170,13],[144,0,145,13],[134,0,135,13],[48,1,54,13],[130,0,132,13],[79,1,83,13],[72,1,77,13],[85,1,90,13],[92,1,95,13],[64,1,70,13],[113,1,114,13],[97,1,100,13],[110,1,111,13],[23,0,23,3],[29,5,30,12],[56,1,62,13],[44,1,44,12],[46,1,47,12],[43,0,43,1],[31,5,31,7],[102,1,104,13],[106,1,108,13],[1,5,1,7],[0,5,0,7],[0,8,0,9],[1,8,1,9],[3,0,3,12],[5,1,5,3],[28,5,28,13],[8,13,9,13],[5,4,5,12],[7,7,7,12],[8,9,8,10],[8,11,8,12],[8,7,8,8]],"flags":["formulas_cached_only"]}
[{"$nulls":5},"USFS Agreement No.:",{"$nulls":4},"Mod. No."]
[{"$nulls":5},"Cooperator Agreement No.:"]
[]
["Agreements Financial Plan (Long Form)"]
["1. Financial Plan Matrix:",null,"Note: All columns may not be used. Use depends on source and type of contribution(s)."]
[null,"FOREST SERVICE CONTRIBUTIONS",null,null,"COOPERATOR CONTRIBUTIONS"]
[null,"(a) ","(b)","(c)","(d)","(e)","(f)","(g)","(h)","(i)","(j)","(k)","(l)"]
[null,null,null,"Reimb.",null,null,null,"THIRD PARTY"]
["COST ELEMENTS","Non-Cash","In-Kind","Coop.","Non-Cash","In-Kind","Cash","Cash",null,"Non-Cash ",null,"In-Kind",null,"(m)\nTotal"]
["Direct Costs",null,null,"Expenses",null,null,null,"Non-Fed","Federal","Non-Fed","Federal","Non-Fed","Federal"]
["Salaries/Labor",{"$nulls":12},0]
["Travel",{"$nulls":12},0]
["Equipment Use",{"$nulls":12},0]
["Supplies",{"$nulls":12},0]
["Materials",{"$nulls":12},0]
["Printing",{"$nulls":12},0]
["Other",{"$nulls":12},0]
["Other",{"$nulls":12},0]
["Subtotal",0,0,0,0,0,0,0,0,0,0,0,0,0]
["Indirect Costs",{"$nulls":12},0]
["Total",0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[{"$nulls":8},"(n) Estimated Program Income (subtract from total of column (m):"]
["Matching Costs Determination",{"$nulls":7},"(o) Net Total Project Value:",{"$nulls":4},0]
["Total Forest Service Share =",null,null,"(p)"]
["(a+b+c)/(o) = (p)",null,null,{"$error":"#DIV/0!"}]
[]
["Third Party Contribution-- Federal =",null,null,"(q)"]
["(h+j+l)/(o) = (q)",null,null,{"$error":"#DIV/0!"},null,"Reimbursement Calculation"]
[{"$nulls":5},"Forest Service reimbursement percent (as % of expenses directly incurred by the Cooperator-- i.e., Cooperator's non-cash and cash contributions only-- that are subject to Forest Service reimbursement)"]
["Total Federal Share =",null,null,"(r)",{"$nulls":9},"(u)"]
["(p+q) = (r)",null,null,{"$error":"#DIV/0!"},null,"(c)/[(c+d+f) - (n)] = (u)",{"$nulls":7},{"$error":"#DIV/0!"}]
[]
["Total Cooperator Share",null,null,"(s)",null,"Reimbursable Amount = Total actual cost incurred to date (sum of cost elements from the Cooperator's invoice as  "]
["[(d+e+f+g+i+k) - (n)] / (o) = (s)",null,null,{"$error":"#DIV/0!"},null,"prescribed in agreement provisions ",null,null,null,"and",null,"multiplied  by",{"$error":"#DIV/0!"}]
[{"$nulls":5},"(u) minus any previous Forest Service payments, not to exceed the subtotal amount listed in column (c) minus any"]
[null,null,null,"(t)",null,"estimated program income.)"]
["Total (r+s) = (t)",null,null,{"$error":"#DIV/0!"}]
[]
[]
[]
[]
[]
["2. Cost Analysis:"]
[null,"Use the following section to show additional information that supports the lump sum figures provided above.  The following Cost Analysis boxes, (a)-(l), should provide a cost analysis of the corresponding matrix columns, (a)-(l), above, e.g. matrix column (a) FS Non-Cash Contribution should be analyzed under block (a), below, and matrix column (b) In-Kind Contribution should be analyzed under block (b), below, etc. Furthermore, each cost analysis box, below, should have clear labels indicating which cost element, above, that is being analyzed, e.g. Salary/Labor = hrs or days x rate; Travel = miles x rate or months x FOR rate, days x per diem rate; Equipment Use = hrs or days x rate; Supplies & Materials--list of items and estimated cost; Printing = estimated cost per item; Indirect Cost = Direct cost x current indirect rate."]
[]
[null,"If necessary, add additional sheets for cost analysis. To compress any unwanted portion(s) of this section, highlight the section to be hidden, then select \"Format\", \"Row\", and \"Hide\" from the toolbar."]
[]
["(a)"]
{"$rows_empty":7}
["(b)"]
{"$rows_empty":7}
["(c)"]
{"$rows_empty":7}
["(d)"]
[]
[]
[]
[]
[]
[]
["(e)"]
[]
[]
[]
[]
[]
["(f)"]
[]
[]
[]
[]
[]
[" "]
["(g)"]
[]
[]
[]
[]
["(h)"]
[]
[]
[]
[]
["(i)"]
[]
[]
[]
["(j)"]
[]
[]
[]
["(k)"]
[]
[]
["(l)"]
{"$rows_empty":14}
["3. Instructions:   Use this form in conjunction with ID 1509.11-2007-1."]
[]
["Use Cost Elements that apply to the particular project.  The Cost Elements listed are examples of those commonly used. Delete those that don't apply. Value assessed for volunteer labor should be commensurate with local labor rates for similar work. Donated materials, equipment and supplies should be valued at rates and prices available in the current local market."]
[]
[]
[]
["(a) Forest Service Non-Cash Contribution:  Forest Service employee salaries, travel, equipment, supplies, etc., provided toward completion of the project.  Total Forest Service indirect cost (overhead) is also included in this column.  All the costs listed here are an expense to the Forest Service."]
[]
[]
["(b) Value of Forest Service In-Kind Contribution: Forest Service contributions toward completion of the project for which the Forest Service has incurred no expense.  These contributions include such items as volunteer labor, donated materials, equipment, supplies, etc., contributed by third parties directly to the Forest Service. Forest Service volunteer and/or equipment rental agreements should be used to document the donated services."]
[]
[]
[]
["(c) Reimbursable Cooperator Expenses:  The figure(s) listed are both the maximum Forest Service funds to be obligated for reimbursement and Cooperator expenses that are not included anywhere else on this form.  This is an expense to the Forest Service."]
[]
[]
["(d) Cooperator Non-Cash Contribution:  Cooperator employee salaries, travel, equipment, supplies, etc., provided toward completion of the project. Total Cooperator indirect cost (overhead) is also included in this column.  All the costs listed here are an expense to the Cooperator."]
[]
[]
["(e) Value of Cooperator In-Kind Contribution:  Cooperator non-cash contributions provided toward completion of the project for which the Cooperator has incurred no expense.  These contributions can be made from the Cooperator or through the Cooperator by other entities and include such items as volunteer labor, donated materials, equipment, supplies, etc.  These values are not reimbursable and can only be used to satisfy the Cooperator's matching requirement."]
[]
[]
[]
["(f) Cash Contribution to the Forest Service:  Cooperator cash contribution provided to the Forest Service for use in completing the project.  This is an expense to the Cooperator.  Display by Cost Element where these funds will be expended. Be sure to cite a collection authority in the Agreement if this column is used."]
[]
[]
["(g) Third Party Cash Contribution Non-Federal: Cash contribution provided to the Cooperator from Non-Federal organization(s) for use in the project.  Display these contributions by Cost Element expenditures."]
[]
[]
["(h) Third Party Cash Contribution Federal:  Cash contributions provided to the Cooperator from Federal agency(ies) for use in the project.  Display these contributions by Cost Element expenditures."]
[]
[]
["(i) Third Party Non-Cash Contribution Non-Federal: Non-cash contribution provided to the Cooperator from Non-Federal organization(s) for use in the project. Display these contributions by Cost Element Expenditures. "]
[]
[]
["(j) Third Party Non-Cash Contribution Federal: Non-cash contribution provided to the Cooperator from Federal agencie(s) for use in the project. Display these contributions by Cost Element Expenditures."]
[]
[]
["(k) Third Party In-Kind Contribution Non-Federal: In-kind contribution provided to the Cooperator from Non-Federal organization(s) for use in the project. Display these contribtuions by Cost Element Expenditures."]
[]
[]
["(l) Third Party In-Kind Contribution Federal: In-kind contribution provided to the Cooperator from Federal agencie(s) for use in the project. Display these contributions by Cost Element Expenditures."]
[]
[]
["(m) Gross Total Project Value: The sum of all the values provided toward the project.  This figure reflects the true estimated cost of the project."]
[]
["(n)  Estimated Program Income:  The gross income estimated to be generated under the project between the effective date of award and completion of the project, such as conference or workshop fees received, rental fees earned from renting real property or equipment acquired with agreement funds, or the sale of commodities or items developed under the project."]
[]
[]
[]
["(o)  Net Total Project Value:  The sum of all the values provided toward the project with Estimated Project Income taken into consideration.  This figure reflects the true estimated cost of the project.  "]
[]
[]
[]
[]
[{"$nulls":6},"Burden Statement"]
[]
["According to the Paperwork Reduction Act of 1995, an agency may not conduct or sponsor, and a person is not required to respond to a collection of information unless it displays a valid OMB control number.  The valid OMB control number for this information collection is 0596-New.  The time required to complete this information collection is estimated to average 1 hour per response, including the time for reviewing instructions, searching existing data sources, gathering and maintaining the data needed, and completing and reviewing the collection of information.  "]
[]
["The U.S. Department of Agriculture (USDA) prohibits discrimination in all its programs and activities on the basis of race, color, national origin, age, disability, and where applicable, sex, marital status, familial status, parental status, religion, sexual orientation, genetic information, political beliefs, reprisal, or because all or part of an individual’s income is derived from any public assistance.  (Not all prohibited bases apply to all programs.)  Persons with disabilities who require alternative means for communication of program information (Braille, large print, audiotape, etc.) should contact USDA’s TARGET Center at 202-720-2600 (voice and TDD)."]
[]
["To file a complaint of discrimination, write USDA, Director, Office of Civil Rights, 1400 Independence Avenue, SW, Washington, DC 20250-9410 or call toll free (866) 632-9992 (voice).  TDD users can contact USDA through local relay or the Federal relay at (800) 877-8339 (TDD) or (866) 377-8642 (relay voice).  USDA is an equal opportunity provider and employer."]