please show me how to solve this with excel and build an excel calcuator!

1) Given the following information, calculate the estimated terminal value of the property at the end of its holding period: going-out cap rate: 9%; estimated holding period: five years; NOI for year 5:$100,500; NOI for year 6 : $102,000. A) $1,113,333 B) $1,116,667 C) $1,133,333 - wrong D) $1,166,667