# Presentation: 674199

## IDIS CDBG Financial Summary Report

## What will you learn? 

- Participants will learn ...
- Line by line detailed explanation
- The key IDIS data fields
- How to do adjustments
- What additional info to include as attachment

## CDBG Financial Summary  (PR26)

- Allows Rep to review compliance with the following:
- 70% low/mod income benefit certification
- 15% public service cap calculation
- 20% planning and administration cap calculation

## CDBG Financial Summary  (PR26)

- Part I: 	Summary of CDBG Resources
- Part II: 	Summary of CDBG Expenditures
- Part III: 	Low/Mod Benefit Calculation
- Part IV:	Public Service Cap Calculation
- Part V: 	Planning/Admin Cap Calculation

## CDBG Financial Summary  (PR26)

**Part I: Summary of CDBG Resources**
- Funds unexpended from previous year
- Current year grant
- Surplus Urban Renewal
- Section 108 loan funds
- Program income
- Funds returned to Treasury
- Funds returned to local account

## Part II: Summary of Expenditures

Activity expenditures
Planning & administration expenditures
Section 108 loan repayments

- Activity expenditures
- Planning & administration expenditures
- Section 108 loan repayments

**CDBG Financial Summary  (PR26)**

## Part III: Low/Mod Benefit Calculation

Did You Meet the Overall Benefit Test?
Low/mod housing in NRSA expenditures
Low/mod multi-unit housing expenditures
Low/mod activities expenditures
Percent low/mod > 70%?
Total low/mod expenditures divided by total expenditures 
Include Section 108 and EDI/BEDI
Exclude P&A and Section 108 repayments 

- Did You Meet the Overall Benefit Test?
- Low/mod housing in NRSA expenditures
- Low/mod multi-unit housing expenditures
- Low/mod activities expenditures
- Percent low/mod _>_ 70%?
- Total low/mod expenditures divided by total expenditures
- Include Section 108 and EDI/BEDI
- Exclude P&A and Section 108 repayments

**CDBG Financial Summary  (PR26)**

## Part III: Low/Mod Benefit Calculation

Did You Meet the Overall Benefit Test?
Slum Blight and Urgent Need do not count 

- Did You Meet the Overall Benefit Test?
- Slum Blight and Urgent Need do not count

**CDBG Financial Summary  (PR26)**

## Part III: Low/Mod Benefit Calculation

Multi-Unit & Special Areas Housing Calculation
1) Identify low/mod percent
    6 low/mod occupants / 10 units = 60%
2) Identify percent paid with CDBG 
    $80,000 CDBG / $100,000 all funds = 80%
		If % CDBG funds < % low/mod occupants, full credit
3) Total funds eligible for low/mod
         60% low/mod occupants x $100,000 
	all funds = $60,000

- Multi-Unit & Special Areas Housing Calculation
**1) **Identify low/mod percent
-     6 low/mod occupants / 10 units = 60%
**2)** Identify percent paid with CDBG
-     $80,000 CDBG / $100,000 all funds = 80%
- 		If % CDBG funds _<_ % low/mod occupants, full credit
**3) **Total funds eligible for low/mod
-          60% low/mod occupants x $100,000
- 	all funds = $60,000

**CDBG Financial Summary  (PR26)**

## Part III: Low Mod Benefit Calculation

Multi-Unit & Special Areas Housing Calculation
4) 	Percent of CDBG funds low/mod
		$60,000 low/mod value / $80,000 CDBG = .75
5) Total CDBG low/mod credit for period
     $65,000 during period x .75 = $48,750 credit

- Multi-Unit & Special Areas Housing Calculation
- 4) 	Percent of CDBG funds low/mod
- 		$60,000 low/mod value / $80,000 CDBG = .75
- 5) Total CDBG low/mod credit for period
-      $65,000 during period x .75 = $48,750 credit

**CDBG Financial Summary  (PR26)**

## Part III: Low Mod Benefit Calculation

Multi-Year Certification
Cumulative expenditures
Includes Section 108 and EDI/BEDI
Excludes Slum Blight, Urgent Need, P&A and Section 108 loan repayments 
Divided by cumulative net expenditures 
Includes Section 108, EDI/BEDI, Slum Blight, Urgent Need
Excludes P&A and Section 108 loan repayments
Equal % meeting low/mod national objective
Must be > 70% during period

