Obtain the principle amount repaid during years 7 and 8 of $425000 mortgage when n= 20...

Obtain the principle amount repaid during years 7 and 8 of $425000 mortgage when n= 20 and k=8.5%, assuming monthly compounding. (Explain how you get the numbers for P1 AND P2)

Solutions

Expert Solution

Monthly payment is calculated using PMT function in Excel with these inputs :

rate = 8.5% / 12 (converting the annual interest rate into monthly rate)

nper = 20 * 12 (20 year loan * 12 months per year)

pv = -425,000 (mortgage amount)

PMT is calculated to be $3,688.25

Interest in any month = principal outstanding at beginning of month * 8.5% / 12

Principal portion of monthly payment = monthly payment minus interest portion of payment

principal outstanding at end of month = principal outstanding at beginning of month minus principal portion of monthly payment

In this way we calculate the mortgage schedule

Principle amount repaid during years 7 = $707

Principle amount repaid during years 8 = $712

jeff jeffy answered 1 year ago

Next > < Previous

Related Solutions

When a mortgage is for 15 years at a 4.5% interest and the amount borrowed is...

When a mortgage is for 15 years at a 4.5% interest and the amount borrowed is $200,000 and closing costs are 4% of the new mortgage paid at closing by the buyer what is the...a) monthly mortgage principal and interest payment. b) balance of the mortgage after 5 years? c) total interest paid on the mortgage over ther 15 years? d) what is the first year's total mortgage interest tax deduction, if this is a home? e) what are the...

A loan of amount L is to be repaid by n(n > 1) payments, starting one...

A loan of amount L is to be repaid by n(n > 1) payments, starting one period after the loan is made, with interest at rate i per period. Two repayment schemes are considered: (i) level payments for the lifetime of the loan; (ii) each payment consists of principal repaid of L n plus interest on the previous outstanding balance. (a) Find the total interest repaid under each scheme and show algebraically that the interest paid under scheme (i) is...

WellsBargo offer a mortgage of $250,000 payable over 20 years with APR of 8%. What is...

WellsBargo offer a mortgage of $250,000 payable over 20 years with APR of 8%. What is the annual mortgage payment? SunBust offers a mortgage of $X also payable over 20 years with APR of 7%. You now the yearly mortgage payment for this option is $1,532 less than the WellsBargo option. What is the original amount of the mortgage from SunBust?

A 20-year, $ 490,000 mortgage at 4.20\% compounded annually is repaid wit monthly payments . a....

A 20-year, $ 490,000 mortgage at 4.20\% compounded annually is repaid wit monthly payments . a. What is the size of the monthly payments ? Round to the nearest cent. b. Find the balance of the mortgage at the end of 5 years 00 Round to the nearest cent c. By how much did the amortization period shorten by if the monthly payments are increased by $ 200 at the end of year five

Assume Sam borrowed $120,000 for a home mortgage, to be repaid at 8% interest over 3...

Assume Sam borrowed $120,000 for a home mortgage, to be repaid at 8% interest over 3 years with monthly payments. How many monthly payments does Sam has to pay for 3 year? How much is the monthly payment? How much is the interest payment for the third month? How much interest is paid over the life of the loan? Hint: Annual percentage rate (APR) = ?? Monthly discount rate (rate) = ?? Number of payment (Nper) = ?? Monthly payment...

8. (20 pts) a. RSA encryption. Let n = pq = (7)(17) = 119 and e...

8. (20 pts) a. RSA encryption. Let n = pq = (7)(17) = 119 and e = 5 define a (very modest) RSA public key encryption. Since 25 < 119 < 2525, we can only encode one letter (two digit representation) at a time. Use the function ? = ? mod ? to encode the word MATHY into a series of five numbers that are less than n. b. To decrypt an RSA encrypted message, we need to find d,...

You borrowed an X amount of money from a local bank to be repaid over N...

You borrowed an X amount of money from a local bank to be repaid over N months at an interest rate i (assume your own numbers for X, i, N). Create a table (using Excel) showing each month’s interest in $ (I), principal repayment, and amount of principal remaining at the end of each month. Suppose that you decided to pay out the remaining principal all at once after few monthly payments (< N), how much will you pay? Use...

You borrowed an X amount of money from a local bank to be repaid over N...

you are taking out a $100,000 mortgage loan to be repaid over 25 years in 300...

you are taking out a $100,000 mortgage loan to be repaid over 25 years in 300 monthly payments. a. if the interest rate is 16% per year, what is the amount of the monthly payment? b. if you can only afford to pay $1000 per month, how large a loan can you take? c. if you can afford to pay $1500 per month and need to borrow $100,000, how many months would it take to pay the mortgage? d. if...

A $ 120 000.00 mortgage is amortized over 20 years. If interest on the mortgage is...

A $ 120 000.00 mortgage is amortized over 20 years. If interest on the mortgage is 6.5% compounded semi-annually, calculate the size of monthly payments made at the end of each month.

Subjects