ED Form 2000 Monthly Annual Data Template

Guaranty Agency Financial Report

FY2013 - Monthly Annual Data Template.xls

Guaranty Agency Financial Report

OMB: 1845-0026

Document [xlsx]
Download: xlsx | pdf

Overview

MD-20..MD-25..MD-36..MD-39
MD-51..MD-54
Monthly Annual Data


Sheet 1: MD-20..MD-25..MD-36..MD-39

FEDERAL FUND




























































































MD-20 and MD-25 (FY2013)
MD-20 and MD-25 (FY2013)
MD-20 and MD-25 (FY2013)
MD-20 and MD-25 (FY2013)
MD-20 and MD-25 (FY2013)
MD-20 and MD-25 (FY2013)
MD-20 and MD-25 (FY2013)
MD-20 and MD-25 (FY2013)
MD-20 and MD-25 (FY2013)
MD-20 and MD-25 (FY2013)
MD-20 and MD-25 (FY2013)
MD-20 and MD-25 (FY2013)















































October 2012
November 2012
December 2012
January 2013
February 2013
March 2013
April 2013
May 2013
June 2013
July 2013
August 2013
September 2013
Green cells are populated into the Monthly/Annual spreadsheet.
Green cells are populated into the Monthly/Annual spreadsheet.
Green cells are populated into the Monthly/Annual spreadsheet.
Green cells are populated into the Monthly/Annual spreadsheet.
Green cells are populated into the Monthly/Annual spreadsheet.
Green cells are populated into the Monthly/Annual spreadsheet.
Green cells are populated into the Monthly/Annual spreadsheet.
Green cells are populated into the Monthly/Annual spreadsheet.
Green cells are populated into the Monthly/Annual spreadsheet.
Green cells are populated into the Monthly/Annual spreadsheet.
Green cells are populated into the Monthly/Annual spreadsheet.
Green cells are populated into the Monthly/Annual spreadsheet.















































MD-20 (Other Revenues)
MD-20 (Other Revenues)
MD-20 (Other Revenues)
MD-20 (Other Revenues)
MD-20 (Other Revenues)
MD-20 (Other Revenues)
MD-20 (Other Revenues)
MD-20 (Other Revenues)
MD-20 (Other Revenues)
MD-20 (Other Revenues)
MD-20 (Other Revenues)
MD-20 (Other Revenues)















































Detailed breakdown of MD-20 (including accruals, adjustments, etc.)


Detailed breakdown of MD-20 (including accruals, adjustments, etc.)


Detailed breakdown of MD-20 (including accruals, adjustments, etc.)


Detailed breakdown of MD-20 (including accruals, adjustments, etc.)


Detailed breakdown of MD-20 (including accruals, adjustments, etc.)


Detailed breakdown of MD-20 (including accruals, adjustments, etc.)


Detailed breakdown of MD-20 (including accruals, adjustments, etc.)


Detailed breakdown of MD-20 (including accruals, adjustments, etc.)


Detailed breakdown of MD-20 (including accruals, adjustments, etc.)


Detailed breakdown of MD-20 (including accruals, adjustments, etc.)


Detailed breakdown of MD-20 (including accruals, adjustments, etc.)


Detailed breakdown of MD-20 (including accruals, adjustments, etc.)

SES included in MD-20


SES included in MD-20


SES included in MD-20


SES included in MD-20


SES included in MD-20


SES included in MD-20


SES included in MD-20


SES included in MD-20


SES included in MD-20


SES included in MD-20


SES included in MD-20


SES included in MD-20

GA Retention included in MD-20 (if applicable)


GA Retention included in MD-20 (if applicable)


GA Retention included in MD-20 (if applicable)


GA Retention included in MD-20 (if applicable)


GA Retention included in MD-20 (if applicable)


GA Retention included in MD-20 (if applicable)


GA Retention included in MD-20 (if applicable)


GA Retention included in MD-20 (if applicable)


GA Retention included in MD-20 (if applicable)


GA Retention included in MD-20 (if applicable)


GA Retention included in MD-20 (if applicable)


GA Retention included in MD-20 (if applicable)

SES DL Fees included in MD-20


SES DL Fees included in MD-20


SES DL Fees included in MD-20


SES DL Fees included in MD-20


SES DL Fees included in MD-20


SES DL Fees included in MD-20


SES DL Fees included in MD-20


