president

Document Sample
president Powered By Docstoc
					FLORIDA ATLANTIC UNIVERSITY                                                                                                                                         June 30,2009
Auxiliary Cash Flow Projections and YTD Actual
ATHLETICS Banner Fund: ATHLET
FY 2007-2008                       INIT/ADJ                                                                                                                      6/30              OVER/
CASH FLOW                           BUDGET                             QTR 1             QTR 2                          QTR 3               QTR 4              TOTAL             (UNDER)
-------------------------------- -----------------                ----------------- -----------------              -----------------   -----------------   -----------------   -----------------
Beginning Fund Balance             (3,017,357)                      (3,017,357) (2,840,037)                          (2,036,306)         (4,340,113)         (3,017,357)                     0
+ Revenue                          13,236,185                        4,112,709         4,212,856                      1,504,372           2,014,935          11,844,872          (1,391,313)
+ Transfer                                     0                                           90,000                        239,349             932,796          1,262,145           1,262,145
- Expenditures                     13,236,185                        3,935,389         3,499,125                      4,047,528           1,715,991          13,198,033              (38,152)                          43150
- Transfer Out                                 0                                0                 0                              0                   0                    0                  0                       -121966
                                 -----------------                ----------------- -----------------              -----------------   -----------------   -----------------   -----------------                      165116
Ending Fund Balance                (3,017,357)                      (2,840,037) (2,036,306)                          (4,340,113)         (3,108,373)         (3,108,373)             (91,017)
                                 -----------------                ----------------- -----------------              -----------------   -----------------   -----------------   -----------------
================= =========                                       ========= =========                              =========           =========           =========           =========
FY 2007-2008
CASH FLOW %                         ACTUAL                             QTR 1             QTR 2             QTR 3             QTR 4            TOTAL
-------------------------------- -----------------                ----------------- ----------------- ----------------- ----------------- -----------------
+ Revenue                          11,844,872                            34.72%            35.57%            12.70%            17.01%           100.00%
+ Transfer                          1,262,145                              0.00%             7.13%           18.96%            73.91%           100.00%
- Expenditures                     13,198,033                            29.82%            26.51%            30.67%            13.00%           100.00%
- Transfer Out                                 0                           0.00%             0.00%             0.00%             0.00%             0.00%
                                 -----------------                ----------------- ----------------- ----------------- ----------------- -----------------
================= =========                                       ========= ========= ========= ========= =========
FY 2008-2009                           INIT                                                                                                     6/30
PROJECT                             BUDGET                             QTR 1             QTR 2             QTR 3             QTR 4            Project
-------------------------------- -----------------                ----------------- ----------------- ----------------- ----------------- -----------------
Beginning Fund Balance             (3,108,373)                      (3,108,373) (3,108,373) (3,108,373) (3,108,373) (3,108,373)
+ Revenue                          13,015,662                        3,253,916         3,253,916         3,253,916         3,253,916 13,015,662
+ Transfer In                                  0                                0                 0                 0                 0                  0
- Expenditures                     13,015,661                        3,253,915         3,253,915         3,253,915         3,253,915 13,015,661
- Transfer Out                                 0                                0                 0                 0                 0                  0
                                 -----------------                ----------------- ----------------- ----------------- ----------------- -----------------
Ending Fund Balance                (3,108,372)                      (3,108,373) (3,108,373) (3,108,373) (3,108,372) (3,108,372)
                                 -----------------                ----------------- ----------------- ----------------- ----------------- -----------------
================= =========                                       ========= ========= ========= ========= =========                                                            =========           ========
FY 2008-2009                      INIT/ADJD                            QTR 1             QTR 2             QTR 3             QTR 4              6/30                                OVER                  %
CASH FLOW                           BUDGET                             Actual            Actual            Actual            Actual             Total                            (UNDER)               VAR*
-------------------------------- -----------------                ----------------- ----------------- ----------------- ----------------- -----------------                    -----------------   ---------------
Beginning Fund Balance             (3,108,373)                      (3,108,373) (3,225,263) (2,496,194) (3,655,907) (3,108,373)                                                              0
+ Revenue                          13,407,662                        4,797,903         3,405,479         2,214,514         1,628,211 12,046,105                                  (1,361,557)           -10.16%
+ Transfer In                           69,956                          (94,681)          284,561           122,682           858,418        1,170,980                            1,101,024          1573.88%
- Expenditures                     13,537,872                        4,701,320         2,960,970         3,493,909         1,965,542 13,121,742                                     (416,130)            -3.07%
-Transfer Out                                  0                        118,792                   0            3,000                  0         121,792                              121,792         #DIV/0!
                                 -----------------                ----------------- ----------------- ----------------- ----------------- -----------------                    -----------------   ---------------