- Multi-Year Certification
- Cumulative expenditures
- Includes Section 108 and EDI/BEDI
- Excludes Slum Blight, Urgent Need, P&A and Section 108 loan repayments
- Divided by cumulative net expenditures
- Includes Section 108, EDI/BEDI, Slum Blight, Urgent Need
- Excludes P&A and Section 108 loan repayments
- Equal % meeting low/mod national objective
- Must be _>_ 70% during period

**CDBG Financial Summary  (PR26)**

## Part IV: Public Services Cap Calculation

Total expended for PS
Plus unliquidated at end of current year
Minus unliquidated at end of previous year
Equals total subject to cap
Cap total / (entitlement grant + prior year program income)
Equal public service obligation 
Must be < 15% unless exception granted

- Total expended for PS
- Plus unliquidated at end of current year
- Minus unliquidated at end of previous year
- Equals total subject to cap
- Cap total / (entitlement grant + prior year program income)
- Equal public service obligation
- Must be _<_ 15% unless exception granted

**CDBG Financial Summary  (PR26)**

## Part V: Planning/Administration Cap Calculation

**CDBG Financial Summary  (PR26)**

- Total expended for planning and administration
- Plus unliquidated at end of current year
- Minus unliquidated at end of previous year
- Equals total subject to cap
- Cap total / (entitlement grant + current year          program income)
- Equals planning/administration obligation
- Must be  20%

## Things to Remember

Prior year flag
Unliquidated obligation field
Correct low/mod activity identification
Adjustments
Expenditures not included during period
Expenditures included but should not have been
Funds available during period but not in IDIS

- Prior year flag
- Unliquidated obligation field
- Correct low/mod activity identification
- Adjustments
- Expenditures not included during period
- Expenditures included but should not have been
- Funds available during period but not in IDIS

**CDBG Financial Summary  (PR26)**

## Attachment

Explanation of adjustment amounts
if adjustment from prior year activity, provide the GPR where activity was listed
Program income
amount to individual revolving loan
float repayment
other loans by category, i.e. housing, ED
sale of property
Loans
# and balance by loans outstanding, forgiven/ deferred, default

- Explanation of adjustment amounts
- if adjustment from prior year activity, provide the GPR where activity was listed
- Program income
- amount to individual revolving loan
- float repayment
- other loans by category, i.e. housing, ED
- sale of property
- Loans
- # and balance by loans outstanding, forgiven/ deferred, default

**CDBG Financial Summary  (PR26)**

## Reconciliation of Line of Credit and Cash On Hand To Unexpended Balance
Unexpended amount at end of year
Add
LOC balance (provided by HUD)
Program income
Subrecipient program income
Revolving loan fund
Section 108 cash balances
Subtract
Liabilities during the year but drawn or to be drawn from LOC after end of program year 
Total will equal Reconciling Balance

- Unexpended amount at end of year
- Add
- LOC balance (provided by HUD)
- Program income
- Subrecipient program income
- Revolving loan fund
- Section 108 cash balances
- Subtract
- Liabilities during the year but drawn or to be drawn from LOC after end of program year
- Total will equal Reconciling Balance

**CDBG Financial Summary  (PR26)**

## Reconciliation of Line of Credit and Cash
On Hand To Unexpended Balance

Reconciling Balance should equal 	Unexpended Balance
If not, explain
Problem
HUD LOC balance may reflect prior year or future 	year draws  
Failure to use Prior Year Flag

**On Hand To Unexpended Balance**
- Reconciling Balance should equal 	Unexpended Balance
- If not, explain
- Problem
- HUD LOC balance may reflect prior year or future 	year draws
- Failure to use Prior Year Flag

**CDBG Financial Summary  (PR26)**

## CDBG Financial Summary  (PR26)

**Returning Funds Drawn in IDIS**
- HUD activity #2: CDBG Funds Adjustment
- Returned in form of negative amount
- Must use Maintain Drawdown to undo original draw

## Slide 19

## Slide 20

## Slide 21

## Questions? 

## CDBG Financial Summary  (PR26)

- Time for a Case Study