Calculating Tenant Improvement Amortization
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZAAABAC
1
Size of space in SF25,096
Tenant Improvement Amortization Schedule
2
Add TI Allowance Need$7.21TI Loan Amount$180,942Term (Yrs)10
3
Total Additional TI Allowance Needed$180,942.16Interest Rate8.00%Lease Start Date6/1/20
4
5
PeriodDateMonthly PaymentInterest PaymentPrincipal PaymentLoan Balance
6
06/1/20$0.00$0.00$0.00$180,942
7
ONLY CHANGE GREEN Fields17/1/2020-$2,195.33-$1,206.28-$989.05$179,953.05
8
28/1/2020-$2,195.33-$1,199.69-$995.64$178,957.41
9
39/1/2020-$2,195.33-$1,193.05-$1,002.28$177,955.14
10
410/1/2020-$2,195.33-$1,186.37-$1,008.96$176,946.18
11
511/1/2020-$2,195.33-$1,179.64-$1,015.69$175,930.49
12
612/1/2020-$2,195.33-$1,172.87-$1,022.46$174,908.03
13
Amortizing Tenant Improvements71/1/2021-$2,195.33-$1,166.05-$1,029.27$173,878.76
14
82/1/2021-$2,195.33-$1,159.19-$1,036.14$172,842.63
15
93/1/2021-$2,195.33-$1,152.28-$1,043.04$171,799.58
16
104/1/2021-$2,195.33-$1,145.33-$1,050.00$170,749.59
17
115/1/2021-$2,195.33-$1,138.33-$1,057.00$169,692.59
18
126/1/2021-$2,195.33-$1,131.28-$1,064.04$168,628.55
19
137/1/2021-$2,195.33-$1,124.19-$1,071.14$167,557.41
20
148/1/2021-$2,195.33-$1,117.05-$1,078.28$166,479.13
21
159/1/2021-$2,195.33-$1,109.86-$1,085.47$165,393.67
22
1610/1/2021-$2,195.33-$1,102.62-$1,092.70$164,300.96
23
1711/1/2021-$2,195.33-$1,095.34-$1,099.99$163,200.98
24
1812/1/2021-$2,195.33-$1,088.01-$1,107.32$162,093.66
25
191/1/2022-$2,195.33-$1,080.62-$1,114.70$160,978.95
26
202/1/2022-$2,195.33-$1,073.19-$1,122.13$159,856.82
27
213/1/2022-$2,195.33-$1,065.71-$1,129.61$158,727.20
28
224/1/2022-$2,195.33-$1,058.18-$1,137.15$157,590.06
29
235/1/2022-$2,195.33-$1,050.60-$1,144.73$156,445.33
30
246/1/2022-$2,195.33-$1,042.97-$1,152.36$155,292.97
31
257/1/2022-$2,195.33-$1,035.29-$1,160.04$154,132.93
32
268/1/2022-$2,195.33-$1,027.55-$1,167.77$152,965.16
33
279/1/2022-$2,195.33-$1,019.77-$1,175.56$151,789.60
34
2810/1/2022-$2,195.33-$1,011.93-$1,183.40$150,606.20
35
2911/1/2022-$2,195.33-$1,004.04-$1,191.29$149,414.92
36
3012/1/2022-$2,195.33-$996.10-$1,199.23$148,215.69
37
311/1/2023-$2,195.33-$988.10-$1,207.22$147,008.47
38
322/1/2023-$2,195.33-$980.06-$1,215.27$145,793.20
39
333/1/2023-$2,195.33-$971.95-$1,223.37$144,569.83
40
344/1/2023-$2,195.33-$963.80-$1,231.53$143,338.30
41
355/1/2023-$2,195.33-$955.59-$1,239.74$142,098.56
42
366/1/2023-$2,195.33-$947.32-$1,248.00$140,850.56
43
377/1/2023-$2,195.33-$939.00-$1,256.32$139,594.23
44
388/1/2023-$2,195.33-$930.63-$1,264.70$138,329.53
45
399/1/2023-$2,195.33-$922.20-$1,273.13$137,056.40
46
4010/1/2023-$2,195.33-$913.71-$1,281.62$135,774.79
47
4111/1/2023-$2,195.33-$905.17-$1,290.16$134,484.62
48
4212/1/2023-$2,195.33-$896.56-$1,298.76$133,185.86
49
431/1/2024-$2,195.33-$887.91-$1,307.42$131,878.44
50
442/1/2024-$2,195.33-$879.19-$1,316.14$130,562.30
51
453/1/2024-$2,195.33-$870.42-$1,324.91$129,237.39
52
464/1/2024-$2,195.33-$861.58-$1,333.74$127,903.65
53
475/1/2024-$2,195.33-$852.69-$1,342.64$126,561.01
54
486/1/2024-$2,195.33-$843.74-$1,351.59$125,209.42
55
497/1/2024-$2,195.33-$834.73-$1,360.60$123,848.83
56
508/1/2024-$2,195.33-$825.66-$1,369.67$122,479.16
57
519/1/2024-$2,195.33-$816.53-$1,378.80$121,100.36
58
5210/1/2024-$2,195.33-$807.34-$1,387.99$119,712.37
59
5311/1/2024-$2,195.33-$798.08-$1,397.24$118,315.12
60
5412/1/2024-$2,195.33-$788.77-$1,406.56$116,908.56
61
551/1/2025-$2,195.33-$779.39-$1,415.94$115,492.63
62
562/1/2025-$2,195.33-$769.95-$1,425.38$114,067.25
63
573/1/2025-$2,195.33-$760.45-$1,434.88$112,632.37
64
584/1/2025-$2,195.33-$750.88-$1,444.44$111,187.93
65
595/1/2025-$2,195.33-$741.25-$1,454.07$109,733.85
66
606/1/2025-$2,195.33-$731.56-$1,463.77$108,270.09
67
617/1/2025-$2,195.33-$721.80-$1,473.53$106,796.56
68
628/1/2025-$2,195.33-$711.98-$1,483.35$105,313.21
69
639/1/2025-$2,195.33-$702.09-$1,493.24$103,819.97
70
6410/1/2025-$2,195.33-$692.13-$1,503.19$102,316.78
71
6511/1/2025-$2,195.33-$682.11-$1,513.22$100,803.56
72
6612/1/2025-$2,195.33-$672.02-$1,523.30$99,280.26
73
671/1/2026-$2,195.33-$661.87-$1,533.46$97,746.80
74
682/1/2026-$2,195.33-$651.65-$1,543.68$96,203.12
75
693/1/2026-$2,195.33-$641.35-$1,553.97$94,649.15
76
704/1/2026-$2,195.33-$630.99-$1,564.33$93,084.81
77
715/1/2026-$2,195.33-$620.57-$1,574.76$91,510.05
78
726/1/2026-$2,195.33-$610.07-$1,585.26$89,924.79
79
737/1/2026-$2,195.33-$599.50-$1,595.83$88,328.96
80
748/1/2026-$2,195.33-$588.86-$1,606.47$86,722.50
81
759/1/2026-$2,195.33-$578.15-$1,617.18$85,105.32
82
7610/1/2026-$2,195.33-$567.37-$1,627.96$83,477.36
83
7711/1/2026-$2,195.33-$556.52-$1,638.81$81,838.55
84
7812/1/2026-$2,195.33-$545.59-$1,649.74$80,188.81
85
791/1/2027-$2,195.33-$534.59-$1,660.73$78,528.08
86
802/1/2027-$2,195.33-$523.52-$1,671.81$76,856.27
87
813/1/2027-$2,195.33-$512.38-$1,682.95$75,173.32
88
824/1/2027-$2,195.33-$501.16-$1,694.17$73,479.15
89
835/1/2027-$2,195.33-$489.86-$1,705.47$71,773.68
90
846/1/2027-$2,195.33-$478.49-$1,716.84$70,056.85
91
857/1/2027-$2,195.33-$467.05-$1,728.28$68,328.57
92
868/1/2027-$2,195.33-$455.52-$1,739.80$66,588.76
93
879/1/2027-$2,195.33-$443.93-$1,751.40$64,837.36
94
8810/1/2027-$2,195.33-$432.25-$1,763.08$63,074.28
95
8911/1/2027-$2,195.33-$420.50-$1,774.83$61,299.45
96
9012/1/2027-$2,195.33-$408.66-$1,786.66$59,512.79
97
911/1/2028-$2,195.33-$396.75-$1,798.58$57,714.21
98
922/1/2028-$2,195.33-$384.76-$1,810.57$55,903.65
99
933/1/2028-$2,195.33-$372.69-$1,822.64$54,081.01
100
944/1/2028-$2,195.33-$360.54-$1,834.79$52,246.22
Loading...