Spreadsheet

---

Overview

RES-EEI grants Interim Rule
grants cost to government
RES-EEI loan Interim Rule
loan cost to government
Totals

---

Sheet 1: RES-EEI grants Interim Rule

Section of				Reports	Total Annual	Est. No. of	Est. Total		Total
Interim		Form No.	Est. No. of	Filed	Responses	Man hours	Man-hours	Wage	Cost
4280.XXX	Title	(if Any)	Respondents	Annually	(D) x (E)	Per Response	(F) x (G)	Class	(H) x (I)
(A)	(B)	(C)	(D)	(E)	(F)	(G)	(H)	(I)	(J)
	REPORTING REQUIREMENTS - NO FORMS
105	Appeals	written	ken.meardon: 1898*0.0025 rounded up to 5 5	1	5	12	60	60	$3,600
FR Notice	SAM number for application	written	3,619	1	3,619	1	3,619	60	$217,140
116(b)(1)(vi)	DUNS	written	3,619	1	3,619	1	3,619	60	$217,140
	Full Applications
116(b)(1)(ii)(C)	Cerification for contracts, grants, and loans" 7 CFR 3018.110, grant exceeds $100,000	written	366	1	366	0.08	29	60	$1,757
116(b)(1)(ii)(H)	Association or Relationship with Rural Development Employees	written	366	1	366	0.25	92	60	$5,490
116(b)(2), (3), and (5)	Application Narrative - RES	written	285	1	285	40	11,400	60	$684,000
116(b)(2), (3), and (5)	Application Narrative - EEI	written	81	1	81	40	3,240	60	$194,400
116(b)(4)	Financial information (past, present and future)	Balance sheets and income statements	366	1	366	20	7,320	60	$439,200
116(b)(6)	Self-scoring documentation	written	amy.cavanaugh: Assumes that 50% of applicants will provide self-score documentation. 183	1	183	1.5	275	60	$16,470
116(b)(7)(ii)(A)	Technical Reports - RES	Appendix B, C, or D	285	1	285	25	7,125	60	$427,500
116(b)(7)(ii)(A)	Technical Reports - EEI	Appendix B	81	1	81	25	2,025	60	$121,500
116(b)(7)(ii)(B)	Energy Audit - EEI (>$50,000)	written	81	1	81	16	1,296	60	$77,760
116(b)(8)	Feasibility study - RES		285	1	285	40	11,400	60	$684,000
118	Insurance (flood, business interruption)	written	73	1	73	1.5	110	60	$6,588
	Simplified Applications
116(b)(1)(ii)(C)	Cerification for contracts, grants, and loans" 7 CFR 3018.110, grant exceeds $100,000	written	3,253	1	3,253	0.08	260	60	$15,614
116(b)(1)(ii)(H)	Association or Relationship with Rural Development Employees	written	3,253	1	3,253	0.25	813	60	$48,795
116(b)(2) through (5)	Application Narrative - RES	written	1,297	1	1,297	40	51,880	60	$3,112,800
116(b)(2) through (5)	Application Narrative - EEI	written	1,956	1	1,956	40	78,240	60	$4,694,400
116(b)(6)	Self-scoring documentation	written	ken.meardon: D25 divided by 2 and rounded up to 1627 1,627	1	1,627	1.5	2,441	60	$146,430
116(b)(7)(i)(A)	Technical Reports - RES	Appendix A, C, or D	1,297	1	1,297	25	32,425	60	$1,945,500
116(b)(7)(i)(A)	Technical Reports - EEI	Appendix A	1,956	1	1,956	25	48,900	60	$2,934,000
116(b)(7)(i)(B)	Energy Audit - EEI (>$50,000)	written	ken.meardon: 1956 times 0.3 and rounded up to 587 587	1	587	16	9,392	60	$563,520
118	Insurance (flood, business interruption)	written	3,253	1	3,253	0.5	1,627	60	$97,590
	Grantee Award Requirements
116(b)(5)	Evidence of matching funds	written	1,898	1	1,898	1	1,898	60	$113,880
121 (Dept Reg)	Programmatic changes	written	ken.meardon: 1898 time 0.1 and rounded up to 19 for this cell and the next three cells down 19	1	19	0.5	10	60	$570
121 (1951(e))	Transfers	written	38	1	38	0.5	19	60	$1,140
122 (1951(e))	Disposition instructions for acquired property	written	19	1	19	0.5	10	60	$570
126(b)	Power purchase agreement	written	amy.cavanaugh: Average number of wind obligations 95	1	95	1.5	143	60	$8,550
FR Notice	Maintenance for SAM reporting	written	1,898	1	1,898	1	1,898	60	$113,880
Grant agreement	Semiannual Project Performance Report	written	1,824	2	3,648	1	3,648	60	$218,880
Grant agreement	Final Project Performance Report - RES	written	533	1	533	2	1,066	60	$63,960
Grant agreement	Final Project Performance Report - EEI	written	1,365	1	1,365	1	1,365	60	$81,900
Grant agreement	Outcome Project Performance Reports - RES	written	533	1	533	2	1,066	60	$63,960
Grant agreement	Outcome Project Performance Reports - EEI	written	1,365	1	1,365	1	1,365	60	$81,900
	REPORTING REQUIREMENTS - FORMS APPROVED WITH THIS DOCKET