SES DL Fees included in MD-20


SES DL Fees included in MD-20


SES DL Fees included in MD-20


SES DL Fees included in MD-20


SES DL Fees included in MD-20

Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>

Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>

Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>

Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>

Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>

Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>

Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>

Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>

Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>

Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>

Total is Reported MD-20
$0
Total is Reported MD-20
$0
Total is Reported MD-20
$0
Total is Reported MD-20
$0
Total is Reported MD-20
$0
Total is Reported MD-20
$0
Total is Reported MD-20
$0
Total is Reported MD-20
$0
Total is Reported MD-20
$0
Total is Reported MD-20
$0
Total is Reported MD-20
$0
Total is Reported MD-20
$0

















































































































































































MD-25 (Other Expenses)
MD-25 (Other Expenses)
MD-25 (Other Expenses)
MD-25 (Other Expenses)
MD-25 (Other Expenses)
MD-25 (Other Expenses)
MD-25 (Other Expenses)
MD-25 (Other Expenses)
MD-25 (Other Expenses)
MD-25 (Other Expenses)
MD-25 (Other Expenses)
MD-25 (Other Expenses)















































Detailed breakdown of MD-25 (including accruals, adjustments, etc.)


Detailed breakdown of MD-25 (including accruals, adjustments, etc.)


Detailed breakdown of MD-25 (including accruals, adjustments, etc.)


Detailed breakdown of MD-25 (including accruals, adjustments, etc.)


Detailed breakdown of MD-25 (including accruals, adjustments, etc.)


Detailed breakdown of MD-25 (including accruals, adjustments, etc.)


Detailed breakdown of MD-25 (including accruals, adjustments, etc.)


Detailed breakdown of MD-25 (including accruals, adjustments, etc.)


Detailed breakdown of MD-25 (including accruals, adjustments, etc.)


Detailed breakdown of MD-25 (including accruals, adjustments, etc.)


Detailed breakdown of MD-25 (including accruals, adjustments, etc.)


Detailed breakdown of MD-25 (including accruals, adjustments, etc.)

SES included in MD-25


SES included in MD-25


SES included in MD-25


SES included in MD-25


SES included in MD-25


SES included in MD-25


SES included in MD-25


SES included in MD-25


SES included in MD-25


SES included in MD-25


SES included in MD-25


SES included in MD-25

GA Retention included in MD-25 (if applicable)


GA Retention included in MD-25 (if applicable)


GA Retention included in MD-25 (if applicable)


GA Retention included in MD-25 (if applicable)


GA Retention included in MD-25 (if applicable)


GA Retention included in MD-25 (if applicable)


GA Retention included in MD-25 (if applicable)


GA Retention included in MD-25 (if applicable)


GA Retention included in MD-25 (if applicable)


GA Retention included in MD-25 (if applicable)


GA Retention included in MD-25 (if applicable)


GA Retention included in MD-25 (if applicable)

SES DL Fees included in MD-25


SES DL Fees included in MD-25


SES DL Fees included in MD-25


SES DL Fees included in MD-25


SES DL Fees included in MD-25


SES DL Fees included in MD-25


SES DL Fees included in MD-25


SES DL Fees included in MD-25


SES DL Fees included in MD-25


SES DL Fees included in MD-25


SES DL Fees included in MD-25


SES DL Fees included in MD-25

Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>

Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>

Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>

Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>

Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>

Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>

Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>

Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>

Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>

Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>

Total is Reported MD-25
$0
Total is Reported MD-25
$0
Total is Reported MD-25
$0
Total is Reported MD-25
$0
Total is Reported MD-25
$0
Total is Reported MD-25
$0
Total is Reported MD-25
$0
Total is Reported MD-25
$0
Total is Reported MD-25
$0
Total is Reported MD-25
$0
Total is Reported MD-25
$0
Total is Reported MD-25
$0






























































































OPERATING FUND




























































































MD-36 and MD-39 (FY2013)
MD-36 and MD-39 (FY2013)
MD-36 and MD-39 (FY2013)
MD-36 and MD-39 (FY2013)
MD-36 and MD-39 (FY2013)
MD-36 and MD-39 (FY2013)
MD-36 and MD-39 (FY2013)
MD-36 and MD-39 (FY2013)
MD-36 and MD-39 (FY2013)
MD-36 and MD-39 (FY2013)
MD-36 and MD-39 (FY2013)
MD-36 and MD-39 (FY2013)















































