IRR Financial Model
IRR Financial Model
IRR Financial Model
IRR 1500000000.00%
Cash on Cash N/A 1000000000.00%
Fully Capitalized N/A
500000000.00%
0.00%
1 2
-500000000.00%
1500000000.00%
1000000000.00%
500000000.00%
IRR @ $250000
0.00%
Cash on Cash $28,679,090 1 2
Fully Capitalized $28,679,090 -500000000.00%
Sources of Funds
$130,861 $67,388 $0
$87,343 $63,473 $67,388
Sales
Net Income
1 2 3 4 5
1 2 3 4 5
Potential Capital Needed 2,300,000
Capital Requested 1,500,000
Potential Add'l Capital Needed 800,000
Capital Structure
Existing POST RAISE/NEW ADDITIONS
10.00% 6.50%
20.00% 13.00%
1.00% 0.65%
1.00% 0.65%
1.00% 0.65%
1.00% 0.65%
1.00% 0.65%
2.00% 1.30%
63.00% 40.30%
0.00% 35.65%
Total 100.00% Total 100.00%
Capital Structure
After Contributions
4.23%
8.45%
0.42%
0.42%
0.42%
0.42%
0.42%
0.85%
26.20%
23.17%
15.00%
20.00%
Total 100.00%
% Retained 80.00%
% Sold to Investors 20.00%
Projected Income Statements
At the end of year
1 2 3
Gross Revenue 259,750 1,368,370 6,049,920
% Growth N/A 426.80% 342.13%
Wages & Salaries 959,400 1,453,432 2,186,178
% of Sales 369.36% 106.22% 36.14%
Payroll Taxes 10,894 7,876 167,243
% of Sales 4.19% 0.58% 2.76%
Employee Benefits 10,390 39,610 137,000
% of Sales 4.00% 2.89% 2.26%
Operating Expenses 36,612 86,871 206,669
% of Sales 14.09% 6.35% 3.42%
Marketing & Promotion Expenses 40,000 6,684 23,119
% of Sales 15.40% 0.49% 0.38%
Contribution Margin (787,155) (186,493) 3,466,712
% Margin -303.04% -13.63% 57.30%
19,589 20,054
0.10% 0.05%
38,333 42,166
0.19% 0.10%
360,000 460,000
1.83% 1.10%
14,650,316 33,203,741
74.32% 79.29%
253,000 265,000
1.28% 0.63%
14,397,316 32,938,741
73.04% 78.65%
6,125 2,210
0.03% 0.01%
14,391,191 32,936,531
73.01% 78.65%
5,252,785 12,021,834
36.50% 36.50%
9,138,406 20,914,697
60,000 88,000
0.30% 0.21%
Cash on Cash
Fully Capitalized
1 2 3 4
EBITDA (913,739) (343,377) 3,252,725 14,650,316
Interest Paid (4,013) (2,505) (904) -
Taxes Paid - - (460,459) (5,252,785)
Cap Ex (60,000) (60,000) (60,000) (60,000)
CF Value - - - -
Net Cash Flow (1,500,000) (977,752) (405,882) 2,731,362 9,337,531
Net Cash Flow (1,500,000) (977,752) (405,882) 2,731,362 9,337,531
1 2 3 4
Operating Tax Rate 36.50% 36.50% 36.50% 36.50%
EBT x Tax Rate (420,228) (214,681) 1,095,368 5,252,785
NOL Carryforwards (420,228) (634,909) - -
CY Provision for Taxes - - 460,459 5,252,785
5
33,203,741
-
(12,021,834)
(88,000)
830,093,525
851,187,433
851,187,433
5
36.50%
12,021,834
-
12,021,834
Scenario Under Review 2 Projected Income State
For Year 1 by mon
1 2 3 4 5
Gross Revenue 12,000 12,750 13,750 15,250 16,750
% Growth N/A 6.25% 7.84% 10.91% 9.84%
Wages & Salaries 48,550 67,683 70,350 70,350 76,600
% of Sales 404.58% 530.85% 511.64% 461.31% 457.31%
Payroll Taxes 1,285 1,079 964 964 964
% of Sales 10.71% 8.46% 7.01% 6.32% 5.75%
Employee Benefits 600 750 810 930 950
% of Sales 5.00% 5.88% 5.89% 6.10% 5.67%
Operating Expenses 2,742 2,885 2,943 3,058 3,077
% of Sales 22.85% 22.63% 21.40% 20.05% 18.37%
Marketing & Promotion Expenses 3,333 3,333 3,333 3,333 3,333
% of Sales 27.78% 26.14% 24.24% 21.86% 19.90%
Contribution Margin (43,910) (62,231) (63,840) (62,455) (67,224)
% Margin -365.92% -488.08% -464.29% -409.54% -401.34%
- - - - - - -
0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00%
(95,968) (97,008) (94,466) (103,991) (106,241) (102,391) (98,637)
- - - - - - -
0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00%
(92,514) (85,392) (77,020) (66,779) (55,838) (42,891) (30,631)
(74,432) (167,153) (261,452) (354,335) (451,954) (547,922) (644,930) (739,396)
36.50% 36.50% 36.50% 36.50% 36.50% 36.50% 36.50% 36.50%
- - - - - - - -
(1,260,100) (1,364,986) (1,464,070) (1,562,793) (1,662,772) (1,755,286) (1,840,677) (1,917,697)
36.50% 36.50% 36.50% 36.50% 36.50% 36.50% 36.50% 36.50%
- - - - - - - -
(843,387) (949,627) (1,052,018) (1,150,655)
36.50% 36.50% 36.50% 36.50%
- - - -
(1,984,476) (2,040,314) (2,083,205) (2,113,836)
36.50% 36.50% 36.50% 36.50%
- - - -
Scenario Under Review 2
Income Statement 1 2 3
Gross Revenue 259,750 1,368,370 6,049,920
Wages & Salaries 959,400 1,453,432 2,186,178
Payroll Taxes 10,894 7,876 167,243
Employee Benefits 10,390 39,610 137,000
Operating Expenses 36,612 86,871 206,669
Marketing & Promotion Expenses 40,000 6,684 23,119
G&A 26,784 35,204 19,139
Other Misc. Expenses 63,800 31,680 34,848
Rent 36,000 90,000 160,000
Depreciation & Amortization 217,000 229,000 241,000
SCENARIO ASSUMPTIONS
Customer Customer
GROSS REVENUE 259,750 Growth % 1,368,370 Growth %
High Growth 1 566,500 323 300.00% 1,292 225.00%
Base Case 2 259,750 148 270.27% 548 200.00%
Slow Growth 3 390,000 222 100.00% 444 50.00%
VARIABLE EXPENSES
WAGES & SALARIES 959,400 1,453,432
High Growth 1 959,400 1,453,432 3,459,258
Base Case 2 959,400 1,453,432 2,186,178
Slow Growth 3 959,400 1,453,432 1,708,773
FIXED EXPENSES
G&A 26,784 35,204
High Growth 1 26,784 35,204 19,139
Base Case 2 26,784 35,204 19,139
Slow Growth 3 26,784 35,204 19,139
MPTIONS
Customer Customer
6,049,920 Growth % 19,712,588 Growth % 41,878,845
4,199 150.00% 10,498 125.00% 23,621
1,644 150.00% 4,110 100.00% 8,220
666 50.00% 999 50.00% 1,499
NSES
2,186,178 3,871,757 6,635,127
12 7,603,473 25 16,444,591 52
4 3,871,757 10 6,635,127 16
1 1,919,171 1 2,318,972 2
ES
19,139 19,589 20,054
19,589 20,054
19,589 20,054
19,589 20,054
22,833 28,625 34,417 40,208 46,000 51,792 57,583 63,375 69,167 74,958
121,125 141,313 161,500 181,688 201,875 222,063 242,250 262,438 282,625 302,813
12,750 13,750 15,250 16,750 18,500 21,000 23,500 26,500 29,500 33,250
47,000 53,250 59,500 67,000 74,500 82,000 90,750 100,750 112,000 124,500
18,625 22,313 26,000 29,688 33,375 37,063 40,750 44,438 48,125 51,813
64,750 69,375 74,000 78,625 83,250 87,875 92,500 97,125 101,750 106,375
12 Totals
80,750 586,750 $1
323,000 2,543,625
37,000 259,750
137,000 990,250
55,500 422,625
111,000 1,026,750
Revenue 1 5 8 10
Year Year Year Year
1 2 3 4
VARIABLE EXPENSES
Payroll Taxes
Calculated as a percentage (%) of Wages & Salaries
Employee Benefits
Calculated as a percentage (%) of Revenue
HIGH GROWTH
Month 1 4.00% 682 4.00% 4,038 4.00% 15,343 4.00%
Month 2 4.00% 913 4.00% 4,845 4.00% 17,765 4.00%
Month 3 4.00% 1,145 4.00% 5,653 4.00% 20,188 4.00%
Month 4 4.00% 1,377 4.00% 6,460 4.00% 22,610 4.00%
Month 5 4.00% 1,608 4.00% 7,268 4.00% 25,033 4.00%
Month 6 4.00% 1,840 4.00% 8,075 4.00% 27,455 4.00%
Month 7 4.00% 2,072 4.00% 8,883 4.00% 29,878 4.00%
Month 8 4.00% 2,303 4.00% 9,690 4.00% 32,300 4.00%
Month 9 4.00% 2,535 4.00% 10,498 4.00% 34,723 4.00%
Month 10 4.00% 2,767 4.00% 11,305 4.00% 37,145 4.00%
Month 11 4.00% 2,998 4.00% 12,113 4.00% 39,568 4.00%
Month 12 4.00% 3,230 4.00% 12,920 4.00% 41,990 4.00%
23,470 101,745 343,995
BASE CASE
Month 1 4.00% 600 4.00% 1,980 4.00% 6,393 4.00%
Month 2 4.00% 750 4.00% 2,480 4.00% 7,307 4.00%
Month 3 4.00% 810 4.00% 2,830 4.00% 8,220 4.00%
Month 4 4.00% 930 4.00% 3,080 4.00% 9,133 4.00%
Month 5 4.00% 950 4.00% 3,230 4.00% 10,047 4.00%
Month 6 4.00% 1,050 4.00% 3,280 4.00% 10,960 4.00%
Month 7 4.00% 940 4.00% 3,580 4.00% 11,873 4.00%
Month 8 4.00% 930 4.00% 3,880 4.00% 12,787 4.00%
Month 9 4.00% 990 4.00% 3,730 4.00% 13,700 4.00%
Month 10 4.00% 850 4.00% 3,980 4.00% 14,613 4.00%
Month 11 4.00% 780 4.00% 3,680 4.00% 15,527 4.00%
Month 12 4.00% 810 4.00% 3,880 4.00% 16,440 4.00%
10,390 39,610 137,000
SLOW GROWTH
Month 1 4.00% 598 4.00% 2,405 4.00% 4,625 4.00%
Month 2 4.00% 745 4.00% 2,590 4.00% 4,810 4.00%
Month 3 4.00% 893 4.00% 2,775 4.00% 4,995 4.00%
Month 4 4.00% 1,040 4.00% 2,960 4.00% 5,180 4.00%
Month 5 4.00% 1,188 4.00% 3,145 4.00% 5,365 4.00%
Month 6 4.00% 1,335 4.00% 3,330 4.00% 5,550 4.00%
Month 7 4.00% 1,483 4.00% 3,515 4.00% 5,735 4.00%
Month 8 4.00% 1,630 4.00% 3,700 4.00% 5,920 4.00%
Month 9 4.00% 1,778 4.00% 3,885 4.00% 6,105 4.00%
Month 10 4.00% 1,925 4.00% 4,070 4.00% 6,290 4.00%
Month 11 4.00% 2,073 4.00% 4,255 4.00% 6,475 4.00%
Month 12 4.00% 2,220 4.00% 4,440 4.00% 6,660 4.00%
16,905 41,070 67,710
Operating Expenses
Legal
Calculated as a percentage (%) of Revenue
HIGH GROWTH
Month 1 1.00% 170 0.75% 757 0.30% 1,151 0.30%
Month 2 1.00% 228 0.75% 908 0.30% 1,332 0.30%
Month 3 1.00% 286 0.75% 1,060 0.30% 1,514 0.30%
Month 4 1.00% 344 0.75% 1,211 0.30% 1,696 0.30%
Month 5 1.00% 402 0.75% 1,363 0.30% 1,877 0.30%
Month 6 1.00% 460 0.75% 1,514 0.30% 2,059 0.30%
Month 7 1.00% 518 0.75% 1,665 0.30% 2,241 0.30%
Month 8 1.00% 576 0.75% 1,817 0.30% 2,423 0.30%
Month 9 1.00% 634 0.75% 1,968 0.30% 2,604 0.30%
Month 10 1.00% 692 0.75% 2,120 0.30% 2,786 0.30%
Month 11 1.00% 750 0.75% 2,271 0.30% 2,968 0.30%
Month 12 1.00% 808 0.75% 2,423 0.30% 3,149 0.30%
5,868 19,077 25,800
BASE CASE
Month 1 1.00% 150 0.75% 371 0.30% 480 0.30%
Month 2 1.00% 188 0.75% 465 0.30% 548 0.30%
Month 3 1.00% 203 0.75% 531 0.30% 617 0.30%
Month 4 1.00% 233 0.75% 578 0.30% 685 0.30%
Month 5 1.00% 238 0.75% 606 0.30% 754 0.30%
Month 6 1.00% 263 0.75% 615 0.30% 822 0.30%
Month 7 1.00% 235 0.75% 671 0.30% 891 0.30%
Month 8 1.00% 233 0.75% 728 0.30% 959 0.30%
Month 9 1.00% 248 0.75% 699 0.30% 1,028 0.30%
Month 10 1.00% 213 0.75% 746 0.30% 1,096 0.30%
Month 11 1.00% 195 0.75% 690 0.30% 1,165 0.30%
Month 12 1.00% 203 0.75% 728 0.30% 1,233 0.30%
2,598 7,427 10,275
SLOW GROWTH
Month 1 1.00% 149 0.75% 451 0.30% 347 0.30%
Month 2 1.00% 186 0.75% 486 0.30% 361 0.30%
Month 3 1.00% 223 0.75% 520 0.30% 375 0.30%
Month 4 1.00% 260 0.75% 555 0.30% 389 0.30%
Month 5 1.00% 297 0.75% 590 0.30% 402 0.30%
Month 6 1.00% 334 0.75% 624 0.30% 416 0.30%
Month 7 1.00% 371 0.75% 659 0.30% 430 0.30%
Month 8 1.00% 408 0.75% 694 0.30% 444 0.30%
Month 9 1.00% 444 0.75% 728 0.30% 458 0.30%
Month 10 1.00% 481 0.75% 763 0.30% 472 0.30%
Month 11 1.00% 518 0.75% 798 0.30% 486 0.30%
Month 12 1.00% 555 0.75% 833 0.30% 500 0.30%
4,226 7,701 5,078
Payroll Service
Calculated as a percentage (%) of Revenue
HIGH GROWTH
Month 1 0.30% 51 0.30% 303 0.30% 1,151 0.30%
Month 2 0.30% 69 0.30% 363 0.30% 1,332 0.30%
Month 3 0.30% 86 0.30% 424 0.30% 1,514 0.30%
Month 4 0.30% 103 0.30% 485 0.30% 1,696 0.30%
Month 5 0.30% 121 0.30% 545 0.30% 1,877 0.30%
Month 6 0.30% 138 0.30% 606 0.30% 2,059 0.30%
Month 7 0.30% 155 0.30% 666 0.30% 2,241 0.30%
Month 8 0.30% 173 0.30% 727 0.30% 2,423 0.30%
Month 9 0.30% 190 0.30% 787 0.30% 2,604 0.30%
Month 10 0.30% 208 0.30% 848 0.30% 2,786 0.30%
Month 11 0.30% 225 0.30% 908 0.30% 2,968 0.30%
Month 12 0.30% 242 0.30% 969 0.30% 3,149 0.30%
1,760 7,631 25,800
BASE CASE
Month 1 0.30% 45 0.30% 149 0.30% 480 0.30%
Month 2 0.30% 56 0.30% 186 0.30% 548 0.30%
Month 3 0.30% 61 0.30% 212 0.30% 617 0.30%
Month 4 0.30% 70 0.30% 231 0.30% 685 0.30%
Month 5 0.30% 71 0.30% 242 0.30% 754 0.30%
Month 6 0.30% 79 0.30% 246 0.30% 822 0.30%
Month 7 0.30% 71 0.30% 269 0.30% 891 0.30%
Month 8 0.30% 70 0.30% 291 0.30% 959 0.30%
Month 9 0.30% 74 0.30% 280 0.30% 1,028 0.30%
Month 10 0.30% 64 0.30% 299 0.30% 1,096 0.30%
Month 11 0.30% 59 0.30% 276 0.30% 1,165 0.30%
Month 12 0.30% 61 0.30% 291 0.30% 1,233 0.30%
779 2,971 10,275
SLOW GROWTH
Month 1 0.30% 45 0.30% 180 0.30% 347 0.30%
Month 2 0.30% 56 0.30% 194 0.30% 361 0.30%
Month 3 0.30% 67 0.30% 208 0.30% 375 0.30%
Month 4 0.30% 78 0.30% 222 0.30% 389 0.30%
Month 5 0.30% 89 0.30% 236 0.30% 402 0.30%
Month 6 0.30% 100 0.30% 250 0.30% 416 0.30%
Month 7 0.30% 111 0.30% 264 0.30% 430 0.30%
Month 8 0.30% 122 0.30% 278 0.30% 444 0.30%
Month 9 0.30% 133 0.30% 291 0.30% 458 0.30%
Month 10 0.30% 144 0.30% 305 0.30% 472 0.30%
Month 11 0.30% 155 0.30% 319 0.30% 486 0.30%
Month 12 0.30% 167 0.30% 333 0.30% 500 0.30%
1,268 3,080 5,078
Postage
Calculated as a percentage (%) of Revenue
HIGH GROWTH
Month 1 0.02% 3 0.02% 20 0.02% 77 0.02%
Month 2 0.02% 5 0.02% 24 0.02% 89 0.02%
Month 3 0.02% 6 0.02% 28 0.02% 101 0.02%
Month 4 0.02% 7 0.02% 32 0.02% 113 0.02%
Month 5 0.02% 8 0.02% 36 0.02% 125 0.02%
Month 6 0.02% 9 0.02% 40 0.02% 137 0.02%
Month 7 0.02% 10 0.02% 44 0.02% 149 0.02%
Month 8 0.02% 12 0.02% 48 0.02% 162 0.02%
Month 9 0.02% 13 0.02% 52 0.02% 174 0.02%
Month 10 0.02% 14 0.02% 57 0.02% 186 0.02%
Month 11 0.02% 15 0.02% 61 0.02% 198 0.02%
Month 12 0.02% 16 0.02% 65 0.02% 210 0.02%
117 509 1,720
BASE CASE
Month 1 0.02% 3 0.02% 10 0.02% 32 0.02%
Month 2 0.02% 4 0.02% 12 0.02% 37 0.02%
Month 3 0.02% 4 0.02% 14 0.02% 41 0.02%
Month 4 0.02% 5 0.02% 15 0.02% 46 0.02%
Month 5 0.02% 5 0.02% 16 0.02% 50 0.02%
Month 6 0.02% 5 0.02% 16 0.02% 55 0.02%
Month 7 0.02% 5 0.02% 18 0.02% 59 0.02%
Month 8 0.02% 5 0.02% 19 0.02% 64 0.02%
Month 9 0.02% 5 0.02% 19 0.02% 69 0.02%
Month 10 0.02% 4 0.02% 20 0.02% 73 0.02%
Month 11 0.02% 4 0.02% 18 0.02% 78 0.02%
Month 12 0.02% 4 0.02% 19 0.02% 82 0.02%
52 198 685
SLOW GROWTH
Month 1 0.02% 3 0.02% 12 0.02% 23 0.02%
Month 2 0.02% 4 0.02% 13 0.02% 24 0.02%
Month 3 0.02% 4 0.02% 14 0.02% 25 0.02%
Month 4 0.02% 5 0.02% 15 0.02% 26 0.02%
Month 5 0.02% 6 0.02% 16 0.02% 27 0.02%
Month 6 0.02% 7 0.02% 17 0.02% 28 0.02%
Month 7 0.02% 7 0.02% 18 0.02% 29 0.02%
Month 8 0.02% 8 0.02% 19 0.02% 30 0.02%
Month 9 0.02% 9 0.02% 19 0.02% 31 0.02%
Month 10 0.02% 10 0.02% 20 0.02% 31 0.02%
Month 11 0.02% 10 0.02% 21 0.02% 32 0.02%
Month 12 0.02% 11 0.02% 22 0.02% 33 0.02%
85 205 339
Entertainment
Calculated as a fixed dollar ($) amount in Year 1 and percentage (%) of Revenue thereafter
HIGH GROWTH
Month 1 0.07% 12 0.07% 71 0.07% 268 0.08%
Month 2 0.07% 16 0.07% 85 0.07% 311 0.08%
Month 3 0.07% 20 0.07% 99 0.07% 353 0.08%
Month 4 0.07% 24 0.07% 113 0.07% 396 0.08%
Month 5 0.07% 28 0.07% 127 0.07% 438 0.08%
Month 6 0.07% 32 0.07% 141 0.08% 549 0.08%
Month 7 0.07% 36 0.07% 155 0.08% 598 0.08%
Month 8 0.07% 40 0.07% 170 0.08% 646 0.08%
Month 9 0.07% 44 0.07% 184 0.08% 694 0.08%
Month 10 0.07% 48 0.07% 198 0.08% 743 0.08%
Month 11 0.07% 52 0.07% 212 0.08% 791 0.08%
Month 12 0.07% 57 0.07% 226 0.08% 840 0.08%
411 1,781 6,628
BASE CASE
Month 1 0.07% 11 0.07% 35 0.07% 112 0.08%
Month 2 0.07% 13 0.07% 43 0.07% 128 0.08%
Month 3 0.07% 14 0.07% 50 0.07% 144 0.08%
Month 4 0.07% 16 0.07% 54 0.07% 160 0.08%
Month 5 0.07% 17 0.07% 57 0.07% 176 0.08%
Month 6 0.07% 18 0.07% 57 0.08% 219 0.08%
Month 7 0.07% 16 0.07% 63 0.08% 237 0.08%
Month 8 0.07% 16 0.07% 68 0.08% 256 0.08%
Month 9 0.07% 17 0.07% 65 0.08% 274 0.08%
Month 10 0.07% 15 0.07% 70 0.08% 292 0.08%
Month 11 0.07% 14 0.07% 64 0.08% 311 0.08%
Month 12 0.07% 14 0.07% 68 0.08% 329 0.08%
182 693 2,637
SLOW GROWTH
Month 1 0.07% 10 0.07% 42 0.07% 81 0.07%
Month 2 0.07% 13 0.07% 45 0.07% 84 0.07%
Month 3 0.07% 16 0.07% 49 0.07% 87 0.07%
Month 4 0.07% 18 0.07% 52 0.07% 91 0.07%
Month 5 0.07% 21 0.07% 55 0.07% 94 0.07%
Month 6 0.07% 23 0.07% 58 0.07% 97 0.07%
Month 7 0.07% 26 0.07% 62 0.07% 100 0.07%
Month 8 0.07% 29 0.07% 65 0.07% 104 0.07%
Month 9 0.07% 31 0.07% 68 0.07% 107 0.07%
Month 10 0.07% 34 0.07% 71 0.07% 110 0.07%
Month 11 0.07% 36 0.07% 74 0.07% 113 0.07%
Month 12 0.07% 39 0.07% 78 0.07% 117 0.07%
296 719 1,185
Web Hosting
Calculated as a fixed dollar ($) amount in Years 1-3 and percentage (%) of Revenue thereafter
Internet
Calculated as a percentage (%) of Revenue
HIGH GROWTH
Month 1 0.04% 6 0.04% 35 0.04% 134 0.04%
Month 2 0.04% 8 0.04% 42 0.04% 155 0.04%
Month 3 0.04% 10 0.04% 49 0.04% 177 0.04%
Month 4 0.04% 12 0.04% 57 0.04% 198 0.04%
Month 5 0.04% 14 0.04% 64 0.04% 219 0.04%
Month 6 0.04% 16 0.04% 71 0.04% 240 0.04%
Month 7 0.04% 18 0.04% 78 0.04% 261 0.04%
Month 8 0.04% 20 0.04% 85 0.04% 283 0.04%
Month 9 0.04% 22 0.04% 92 0.04% 304 0.04%
Month 10 0.04% 24 0.04% 99 0.04% 325 0.04%
Month 11 0.04% 26 0.04% 106 0.04% 346 0.04%
Month 12 0.04% 28 0.04% 113 0.04% 367 0.04%
205 890 3,010
BASE CASE
Month 1 0.04% 5 0.04% 17 0.04% 56 0.04%
Month 2 0.04% 7 0.04% 22 0.04% 64 0.04%
Month 3 0.04% 7 0.04% 25 0.04% 72 0.04%
Month 4 0.04% 8 0.04% 27 0.04% 80 0.04%
Month 5 0.04% 8 0.04% 28 0.04% 88 0.04%
Month 6 0.04% 9 0.04% 29 0.04% 96 0.04%
Month 7 0.04% 8 0.04% 31 0.04% 104 0.04%
Month 8 0.04% 8 0.04% 34 0.04% 112 0.04%
Month 9 0.04% 9 0.04% 33 0.04% 120 0.04%
Month 10 0.04% 7 0.04% 35 0.04% 128 0.04%
Month 11 0.04% 7 0.04% 32 0.04% 136 0.04%
Month 12 0.04% 7 0.04% 34 0.04% 144 0.04%
91 347 1,199
SLOW GROWTH
Month 1 0.04% 5 0.04% 21 0.04% 40 0.04%
Month 2 0.04% 7 0.04% 23 0.04% 42 0.04%
Month 3 0.04% 8 0.04% 24 0.04% 44 0.04%
Month 4 0.04% 9 0.04% 26 0.04% 45 0.04%
Month 5 0.04% 10 0.04% 28 0.04% 47 0.04%
Month 6 0.04% 12 0.04% 29 0.04% 49 0.04%
Month 7 0.04% 13 0.04% 31 0.04% 50 0.04%
Month 8 0.04% 14 0.04% 32 0.04% 52 0.04%
Month 9 0.04% 16 0.04% 34 0.04% 53 0.04%
Month 10 0.04% 17 0.04% 36 0.04% 55 0.04%
Month 11 0.04% 18 0.04% 37 0.04% 57 0.04%
Month 12 0.04% 19 0.04% 39 0.04% 58 0.04%
148 359 592
HIGH GROWTH
Month 1 0.05% 9 0.05% 50 0.05% 192 0.05%
Month 2 0.05% 11 0.05% 61 0.05% 222 0.05%
Month 3 0.05% 14 0.05% 71 0.05% 252 0.05%
Month 4 0.05% 17 0.05% 81 0.05% 283 0.05%
Month 5 0.05% 20 0.05% 91 0.05% 313 0.05%
Month 6 0.05% 23 0.05% 101 0.05% 343 0.05%
Month 7 0.05% 26 0.05% 111 0.05% 373 0.05%
Month 8 0.05% 29 0.05% 121 0.05% 404 0.05%
Month 9 0.05% 32 0.05% 131 0.05% 434 0.05%
Month 10 0.05% 35 0.05% 141 0.05% 464 0.05%
Month 11 0.05% 37 0.05% 151 0.05% 495 0.05%
Month 12 0.05% 40 0.05% 162 0.05% 525 0.05%
293 1,272 4,300
BASE CASE
Month 1 0.05% 8 0.05% 25 0.05% 80 0.05%
Month 2 0.05% 9 0.05% 31 0.05% 91 0.05%
Month 3 0.05% 10 0.05% 35 0.05% 103 0.05%
Month 4 0.05% 12 0.05% 39 0.05% 114 0.05%
Month 5 0.05% 12 0.05% 40 0.05% 126 0.05%
Month 6 0.05% 13 0.05% 41 0.05% 137 0.05%
Month 7 0.05% 12 0.05% 45 0.05% 148 0.05%
Month 8 0.05% 12 0.05% 49 0.05% 160 0.05%
Month 9 0.05% 12 0.05% 47 0.05% 171 0.05%
Month 10 0.05% 11 0.05% 50 0.05% 183 0.05%
Month 11 0.05% 10 0.05% 46 0.05% 194 0.05%
Month 12 0.05% 10 0.05% 49 0.05% 206 0.05%
130 495 1,713
SLOW GROWTH
Month 1 0.05% 7 0.05% 30 0.05% 58 0.05%
Month 2 0.05% 9 0.05% 32 0.05% 60 0.05%
Month 3 0.05% 11 0.05% 35 0.05% 62 0.05%
Month 4 0.05% 13 0.05% 37 0.05% 65 0.05%
Month 5 0.05% 15 0.05% 39 0.05% 67 0.05%
Month 6 0.05% 17 0.05% 42 0.05% 69 0.05%
Month 7 0.05% 19 0.05% 44 0.05% 72 0.05%
Month 8 0.05% 20 0.05% 46 0.05% 74 0.05%
Month 9 0.05% 22 0.05% 49 0.05% 76 0.05%
Month 10 0.05% 24 0.05% 51 0.05% 79 0.05%
Month 11 0.05% 26 0.05% 53 0.05% 81 0.05%
Month 12 0.05% 28 0.05% 56 0.05% 83 0.05%
211 513 846
Electric
Calculated as a percentage (%) of Revenue
HIGH GROWTH
Month 1 0.75% 128 0.75% 757 0.75% 2,877 0.75%
Month 2 0.75% 171 0.75% 908 0.75% 3,331 0.75%
Month 3 0.75% 215 0.75% 1,060 0.75% 3,785 0.75%
Month 4 0.75% 258 0.75% 1,211 0.75% 4,239 0.75%
Month 5 0.75% 302 0.75% 1,363 0.75% 4,694 0.75%
Month 6 0.75% 345 0.75% 1,514 0.75% 5,148 0.75%
Month 7 0.75% 388 0.75% 1,665 0.75% 5,602 0.75%
Month 8 0.75% 432 0.75% 1,817 0.75% 6,056 0.75%
Month 9 0.75% 475 0.75% 1,968 0.75% 6,510 0.75%
Month 10 0.75% 519 0.75% 2,120 0.75% 6,965 0.75%
Month 11 0.75% 562 0.75% 2,271 0.75% 7,419 0.75%
Month 12 0.75% 606 0.75% 2,423 0.75% 7,873 0.75%
4,401 19,077 64,499
BASE CASE
Month 1 0.75% 113 0.75% 371 0.75% 1,199 0.75%
Month 2 0.75% 141 0.75% 465 0.75% 1,370 0.75%
Month 3 0.75% 152 0.75% 531 0.75% 1,541 0.75%
Month 4 0.75% 174 0.75% 578 0.75% 1,713 0.75%
Month 5 0.75% 178 0.75% 606 0.75% 1,884 0.75%
Month 6 0.75% 197 0.75% 615 0.75% 2,055 0.75%
Month 7 0.75% 176 0.75% 671 0.75% 2,226 0.75%
Month 8 0.75% 174 0.75% 728 0.75% 2,398 0.75%
Month 9 0.75% 186 0.75% 699 0.75% 2,569 0.75%
Month 10 0.75% 159 0.75% 746 0.75% 2,740 0.75%
Month 11 0.75% 146 0.75% 690 0.75% 2,911 0.75%
Month 12 0.75% 152 0.75% 728 0.75% 3,083 0.75%
1,948 7,427 25,688
SLOW GROWTH
Month 1 0.75% 112 0.75% 451 0.75% 867 0.75%
Month 2 0.75% 140 0.75% 486 0.75% 902 0.75%
Month 3 0.75% 167 0.75% 520 0.75% 937 0.75%
Month 4 0.75% 195 0.75% 555 0.75% 971 0.75%
Month 5 0.75% 223 0.75% 590 0.75% 1,006 0.75%
Month 6 0.75% 250 0.75% 624 0.75% 1,041 0.75%
Month 7 0.75% 278 0.75% 659 0.75% 1,075 0.75%
Month 8 0.75% 306 0.75% 694 0.75% 1,110 0.75%
Month 9 0.75% 333 0.75% 728 0.75% 1,145 0.75%
Month 10 0.75% 361 0.75% 763 0.75% 1,179 0.75%
Month 11 0.75% 389 0.75% 798 0.75% 1,214 0.75%
Month 12 0.75% 416 0.75% 833 0.75% 1,249 0.75%
3,170 7,701 12,696
Gas Utility
Calculated as a percentage (%) of Revenue
HIGH GROWTH
Month 1 0.70% 119 0.70% 707 0.70% 2,685 0.70%
Month 2 0.70% 160 0.70% 848 0.70% 3,109 0.70%
Month 3 0.70% 200 0.70% 989 0.70% 3,533 0.70%
Month 4 0.70% 241 0.70% 1,131 0.70% 3,957 0.70%
Month 5 0.70% 281 0.70% 1,272 0.70% 4,381 0.70%
Month 6 0.70% 322 0.70% 1,413 0.70% 4,805 0.70%
Month 7 0.70% 363 0.70% 1,554 0.70% 5,229 0.70%
Month 8 0.70% 403 0.70% 1,696 0.70% 5,653 0.70%
Month 9 0.70% 444 0.70% 1,837 0.70% 6,076 0.70%
Month 10 0.70% 484 0.70% 1,978 0.70% 6,500 0.70%
Month 11 0.70% 525 0.70% 2,120 0.70% 6,924 0.70%
Month 12 0.70% 565 0.70% 2,261 0.70% 7,348 0.70%
4,107 17,805 60,199
BASE CASE
Month 1 0.70% 105 0.70% 347 0.70% 1,119 0.70%
Month 2 0.70% 131 0.70% 434 0.70% 1,279 0.70%
Month 3 0.70% 142 0.70% 495 0.70% 1,439 0.70%
Month 4 0.70% 163 0.70% 539 0.70% 1,598 0.70%
Month 5 0.70% 166 0.70% 565 0.70% 1,758 0.70%
Month 6 0.70% 184 0.70% 574 0.70% 1,918 0.70%
Month 7 0.70% 165 0.70% 627 0.70% 2,078 0.70%
Month 8 0.70% 163 0.70% 679 0.70% 2,238 0.70%
Month 9 0.70% 173 0.70% 653 0.70% 2,398 0.70%
Month 10 0.70% 149 0.70% 697 0.70% 2,557 0.70%
Month 11 0.70% 137 0.70% 644 0.70% 2,717 0.70%
Month 12 0.70% 142 0.70% 679 0.70% 2,877 0.70%
1,818 6,932 23,975
SLOW GROWTH
Month 1 0.70% 105 0.70% 421 0.70% 809 0.70%
Month 2 0.70% 130 0.70% 453 0.70% 842 0.70%
Month 3 0.70% 156 0.70% 486 0.70% 874 0.70%
Month 4 0.70% 182 0.70% 518 0.70% 907 0.70%
Month 5 0.70% 208 0.70% 550 0.70% 939 0.70%
Month 6 0.70% 234 0.70% 583 0.70% 971 0.70%
Month 7 0.70% 259 0.70% 615 0.70% 1,004 0.70%
Month 8 0.70% 285 0.70% 648 0.70% 1,036 0.70%
Month 9 0.70% 311 0.70% 680 0.70% 1,068 0.70%
Month 10 0.70% 337 0.70% 712 0.70% 1,101 0.70%
Month 11 0.70% 363 0.70% 745 0.70% 1,133 0.70%
Month 12 0.70% 389 0.70% 777 0.70% 1,166 0.70%
2,958 7,187 11,849
Water/Sewer
Calculated as a percentage (%) of Revenue
HIGH GROWTH
Month 1 0.20% 34 0.20% 202 0.20% 767 0.20%
Month 2 0.20% 46 0.20% 242 0.20% 888 0.20%
Month 3 0.20% 57 0.20% 283 0.20% 1,009 0.20%
Month 4 0.20% 69 0.20% 323 0.20% 1,131 0.20%
Month 5 0.20% 80 0.20% 363 0.20% 1,252 0.20%
Month 6 0.20% 92 0.20% 404 0.20% 1,373 0.20%
Month 7 0.20% 104 0.20% 444 0.20% 1,494 0.20%
Month 8 0.20% 115 0.20% 485 0.20% 1,615 0.20%
Month 9 0.20% 127 0.20% 525 0.20% 1,736 0.20%
Month 10 0.20% 138 0.20% 565 0.20% 1,857 0.20%
Month 11 0.20% 150 0.20% 606 0.20% 1,978 0.20%
Month 12 0.20% 162 0.20% 646 0.20% 2,100 0.20%
1,174 5,087 17,200
BASE CASE
Month 1 0.20% 30 0.20% 99 0.20% 320 0.20%
Month 2 0.20% 38 0.20% 124 0.20% 365 0.20%
Month 3 0.20% 41 0.20% 142 0.20% 411 0.20%
Month 4 0.20% 47 0.20% 154 0.20% 457 0.20%
Month 5 0.20% 48 0.20% 162 0.20% 502 0.20%
Month 6 0.20% 53 0.20% 164 0.20% 548 0.20%
Month 7 0.20% 47 0.20% 179 0.20% 594 0.20%
Month 8 0.20% 47 0.20% 194 0.20% 639 0.20%
Month 9 0.20% 50 0.20% 187 0.20% 685 0.20%
Month 10 0.20% 43 0.20% 199 0.20% 731 0.20%
Month 11 0.20% 39 0.20% 184 0.20% 776 0.20%
Month 12 0.20% 41 0.20% 194 0.20% 822 0.20%
520 1,981 6,850
SLOW GROWTH
Month 1 0.20% 30 0.20% 120 0.20% 231 0.20%
Month 2 0.20% 37 0.20% 130 0.20% 241 0.20%
Month 3 0.20% 45 0.20% 139 0.20% 250 0.20%
Month 4 0.20% 52 0.20% 148 0.20% 259 0.20%
Month 5 0.20% 59 0.20% 157 0.20% 268 0.20%
Month 6 0.20% 67 0.20% 167 0.20% 278 0.20%
Month 7 0.20% 74 0.20% 176 0.20% 287 0.20%
Month 8 0.20% 82 0.20% 185 0.20% 296 0.20%
Month 9 0.20% 89 0.20% 194 0.20% 305 0.20%
Month 10 0.20% 96 0.20% 204 0.20% 315 0.20%
Month 11 0.20% 104 0.20% 213 0.20% 324 0.20%
Month 12 0.20% 111 0.20% 222 0.20% 333 0.20%
845 2,054 3,386
Waste Removal/Scavenger
Calculated as a percentage (%) of Revenue
HIGH GROWTH
Month 1 0.14% 24 0.14% 140 0.14% 531 0.14%
Month 2 0.14% 32 0.14% 168 0.14% 615 0.14%
Month 3 0.14% 40 0.14% 196 0.14% 699 0.14%
Month 4 0.14% 48 0.14% 224 0.14% 783 0.14%
Month 5 0.14% 56 0.14% 252 0.14% 867 0.14%
Month 6 0.14% 64 0.14% 280 0.14% 951 0.14%
Month 7 0.14% 72 0.14% 308 0.14% 1,035 0.14%
Month 8 0.14% 80 0.14% 336 0.14% 1,118 0.14%
Month 9 0.14% 88 0.14% 363 0.14% 1,202 0.14%
Month 10 0.14% 96 0.14% 391 0.14% 1,286 0.14%
Month 11 0.14% 104 0.14% 419 0.14% 1,370 0.14%
Month 12 0.14% 112 0.14% 447 0.14% 1,454 0.14%
813 3,523 11,911
BASE CASE
Month 1 0.14% 21 0.14% 69 0.14% 221 0.14%
Month 2 0.14% 26 0.14% 86 0.14% 253 0.14%
Month 3 0.14% 28 0.14% 98 0.14% 285 0.14%
Month 4 0.14% 32 0.14% 107 0.14% 316 0.14%
Month 5 0.14% 33 0.14% 112 0.14% 348 0.14%
Month 6 0.14% 36 0.14% 114 0.14% 379 0.14%
Month 7 0.14% 33 0.14% 124 0.14% 411 0.14%
Month 8 0.14% 32 0.14% 134 0.14% 443 0.14%
Month 9 0.14% 34 0.14% 129 0.14% 474 0.14%
Month 10 0.14% 29 0.14% 138 0.14% 506 0.14%
Month 11 0.14% 27 0.14% 127 0.14% 538 0.14%
Month 12 0.14% 28 0.14% 134 0.14% 569 0.14%
360 1,371 4,744
SLOW GROWTH
Month 1 0.14% 21 0.14% 83 0.14% 160 0.14%
Month 2 0.14% 26 0.14% 90 0.14% 167 0.14%
Month 3 0.14% 31 0.14% 96 0.14% 173 0.14%
Month 4 0.14% 36 0.14% 102 0.14% 179 0.14%
Month 5 0.14% 41 0.14% 109 0.14% 186 0.14%
Month 6 0.14% 46 0.14% 115 0.14% 192 0.14%
Month 7 0.14% 51 0.14% 122 0.14% 199 0.14%
Month 8 0.14% 56 0.14% 128 0.14% 205 0.14%
Month 9 0.14% 62 0.14% 135 0.14% 211 0.14%
Month 10 0.14% 67 0.14% 141 0.14% 218 0.14%
Month 11 0.14% 72 0.14% 147 0.14% 224 0.14%
Month 12 0.14% 77 0.14% 154 0.14% 231 0.14%
585 1,422 2,344
HIGH GROWTH
Month 1 0.50% 85 0.54% 545 0.54% 2,071 0.54%
Month 2 0.50% 114 0.54% 654 0.54% 2,398 0.54%
Month 3 0.50% 143 0.54% 763 0.54% 2,725 0.54%
Month 4 0.50% 172 0.54% 872 0.54% 3,052 0.54%
Month 5 0.50% 201 0.54% 981 0.54% 3,379 0.54%
Month 6 0.50% 230 0.54% 1,090 0.54% 3,706 0.54%
Month 7 0.50% 259 0.54% 1,199 0.54% 4,033 0.54%
Month 8 0.50% 288 0.54% 1,308 0.54% 4,361 0.54%
Month 9 0.50% 317 0.54% 1,417 0.54% 4,688 0.54%
Month 10 0.50% 346 0.54% 1,526 0.54% 5,015 0.54%
Month 11 0.50% 375 0.54% 1,635 0.54% 5,342 0.54%
Month 12 0.50% 404 0.54% 1,744 0.54% 5,669 0.54%
2,934 13,736 46,439
BASE CASE
Month 1 0.50% 75 0.54% 267 0.54% 863 0.54%
Month 2 0.50% 94 0.54% 335 0.54% 986 0.54%
Month 3 0.50% 101 0.54% 382 0.54% 1,110 0.54%
Month 4 0.50% 116 0.54% 416 0.54% 1,233 0.54%
Month 5 0.50% 119 0.54% 436 0.54% 1,356 0.54%
Month 6 0.50% 131 0.54% 443 0.54% 1,480 0.54%
Month 7 0.50% 118 0.54% 483 0.54% 1,603 0.54%
Month 8 0.50% 116 0.54% 524 0.54% 1,726 0.54%
Month 9 0.50% 124 0.54% 504 0.54% 1,850 0.54%
Month 10 0.50% 106 0.54% 537 0.54% 1,973 0.54%
Month 11 0.50% 98 0.54% 497 0.54% 2,096 0.54%
Month 12 0.50% 101 0.54% 524 0.54% 2,219 0.54%
1,299 5,347 18,495
SLOW GROWTH
Month 1 0.50% 75 0.54% 325 0.54% 624 0.54%
Month 2 0.50% 93 0.54% 350 0.54% 649 0.54%
Month 3 0.50% 112 0.54% 375 0.54% 674 0.54%
Month 4 0.50% 130 0.54% 400 0.54% 699 0.54%
Month 5 0.50% 148 0.54% 425 0.54% 724 0.54%
Month 6 0.50% 167 0.54% 450 0.54% 749 0.54%
Month 7 0.50% 185 0.54% 475 0.54% 774 0.54%
Month 8 0.50% 204 0.54% 500 0.54% 799 0.54%
Month 9 0.50% 222 0.54% 524 0.54% 824 0.54%
Month 10 0.50% 241 0.54% 549 0.54% 849 0.54%
Month 11 0.50% 259 0.54% 574 0.54% 874 0.54%
Month 12 0.50% 278 0.54% 599 0.54% 899 0.54%
2,113 5,544 9,141
Bank Fees
Calculated as a percentage (%) of Revenue
HIGH GROWTH
Month 1 0.07% 12 0.07% 71 0.07% 268 0.07%
Month 2 0.07% 16 0.07% 85 0.07% 311 0.07%
Month 3 0.07% 20 0.07% 99 0.07% 353 0.07%
Month 4 0.07% 24 0.07% 113 0.07% 396 0.07%
Month 5 0.07% 28 0.07% 127 0.07% 438 0.07%
Month 6 0.07% 32 0.07% 141 0.07% 480 0.07%
Month 7 0.07% 36 0.07% 155 0.07% 523 0.07%
Month 8 0.07% 40 0.07% 170 0.07% 565 0.07%
Month 9 0.07% 44 0.07% 184 0.07% 608 0.07%
Month 10 0.07% 48 0.07% 198 0.07% 650 0.07%
Month 11 0.07% 52 0.07% 212 0.07% 692 0.07%
Month 12 0.07% 57 0.07% 226 0.07% 735 0.07%
411 1,781 6,020
BASE CASE
Month 1 0.07% 11 0.07% 35 0.07% 112 0.07%
Month 2 0.07% 13 0.07% 43 0.07% 128 0.07%
Month 3 0.07% 14 0.07% 50 0.07% 144 0.07%
Month 4 0.07% 16 0.07% 54 0.07% 160 0.07%
Month 5 0.07% 17 0.07% 57 0.07% 176 0.07%
Month 6 0.07% 18 0.07% 57 0.07% 192 0.07%
Month 7 0.07% 16 0.07% 63 0.07% 208 0.07%
Month 8 0.07% 16 0.07% 68 0.07% 224 0.07%
Month 9 0.07% 17 0.07% 65 0.07% 240 0.07%
Month 10 0.07% 15 0.07% 70 0.07% 256 0.07%
Month 11 0.07% 14 0.07% 64 0.07% 272 0.07%
Month 12 0.07% 14 0.07% 68 0.07% 288 0.07%
182 693 2,398
SLOW GROWTH
Month 1 0.07% 10 0.07% 42 0.07% 81 0.07%
Month 2 0.07% 13 0.07% 45 0.07% 84 0.07%
Month 3 0.07% 16 0.07% 49 0.07% 87 0.07%
Month 4 0.07% 18 0.07% 52 0.07% 91 0.07%
Month 5 0.07% 21 0.07% 55 0.07% 94 0.07%
Month 6 0.07% 23 0.07% 58 0.07% 97 0.07%
Month 7 0.07% 26 0.07% 62 0.07% 100 0.07%
Month 8 0.07% 29 0.07% 65 0.07% 104 0.07%
Month 9 0.07% 31 0.07% 68 0.07% 107 0.07%
Month 10 0.07% 34 0.07% 71 0.07% 110 0.07%
Month 11 0.07% 36 0.07% 74 0.07% 113 0.07%
Month 12 0.07% 39 0.07% 78 0.07% 117 0.07%
296 719 1,185
FIXED EXPENSES
G&A
Financial
Calculated using a growth rate from one year to the next
Office Supplies
Calculated as a fixed dollar ($) amount
Start-up Costs
Calculated as a fixed dollar ($) amount
laries
7,603,473 16,444,591
48,472 7.65% 104,834 H 1 1,285 1,079 964 964
48,472 7.65% 104,834 H 2 656 656 656 656
48,472 7.65% 104,834 H 3 22,053 22,053 22,053 22,053
48,472 7.65% 104,834 H 4 48,472 48,472 48,472 48,472
48,472 7.65% 104,834 H 5 104,834 104,834 104,834 104,834
48,472 7.65% 104,834
48,472 7.65% 104,834
48,472 7.65% 104,834
48,472 7.65% 104,834
48,472 7.65% 104,834
48,472 7.65% 104,834
48,472 7.65% 104,834
581,666 1,258,011
3,871,757 6,635,127
24,682 7.65% 42,299 B 1 1,285 1,079 964 964
24,682 7.65% 42,299 B 2 656 656 656 656
24,682 7.65% 42,299 B 3 13,937 13,937 13,937 13,937
24,682 7.65% 42,299 B 4 24,682 24,682 24,682 24,682
24,682 7.65% 42,299 B 5 42,299 42,299 42,299 42,299
24,682 7.65% 42,299
24,682 7.65% 42,299
24,682 7.65% 42,299
24,682 7.65% 42,299
24,682 7.65% 42,299
24,682 7.65% 42,299
24,682 7.65% 42,299
296,189 507,587
1,919,171 2,318,972
12,235 7.65% 14,783 S 1 1,285 1,079 964 964
12,235 7.65% 14,783 S 2 656 656 656 656
12,235 7.65% 14,783 S 3 10,893 10,893 10,893 10,893
12,235 7.65% 14,783 S 4 12,235 12,235 12,235 12,235
12,235 7.65% 14,783 S 5 14,783 14,783 14,783 14,783
12,235 7.65% 14,783
12,235 7.65% 14,783
12,235 7.65% 14,783
12,235 7.65% 14,783
12,235 7.65% 14,783
12,235 7.65% 14,783
12,235 7.65% 14,783
146,817 177,401
92 0.02% 223 B 1 3 4 4 5
103 0.02% 240 B 2 10 12 14 15
113 0.02% 257 B 3 32 37 41 46
123 0.02% 274 B 4 92 103 113 123
134 0.02% 291 B 5 223 240 257 274
144 0.02% 308
154 0.02% 325
164 0.02% 343
175 0.02% 360
185 0.02% 377
195 0.02% 394
206 0.02% 411
1,788 3,802
35 0.02% 52 S 1 3 4 4 5
36 0.02% 54 S 2 12 13 14 15
37 0.02% 56 S 3 23 24 25 26
39 0.02% 58 S 4 35 36 37 39
40 0.02% 60 S 5 52 54 56 58
42 0.02% 62
43 0.02% 65
44 0.02% 67
46 0.02% 69
47 0.02% 71
49 0.02% 73
50 0.02% 75
508 762
%) of Revenue thereafter
ware
e
61 0.04% 91 S 1 5 7 8 9
63 0.04% 95 S 2 21 23 24 26
66 0.04% 98 S 3 40 42 44 45
68 0.04% 102 S 4 61 63 66 68
70 0.04% 106 S 5 91 95 98 102
73 0.04% 109
75 0.04% 113
78 0.04% 117
80 0.04% 120
83 0.04% 124
85 0.04% 128
87 0.04% 131
889 1,333
87 0.05% 130 S 1 7 9 11 13
90 0.05% 135 S 2 30 32 35 37
94 0.05% 141 S 3 58 60 62 65
97 0.05% 146 S 4 87 90 94 97
101 0.05% 151 S 5 130 135 141 146
104 0.05% 156
108 0.05% 161
111 0.05% 167
114 0.05% 172
118 0.05% 177
121 0.05% 182
125 0.05% 187
1,270 1,905
e
8,267 0.70% 20,285 H 1 119 160 200 241
9,185 0.70% 22,199 H 2 707 848 989 1,131
10,104 0.70% 24,113 H 3 2,685 3,109 3,533 3,957
11,023 0.70% 26,027 H 4 8,267 9,185 10,104 11,023
11,941 0.70% 27,940 H 5 20,285 22,199 24,113 26,027
12,860 0.70% 29,854
13,778 0.70% 31,768
14,697 0.70% 33,682
15,616 0.70% 35,595
16,534 0.70% 37,509
17,453 0.70% 39,423
18,372 0.70% 41,337
159,830 369,732
%) of Revenue thereafter
the next
3,500
292 292 292 H 1 1,000 1,000 1,000 1,000
292 292 292 H 2 1,667 1,667 1,667 1,667
292 292 292 H 3 292 292 292 292
292 292 292 H 4 292 292 292 292
292 292 292 H 5 292 292 292 292
292 292 292
292 292 292
292 292 292
292 292 292
292 292 292
292 292 292
292 292 292
3,500 3,500
3,500
292 292 292 B 1 1,000 1,000 1,000 1,000
292 292 292 B 2 1,667 1,667 1,667 1,667
292 292 292 B 3 292 292 292 292
292 292 292 B 4 292 292 292 292
292 292 292 B 5 292 292 292 292
292 292 292
292 292 292
292 292 292
292 292 292
292 292 292
292 292 292
292 292 292
3,500 3,500
3,500
292 292 292 S 1 1,000 1,000 1,000 1,000
292 292 292 S 2 1,667 1,667 1,667 1,667
292 292 292 S 3 292 292 292 292
292 292 292 S 4 292 292 292 292
292 292 292 S 5 292 292 292 292
292 292 292
292 292 292
292 292 292
292 292 292
292 292 292
292 292 292
292 292 292
3,500 3,500
2,784
232 232 232 H 1 232 232 232 232
232 232 232 H 2 232 232 232 232
232 232 232 H 3 232 232 232 232
232 232 232 H 4 232 232 232 232
232 232 232 H 5 232 232 232 232
232 232 232
232 232 232
232 232 232 Total High Growt
232 232 232 1 2,232 2,232 2,232 2,232
232 232 232 2 2,934 2,934 2,934 2,934
232 232 232 3 1,595 1,595 1,595 1,595
232 232 232 4 1,632 1,632 1,632 1,632
2,784 2,784 5 1,671 1,671 1,671 1,671
2,784
232 232 232 B 1 232 232 232 232
232 232 232 B 2 232 232 232 232
232 232 232 B 3 232 232 232 232
232 232 232 B 4 232 232 232 232
232 232 232 B 5 232 232 232 232
232 232 232
232 232 232
232 232 232 Total Base Case
232 232 232 1 2,232 2,232 2,232 2,232
232 232 232 2 2,934 2,934 2,934 2,934
232 232 232 3 1,595 1,595 1,595 1,595
232 232 232 4 1,632 1,632 1,632 1,632
2,784 2,784 5 1,671 1,671 1,671 1,671
2,784
232 232 232 S 1 232 232 232 232
232 232 232 S 2 232 232 232 232
232 232 232 S 3 232 232 232 232
232 232 232 S 4 232 232 232 232
232 232 232 S 5 232 232 232 232
232 232 232
232 232 232
232 232 232 Total Slow Growt
232 232 232 1 2,232 2,232 2,232 2,232
232 232 232 2 2,934 2,934 2,934 2,934
232 232 232 3 1,595 1,595 1,595 1,595
232 232 232 4 1,632 1,632 1,632 1,632
2,784 2,784 5 1,671 1,671 1,671 1,671
the next
71 79 71 70 74 64 59 61
242 246 269 291 280 299 276 291
754 822 891 959 1,028 1,096 1,165 1,233
2,004 2,158 2,312 2,466 2,620 2,774 2,928 3,083
4,367 4,624 4,881 5,138 5,394 5,651 5,908 6,165
89 100 111 122 133 144 155 167
236 250 264 278 291 305 319 333
402 416 430 444 458 472 486 500
604 624 645 666 687 708 728 749
906 937 968 999 1,031 1,062 1,093 1,124
8 9 10 12 13 14 15 16
36 40 44 48 52 57 61 65
125 137 149 162 174 186 198 210
341 367 394 420 446 472 499 525
798 853 908 962 1,017 1,072 1,126 1,181
5 5 5 5 5 4 4 4
16 16 18 19 19 20 18 19
50 55 59 64 69 73 78 82
134 144 154 164 175 185 195 206
291 308 325 343 360 377 394 411
6 7 7 8 9 10 10 11
16 17 18 19 19 20 21 22
27 28 29 30 31 31 32 33
40 42 43 44 46 47 49 50
60 62 65 67 69 71 73 75
28 32 36 40 44 48 52 57
127 141 155 170 184 198 212 226
438 549 598 646 694 743 791 840
1,365 1,470 1,575 1,680 1,785 1,890 1,995 2,100
2,794 2,985 3,177 3,368 3,560 3,751 3,942 4,134
17 18 16 16 17 15 14 14
57 57 63 68 65 70 64 68
176 219 237 256 274 292 311 329
534 575 617 658 699 740 781 822
1,019 1,079 1,139 1,199 1,259 1,319 1,379 1,439
21 23 26 29 31 34 36 39
55 58 62 65 68 71 74 78
94 97 100 104 107 110 113 117
141 146 151 155 160 165 170 175
211 219 226 233 240 248 255 262
14 16 18 20 22 24 26 28
64 71 78 85 92 99 106 113
219 240 261 283 304 325 346 367
597 643 689 735 781 827 873 919
1,397 1,493 1,588 1,684 1,780 1,875 1,971 2,067
8 9 8 8 9 7 7 7
28 29 31 34 33 35 32 34
88 96 104 112 120 128 136 144
234 252 270 288 306 324 342 360
509 539 569 599 629 659 689 719
10 12 13 14 16 17 18 19
28 29 31 32 34 36 37 39
47 49 50 52 53 55 57 58
70 73 75 78 80 83 85 87
106 109 113 117 120 124 128 131
20 23 26 29 32 35 37 40
91 101 111 121 131 141 151 162
313 343 373 404 434 464 495 525
853 919 984 1,050 1,115 1,181 1,247 1,312
1,996 2,132 2,269 2,406 2,543 2,679 2,816 2,953
12 13 12 12 12 11 10 10
40 41 45 49 47 50 46 49
126 137 148 160 171 183 194 206
334 360 385 411 437 462 488 514
728 771 813 856 899 942 985 1,028
15 17 19 20 22 24 26 28
39 42 44 46 49 51 53 56
67 69 72 74 76 79 81 83
101 104 108 111 114 118 121 125
151 156 161 167 172 177 182 187
48 53 47 47 50 43 39 41
162 164 179 194 187 199 184 194
502 548 594 639 685 731 776 822
1,336 1,439 1,541 1,644 1,747 1,850 1,952 2,055
2,911 3,083 3,254 3,425 3,596 3,768 3,939 4,110
59 67 74 82 89 96 104 111
157 167 176 185 194 204 213 222
268 278 287 296 305 315 324 333
402 416 430 444 458 472 486 500
604 625 645 666 687 708 729 750
56 64 72 80 88 96 104 112
252 280 308 336 363 391 419 447
867 951 1,035 1,118 1,202 1,286 1,370 1,454
2,363 2,544 2,726 2,908 3,090 3,271 3,453 3,635
5,528 5,907 6,286 6,664 7,043 7,421 7,800 8,179
33 36 33 32 34 29 27 28
112 114 124 134 129 138 127 134
348 379 411 443 474 506 538 569
925 996 1,067 1,138 1,210 1,281 1,352 1,423
2,016 2,135 2,253 2,372 2,490 2,609 2,728 2,846
41 46 51 56 62 67 72 77
109 115 122 128 135 141 147 154
186 192 199 205 211 218 224 231
279 288 298 307 317 327 336 346
418 432 447 461 476 490 505 519
201 230 259 288 317 346 375 404
981 1,090 1,199 1,308 1,417 1,526 1,635 1,744
3,379 3,706 4,033 4,361 4,688 5,015 5,342 5,669
9,212 9,920 10,629 11,338 12,046 12,755 13,464 14,172
21,554 23,030 24,507 25,983 27,459 28,936 30,412 31,888
17 18 16 16 17 15 14 14
57 57 63 68 65 70 64 68
176 192 208 224 240 256 272 288
468 503 539 575 611 647 683 719
1,019 1,079 1,139 1,199 1,259 1,319 1,379 1,439
21 23 26 29 31 34 36 39
55 58 62 65 68 71 74 78
94 97 100 104 107 110 113 117
141 146 151 155 160 165 170 175
211 219 226 233 240 248 255 262
1,596,127 1,658,276
Principal 77,963
Purchase Date 1/7/2011
First Fiscal Year Charged 1
Stated Rate 6.00%
Monthly Rate 0.50%
Term (in months) 36
Yearly Payment 2,371.77