Calc Ending Fund Balance           (3,168,627)                      (3,225,263) (2,496,194) (3,655,907) (3,134,821) (3,134,821)                                                       33,806              0.00%
================= =========                                       ========= ========= ========= ========= =========                                                            =========           ========
Banner Cash (FGRCASH)                                                  (697,562) (2,599,906)               (786,198)          237,758
                                 -----------------                ----------------- ----------------- ----------------- -----------------
Difference                                                          (2,527,702)           103,712       (2,869,709) (3,372,579)
Accounts Payable                                                        155,614            18,883            38,151           181,283
Defer Revenue                                                                   0                            21,644           708,850
Travel Advances
Prepaid items                                                                                                                                84,620
Due from Cop Unit Primary Govt              73,780        73,780          0                                                                  78,990
Accounts Receivable                        696,610     3,191,294      332565                                                                498,890
Cash on Hand                                 3,500         3,500        3500                                                                  1,000
Cash in Bank                                 5,544         5,544        5544                                                                  5,578
Loans Due                                3,151,527     3,151,527  3,151,527                                                               3,151,527
                                         2,527,706      (103,708) 2,869,714                                                              (3,372,582)
JE J0056669 booked late in 0708 xfr 118,791.50 from F00010(Aux Admin)
* IF A CATEGORY HAS A VARIANCE GREATER THAN 10%, CORRECTIVE ACTION IS NEEDED AND PROJECTIONS SHOULD BE ADJUSTED.

CHANGE PROJECTIONS: (INDICATE MONTH, CATEGORY AND AMOUNT)

COMMENTS:




                                                                                                                                                                                                                               4/16/2012   CF-
FLORIDA ATLANTIC UNIVERSITY                                                                                                                       June 30,2009
Auxiliary Cash Flow Projections and YTD Actual
TEACHING GYM Banner Fund: AT4096
Org: S09600
FY 2007-2008                   INIT/ADJ                                                                                                   6/30            OVER/
CASH FLOW                       BUDGET                           QTR 1             QTR 2             QTR 3             QTR 4            TOTAL           (UNDER)
---------------------------- -----------------              ----------------- ----------------- ----------------- ----------------- ----------------- -----------------
Beginning Fund Balance                2,682                          2,682             2,809            10,301            (3,848)            2,682                   0
+ Revenue                            75,000                                0           8,806             6,423          112,766           127,995             52,995
- Expenditures                       75,000                           (120)            1,238            19,386          102,999           123,503             48,503
- Transfer Out                        4,590                               (7)              76            1,186             6,303             7,558             2,968
                             -----------------              ----------------- ----------------- ----------------- ----------------- ----------------- -----------------
Ending Fund Balance                  (1,908)                         2,809            10,301            (3,848)             (384)             (384)            1,524
================ ==========                                 ========== ========== ========== ========== ========== ==========
FY 2007-2008
CASH FLOW %                     ACTUAL                           QTR 1             QTR 2             QTR 3             QTR 4            TOTAL
---------------------------- -----------------              ----------------- ----------------- ----------------- ----------------- -----------------
+ Revenue & Transfer               127,995                           0.00%             6.88%             5.02%            88.10%          100.00%
- Expenditures                     123,503                          -0.10%             1.00%            15.70%            83.40%          100.00%
- Transfer Out                        7,558                         -0.09%             1.01%            15.69%            83.40%          100.00%
                             -----------------              ----------------- ----------------- ----------------- ----------------- -----------------