October 2012
November 2012
December 2012
January 2013
February 2013
March 2013
April 2013
May 2013
June 2013
July 2013
August 2013
September 2013






























































































Green cells are populated into the Monthly/Annual spreadsheet.
Green cells are populated into the Monthly/Annual spreadsheet.
Green cells are populated into the Monthly/Annual spreadsheet.
Green cells are populated into the Monthly/Annual spreadsheet.
Green cells are populated into the Monthly/Annual spreadsheet.
Green cells are populated into the Monthly/Annual spreadsheet.
Green cells are populated into the Monthly/Annual spreadsheet.
Green cells are populated into the Monthly/Annual spreadsheet.
Green cells are populated into the Monthly/Annual spreadsheet.
Green cells are populated into the Monthly/Annual spreadsheet.
Green cells are populated into the Monthly/Annual spreadsheet.
Green cells are populated into the Monthly/Annual spreadsheet.















































MD-36 (Other Revenues)
MD-36 (Other Revenues)
MD-36 (Other Revenues)
MD-36 (Other Revenues)
MD-36 (Other Revenues)
MD-36 (Other Revenues)
MD-36 (Other Revenues)
MD-36 (Other Revenues)
MD-36 (Other Revenues)
MD-36 (Other Revenues)
MD-20 (Other Revenues)
MD-36 (Other Revenues)















































Detailed breakdown of MD-36 (including accruals, adjustments, etc.)


Detailed breakdown of MD-36 (including accruals, adjustments, etc.)


Detailed breakdown of MD-36 (including accruals, adjustments, etc.)


Detailed breakdown of MD-36 (including accruals, adjustments, etc.)


Detailed breakdown of MD-36 (including accruals, adjustments, etc.)


Detailed breakdown of MD-36 (including accruals, adjustments, etc.)


Detailed breakdown of MD-36 (including accruals, adjustments, etc.)


Detailed breakdown of MD-20 (including accruals, adjustments, etc.)


Detailed breakdown of MD-36 (including accruals, adjustments, etc.)


Detailed breakdown of MD-36 (including accruals, adjustments, etc.)


Detailed breakdown of MD-36 (including accruals, adjustments, etc.)


Detailed breakdown of MD-36 (including accruals, adjustments, etc.)

Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>

Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>

Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>

Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>

Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>

Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>

Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>

Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>

Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>

Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>

Total is Reported MD-36
$0
Total is Reported MD-36
$0
Total is Reported MD-36
$0
Total is Reported MD-36
$0
Total is Reported MD-36
$0
Total is Reported MD-36
$0
Total is Reported MD-36
$0
Total is Reported MD-36
$0
Total is Reported MD-36
$0
Total is Reported MD-36
$0
Total is Reported MD-36
$0
Total is Reported MD-36
$0
















































































































































































MD-39 (Other Expenses)
MD-39 (Other Expenses)
MD-39 (Other Expenses)
MD-39 (Other Expenses)
MD-39 (Other Expenses)
MD-39 (Other Expenses)
MD-39 (Other Expenses)
MD-39 (Other Expenses)
MD-39 (Other Expenses)
MD-39 (Other Expenses)
MD-39 (Other Expenses)
MD-39 (Other Expenses)















































Detailed breakdown of MD-39 (including accruals, adjustments, etc.)


Detailed breakdown of MD-39 (including accruals, adjustments, etc.)


Detailed breakdown of MD-39 (including accruals, adjustments, etc.)


Detailed breakdown of MD-39 (including accruals, adjustments, etc.)


Detailed breakdown of MD-39 (including accruals, adjustments, etc.)


Detailed breakdown of MD-39 (including accruals, adjustments, etc.)


Detailed breakdown of MD-39 (including accruals, adjustments, etc.)


Detailed breakdown of MD-39 (including accruals, adjustments, etc.)


Detailed breakdown of MD-39 (including accruals, adjustments, etc.)


Detailed breakdown of MD-39 (including accruals, adjustments, etc.)


Detailed breakdown of MD-39 (including accruals, adjustments, etc.)


Detailed breakdown of MD-39 (including accruals, adjustments, etc.)

Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>

Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>

Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>

Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>

Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>

Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>

Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>

Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>

Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>

Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>


Other - Specify =>

