# Question: You know that in one year you are going to

You know that in one year you are going to buy a house. The annual interest rate for fixed-rate 30-year mortgages is currently 6.00%, and the price of the type of house you are considering is $120,000. However, things may change. Using your knowledge of the economy (and a crystal ball), you estimate that the interest rate might increase or decrease by as much as one percentage point. Also, the price of the house might increase by as much as $10,000—it certainly won’t decrease. You assess the probability distribution of the interest rate change as shown in the file S04_39.xlsx. The probability distribution of the increase in the price of the house is also shown in this file. Finally, you assume that the two random events are probabilistically independent. This means that the probability of any joint event, such as an interest increase of 0.50% and a price increase of $5000, is the product of the individual probabilities.

a. Using Excel’s PMT function, find the expected monthly house payment (using a 30-year fixed-rate mortgage) if there is no down payment. Find the variance and standard deviation of this monthly payment.

b. Repeat part a, but assume that the down payment is 10% of the price of the house (so that you finance only 90%).

c. Is the independence assumption realistic?

a. Using Excel’s PMT function, find the expected monthly house payment (using a 30-year fixed-rate mortgage) if there is no down payment. Find the variance and standard deviation of this monthly payment.

b. Repeat part a, but assume that the down payment is 10% of the price of the house (so that you finance only 90%).

c. Is the independence assumption realistic?

**View Solution:**## Answer to relevant Questions

A typical consumer buys a random number (X) of polo shirts when he shops at a men’s clothing store. The distribution of X is given by the following probability distribution: P(X = 0) = 0.30, P(X = 1) = 0.30, P(X = 2) = ...A film-processing shop charges its customers 18 cents per print, but customers may refuse to accept one or more of the prints for various reasons. Assume that this shop does not charge its customers for refused prints. The ...The weekly demand function for one of a given firm’s products can be represented by q = 200 - 5p, where q is the number of units purchased (in hundreds) at price p (in dollars). Assume that the price of the product will be ...The probability distribution of the weekly demand for copier paper (in hundreds of reams) used in the duplicating center of a corporation is provided in the file S04_58.xlsx. Assuming that it costs the duplicating center $5 ...You are involved in a risky business venture where three outcomes are possible: (1) You will lose not only your initial investment ($5000) but an additional $3000; (2) You will just make back your initial investment (for a ...Post your question