Consider a 6%, 30 year, $200,000 level payment mortgage with a monthly payment of $1,199.10. Assume...

Consider a 6%, 30 year, $200,000 level payment mortgage with a monthly payment of $1,199.10. Assume up front financing cost (includes all costs paid to the lender and third parties except discount points) equal $3,000.
1. Find the EBC if the borrower repays the loan after two years (assuming no direct points).
2. What is the EBC if the lender charges one discount point?
3. What is the EBC if the lender charges 2.5 discount point?

Expert Solution

Month	Opening Loan O/s	Interest	Opening Loan o/s + interest	Monthly Payment	Closing Loan O/s
	A	B	C= A+B	D	E = C + D
1	2,00,000.00	1,000.00	2,01,000.00	-1,199.10	1,99,800.90
2	1,99,800.90	999.00	2,00,799.90	-1,199.10	1,99,600.80
3	1,99,600.80	998.00	2,00,598.81	-1,199.10	1,99,399.71
4	1,99,399.71	997.00	2,00,396.71	-1,199.10	1,99,197.61
5	1,99,197.61	995.99	2,00,193.60	-1,199.10	1,98,994.50
6	1,98,994.50	994.97	1,99,989.47	-1,199.10	1,98,790.37
7	1,98,790.37	993.95	1,99,784.32	-1,199.10	1,98,585.22
8	1,98,585.22	992.93	1,99,578.15	-1,199.10	1,98,379.05
9	1,98,379.05	991.90	1,99,370.94	-1,199.10	1,98,171.84
10	1,98,171.84	990.86	1,99,162.70	-1,199.10	1,97,963.60
11	1,97,963.60	989.82	1,98,953.42	-1,199.10	1,97,754.32
12	1,97,754.32	988.77	1,98,743.09	-1,199.10	1,97,543.99
13	1,97,543.99	987.72	1,98,531.71	-1,199.10	1,97,332.61
14	1,97,332.61	986.66	1,98,319.27	-1,199.10	1,97,120.17
15	1,97,120.17	985.60	1,98,105.77	-1,199.10	1,96,906.67
16	1,96,906.67	984.53	1,97,891.21	-1,199.10	1,96,692.11
17	1,96,692.11	983.46	1,97,675.57	-1,199.10	1,96,476.47
18	1,96,476.47	982.38	1,97,458.85	-1,199.10	1,96,259.75
19	1,96,259.75	981.30	1,97,241.05	-1,199.10	1,96,041.95
20	1,96,041.95	980.21	1,97,022.16	-1,199.10	1,95,823.06
21	1,95,823.06	979.12	1,96,802.17	-1,199.10	1,95,603.07
22	1,95,603.07	978.02	1,96,581.09	-1,199.10	1,95,381.99
23	1,95,381.99	976.91	1,96,358.90	-1,199.10	1,95,159.80
24	1,95,159.80	975.80	1,96,135.60	-1,199.10	1,94,936.50
	Total	23,714.90		-28,778.40

Effective Borrowing Cost ('EBC' if no discount and loan is repaid in 2 years) = Interest cost + Front Financing Cost + Direct Cost = $ 23,714.90 + $ 3,000 + 0 = $ 26,714.90

Effective Borrowing Cost ('EBC' if one point discount and loan is repaid through the period) = Interest cost (calculated on basis of above table)+ Front Financing Cost + Direct Cost = $ 231,677.06 + $ 3,000 + ($ 200,000 * 1%) = $ 236,677.06

Effective Borrowing Cost ('EBC' if 2.5 discount and loan is repaid through the period) = Interest cost (calculated on basis of above table) + Front Financing Cost + Direct Cost = $ 231,677.06 + $ 3,000 + ($ 200,000 * 2.5%) = $ 239,677.06

jeff jeffy answered 1 year ago

1.(Level-Payment Mortgages) Compute the monthly payment on a 30-year level payment mortgage assuming an annual mortgage...

