Residential Underwriting & Valuation Assignment

Instructions:

1. Round all final dollar amounts to the nearest cent and don't enter the dollar sign. E.g. if the answer is $1,022.912, enter it as 1,022.91. Commas don't matter, hence you can also enter 1022.91.

2. Round all final percentages to the nearest basis point and don't enter the percent sign. E.g. if the answer is 17.238%, enter it as 17.24. If the answer is 0.52%, enter it as 0.52.

1. Which of the following does NOT affect your FICO score?

a) length of credit history

b) payment history

c) income

d) types of credit used

2. Jim has an annual income of $136,000. Apple bank has a maximum front end DTI limit of 26%, what is the most they will allow Jim to spend on monthly principal, interest, taxes and insurance?

3. Jim has an annual income of $136,000. Jim is looking to buy a house with monthly property taxes of $140 and monthly homeowner's insurance of $70. Apple bank has a maximum front end DTI limit of 26%, what is the most they will allow Jim to spend on a monthly mortgage?

4. Jim has an annual income of $136,000. Jim is looking to buy a house with monthly property taxes of $140 and monthly homeowner's insurance of $70. Jim has $1,500 in monthly student loan payments and an average monthly credit card bill of $500. Apple bank has a maximum back end DTI limit of 41%. Given the back end DTI constraint, what is the most they will allow Jim to spend on a monthly mortgage payment?

5. Jim has an annual income of $136,000. Jim is looking to buy a house with monthly property taxes of $140 and monthly homeowner's insurance of $70. Jim has $1,500 in monthly student loan payments and an average monthly credit card bill of $500. Apple bank has a maximum front end DTI limit of 26% and a maximum back end DTI limit of 41%. Given both limits, what is the most they will allow Jim to spend on a monthly mortgage payment?

6. Jim has an annual income of $136,000. Jim is looking to buy a house with monthly property taxes of $140 and monthly homeowner's insurance of $70. Jim has $1,500 in monthly student loan payments and an average monthly credit card bill of $500. Apple bank has a maximum front end DTI limit of 26% and a maximum back end DTI limit of 41%. Both limits must be satisfied. Apple bank is offering a fully amortizing 30 year FRM at an annual rate of 5%, with monthly payments, compounded monthly. What is the biggest loan Jim can get?

7. Jim has an annual income of $136,000. Jim is looking to buy a house with monthly property taxes of $140 and monthly homeowner's insurance of $70. Jim has $1,500 in monthly student loan payments and an average monthly credit card bill of $500. Apple bank has a maximum front end DTI limit of 26% and a maximum back end DTI limit of 41%. Both limits must be satisfied. Apple bank is offering a fully amortizing 30 year FRM at an annual rate of 5%, with monthly payments, compounded monthly. Apple Bank allows a maximum LTV of 80%. What is the most Jim can spend on a house?

8. Sam bought a house that costs $130,000. Sam got a 96% LTV loan. The lender demanded that Sam buy private mortgage insurance to insure the portion of the loan over 75% LTV. Suppose 5 years later, Sam's mortgage balance is $120,000. However Sam defaults and his house sells for $60,000 in a foreclosure auction. How much will the mortgage insurance company pay Sam's lender? Review LLPA on slide 34

9. Tom paid $10k in mortgage interest and $4k in property taxes last year. His average tax rate is 20%, his marginal tax rate is 35%. Compute Tom's tax shield from the mortgage interest and property tax deduction.

10. Jill buys a house for $100k, lives there for exactly 10 years and sells it. Suppose Jill's annual cost of ownership is exactly equal to the annual rent she would have paid to live in the same house. Suppose the price of Jill's house grows 4.5% annually. Suppose selling expenses are 8% of the sale price. Compute Jill's annual IRR from owning net of renting. (Hint: look at the last equation on slide 20, assume there is no mortgage or buying expense.)