Spreadsheet

---

Overview

rollup
commfacility
waterwaste
bandi
reseei
cost to government

---

Sheet 1: rollup

		Form	Estimated	Reports	Total Annual	Est'd # of	Est. Total	Wage	Total
Sec.	Title	Number	Number of	Filed	Responses	Man-hours	Man-hours	Class	Cost
		(if any)	Respondents	Annually	(D) x (E)	per response	(F) x (G)		(H) x (I)
(A)	(B)	(C)	(D)	(E)	(F)	(G)	(H)	(I)	(J)
5001.4	Oversight and monitoring
(b)(3)	Notifications		314		314	1	314		$18,840
5001.6	Project eligibility
(d)(2)	Notice to unserved		5		5	1	5		$300
5001.11	Guarantee Application Process
(a)(1)	Preapplications		237		237	3	711		$42,660
5001.16	Lender responsibilities - origination
(d)(1)	Personal and corporate guarantees		35		35	1	35		$2,100
5001.17	Lender responsibilities - servicing
(c)	Collateral inspection and release		124		124	1	124		$7,440
(d)	Transfers and assumptions		77		77	2	154		$9,240
(f)	Subordination of lien position		242		242	2	484		$29,040
(g)	Repurchases		168		168	1	168		$10,080
(h)	Additional expenditures		57		57	1	57		$3,420
(k)	Protective advances		303		303	1	303		$18,180
(l)	Liquidation		150		150	4	600		$36,000
(m)	Litigation		149		596	1	596		$35,760
5001.31	Guaranteed loan requirements
(b)	Interest rate changes		66		66	1	66		$3,960
5001.34	Issuance of the Guarantee
(d)	Replacement of LNG or Assignment Guarantee Agreement		7		7	4	28		$1,680
5001.35	Alterations to loan instruments		7		7	1	7		$420
5001.36	Reorganizations		57		57	3	171		$10,260
5001.38	Termination of loan note guarantee
(c)	Lender request to Agency to terminate guarantee		7		7	1	7		$420
5001.40	Community Facilities
(a)(1)(iv)	Agency approval of hydroelectric facility		1		1	1	1		$60
(a)(5)(i)	Certificate of local support		135		540	1	540		$32,400
5001.41	Water and Waste Disposal Facilities
(a)(3)	Certificate of local support		15		60	1	60		$3,600
5001.42	Business and Industry
(a)(1)(iii)	Agency approval of agricultural production		2		2	1	2		$120
5001.43	Renewable Energy and Energy Efficiency Improvements (9006)
(e)	Post construction requirements annual report		100		100	5	500		$30,000
	Subtotal		2258		3155		4933		$295,980
REPORTING REQUIREMENTS - FORMS
5001.4	Reports
(b)(1)	Guaranteed Loan Borrower Status - loan status	5001-8	4206	2	8412	1	8412		$504,720
(b)(2)	Guaranteed Loan Borrower Status - default	5001-8	365	6	2190	2	4380		$262,800
5001.9	Lender's Application
(a)	Regulated/supervised lenders - with existing portfolio		445	1	445	2	890	60	$53,400
(a)	Regulated/supervised lenders - without existing portfolio	5001-1	111	1	111	12	1332	60	$79,920
(b)	Non-regulated/supervised lenders -existing portfolio	5001-1	50	1	50	4	200	60	$12,000
(b)	Non-regulated/supervised lenders -without existing portfolio	5001-1	12	1	12	24	288	60	$17,280
5001.12	Application for Loan Guarantee
(a)	Full documentation applications	5001-3	927	1	927	20	18,540		$1,112,400
(b)	Low documentation applications	5001-3	231	1	231	10	2,310		$138,600
--	Certificate of Non-relocation and Market and Capacity Information Report	5001-49	150	1	150	2	300		$18,000
5001.16(d)(1)	Unconditional Guarantee	5001-14	164	1	164	1	82		$4,920
5001.17(g)	Lender's Guaranteed Loan Payment to USDA	5001-19	141	1	141	1	141		$8,460
5001.17(l), (m)	Guaranteed Loan Report of Loss	5001-10	92	1	92	25	2,300		$138,000
5001.32	Conditional Commitment	5001-4	1,024	1	1,024	2	2,048		$122,880
5001.30(b)	Lender's Agreement	5001-2	604	1	604	2	1,208		$72,480
5001.34(b)	Assignment Guarantee Agreement	5001-6	764	1	764	2	1,528		$91,680
	Subtotal		9286		15317		43959		$2,637,540
	Grand Total		11544		18472		48892		$2,933,520

