| Schedule
5 |
|
|
|
|
| LAMAR STATE
COLLEGE - ORANGE |
|
| 3 YEAR CASH FLOW
PROJECTIONS (Local E & G, Designated, and Auxiliary) |
|
| QUARTER ENDING
August 31, 2007 |
|
|
|
|
|
| Estimated
Cash Inflows: |
|
FY 2007 |
|
FY 2008 |
|
FY 2009 |
|
|
Tuition and Fees, net (includes
Computer Use) |
|
$ 5,135,393.00 |
|
$ 5,135,393.00 |
|
$ 5,135,393.00 |
|
|
Course Fees |
|
$ 72,315.00 |
|
$ - |
|
$ - |
|
|
Bookstore Sales |
|
43,380.00 |
|
43,380.00 |
|
43,380.00 |
|
|
Investment Earnings |
|
96,512.00 |
|
86,860.80 |
|
78,174.72 |
|
|
Rental/Other Income |
|
317,589.00 |
|
311,289.00 |
|
311,289.00 |
|
|
Indirect Cost |
|
16,000.00 |
|
14,400.00 |
|
8,000.00 |
|
|
Lab Fees/Other Revenue |
|
|
24,000.00 |
|
24,000.00 |
|
24,000.00 |
|
|
Transfer Between Funds and Agency |
|
|
(148,761.00) |
|
(148,761.00) |
|
(148,761.00) |
|
|
Skiles/TPEG |
|
|
(33,750.00) |
|
(33,750.00) |
|
(33,750.00) |
|
|
Unexpended Balance Forward |
|
|
1,043,462.00 |
|
|
|
|
|
|
Total Estimated Cash
Inflows for the Year |
|
6,566,140.00 |
|
5,432,811.80 |
|
5,417,725.72 |
|
|
|
|
| Estimated
Cash Outflows: |
|
|
|
|
Payroll and Operating Expenses |
|
5,922,192.28 |
|
5,902,593.56 |
|
5,882,994.84 |
|
|
Non-Tuition Revenue Bond Payments |
|
129,722.83 |
|
149,321.55 |
|
168,920.27 |
|
|
Banner Project |
|
297,296.00 |
|
|
|
|
|
|
|
|
|
|
|
Total Estimated Cash
Outflows for the Year |
|
6,349,211.11 |
|
6,051,915.11 |
|
6,051,915.11 |
|
|
|
|
| Net
Cash Inflows/Outflows for the Year |
|
216,928.89 |
|
(619,103.31) |
|
(634,189.39) |
|
|
|
|
| Cash
and Cash Equivalents for Local E & G, Designated and Auxiliary Funds as
of September 1 (See Note A) |
10,613,636.27 |
|
10,830,565.16 |
|
10,396,972.85 |
|
|
|
|
| Estimated
Cash and Cash Equivalents as of August 31 |
|
$ 10,830,565.16 |
|
$ 10,211,461.85 |
|
$ 9,762,783.46 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 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, 2007 |
|
| |
|
|
|
|
|
|
Fund 2 |
|
**Prior Columns NOT Set Up as Formulas for
all Projections** |
|
|
|
|
|
|
|
|
|
|
|
|
|
| Estimated Cash Inflows: |
|
Local E&G |
|
Designated |
|
Auxiliary |
|
FY 2007 |
|
FY 2008 |
|
FY 2009 |
|
|
Tuition and Fees, net |
per Budget |
1,955,631 |
+ |
2,465,305 |
+ |
714,457 |
= |
$ 5,135,393.00 |
|
$ 5,135,393.00 |
|
$ 5,135,393.00 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Computer Use Fee |
per Budget |
|
|
|
+ |
|
|
$ - |
|
$ - |
|
$ - |
|
|
Course Fees |
per Budget |
|
|
72,315 |
|
|
= |
$ 72,315.00 |
|
$ - |
|
$ - |
|
|
Bookstore Sales |
per Budget |
|
|
|
|
43,380 |
= |
$ 43,380.00 |
|
43,380.00 |
|
43,380.00 |
|
|
Investment Earnings |
Tuition Rev. Bonds |
|
|
|
|
|
|
$ - |
|
0 |
|
0 |
|
|
New 225k bond-fy03 |
|
|
|
|
|
|
$ - |
|
|
|
|
|
|
Budgeted Interest |
25,000 |
+ |
46,512 |
+ |
25,000 |
|
$ 96,512.00 |
|
$ 86,860.80 |
|
$ 78,174.72 |
|
|
Miscellaneous Revenue |
|
|
|
|
3,300 |
= |
$ 3,300.00 |
|
|
|
- |
|
|
Rental/Other Income |
Green Ave. Plaza |
|
+ |
2,400 |
+ |
500 |
= |
$ 2,900.00 |
|
2,900.00 |
|
2,900.00 |
|
|
Brown Center |
|
+ |
308,389 |
|
|
|
$ 308,389.00 |
|
$ 308,389.00 |
|
$ 308,389.00 |
|
|
Indirect Cost |
|
16,000 |
+ |
|
+ |
|
= |
$ 16,000.00 |
|
$ 14,400.00 |
|
8,000.00 |
|
|
Diploma Fees |
|
|
|
3,000 |
|
|
|
$ 3,000.00 |
|
$ 3,000.00 |
|
3,000.00 |
|
|
Lab Fees/Other Rev. |
per Budget |
24,000 |
+ |
|
+ |
|
= |
$ 24,000.00 |
|
24,000.00 |
|
24,000.00 |
|
|
|
|
|
|
|
|
$ - |
|
|
|
|
|
|
Unexpended Balance Forward |
680,904 |
|
362,558 |
|
|
$ 1,043,462.00 |
|
|
|
|
|
|
Transfer Between Agency(Bond Pmt) |
|
|
-148,761 |
|
|
$ (148,761.00) |
|
$ (148,761.00) |
|
$ (148,761.00) |
|
|
Transfer Between Funds |
|
|
|
0 |
|
|
$ - |
|
|
|
|
|
|
TPEG |
|
|
-337,504 |
|
303,754 |
|
|
$ (33,750.00) |
|
(33,750.00) |
|
(33,750.00) |
|
|
Skiles |
|
|
-23,155 |
|
23,155 |
|
|
$ - |
|
|
|
|
|
|
Total Est. Cash Inflows |
2,340,876 |
|
3,438,627 |
|
786,637 |
|
$ 6,566,140.00 |
|
$ 5,618,322.80 |
|
$ 5,603,236.72 |
|
|
|
|
|
|
|
|
| Estimated Cash Out: |
per Budget |
10,320,552 |
|
3,434,270 |
|
702,208 |
|
|
|
|
Payroll/Oper. Exp. |
less HEAF |
(743,365) |
|
|
|
|
|
|
|
|
|
|
|
x 20% "local" = for E & G only |
|
1,915,437 |
+ |
3,434,270 |
+ |
702,208 |
= |
$ 5,922,192.28 |
|
$ 5,902,593.56 |
|
$ 5,882,994.84 |
|
|
|
|
|
|
|
|
Non-Tuition Revenue Bond
Payments |
|
|
129,722.83 |
|
149,321.55 |
|
168,920.27 |
|
|
|
|
|
|
|
|
|
|
|
|
Banner Project |
|
Estimated |
|
297,296.00 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Total Est. Cash Outflows |
|
|
|
$
6,349,211.11 |
|
$
6,051,915.11 |
|
$ 6,051,915.11 |
|
|
|
|
| Net Cash In/Out for the
Year |
|
$ 216,928.89 |
|
$ (433,592.31) |
|
$ (448,678.39) |
|
|
|
|
| Cash/Cash Eq. as of
September 1 |
|
+ |
$ 10,613,636.27 |
+ |
$ 10,830,565.16 |
+ |
$ 10,396,972.85 |
|
|
|
|
| Estimated Cash/Cash Eq.
for E & G, Designated and Auxiliary Funds as of August 31 |
|
$ 10,830,565.16 |
|
$ 10,396,972.85 |
|
$ 9,948,294.46 |
|
|
|
|
| (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) |
|
$ 129,722.83 |
|
149,321.55 |
|
168,920.27 |
|
|
Tuition Rev. Bond
Payments GR |
|
|
|
|
|
|
|
| NOTE: TPEG is not shown as Desig. Inflow because
it was not deducted from E&G. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|