Total is Reported MD-39
$0
Total is Reported MD-39
$0
Total is Reported MD-39
$0
Total is Reported MD-39
$0
Total is Reported MD-39
$0
Total is Reported MD-39
$0
Total is Reported MD-39
$0
Total is Reported MD-39
$0
Total is Reported MD-39
$0
Total is Reported MD-39
$0
Total is Reported MD-39
$0
Total is Reported MD-39
$0

















































Sheet 2: MD-51..MD-54


MD-51 and MD-54 (FY2013)





MD-51 and MD-54 (FY2013)




MD-51 and MD-54 (FY2013)























October 2012


November 2012

December 2012

January 2013

February 2013

March 2013




















Reported MD-51 $0

Reported MD-51

Reported MD-51

Reported MD-51

Reported MD-51

Reported MD-51

Less Reported MD-54 $0

Less Reported MD-54

Less Reported MD-54

Less Reported MD-54

Less Reported MD-54

Less Reported MD-54

Equals ED Calculated MR-16 $0 The ED calculated MR-16 should equal the total amount of the breakdown box below shaded in green.
Equals ED Calculated MR-16 $0
Equals ED Calculated MR-16 $0
Equals ED Calculated MR-16 $0
Equals ED Calculated MR-16 $0
Equals ED Calculated MR-16 $0


























































Breakdown of MD-51 less MD-54 (including accruals, adjustments, etc.)


Breakdown of MD-51 less MD-54 (including accruals, adjustments, etc.)

Breakdown of MD-51 less MD-54 (including accruals, adjustments, etc.)

Breakdown of MD-51 less MD-54 (including accruals, adjustments, etc.)

Breakdown of MD-51 less MD-54 (including accruals, adjustments, etc.)

Breakdown of MD-51 less MD-54 (including accruals, adjustments, etc.)

MD-51:


MD-51:

MD-51:

MD-51:

MD-51:

MD-51:

MD-51:


MD-51:

MD-51:

MD-51:

MD-51:

MD-51:

MD-51:


MD-51:

MD-51:

MD-51:

MD-51:

MD-51:

MD-54:


MD-54:

MD-54:

MD-54:

MD-54:

MD-54:

MD-54:


MD-54:

MD-54:

MD-54:

MD-54:

MD-54:

MD-54:


MD-54:

MD-54:

MD-54:

MD-54:

MD-54:

Total $0

Total $0
Total $0
Total $0
Total $0
Total $0


























































April 2013


May 2013

June 2013

July 2013

August 2013

September 2013




















Reported MD-51


Reported MD-51

Reported MD-51

Reported MD-51

Reported MD-51

Reported MD-51

Less Reported MD-54


Less Reported MD-54

Less Reported MD-54

Less Reported MD-54

Less Reported MD-54

Less Reported MD-54

Equals ED Calculated MR-16 $0 The ED calculated MR-16 should equal the total amount of the breakdown box below shaded in green.
Equals ED Calculated MR-16 $0
Equals ED Calculated MR-16 $0
Equals ED Calculated MR-16 $0
Equals ED Calculated MR-16 $0
Equals ED Calculated MR-16 $0


























































Breakdown of MD-51 less MD-54 (including accruals, adjustments, etc.)


Breakdown of MD-51 less MD-54 (including accruals, adjustments, etc.)

Breakdown of MD-51 less MD-54 (including accruals, adjustments, etc.)

Breakdown of MD-51 less MD-54 (including accruals, adjustments, etc.)

Breakdown of MD-51 less MD-54 (including accruals, adjustments, etc.)

Breakdown of MD-51 less MD-54 (including accruals, adjustments, etc.)

MD-51:


MD-51:

MD-51:

MD-51:

MD-51:

MD-51:

MD-51:


MD-51:

MD-51:

MD-51:

MD-51:

MD-51:

MD-51:


MD-51:

MD-51:

MD-51:

MD-51:

MD-51:

MD-54:


MD-54:

MD-54:

MD-54:

MD-54:

MD-54:

MD-54:


MD-54:

MD-54:

MD-54:

MD-54:

MD-54:

MD-54:


MD-54:

MD-54:

MD-54:

MD-54:

MD-54:

Total $0

Total $0
Total $0
Total $0
Total $0
Total $0




















Sheet 3: Monthly Annual Data


GUARANTY AGENCY MONTHLY REPORTING OF ANNUAL DATA FORMAT
OMB No. 1845-0026












GA NAME:
Expiration Date: 09-30-2013













