29 Maximum loan
supported by required debt service
coverage
Effective net operating income/required
debt service coverage/constant
$424,215 / 1.25 / .10070356
= $3,370,008.96
30 Loan to value (market)
Loan/value (market)
$3,370,000 / $4,286,734
= 78.61%
31 Loan constant
Debt service/loan amount
$339,371 / $3,370,000
= .10070356
32 Loan to purchase price
Loan amount / purchase price
$3,370,000 / $4,450,000
= 75.73%
34 Debt service coverage (d.s.c.)
Net operating income/debt service
$424,215 / $339,371
= 1.25
36 Loan per gross sq. ft. (improvements)
Loan/gross sq. ft. (improvements)
$3,370,000 / 86,479
= $38.97
38 Gross income per net usable occupied sq. ft.
Gross income/net usable sq ft
improvements/current occupancy. %
$476,499 / 86,479 / .95
= $5.80
39 Net operating income per net usable occupied sq.
ft.
Net operating income/net usable sq
ft imp's/current. occupancy. %
$424,215 / 86,479 / .95 = $5.16
45 Break even at stabilized occupancy
Debt service + exp/net usable sq ft
(improvement)/net occupancy %
($339,371 + $52,284)/ 86,479 / .95 = $4.77
46 Break even at stabilized rent
Debt
service + exp/gross income
per sq ft (imp)/net sq ft (imp)
($339,371 + $52,284)/ $5.80
/ 86,479 =
78.08%
50 Blended anchor tenant coverage to loan term
(non concurrent term)
Avg. yrs remaining anchor
tenant leases/loan term balloon) yrs
18.00 / 7 = 2.57
53 Loss of N.O.I. at maximum anchor tenant lease
fall out
Sq ft
anchor lease exp before balance x
net inc per net usable sq ft
0 X $5 = $.00
54 Remaining net operating income on retained
tenant base
Net operating income-loss of noi at max
anchor tent lease fall out
$424,215 - $0 = $424,214.89
64 Total parking spaces for each 1000 net usable
sq. ft.
Total parking spaces/net usable sq.
ft. (imp.) in 1000's
380 / 86.48 =
4.3941
