Question
Morehouse Investments Inc. is planning to buy and develop the Rufus M. Rose house located in the SoNo neighborhood of Atlanta. It is a Victorian
Morehouse Investments Inc. is planning to buy and develop the Rufus M. Rose house located in the SoNo neighborhood of Atlanta. It is a Victorian style house built in 1901 and is the last residence in the neighborhood. Ben Mays, the chairman, believes the house can be developed into apartments for the local doctors and medical professionals who work across the street at Emory University Hospital Midtown, the former Crawford Long Hospital. The current asking price for the house is $1.5 million and he expects to put 20% in a down payment for a 30 year loan. He assumes he would need to pay an extra 17% of the monthly payment per month to cover taxes and insurance. Mays is considering whether this is a good investment to make. From investigating various lending options, he believes the annual interest rate on his loan could be 3.0%, 3.15%, or 3.25%.
Having an architect take a quick glance at n the building, he has found it is possible to create either 6 apartments (3 that are 2BD/2Ba and 3 that are 1 BD/1BA) or 8 apartments (2 that are 2 BD/2 BA and 6 that are 1 BD/1 BA). Data on the next page shows the cost of apartments in various neighborhoods. A model can be created to ascertain the average rental cost of an apartment in a normal market as related to three variables: number of bedrooms, number of bathrooms, and a binary variable that denotes if it is an established neighborhood or up and coming. (When predicting the rent, assume the SoNo neighborhood is up and coming so put a 1 in for that variable.) Also, if he did the 8 apartments, the 1 BD/ 1BA apartments would be smaller and would always rent for 10% less. You are also expected to measure the impact the rental market will have on the investment. The model creates a forecast for a normal market. In a good market, the apt rents would be 20% higher and in a poor market, the apt rents would be 15% lower.
Mays wants you to create an Excel spreadsheet model demonstrating how all of the options (layout, interest rates, apt market) would affect his monthly profit or loss. He should be able to look at the first sheet and clearly see what would happen if each condition mentioned is in place and he should be able to change the inputs to immediately see what the impact would be. (For example, if one of the interest rates were to change to 6%, what would happen?) The calculations should be shown on another sheet but marked in a way that he checks them for accuracy if he so chooses. Create a graph showing the monthly profit of the various options.
You should submit the Excel model for the investment using BlackBoard by beginning of class. on Wednesday, November 17, 2021.
| Neighborhood | Rent | # of Bathrooms | # of Bedrooms | Up and Coming? |
| Sylvan Hills | $830 | 2 | 2 | 1 |
| NoNo | $900 | 2 | 1 | 1 |
| Midtown | $1100 | 2 | 2 | 0 |
| Midtown | $920 | 1 | 1 | 0 |
| NoNo | $975 | 2 | 1 | 1 |
| VaHi | $1150 | 2 | 2 | 0 |
| Buckhead | $1400 | 2 | 2 | 0 |
| Buckhead | $1000 | 1 | 1 | 0 |
| Buckhead | $1050 | 1 | 1 | 0 |
| Sylvan Hills | $500 | 1 | 1 | 1 |
| Midtown | $850 | 1 | 1 | 0 |
| Midtown | $1220 | 2 | 2 | 0 |
| NoNo | $1100 | 2 | 1 | 1 |
| West Atlanta | $1200 | 2 | 2 | 1 |
| West Atlanta | $1000 | 1 | 1 | 1 |
| West Atlanta | $950 | 1 | 1 | 1 |
| VaHi | $875 | 1 | 1 | 0 |
| VaHi | $940 | 2 | 1 | 0 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Smith and Roberson Business Law
Authors: Richard A. Mann, Barry S. Roberts
15th Edition
1285141903, 1285141903, 9781285141909, 978-0538473637
