Data were collected from a random sample of 230 home sales from a community in 2003. Let Price denote the selling price (in $1,000), BDR denote the number of bedrooms, Bath denote the number of bathrooms, Hsize denote the size of the house (in square feet), Size denote the lot size (in square feet), Age denote the age of the house (in years), and Poor denote a binary variable that is equal to 1 if the condition of the house is reported as "poor." An estimated regression yields ModifyingAbove Price with caret equals 118.0 plus 0.480 BDR plus 23.2 Bath plus 0.154 Hsize plus 0.002 L'Size plus 0.089 Age minus 48.3 Poor comma Upper R overbar squared equals 0.71 comma SER equals 41.1. Suppose that a homeowner converts part of an existing family room in her house into a new bathroom. What is the expected increase in the value of the house?

Variable rate cd’s = $90 treasury bills = $150 discount loans = $20 treasury notes = $100 fixed rate cds = $160 money market deposit accts. = $140 savings deposits = $90 fed funds borrowing = $40 variable rate mortgage loans $140 demand deposits = $40 primary reserves = $50 fixed rate loans = $210 fed funds lending = $50 equity capital = $120 a. develop a balance sheet from the above data. be sure to divide your balance sheet into rate-sensitive assets and liabilities as we did in class and in the examples. b. perform a standard gap analysis and a duration analysis using the above data if you have a 1.15% decrease in interest rates and an average duration of assets of 5.4 years and an average duration of liabilities of 3.8 years. c. indicate if this bank will remain solvent after the valuation changes. if so, indicate the new level of equity capital after the valuation changes. if not, indicate the amount of the shortage in equity capital.