Posted: May 28th, 2021


1. Download the monthly Case-Shiller house price index for Los Angeles from the St. Louis Fed (FRED II). Choose the version that is not seasonally adjusted, and get all data, from about 1987 through the last available data point.
2. [5 pts] Compute the monthly appreciation r tt+1 = (H t+1 – H t)/ H t. Extra points if you can show that the resulting time series is stationary.
3. [15 pts] Model the change in appreciation as an Orenstein-Uhlenbeck process (discretized version)
Δrt+1 = r tt+1 – r t = κ (ϑ – r t) Δt + σ Δt1/2 ε
where ε is a normally distributed variable with mean 0 and variance 1.
a. Do this in excel, by adding in the Analysis Tool pack from File>Options>Add-Ins. Use OLS regression, with y= r ttt+1 – r t and x = r t Δt, and identify the unknown parameters above (κ, and ϑ) from your linear regression result.
b. To compute σ, ask the regression to give you the residuals, find their standard deviation, and then divide the answer by Δt1/2
c. Since Δt = (1/12) years (monthly), your parameters will be annual numbers.
4. [15 pts] Create a set of 10,000 simulations of a monthly house price for 10 years using the equation and parameters in 3 above. Assume the starting price is $800,000.
a. Since you do not know the appreciation before t=0, “warm up” the data generating process with 1 years’ worth of appreciation before t=0 (you can start the warmup with r=0).
b. You can use either VBA, or simulate directly in the spreadsheet. When testing your work, use a smaller time frame (say 1 year) and fewer Monte Carlo simulations (say 100): 10 years’ worth of 10,000 simulations may take a while on your computer.
c. ε is a normal random draw with mean 0 and variance 1. To generate such a random draw, use the function norm.inv(rand(),0,1). Rand() generates a uniform random number between 0 and 1 (a random probability), and the function then returns a random draw from the normal distribution with mean 0 and variance 1.
d. Since every alteration to your spreadsheet will re-compute the random variable (potentially changing your results slightly), I suggest you switch off the automatic workbook calculation by going to file>options>formulas and selecting “manual.” To re-compute the workbook, you MUST then press “control =” or F9 to update formulae… don’t forget this. Also, best to set back to “automatic” when done with project. Apples may be different.
5. [20 pts] Suppose you wanted to buy this home with 10% down, and, to lower mortgage costs, you chose to get as an equity investor to provide another 10% (for a total of 20% down and 80% mortgage). Go to to find out how Unison computes its share of appreciation.
From your results in 4, create a frequency distribution of Unison’s return, compute their expected return and standard deviation of returns, and estimate the probability that Unison will lose money. Do this for the cases that the homeowner will pay back Unison after 1, 2, …,10 years (i.e., only at yearly anniversaries). 
6. [5 pts] Why do you think computes appreciation from a “risk adjusted basis,” that is smaller than the value of the home at origination, rather than the purchase price/valuation at origination?

Don't use plagiarized sources. Get Your Custom Essay on
Just from $13/Page
Order Essay

Expert paper writers are just a few clicks away

Place an order in 3 easy steps. Takes less than 5 mins.

Calculate the price of your order

You will get a personal manager and a discount.
We'll send you the first draft for approval by at
Total price: