Question

. Hamilton State Bank wants to add a new branch office. They have determined that the...

. Hamilton State Bank wants to add a new branch office. They have determined that the cost of construction on the new facility will be $1.5 million with another $500,000 in organizational costs. Annual net revenues are projected to be $277,000. If the new branch is expected to last 20 years, what is the expected rate or return on this investment? (Round to the nearest whole percent)

            A. $929,252

            B. 72%

            C. 15%

            D. 12.5%

            E. 1.14%

Please show me the work so I know how to do it.

0 0
Add a comment Improve this question Transcribed image text
Answer #1

B23 - fx =IRR(B2:B22) B 1 year Cash flows 2 0 $ (2,000,000.00) 1500000+500000 3 1 $ 277,000.00 4 2 $ 277,000.00 5 3 5 277,000

Add a comment
Know the answer?
Add Answer to:
. Hamilton State Bank wants to add a new branch office. They have determined that the...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • West Bank has estimated the cost of a new facility at $1.5 million. At this initial...

    West Bank has estimated the cost of a new facility at $1.5 million. At this initial point, organizational costs are expected to reach an additional amount of approx. $500,000. Yearly net revenues are estimated at $400,000 and the new branch is expected to last 15 years. What is the expected rate of return on this investment? (Round to the nearest whole percent) 6 percent 21 percent 18 percent 32 percent none of the above

  • 1. LL Incorporated's currently outstanding 10% coupon bonds have a yield to maturity of 13%. LL...

    1. LL Incorporated's currently outstanding 10% coupon bonds have a yield to maturity of 13%. LL believes it could issue new bonds at par that would provide a similar yield to maturity. If its marginal tax rate is 35%, what is LL's after-tax cost of debt? Round your answer to two decimal places. 2. Summerdahl Resort's common stock is currently trading at $36.00 a share. The stock is expected to pay a dividend of $2.50 a share at the end...

  • Blues Traveler Company sells electric razors. The company’s home office is in Princeton, New Jers...

    Blues Traveler Company sells electric razors. The company’s home office is in Princeton, New Jersey. The company was founded in 2005 when John Popper invested $300,000 for 30,000 shares and Chan Kinchla invested $200,000 for 20,000 shares of common stock. The only other financing activities relate to a $500,000 bank loan from 1st National Bank that accrues interest at six percent per year payable on January 1 each year that has an unpaid balance of $400,000. The loan is due...

  • What rates should be charged? Downtown Parking Authority In January a meeting was held in the office of the mayor of Oa...

    What rates should be charged? Downtown Parking Authority In January a meeting was held in the office of the mayor of Oakmont to discuss a unicipal parking facility. The participants included the mayor, the traffic proposca the administrator of Oakmont's Downtown Parking Authority, the city planner, and the finance director. The purpose of the meeting was to consider a report Richard Stockton, executive assistant to the Parking Authority's administrator, concerning estimated costs and revenues for the proposed facility. Mr. Stockton's...

  • Direction: review the eassy prof it and summerize it. Add thesis with it. make changes if...

    Direction: review the eassy prof it and summerize it. Add thesis with it. make changes if posible Title The coporate puzzel When all you believe is people behind you until they turn their back on you. Times are hard when you are not to be worried about anything in life. I had a great job with a very working paid. Things were going smoothly until one day I had a call to my manager’s office saying he will like to...

  • Hi, Kindly assist with my project management assignment below using the attached case study Question 1 Update the project charter for the remainder of the project in response to Adams’ memo (lines 241...

    Hi, Kindly assist with my project management assignment below using the attached case study Question 1 Update the project charter for the remainder of the project in response to Adams’ memo (lines 241 through 246). Question 2 Prepare a plan for the remainder of the project in response to Adams’ memo (lines 241 through 246). Your answers to the above will be assessed in terms of the level of communication displayed, the insights and inferences drawn, and your ability to...

  • What additional information, if any, should be obtained before making a final decision? Downtown Parking Authority In J...

    What additional information, if any, should be obtained before making a final decision? Downtown Parking Authority In January a meeting was held in the office of the mayor of Oakmont to discuss a unicipal parking facility. The participants included the mayor, the traffic proposca the administrator of Oakmont's Downtown Parking Authority, the city planner, and the finance director. The purpose of the meeting was to consider a report Richard Stockton, executive assistant to the Parking Authority's administrator, concerning estimated costs...

  • Sabrina Hoffman is founder and CEO of Golden Care, Inc., which owns and operates several assisted-living...

    Sabrina Hoffman is founder and CEO of Golden Care, Inc., which owns and operates several assisted-living facilities. The facilities are apartment-style buildings with 25 to 30 one- or two-bedroom apartments. While each apartment has its own complete kitchen, in every building Golden Care offers communal dining options and an on-site nurse who is available 24 hours a day. Residents can choose monthly meal options that include one or two meals per day in the dining room. Residents who require nursing...

  • Please read the facts of the case and prepare answers for the following questions : 1...

    Please read the facts of the case and prepare answers for the following questions : 1 – What is the relevance of the $2,000 monthly payment to Dave Verden on the analysis of Jones’ financing needs? 2 – What metrics could you use to compare the historical financial results for Jones with the projected financial results under the four defined scenarios? 3 – Other than financing needs, what other issues should Jones address as he considers the different growth scenarios?...

  • Read the attached article. Do you feel one style of banking control is more stable than...

    Read the attached article. Do you feel one style of banking control is more stable than the other? Why? Does one banking method minimize market volatility and risk better or is it just packaged differently? Do you feel the US (Western) Banking system can better control the patterns of behavior going forward that have caused economic damage in the past? Should the Fed continue its stimulus policy, reduce it or abandon it entirely (Google some recent articles to research this)?  (Please...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT