FINANCIAL REPORTING FORM OF QUARTERLY OFFICER'S REPORT

A~IERICAN ACADE~IY EDUCATE I INNOVATE I EXPLORE EXHIBIT D: CECFA American Academy Project Series 2015 December, 2016 Report FINANCIAL REPORTING FO...
1 downloads 1 Views 301KB Size
A~IERICAN ACADE~IY EDUCATE

I INNOVATE I EXPLORE

EXHIBIT D: CECFA American Academy Project Series 2015

December, 2016 Report

FINANCIAL REPORTING FORM OF QUARTERLY OFFICER'S REPORT Issuer: Colorado Educational and Cultural Facilities Authority

Bond Issue: $38,725,000 Charter School Refunding Revenue Bonds (American Academy Project), Series 2015 and $27,690,000 Charter School Revenue Bonds, Series 2016 Trustee: UMB Bank, n.a.

Borrower/Lessor: AA Building Corporation II, a Colorado nonprofit corporation Lessee: American Academy THIS QUARTERLY OFFICER'S REPORT is delivered by the Charter School to the Trustee, the Authority and the Corporation each identified above, in connection with the Lease, the Base Rent from which is used for payment of the bonds issued pursuant to Indenture of Trust dated as of October 1, 2015 (the "Indenture") between the Authority and the Trustee. Defined terms used in this report and not defined herein shall have the meanings established in the Lease (as defined in the Indenture). This Quarterly Officer's Report is intended to be filed with the MSRB's Electronic Municipal Market Access (EMMA) website by the Trustee, however, the contents of each report and the timing with respect to each filing is not intended to comprise part of the Continuing Disclosure Agreement or undertaking made for the benefit of Bondholders under Securities and Exchange Commission Rule 15c2-12. Additionally, the contents of this Quarterly Officer's Report may be modified by the Charter School, in its sole discretion. The attached report is for the Fiscal Year Quarter which ended on 12/31/2016. Attachments to this Quarterly Officer's Report For purpose of financial reporting for the respective quarters of each Fiscal Year, there is attached to this Quarter Officer's Report the following (for the respective quarters as indicated): First Three Quarters' 45-Day Reporting. On or before forty-five days after the end of each quarter for the first three quarters of each Fiscal Year, commencing with the quarter which ends on December 31, 2015, as provided below: (a) Financial Data of the Charter School. Unaudited financial statements of the Charter School for each fiscal quarter reflecting revenues and expenses as submitted to the Charter School's governing board, which shall include a year-to-date income statement. a balance sheet, a statement of cash flows and a comparison of such calendar quarter to the budget of the Charter School. (b) Enrollment. In each fiscal quarter report, the actual enrollment for the Charter School and the actual funded student count as last reported to the Department of Education of the State. Final Quarter 45-Day Reporting. On or before forty-five days after the end of the final quarter for each Fiscal Year, commencing with the final quarter which ends on June 30, 2016, as provided below: (a) Financial Data of the Charter School. Unaudited financial statements of the Charter School for the final quarter reflecting revenues and expenses as submitted to its governing board, which shall include a year-to-date income statement. a balance sheet, a statement of cash flows and a comparison of such calendar quarter to the budget of the school. (b) Budget. A copy of the Charter School's annual budget, as amended or supplemented as of the reporting date, for the then current Fiscal Year.

CECFA American Academy Project Series 2015

Created January 20, 2016

January 24, 2017

Page 2

Certification

The undersigned, as the Executive Director or the Chief Financial Officer of the Charter School, hereby certifies that she or he are authorized to provide the information contained in this Quarterly Officer's Report and have reviewed the applicable financing document covenants, as well as unaudited financial information for the Charter School, for the purpose of making the representations made herein. Date of Report Execution: January 24, 2017

:'"~c/aP-u

Name: Jen Tucker Title: Director, Operations

(a)

Financial Data of the Charter School (attached)

• • •

1: American Academy Balance Sheet

3: American Academy Budget vs . Actual (collapsed)



4: American Academy Statement of Cash Flows



5: AA Building Corporation II Balance Sheet



6: AA Building Corporation II Income Statement

(b)

Enrollment Reporting