================ ==========                                 ========== ========== ========== ========== ==========
FY 2008-2009                       INIT                                                                                                   6/30
PROJECT                         BUDGET                           QTR 1             QTR 2             QTR 3             QTR 4            Project
---------------------------- -----------------              ----------------- ----------------- ----------------- ----------------- -----------------
Beginning Fund Balance                 (384)                          (384)             (384)             (384)             (384)             (384)
+ Revenue & Transfer                 75,000                         18,750            18,750            18,750            18,750            75,000
- Expenditures                       70,410                         17,603            17,603            17,603            17,603            70,410
- Transfer Out                        4,590                          1,148             1,148             1,148             1,148             4,590
                             -----------------              ----------------- ----------------- ----------------- ----------------- -----------------
Ending Fund Balance                    (384)                          (384)             (384)             (384)             (384)             (384)
                             -----------------              ----------------- ----------------- ----------------- ----------------- -----------------
================ ==========                                 ========== ========== ========== ========== ==========                                      ==========          =======
FY 2008-2009                 INIT/ADJD                           QTR 1             QTR 2             QTR 3             QTR 4              6/30               OVER                %
CASH FLOW                    BUDGET                              Actual            Actual            Actual            Actual             Total           (UNDER)             VAR*
---------------------------- -----------------              ----------------- ----------------- ----------------- ----------------- -----------------   -----------------   ------------
Beginning Fund Balance                 (384)                          (384)          (13,675)          (20,061)          (38,827)             (384)                    0
+ Revenue                            75,000                          3,325             7,225             9,335          128,547           148,432               73,432         97.91%
+ Transfer In                               0                              0                 0                 0           1,569             1,569               1,569       #DIV/0!
- Expenditures                       70,410                         15,658            12,826            26,481            83,791          138,756               68,346         97.07%
- Transfer Out                        4,590                            958               785             1,621             5,128             8,492               3,902         85.01%
                             -----------------              ----------------- ----------------- ----------------- ----------------- -----------------   -----------------   ------------
Calc Ending Fund Balance               (384)                       (13,675)          (20,061)          (38,827)            2,369             2,369               2,753          0.00%
================ ==========                                 ========== ========== ========== ========== ==========                                      ==========          =======
Banner Cash (FGRCASH)                                              (22,481)          (28,867)          (47,633)        (121,139)
                             -----------------              ----------------- ----------------- ----------------- -----------------
Difference                                                           8,806             8,806             8,806          123,509
Travel Advance                                                             0
Accounts Receivable                                                  8,806             8,806             8,806          134,947
Accounts Payable                                                           0                                              11,439
* IF A CATEGORY HAS A VARIANCE GREATER THAN 10%, CORRECTIVE ACTION IS NEEDED AND PROJECTIONS SHOULD BE ADJUSTED.

CHANGE PROJECTIONS: (INDICATE MONTH, CATEGORY AND AMOUNT)

COMMENTS:




                                                                                                             4/16/2012                                                                     CF-
FLORIDA ATLANTIC UNIVERSITY                                                                                                               June 30,2009
Auxiliary Cash Flow Projections and YTD Actual
GREATER BOCA RATON SOCCERFIELD Banner Fund: AT4097
Org: S09603
FY 2007-2008                    INIT/ADJ                                                                                      6/30            OVER/
CASH FLOW                        BUDGET             QTR 1             QTR 2             QTR 3             QTR 4             TOTAL           (UNDER)
----------------------------- ----------------- ----------------- ----------------- ----------------- ----------------- ----------------- -----------------
Beginning Fund Balance                      0                 0                 0                 0                 0                 0                 0
+ Revenue & Transfer                        0                 0                 0                 0                 0                 0                 0
- Expenditures                              0                 0                 0                 0                 0                 0                 0
- Transfer Out                              0                 0                 0                 0                 0                 0                 0
                              ----------------- ----------------- ----------------- ----------------- ----------------- ----------------- -----------------
Ending Fund Balance                         0                 0                 0                 0                 0                 0                 0
                              ----------------- ----------------- ----------------- ----------------- ----------------- ----------------- -----------------
================= ========== ========== ========== ========== ========== ========== ==========
FY 2007-2008
CASH FLOW %                      ACTUAL             QTR 1             QTR 2             QTR 3             QTR 4             TOTAL
----------------------------- ----------------- ----------------- ----------------- ----------------- ----------------- -----------------
+ Revenue & Transfer                        0            0.00%             0.00%             0.00%             0.00%             0.00%
- Expenditures                              0            0.00%             0.00%             0.00%             0.00%             0.00%
- Transfer Out                              0            0.00%             0.00%             0.00%             0.00%             0.00%
                              ----------------- ----------------- ----------------- ----------------- ----------------- -----------------