120(b)	Rural Business Cooperative Service Grant Agreement	RD 4280-2	1,898	1	1,898	1	1,898	60	$113,880
116(b)(1)(ii)(A)	Cert. Regarding Drug-Free Workplace Req. (Grants) Alt. I - For Grantees Other Than Individuals	AD -1049	amy.cavanaugh: Total apps on hand and average grant and grant combos 3,619	1	3,619	0.25	905	60	$54,285
116(b)(1)(ii)(B)	Certification Regarding Debarment, Suspension, Ineligibility, and Voluntary Exclusion - Lower Tier Covered Transactions	AD-1048	amy.cavanaugh: total obligations plus one contractor per RES project 2,431	1	2,431	0.25	608	60	$36,465
116(b)(1)(ii)(E)	Certification Regarding Debarment, Suspension & Other Resp. Matters-Primary Covered Trans.	AD-1047	amy.cavanaugh: Total apps on hand and average grant and grant combos 3,619	1	3,619	0.25	905	60	$54,285
	Average per year				51,152		294,388		17,663,299
	Total over the three years				153,457		883,165		$52,989,898
	REPORTING REQUIREMENTS - FORMS APPROVED UNDER OTHER OMB NUMBERS
116(b)(1)(i)(A)	Application for Federal Assistance	SF 424 (4040-0004)	amy.cavanaugh: Total apps on hand and average grant and grant combos 3,619	1	3,619	1	3,619	0	$0
116(b)(1)(i)(B)	Budget Information - Construction Programs	SF 424C (4040-0008)	amy.cavanaugh: Total apps on hand and average grant and grant combos 3,619	1	3,619	3	10,857	0	$0
116(b)(1)(i)(C)	Assurances - Construction Programs	SF 424D (4040-0009)	amy.cavanaugh: Total apps on hand and average grant and grant combos 3,619	1	3,619	0.25	905	0	$0
116(b)(1)(i)(D)	Environmental Analysis	RD 1940-20	amy.cavanaugh: Total apps on hand and average grant and grant combos 3,619	1	3,619	6	21,714	0	$0
116(b)(1)(ii)(D)	Disclosure of Lobbying Activities	SF LLL (0348-0046)	amy.cavanaugh: Average number of grant $100k or above 74	1	74	0.16	12	0	$0
116(b)(1)(ii)(F)	Equal Opportunity Agreement	RD 400-1	amy.cavanaugh: Total apps on hand and average grant and grant combos 3,619	1	3,619	0.16	579	0	$0
116(b)(1)(ii)(G)	Assurance Agreement	RD 400-4	amy.cavanaugh: Total apps on hand and average grant and grant combos 3,619	1	3,619	0.25	905	0	$0
119(e)(8)	Certificate of Contractor's Release	RD 1924-9	1,898	1	1,898	0.25	475	0	$0
119(e)(8)	Release by Claimants	RD 1924-10	1,898	1	1,898	0.5	949	0	$0
119(e)	Construction Contract	RD 1924-6	533	1	533	0.25	133	0	$0
119(e) (via RD1924-6)	Compliance Statement	RD-400-6	533	1	533	0.25	133	0	$0
120(a)	Letter of Intent	RD 1942-46	1,898	1	1,898	1.5	2,847	0	$0
120(a)	Request for Obligation of Funds	RD 1940-1	1,898	1	1,898	0.25	475	0	$0
121	Outlay Report and Request for Reimbursement for Construction Programs	SF 271 (0348-0002)	1,898	2	3,796	1	3,796	0	$0
Grant agreement	Federal Financial Report	SF 425 (0348-0061)	1,898	2	3,796	1.5	5,694	0	$0
Grant agreement	Performance Progress Report	SF PPR (0970-0334)	74	2	148	0.43	64	0	$0

---

Sheet 2: grants cost to government

