| Schedule
5 |
|
|
|
|
| LAMAR STATE
COLLEGE - ORANGE |
|
| 3 YEAR CASH FLOW
PROJECTIONS (Local E & G, Designated, and Auxiliary) |
|
| QUARTER ENDING
November 30, 2007 |
|
|
|
|
|
| Estimated
Cash Inflows: |
|
FY
2008 |
|
FY
2009 |
|
FY 2010 |
|
|
Tuition and Fees, net (includes
Computer Use) |
|
$
5,651,592.00 |
|
$
5,651,592.00 |
|
$ 5,651,592.00 |
|
|
Bookstore Sales |
|
49,345.00 |
|
49,345.00 |
|
49,345.00 |
|
|
Investment Earnings |
|
140,086.00 |
|
126,077.40 |
|
113,469.66 |
|
|
Rental/Other Income |
|
342,276.00 |
|
338,976.00 |
|
338,976.00 |
|
|
Indirect Cost |
|
16,000.00 |
|
14,400.00 |
|
12,960.00 |
|
|
Lab Fees/Other Revenue |
|
|
24,000.00 |
|
24,000.00 |
|
24,000.00 |
|
|
Transfer Between Funds and Agency |
|
|
(149,322.00) |
|
(149,322.00) |
|
(149,322.00) |
|
|
Skiles/TPEG |
|
|
(34,786.00) |
|
(34,786.00) |
|
(34,786.00) |
|
|
Unexpended Balance Forward |
|
|
966,207.00 |
|
- |
|
- |
|
|
Total Estimated Cash
Inflows for the Year |
|
7,005,398.00 |
|
6,020,282.40 |
|
6,006,234.66 |
|
|
|
|
| Estimated
Cash Outflows: |
|
|
|
|
Payroll and Operating Expenses |
|
6,629,827.46 |
|
6,696,125.73 |
|
6,763,087.00 |
|
|
Non-Tuition Revenue Bond Payments |
|
149,321.74 |
|
150,015.15 |
|
150,708.56 |
|
|
|
|
|
|
|
|
|
Total Estimated Cash
Outflows for the Year |
|
6,779,149.20 |
|
6,846,140.88 |
|
6,913,795.56 |
|
|
|
|
| Net
Cash Inflows/Outflows for the Year |
|
226,248.80 |
|
(825,858.48) |
|
(907,560.90) |
|
|
|
|
| Cash
and Cash Equivalents for Local E & G, Designated and Auxiliary Funds as
of September 1 (See Note A) |
11,175,796.31 |
|
11,402,045.11 |
|
10,576,186.63 |
|
|
|
|
| Estimated
Cash and Cash Equivalents as of August 31 |
|
$
11,402,045.11 |
|
$
10,576,186.63 |
|
$ 9,668,625.73 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 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 November 30, 2007 |
|
| |
|
|
|
|
|
|
Fund 2 |
|
**Prior Columns NOT Set Up as Formulas for
all Projections** |
|
|
|
|
|
|
|
|
|
|
|
|
|
| Estimated Cash Inflows: |
|
Local E&G |
|
Designated |
|
Auxiliary |
|
FY
2008 |
|
FY
2009 |
|
FY 2010 |
|
|
Tuition and Fees, net |
per Budget |
2,059,681 |
+ |
2,848,975 |
+ |
742,936 |
= |
$
5,651,592.00 |
|
$
5,651,592.00 |
|
$ 5,651,592.00 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Computer Use Fee |
per Budget |
- |
|
- |
+ |
- |
|
$ - |
|
$ - |
|
$ - |
|
|
Bookstore Sales |
per Budget |
- |
|
- |
|
49,345 |
= |
$ 49,345.00 |
|
49,345.00 |
|
49,345.00 |
|
|
Investment Earnings |
Tuition Rev. Bonds |
- |
|
- |
|
- |
|
$ - |
|
- |
|
- |
|
|
New 225k bond-fy03 |
- |
|
- |
|
- |
|
$ - |
|
- |
|
- |
|
|
Budgeted Interest |
50,000 |
+ |
64,086 |
+ |
26,000 |
|
$ 140,086.00 |
|
$ 126,077.40 |
|
$ 113,469.66 |
|
|
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 |
- |
+ |
333,076 |
|
- |
|
$ 333,076.00 |
|
$ 333,076.00 |
|
$ 333,076.00 |
|
|
Indirect Cost |
|
- |
+ |
16,000 |
+ |
- |
= |
$ 16,000.00 |
|
$ 14,400.00 |
|
$ 12,960.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 |
226,748 |
|
433,230 |
|
306,229 |
|
$ 966,207.00 |
|
- |
|
- |
|
|
Transfer Between Agency(Bond Pmt) |
- |
|
(149,322) |
|
- |
|
$ (149,322.00) |
|
$ (149,322.00) |
|
$ (149,322.00) |
|
|
Transfer Between Funds |
|
198,122 |
|
(187,407) |
|
(10,715) |
|
$ - |
|
- |
|
- |
|
|
TPEG |
|
|
(347,860) |
|
313,074 |
|
- |
|
$ (34,786.00) |
|
(34,786.00) |
|
(34,786.00) |
|
|
Skiles |
|
|
(23,645) |
|
23,645 |
|
- |
|
$ - |
|
- |
|
- |
|
|
Total Est. Cash Inflows |
2,187,046 |
|
3,700,757 |
|
1,117,595 |
|
$
7,005,398.00 |
|
$
6,020,282.40 |
|
$ 6,190,342.66 |
|
|
|
|
|
|
|
|
| Estimated Cash Out: |
per Budget |
10,981,264 |
|
3,700,757 |
|
1,105,149 |
|
|
|
|
Payroll/Oper. Exp. |
less HEAF |
(1,115,048) |
|
- |
|
- |
|
|
|
|
|
|
|
x 20%
"local" = for E & G only |
|
1,973,243 |
+ |
3,700,757 |
+ |
1,105,149 |
= |
$
6,629,827.46 |
|
$
6,696,125.73 |
|
$ 6,763,087.00 |
|
|
|
|
|
|
|
|
Non-Tuition Revenue Bond
Payments |
|
|
149,321.74 |
|
150,015.15 |
|
150,708.56 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Total Est. Cash Outflows |
|
|
|
$ 6,779,149.20 |
|
$ 6,846,140.88 |
|
$ 6,913,795.56 |
|
|
|
|
| Net Cash In/Out for the
Year |
|
$ 226,248.80 |
|
$ (825,858.48) |
|
$ (723,452.90) |
|
|
|
|
| Cash/Cash Eq. as of
September 1 |
|
+ |
$
11,175,796.31 |
+ |
$
11,402,045.11 |
+ |
$
10,576,186.63 |
|
|
|
|
| Estimated Cash/Cash Eq.
for E & G, Designated and Auxiliary Funds as of August 31 |
|
$
11,402,045.11 |
|
$
10,576,186.63 |
|
$ 9,852,733.73 |
|
|
|
|
| (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) |
|
|
|
|
|
|
|
|
Tuition Rev. Bond
Payments GR |
|
|
|
|
|
|
|
| NOTE: TPEG is not shown as Desig. Inflow because
it was not deducted from E&G. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|