1.(Level-Payment Mortgages) Compute the monthly payment on a 30-year level payment mortgage assuming an annual mortgage rate of 5% and an initial mortgage principal of $400,000. (2147.29) 2.(Mortgage Pass-Throughs) Consider a $400 million pass-through MBS that has just been created (so the 'seasoning' of the pass-through is equal to 0). The underlying pool of mortgages each has a maturity of 20 years and an annual mortgage coupon rate of 6%. The pass-through rate of the mortgage pool is 5%. Assuming...

Assuming a 5/1 ARM, calculate the monthly mortgage payment on a 30 year $200,000 mortgage with...

Assuming a 5/1 ARM, calculate the monthly mortgage payment on a 30 year $200,000 mortgage with an initial rate of 2.75%, a rate of 4% at the time of the first adjustment, a rate of 5% at second adjustment and a rate of 4% at the third adjustment.

Consider a 30-year, traditional mortgage on a $200,000 property. With 30% down payment and a 4%...

Consider a 30-year, traditional mortgage on a $200,000 property. With 30% down payment and a 4% APR. Mortgage payments are made monthly. What is the 214th payment?

Consider a $329,000; 4.2%; 30 year mortgage. (monthly payment and monthly compounding). a. If a borrower...

Consider a $329,000; 4.2%; 30 year mortgage. (monthly payment and monthly compounding). a. If a borrower submits an extra $10,000 towards principal along with the 36th payment, and if all other payments are made according to schedule, what's the projected balance at the end of the 5th year? b. (Ignoring 5a) If you just turned 23 years old on the day this 30-year mortgage was originated, but would like to have the entire mortgage paid off by the time you...

A borrower takes out a 30-year price level adjusted mortgage loan for $200,000 with monthly payments....

A borrower takes out a 30-year price level adjusted mortgage loan for $200,000 with monthly payments. The initial interest rate is 4% with 4 points. Assuming that inflation is expected to increase at the rate of 3% for the next 5 years, and a fully amortizing loan is made. a) What is the monthly payment in year 2? b) What is the expected effective yield to the lender if the loan is repaid in 2 years?

Amortize a 30-year mortgage for a $200,000 house cost with a 20% down payment. The mortgage...

Amortize a 30-year mortgage for a $200,000 house cost with a 20% down payment. The mortgage interest rate is 4.125%. How much is the monthly payment? How much will the borrower pay in total interest?

What is the monthly mortgage payment on a $300,000 30 year fixed rate mortgage with an...

What is the monthly mortgage payment on a $300,000 30 year fixed rate mortgage with an interest rate of 5.125 percent. A friend who knows you have studied amortization asks your help to find the interest portion of their house payments for tax purposes (assuming they itemize). The monthly payments are $2,107.02 on a 30 year loan with a 5 percent interest rate. a) What was the total amount of interest paid during year 2? b) At what point in...

Suppose that a 15-year mortgage loan for $200,000 is obtained. The mortgage is a level-payment, fixed-rate,...

Suppose that a 15-year mortgage loan for $200,000 is obtained. The mortgage is a level-payment, fixed-rate, fully amortized mortgage and the mortgage rate is 7.0% (APR, monthly). a. Find the monthly mortgage payment. b. Compute an amortization schedule for the first six months. c. What will the mortgage balance be at the end of the 15th year? d. If an investor purchased this mortgage, what will the timing of the cash flow be assuming that the borrower does not default?

Assume a 30-year, $600,000, 6% mortgage with annual payments. 16. Assume the first payment beginning in...

Assume a 30-year, $600,000, 6% mortgage with annual payments. 16. Assume the first payment beginning in exactly one year, what is the annual payment? 17. What is the outstanding mortgage balance after you have made 10 payments? 18. If the loan calls for monthly payments, what is the monthly payment? Assume you have a 6% 30-year mortgage for $100,000 with now 10 years to maturity (annual payments with exactly one year to the next payment). You are considering a refinance...

You purchased a home 6 years ago using a 4% 30-year mortgage with a monthly payment...

You purchased a home 6 years ago using a 4% 30-year mortgage with a monthly payment of $1072.25. Assuming you want to pay off your mortgage today, how much would you have to pay the lender in order to pay off the outstanding balance on your mortgage loan? Round to the nearest dollar.

Question