• •

Actual Enrollment as of 12/31 /16: 1,757 students

2: American Academy Income Statement (collapsed)

Actual funded student count as last reported to the Department of Education of the State: 1,680.28

CECFA American Academy Project Series 2015

Created January 20, 2016

American Academy

01/23/17

Balance Sheet As of December 31, 2016

Dec 31, 16

Dec 31, 15

$ Change

% Change

ASSETS Current Assets Checking/Savings 8100 · Cash and Investments Citywide Accounts

0

3,965,810

-3,965,810

-100%

3,621,889

0

3,621,889

100%

Petty Cash Accounts

1,900

1,400

500

36%

8111 · ColoTrust Savings

2,232

2,217

14

1%

3,626,020

3,969,427

-343,407

-9%

3,626,020

3,969,427

-343,407

-9%

8132 · Interfund accounts receivable

165,647

0

165,647

100%

8153a · Misc. Receivables

121,882

94,790

27,092

29%

8181 · Prepaid Expenses

6,515

19,851

-13,335

-67%

8182 · Prepaid Insurance

0

732

-732

-100%

294,045

115,372

178,672

155%

3,920,065

4,084,800

-164,735

-4%

398,287 4,318,352

33,903 4,118,703

364,383 199,649

1,075% 5%

215,968

165,573

50,395

30%

1,057

4,188

-3,131

-75%

808

323

486

151%

1,100

1,100

0

0%

Community Banks of Colorado

Total 8100 · Cash and Investments Total Checking/Savings Other Current Assets

Total Other Current Assets Total Current Assets Other Assets TOTAL ASSETS LIABILITIES & EQUITY Liabilities Current Liabilities Accounts Payable Credit Cards Other Current Liabilities 7421A · Misc. Liabilities DCSD Fees Facility Rental Deposits Total 7421A · Misc. Liabilities

1,908

1,423

486

34%

260,744

248,029

12,714

5%

5,869

-62,804

68,673

109%

10,600

1,760

8,840

502%

279,121

188,408

90,713

48%

496,146

358,169

137,976

39%

496,146

358,169

137,976

39%

1,375,496

1,220,574

154,922

13%

6761 · Tabor 3% Emergency Reserve

500,000

479,000

21,000

4%

6770 · Unassigned Fund Balance

543,967

564,967

-21,000

-4%

Net Income

1,402,743

1,495,993

-93,250

-6%

Total Equity TOTAL LIABILITIES & EQUITY

3,822,206 4,318,352

3,760,534 4,118,703

61,673 199,649

2% 5%

7461 · Accrued Salaries & Benefits 7471 · Payroll Deductions and Withhold 7481 · Deferred Revenues Total Other Current Liabilities Total Current Liabilities Total Liabilities Equity 32000 · Unrestricted Net Assets

Page 1 of 1

01/23/17

American Academy Income Statement July through December 2016 Jul - Dec 16

Jul - Dec 15

$ Change

% Change

Income 1000 · Revenue from Local Sources

2,569,246

2,724,460

-155,214

-6%

3000 · Revenue from State Sources

267,591

246,859

20,732

8%

6,320,710

5,945,735

374,975

6%

9,157,547

8,917,054

240,493

3%

0100 · Salaries

3,586,034

3,286,347

299,687

9%

0200 · Benefits

1,075,843

954,749

121,093

13%

205,374

191,119

14,256

7%

1,417,150

1,541,232

-124,081

-8%

0500 · Other Purchased Services

723,686

789,680

-65,994

-8%

0600 · Supplies

305,321

428,034

-122,713

-29%

0700 · Property

351,658

142,171

209,487

147%

0800 · Other Objects

23,518

17,170

6,348

37%

0900 · Other Uses of Funds

66,219

70,559

-4,340

-6%

7,754,804 1,402,743

7,421,061 1,495,993

333,743 -93,250

4% -6%

5000 · Other Sources Total Income Expense

0300 · Purchased Prof & Technical Svs. 0400 · Purchased Property Services

Total Expense Net Income

Page 1 of 1

American Academy Schedule of Income and Expenditures - Budget to Actual - 2nd Quarter For the Period Ended December 31, 2016 Prior Year FY 2015-2016 Budget