---

Sheet 2: commfacility

		Form	Estimated	Reports	Total Annual	Est'd # of	Est. Total	Wage	Total
Sec.	Title	Number	Number of	Filed	Responses	Man-hours	Man-hours	Class	Cost
		(if any)	Respondents	Annually	(D) x (E)	per response	(F) x (G)		(H) x (I)
(A)	(B)	(C)	(D)	(E)	(F)	(G)	(H)	(I)	(J)
5001.4	Oversight and monitoring
(b)(3)	Notifications		3	1	3	1	3	60	180
5001.6	Project eligibility
(d)(2)	Notice to unserved				0		0		0
5001.11	Guarantee Application Process
(a)(1)	Preapplications		125	1	125	3	375	60	22500
5001.16	Lender responsibilities - origination
(d)(1)	Personal and corporate guarantees				0		0		0
5001.17	Lender responsibilities - servicing
(c)	Collateral inspection and release		3	1	3	1	3	60	180
(d)	Transfers and assumptions		2	1	2	2	4	60	240
(f)	Subordination of lien position		2	1	2	2	4	60	240
(g)	Repurchases		5	1	5	1	5	60	300
(h)	Additional expenditures		2	1	2	1	2	60	120
(k)	Protective advances		2	1	2	1	2	60	120
(l)	Liquidation		5	1	5	4	20	60	1200
(m)	Litigation		5	4	20	1	20	60	1200
5001.31	Guaranteed loan requirements
(b)	Interest rate changes		5	1	5	1	5	60	300
5001.34	Issuance of the Guarantee
(d)	Replacement of LNG or Assignment Guarantee Agreement		1	1	1	4	4	60	240
5001.35	Alterations to loan instruments		1	1	1	1	1	60	60
5001.36	Reorganizations		10	1	10	3	30	60	1800
5001.38	Termination of loan note guarantee
(c)	Lender request to Agency to terminate guarantee		1	1	1	1	1	60	60
5001.40	Community Facilities
(a)(1)(iv)	Agency approval of hydroelectric facility		1	1	1	1	1	60	60
(a)(5)(i)	Certificate of local support		135	4	540	1	540	60	32400
5001.41	Water and Waste Disposal Facilities
(a)(3)	Certificate of local support	na	na	na	na	na	na	na	na
5001.42	Business and Industry
(a)(1)(iii)	Agency approval of agricultural production	na	na	na	na	na	na	na	na
5001.43	Renewable Energy and Energy Efficiency Improvements (9006)
(e)	Post construction requirements annual report	na	na	na	na	na	na	na	na
	Subtotal								$61,200
REPORTING REQUIREMENTS - FORMS
5001.4	Reports
(b)(1)	Guaranteed Loan Borrower Status - loan status	5001-8	500	2	1000	1	1000	60	$60,000
(b)(2)	Guaranteed Loan Borrower Status - default	5001-8	50	6	300	2	600	60	$36,000
5001.9	Lender's Application
(a)	Regulated/supervised lenders - with existing portfolio	5001-1	included in rollup
(a)	Regulated/supervised lenders - without existing portfolio	5001-1	included in rollup
(b)	Non-regulated/supervised lenders	5001-1	included in rollup
5001.12	Application for Loan Guarantee
(a)	Full documentation applications	5001-3	108	1	108	20	2160	60	$129,600
(b)	Low documentation applications	5001-3	27	1	27	10	270	60	$16,200
--	Certificate of Non-relocation and Market and Capacity Information Report	5001-49	na						$0
5001.16(d)(1)	Unconditional Guarantee	5001-14	2	1	2	0.5	1	60	$60
5001.17(g)	Lender's Guaranteed Loan Payment to USDA	5001-19	2	1	2	1	2	60	$120
5001.17(l), (m)	Guaranteed Loan Report of Loss	5001-10	3	1	3	25	75	60	$4,500
5001.32	Conditional Commitment	5001-4	90	1	90	2	180	60	$10,800
5001.30(b)	Lender's Agreement	5001-2	90	1	90	2	180	60	$10,800
5001.34(b)	Assignment Guarantee Agreement	5001-6	9	1	9	2	18	60	$1,080
	subtotal								$269,160

