Please Show formulas

Question 1 Given the following data on a potential branch opening please calculate the answers and decide if the branch should be opened? Input Area: Initial cost of banking facility Initial other organizing expenses Year 1 revenue Year 1 operating expense Annual growth rate in revenues Annual growth rate in expenses Required annual rate of return Life of Facility Years $2,300,000.00 $400,000.00 $300,000.00 $130,000.00 4.00% 1.50% 9.00% 20.00 Answer Area Enter your answer Grade Present value of Revenues 0 Present value of Expenses 0 Net Present Value of new banking facility 0 1 Should thid facility be opend No (enter O), Yes (enter 1)