Actual

Current Year FY 2016-2017

% to Budget

Budget

Actual

Projected Year End FY 2016-2017

% to Budget

Budget

Actual

% to Budget

Revenue: 5700

Per Pupil Rev enue

$ 11,783,080

$ 11,874,135

100.77%

$ 11,890,652

$ 6,031,932

50.73%

$ 11,890,652

$ 11,894,193

100.03%

1110

Mill Lev y /Ov erride

908,562

929,899

102.35%

903,413

464,319

51.40%

903,413

916,610

101.46%

1300

Tuition

1,477,842

1,499,847

101.49%

1,509,171

813,727

53.92%

1,509,171

1,509,171

100.00%

1400

Trans portation Fees

429,400

380,111

88.52%

400,925

269,361

67.18%

400,925

400,925

100.00%

1500

Earnings on Inv es tments

8,400

11,884

141.48%

6,000

3,721

62.02%

6,000

6,000

100.00%

1600

Food Serv ic es

-

-

-

-

-

-

1700

Pupil Ac tiv ities

1800

Community Serv ic e Ac tiv ities

1900

Other Loc al Rev enue

1910

Rental/Leas e

1920

Contributions /Donations

1935 Non-Capital As s et Sales 1985 Ins uranc e Claims

444,431 541,239

516,676 -

0.00% 116.26% 0.00%

525,501

97.09%

75,000

87,490

116.65%

406,109

277,642

68.37%

-

-

86,710

86,710

525,000 531,597

306,715 -

0.00% 58.42% 0.00%

523,544

98.49%

65,000

59,413

91.40%

285,250

127,246

44.61%

525,000 531,597

535,162 -

0.00% 101.94% 0.00%

531,628

100.01%

65,000

65,095

100.15%

285,250

349,170

122.41%

0.00%

-

1,200

0.00%

-

1,200

0.00%

100.00%

-

-

0.00%

-

-

0.00%

1990

Mis c ellaneous Rev enue

1,000

636

63.63%

10,000

0.00%

10,000

10,000

100.00%

3000

Categoric al Rev enue

423,135

437,652

103.43%

463,271

233,536

50.41%

463,271

463,271

100.00%

3954

Other State Rev enue

30,800

62,565

203.13%

86,101

34,054

39.55%

86,101

110,381

128.20%

4000

Grants Federal

-

-

0.00%

-

-

0.00%

-

-

5200

Fund Trans fer

(9,750)

(9,434)

96.76%

-

-

0.00%

-

-

5900

Other Sourc es

-

-

0.00%

Cap Res erv e Bond Rev enue

-

-

0.00%

-

-

0.00%

-

-

Grants Loc al

-

-

0.00%

-

-

0.00%

-

-

Total Revenue

288,778

-

288,778

100.00%

288,778

288,778

0.00% 0.00% 100.00% 0.00% 0.00%

$ 16,605,959

$ 16,681,316

100.45%

$ 16,965,158

$ 9,157,547

53.98%

$ 16,965,158

$ 17,081,583

100.69%

Expenditures: 0100

Salaries

$ 7,812,586

$ 7,761,012

99.34%

$ 8,137,729

$ 3,586,034

44.07%

$ 8,137,729

$ 8,137,729

100.00%

0200

Benefits

2,277,374

2,230,552

97.94%

2,513,415

1,075,843

42.80%

2,513,415

2,513,415

100.00%

0300

Purc has ed Profes s ional and Tec hnic al Serv ic es

364,654

365,262

100.17%

355,637

205,374

57.75%

355,637

354,140

99.58%

0400

Purc has ed Property Serv ic es

3,040,764

3,062,079

100.70%

2,964,160

1,417,150

47.81%

2,964,160

2,964,160

100.00%

0500

Other Purc has ed Serv ic es

1,382,858

1,316,782

95.22%

1,358,498

723,686

53.27%

1,358,498

1,358,548

100.00%

0600

Supplies

989,870

892,547

90.17%

879,683

305,321

34.71%

879,683

879,682

100.00%

0700

Property

806,945

729,963

90.46%

567,751

351,658

61.94%

567,751