---

Sheet 3: waterwaste

		Form	Estimated	Reports	Total Annual	Est'd # of	Est. Total	Wage	Total
Sec.	Title	Number	Number of	Filed	Responses	Man-hours	Man-hours	Class	Cost
		(if any)	Respondents	Annually	(D) x (E)	per response	(F) x (G)		(H) x (I)
(A)	(B)	(C)	(D)	(E)	(F)	(G)	(H)	(I)	(J)
5001.4	Oversight and monitoring
(b)(3)	Notifications		1	1	1	1	1	60	60
5001.6	Project eligibility
(d)(2)	Notice to unserved		5	1	5	1	5	60	300
5001.11	Guarantee Application Process
(a)(1)	Preapplications		12	1	12	3	36	60	2160
5001.16	Lender responsibilities - origination
(d)(1)	Personal and corporate guarantees				0		0		0
5001.17	Lender responsibilities - servicing
(c)	Collateral inspection and release		1	1	1	1	1	60	60
(d)	Transfers and assumptions		1	1	1	2	2	60	120
(f)	Subordination of lien position				0		0	60	0
(g)	Repurchases		1	1	1	1	1	60	60
(h)	Additional expenditures				0		0	60	0
(k)	Protective advances		1	1	1	1	1	60	60
(l)	Liquidation				0		0	60	0
(m)	Litigation				0		0	60	0
5001.31	Guaranteed loan requirements
(b)	Interest rate changes				0		0	60	0
5001.34	Issuance of the Guarantee
(d)	Replacement of LNG or Assignment Guarantee Agreement				0		0	60	0
5001.35	Alterations to loan instruments				0		0	60	0
5001.36	Reorganizations		2	1	2	3	6	60	360
5001.38	Termination of loan note guarantee
(c)	Lender request to Agency to terminate guarantee				0		0	60	0
5001.40	Community Facilities
(a)(1)(iv)	Agency approval of hydroelectric facility	na	na	na	na	na	na	na	na
(a)(5)(i)	Certificate of local support	na	na	na	na	na	na	na	na
5001.41	Water and Waste Disposal Facilities
(a)(3)	Certificate of local support		15	4	60	1	60	60	3600
5001.42	Business and Industry
(a)(1)(iii)	Agency approval of agricultural production	na	na	na	na	na	na	na	na
		na	na	na	na	na	na	na	na
5001.43	Renewable Energy and Energy Efficiency Improvements (9006)
(e)	Post construction requirements annual report	na	na	na	na	na	na	na	na
	Subtotal								$6,780
REPORTING REQUIREMENTS - FORMS
5001.4	Reports
(b)(1)	Guaranteed Loan Borrower Status - loan status	5001-8	50	2	100	1	100	60	$6,000
(b)(2)	Guaranteed Loan Borrower Status - default	5001-8	5	6	30	2	60	60	$3,600
5001.9	Lender's Application
(a)	Regulated/supervised lenders - with existing portfolio	5001-1	included in rollup
(a)	Regulated/supervised lenders - without existing portfolio	5001-1	included in rollup
(b)	Non-regulated/supervised lenders	5001-1	included in rollup
5001.12	Application for Loan Guarantee
(a)	Full documentation applications	5001-3	12	1	12	20	240	60	$14,400
(b)	Low documentation applications	5001-3	3	1	3	10	30	60	$1,800
--	Certificate of Non-relocation and Market and Capacity Information Report	5001-49	na						$0
5001.16(d)(1)	Unconditional Guarantee	5001-14	1	1	1	0.5	0.5	60	$30
5001.17(g)	Lender's Guaranteed Loan Payment to USDA	5001-19	1	1	1	1	1	60	$60
5001.17(l), (m)	Guaranteed Loan Report of Loss	5001-10	1	1	1	25	25	60	$1,500
5001.32	Conditional Commitment	5001-4	10	1	10	2	20	60	$1,200
5001.30(b)	Lender's Agreement	5001-2	10	1	10	2	20	60	$1,200
5001.34(b)	Assignment Guarantee Agreement	5001-6	1	1	1	2	2	60	$120
	subtotal								$29,910

