solved “You are the analyst. There are not necessarily any right
“You are the analyst. There are not necessarily any right or wrong answers as long as you can justify the information you are using.This assignment is to present you with the information that you may have in a real world situation. In the real world, at a real job, you always have incomplete information. There isn’t anyone to go to and ask to be provided variables to be input into a model. Variables such as cap rate, risk free rate, etc…. Things that have to be looked up and or estimates by you, the analyst. As such, you have to do you best to figure things out with the information that is provided. You can use what is provided to fill out as much as you can, but you can also do your own research and determine some of the other variables and one’s that the Google Doc does not give you. In the files you submit to me, explain any of your own research and how you arrived at anything you use in the model. This is how you would do it in a real job. You’d do all of your own research, come up with your own estimates for everything in the model, and then explain it in a report / presentation. I’m not making you research every single variable, but anything I don’t give you should be found on your own. Also, if you disagree with any of the estimates of rents or anything else that I do provide you can do your own research here as well and change the estimates. Just provide your research and explain it.So, what am I saying? You can absolutely use the numbers provided in the Google doc. Any numbers you cannot extract from the Google doc you can definitely research on your own and input. The overall instructions for the assignment are contained in the Google doc. You are essentially analyzing two different options for the this property. This is why you will submit two separate Excel spreadsheets. In one, you analyze “Option #1â€. In the other, you analyze “Option #2â€. Most of option number 2 will be the same as option #1 but there are some things that you will change and will be different. You, as the analyst, need to look at both options and evaluate them. Which one makes the most sense? Is it worth it to spend the extra money for option #2? At the very bottom of the Case Study Google Doc are a bunch of questions you should ask yourself while analyzing the two options for the property. You will write about these in a word document and submit this along with the two excel files (one file for each of the two options).”