80.2K

Verified Solution

Link Copied!

historical maximum 15 year mortgage rate?

time for the max?

historical minimum 15 year mortgage rate ?

time for the min?

median mortgage rate ?

mean or average mortgage rate ?

assume a 15 year fixed rate mortgage loan is 250,000

caluculate monthly mortgage payment based on :

historical maximum mortgage rate

most recent mortgage rate

Merge & Center Ba $ % 9 lil 39 BIU conditional Formatting Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates 010 x x C D E 1 Name: 2 3 Estimate mortgage payments 4 Fill in the blue color cells 5 Use the given inputs in the previous worksheet to do the calculations. 6 Turn in this file to Canvas "Assignments" 7 3.18 9 10 Most recent 15-year mortgage rate: 11 12 Historical maximum 15-year mortgage rate: 13 Time for the max: 14 15 Historical minimum 15-year mortgage rate: 16 Time for the min: 17 18 Median mortgage rate: 19 Mean (or average) mortgage rate: 20 21 Assume a 15-year fixed rate mortgage loan: 22 Calculate monthly mortgage payment based on: 23 historical maximum mortgage rate 24 most recent mortgage rate 25 26 27 S 250,000 PMT (monthly) inputs mortgage paymits Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates, D12 x x D 1 http://www.freddiemac.com/pms/mmsis.html 2 3 CONVENTIONAL, CONFORMING 15-YEAR FIXED-RATE MORTGAGE SERIES SINCE 1991 4 5 6 Sep-1991 8.69 7 Oct-1991 8.49 8 Nov. 1991 8.33 Dec-1991 8.07 10 Jan-1992 8.01 11 Feb-1992 8.38 12 Mar.1992 8.58 13 Apr 1992 8.47 14 May-1992 8.29 15 Jun-1992 8.08 16 Jul-1992 7.67 17 Aug-1992 7.49 18 Sep-1992 7.41 19 Oct-1992 7.55 20 Nov-1992 7.8 21 Dec-1992 7.742 Jan-1993 7.51 Feb-1993 7.17 24 Mar-1993 7 25 Apr-1993 6.9425 26 May-1993 6.93 27 Jun-1993 6.92 Jul-1993 6.72 29 Aug-1993 6.63 30 Sep-1993 6.43 Oct-1993 6.374 32 Nov-1993 6.6875 33 Dec-1993 6.682 34 Jan-1994 6.565 35 Feb-1994 6.655 36 Mar 1994 7.1825 Apr-1994 7.8 38 May 1994 3.0775 39 Jun 1994 7.91 40 Jul 1994 8.11 Aur.1994 inputs mortgage payments + Ready B D E 8 9 -0 51 52 53 54 55 56 57 58 59 60 61 52 63 64 Aug-1994 Sep-1994 Oct-1994 Nov-1994 Dec-1994 Jan-1995 Feb-1995 Mar-1995 Apr-1995 May-1995 Jun-1995 Jul-1995 Aug-1995 Sep-1995 Oct-1995 Nov-1995 Dec-1995 Jan-1996 Feb-1996 Mar-1996 Apr-1996 May-1996 Jun-1996 Jul-1996 Aug-1996 Sep-1996 Oct-1996 Nov-1996 Dec-1996 Jan-1997 Feb-1997 Mar-1997 Apr-1997 May 1997 Jun-1997 Jul-1997 Aug-1997 Sep-1997 Oct-1997 Nov-1997 Dec-1997 8.02 8.13 8.39 8.67 8.8 8.8 8.46 8.06 7.88 7.51 7.06 7.09 7.36 7.16 7.0075 6.8875 6.736 6.545 6.56 7.114 7.44 7.578 7.8325 7.7675 7.518 7.7525 7.43 7.142 7. 0975 7.328 7.15 7.405 7.675 7.472 7.235 7.04 7.016 6.9875 6.848 5.76 6.6625 65 66 67 68 69 70 71 72 73 74 25 76 77 78 79 BO inputs mortgage payments Ready Mace B D E 5 8 9 00 01 02 Dec-1997 Jan-1998 Feb-1998 Mar-1998 Apr-1998 May-1998 Jun-1998 Jul-1998 Aug-1998 Sep-1998 Oct-1998 Nov-1998 Dec-1998 Jan-1999 Feb-1999 Mar-1999 Apr-1999 May-1999 Jun-1999 Jul-1999 Aug-1999 Sep-1999 Oct-1999 Nov-1999 Dec-1999 Jan-2000 Feb-2000 Mar-2000 Apr-2000 May-2000 Jun-2000 Jul-2000 Aug-2000 Sep-2000 Oct-2000 Nov-2000 Dec-2000 Jan-2001 Feb-2001 Mar-2001 Ar-2001 6.6625 6.576 6.6375 6.7425 6.78 6.784 6.6675 6.624 6.6125 6.4025 6.364 6.505 6.39 6.425 6.4375 6.675 6.528 6.7475 7.1775 7.256 7.5275 7.4425 7.466 7.355 7.52 7.8 793 7.83 7.8 8.18 7.99 7.87 7.7625 7.6 7.47 7.42 7.06 6.64 6.64 6.51 6.6 03 104 205 106 107 108 109 110 112 113 115 116 117 119 120 121 inputs mortgage payments + Ready

Answer & Explanation Solved by verified expert

See Answer