HomeMy WebLinkAbout1_-_Original_Submission__Exhibit_D_2025_Funding_WorksheetElement Information Sources of Financing Worksheet
Organization Name:
Enter the organization provider name
Program Name
Enter the name of your Services Program or Project Name
Funding Source
Enter the name of funding sources that are currently, or anticipated, to fund the program in the grant
cycle year. In the following Funding Source sections you will enter the names of the other funding
sources that will be funding your services program.
This section consists of groups of funding sources including:
• 2024 CGAP Services Funding Request
• Federal Funding
• State Funding
• Local Funding
• Applicant Funding
• Private Funding
• In-Kind Funding
IMPORTANT: In row 8 the Total CGAP Requested Funds Source Name is entered, this will include all of
the funding sources (CDBG, HOME, AHGP/HHGP, MHCDTC, and CIAH) that are part of this
coordinated grant application. This should match your Total Requested amount in the CGAP Service
Committed
Enter the total amount of funding for the Funding Source that has been committed to fund the program
in the grant cycle year.
Conditional
Enter the total amount of funding for the Funding Source that is conditional (for example funding which
requires a match) to fund the program for the grant cycle year.
TentativeEnter the total amount of funding from the Funding Source that is tentative (for example funding that is
being applied for now or in the near future) to fund the program in the grant cycle year. Funding from
the CGAP process for funding from CDBG, HOME, AHGP/HHGP, MHCDTC, and CIAH will be entered into
this column in row 8.
Total
The Total is [calculated] by the Funding Source from each of the Committed, Conditional, and Tentative
Funding columns.
Kitsap County Human Services
Coordinated Grant Application Process
Homeownership Housing Budget and Financing 2025 Instructions
This form is collects information regarding the funding of your homeownership housing rehab program. Complete both Sources of Financing and Total
Program Budget worksheets. The Sources of Financing worksheet should include all sources of funding for the program, current and anticipated, in the
grant year. The Total Program Budget worksheet should show all costs to operate the program (i.e. staff costs, supplies, indirect overhead costs, etc.).
NOTE: If your agency does not operate more than one program, the program budget will be the same as your total agency budget. The salary of the
director is not a program. The director is part of the entire program, like a food bank, and you would include the director's salary along with all the other
costs for the program on the budget.
Column H
Column I [calculated]
REPORT FORM INSTRUCTIONS
Cells E2-G2
Cells E3-G3
Columns A-E
Column F
Column G
Docusign Envelope ID: 88A39940-C218-8CB2-82FC-7439F32AAA8D
Element Information Total Program Budget Worksheet
Organization Name:
The organization provider name - [linked] from the Sources of Financing worksheet
Program Name
The name of your Services Program or Project Name - [linked] from the Sources of Financing worksheet
Categories/Line Items
Includes a list of categories and sub-items that are common and expected expense types to operate a
program.
Categories include:
• Personnel - enter costs associated with program staff including salaries and fringe benefits
• Supplies & Equipment - enter office and program supplies and equipment that supports program
operations
• Administration - enter administrative expenses associated with this program
• Acquistion - enter costs for acquisition and appraisal costs
• Soft Costs - enter costs associated with design, engineering, permits, and fees.
• Hard Costs - enter costs associated construction/rehab work.
• Other - enter other expenses for your program not covered by categories but are necessary for
operating your program.
Please Note: Some Categories will include an "Other:" sub-item which you must edit and enter a name
if using this field for an expense.
Total CGAP Requested Funds
(CDBG, HOME, AHGP/HHGP, MHCDTC, CIAH)
In this column enter the amounts of Total CGAP Requested Funds will be used to support the program
by each of the Categories/Line Items listed in Column A. The Total of this column must match the Total
Request Amount from Cell I9 in your Sources of Financing.
- Row 6 [linked] Contains the Total Requested Amount from the Sources of Financing cell I9
- Row 62 [calculated] The Remaining funds to allocate to the Categories/Line Items as budgeted for
your program (Sources of Financing Total minus Budget Subtotals)
- Row 63 [calculated] The Total Project Budget for your Requested CGAP Funds. The calculated Total
must match the Total Requested Amount, if these amounts do not match this will result in an error
which will format the cell to display with a red background and white text. Once the Total Project
Budget and Requested CGAP Funds amount match the error formatting will be cleared.
Total Other Funds
(Federal, State, Local, Applicant, Private)
In this column enter the amounts of Total Other Funds which be used to support the program by each
of the Categories/Line Items listed in Column A. The Total of this column must match the total of all
other funding sources (Federal, State, Local, Applicant, Private, and In-Kind) that have been noted in the
Sources of Financing Worksheet as Committed, Conditional, or Tentative.
- Row 6 [linked] Contains the Sources of Financing Totals for all Other Funding source excluding
requests from the CGAP funds. This is a total which includes all other funding noted that is committed,
conditional, or tentative.
- Row 62 [calculated] The Remaining funds to allocate to the Categories/Line Items as budgeted for
your program (Sources of Financing Total minus Budget Subtotals)
- Row 63 [calculated] The Total Project Budget for your Total Other Funding Sources. The calculated
Total must match the Total Other Funding amount, if these amounts do not match this will result in an
error which will format the cell to display with a red background and white text. Once the Total Project
Budget and Other Total Funds amount match the error formatting will be cleared.
Total Program Budget
This column calculates amounts of Total CGAP Requested Funds and Total Other Funds which be used
to support the program by each of the Categories/Line Items listed in Column A.
- Row 6 [linked] Contains the Sources of Financing Totals cell I61 for all funding sources. This is a total
which includes all funding noted that is committed, conditional, or tentative.
- Row 62 [calculated] The Remaining funds to allocate to the Categories/Line Items as budgeted for
your program (Sources of Financing Total minus Budget Subtotals)
- Row 63 [calculated] The Total Project Budget for all Funding Sources. The calculated Total Project
Budget in cell F63 must match the Sources of Financing Totals cell I61 for all funding sources, if these
amounts do not match this will result in an error which will format the cell to display with a red
background and white text. Once the Total Project Budget in both the Total Program Budget and
Sources of Financing worksheets match the error formatting will be cleared.
Column F [calculated]
Cells B3-G3 [linked]
Cells B4-G4 [linked]
Column A
Column B
Column D
Docusign Envelope ID: 88A39940-C218-8CB2-82FC-7439F32AAA8D
Organization Name:
Program:
Committed Conditional Tentantive TOTAL
50,000.0 0 -$
50,000.0 -$ -$
178,149 178,149$
428,370 428,370$
-$
-$
-$
606,519$ -$ -$ 606,519$
100%
-$
-$
-$
-$
-$
-$ -$ -$ -$
518,088 518,088$
100,000 100,000$
-$
-$
-$
-$ -$ 618,088$ 618,088$
100%
-$
-$
-$
-$ -$ -$ -$
-$
-$
-$
-$
-$
-$ -$ -$ -$
744,268 744,268$
-$
-$
-$ -$ 744,268$ 744,268$
100%
606,519$ -$ 1,362,356$ 1,968,875$
31%69%
2025 City of Bremerton CDBG Award
Funding Source
2025 CGAP Grant Request
Total Requested Funds
Federal
Health & Human Services LIHEAP
Dept. of Energy BIL
Total State
Total Federal
State
Local
Puget Sound Energy
Cascade Natural Gas
Total In-Kind
TOTAL PROJECT FUNDING
Total Private
In-Kind
Total CGAP Requested Funds
(CDBG, HOME, MHCDTC, CIAH)
Kitsap Community Resources
Weatherization & Minor Home Repair
Weatherization Plus Health
Total Applicant
Private
Total Local
Applicant
Docusign Envelope ID: 88A39940-C218-8CB2-82FC-7439F32AAA8D
Organization Name:
Program:
Categories/Line Items Total City CDBG Funds %
Total Other Funds
(Federal, State, Local,
Applicant, Private)
%Total Program
Budget %
Sources of Financing Totals $ 50,000 3% $ 1,968,875 100%1,968,875$
Personnel
Managers and Staff (program related)36,000.00$ 2%385,116.00$ 20%421,116$ 21%
Fringe Benefits 15,500.00$ 1%170,603.00$ 9%186,103$ 9%
SUBTOTAL 51,500$ 3%555,719$ 28%607,219$ 31%
Supplies & Equipment
Equipment 0%2,274$ 0%2,274$ 0%
Office Supplies 2,124.00$ 0%7,206.00$ 0%9,330$ 0%
Other (describe):-$
SUBTOTAL 2,124$ 0%9,480$ 0%11,604$ 1%
Administration
Advertising/Marketing -$
Audit/Accouting -$
Communication 675$ 0%1,700$ 0%2,375$ 0%
Fees and Taxes -$
Indirect Administrative Expenses 17,600.00$ 1%328,100.00$ 17%345,700$ 18%
Insurance/Bonds 500.00$ 0%6,100.00$ 0%6,600$ 0%
Legal Services -$
Training 0%32,152.00$ 2%32,152$ 2%
Travel/Transportation 675$ 0%4,200$ 0%4,875$ 0%
Other (describe): postage, printing, bldg charge, copier, ect 8,926$ 0%15,255$ 1%24,181$ 1%
SUBTOTAL 28,376$ 1%387,507$ 20%415,883$ 21%
Acquisition Costs
Acquisition -$
Appraisal/Surveys -$
Other (describe):-$
Other (describe):-$
SUBTOTAL -$ -$ -$
Soft Costs
Appraisal -$
Design/Architecture -$
Engineering -$
Processing, Settlement, Financing -$
Other (describe):-$
Other (describe):-$
SUBTOTAL -$ -$ -$
Hard Costs
Clearance/Demolition -$
Construction/Rehab 118,000.00$ 6%1,016,169.00$ 52%1,134,169$ 58%
Other (describe):-$
Other (describe):-$
SUBTOTAL 118,000$ 6%1,016,169$ 52%1,134,169$ 58%
Other
Professional Services -$
Relocation -$
Other (describe):-$
Other (describe):-$
SUBTOTAL -$ -$ -$
REMAINING
(Sources of Financing Total minus Budget Subtotals)(150,000)$ -$ (200,000)$
TOTAL PROJECT BUDGET 200,000$ 1,968,875$ 2,168,875$
Enter the estimated costs associated with your project/program from CGAP Sources and from Other Funds
Kitsap Community Resources
Weatherization & Minor Home Repair
2025 Total Homeownership Housing Budget
Docusign Envelope ID: 88A39940-C218-8CB2-82FC-7439F32AAA8D