567,751

100.00%

0800

Other Ex pens es

34,990

20,434

58.40%

38,200

23,518

61.57%

38,200

38,200

100.00%

0900

Other Us es of Funds

-

-

0.00%

-

-

0.00%

-

-

0910

Redemption of Princ ipal

-

-

0.00%

-

-

0.00%

-

-

0913

Princ ipal on Leas es

66,219

44.15%

149,761

147,761

98.66%

150,000

150,000

150,000

Grant Ex pens e

-

-

0.00%

-

-

0.00%

-

-

Cap Res erv e Ex pens e

-

-

0.00%

-

-

0.00%

-

-

Total Expenditures

$ 16,859,804

$ 16,526,394

98.02%

$ 16,965,072

$ 7,754,804

45.71%

$ 16,965,072

$ 16,963,625

0.00% 0.00% 100.00% 0.00% 0.00% 99.99%

01/23/2017

American Academy Cash Flow Forecast 2016/17

Actual

Actual

Actual

Actual

Actual

Actual

Forecast

Forecast

Forecast

Forecast

Forecast

Forecast

Jul 16

Aug 16

Sep 16

Oct 16

Nov 16

Dec 16

Jan 17

Feb 17

Mar 17

Apr 17

May 17

Jun 17

Income 1000 · Revenue from Local Sources 1310 · Full Day Kindergarten Tuition

67,732

45,408

60,960

59,088

54,864

55,728

54,303

54,303

54,303

54,303

54,303

0

1312 · KindiePrep

25,040

105,262

86,644

85,606

82,311

85,084

85,073

85,073

85,073

85,073

85,073

0

125,545

3,239

22,684

54,141

50,094

13,659

24,204

24,204

24,204

24,204

24,204

0

736

664

626

609

475

612

413

413

413

413

413

413

22,351

68,146

73,388

32,381

69,396

41,002

44,917

44,917

44,917

44,917

44,917

0

1,710

0

52,825

338

4,540

0

812

812

812

812

812

812 84,232

1411 · Field Trip Activities 1510 · Interest on Investments 1700 · Extracurricular Activities 1910 · Rentals/Leases 1920 · Contributions and Donations

0

0

96,435

0

40

30,772

84,232

0

0

84,232

0

1935 · Non-Capital Asset Sales

0

0

0

0

1,200

0

0

0

0

0

0

0

104,013

407,953

7,481

2,658

1,591

-102

1,133

1,133

1,133

1,133

1,133

1,133 75,395

1940 · Instructional Materials Fees 1954 · Mil Levy Override

77,769

77,769

77,769

77,769

77,769

75,474

75,395

75,395

75,395

75,395

75,395

1990 · Misc. Revenue

0

0

0

0

0

0

1,429

1,429

1,429

1,429

1,429

1,429

3113 · Charter School Capital Construc

0

38,923

77,845

38,923

38,923

38,923

38,380

38,380

38,380

38,380

38,380

38,380

3934 · Other State Revenue 5710 · Per Pupil Revenue Allocation Letter of Credit (CD)

0

0

0

26,034

4,010

4,010

4,010

4,010

4,010

4,010

4,010

4,010

1,008,981

1,008,981

1,008,981

1,008,981

1,008,981

987,029

985,936

985,936

985,936

985,936

985,936

985,936 0

0

0

0

0

-398,287

33,903

0

0

0

0

0

Deferred Revenue

-235,920

0

0

0

0

10,600

0

0

0

0

0

0

Receivables

-251,672

-11,701

-98,808

528,284

-160,853

-24,077

258,082

0

0

0

0

0

946,285

1,744,643

1,466,829

1,914,811

835,055

1,352,616

1,658,317

1,316,004

1,316,004

1,400,236

1,316,004

1,191,739

946,285

1,744,643

1,466,829

1,914,811

835,055

1,352,616

1,658,317

1,316,004

1,316,004

1,400,236

1,316,004

1,191,739

745,947

785,232

858,656

871,469

862,606

740,951

900,000

900,000

900,000

900,000

900,000

900,000

36,187

38,866

33,112

32,909

40,611

23,691

24,637

24,637

24,637

24,637

24,637

