Question

In: Finance

What must be the end-of-the-month mortgage payment amount required to repay a loan of $52000 in...

What must be the end-of-the-month mortgage payment amount required to repay a loan of $52000 in 25 years? Assume k = 0.12 with monthly compounding.

Round your final answer to 2 decimal places.

Solutions

Expert Solution

Monthly rate(M)= yearly rate/12= 1.00% Monthly payment= 5514.76
Month Beginning balance (A) Monthly payment Interest = M*A Principal paid Ending balance
1 525000.00 5514.76 5250.00 264.76 524735.24
2 524735.24 5514.76 5247.35 267.41 524467.83
3 524467.83 5514.76 5244.68 270.08 524197.74
4 524197.74 5514.76 5241.98 272.79 523924.96
5 523924.96 5514.76 5239.25 275.51 523649.44
6 523649.44 5514.76 5236.49 278.27 523371.17
7 523371.17 5514.76 5233.71 281.05 523090.12
8 523090.12 5514.76 5230.90 283.86 522806.26
9 522806.26 5514.76 5228.06 286.70 522519.56
10 522519.56 5514.76 5225.20 289.57 522229.99
11 522229.99 5514.76 5222.30 292.46 521937.53
12 521937.53 5514.76 5219.38 295.39 521642.14

.

.

.

292 47239.56 5514.76 472.40 5042.37 42197.19
293 42197.19 5514.76 421.97 5092.79 37104.40
294 37104.40 5514.76 371.04 5143.72 31960.68
295 31960.68 5514.76 319.61 5195.16 26765.52
296 26765.52 5514.76 267.66 5247.11 21518.42
297 21518.42 5514.76 215.18 5299.58 16218.84
298 16218.84 5514.76 162.19 5352.57 10866.26
299 10866.26 5514.76 108.66 5406.10 5460.16
300 5460.16 5514.76 54.60 5460.16 0.00
Where
Interest paid = Beginning balance * Monthly interest rate
Principal = Monthly payment – interest paid
Ending balance = beginning balance – principal paid
Beginning balance = previous Month ending balance

Related Solutions

3) What payment is required at the end of each month for 3 years to repay...
3) What payment is required at the end of each month for 3 years to repay a loan of $8000.00 at 6.4% compounded monthly?
If you borrow a principal amount of $11,778 and are required to repay the loan in...
If you borrow a principal amount of $11,778 and are required to repay the loan in ten equal installments of $2,000, what is the interest rate associated with the loan?
What amount of interest is paid in month 31 of a partially amortizing mortgage loan for...
What amount of interest is paid in month 31 of a partially amortizing mortgage loan for $200,000 at 8% interest for 20 years with an agreed-upon balloon payment of $40,000 at maturity? Enter your answer rounded to the nearest penny with no punctuation other than a decimal point.
What is the monthly payment required to fulling amortize a $300,000 mortgage loan over a 30...
What is the monthly payment required to fulling amortize a $300,000 mortgage loan over a 30 years at an intrest rate of 3.5% annual rate compound monthly? $1,244 $1,367 $1,482 $1,390 $1,344
a $30000 5-year payment loan with level payment payable at the end of each month. (i)...
a $30000 5-year payment loan with level payment payable at the end of each month. (i) Calculate the level payment of each month with loan interest of 8% effective monthly. (ii) Calculate the loan balance at the end of month 3 after the third loan payment is made by using retrospective method. (iii) Calculate the loan balance at the end of month 3 after the third loan payment is made by using prospective method. (iv) what is total interest paid...
A borrower took out a loan of 100,000 and promised to repay it with a payment...
A borrower took out a loan of 100,000 and promised to repay it with a payment at the end of each year for 30 years. The amount of each of the first ten payments equals the amount of interest due. The amount of each of the next ten payments equals 150% of the amount of interest due. The amount of each of the last ten payments is X. The lender charges interest at an annual effective rate of 10%. Calculate...
A borrower took out a loan of 100,000 and promised to repay it with a payment...
A borrower took out a loan of 100,000 and promised to repay it with a payment at the end of each year for 30 years. The amount of each of the first ten payments equals the amount of interest due. The amount of each of the next ten payments equals 150% of the amount of interest due. The amount of each of the last ten payments is X. The lender charges interest at an annual effective rate of 10%. Calculate...
Loan payment:   Determine the​ equal, annual,​ end-of-year payment required each year over the life of the...
Loan payment:   Determine the​ equal, annual,​ end-of-year payment required each year over the life of the loan shown in the following table to repay it fully during the stated term of the loan.  ​(Click on the icon located on the​ top-right corner of the data table below in order to copy its contents into a​ spreadsheet.) Loan: Principal: Interest rate: Term of loan (years): A $12,000 8%    3 B $60,000 12% 10 C $75,000 10%    30 D $4,000...
Tedros borrowed $2 million and planned to repay the loan by making equal month-end payments over...
Tedros borrowed $2 million and planned to repay the loan by making equal month-end payments over a period of 10 years. The interest rate on the loan is 6%, compounded monthly. (a) Calculate the amount of monthly payment. (b) Of the 60th payment, how much will be used to repay the interest and principal for the month? (c) Tedros plans to pay off the loan immediately after making the 60th payment. What should the size of the lump-sum (pre-)payment be?...
Tedros borrowed $2 million and planned to repay the loan by making equal month-end payments over...
Tedros borrowed $2 million and planned to repay the loan by making equal month-end payments over a period of 10 years. The interest rate on the loan is 6%, compounded monthly. (a) Calculate the amount of monthly payment. (b) Of the 60th payment, how much will be used to repay the interest and principal for the month? (c) Tedros plans to pay off the loan immediately after making the 60th payment. What should the size of the lump-sum (pre-)payment be?...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT