Calculating Amortization of TI Allowance - Lease Ref
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

View only
 
ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
3
4
5
6
Assumptions
7
Annual increase %3.00%
8
Base rent (per month)
$2.00
9
Interest rate7.50%
10
SF3,000
11
Term (Years)10
12
TI amount to be amortized
$90,000.00
13
14
15
Rent Calc:Year 1Year 2Year 3Year 4Year 5Year 6Year 7Year 8Year 9
Year 10
16
17
Base rent 72,000 74,160 76,385 78,676 81,037 83,468 85,972 88,551 91,207 93,944
18
TI amortization 12,820 12,820 12,820 12,820 12,820 12,820 12,820 12,820 12,820 12,820
19
Total$84,820 $86,980 $89,205 $91,496 $93,856 $96,288 $98,792 $101,371 $104,027 $106,763
20
$ PSF / year$28.27 $28.99 $29.73 $30.50 $31.29 $32.10 $32.93 $33.79 $34.68 $35.59
21
$ PSF / month$2.36 $2.42 $2.48 $2.54 $2.61 $2.67 $2.74 $2.82 $2.89 $2.97
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
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
Loading...