FS-1500-21b Stewardship Financial Plan

Federal and Non-Federal Financial Assistance Instruments

FS 1500-21B Stewardship Financial Plan.xlsx

Private Sector - Federal/Non-Federal Financial Assistance Instruments

OMB: 0596-0217

Document [xlsx]
Download: xlsx | pdf

Overview

Financial Plan-Long Form
D - Financial Plan Crosswalk


Sheet 1: Financial Plan-Long Form

Agreement Financial Plan

PROJECT NAME:





USFS AGREEMENT NO:
Mod No: 00








PARTNER AGREEMENT NO:








1. Financial Plan Matrix:


















FOREST SERVICE CONTRIBUTIONS



PARTNER CONTRIBUTIONS

FSDefaultUser: (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.
FSDefaultUser: (c) Forest Service Obligation to Pay Cooperator Expenses: This is the maximum Forest Service funding to be obligated under the agreement for advance or reimbursement of the Forest Service share of cooperator expenses. This is an expense to the Forest Service. Paynment for Services not contributed by Cooperator in exceeding product value.

FSDefaultUser: (b) Value of Forest Products appraised by the FS.

FSDefaultUser: Cooperator Services for Exchange Contribution. Cooperator contributions may consist of employee salaries, overhead, travel provided, and/or equipment and supplies purchased and provided for use in the performance of service work (stewardship items). These services are an expense to the Cooperator, and are exchanged for product value.
FSDefaultUser: Cooperator Noncash Contribution. Cooperator noncash contributions may consist of employee salaries, overhead, travel provided, and/or equipment and supplies purchased and provided for use in the project. These costs are an expense to the Cooperator, and are not reimbursed by the FS.
FSDefaultUser: (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.
FSDefaultUser: (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.
USDA Forest Service: UNHIDE COLUMNS L-Q FOR THIRD PARTY CONTRIBUTIONS! To unhide, highlight columns L-R. Then choose format, column, unhide.










(b)
Cash to Partner
*(1)

(c)
Appraised Value of Forest Product
Non-Cash

(d)
Services Exchanged for Product Value (2)


(g)
Cash *(3)

(h) (i) (j) (k) (l) (m)


(a)

(e) (f)
THIRD PARTY

COST ELEMENTS Non-Cash

Non-Cash In-Kind
Cash Non-Cash In-Kind (n)
Total







FSDefaultUser: (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.
FSDefaultUser: (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.
FSDefaultUser: (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.
FSDefaultUser: (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.
FSDefaultUser: (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.
FSDefaultUser: (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.

Direct Costs:





Non-Fed Federal Non-Fed Federal Non-Fed Federal
Salaries/Labor
*(5)






$0.00
Travel
*(5)






$0.00
Equipment

*(5)






$0.00
Supplies

*(5)






$0.00
Materials
*(5)






$0.00
Printing
*(5)





$0.00
Planned service work to be contracted - This cost element can be replaced with a cost element unique to your agreement.

*(5)




*(4)
$0.00
Planned service work to be contracted - This cost element can be replaced with a cost element unique to your agreement.
*(5)



*(4)
$0.00
Planned service work to be contracted - This cost element can be replaced with a cost element unique to your agreement.
*(5)


*(4)
$0.00
Product Value


Appraisal for timber reported on an FS2400-17 or bid value as applicable.




Cash Product Value equals Residual Receipts paid to the government by the cooperator. Once agreement has been closed, excess money will move from residual receipts to retained receipts. *(6)


$0.00
Subtotal $0.00 $0.00
$0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
Indirect Costs

*(5)





$0.00
Total $0.00 $0.00
$0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
















Total Forest Service Contributions: $0.00

Total Partner & Third Party Contribution less Exchanged Services (Col D):



$0.00






















(1) See Tab D Financial Plan Crosswalk for service work to be paid for by the FS
(2) See Tab D Financial Plan Crosswalk for service work exchanged for product appraised value. Partner reimbursed by sale of product.
(3) See Tab D Financial Plan Crosswalk for service work to be paid for with Partner cash contribution (collection for CWKV, BD, and coop funds [RM, SRR, etc.] not allowed)
(4) See Tab D Financial Plan Crosswalk for contributed service work (Rows 20-22*, Columns E-M).
(5) Enter in TSA amounts in Column B that are also included in Tab D Financial Plan Crosswalk and Appendix E Schedule of Items and Specifications
(6) Residual Receipts: Column G Partner Cash – Receipts paid to FS by Partner – Moved to retained receipts once agreement closed

If indirect costs (column B, row 29) will be reimbursed and/or exchanged for product (column D, row 29) the total dollar amount of indirect costs can be prorated between all lines of services listed in Column B and/or Column D on Tab D - Financial Plan Crosswalk and in Appendix E - Schedule of Items and Specifications.
Orange fields identify all service work, by unit price, and must equal Appendix E - Schedule of Items and Specifications. Tab D Financial Plan Crosswalk identifies how total services are funded .
Green fields identify possible TSA data figures.



















Matching Costs Determination















Total Forest Service Share =
(p)















(a+b+c)/(n) = (p)
#DIV/0!































Third Party Contribution-- Federal =
(q)














(i+k+m)/(n) = (q)
#DIV/0!


































Total Federal Share =
(r)














(p+q) = (r)
#DIV/0!


































Total Partner Share
(s)














[(e+f+g+h+j+l) / (n) = (s)
#DIV/0!


































(t)















Total (r+s) = (t)
#DIV/0!

































2. Cost Analysis:

















Use the following section to show additional information that supports the lump sum figures provided above. The following Cost Analysis boxes, (a)-(m), should provide a cost analysis of the corresponding matrix columns, (a)-(m), above, e.g. matrix column (a) FS Non-Cash Contribution should be analyzed under block (a), below, and matrix column (b) Obligation to Pay Partner Costs 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.




















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.


FS Non-Cash Contributions ONLY: EXAMPLE Column (a): Salary GS 11 Biologist @ 40 hrs x $25.02/hr = $1,000.80, GS 5 Crew Leader @ 80 hrs x $12.79/hr = $1,023.20, GS 3 Crew 3 x 80hrs x $10.19/hr = $2445.60; Travel 12 round trips x 50 miles x $.375/mi. = $225; Indirect Cost: $4,694.60 x 19.2% = $901.36 Column (a)

FS Non-Cash Contribution



























The amount the FS will be reimbursing above the contributed product in Column C. EXAMPLE Column (c): Salary: GS 11 Biologist @ 40 hrs x $25.02/hr = $1,000.80, GS 5 Crew Leader @ 80 hrs x $12.79/hr = $1,023.20, GS 3 Crew 3 x 80hrs x $10.19/hr = $2445.60; Travel: 12 round trips x 50 miles x $.375/mi. = $225; Indirect Cost: $4,694.60 x 19.2% = $901.36 Column (b)

FS Cash to Partner




















The Forest Service appraised value or higher bid value of product provided to Cooperator in exchange for their services.(1) See Appendix E Schedule of Items for service work and include services in Tab D Funding Breakdown to identify all services to be paid for by the FS Column (c)

Value of Forest Products to Reimburse Partner
























Cooperators services in the amount they will provide to receive product of same amount in Column C. Costs in rows 14 through 19 should be prorated to costs in rows 20 through 26. EXAMPLE Column (d): Salary: GS 11 Biologist @ 40 hrs x $25.02/hr = $1,000.80, GS 5 Crew Leader @ 80 hrs x $12.79/hr = $1,023.20, GS 3 Crew 3 x 80hrs x $10.19/hr = $2445.60; Travel: 12 round trips x 50 miles x $.375/mi. = $225; Indirect Cost: $4,694.60 x 19.2% = $901.36 Column (d)

Services for exchange














































FSDefaultUser: Cooperator Non-Cash Contributions ONLY: EXAMPLE Column (d): Salary: GS 11 Biologist @ 40 hrs x $25.02/hr = $1,000.80, GS 5 Crew Leader @ 80 hrs x $12.79/hr = $1,023.20, GS 3 Crew 3 x 80hrs x $10.19/hr = $2445.60; Travel: 12 round trips x 50 miles x $.375/mi. = $225; Indirect Cost: $4,694.60 x 19.2% = $901.36 Column (e)

Partner Non-Cash Contribution














































Cooperator In-Kind Contributions ONLY: EXAMPLE Column (e): Salary: GS 11 Biologist @ 40 hrs x $25.02/hr = $1,000.80, GS 5 Crew Leader @ 80 hrs x $12.79/hr = $1,023.20, GS 3 Crew 3 x 80hrs x $10.19/hr = $2445.60; Travel: 12 round trips x 50 miles x $.375/mi. = $225; Indirect Cost: $4,694.60 x 19.2% = $901.36 Column (f)

Partner In-Kind Contribution


























FSDefaultUser: Cooperator Cash Contributions ONLY: EXAMPLE Column (f): Salary: GS 11 Biologist @ 40 hrs x $25.02/hr = $1,000.80, GS 5 Crew Leader @ 80 hrs x $12.79/hr = $1,023.20, GS 3 Crew 3 x 80hrs x $10.19/hr = $2445.60; Travel: 12 round trips x 50 miles x $.375/mi. = $225; Indirect Cost: $4,694.60 x 19.2% = $901.36 Column (g)

Partner Cash Contribution










































FSDefaultUser: "The funding shown in this column is funding being sought from several sources for adequate fuding to make this project viable. It will be used to cover contract costs. If outside funding sources are obtained, this Stewardship Agreement will be modified to reflect that in this Financial Plan." Column (h)
Partner 3rd Party Cash-Non Fed.





















Column (i)

Partner 3rd Party Cash-Fed.




















Column (j)

Partner 3rd Party Non-Cash Non-Fed.




















Column (k)

Partner 3rd Party Non-Cash Fed.




















Column (l)

Partner 3rd Party In-Kind Non-Fed.




















Column (m)

Partner 3rd Party In-Kind Fed.







































3. Instructions: Use this form in conjunction with FSH 1509.11 Chapter 70




































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) Forest Service Cash to Pay Partner Expenses: This is the maximum Forest Service funding to be obligated under the agreement for advance or reimbursement of the FS share of partner expenses. This is an expense to the Forest Service.







































(c) Appraised or Bid Value of Forest Products: Per 36 CFR 223.60 appraisal establishing value of forest products that can be exchanged for stewardship items (project work) provided by Partner. If Partner subcontracts removal and obtains bids, this amount should be used to value products for exchange.





















(d) Partner services exchanged for product value. Stewardship service work performed by Partner in exchange for forest product.





















(e) Partner Non-Cash Contribution: Partner employee salaries, travel, equipment, supplies, etc., provided toward completion of the project. Total Partner indirect cost (overhead) is also included in this column. All the costs listed here are an expense to the Partner.






















(f) Value of Partner In-Kind Contribution: Partner contributions provided toward completion of the project for which the Partner has incurred no expense. These contributions can be made from the Partner or through the Partner 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 Partner's matching requirement.





















(g) Partner Cash to the FS: Required cash deposits per Appendix F-Timber Removal Specifications. This is an expense to the Partner.




















(h) Third Party Cash Contribution Non-Federal: Cash contribution provided to the Partner from Non-Federal organization(s) for use in the project. Display these contributions by cost element expenditures.




















(i) Third Party Cash Contribution Federal: Cash contributions provided to the Partner from Federal agency(ies) for use in the project. Display these contributions by cost element expenditures.




















(j) Third Party Non-Cash Contribution Non-Federal: Non-cash contribution provided to the Partner from Non-Federal organization(s) for use in the project. Display these contributions by cost element expenditures.




















(k) Third Party Non-Cash Contribution Federal: Non-cash contribution provided to the Partner from Federal agencie(s) for use in the project. Display these contributions by cost element expenditures.







































(l) Third Party In-Kind Contribution Non-Federal: In-kind contribution provided to the Partner from Non-Federal organization(s) for use in the project. Display these contributions by cost element expenditures.




















(m) Third Party In-Kind Contribution Federal: In-kind contribution provided to the Partner from Federal agencie(s) for use in the project. Display these contributions by cost element expenditures.




















(n) Total Project Value: The sum of all the values provided toward the project. This figure reflects the true estimated cost of the project.







































































































































































































































































































































































































































































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 XX minutes/hours 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.

Sheet 2: D - Financial Plan Crosswalk

PROJECT NAME:











USFS AGREEMENT NO:












PARTNER AGREEMENT NO:













Mod No:














TAB D















FINANCIAL PLAN CROSSWALK











[Instructions: Complete this form when forest products will be exchanged for services.]



















Enter Item as a number. Entering an alpha character will cause errors in the calculations on this worksheet
Enter Item as a number. Entering an alpha character will cause errors in the calculations on this worksheet

Enter Item as a number. Entering an alpha character will cause errors in the calculations on this worksheet



Enter Item as a number. Entering an alpha character will cause errors in the calculations on this worksheet






Item No: Description Method of Meas. Unit Quantity USDA Forest Service: Agreed to unit price Unit Price USDA Forest Service: Total services should equal amounts in FP Columns B & D, and E thru M Rows 20-22* Total USDA Forest Service: FP column D Breakdown of Services to be paid for with appraised product value USDA Forest Service: FP Column B, Negotiated cost elements included in the unit rate. Breakdown of Services to be paid for with Federal Dollars FP column G, Partner cash contribution paid to FS. Breakdown of Services to be paid for with Partner Cash Contribution USDA Forest Service: Cooperator contributed service work; rows 20-22*, columns E thru M (but not column G) Total Partner Provided Service Work Completed Date

















USDA Forest Service: (For example purposes, I am adding Identifier for Mandatory Items and adding Optional Items for future inclusion if funds or product value became available. Mandatory Stewardship Projects:












01 Planned service work to be contracted - This cost element can be replaced with a cost element unique to your agreement.
















02 Planned service work to be contracted - This cost element can be replaced with a cost element unique to your agreement.













03 Planned service work to be contracted - This cost element can be replaced with a cost element unique to your agreement.
















04 Planned service work to be contracted - This cost element can be replaced with a cost element unique to your agreement.
















05 Planned service work to be contracted - This cost element can be replaced with a cost element unique to your agreement.
















06 Planned service work to be contracted - This cost element can be replaced with a cost element unique to your agreement.
















07 Planned service work to be contracted - This cost element can be replaced with a cost element unique to your agreement.














USDA Forest Service: (For example purposes, I am adding Identifier for Mandatory Items and adding Optional Items for future inclusion if funds or product value became available. Optional :















Op2
DQ














2a
DQ














2b
DQ

















TOTAL:
$0.00 $0.00 $0.00 $0.00 $0.00

























TOTAL APPRAISED VALUE OF FOREST PRODUCT FROM FINANCIAL PLAN:




$0.00





























Difference Should be Zero


$0.00









File Typeapplication/vnd.openxmlformats-officedocument.spreadsheetml.sheet
File Modified0000-00-00
File Created0000-00-00

© 2024 OMB.report | Privacy Policy