ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Net cash from one acre in the Railyards
2
Cumulative cash in minus cash out, plus the costs of extra driving; nominal dollars, no interest. Edit blue cells on the Inputs sheet.
3
4
Scenario
Year-30 net cash
5
EIFD-financed garage($64,169,735)
6
Dirt lot-
7
Public housing A (no parking, 25% affordable)$6,043,165
8
Public housing B (no parking, 100% affordable)($34,880,564)
9
Private mixed-use (1 stall/unit)$21,391,172
10
11
12
Cumulative net cash by year (chart data)
13
YearEIFD-financed garageDirt lotPublic housing A (no parking, 25% affordable)Public housing B (no parking, 100% affordable)Private mixed-use (1 stall/unit)
14
0($6,800,000)----
15
1($8,781,656)-$511,693($664,787)$538,000
16
2($10,759,762)-$1,015,404($1,349,321)$1,086,140
17
3($12,734,211)-$1,510,031($2,054,821)$1,644,604
18
4($14,704,893)-$1,994,428($2,782,552)$2,213,580
19
5($16,671,696)-$2,467,411($3,533,820)$2,793,258
20
6($18,634,503)-$2,927,746($4,309,977)$3,383,831
21
7($20,593,194)-$3,374,157($5,112,422)$3,985,497
22
8($22,547,645)-$3,805,320($5,942,605)$4,598,457
23
9($24,497,731)-$4,219,861($6,802,024)$5,222,912
24
10($26,443,319)-$4,616,357($7,692,227)$5,859,072
25
11($28,384,274)-$4,993,332($8,614,818)$6,507,146
26
12($30,320,458)-$5,349,256($9,571,455)$7,167,348
27
13($32,251,728)-$5,682,545($10,563,853)$7,839,896
28
14($34,177,936)-$5,991,559($11,593,784)$8,525,011
29
15($36,098,930)-$6,274,595($12,663,081)$9,222,917
30
16($38,014,554)-$6,529,893($13,773,639)$9,933,845
31
17($39,924,647)-$6,755,630($14,927,418)$10,658,024
32
18($41,829,042)-$6,949,916($16,126,443)$11,395,692
33
19($43,727,569)-$7,110,796($17,372,806)$12,147,089
34
20($45,620,052)-$7,236,247($18,668,671)$12,912,459
35
21($47,506,310)-$7,324,174($20,016,273)$13,692,048
36
22($49,386,155)-$7,372,408($21,417,923)$14,486,110
37
23($51,259,396)-$7,378,707($22,876,008)$15,294,899
38
24($53,125,834)-$7,340,748($24,392,993)$16,118,676
39
25($54,985,265)-$7,256,131($25,971,428)$16,957,705
40
26($56,837,479)-$7,122,371($27,613,944)$17,812,255
41
27($58,682,259)-$6,936,897($29,323,261)$18,682,597
42
28($60,519,383)-$6,697,053($31,102,186)$19,569,009
43
29($62,348,620)-$6,400,090($32,953,622)$20,471,772
44
30($64,169,735)-$6,043,165($34,880,564)$21,391,172
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100