================= ========== ========== ========== ========== ========== ==========
FY 2008-2009                        INIT                                                                                      6/30
PROJECT                          BUDGET             QTR 1             QTR 2             QTR 3             QTR 4             Project
----------------------------- ----------------- ----------------- ----------------- ----------------- ----------------- -----------------
Beginning Fund Balance                      0                 0                 0                 0                 0                 0
+ Revenue & Transfer                        0                 0                 0                 0                 0                 0
- Expenditures                              0                 0                 0                 0                 0                 0
- Transfer Out                              0                 0                 0                 0                 0                 0
                              ----------------- ----------------- ----------------- ----------------- ----------------- -----------------
Ending Fund Balance                         0                 0                 0                 0                 0                 0
                              ----------------- ----------------- ----------------- ----------------- ----------------- -----------------
================= ========== ========== ========== ========== ========== ========== ========== ========
FY 2008-2009                   INIT/ADJD            QTR 1             QTR 2             QTR 3             QTR 4               6/30            OVER                 %
CASH FLOW                        BUDGET              Actual            Actual            Actual            Actual            Total          (UNDER)             VAR*
----------------------------- ----------------- ----------------- ----------------- ----------------- ----------------- ----------------- ----------------- ---------------
Beginning Fund Balance                      0                 0           (3,864)          (84,424)        (196,999)                  0                 0
+ Revenue                                   0                 0                 0                 0         345,205           345,205           345,205        #DIV/0!
+ Transfer In                               0                 0                 0                 0                 0                 0                 0      #DIV/0!
- Expenditures                      300,000              3,569            80,855          112,575           148,205           345,205             45,205          15.07%
- Transfer Out                              0              295              (295)                 0                 0                (0)               (0) #DIV/0!
                              ----------------- ----------------- ----------------- ----------------- ----------------- ----------------- ----------------- ---------------
Calc Ending Fund Balance           (300,000)            (3,864)          (84,424)        (196,999)                  0                 0         300,000        #DIV/0!
                              ----------------- ----------------- ----------------- ----------------- ----------------- ----------------- ----------------- ---------------
================= ========== ========== ========== ========== ========== ========== ========== ========
FGRCASH                                                 (3,864)         (84,424)         (196,999)           (82,767)
                              ----------------- ----------------- ----------------- ----------------- -----------------
Difference                                                     -                 0                 0          82,767
Accounts Receivable                                                                                         146,395
Accounts Payable                                                                                              63,628
* IF A CATEGORY HAS A VARIANCE GREATER THAN 10%, CORRECTIVE ACTION IS NEEDED AND PROJECTIONS SHOULD BE ADJUSTED.

CHANGE PROJECTIONS: (INDICATE MONTH, CATEGORY AND AMOUNT)

COMMENTS:




                                                                                                         4/16/2012                                                CF-
FLORIDA ATLANTIC UNIVERSITY                                                                                                                                        June 30,2009
Auxiliary Cash Flow Projections and YTD Actual
ARENA EXTERNAL EVENT TICKET REVENUE Banner Fund: ATH496
Org: S09602
FY 2007-2008                   INIT/ADJ                                                                                                              6/30              OVER/
CASH FLOW                      BUDGET              QTR 1                                   QTR 2             QTR 3               QTR 4             TOTAL             (UNDER)
---------------------------- ----------------- -----------------                       ----------------- -----------------   ----------------- -----------------   -----------------
Beginning Fund Balance                3,244             3,244                                   3,244             2,396               3,244             3,244                     0
+ Revenue & Transfer                 15,000                   0                                       0                 0                   0                 0           (15,000)
- Expenditures                       15,000                   0                                   799              (799)                    0                 0           (15,000)
- Transfer Out                          918                   0                                     49               (49)                   0                 0              (918)
                             ----------------- -----------------                       ----------------- -----------------   ----------------- -----------------   -----------------
Ending Fund Balance                   2,326             3,244                                   2,396             3,244               3,244             3,244                 918
                             ----------------- -----------------                       ----------------- -----------------   ----------------- -----------------   -----------------