24,637

0400 · Purchased Property Services

238,115

235,940

234,239

239,118

240,415

229,323

253,762

253,762

253,762

253,762

253,762

253,762

0500 · Other Purchased Services

Total Income Gross Profit Expense 0100 · Salaries & 0200 · Benefits 0300 · Purchased Prof & Technical Svs.

238,719

104,265

117,190

87,965

105,057

70,427

100,765

100,765

100,765

100,765

100,765

100,765

0600 · Supplies

25,124

58,277

42,741

41,882

73,703

63,659

91,137

91,137

91,137

91,137

91,137

91,137

0700 · Property

14,194

19,384

4,164

6,781

8,279

10,078

32,310

32,310

32,310

32,310

32,310

32,310

0800 · Other Objects

1,187

12,612

648

8,334

57

680

2,194

2,194

2,194

2,194

2,194

2,194

0900 · Other Uses of Funds

4,497

16,804

20,225

10,964

10,943

2,787

12,367

12,367

12,367

12,367

12,367

12,367

Accounts Payable

-283,031

306,569

7,369

3,770

-85,307

12,629

0

0

0

0

0

0

PrePaid Expenses for Future Years

-117,552

0

0

0

0

0

0

0

0

0

0

0

903,387 42,898

1,577,949 166,694

1,318,344 148,485

1,303,191 611,620

1,256,364

1,154,224

1,417,171

1,417,171

1,417,171

1,417,171

1,417,171

1,417,171

-421,308

198,392

241,146

-101,167

-101,167

-16,936

-101,167

-225,432

3,088,831

3,237,317

3,848,937

3,427,628

3,626,020

3,867,167

3,765,999

3,664,832

3,647,896

3,546,729

3,321,297

Total Expense Net Income Cash Balance carried forward

2,879,239

Net Running Cash

2,922,137

NOTES: 2016/17 Forecast based on Projected Year End as of 12/31 reporting divided over remaining months of activity.

Page 1 of 1

AA Building Corporation II Balance Sheet

01/02/17

As of December 31, 2016 Dec 31, 16 ASSETS Current Assets Checking/Savings 8105 · UMB Trustee Accounts

Dec 31, 15

$ Change

% Change

24,265,727

1,365,895

22,899,833

1,677%

24,265,727

1,365,895

22,899,833

1,677%

4,000 144,000

0 148,000

4,000 -4,000

100% -3%

2,452,925

0

2,452,925

100%

2,600,925

148,000

2,452,925

1,657%

26,866,653

1,513,895

25,352,758

1,675%

3,647,598

1,833,333

1,814,265

99%

28,307,286

28,899,027

-591,741

-2%

541,737

471,351

70,386

15%

32,496,622

31,203,712

1,292,910

4%

248,130

0

248,130

100%

3,994,482

4,438,314

-443,831

-10%

4,242,612

4,438,314

-195,701

-4%

63,605,887

37,155,920

26,449,967

71%

LIABILITIES & EQUITY Liabilities Current Liabilities Other Current Liabilities 7455 · Accrued Interest Payable

0

147,428

-147,428

-100%

Total Other Current Liabilities

0

147,428

-147,428

-100%

0

147,428

-147,428

-100%

Long Term Liabilities 7442 · Bonds Payable

65,625,000

38,725,000

26,900,000

70%

Total Long Term Liabilities

65,625,000

38,725,000

26,900,000

70%

Total Liabilities

65,625,000

38,872,428

26,752,572

69%

Equity Contributed Capital 6760 · Fund Balance 6770 · Unrestricted Net Assets Net Income

650,575 11,191 -2,724,601 43,722

0 11,191 -2,987,304 1,259,605

650,575 0 262,703 -1,215,883

100% 0% 9% -97%

Total Equity

-2,019,113

-1,716,508

-302,605

-18%

63,605,887

37,155,920

26,449,967

71%

Total Checking/Savings Other Current Assets 8153 · Accounts Receivable 8181 · PrePaid Expenses 8231A · Construction in Progress Total Other Current Assets Total Current Assets Fixed Assets 8211 · Land 8231 · Buildings and Improvements 8241 · Equipment Total Fixed Assets Other Assets 8193B · Underwriting Discount 8800 · Deferred Outflows of Resources Total Other Assets TOTAL ASSETS