Cost to the Federal Government - Grants
Activity		Number		# of Hours		Rate		TOTAL
Application review		3,619		20		$42		$3,039,960
Technical merit review		3,619		4		$42		$607,992
Approve and obligate funds		1,898		8		$42		$637,728
Servicing actions other than monitoring		36		4		$42		$6,048
Planning and Performance		533		16		$42		$358,176
Reporting and Grant Disbursement		1898		16		$42		$1,275,456
Appeals		5		16		$42		$3,360
Administrative Costs								$697,200
ANNUALIZED TOTAL								$6,625,920
The reviews are typically completed by GS-11 & 12 State Loan Specialists and GS-13
State Program Directors. The loans are typically approved by the State Director.
The GS-8 or 9 State Loan Technician typically does the data entry in the computer system.

---

Sheet 3: RES-EEI loan Interim Rule

Section of				Reports	Total Annual	Est. No. of	Est. Total		Total
Interim Rule		Form No.	Est. No. of	Filed	Responses	Man hours	Man-hours	Wage	Cost
4280.XXX	Title	(if Any)	Respondents	Annually	(D) x (E)	Per Response	(F) x (G)	Class	(H) x (I)
(A)	(B)	(C)	(D)	(E)	(F)	(G)	(H)	(I)	(J)
REPORTING REQUIREMENTS - NO FORMS
	REPORTING REQUIREMENTS - FORMS APPROVED WITH THIS DOCKET
105	Appeals	written	5	1	5	12	60	$60	$3,600
FR Notice	SAM number applications	written	15	1	15	1	15	$60	$900
116(b)(1)(vi)	DUNS	written	15	1	15	1	15	$60	$900
128(b)(1)(ii)-(v)	Application Narrative - RES	written	13	1	13	40	520	$60	$31,200
128(b)(1)(ii)-(v)	Application Narrative - EEI	written	2	1	2	40	80	$60	$4,800
128(b)(1)(vi)	Technical Reports - RES	Appendix C	13	1	13	25	325	$60	$19,500
128(b)(1)(vi)	Technical Reports - EEI	Appendix A	2	1	2	20	40	$60	$2,400
128(b)(2)(iii)	Personal credit reports	written	820	1	820	2	1,640	$60	$98,400
128(b)(2)(iv)	Appraisals	written	amy.cavanaugh: loan request above $600k average obligation plus on hand 36	1	36	2	72	$60	$4,320
128(b)(2)(v)	Commercial credit reports	written	amy.cavanaugh: Loan only 15	1	15	2	30	$60	$1,800
128(b)(2)(vi)	Personal and corporate financial statements of guarantors	written	835	1	835	2	1,670	$60	$100,200
128(b)(2)(vii)	Financial information (past, present and future)	Balance sheets and income statements	15	1	15	20	300	$60	$18,000
128(b)(1)(viii)	Feasibility study - RES	Appendix D	amy.cavanaugh: Loan only count combos counted under grants 13	1	13	20	260	$60	$15,600
128(b)(1)(ix)	Lender's analysis	written	amy.cavanaugh: All loan only and combos 820	1	820	1.5	1,230	$60	$73,800
128(b)(1)(x)	Lender's certification	written	amy.cavanaugh: All loan only and combos 820	1	820	0.5	410	$60	$24,600
128(b)(1)(xi)	Proposed or sample loan agreement	written	amy.cavanaugh: All loan only and combos 820	1	820	2	1,640	$60	$98,400
149	Outcome project performance	written	15	1	15	2	30	$60	$1,800
137	Repurchase from holder	written	amy.cavanaugh: 3 done as of 2011 3	1	3	2.5	8	$60	$450
138	Replacement of document	written	1	1	1	2	2	$60	$120
125(b)	Interest rate change	written	4	1	4	0.5	2	$60	$120
131(d)	Planning and performing development for lender	wriiten	15	1	15	12	180	$60	$10,800
144	Transfer of lender	written	11	1	11	1	11	$60	$660
145	Changes in borrowers	written	21	1	21	1	21	$60	$1,260
146	Conditions precedent to issuance of guarantee	written	559	1	559	2	1,118	$60	$67,080
147	Issuance of loan note guarantee	written	559	1	559	1	559	$60	$33,540
148	Refusal to issue loan note guarantee	written	3	1	3	3	9	$60	$540
152(a)	Loan classification	written	556	1	556	0.5	278	$60	$16,680
152(a)	Agency and lender conference	written	amy.cavanaugh: above $600k 36	1	36	1.5	54	$60	$3,240
152(a)	Quarterly financial reports	written	559	4	2236	0.5	1,118	$60	$67,080
152(a)	Annual financial reports	written	559	1	559	2	1,118	$60	$67,080
FR Notice	Maintenance for SAM reporting	written	15	1	15	1.5	23	$60	$1,350
152(a)	Borrower visits	written	559	1	559	2	1,118	$60	$67,080
152(b)	Interest rate adjustments	written	3	1	3	0.5	2	$60	$90
152(c)	Release of collateral	written	6	1	6	2	12	$60	$720
152(d)	Subordination of lien position	written	6	1	6	2	12	$60	$720
152(e)	Alterations of loan instruments	written	3	1	3	1.5	5	$60	$270
152(f)	Loan transfer and assumption	written	6	1	6	3.5	21	$60	$1,260
152(f)(1)	Credit reports	written	amy.cavanaugh: Number of transfer and assumptions plus liquidation plans 9	1	9	0.5	5	$60	$270
152(f)	Appraisal reports	written	16	1	16	1	16	$60	$960
153	Substitution of lender	written	3	1	3	1	3	$60	$180
154	Default by borrower	written	3	1	3	1	3	$60	$180
154	Curative actions	written	3	1	3	1.5	5	$60	$270
155	Protective advances	written	3	1	3	1	3	$60	$180
156	Liquidation plan	written	3	1	3	6	18	$60	$1,080
156	Acceleration	written	3	1	3	0.5	2	$60	$90
156	Accounting and reports	written	amy.cavanaugh: above $600k 36	1	36	0.5	18	$60	$1,080
160	Termination of guarantee	written	56	1	56	0.5	28	$60	$1,680
REPORTING REQUIREMENT - FORMS APPROVED UNDER THIS DOCKET
182(a)(2)(i)	Application for a loan guarantee (>$600,000)	RD 4279-1 (0570-0017)	110	1	110	4	440	$60	$26,400
128(c)	Application for a loan guarantee (<$600,000)	4279-1A (0570-0017)	710	1	710	3	2,130	$60	$127,800
143	Conditional Commitment	RD 4279-3 (0570-0017)	559	1	559	0.25	140	$60	$8,385
147(b)	Lender's Agreement	RD 4279-4	559	1	559	2	1,118	$60	$67,080
134	Assignment Guaranteed Agreement	RD 4279-6 (0570-0017)	ken.meardon: 559 times 0.0025 rounded down to 1 1	1	1	0.33	0	$60	$20
142(a)	Unconditional Guarantee	RD 4279-14	559	1	559	0.5	280	$60	$16,770
	3-year Average Totals				12,068		18,213		$1,092,785
	Totals for 3 years				36,204		54,639		3,278,354