================ ========== ==========                                                 ========== ==========                 ========== ==========                 ==========
FY 2007-2008
CASH FLOW %                    ACTUAL              QTR 1                                   QTR 2             QTR 3             QTR 4             TOTAL
---------------------------- ----------------- -----------------                       ----------------- ----------------- ----------------- -----------------
+ Revenue & Transfer                        0           0.00%                                   0.00%             0.00%             0.00%             0.00%
- Expenditures                              0           0.00%                                   0.00%             0.00%             0.00%             0.00%
- Transfer Out                              0           0.00%                                   0.00%             0.00%             0.00%             0.00%
                             ----------------- -----------------                       ----------------- ----------------- ----------------- -----------------
================ ========== ==========                                                 ========== ========== ========== ==========
FY 2008-2009                       INIT                                                                                                            6/30
PROJECT                        BUDGET              QTR 1                                   QTR 2             QTR 3             QTR 4             Project
---------------------------- ----------------- -----------------                       ----------------- ----------------- ----------------- -----------------
Beginning Fund Balance                3,244             3,244                                   3,244             3,244             3,244             3,244
+ Revenue & Transfer                        0                 0                                       0                 0                 0                 0
- Expenditures                              0                 0                                       0                 0                 0                 0
- Transfer Out                              0                 0                                       0                 0                 0                 0
                             ----------------- -----------------                       ----------------- ----------------- ----------------- -----------------
Ending Fund Balance                   3,244             3,244                                   3,244             3,244             3,244             3,244
                             ----------------- -----------------                       ----------------- ----------------- ----------------- -----------------
================ ========== ==========                                                 ========== ========== ========== ==========                                 ========== =======
FY 2008-2009                  INIT/ADJD            QTR 1                                   QTR 2             QTR 3             QTR 4               6/30                 OVER              %
CASH FLOW                      BUDGET               Actual                                  Actual            Actual            Actual            Total              (UNDER)           VAR*
---------------------------- ----------------- -----------------                       ----------------- ----------------- ----------------- -----------------     ----------------- ------------
Beginning Fund Balance                3,244             3,244                                   3,244             3,244             3,244             3,244                       0
+ Revenue & Transfer                        0                 0                                       0                 0                 0                 0                     0 #DIV/0!
- Expenditures                              0                 0                                       0                 0                 0                 0                     0 #DIV/0!
- Transfer Out                              0                 0                                       0                 0                 0                 0                     0 #DIV/0!
                             ----------------- -----------------                       ----------------- ----------------- ----------------- -----------------     ----------------- ------------
Calc Ending Fund Balance              3,244             3,244                                   3,244             3,244             3,244             3,244                       0      0.00%
================ ========== ==========                                                 ========== ========== ========== ==========                                 ========== =======
Banner Cash (FGRCASH)                                   3,244                                   3,244             3,244             3,244
                             ----------------- -----------------                       ----------------- ----------------- -----------------
Difference                                                   (0)                                     (0)               (0)                0
Accounts Payable

* IF A CATEGORY HAS A VARIANCE GREATER THAN 10%, CORRECTIVE ACTION IS NEEDED AND PROJECTIONS SHOULD BE ADJUSTED.

CHANGE PROJECTIONS: (INDICATE MONTH, CATEGORY AND AMOUNT)

COMMENTS:




                                                                                                        4/16/2012                                                                        CF-
                     FLORIDA ATLANTIC UNIVERSITY
                     Auxiliary Month End Cash Balances                               2007-2008 Quarter 4                                                     2008-2009 Quarter 1                                                         2008-2009 Quarter 2                                                    2008-2009 Quarter 3                                                             2008-2009 Quarter 4

                                                                            Report of Budget Ending Cash Balance                                  Report of Budget Ending Cash Balance                                        Report of Budget Ending Cash Balance                           Report of Budget Ending Cash Balance              End Fund Balance      Report of Budget Ending Cash Balance                Ending Fund Balance

            BANNER                                         Run 06-30-05     Run 08-04-06     Run 09-04-07     Run: 08-20-08                               Run 10-03-06       Run 10-11-07       Run 10-10-08                        Run: 01-07-07     Run: 01-11-08     Run: 01-12-09                      Run: 04-12-07     Run: 4/15/2008 Run: 4/10/2009        Run 08-04-06     Run 09-04-07     Run: 08-20-08                     Run: 08-13-09

            FUND                                            6/30/2005        6/30/2006        6/30/2007            6/30/2008                9/30/2005          9/30/2006          9/30/2007          9/30/2008        12/31/2005        12/31/2006        12/31/2007        12/31/2008        3/31/2006         3/31/2007         3/31/2008         3/31/2009      6/30/2006        6/30/2007         6/30/2008       6/30/2008         6/30/2009

