Question: please solve this numerical problem = = A1 fe F G H D E 1 2 Question 1 3 Glven the following data on a

please solve this numerical problem

= = A1 fe F G H D E 1 2 Question 1 3 Glven 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 11.00% 13 Life of Facility Years 20.00 14 15 Answer Area Enter your answer Grade 0 O 20 0 117 Present value of Revenues 18 19 Present value of Expenses 21 Net Present Value of new banking facility 22 23 24 should thid facility be opend 25 No (enter). Yes (enter 1) 26 27 28

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

please solve this numerical problem Al fx G H 17.96% 15.95% 10.48% 7.98% 18.45% 25.14% 74.86% A B D E F 26 27 28 29 Question 2 30 Given the following data on a potential branch acquisition please...

You dont need to do the data table part of the question at the end as i did not provided the data table for the last part. But please solve the parts at the top L M B D E F H J 77 Economies of Scale...

A B D K L M N O Month Year |Day 10 Quantity 7 20 25 380 220 4 280 1 380 00 ONS VAN 6 26 200 DO NOT MAKE ANY MODIFICATION (CHANGING THE ORDER OF THE COLUMNS, ADDING A NEW CALCULATED COLUMN ETC.) ON...

Please help answer part a to l: Attached below is the data: of the Documentation worksheet according to your nors de and then type your name in Firstname lastnom You have been asked to determine...

Robert (Bob) S. and Sally D. Grove are husband and wife and live at 4112 Larkspur Lane, Denton, TX 76201. Bob is a retired petroleum engineer, and Sally is a portrait artist. 1. When he retired at...

Please see numerical data to answer the questions in an excel sheet F G H M N 2. Quantitative Data - 15 pts O One way to organize data numerically is to create a frequency distribution. This is...

pg 2 above pg 3 above pg 4 above page 5 above page 6 above page 6 continued above page 7 above page 7 continued above page 7 continued above page 8 above This is my assignment for ACCT intermediate...

Alignment Number M88 B D G M 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 7 8 9 0 Details of McCormick Plant Proposal As you know from Project 4, McCormick & Company is considering building a new factory...

Please see attachment. All three question need to be answered in narrative format. If you have questions, just let me know. Normal requirement for references are 2 outside our course text....

For both companies compute the ( a ) current ratio, ( b ) acid-test ratio ( Do not round intermediate calculations). Please try to answer with drop options to make it easier to understand. Required...

A vote is to be taken among the residents of a town and the surrounding county to determine whether a proposed chemical plant should be constructed. The construction site is within the town limits,...

That old equipment for producing carburetors is worn out, said Bill Seebach, president of Hondrich Company. We need to make a decision quickly. The company is trying to decide whether it should rent...

Multiple Choice 1 . 6 7 points How does a mortgage broker make profit? a fee paid when the loan is completed and funds by servicing the loan interest on their monthly payment by selling the loan to...

Question 6 ( 1 point ) The concept of a media bubble dates back to the q , 1 9 9 0 s development of smartphones 1 9 7 0 s development of social media

What are the other economic side effects of accidents?

Write a short position paper on the subject, What should we do to get all our employees to behave more safely at work?

Based on what youve seen to this point, how comprehensive would you say that the companys safety program is? What suggestions would you make for additional steps it should take?