Total Current Liabilities

TOTAL LIABILITIES & EQUITY

Page 1

AA Building Corporation II 01/02/17

Income Statement July through December 2016

Jul - Dec 16

Jul - Dec 15

$ Change

% Change

Income 1510 · Investments 52XX · Transfer In

74,596 1,148,380

1,302 2,123,803

73,294 -975,423

5,630% -46%

Total Income

1,222,976

2,125,105

-902,129

-43%

Expense 0300 · Purchased Services 0313 · Cash Management Fee 0390 · Professional Fees Total 0300 · Purchased Services 0800 · Other Objects 0830 · Interest Expense Total 0800 · Other Objects Total Expense Net Income

11,429 207,891 219,320

959,935

7,101 618,949 626,050

239,450

4,327 -411,058

61% -66%

-406,731

720,485

-65%

301%

959,935

239,450

720,485

301%

1,179,254

865,500

313,754

36%

43,722

1,259,605

-1,215,883

-97%

Page 1

American Academy REVISED FY 2016-2017 Budget Audited Actual 2015-2016

Revised Budget 2016-2017

Estimated Actual 9/30/16 Rpt

Projected Budget 2017-2018

Projected Budget 2018-2019

Projected Budget 2019-2020

Balance on Hand July 1

$2,264,541

$2,419,464

$2,419,464

$2,419,550

$2,419,568

$2,419,662

Revenue: Per Pupil Revenue Mill Levy/Override Tuition Interest Income Student Participation Fees Child Care Fees Rental/Lease Contributions/Donations Categorical Revenue Other State Revenue Cap Reserve Bond Revenue Grants Local Grants Federal 5000 Other Sources Miscellaneous Revenue Total Revenue

11,874,135 929,899 1,499,847 11,884 905,613 516,676 87,490 277,642 437,652 62,565 (9,434) 87,347 16,681,316

11,918,637 903,413 1,509,171 6,000 932,522 525,000 65,000 285,250 463,271 58,116 288,778 10,000 16,965,158

$3,026,942 233,307 377,553 2,025 669,893 174,381 54,535 28,416 116,768 4,683,822

16,453,257 1,206,925 2,673,820 6,000 1,143,203 475,500 100,000 194,000 560,278 70,500 15,000 22,898,483

17,438,137 1,229,785 2,688,220 6,000 1,300,180 570,600 100,000 194,000 521,080 70,500 15,000 24,133,502

18,746,501 1,271,206 2,688,220 6,000 1,430,198 627,660 100,000 194,000 484,245 70,500 15,000 25,633,530

Total Sources

18,945,858

19,384,622

7,103,286

25,318,033

26,553,070

28,053,192

Expenditures: Salaries Benefits Purchased Services Purchased Prop Svcs Other Purch. Svcs Supplies & Materials Property Other Expenses Other Uses of Funds Grant Expense Cap Reserve Expense Total Expenditures

7,761,012 2,230,552 365,262 3,062,079 1,316,782 892,547 729,963 20,434 147,761 16,526,394

8,137,729 2,513,415 355,637 2,964,160 1,358,498 879,683 567,751 38,200 150,000 16,965,072

$1,521,258 459,484 106,937 705,255 460,230 127,724 36,080 14,284 35,365 3,466,618

10,613,913 3,577,270 464,333 3,277,668 1,918,455 1,832,201 763,425 208,200 243,000 22,898,464

11,240,192 3,808,595 483,834 4,474,297 2,142,377 1,345,089 296,500 99,523 243,000 24,133,407

11,760,066 3,959,940 492,174 4,982,980 2,309,250 1,429,144 356,000 100,911 243,000 25,633,467

Balance on Hand June 30

$2,419,464

$2,419,550

$3,636,668

$2,419,568

$2,419,662

$2,419,725

5710 1110 1310 1500 1700 1800 1910 1922 3100 3900

0100 0200 0300 0400 0500 0600 0700 0800 0900

Fund Balance as a % of Revenue

14.50%

14.26%

10.57%

10.03%

9.44%