---

Sheet 4: bandi

		Form	Estimated	Reports	Total Annual	Est'd # of	Est. Total	Wage	Total
Sec.	Title	Number	Number of	Filed	Responses	Man-hours	Man-hours	Class	Cost
		(if any)	Respondents	Annually	(D) x (E)	per response	(F) x (G)		(H) x (I)
(A)	(B)	(C)	(D)	(E)	(F)	(G)	(H)	(I)	(J)
5001.4	Oversight and monitoring
(b)(3)	Notifications		300	1	300	1	300	60	$18,000
5001.6	Project eligibility
(d)(2)	Notice to unserved				0		0		$0
5001.11	Guarantee Application Process
(a)(1)	Preapplications		100	1	100	3	300	60	$18,000
5001.16	Lender responsibilities - origination
(d)(1)	Personal and corporate guarantees		25	1	25	1	25	60	$1,500
5001.17	Lender responsibilities - servicing
(c)	Collateral inspection and release		100	1	100	1	100	60	$6,000
(d)	Transfers and assumptions		70	1	70	2	140	60	$8,400
(f)	Subordination of lien position		200	1	200	2	400	60	$24,000
(g)	Repurchases		150	1	150	1	150	60	$9,000
(h)	Additional expenditures		50	1	50	1	50	60	$3,000
(k)	Protective advances		250	1	250	1	250	60	$15,000
(l)	Liquidation		120	1	120	4	480	60	$28,800
(m)	Litigation		120	4	480	1	480	60	$28,800
5001.31	Guaranteed loan requirements
(b)	Interest rate changes		50	1	50	1	50	60	$3,000
5001.34	Issuance of the Guarantee
(d)	Replacement of LNG or Assignment Guarantee Agreement		4	1	4	4	16	60	$960
5001.35	Alterations to loan instruments		4	1	4	1	4	60	$240
5001.36	Reorganizations		30	1	30	3	90	60	$5,400
5001.38	Termination of loan note guarantee
(c)	Lender request to Agency to terminate guarantee		4	1	4	1	4	60	$240
5001.40	Community Facilities
(a)(1)(iv)	Agency approval of hydroelectric facility	na	na	na	na	na	na	na	na
(a)(5)(i)	Certificate of local support	na	na	na	na	na	na	na	na
5001.41	Water and Waste Disposal Facilities
(a)(3)	Certificate of local support	na	na	na	na	na	na	na	na
5001.42	Business and Industry
(a)(1)(iii)	Agency approval of agricultural production		2	1	2	1	2	60	$120
5001.43	Renewable Energy and Energy Efficiency Improvements (9006)
(e)	Post construction requirements annual report	na	na	na	na	na	na	na	na
	Subtotal								$170,460
REPORTING REQUIREMENTS - FORMS
5001.4	Reports
(b)(1)	Guaranteed Loan Borrower Status - loan status	5001-8	3450	2	6900	1	6900	60	$414,000
(b)(2)	Guaranteed Loan Borrower Status - default	5001-8	300	6	1800	2	3600	60	$216,000
5001.9	Lender's Application
(a)	Regulated/supervised lenders - with existing portfolio	5001-1	included in rollup
(a)	Regulated/supervised lenders - without existing portfolio	5001-1	included in rollup
(b)	Non-regulated/supervised lenders	5001-1	included in rollup
5001.12	Application for Loan Guarantee
(a)	Full documentation applications	5001-3	640	1	640	20	12800	60	$768,000
(b)	Low documentation applications	5001-3	160	1	160	10	1600	60	$96,000
--	Certificate of Non-relocation and Market and Capacity Information Report	5001-49	150	on occasion	150	2	300	60	$18,000
5001.16(d)(1)	Unconditional Guarantee	5001-14	142	1	142	0.5	71	60	$4,260
5001.17(g)	Lender's Guaranteed Loan Payment to USDA	5001-19	130	1	130	1	130	60	$7,800
5001.17(l), (m)	Guaranteed Loan Report of Loss	5001-10	80	1	80	25	2000	60	$120,000
5001.32	Conditional Commitment	5001-4	770	on occasion	770	2	1540	60	$92,400
5001.30(b)	Lender's Agreement	5001-2	350	on occasion	350	2	700	60	$42,000
5001.34(b)	Assignment Guarantee Agreement	5001-6	600	on occasion	600	2	1200	60	$72,000
	subtotal								$1,850,460

