([ cellreference1 ]=[ cellreference2 ], “ yes ”, “ B u s i n e s s F i n a n c e

([ cellreference1 ]=[ cellreference2 ], “ yes ”, “ B u s i n e s s F i n a n c e

Homework #1

Please make sure you have 3 excel files named Question 1 Data, Question 2 Data and Question 3 Data that accompanies this Homework. Question 2 Data has two tabs in it.

Question 1: Referring to the file Question 1 Data.xls, suppose you want to purchase a home in bay area and have started to shop. Your budget is strictly fixed (<$1.2 Million) and you have the statistics mentioned in the data.

You also have access from the website