Obtain the principle amount repaid during the last ten years of a $425,000 mortgage when N=20 and k=8.5%, assuming monthly compounding. (SHOW WORKING FOR EACH STEP) Also please explain how P1 is equal to 121.
Original Mortgage Amount = $ 425000, Mortgage Tenure = N = 20 years or (12 x 20) = 240 months, Interest Rate = 8.5 % per annum
Monthly Interest Rate = (8.5 / 12) = 0.7083 %
Let the monthly mortgage repayments be $ P
Therefore, 425000 = P x (1/0.007083) x [1-{1/(1.007083)^(240)}]
425000 = P x 115.234
P = 425000 / 115.234 = $ 3688.15
Assuming that the entire original mortgage amount is completely repaid during the 20 year mortgage tenure, the amount of principal repaid in the last ten years should equal the portion of the original mortgage outstanding as of the end of Year 10.
Principal Outstanding at the end of Year 10 = Principal Repaid in the last 10 years = Present Value of Remaining Monthly Mortgage Repayments at the end of Year 10 = 3688.15 x (1/0.007083) x [1-{1/(1.007083)^(120)}] = $ 297470.72
Obtain the principle amount repaid during the last ten years of a $425,000 mortgage when N=20 and...
DQuestion 4 1 pts What will be the mortgage balance remaining on a loan of $ 227993 with a 33-year term monthly compounding) and k 0.055 after 24 end-of-month payments have been made? Round your final answer to 2 decimal places. DQuestion 5 1 pts Obtain the total interest paid during the last ten years of a $ 528397 mortgage when n- 20 and k-0.076, assuming monthly compounding (end of month payments) Round your final answer to 2 decimal places.
Agatha takes out a $150, 000 mortgage which is to be repaid in 20 years by monthly payments at 7% convertible monthly. The first payment is due in one month after the mortgage is taken out. After 10 years she refinances the mortgage at 5% convertible monthly and agrees to pay the remaining amount by monthly payments in 5 years. Find the size of her new payment Please show full detailed steps, thank you!
Ten years ago you obtained a 30-year mortgage for $400,000 with a fixed interest rate of 3% APR compounded monthly. The mortgage is a standard fixed rate mortgage with equal monthly payments over the life of the loan. What are the monthly fixed mortgage payments on this mortgage (i.e., the minimum required monthly payments to pay down the mortgage in 30 years)? What is the remaining loan balance immediately after making the 120th monthly payment (i.e., 10 years after initially...
Robert Johnson is 25 years old. He and his wife Jane have two children, Emmitt and Patricia, ages 2 and 4 respectively. Robert wants to retire in 40 years and build boats. He would like a nice retirement home with some land on a peaceful lake in the mountains of Georgia. Robert believes that to purchase a home and lot in 40 years would cost $300,000 in today’s prices. In forty years Robert also believes he and Patricia can live...
Jimmy and Jane Have Goals Jimmy Johnson is 25 years old. He and his wife Jane have two children, Emmitt and Patricia, ages 2 and 4 respectively. Jimmy wants to retire in 40 years and build boats. He would like a nice retirement home with some land on a peaceful lake in the mountains of Georgia. Jimmy believes that to purchase a home and lot in 40 years would cost $300,000 in today’s prices. In forty years Jimmy also believes...
Jimmy and Jane Have Goals Jimmy Johnson is 25 years old. He and his wife Jane have two children, Emmitt and Patricia, ages 2 and 4 respectively. Jimmy wants to retire in 40 years and build boats. He would like a nice retirement home with some land on a peaceful lake in the mountains of Georgia. Jimmy believes that to purchase a home and lot in 40 years would cost $300,000 in today’s prices. In forty years Jimmy also believes...
a. Find the FV of $1,000 invested to earn 10% annually 5 years from now. Answer this question by using a math formula and also by using the Excel function wizard. Inputs: PV = 1000 I/YR = 10% N = 5 Formula: FV = PV(1+I)^N = Wizard (FV): $1,610.51 Note: When you use the wizard and fill in the menu items, the result is the formula you see on the formula line if you click on cell E12. Put the...
Time Value of Money Spreadsheet Example 4 Module IV Name: Date: 6 7 8 Question 1 9 Question 2 10 Question 3 11 Question 4 12 Question 5 13 Question 6 14 Question 7 15 Question 8 16 Question 9 17 Question 10 18 19 20 Single Amount or Annuity 21 Periodic Interest Rate 22 Number of Periods 23 24 25 Present Value of Single Amount 26 27 Future Value of Single Amount 28 29 Future Value of An Annuity...
I need help on question 2.
MODULE IV: TIME VALUE OF MONEY INTRODUCTION The time value of money analysis has many a lysis has many applications, ranging from setting hedules for paying off loans to decisions about whether to invest in a partie financial instrument. First, let's define the following notations: I = the interest rate per period Na the total number of payment periods in an annuity PMT = the annuity payment made each period PV = present value...
avakis FN 305-Foundations of Finandal Management Soring 2019- Final Exam Student: Directions: Complete all answers on separate paper. Use pencil for all problems. Show the formula first and can check your answer with the financial calculator, but do not just write down a number you got from your calculator. The problems count 23 points each and the discusslon question counts 39 points for a total of 200 points. Use a pen to write the discussion question. (Assume 365 days per...