| Schedule
5 |
|
|
|
|
| LAMAR STATE
COLLEGE - ORANGE |
|
| 3 YEAR CASH FLOW
PROJECTIONS (Local E & G, Designated, and Auxiliary) |
|
| QUARTER ENDING
February 28, 2006 |
|
|
|
|
|
| Estimated
Cash Inflows: |
|
FY
2006 |
|
FY
2007 |
|
FY 2008 |
|
|
Tuition and Fees, net (includes
Computer Use) |
|
$
5,397,978.00 |
|
$
5,397,978.00 |
|
$ 5,397,978.00 |
|
|
Bookstore Sales |
|
43,380.00 |
|
43,380.00 |
|
43,380.00 |
|
|
Investment Earnings |
|
79,382.00 |
|
71,443.80 |
|
64,299.42 |
|
|
Rental/Other Income |
|
299,388.00 |
|
293,188.00 |
|
293,188.00 |
|
|
Indirect Cost |
|
13,000.00 |
|
11,700.00 |
|
6,500.00 |
|
|
Lab Fees/Other Revenue |
|
|
27,000.00 |
|
27,000.00 |
|
27,000.00 |
|
|
Transfer Between Funds and Agency |
|
|
46,769.00 |
|
|
|
|
|
|
Skiles/TPEG |
|
|
(37,801.00) |
|
|
|
|
|
|
Unexpended Balance Forward |
|
|
262,761.00 |
|
|
|
|
|
|
Total Estimated Cash
Inflows for the Year |
|
6,131,857.00 |
|
5,844,689.80 |
|
5,832,345.42 |
|
|
|
|
| Estimated
Cash Outflows: |
|
|
|
|
Payroll and Operating Expenses |
|
5,475,754.68 |
|
5,465,447.04 |
|
5,455,138.60 |
|
|
Non-Tuition Revenue Bond Payments |
|
149,769.92 |
|
160,077.56 |
|
170,386.00 |
|
|
Banner Project |
|
1,000,000.00 |
|
|
|
|
|
|
|
|
|
|
|
Disaster Costs |
|
1,788,871.00 |
|
|
|
|
Total Estimated Cash
Outflows for the Year |
|
8,414,395.60 |
|
5,625,524.60 |
|
5,625,524.60 |
|
|
|
|
| Net
Cash Inflows/Outflows for the Year |
|
(2,282,538.60) |
|
219,165.20 |
|
206,820.82 |
|
|
|
|
| Cash
and Cash Equivalents for Local E & G, Designated and Auxiliary Funds as
of September 1 (See Note A) |
9,032,566.42 |
|
6,250,027.82 |
|
5,971,893.02 |
|
|
|
|
| Estimated
Cash and Cash Equivalents as of August 31 |
|
$
6,750,027.82 |
|
$
6,469,193.02 |
|
$ 6,178,713.84 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Note
A: "Cash & Cash
Equivalents" includes Cash & TexPool Investment Pool. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Schedule 5
- Work Paper - NOT for Distribution |
|
| |
|
|
|
| LAMAR STATE COLLEGE - ORANGE |
|
| 3 YEAR CASH FLOW PROJECTIONS (Local E&G,
Designated, and Auxiliary) |
|
| QUARTER ENDING February 28, 2006 |
|
| |
|
|
|
|
|
|
Fund 2 |
|
**Prior Columns NOT Set Up as Formulas for
all Projections** |
|
|
|
|
|
|
|
|
|
|
|
|
|
| Estimated Cash Inflows: |
|
Local E&G |
|
Designated |
|
Auxiliary |
|
FY
2006 |
|
FY
2007 |
|
FY 2008 |
|
|
Tuition and Fees, net |
per Budget |
2,143,350 |
+ |
2,525,221 |
+ |
729,407 |
= |
$
5,397,978.00 |
|
$
5,397,978.00 |
|
$ 5,397,978.00 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Computer Use Fee |
per Budget |
0 |
|
0 |
+ |
0 |
|
$ - |
|
$ - |
|
$ - |
|
|
Bookstore Sales |
per Budget |
0 |
|
0 |
|
43,380 |
= |
$ 43,380.00 |
|
43,380.00 |
|
43,380.00 |
|
|
Investment Earnings |
Tuition Rev. Bonds |
|
|
|
|
0 |
|
$ - |
|
0 |
|
0 |
|
|
New 225k bond-fy03 |
0 |
|
|
|
|
|
$ - |
|
|
|
|
|
|
Budgeted Interest |
25,000 |
+ |
40,682 |
+ |
13,700 |
|
$ 79,382.00 |
|
$ 71,443.80 |
|
$ 64,299.42 |
|
|
Miscellaneous Revenue |
|
|
|
|
3,200 |
= |
$ 3,200.00 |
|
|
|
- |
|
|
Rental/Other Income |
Green Ave. Plaza |
0 |
+ |
2,400 |
+ |
500 |
= |
$ 2,900.00 |
|
2,900.00 |
|
2,900.00 |
|
|
Brown Center |
0 |
+ |
290,288 |
|
0 |
|
$ 290,288.00 |
|
$ 290,288.00 |
|
$ 290,288.00 |
|
|
Indirect Cost |
|
13,000 |
+ |
|
+ |
0 |
= |
$ 13,000.00 |
|
$ 11,700.00 |
|
6,500.00 |
|
|
Diploma Fees |
|
|
|
3,000 |
|
|
|
$ 3,000.00 |
|
$ 2,700.00 |
|
6,500.00 |
|
|
Lab Fees/Other Rev. |
per Budget |
27,000 |
+ |
|
+ |
0 |
= |
$ 27,000.00 |
|
27,000.00 |
|
27,000.00 |
|
|
|
|
|
|
|
|
$ - |
|
|
|
|
|
|
Unexpended Balance Forward |
0 |
|
262,761 |
|
|
$ 262,761.00 |
|
|
|
|
|
|
Transfer Between Agency(Bond Pmt) |
|
|
-217,495 |
|
|
$ (217,495.00) |
|
|
|
|
|
|
Transfer Between Funds |
|
0 |
|
264,264 |
|
|
$ 264,264.00 |
|
|
|
|
|
|
TPEG |
|
|
-378,011 |
|
340,210 |
|
|
$ (37,801.00) |
|
|
|
|
|
|
Skiles |
|
|
-25,085 |
|
25,085 |
|
|
$ - |
|
|
|
|
|
|
Total Est. Cash Inflows |
1,805,254 |
|
3,536,416 |
|
790,187 |
|
$
6,131,857.00 |
|
$
5,847,389.80 |
|
$ 5,838,845.42 |
|
|
|
|
|
|
|
|
| Estimated Cash Out: |
per Budget |
9,769,843 |
|
3,151,847 |
|
668,382 |
|
|
|
|
Payroll/Oper. Exp. |
less HEAF |
(743,365) |
|
|
|
|
|
|
|
|
|
|
|
x 20%
"local" = for E & G only |
|
1,805,296 |
+ |
3,151,847 |
+ |
668,382 |
= |
$
5,475,754.68 |
|
$
5,465,447.04 |
|
$ 5,455,138.60 |
|
|
|
|
|
|
|
|
Non-Tuition Revenue Bond
Payments |
|
|
149,769.92 |
|
160,077.56 |
|
170,386.00 |
|
|
|
|
|
|
|
|
|
|
|
|
Banner Project |
|
Estimated |
|
1,000,000.00 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Disaster Costs |
|
|
|
|
|
1,788,871.00 |
|
|
|
|
Reserved for possible funding of
computer system |
|
|
|
500,000.00 |
|
500,000.00 |
|
|
|
|
Total Est. Cash Outflows |
|
|
|
$
8,914,395.60 |
|
$
6,125,524.60 |
|
$ 5,625,524.60 |
|
|
|
|
| Net Cash In/Out for the
Year |
|
$
(2,782,538.60) |
|
$ (278,134.80) |
|
$ 213,320.82 |
|
|
|
|
| Cash/Cash Eq. as of
September 1 |
|
+ |
$
9,032,566.42 |
+ |
$
6,250,027.82 |
+ |
$ 5,971,893.02 |
|
|
|
|
| Estimated Cash/Cash Eq.
for E & G, Designated and Auxiliary Funds as of August 31 |
|
$
6,250,027.82 |
|
$
5,971,893.02 |
|
$ 6,185,213.84 |
|
|
|
|
| (a) Estimation based on
actual for oct; estimated for nov thru feb |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| (d) Calculation of Bond
Payments: |
Taxable Refunding (for
each of the 3 years) |
|
$ 149,769.92 |
|
$ 160,077.56 |
|
$ 170,386.00 |
|
|
Tuition Rev. Bond
Payments GR |
|
|
|
|
|
|
|
| NOTE: TPEG is not shown as Desig. Inflow because
it was not deducted from E&G. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|