Question 1 Given the following data on a potential branch opening please calculate the answers and decide if the branch should be opened? \begin{tabular}{l|r|} \hline Input Area: & \\ \hline Initial cost of banking facility & $2,300,000.00 \\ \hline Initial other organizing expenses & $400,000.00 \\ \hline Year 1 revenue & $300,000.00 \\ \hline Year 1 operating expense & $130,000.00 \\ \hline Annual growth rate in revenues & 4.00% \\ \hline Annual growth rate in expenses & 1.50% \\ \hline Required annual rate of return & 10.00% \\ \hline Life of Facility Years & 20.00 \\ \hline \end{tabular} Present value of Revenues Present value of Expenses Net Present Value of new banking facility Should thid facility be opend No (enter 0 ), Yes (enter 1 )