Question: NA 1 2 Question 1 3 Given the following data on a potential branch opening please calculate the answers and decide if the branch should

NA 1 2 Question 1 3 Given the following data on a potential branch opening please calculate the answers and decide if the branch should be opened? 4 5 Input Area: 6 Initial cost of banking facility $3,400,000.00 7 Initial other organizing expenses $400,000.00 8 Year 1 revenue $400,000.00 9 Year 1 operating expense $140,000.00 10 Annual growth rate in revenues 3.00% 11 Annual growth rate in expenses 2.00% 12 Required annual rate of return 15.00% 13 Life of Facility Years 20.00 14 15 Answer Area Enter your answer 16 17 Present value of Revenues 18 19 Present value of Expenses 20 21 Net Present Value of new banking facility 22 23 24 Should thid facility be opend 25 No (enter O), Yes (enter 1) 26 Grade 0 0 0 1 NA 1 2 Question 1 3 Given the following data on a potential branch opening please calculate the answers and decide if the branch should be opened? 4 5 Input Area: 6 Initial cost of banking facility $3,400,000.00 7 Initial other organizing expenses $400,000.00 8 Year 1 revenue $400,000.00 9 Year 1 operating expense $140,000.00 10 Annual growth rate in revenues 3.00% 11 Annual growth rate in expenses 2.00% 12 Required annual rate of return 15.00% 13 Life of Facility Years 20.00 14 15 Answer Area Enter your answer 16 17 Present value of Revenues 18 19 Present value of Expenses 20 21 Net Present Value of new banking facility 22 23 24 Should thid facility be opend 25 No (enter O), Yes (enter 1) 26 Grade 0 0 0 1
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