REPORTING REQUIREMENTS - FORMS APPROVED UNDER OTHER OMB NUMBERS
128(b)(2)(ii)	Environmental Analysis	RD 1940-20	15	1	15	1	15	$0	$0
147(a)(3)	Guaranteed Loan Closing Report	RD 1980-19 (0575-0137)	559	1	559	1	559	$0	$0
152(f)(4)	Loan Note Guarantee Report of Loss	RD 449-30 (0575-0137)	559	1	559	25	13,975	$0	$0
152(a)	Guaranteed Loan Status Report	RD 1980-41 (0570-0016)	559	2	1118	0.33	369	$0	$0
156	Lender's Guaranteed Loan Payment to the Agency	RD 1980-43 (0575-0137)	559	1	559	0.5	280	$0	$0
154	Guaranteed Loan Deliquent Status Borrower	RD 1980-44 (0570-0016)	3	6	18	0.33	6	$0	$0

---

Sheet 4: loan cost to government

Cost to the Federal Government - Loans
Activity		Number		# of Hours		Rate		TOTAL
Review application and lender's analysis and complete negotiations, site visit and environmental review		835		20		$42		$701,400
Review Technical Reports		15		4		$42		$2,520
Approve loan and obligate funds		559		8		$42		$187,824
Review documents and issue guarantee		559		6		$42		$140,868
Replacement of documents		1		3		$42		$126
Appeals		5		16		$42		$3,360
Financial statement review		559		3		$42		$70,434
Servicing actions		559		4		$42		$93,912
Borrower/lender visits		559		3		$42		$70,434
Outcome project performance		15		1		$42		$630
ANNUALIZED TOTAL								$1,271,508
The reviews are typically completed by GS-11 & 12 State Loan Specialists and GS-13
State Program Directors. The loans are typically approved by the State Director.
The GS-8 or 9 State Loan Technician typically does the data entry in the computer system.

---

Sheet 5: Totals

Program	Number of respondents	Total Annual	Est. Total	Wage	Total	Number of hours per response
		Responses	Man-hours	Class	Cost
RES-EEI Grant	3619	51,152	294,388	$60	$17,663,299	5.76
RES-EEI Loan	820	12,068	18,213	$60	$1,092,785	1.51
Total # of unique respondents	3634	63,220	312,601		$18,756,084	4.94	Average hour per response