---

Sheet 5: reseei

		Form	Estimated	Reports	Total Annual	Est'd # of	Est. Total	Wage	Total
Sec.	Title	Number	Number of	Filed	Responses	Man-hours	Man-hours	Class	Cost
		(if any)	Respondents	Annually	(D) x (E)	per response	(F) x (G)		(H) x (I)
(A)	(B)	(C)	(D)	(E)	(F)	(G)	(H)	(I)	(J)
5001.4	Oversight and monitoring
(b)(3)	Notifications		10	1	10	1	10	60	$600
5001.6	Project eligibility
(d)(2)	Notice to unserved				0		0		$0
5001.11	Guarantee Application Process
(a)(1)	Preapplications				0		0	60	$0
5001.16	Lender responsibilities - origination
(d)(1)	Personal and corporate guarantees		10	1	10	1	10	60	$600
5001.17	Lender responsibilities - servicing
(c)	Collateral inspection and release		20	1	20	1	20	60	$1,200
(d)	Transfers and assumptions		4	1	4	2	8	60	$480
(f)	Subordination of lien position		40	1	40	2	80	60	$4,800
(g)	Repurchases		12	1	12	1	12	60	$720
(h)	Additional expenditures		5	1	5	1	5	60	$300
(k)	Protective advances		50	1	50	1	50	60	$3,000
(l)	Liquidation		25	1	25	4	100	60	$6,000
(m)	Litigation		24	4	96	1	96	60	$5,760
5001.31	Guaranteed loan requirements
(b)	Interest rate changes		11	1	11	1	11	60	$660
5001.34	Issuance of the Guarantee
(d)	Replacement of LNG or Assignment Guarantee Agreement		2	1	2	4	8	60	$480
5001.35	Alterations to loan instruments		2	1	2	1	2	60	$120
5001.36	Reorganizations		15	1	15	3	45	60	$2,700
5001.38	Termination of loan note guarantee
(c)	Lender request to Agency to terminate guarantee		2	1	2	1	2	60	$120
5001.40	Community Facilities
(a)(1)(iv)	Agency approval of hydroelectric facility	na	na	na	na	na	na	na	na
(a)(5)(i)	Certificate of local support	na	na	na	na	na	na	na	na
5001.41	Water and Waste Disposal Facilities	na	na	na	na	na	na	na	na
(a)(3)	Certificate of local support	na	na	na	na	na	na	na	na
5001.42	Business and Industry	na	na	na	na	na	na	na	na
(a)(1)(iii)	Agency approval of agricultural production	na	na	na	na	na	na	na	na
5001.43	Renewable Energy and Energy Efficiency Improvements (9006)
(e)	Post construction requirements annual report		100	1	100	5	500	60	$30,000
	Subtotal								$57,540