15   Pres   AT4096   Teaching gymnasium                       (55,435.05)      25,600.99         2,681.75                  (384.59)         6,476.40          26,923.22           2,809.73            (4,688.56)       (2,571.73)       53,663.63         10,302.01         (11,074.32)      (15,098.17)       (10,891.94)        (3,847.68)       (38,827.87)       25,600.99         2,681.75           (384.59)         (384.58)        2,368.73

15   Pres   AT4097   Great Boca Raton Soccerfield                                                                                                                                                     (3,863.86)                                                            (84,424.09)                                                          (196,999.07)

15   Pres   ATH496   Arena External Event Ticket Revenue                       24,962.88         3,244.47                   3,244.47                            34,869.47           3,244.47           3,244.47                         50,072.78          2,396.57          3,244.47                         113,699.77          3,244.47          3,244.47         24,962.88         3,244.47          3,244.47        3,244.47          3,244.47

15   Pres   AT5007   Football 02-03                         (761,526.85)     (761,526.85)     (761,538.74)               (761,538.74)      (761,526.85)       (761,526.85)       (761,538.74)       (761,538.74)    (761,526.85)      (761,526.85)      (761,538.74)      (761,538.74)     (761,526.85)      (761,538.74)      (761,538.74)            (11.89)     (761,526.85)     (761,538.74)      (761,538.74)    (761,538.74)      (761,538.74)

15   Pres   ATH007   Athletics - Loan 04-05                (1,890,000.00)   (1,890,000.00)   (1,890,000.00)            (1,890,000.00)    (1,890,000.00)     (1,890,000.00)     (1,890,000.00)     (1,890,000.00)   (1,890,000.00)    (1,890,000.00)    (1,890,000.00)    (1,890,000.00)   (1,890,000.00)    (1,890,000.00)    (1,890,000.00)    (1,890,000.00)    (1,890,000.00)   (1,890,000.00)   (1,890,000.00)   (1,890,000.00)   (1,890,000.00)

15   Pres   ATH507   Athletics - Loan 03-04                                  (500,000.00)     (500,000.00)               (500,000.00)                         (500,000.00)       (500,000.00)       (500,000.00)    (500,000.00)      (500,000.00)      (500,000.00)      (500,000.00)     (500,000.00)      (500,000.00)      (500,000.00)      (500,000.00)      (500,000.00)     (500,000.00)      (500,000.00)    (500,000.00)      (500,000.00)

15   Pres   ATHL00   Financial Statement Adjustments                          238,419.22                                                                        64,039.93                                            238,419.22         64,039.93                                           238,419.22         64,039.93                                            238,419.22

15   Pres   ATHLET   FAU University Athletics                281,436.27       482,589.80       226,941.84                 17,129.20         132,195.20         276,279.43         404,262.10        (238,856.08)   (1,052,243.74)     (984,022.03)     1,207,993.76      (2,599,905.96)    (557,438.72)      (785,705.84)     (1,095,812.59)    (3,655,911.93)      260,418.33       226,941.84       (121,966.20)    (121,966.20)      237,758.35

            Total                          President       (2,425,525.63)   (2,379,953.96)   (2,918,670.68)          (3,131,549.66)     (2,512,855.25)     (2,749,414.80)     (2,741,222.44)     (3,395,702.77)    (3,967,923.10)    (3,967,772.54)    (1,930,846.40)    (5,843,698.64)   (3,485,644.52)    (3,770,396.82)    (4,247,954.54)    (6,278,506.29)    (2,602,125.43)   (2,918,670.68)   (3,270,645.06)   (3,270,645.05)   (2,908,167.19)

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:8
posted:4/17/2012
language:English
pages:5