Authority: The collection of this information is authorized by the Higher Education Act of 1965, as amended, Part B, Federal Family Education Loan Program (20 U.S.C. 1071 Et Seq.).

Reporting Burden: According to the Paperwork Reduction Act of 1995, no persons are required to respond to a collection of information unless such collection displays a valid, OMB control number. The valid OMB control number for this information collection is 1845-0026. Public reporting burden for this collection of information is estimated to average 55 hours per response, including time for reviewing instructions, searching existing data sources, gathering and maintaining the data needed, and completing and reviewing the collection of information. The obligation to respond to this collection is required to obtain or retain a benefit, as cited in 34CFR682.400. Send comments regarding the burden estimate or any other aspect of this collection of information, including suggestions for reducing this burden, to the U.S. Department of Education, 400 Maryland Ave., SW, Washington, DC 20210-4537 or email [email protected] and reference the OMB Control Number 1845-0026. Note: Please do not return the completed Guaranty Agency Financial Report to this address. If you have any comments or concerns regarding the status of your individual submission of this form, write directly to: Guaranty Agency Reporting, U.S. Department of Education, 830 First Street, NE, 5th Floor, Washington, D.C. 20202 or email [email protected].






















GA CODE:






























































ED Comments: The Green cells will be populated once the corresponding tabs are completed.




























GA Comments:






























Oct 2012 Nov 2012 Dec 2012 Jan 2013 Feb 2013 Mar 2013 Apr 2013 May 2013 Jun 2013 Jul 2013 Aug 2013 Sep 2013


FEDERAL FUND:













MD 15 Beginning Balance












0
MD 16 Investment Income












0
MD 17 Reinsurance Income from ED












0
MD 18 Collections (Reinsurance Complement)












0
MD 19 Insurance Premiums












0
MD 20 Other Revenues $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
0
MD 21 Claims Expensed to Lenders












0
MD 22 Recall of Federal Funds to the Restricted Account












0
MD 23 Transfer to Operating Fund for Default Aversion Fee (DAF)












0
MD 24 Transfer to Operating Fund for Account Maintenance Fee (AMF)












0
MD 25 Other Expenses $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
0
MD 26 Ending Balance $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
0
MD 27 Amount transferred from Federal Fund to Operating Fund













MD 28 Amount Received from Operating Fund to Repay Advance















Oct 2012 Nov 2012 Dec 2012 Jan 2013 Feb 2013 Mar 2013 Apr 2013 May 2013 Jun 2013 Jul 2013 Aug 2013 Sep 2013


OPERATING FUND:













MD 29 Beginning Balance












0
MD 30 Transfer from Federal Fund for Default Aversion Fee (DAF)












0
MD 31 Loan Processing and Issuance Fee (LPIF)












0
MD 32 Account Maintenance Fee












0
MD 33 Transfer from Federal Fund for Account Maintenance Fee (AMF)












0
MD 34 Collections less Reinsurance Complement












0
MD 35 Investment Income












0
MD 36 Other Revenues $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
0
MD 37 Collections Secretary's Equitable Share (SES)












0
MD 38 Operating Expenses












0
MD 39 Other Expenses $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
0
MD 40 Ending Balance $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
0
MD 41 Amount Received from Federal Funds for Operating Expenses













MD 42 Amount Repaid to Federal Fund For Operating Expenses















Oct 2012 Nov 2012 Dec 2012 Jan 2013 Feb 2013 Mar 2013 Apr 2013 May 2013 Jun 2013 Jul 2013 Aug 2013 Sep 2013


BALANCE SHEET SECTION:













MD 48 Cash, Cash Equivalents and Investments













MD 49 Restricted Account Cash, Cash Equivalents and Investments













MD 50 Net Investment in Property, Plant, Equipment and Inventory













MD 51 Accounts Receivable from ED $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0

MD 52 Other Assets













MD 53 Accounts Payable, Accured Expenses and Other Current Liabilities













MD 54 Accounts Payable to ED $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0

MD 55 Other Liabilities













MD 56 Allowance and Other Non-Cash Changes to Federal Fund













MD57 Federal Fund Balance $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0

















MATH CHECK 0 0 0 0 0 0 0 0 0 0 0 0

File Typeapplication/vnd.ms-excel
AuthorNicohle M. Williams
Last Modified ByCourtney.Clemons
File Modified2013-04-02
File Created2011-11-15

© 2024 OMB.report | Privacy Policy