REPORTING REQUIREMENTS - FORMS
5001.4	Reports
(b)(1)	Guaranteed Loan Borrower Status - loan status	5001-8	206	2	412	1	412	60	$24,720
(b)(2)	Guaranteed Loan Borrower Status - default	5001-8	10	6	60	2	120	60	$7,200
5001.9	Lender's Application
(a)	Regulated/supervised lenders - with existing portfolio	5001-1	included in rollup
(a)	Regulated/supervised lenders - without existing portfolio	5001-1	included in rollup
(b)	Non-regulated/supervised lenders	5001-1	included in rollup
5001.12	Application for Loan Guarantee
(a)	Full documentation applications	5001-3	167	1	167	20	3340	60	$200,400
(b)	Low documentation applications	5001-3	41	1	41	10	410	60	$24,600
--	Certificate of Non-relocation and Market and Capacity Information Report	5001-49	na						$0
5001.16(d)(1)	Unconditional Guarantee	5001-14	19	1	19	0.5	9.5	60	$570
5001.17(g)	Lender's Guaranteed Loan Payment to USDA	5001-19	8	1	8	1	8	60	$480
5001.17(l), (m)	Guaranteed Loan Report of Loss	5001-10	8	1	8	25	200	60	$12,000
5001.32	Conditional Commitment	5001-4	154	1	154	2	308	60	$18,480
5001.30(b)	Lender's Agreement	5001-2	154	1	154	2	308	60	$18,480
5001.34(b)	Assignment Guarantee Agreement	5001-6	154	1	154	2	308	60	$18,480
	subtotal								$325,410

---

Sheet 6: cost to government

Item	Number	Hours per item	Rate	Cost
Lender Approval Activities
Review/ack lender approval applications - r/s lenders	556	3	40.41	$67,404
Review/ack lender approval applications - non r/s lenders	62	8	40.41	$20,043
Subtotal				$87,447
Application for loan guarantees
Preapplication review and acknowledgment	237	6	40.41	$57,463	6 hours from B&I 4279-B
Review/ack full documentation applications	927	23	40.41	$861,582	B&I 4279-B had 20 hours; B&I 4287-B also had 3 hours for financial statement reviews, which were added here
Review/ack low documentation applications	231	12	40.41	$112,017	assumed 1/2 time of full doc
Review of Certification of Non-relocation …	150	1	40.41	$6,062
Agency approval of hydroelectric facilities	1	2	40.41	$81
Agency approval of agricultural production	2	2	40.41	$162
Subtotal				$1,037,365
(d)(1)
Loan Origination Activities
Approve loans and obligate funds	962	8	40.41	$310,995	8 hours is from B&I 4279-B
Review documents and issue guarantee	962	6	40.41	$233,247	6 hours is from B&I 4279-B
Preparation of Conditional Commitmet for Guarantee	1024	2	40.41	$82,760
Preparation of Lender's Agreement	604	1	40.41	$24,408
Preparation of Assignment Guarantee Agreement	764	1	40.41	$30,873
Subtotal				$682,282
Loan Servicing Activities
Replacement of documents	7	3	40.41	$849	3 hours is from bB&I 4279-A
Subordinations	242	2	40.41	$19,558	2 hours is from B&I 4287-B
Exception authority	15	3	40.41	$1,818	15 and 3 from B&I 4279-A
Litigation and appeals	596	16	40.41	$385,350	16 hours from B&I 4279-A
Liquidation plan	150	3	40.41	$18,185	3 hours is from B&I 4287-B
Release of collateral	124	2	40.41	$10,022	2 hours is from B&I 4287-B
Secondary market activities	900	1	40.41	$36,369	900 and 1 are from B&I 4279-A
Review of report of loss	92	2	40.41	$7,435
Approval of alterations to loan instruments	7	1	40.41	$283
Reorganizations	57	2	40.41	$4,607
Transfers and assumptions	77	20	40.41	$62,231
Repurchases	84	6	40.41	$20,367	Assumed 1/2 of the 168 repurchases are done by Agency; assumed 6 hours
Additional expenditures	57	2	40.41	$4,607
Protective advances	303	2	40.41	$24,488
Review post construction reports (9006 program)	100	1	40.41	$4,041
Subtotal				$600,210
Oversight and Monitoring Activities
Review loan status reports	8412	3	40.41	$1,019,787
Review default reports	2190	1	40.41	$88,498
Lender visits	1800	4	40.41	$290,952	1800 visits from B&I 4287-B; which had 3 hours per visit.
Review notifications (5001.4)	314	1	40.41	$12,689
Subtotal				$1,411,925
Administrative Activities
National office preparation of regs/instructions/forms/etc		640	40.41	$25,862
Associated publication costs				$15,000
Subtotal				$40,862
Grand Total				$3,860,092