In this selection, 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 Janes 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.

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