Cash Flow - ASSUMPTIONS
USED
|
|
Selection |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Fees
- Advanced Payment |
$40,000 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Fees
- Indigents |
$40,000 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Fees
- Indigents |
40 |
<-- Workweek
Hours |
|
|
|
|
|
|
|
| |
|
Hourly
Rate of Pay |
$ 12.00
|
|
Year
2 |
Year
3 |
Year
4 |
Year
5 |
Year
6 |
Year
7 |
Total |
|
|
|
Number
Employed |
150 |
%
= |
40 |
60 |
90 |
- |
|
|
|
|
|
|
|
|
#
Employed: |
60 |
90
|
135 |
- |
- |
- |
|
|
|
|
Annual
Earnings |
|
|
$ 1,497,600
|
$ 2,246,400
|
$3,369,600
|
$
- |
$
- |
$
- |
$ 7,113,600
|
|
|
|
|
|
|
|
|
|
|
|
Avg
Earnings: |
$
47,424 |
|
|
|
Fees
- Premium Neighborhood |
$ 60,000 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$24,000 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Persons to be
fed |
700 |
$ 255,500
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Convert to
solar? |
1 |
Yes |
330 |
<--- #
Homes |
|
Homes ( 330) |
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Long |
|
Short |
|
|
|
|
|
|
|
|
|
Land |
Investment |
Solar |
Investment |
|
|
|
|
|
|
|
|
Amt
Financed |
$2,000,000
|
$ 10,000,000
|
$ 1,650,000
|
$ -
|
|
|
|
|
|
|
|
|
Annual
Rate: |
6.00% |
6.00% |
6.00% |
6.00% |
|
|
|
|
|
|
|
|
Term
(yrs) |
5 |
5 |
4 |
10 |
|
|
|
|
|
|
|
|
Years
Skipped |
0 |
1 |
0 |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Bal
Forward: |
$3,800,000
|
$ 10,600,000
|
$ 1,650,000
|
$
- |
|
|
|
|
|
|
|
|
Years
of Pmts: |
5 |
4 |
4 |
9 |
|
|
|
|
|
|
|
|
Payment: |
$38,666
|
$248,941
|
$38,750
|
$0 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|