Justification & Pro-forma — City Council/Public Finance and Economic Development Authority/Parking Authority, May 2, 2022

ATTACHMENT 6

Page 1 ends

PPreparedd For: Visionary Home Builders of CA
Preparedd By: California Housing Partnership Corporation Version: 1.4 Feasibility AHSC IIG
Revised: 3/2/2022
Filename:

TABLE OF CONTENTS
Sources of Funds…………………………………………..…… 1 Cash Flow (Residential)…………………………… … 11a Uses of Funds…………………………………………..……… … 2 Cash Flow (Commercial) …………………………… 11b Developer Fee Calculation…………………………………… …3 Outstanding Debt & Reserves (Book)…………… … 12a Unit Mix & Rental Income……………………………………… 4 Outstanding Debt & Reserves (Tax)……………… …12b Tax Credit Calculation………………………………………….. 5 Net Cash Flow Fee Accruals……………………… …12c Base Year Income & Expense………………………………… …6 Schedule of Existing Debt………………………… …12d Mortgage Calculation & Bond Ratios………………………… …7 Schedule of Deductions…………………………… 13 Lease-up/Placed-in-Service Schedule……………………… … 8 Analysis of Taxable Income……………………… … 14 Net Syndication Proceeds…………………………………… … 9 Capital Account & Exit Tax Liability……………… …15 TCAC Calculations…………………………………………..… … 10a Investment Summary……………………………… …16 TCAC Transfer Event Calculation…………………………… … 10b Net Quarterly Benefits …………………………… … 17

SOURCES OF FUNDS - PERMANENT
%'-&,
,',$
!&,
*
+,
'+,
'!

!&,
*
+,
*,

%'*,
1D '%%
&,+
*<A/9&3?:/;3;A30A

%/

&3?+;7A

&&$

&3?+;7A

>IND;):G8:9

&3?+;7A

88GJ:9!:;:GG:9&CI:G:HI
>I ND;):G8

6E>I6A DCIG>7JI>DCH *<A/9"&1/=7A/97;19B23@?393/@3<40<;21<99/A3?/94B;2322B? 7;51<;@A?B1A7<; $:C:G6A,6GIC:G!:K:ADE:G#:: )F;2<@A@

$, 6E>I6A
/EDCHDG $3A
>B7AF4<?*

(>B>I:9,6GIC:GH

32" *

)A/A3" *

,',$+'-*
+

)B?=9B@
)6<?A4/99

&CK:HIDG
(
*%&
&,$'&!&,
*
+,*,
,*&
,*&
!& .
+,'*
)-!,1+,# ',
*++-%(,!'&+
6H:.6I:
JH=>DC (&%0 "FJ>I
N#:9:G6A
/I6

JGG:CI
#.
)&, %>HIDG>806M G:9>I
#.)DCI= +8I

$*)
/:GK>8>C< &CK:HIB:CI06M G:9>I /DA #. JH=>DC
&HHJ:G
@@B3?:7;
F +G4FAF3>$(
CG;FK

,AF3>-
/
*

0GJHI::
=3?/;;B:
.6I>C<
=3?/;;B:
:GI>;>86I:9 G:9>I/6A :
.:B6G@:I>C<
=3?/;;B: ,AF3>!@H7EFAD
CG;FK

.:76I:
C6ANHI
=3?/;;B:
,AF3>

SOURCES OF FUNDS - CONSTRUCTION
%'-&,
!&,
*
+,
*,

,
*%
%AE
'%%
&,+
DCHIGJ8I>DC(D6C

&&$

>IND;):G8:9

88GJ:9!:;:GG:9&CI:G:HI
>I ND;):G8

DHIH!:;:GG:91CI>A DCK:GH>DC
)33=/53 ?756A1<9B:;
6E>I6A DCIG>7JI>DCH
48-7;216758(7-21 *5-2)
$, 6E>I6A
/EDCHDG "&
>B7AF4<?0<;21<99/A3?/9

(>B>I:9,6GIC:GH

."# #27'/48-7;85-1+2167

,',$+'-*
+
)F;271/A7<;<@A@

)B?=9B@
)6<?A4/99
$3A
>B7AF4<?*

