CE APR Spreadsheet

---

Overview

Newly, Previously and Leases
Reconciliation
Budget

---

Sheet 1: Newly, Previously and Leases

Grantee:
Award Amount:
Year Awarded:
Summary Table:	Annual Report Year
	2003	2004	2005	2006	2007	2008	2009	2010	2011	2012	2013	2014	2015	2016	2017	2018	2019	Total Since Inception
Loan Amount Leveraged																		$0
Amount of Loans Directly Credit Enhanced																		$0
Number of Schools Served																		0
Number of New Schools Served																		0
A. Year School Served	B. School Name	C. Type of Transaction	D. City	E. State	F. NCES Identification Number	G. Phone	H. Are there any ongoing construction/facilities projects at this school?	I. How were grant funds used to secure or credit-enhance financing?	J. Briefly Describe Source and Type of Financing	K. Name of Bank or Banks Providing the Financing	L. Closing Date on Financing	M. Amortization Structure(s)	N. Amortization Schedule(s)	O. Maturity date(s)	P. Conversion Feature(s)	Q. Amount of Fees Paid by Charter School to Grantee	R. Basis for Calculating the Interest Rate(s)	S. Amount of Grant Funds Committed to the Project	T. Amount of Financing Leveraged	U. Size of the Loan Benefiting from the Credit Enhancement	V. Interest Rate on Loan Benefiting from the Credit Enhancement (Specify the Interest Rate on Other Components, if applicable)	W. What is the estimated debt-to-collateral ratio for this project?	X. How was the financing used?	Y. Was financing for an addition, an existing building, or a new building?	Z. Did the financing increase the amount of physical space available to educate students?	AA. If you answered "yes" to question Z, how many additional students can be accommodated?	AB. Financed Amount Outstanding for this School	AC. Amount of Grant Funds Committed to Project at End of Reporting Period (indicate "$0.00 if the credit enhancement has expired)	AD. How was the school served?	AE. If the answer to AD is "school served by guaranteeing or insuring the lease", what is the dollar amount of grant funds committed?	AF. If the answer to AD is "school served by guaranteeing or insuring the lease", what is the annual dollar amount of the lease?	AG. If the answer to AD is "school served by guaranteeing or insuring the lease", for how many years is the guarantee or insurance in place?	AH. Total leveraged (Sum of yearly lease amounts)	AI. In your opinion, what was the impact of the credit enhancement on the terms and the conditions of the loan?	AJ. In your opinion, what was the impact of the credit enhancement funds on the overall project of the school served?	AK. What happened to the school after the credit enhancement expired?	AL. Percent of Students Proficient and Advanced in Math (School Level)	AM. Percent of Students Proficient and Advanced in Math (State Level)	AN. Percent of Students Proficient and Advanced in Reading (School Level)	AO. Percent of Students Proficient and Advanced in Reading (State Level)
																																	0
																																	0
																																	0
																																	0
																																	0
																																	0
																																	0
																																	0
																																	0
																																	0
																																	0
																																	0
																																	0
																																	0
																																	0
																																	0
																																	0
																																	0
																																	0
																																	0
																																	0
																																	0
																																	0
																																	0
																																	0
																																	0
																																	0
																																	0
																																	0
																																	0
																																	0
																																	0
																																	0
																																	0
																																	0
																																	0
																																	0
																																	0
																																	0
																																	0
																																	0

---

Sheet 2: Reconciliation

Predicted reserve account balance
Year		200_	200_	200_
beginning balance			0	0
plus earnings		0
less expenses		0
ending balance		0	0	0
Reserve account investments balance in total as of 9/30/200_
Investment(s)	Value(s)
Total (actual balance)	0.00
Difference between predicted balance and actual balance:
0.00	balance

---

Sheet 3: Budget

				Budget Form: Grant Funds Expenditures
Budget categories	Project year 1 1	Project year 2	Project year 3	Project year 4	Project year 5	Project year 6	Project year 7	Project year 8	Remaining years	Total
Actual amount spent (Y or N)	Y
A. Administrative funds (0.25%)										0
A.1. Indirect costs										0
A.2. Administrative costs other than indirect costs										0
A. Total administrative costs	0	0	0	0	0	0	0	0	0	0
B. Reserve account earnings										0
C. Reserve account (99.75%)
C.1. Grant funds spent on guaranteeing and insuring debt and leases 2
C.1.a. Personnel and fringe benefits										0
C.1.b. Payments to third parties to guarantee or insure debt										0
C.1.c. Other payments associated with guaranteeing and insuring debt and leases										0
C.1. Total Guaranteeing and insuring debt and leases payments	0	0	0	0	0	0	0	0	0	0
C.2. Grant funds spent on facilitating financing (including facilitating lending and the issuance of bonds) 3
C.2.a. Personnel and fringe benefits										0
C.2.b. Contractual										0
C.2.c. Other payments associated with facilitating financing										0
C.2. Total grant funds spent on facilitating financing (including facilitating lending and the issuance of bonds)	0	0	0	0	0	0	0	0	0	0
C.3. Total reserve account costs (lines A; C.1.; and C.2.)	0	0	0	0	0	0	0	0	0	0
The purpose of this table is to determine the amount of Federal grant funds that the applicant intends to spend on activities to cover costs associated with the Credit Enhancement for Charter School Facilities Grant. The table should include funds from the reserve account only in the year they are spent. The table should not include funds that remain in the reserve account and are used to directly guarantee or insure debt or leases.
1 Project years should coincide with Federal Fiscal Years (October 1 until September 30). In the event a grant is awarded just prior to the beginning of a fiscal year, the grantee may include the preceding few months as part of the following fiscal year.
2 Includes activities in Section 5225(a)(1) and (2).
3 Includes activities in Section 5225(a)(3) and (4).