| Schedule
5 |
|
|
|
|
| LAMAR STATE
COLLEGE - ORANGE |
|
| 3 YEAR CASH FLOW
PROJECTIONS (Local E & G, Designated, and Auxiliary) |
|
| QUARTER ENDING
May 31,2005 |
|
|
|
|
|
| Estimated
Cash Inflows: |
|
FY
2005 |
|
FY
2006 |
|
FY 2007 |
|
|
Tuition and Fees, net (includes
Computer Use) |
|
$
4,884,325.00 |
|
$
4,884,325.00 |
|
$ 4,884,325.00 |
|
|
Bookstore Sales |
|
43,380.00 |
|
43,380.00 |
|
43,380.00 |
|
|
Investment Earnings |
|
87,700.00 |
|
78,930.00 |
|
71,037.00 |
|
|
Rental/Other Income |
|
268,972.00 |
|
268,972.00 |
|
268,972.00 |
|
|
Indirect Cost |
|
13,000.00 |
|
11,700.00 |
|
6,500.00 |
|
|
Lab Fees/Other Revenue |
|
|
16,500.00 |
|
16,500.00 |
|
16,500.00 |
|
|
Transfer Between Funds and Agency |
|
|
- |
|
|
|
|
|
|
Skiles/TPEG |
|
|
- |
|
|
|
|
|
|
Unexpended Balance Forward |
|
|
- |
|
|
|
|
|
|
Total Estimated Cash
Inflows for the Year |
|
5,313,877.00 |
|
5,303,807.00 |
|
5,290,714.00 |
|
|
|
|
| Estimated
Cash Outflows: |
|
|
|
|
Payroll and Operating Expenses |
|
4,460,194.43 |
|
4,459,951.74 |
|
4,460,019.59 |
|
|
Non-Tuition Revenue Bond Payments |
|
147,118.97 |
|
147,361.66 |
|
147,293.81 |
|
|
Construction Payments |
|
- |
|
|
|
|
|
|
|
|
|
|
|
Funding of Construction From FY 2002
Bond Proceeds |
|
- |
|
|
|
|
Funding of construction from
Designated and Auxillary |
|
- |
|
|
|
|
Total Estimated Cash
Outflows for the Year |
|
4,607,313.40 |
|
4,607,313.40 |
|
4,607,313.40 |
|
|
|
|
| Net
Cash Inflows/Outflows for the Year |
|
706,563.60 |
|
696,493.60 |
|
683,400.60 |
|
|
|
|
| Cash
and Cash Equivalents for Local E & G, Designated and Auxiliary Funds as
of September 1 (See Note A) |
8,496,825.32 |
|
8,703,388.92 |
|
8,899,882.52 |
|
|
|
|
| Estimated
Cash and Cash Equivalents as of August 31 |
|
$
9,203,388.92 |
|
$
9,399,882.52 |
|
$ 9,583,283.12 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 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 May 31, 2005 |
|
| |
|
|
|
|
|
|
Fund 2 |
|
**Prior Columns NOT Set Up as Formulas for
all Projections** |
|
|
|
|
|
|
|
|
|
|
|
|
|
| Estimated Cash Inflows: |
|
Local E&G |
|
Designated |
|
Auxiliary |
|
FY
2005 |
|
FY
2006 |
|
FY 2007 |
|
|
Tuition and Fees, net |
per Budget |
1,864,191 |
+ |
1,971,337 |
+ |
713,766 |
= |
$
4,549,294.00 |
|
$
4,549,294.00 |
|
$ 4,549,294.00 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Computer Use Fee |
per Budget |
0 |
|
335,031 |
+ |
0 |
|
$ 335,031.00 |
|
$ 335,031.00 |
|
$ 335,031.00 |
|
|
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 |
+ |
49,000 |
+ |
13,700 |
|
$ 87,700.00 |
|
$ 78,930.00 |
|
$ 71,037.00 |
|
|
|
0 |
|
|
|
|
= |
$ - |
|
|
|
- |
|
|
Rental/Other Income |
Green Ave. Plaza |
0 |
+ |
2,400 |
+ |
- |
= |
$ 2,400.00 |
|
2,400.00 |
|
2,400.00 |
|
|
Brown Center |
0 |
+ |
266,572 |
|
0 |
|
$ 266,572.00 |
|
$ 266,572.00 |
|
$ 266,572.00 |
|
|
Indirect Cost |
|
13000 |
+ |
0 |
+ |
0 |
= |
$ 13,000.00 |
|
$ 11,700.00 |
|
6,500.00 |
|
|
Lab Fees/Other Rev. |
per Budget |
16,500 |
+ |
|
+ |
0 |
= |
$ 16,500.00 |
|
16,500.00 |
|
16,500.00 |
|
|
|
|
|
|
|
$ - |
|
|
|
|
|
|
Unexpended Balance Forward |
365,333 |
|
76,845 |
|
|
|
|
|
|
|
|
|
Transfer Between Agency(Bond Pmt) |
|
|
-148,582 |
|
|
|
|
|
|
|
|
Transfer Between Funds |
|
0 |
|
0 |
|
$ - |
|
|
|
|
|
|
TPEG |
|
|
-331,064 |
|
297,957 |
|
|
|
|
|
|
|
|
Skiles |
|
|
-22,395 |
|
22,395 |
|
$ - |
|
|
|
|
|
|
Total Est. Cash Inflows |
1,930,565 |
|
2,872,955 |
|
770,846 |
|
$
5,313,877.00 |
|
$
5,303,807.00 |
|
$ 5,290,714.00 |
|
|
|
|
|
|
|
| Estimated Cash Out: |
per Budget |
8,981,494 |
|
2,209,922 |
|
749,886 |
|
|
|
|
Payroll/Oper. Exp. |
less HEAF |
(743,967) |
|
|
|
|
|
|
|
|
|
|
|
x 20%
"local" = for E & G only |
|
1,647,505 |
+ |
2,209,922 |
+ |
749,886 |
= |
$
4,460,194.43 |
|
$
4,459,951.74 |
|
$ 4,460,019.59 |
|
|
|
|
|
|
|
|
Non-Tuition Revenue Bond
Payments |
|
|
147,118.97 |
|
147,361.66 |
|
147,293.81 |
|
|
|
|
|
|
|
|
|
|
|
|
Construction Payments |
|
Estimated |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Funding of construction from Fy 2002
Bond Proceeds |
|
|
|
|
|
|
|
|
Funding of construction from
Designated and Auxillary |
|
|
|
|
|
|
|
Reserved for possible funding of
computer system |
|
|
|
500,000.00 |
|
500,000.00 |
|
|
|
|
Total Est. Cash Outflows |
|
|
|
$
5,107,313.40 |
|
$
5,107,313.40 |
|
$ 4,607,313.40 |
|
|
|
|
| Net Cash In/Out for the
Year |
|
$ 206,563.60 |
|
$ 196,493.60 |
|
$ 683,400.60 |
|
|
|
|
| Cash/Cash Eq. as of
September 1 |
|
+ |
$
8,496,825.32 |
+ |
$
8,703,388.92 |
+ |
$ 8,899,882.52 |
|
|
|
|
| Estimated Cash/Cash Eq.
for E & G, Designated and Auxiliary Funds as of August 31 |
|
$
8,703,388.92 |
|
$
8,899,882.52 |
|
$ 9,583,283.12 |
|
|
|
|
| (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) |
|
$ 147,118.97 |
|
$ 147,361.66 |
|
$ 147,293.81 |
|
|
Tuition Rev. Bond
Payments GR |
|
|
|
|
|
|
|
| NOTE: TPEG is not shown as Desig. Inflow because
it was not deducted from E&G. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|