Blinder assumes that John and Jane take out a mortgage with a 20% down payment to invest in a $200,000 house that they expect to appreciate 20% over five years. In calculating their ROE over the period, Blinder ignores the interest they have to pay on the mortgage, which is like treating the borrowing rate as zero.

Question 1 . In the second worksheet in the Excel spreadsheet, show what John and Jane?s ROE would be under three different assumptions about the borrowing rate: a) a rate of zero, as effectively assumed by Blinder; b) a rate of 10%; and c) a rate of 20%, the same as the housing inflation rate. (To make things simple, assume that these are one-year rates and that the length of the period is one year instead of five years.) ? This requires you to fill in columns E to G in the worksheet. (COMPLETED)

part 2 . Blinder uses this example to argue that the opportunity to make big profits from leverage contributed to the housing bubble. Based on your answer to Question 1, does the example support his argument? Explain. (Hint: If the borrowing rate equals the rate of housing inflation, would John and Jane do better taking out the mortgage than paying for the house entirely with their own money?)

part 3: Answer Question 1 assuming that John and Jane make a down payment of $20,000 instead of $40,000 (i.e., higher leverage). This requires you to fill in columns I to K in the worksheet. (COMPLETED )

part 4: Based on your answer to Questions 1-3, is the relationship between leverage and ROE the same as in Part 1 of this assignment, once we take into account the borrowing rate? Explain.

AutoSave On File Home F2 3 4 4 1 Cost of house 2 5 6 7 8 9 10 11 12 13 11 14 15 16 17 17 18 19 20 21 22 23 24 25 26 27 28 22. Insert Page Layout Formulas Data Review View E I > 200,000 =$B$2-E2 B EOY house price Down payment1 Borrowing rate 40,000 240,000 0.00 0.10 0.20 Admati example Blinder example1 Type here to search (+) O Help At assignment 1 fin 340- Last Saved 11/21/2019 1:46 PM Tell me what you want to do. Acrobat E Amt. owed1 n 160,000 176,000 192,000 x] Final equity1 80,000 64,000 48,000 ROE1 (%) 100% 60% 20% I H Down payment2 Amt. owed2 20,000 180,000 198,000 216,000 A Bart abuoun J Final equity2 60,000 42,000 24,000 D M P Share K ROE2 (%) 200% 110% 20% - ^) ENG Comments L 5:48 PM 11/24/2019 + 120% E