How to find terminal value?

B24 - X fx =NPV(C8,B23:L23) F G H I J K 5% 2% 2 Expected annual growth in NOI (year 2-10) 3 Terminal growth rate 4 Rent income year 1 5 Maintenance expense year1 Net Operating Income Year 1 7 Purchase Price 8 Discount rate 120000 30000 90000 1600000 6% 4% 2% 100000 30000 70000 1400000 6% 1 $90,000.00 $94,500.00 $99,225.00 10 $1,32,970.99 $ 1,39,619.54 $1,04,186.25 $1,09,395.56 $1,14,865.34 $1,20,608.61 $1,26,639.04 10 City A Year 12 NOI 13 Initial Investment Terminal Value Net CF NPV $-16,00,000.00 $35,60,298.26 $1,14,865.34 $1,20,608.61 $1,26,639.04 $1,32,970.99 $36,99,917.80 $94,500.00 $99,225.00 $1,04,186.25 $1,09,395.56 $-16,00,000.00 $90,000.00 $ 11,33,920.46 8 $ 88,572.33 $ 92,115.22 $ 95,799.83 $ 10 99,631.83 $70,000.00 $72,800.00 $75,712.00 $ 78,740.48 $ 81,890.10 $ 85,165.70 18 City B Year 20 NOI 21 Initial Investment Terminal Value 23 Net CF 24 NPV $-14,00,000.00 $25,40,611.59 $ 95,799.83 $26,40,243.41 $70,000.00 $72,800.00 $75,712.00 $ 78,740.48 $ 81,890.10 $ 85,165.70 $ 88,572.33 $ 92,115.22 $-14,00,000.00 $ 5,90,284.78