Spreadsheet

20124287_Grid_FY12_Revised 7-30-12.xls

7 CFR 4287-B, "Servicing Business and Industry Guaranteed Loans"

Spreadsheet

OMB: 0570-0016

Document [xlsx]
Download: xlsx | pdf

Overview

Sheet5
Sheet1


Sheet 1: Sheet5

$733,101,712.00
$762,727,182.00
$840,483,936.00
$535,282,996.00
$561,068,829.00
$455,335,671.00
$447.00

Sheet 2: Sheet1


REPORTING REQUIREMENTS - NON FORMS
CHANGES IN BURDEN





Form
Estimated
Reports
Total
Est'd # of
Estimated


Cost to













Section of
Title
Number
Number of
Filed
Annual
Man-hours
Total
Wage
the
Section of


Previous
New


Type of

Regulations


(if any)
Respondents
Annually
Responses
per response
Man-hours
Class
Public
Regulations
Title
Burden
Burden
Difference
Change

(A)
(B)
(C)
(D)
(E)
(F)
(G)
(H)
(I)
(J)













4287.107(b)
Loan classification
written
1,100
1
1,100
0.5
550
62
$34,100
4287.107(b)
Loan classification
500.0
550.0
50.00
Adjustment


































4287.107(c)
Agency and lender
written
380
1
380
1.5
570
62
$35,340
4287.107(c)
Agency and lender
525.0
570.0
45.0





conference


















conference









4287.107(d)
Financial Reports
written
1,100
4
4,400
0.5
2,200
62
$136,400
4287.107(d)
Financial Reports
2,000.0
2,200.0
200.0





and analysis - quarterly





























4287.107(d)
Financial Reports
written
3,750
1
3,750
2.0
7,500
62
$465,000
4287.107(d)
Financial Reports
6,900.0
7,500.0
600.0




and analysis - annually





























4287.107(f)
Borrower visits
visit
1,630
1
1,630
2.0
3,260
62
$202,120
4287.107(f)
Borrower visits
3,000.0
3,260.0
260.0



4287.112
Interest rate adjustment
written
55
1
55
0.5
28
62
$1,705
4287.112
Interest rate adjustment
25.0
27.5
2.5



4287.113
Release of collateral
written
110
1
110
2.0
220
62
$13,640
4287.113
Release of collateral
200.0
220.0
20.0



4287.123
Subordination of lien
written
220
1
220
2.0
440
62
$27,280
4287.123
Subordination of lien
400.0
440.0
40.0





position





























4287.124
Alterations of Loan
written
110
1
110
1.5
165
62
$10,230
4287.124
Alterations of Loan
150.0
165.0
15.0





Instruments


















Instruments









4287.134(a)(g)
Transfer and
written
22
1
22
3.5
77
62
$4,774
4287.134(a)(g)
Transfer and
70.0
77.0
7.0





assumption





























4287.134(a)
Credit reports
written
44
1
44
0.5
22
62
$1,364
4287.134(a)
Credit reports
20.0
22.0
2.0



4287.134(c)
Appraisal reports
written
44
1
44
1.0
44
62
$2,728
4287.134(c)
Appraisal reports
40.0
44.0
4.0




































4287.135
Substitution of lender
written
22
1
22
1.0
22
62
$1,364
4287.135
Substitution of lender
20.0
22.0
2.00




































4287.145(a)
Default by Borrower
visit
130
1
130
1.0
130
62
$8,060
4287.145(a)
Default by Borrower
120.0
130.0
10.00




































4287.145(b)
Curative Actions
written
210
1
210
1.5
315
62
$19,530
4287.145(b)
Curative Actions
300.0
315.0
15.00




































4287.156
Protective advances
written
272
1
272
1.0
272
62
$16,864
4287.156
Protective advances
250.0
272.0
22.0




































4287.157(c)
Liquidation plan
written
130
1
130
6.0
780
62
$48,360
4287.157(c)
Liquidation plan
720.0
780.0
60.0







document



























4287.157(f) Acceleration
written
130
1
130
0.5
65
62
$4,030
4287.157(f)
Acceleration
60.0
65.0
5.0




































4287.157(h)
Accounting and reports
written report
130
4
520
0.5
260
62
$16,120
4287.157(h)
Accounting and reports
240.0
260.0
20.0




































4287.180
Termination of
written
544
1
544
0.5
272
62
$16,864
4287.180
Termination of
250
272
22.0





guarantee


















guarantee









REPORTING REQUIREMENTS - FORMS
CHANGES IN BURDEN (CONT.)





Form
Estimated
Reports
Total
Est'd # of
Estimated


Cost to













Section of
Title
Number
Number of
Filed
Annual
Man-hours
Total
Wage
the
Section of


Previous
New


Type of

Regulations


(if any)
Respondents
Annually
Responses
per response
Man-hours
Class
Public
Regulations
Title
Burden
Burden
Difference
Change

(A)
(B)
(C)
(D)
(E)
(F)
(G)
(H)
(I)
(I)













4287.107(a)
Guaranteed Loan Status
Form 1980-41
3,800
2
7,600
0.33
2,508
62
$155,496
4287.107(a)
Guaranteed Loan Status
2,310.0
2,508
198





Report
















Form 1980-41
Report









4287.145(a)
Guaranteed Loan
Form 1980-44
380
6
2,280
0.33
752
62
$46,649
4287.145(a)
Guaranteed Loan
693.0
752
59





Delinquent Status Borrower
















Form 1980-44
Borrower Default Status









TOTAL DOCKET








23,703


20,452


1,268,018
Total Docket


18,793
20,452
1,659
Adjustment





































































































































REPORTING REQUIREMENTS - FORMS APPROVED UNDER OTHER OMB NUMBERS













4287.157(i)
Lender's Guaranteed Loan Payment to USDA
Form 1980-43
110
12
1,320
0.50
660




















(0575-0137)



























4287.158(c)
Loan Note Guarantee
Form 449-30
110
1
110
25.0
2,750



















Report of Loss
(0575-0137)





















































Total previous burden
18,793
$1,127,580



























Total new burden
20,452
$1,227,114



























Total difference
1,659
99,534





































































Cost to the Federal Government



























# of



























Activity
Number
Hours
Rate
TOTAL























Financial Statement
4,250
3.0
$41.41
$527,978























Review































Liquidation Plan
110
3.0
$41.41
$13,665
























































Borrower / lender visits
2,130
3.0
$41.41
$264,610
























































Release of Collateral
110
2.0
$41.41
$9,110
























































Subordination of
77
2.0
$41.41
$6,377























Collateral































ANNUALIZED






$821,740























TOTAL
































































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.




























File Typeapplication/vnd.ms-excel
AuthorRDA
Last Modified Byjeanne.jacobs
File Modified2012-09-06
File Created1999-07-01

© 2024 OMB.report | Privacy Policy