/DJG8:H(:HH!:;:GG:90D DCK:GH>DC

'&+,*-,!'&$'&!&,
*
+,*,
'&+,*-,!'&$'&.$-,!'& ,0
0 %(,'&

,
&C9:M0NE: /5 .:HIG>8I:9*+&
0:HIH::,6<: *

JGG:CI&C9:M +
. &HHJ:G&C9J8:B:CI 0!
/EG:69 #)2E:G*+&

!(

AAD86I>DC 0!
6H:&CI:G:HI.6I:
CDI>C8AJ9>C<8JH=>
<< G:9>I26AJ:

,:G8:CID; !(

AAD86I>D C
JH=>DC
0DI6A ,:GB
+CA N/D;I!:7I

DCHI
DCANEDGI>DC

!@F7D7EF*3F7>> !@

0DI6A26AJ:

(02 !(
,:G
1C>I(>B>I *

)6M DCHI(D6C
BDJCI

!(
(>B>I *

DBB>IB:CI
BDJCI 0! 0:HI06G<:I
06G<:I(>B>I *

VHB_Parsons_v1.4_Feasibility_HCD.xlsm
1808 Parsons

Page 2 ends

Uses of Funds .7DE;A@ #:6H>7>A>IN
%/ &&$
*7EAEF '+,$$',!'&+ $! ,
$!!$
+!+ ',
*+!+'+,$$',! '&+
*7E+C
AAF 6680-1+
/*(7-21
2 !:;:GG:9ID %>HIDG>8

7BD75;34>7 DBEA:I>DC (6C96H>H .:=67 &0 06M
,AF3> ,AF3>&A@ &A@ A@EFD

DG ;DG 06M G:9>I G:9>I6H>H
,',$ (7D-@;F *7E;67@F;3> *7E;67@F;3>
7BD75;34>7 .:H>9:CI>6A *DC
.:H>9
JB7@E76 ?ADF;L76 *7:34 5CG;E;F;A@ ,:GB DCK 0:HI 6H>H /DA6G,2 )-!+!,!'&'+,+
*<A/9&B?16/@3&?713 (3/9
@A/A3

(6C9
,6GHDCH

(6C9%DA9>C< DHIH

*
'+,+
#27'/216758(7-212175'(7

&
/'&+,*-,!'&
%6G9 DHIH
1C>I DCHIGJ8I>DC

/>I:&BEGDK:B:CIH(6C9H86E:

$
$:C:G6A DC9>I>DCH

$
+K:G=:69,GD;>I

$
&CHJG6C8:

$
DC9,G:B>JB

DCI>C<:C8N
+LC:GH DCHIGJ8I>DC

+'
,'+,+

G8=>I:8IJG:
!:H><C

"C<>C::G>C<

(0
/JGK:N

"CK>GDCB:CI6A

(D86A!:K:ADEB:CI&BE68I#::H

(D86A,:GB>IH#::H

1I>AIN DCC:8I>DC#::H

.:6A"HI6I:06M:H!JG>C< DCHI

&CHJG6C8:!JG>C< DCHI

EEG6>H6A

)6G@:I.:CI DBE/IJ9N

/D;I DHI DCI>C<:C8N

,G:9:K(D6C&CI:G:HI#::H

DCHIGJ8I>DC(D6C&CI:G:HI

88GJ:9&CI:G:HI
>IND;):G8:9

0>IA:.:8DG9>C<"H8GDL
DCHIGJ8I>DC

0>IA:.:8DG9>C<"H8GDL
,:GB6C:CI

(:<6A+LC:G DCHIGJ8I>DC ADH>C<

,:GB 6C:CI ADH>C<

+G <6C>O6I>DCD;,ICH=E

/NC9>86I>DC
$,

/NC9>86I>DC DCHJAI>C<

J9>I DHI :GI>;>86I>DC

0
EEA>86I>DC.:H)DC>IDG>C<#::

#JGC>H=>C<H*DI>C DCIG68I

/I6GI
JE(:6H:

JE"ME:CH:H

6E>I6A>O:9+E:G6I>C<.:H:GK:BDH

!:K:ADE:G#::

!&&!&

+
DCHIGJ8I>DC(:C9:G+G><>C6I>DC#::

DCHIGJ8I>DC(:C9:G"ME:CH:H

DCHIGJ8I>DC(:C9:G DJCH:A

)B0A<A/9
7;/;17;5
<@A@< 4 @@B/;13

,',$

.
$'(%
&,'+,+

*&3?+;7A
*$3A<4/11?B327;A3?3@A

**

1808 Parsons

Page 3 ends

Developer Fee Calculation .7DE;A@ #:6H>7>A>IN
%/ &&$
%0!%-%

.
$'(
*

$-$,!'&
'&+,
)
,',$
#::E:G6H:0
#DGBJA6

&3?13;A<4*<A/9

)6M
AADL67A:#::E:G0
EGDG6I:9

"3@@3C39<=:3;A<;@B9A7;5

&7F>>AI34>7

"3@@%D;3?(32B1A7<;
&7F>>AI34>7

)6M>BJB6H:!:K:ADE:G#::E:G0

)6M>BJB!:K:ADE:G#::E:G% ! *

)6M>BJB!:K:ADE:G#::E:G(D86A *

)6M>BJB!:K:ADE:G#::E:G+LC:G *

)6M>BJB!:K:ADE:G#::6I)6M 6H=#::
)DHI.:HIG>8I>K:)6M>BJB!:K:ADE:G#::

)6M>BJB 6H=#::E:G0

)6M>BJB 6H=#::E:G% ! *

)6M>BJB 6H=#::E:G(D86A *

)6M>BJB 6H=#::E:G+LC:G *

)DHI.:HIG>8I>K:)6M>BJB 6H=#::

,-$

.
$'(
*

(1%
&,+

BDJCI D; 6H=#:: D;0DI6A#::

DCHIGJ8I>DC ADH:

&CI:G>B)>A:HIDC:
&CI:G>B)>A:HIDC:
&CI:G>B)>A:HIDC:
DBEA:I>DC

DCK:GH>DC

#>C6A(,,6N
>C

#>C6A(,,6N
>C
,AF3>3E:
77

,AJH!:;:GG:9!:K:ADE:G#::
,AJH$, 6E>I6A
,AF3>
7H7>AB7D
77

1808 Parsons

Page 4 ends

Unit Mix & Rental Income .7DE;A@ #:6H>7>A>IN
%/ &&$
-,!$!,1$$'/&
+ . . . . . .
.
*

'*
!$!,1
'* ,6GHDCH $! ,-&!,+A8%76;3@

,!&'%
,*
,!&(,+

*
&,$!%!,++'
1
*

):G8:9,%

RESIDENTIAL INCOME
$! , ,;7D

'56216 #

A8-@;FE

# "$"&
-@;F
,KB7 &G?47D
-@;F
>AAD
D73
5FG3>
*7@F
,
%!
5FG3>*7@F
'F:7D%!

(7D-@;F
%A@F:>K
DAEE*7@F
(7D-@;F
*79G>3FADK
&7F*7@F
(7D-@;F
5FG3>&7F
*7@F
,AF3>
%A@F:>K
&7F*7@F
,AF3>
@@G3>&7F
*7@F
&G?47DA8
+G4E;6;L76
-@;FE
(7D-@;F
&7F
+G4E;6K
*7@FE
(7D-@;F
+G4E;6K
!@5D7?7@F
,AF3>
%A@F:>K
+G4E;6K
,AF3>
@@G3>
+G4E;6K
,AF3>
@@G3>
!@5A?7
.

.

.

,',$

$! , ,;7D
'56216 #

A8-@;FE

# "$"&
-@;F
,
KB7 &G?47D
-@;F
>AAD
D73
5FG3>
*7@F
,
%!
5FG3>*7@F
'F:7D%!

(7D-@;F
%A@F:>K
DAEE*7@F
(7D-@;F
*79G>3FADK
&7F*7@F
(7D-@;F
5FG3>&7F
*7@F
,AF3>
%A@F:>K
&7F*7@F
,AF3>
@@G3>&7F
*7@F
&G?47DA8
+G4E;6;L76
-@;FE
(7D-@;F
&7F
+G4E;6K
*7@FE
(7D-@;F
+G4E;6K
!@5D7?7@F
,AF3>
%A@F:>K
+G4E;6K
,AF3>
@@G3>
+G4E;6K
,AF3>
@@G3>
!@5A?7
.

.

,',$

$! , ,;7D
'56216 #
A8-@;FE

# "$"&
-@;F
,KB7 &G?47D
-@;F
>AAD
D73
5FG3>
*7@F
,
%!
5FG3>*7@F
'F:7D%!

(7D-@;F
%A@F:>K
DAEE*7@F
(7D-@;F
*79G>3FADK
&7F*7@F
(7D-@;F
5FG3>&7F
*7@F
,AF3>
%A@F:>K
&7F*7@F
,AF3>
@@G3>&7F
*7@F
&G?47DA8
+G4E;6;L76
-@;FE
(7D-@;F
&7F
+G4E;6K
*7@FE
(7D-@;F
+G4E;6K
!@5D7?7@F
,AF3>
%A@F:>K
+G4E;6K
,AF3>
@@G3>
+G4E;6K
,AF3>
@@G3>
!@5A?7
.

.

,',$

$! , ,;7D
'56216 #
A8-@;FE

# "$"&
-@;F
,KB7 &G?47D
-@;F
>AAD
D73
5FG3>
*7@F
,
%!
5FG3>*7@F
'F:7D%!

(7D-@;F
%A@F:>K
DAEE*7@F
(7D-@;F
*79G>3FADK
&7F*7@F
(7D-@;F
5FG3>&7F
*7@F
,AF3>
%A@F:>K
&7F*7@F
,AF3>
@@G3>&7F
*7@F
&G?47DA8
+G4E;6;L76
-@;FE
(7D-@;F
&7F
+G4E;6K
*7@FE
(7D-@;F
+G4E;6K
!@5D7?7@F
,AF3>
%A@F:>K
+G4E;6K
,AF3>
@@G3>
+G4E;6K
,AF3>
@@G3>
!@5A?7
.

.

.

,',$

+F388-@;FE +;F7

'56216
-@;F
,KB7 &G?47D
-@;F
>AAD
D73
5FG3>
*7@F
,
%!
5FG3>*7@F
'F:7D%!

(7D-@;F
%A@F:>K
DAEE*7@F
(7D-@;F
*79G>3FADK
&7F*7@F
(7D-@;F
5FG3>&7F
*7@F
,AF3>
%A@F:>K
&7F*7@F
,AF3>
@@G3>&7F
*7@F
.

,',$

,',$*
+!

&,!$!&'%

&G?47D
,AF3>
%A@F:>K
&7F*7@F
,AF3>
@@G3>&7F
*7@F
%A@F:>K
+75F;A@
!@5A?7
@@G3>
+75F;A@
!@5A?7
%A@F:>K
&!@5A?7
@@G3>&
!@5A?7
%A@F:>K
,7EF
!@5A?7
@@G3>
,7EF
!@5A?7
%A@F:>K
,7EF

!@5A?7
@@G3>
,7EF

!@5A?7
D3@6
,AF3>
!@5A?7
,AF3>
>AAD
D73
(&%0

* D C
( & % 0
/I6;;1C>IH

,',$

%!+
$$&
'-+!&'%
+-+!
!2

-&!,%!0+-%%*1
(7D-@;F(7D%A@F: %A@F:>K,AF3> @@G3>,AF3>
(6JC9GN2:C9>C<
+I=:G
, 6 G @ > C < .
.
,',$

.
.
.
.
,',$

1808 Parsons
,AF3>-@;FE
-@;FE
/;F:AGF
+G4E;6K
-@;FE/;F:
,7EF

-@;FE/;F:
,7EF
-@;FE/;F:
&
-@;FE/;F:
+75F;A@-@;F,KB7

Page 5 ends

Calculation of Tax Credits .7DE;A@ #:6H>7>A>IN
%/ &&$

*$ $!
'*&!
+*/0 +*/0

-1&/&0&+* ."%
0+0
(
-1&/&0&+* ."%
0+0
(

0+0
("(&$&(" +/0/

(:HH
"C:G<N&CK:HIB:CI06M G:9>I.:H,DGI>DC %>HIDG>806M G:9>I.:H,DGI>DC
*DC
"A><>7A:#:9:G6A#>C6C8>C<
*DC
"A><>7A:$G6CIH
/D;I(D6C6H>H!:9J8I>DC
2DAJCI6GN.:9J8I>DC;DG0>:

G:6@:G
"(&$&("
/&/

*6?3@6<92/@7@"7:7A

*"
E19 B23
&/=

4<?
)A/A3

."-1"/0"!1*
!'1/0"!"(&$&("
/&/#DG0>:7G:6@:G

%&$% +/0
!'1/0)"*05DG* *
'*

!'1/0"!"(&$&("
/&/

,,(&
("#.
0&+*

-1
(&#&"! ."!&0
/&/

."!&0.
0"0
1*!".3.&0&*$ 0DI6A/I6I:

CCJ6A#:9:G6A5G
/I6I:
5G/I6I:
)
4,+0"*0&
(#"!".
( ."!&0*D2DA6H>8.:9J8I
8IJ6A.6I:

G:9>I.6I:H
,DI:CI>6A G:9>I

G:9>I.6I:(D8@:9
.
)
'6C

)
4 ."!&0
)+1*0,".0
1*!".3.&0&*$

CCJ6A#:9:G6A5G/I6I:

5G/I6I:

5G/I6I:

5G/I6I:
0DI6A

."-1"/0"!0+0
(/0
0" ."!&0
)+1*0

)
4
**1
(#"!".
( ."!&0/,".$"+$.
,%& ." $&+*
("*!"!M

)
4
**1
(#"!".
(,".,.+'" 0
((+
0&+*

01 (0
."!&0."/".2
0&+*

CCJ6A#:9:G6A0DI6A/I6I: *
*
*
*
*
*

%0!%-%$$'/$
*

!,+$7EE7DA834AH7

CCJ6A#:9:G6A0DI6A/I6I:

+$!+)*

"
"
) )*#-(
*#%+$*

+$!+)*
) )
-"+
*#-(
*#%+$*

%0!%-%$$'/$
,
&1
*,',$

,',$+,,

*$$! ,%'-&,+

1
*+
,AF3>
767D3>+F3F7
A:C9:9 G:9>I.:FJ:HI

$:C:G6A,6GIC:G/=6G:
"H I06G<:I;DG :CIG6A26AA:N

(>B>I:9,6GIC:G/=6G:

G:9>I.:FJ:HI1C9:G +K:G $:D<G6E=>8.:<>DC

!*+,1
**

!,$-$,!'&

767D3>
5FG3>3E;E%7F:A6 5
8FJ>H>I>DC .:=67*
A9<H
8F .:=67* A9<H
8F .:=67*
)6M>BJB,DI:CI>6A#:9:G6A G:9>IL
8IJ6A6H>H

CCJ6A

3<I
K<(:6H:

JE;GDB,6<:
)6M>BJB,DI:CI>6A,GDG6I:9 G:9>IL
8IJ6A6H>H

0 G:9>I.:H:GK6I>DC

CCJ6A

;DEF173DD76;F$7EE7DA84AH7

&
*1!&.
+,%
&,,0*

!,+A>3D(. (($! $

*,!'&
0DI6A,2%6G9 DHIH
.:A6I:9/D;I DHIH"C<
&CI:GHI

*JB7:GD; 0DI6A
.:A6I:9!:K:ADE:G#::
1C>IH #G68I>DC /F#I #G68I>DC
0DI6A!:EG:8>67A:6H>H
(&%0

A:HH$G6CIH.:76I:H
*DC
(&%0
06M
"M:BEI,DGI>DC
A:HH06M
"M:BEI,DGI>DC
0+0
(

*:I6H>H;DGJH>C:HH06M G:9>I

G:9>I,:G8:CI6<:
BB>;534>7
D35F;A@

,AF3>D76;F
"3@@3?<4"<D ;1<:3
*7E;67@F;3>(ADF;A@A8D76;F
+;7A@<?)>
A
!+,'*!*

!,$-$,!'&
0DI6A!:EG:8>67A:6H>H

A:HH%>HIDG>8
8FJ>H>I>DC6H>H
A:HH/>I:3DG@

A:HH,:GHDC6A,GDE:GIN

6H>H;DG%>HIDG>8 G:9>IE6
G><=I8DAJBC

,GD?:8I/#%>HIDG>8
6H>H;DG%0
9?JHI:97N/#

06M
"M:BEI1H:,DGI>DC
(:HH06M
"M:BEI1H:,DGI>DC

6H>H;DG%>HIDG>8 G:9>IE6
G><=I8DAJBC

G:9>I,:G8:CI6<:
.:H,DGI>DCD;%>HIDG>86H>H8DHI8:GI

,:G:CI6<:G:A6I:9ID.:H>9:CI>6A
,AF3> ;EFAD;5D76;F

*7E
(ADF;A@A8 ;EFAD;5D76;F

1808 Parsons

Page 6 ends

Base Year Income & Expense .7DE;A@ #:6H>7>A>IN
%/ &&$
!&'%

/8=:9JA:9$GDHH&C8DB:
.:H>9:CI>6A

2686C8N(DHH
.:H>9:CI>6A

,!.
*'++!&'%

0(
&+
+ *
+!

&,!$
)0-1-675'7-9*

9K:GI>H>C<

(:<6A

88DJCI>C<
J9>I

/:8JG>IN

+I=:G)>H8
9B>C

#27'/)0-1-675'7-9*

'1'+*0*17**

$7-/-7-*6
$6H

"A:8IG>8>IN

36I:G/:L:G

&CI:GC:I

#27'/$7-/-7-*6

';52// ';52//# ':*6
+C
/>I:)6C6<:G+;;>8:
9B>C

)6>CI:C6C8:,6NGDAA

,6NGDAA06M:H:C:;>IH

#27'/ ';52// ';52//#':*6

1685'1(*

'-17*1'1(*
.:E6>GH

0G6H=.:BDK6A

"MI:GB>C6I>C<

$GDJC9H

"A:K6IDG
'6C>IDG>6A
B>H8:ME:CH:H

#27'/
'-17*1'1(*

7,*5
)>H806M(>8:CH:
#27'/7,*5
!*6-)*17"*59-(*6
0:C6CI/:GK>8:H
#27'/!*6-)*17"*59-(*6
!*3/'(*0*17!*6*59*

!*'/67'7*#':*6

,',$
0(
&+
+ *
+!

&,!$

&3?+;7A&3? ;;B:7;19
(3@3?C3@
&3?+;7A&3? ;;B:D
<A/E3@
?3@
@C1

*#7;7:B:D
<A/E3@
?3@
@C1

&
,.!$$
!&'%

(:HH)6C96IDGN
CCJ6A % !,6NB:CI$GDHH:91E;DG!/ .#68IDG

"-+,

&
,.!$$
!&'%
,',$

"-+,

&
,'
'%%
*!$

"-+,

&
,.!$$
!&'%
&
,'
'(+-+!
1

!:7I/:GK>8: DK:G6<:.6I>D
.!$$

'*

,+
*.!
&
,'
'(+-+!
1

.!$$

'*

,+
*.!
'(+-+!
1'.
* &
&
,.!$$
!&'%

,
*+
&!'*

,+
*.!

&
,.!$$
'%%
*!$'&$1!&'%

1808 Parsons

Page 8 ends

Lease-Up / Placed-in-Service Schedule .7DE;A@ #:6H>7>A>IN %/ &&$
+

3F7E
%A@F:EFA
%;>7EFA@7
G?G>3F;H7
%A@F:E
/I6GID; DCHIGJ8I>DC 'JAN

DBEA:I>DC
EG>A

+88JE6C8N 'JAN

DCK:GH>DC '6CJ6GN

#DGBH )6N

$! ,+

-$
$! ,+

-$

*

!,+ '(
*,!'&++

/&*$("1&(!&*$)1(0&,("1&(!&*$/
$.+1,
/&*$("(!$) 1(0&,("(!$/
$.+1,
5"
.
HI06M G:9>I5:6G HI06M G:9>I5:6G1C>IH 0DI6A1C>IH
DBEA:I:9(:6H:1E7N)DCI=
,AF3>)' ,AF3>.353F76 G?G>3F;H7 G?G>3F;H7 %A@F: &A
-@;FE (7D57@F % A@F: &A
-@;FE (7D57@F
%A@F: 4K%A@F: 4K%A@F: '55GB3@5K '55GB3@5K '6C
'6C

'6C
#:7
#:7

#:7
)6G
)6G

)6G

EG

EG

EG
)6N
)6N

)6N
'JC
'JC

'JC
'JA
'JA

'JA

J<

J<

J<
/:E
/:E

/:E
+8I
+8I

+8I
*DK
*DK

*DK
!:8
!:8

!:8
,AF3>

,AF3>

EF173D'55GB3@5K

,AF3>H9)G3>
'55

,AF3> 'B7D3F;@9;@
;DEF173D

)1(0&,("1&(!&*$/
$.+1, )1(0&,("1&(!&*$/
$.+1, 5"
.8JBJA6I>K:
HI06M G:9>I5:6G HI06M G:9>I5:6G1C>IH 0DI6A1C>IH
0DI6A-+ 0DI6A2686I:9 JBJA6I>K: JBJA6I>K: %A@F: &A
-@;FE (7D57@F %A@F: &A
-@;FE (7D57@F
%A@F: 4K%A@F: 4K%A@F: '55GB3@5K '55GB3@5K '6C
'6C

'6C
#:7
#:7

#:7
)6G
)6G

)6G

EG

EG

EG
)6N
)6N

)6N
'JC
'JC

'JC
'JA
'JA

'JA

J<

J<

J<
/:E
/:E

/:E
+8I
+8I

+8I
*DK
*DK

*DK
!:8
!:8

!:8
,AF3>

,AF3>

EF173D'55GB3@5K

,AF3>H9)G3>
'55

,AF3> 'B7D3F;@9;@@6173D

(!++

-$

'*)+!+

(*
!,!'& (!++

-$

'**

& +!+

(*
!,!'& (!++

-$

'*+!,
/'*#
(
*+
(*'(

(*
!,!'&
5"
. 5"
. 5"
.
)>9
)DCI= DCK:CI>DC )>9
)DCI= DCK:CI>DC )>9
5:6G DCK:C I>DC
A9<,&/7N)DCI= A9<,&/7N)DCI= A9<,&/7N)DCI= #<;A6 $<
+;7A@ 3=
&3?13;A #<;A6 B7927;5$<
$<
+;7A@ &3?13;A #<;A 6 B7927;5$<
$<
+;7A@ &3?13;A
'6C
'6C
'6C

#:7
#:7
#:7

)6G
)6G
)6G

EG

EG

EG

)6N
)6N
)6N

'JC
'JC
'JC

'JA
'JA
'JA

J<

J<

J<

/:E
/:E
/:E

+8I
+8I
+8I

*DK
*DK
*DK

!:8
!:8
!:8

0+0
( 0+0
( 0+0
(
,AF3>H9(!+1

,AF3>H9(!+1

,AF3>H9(!+1

5"
.8JBJA6I>K: 5"
.8JBJA6I>K: 5"
.CDC
8JBJA6I>K:
'6C
'6C
'6C

#:7
#:7
#:7

)6G
)6G
)6G

EG

EG

EG

)6N
)6N
)6N

'JC
'JC
'JC

'JA
'JA
'JA

J<

J<

J<

/:E
/:E
/:E

+8I
+8I
+8I

*DK
*DK
*DK

!:8
!:8
!:8

0+0
( 0+0
( 0+0
(
,AF3>H9(!+1

,AF3>H9(!+1

,AF3>H9(!+ 1

1808 Parsons

Page 9 ends

Calculation of Net Syndication Proceeds .7DE;A@ #:6H>7>A>IN %/ &&$

HD; ADH>C<
0DI6A#:9:G6A G:9>ING /I6I: G:9>I

*<A/9
323?/9?327A

*<A/9)A/A3?327A

$GDHH,GD8::9H0DI6A

?<@@&?<1 332@
323?/9?327A

?<@@&?<1 332@ )A/A3?327A

$GDHH,GD8::9HC:ID;"C:G<N%>HIDG>8 G:9>I,GD8::9H

(:HH(,/NC9>86I>DC DHIH

IIDGC:N

88DJCI6CI

DCHJAI>C<

+I=:G
0DI6A/NC9>86I>DC DHIH

0DI6A/NC9>86I>DC DHIH$GDHH,GD8::9H /NC9>86I>DC(D69 &7F(DA5776E

&7F(DA5776E
,AF3>
763@6+F3F7D76;F

F3J5D76;FBD;57
DAEE(DA5776E,AF3>
,AF3>
763@6+F3F7D76;F

F3J5D76;FBD;57
DAEE(DA5776E
767D3>
+F3F7
;E399D793F76
#:9:G6A I6M8G:9>IEG>8: /I6I: I6M8G:9>IEG>8: &7F(DA5776E
767D3>
+F3F7
;E399D793F76
#:9:G6A I6M8G:9>IEG>8: /I6I: I6M8G:9>IEG>8: 7DF8;53F76+F3F7D76;FE
0DI6A/I6I: G:9>I :GI>;>86I:H
$GDHH,GD8::9H;GDB :GI>;>86I:9 G:9>IH
$GDHH,GD8::9H :GI>;>86I:9 G:9>I
(.D76;F
0DI6A"C:G<N G:9>I
(,/=6G:
$GDHH,GD8::9H;GDB"C:G<N G:9>I
$GDHH,GD8::9H"C:G<N G:9>I
;EFAD;5D76;F
0DI6A%>HIDG>8 G:9>I
(,/=6G:
$GDHH,GD8::9H;GDB%>HIDG>8 G:9>I
$GDHH,GD8::9H%>HIDG>8 G:9>I
,AF3>
CG;FK
$GDHH,GD8::9H;GDB(&%0

$GDHH,GD8::9H;GDB"C:G<N G:9>I
$GDHH,GD8::9H;GDB%>HIDG>8 G:9>I
,AF3>
CG;FK

1808 Parsons

Page 10 ends

TCAC Calculations & Scoring .7DE;A@ #:6H>7>A>IN
%/ &&$
, *
+ '$
+!+$!%!,
DJCIN ):G8:9 0
,GD?:8I
DG8G:9>IH !(
,GD?:8I
5:6G
3E7$;?;FE8AD7A9D3B:;5*79;A@ ,:D7E:A>63E;E$;?;F8AD,:;E (DA<75F ,:G1C>I
1C>I0NE: 1C>I0NE: 1C>IH 6H>H(>B>I 0DI6A
.

.

.

.

.

.

.

.

.

.

.

.

@7D9K
*7EAGD57
88;5;7@5KAAEFE 66;F;A@3>3E;E6<GEF?7@FE
DDHI;DG,G:K6>A>C<36<:
.:C:L67A:HID I6G:6 DDHI;DG,GD?:8I( 67DG <G::B:CI
.:C:L67A:H
6G:6 DDH I;DG,6G@>C<7:C:6I=1C>IH
0>IA:
DDHI;DG =>A986G:
,DHI
G:=67>BEGDK:B:CI DDH I;DG/E:8>6A* ::9H $G:NL6I:GA6C9H86E>C< DDHI;DG:A:K6IDGH:GK>8: DBBJC>IN<6G9:CHH; DDH I;DG0NE:&8DCHIGJ8I>DC *6IJG6A;ADDG>C<@>I8=:CH DDH I;DG0NE:&&&8DCHIGJ8I>DC *6IJG6A;ADDG>C<8DBBDC6G:6 +G4FAF3>AAEF

",
&C9DDG
>G,AJH,GD<G6BB:I DDH I;DG"C:G<N.:HDJG8:";;>8>:C8N 0DM>8/:>HB>8
76I:B:CI DHIH
(D86A!:K:ADEB:CI&BE68I#::H

+G4FAF3>
88;5;7@5K%3J

%><=+EEDGIJC>IN
G:6
+*!/DDHI;DGJC>IHP
)&
:M8A
8G:9>IEGD?:8I
+*!/DDHI;DGJC>IHP
)& :M8A
8G:9>IEGD?:8I
,AF3>,:D7E:A>63E;E$;?;F

,DI:CI>6A"A><>7A:6H>H

"A><>7A:6H>H/JGEAJH!:;>8>I

, ! '+,,
+,
#:9:G6A G:9>I
/I6I: G:9>I % !1).
0DI6A"A><>7A:6H>H

0DI6A
9?JHI:90(

(7D57@F397A8,$

BDJCI+K:G1C9:G (>B>I(>B> I;DG% !

,('!&,+
$AI7EF!@5A?7(A;@FE
.JG6A,GD?:8I
*
&G?47DA8 (7D57@FA8 (7D57@F3
97A8 (7D57@FA8!@5A?7 (A;@FE
3D@76
,3D97F76,3J D73%76;3@ -@;FEFA,AF3> ,3D 97F76-@;FEFA D76;F-@;FE !@5A?7 %! -@;FE ,AF3>,3JD76;F

478AD7DAG@6;@9 -@;FE7J5>GE;H7
6AI@ A8?9DG@;FE

!85'/ 52
.*(761/;
!85'/ 52.*(761/;

,AF3>$AI7EF!@5A?7(A;@FE&A3B

,AF3>$AI7EF!@5A?75FG3>(A;@FE

$AI7EF!@5A?7A@GE(A;@FE *<A/9
# (3>B7?324<?&<7;A@

76DAA?
+7>75F;A@
,AF3>&G?47DA8
,3JD76;F-@;FE
B7D76DAA?+;L7
&G?47DA8
,3D97F76,3J
D76;F-@;FE

%!
(7D57@F397A8
-@;FEFA,AF3>
-@;FE4K476DAA?
E;L7

4K-@;F,KB7
%;@;?G?-@;FE
*7CG;D763F

47>AI
%!
. &/@@
. &/@@
. &/@@
. &/@@
. &/@@
/.+ &/@@
,AF3>

,AF3>$AI7EF!@5A?7A@GE(A;@FE
,,!
*
#
*
$7H7D3976+A8F*7EAGD57E
DBB>II:9"A><>7A:,J7A>8/D;I#JC9H

26AJ:D;!DC6I:9(6C9 #::36>K:G
26AJ:D; DBB>II:9.:CI6A/J7H>9N(:K:G6<>C<
(:HH*DC,GD?:8I
/E:8>;>8+;;H>I:3DG@
(:HH,JG8=6H:,G>8:>C"M8:HHD;
EEG6>H6A
.:H>9:CI>6A,:G8:CI6<:D;0!
/J7IDI6A.:H>9:CI>6A"A><>7A:,J7A>8#JC9H

,:G8:CI6<:(6G<:,GD?:8IDDHI

9?JHI:9.:H>9:CI>6A"A><>7A:,J7A>8#JC9H

.:H>9:CI>6A0DI6A DHIHD;!:K:ADEB:CI

*3F;AA8$7H7D3976+A8F*7EAGD57E
,

*7CG7EF76-@36<GEF76
>;9;4>73E;E
.:FJ:HI:91C69 ?JHI:9"A><>7A:6H>H

.:H>9:CI>6A0DI6A DHIHD;!:K:ADEB:CI

.6I>DD;6H>H0!

!@H7DE7A8*3F;A
;H;6764K

3E7,;74D73=7D+5AD7

756%==<?AB;7AF<<@A

,AF3>,;74D73=7D+5AD7

*730?3/83?/A==971/A7<;
1808 Parsons

Page 11 ends

15-Year Cash Flow .7DE;A@ #:6H>7>A>IN
%/ &&$
EEG?BF;A@E
.:CI&C8G:6H:.:H> 9:CI>6A0:C6CI.:CI H .:CI&C8G:6H: /:8I>DC ,:GB (D6C
!:7I/K85G

.:CI&C8G:6H: DBB:G8>6A.:CIH .:CI&C8G:6H: *
,:GB(D6C
!:7I/K85G

"ME:CH:H&C8G:6H: .:C I&C8G:6H:
0:HI ,:GB (D6C
!:7I/K85G
.:H:GK:&C8G:6H: .:CI&C8G:6H:
0:HI! ,:GB (D6C
!:7I/K85G
,:GB(D6C
!:7I/K85G
5*)-7 *5-2)%*'5

55?35?/A3;;B/9(3; A ;1?3/@3 ,

*'++(',
&,!$!&'%
*
+!

&,!$

2686C8N(DHH
.:H>9:CI>6A

*'++

,!.
!&'%

+E:G6I>C<"ME:CH:HL/I6C96G9&C;A6IDG

+E:G6I>C<"ME:CH:HL
AI:GC6I:&C;A6IDGH
(3/9
@A/A3*/E3@

,',$
0(
&+
+

*<A/9
E=3;@3@ (3@723;A7/9

&
,'(
*,!&!&'%

.",(
")"*0."/".2"

)6C96IDGN
CCJ6A % !,6NB:CI

&
,*
%!&!&!&'%

&
,+
$'/

!:7I/:GK>8: DK:G6<:.6I>D
AA!:7I *
*
*
*
*
*
*
*
*
*
*
*
*
*
*
*
*
*
*

!:7I/:GK>8: DK:G6<:.6I>D"M8AJ9>C</J7DG9>C6I:!:7I * *
*
*
*
*
*
*
*
*
*
*
*
*
*
*
*
*
*

"ME:CH: DK:G6<:.6I>D*D!:7I *
*
*

!+,*!-,!'&'
+
$'/
(,
)# ;;B/9:A

;49/A<?

$,,)# ;;B/9:A

;49/A<?

(3@72B/9(3137=A@"</;@ *<A/9

%/

>IND;):G8:9

$:C:G6A,6GIC:G

(>B>I:9,6GIC:G

1808 Parsons

City Council/Public Finance and Economic Development Authority/Parking AuthorityMay 2, 2022

City Council/Public Finance and Economic Development Authority/Parking Authority
May 2, 2022