Question

In: Finance

A fully amortizing mortgage loan is made for $90,000 for 15 years. The interest rate is...

A fully amortizing mortgage loan is made for $90,000 for 15 years. The interest rate is 6 percent per year compounding monthly. Payments are to be made monthly. What is the principal payment in the first monthly payment?

Solutions

Expert Solution

First we will calculate the monthly payments as per below:

Here, the payments will be same every month, so it is an annuity. We will use the present value of annuity formula fo calculating the monthly payments as below:

PVA = P * (1 - (1 + r)-n / r)

where, PVA = Present value of annuity = $90000, P is the periodical amount, r is the rate of interest = 6% compounded monthly, so monthly rate = 6% / 12 = 0.5% and n is the time period = 15 * 12 = 180 months

Now, putting these values in the above formula, we get,

$90000 = P * (1 - (1 + 0.5%)-180 / 0.5%)

$90000 = P * (1 - ( 1+ 0.005)-180 / 0.005)

$90000 = P * (1 - ( 1.005)-180 / 0.005)

$90000 = P * (1 - 0.40748242666) / 0.005)

$90000 = P * (0.59251757333 / 0.005)

$90000 = P * 118.503514668

P = $90000 / 118.503514668

P = $759.47

So, monthly payments ar for $759.47

Next, we will calculate the interest in the first monthly payment as per below:

Interest = Principal * Rate of interest * 1 / 12

Interest = $90000 * 6% * 1 / 12 = $450

Now,

In the first monthly payment of $759.47, principal is:

Principal = Monthly payment - Interest

Principal = $759.47 - $450 = $309.47


Related Solutions

A fully amortizing mortgage loan is made for $200,000 at 6 percent interest for 30 years....
A fully amortizing mortgage loan is made for $200,000 at 6 percent interest for 30 years. Payments are to be made monthly. (Ignore origination fee and other fees). a.      Using Excel, construct fully amortizing mortgage loan table including beginning balance, payment, interest, principal, and ending balance. (Please check your ending balance by using PV function in Excel) b.      Interest and principal payments during month 1. c.       Total Principal and total interest paid over 30 years. d.      The outstanding loan balance...
A fully amortizing mortgage loan is made for $100,000 at 4.5% for 30 years. Payments will...
A fully amortizing mortgage loan is made for $100,000 at 4.5% for 30 years. Payments will be made monthly. Calculate the following: a. Monthly payments b. Interest and principal payments during month 1. c. Total interest and principal payments made over the life of the loan (30 years). d. If the property were sold at the end of year 15, how much is still owed on the mortgage? e. At the end of year 15, how much has been paid...
Assume a $270,000 fully amortizing mortgage loan, which accrues interest at a 7.5% interest rate, and...
Assume a $270,000 fully amortizing mortgage loan, which accrues interest at a 7.5% interest rate, and has a maturity of 25 years. Payments are monthly. What is the payoff of the loan in 12 years?
Suppose you have taken out a $125,000 fully-amortizing fixed rate mortgage loan that has a term of 15 years and an interest rate of 6%.
Show work through excel formulas: please actually show how you do it   on excel exactly! 1. Suppose you have taken out a $125,000 fully-amortizing fixed rate mortgage loan that has a term of 15 years and an interest rate of 6%. After your first mortgage payment, how much of the original loan balance is remaining? 
 A. $1,054.82 B. $120,603.78 C. $124,570.18 D. $124,875.56 2. Assume you have taken out a partially amortizing loan for $325,000 that has a term of...
4. A $600,000 CPM fully amortizing loan is made, at a 4% interest rate compounded monthly,...
4. A $600,000 CPM fully amortizing loan is made, at a 4% interest rate compounded monthly, for a 30 year term. Loan comes with a charge of 5 points. What is the effective annual rate on the loan? *do work in EXCEL please*
SHOW CLEAR WORK ON EXCEL A 30-year fully amortizing mortgage loan was made 10 years ago...
SHOW CLEAR WORK ON EXCEL A 30-year fully amortizing mortgage loan was made 10 years ago for $75,000 at 6 percent interest. The borrower would like to prepay the mortgage balance by $10,000. a. Assuminghecanreducehismonthlymortgagepayments,whatisthenewmortgagepayment? b. Assuming the loan maturity is shortened and using the original monthly payments, what is the new loan maturity?
SHOW CLEAR WORK ON EXCEL A fully amortizing mortgage loan is made for $100,000 at 6...
SHOW CLEAR WORK ON EXCEL A fully amortizing mortgage loan is made for $100,000 at 6 percent interest for 30 years. Determine payments for each of the periods a–d below if interest is accured: a. Monthly. b. Quarterly. c. Annually. d. Weekly.
The following loan is fully amortizing. The loan is for $13,000 at 9% interest to be...
The following loan is fully amortizing. The loan is for $13,000 at 9% interest to be repaid over three (3) years. Amortize this loan on a monthly basis. Calculate the interest portion of the fourth (4th) payment considering that an additional payment of $2,000 was made with the second payment.
The following loan is fully amortizing. The loan is for $13,000 at 10% interest to be...
The following loan is fully amortizing. The loan is for $13,000 at 10% interest to be repaid over three (3) years. Amortize this loan on a monthly basis. Calculate the interest portion of the fourth (4th) payment considering that an additional payment of $2,000 was made with the second payment.
15. Ann is looking for a fully amortizing 30 year Fixed Rate Mortgage with monthly payments...
15. Ann is looking for a fully amortizing 30 year Fixed Rate Mortgage with monthly payments for $3,200,000. Mortgage A has a 4.38% interest rate and requires Ann to pay 1.5 points upfront. Mortgage B has a 6% interest rate and requires Ann to pay zero fees upfront. Assuming Ann makes payments for 2 years before she sells the house and pays the bank the balance, which mortgage has the lowest cost of borrowing (ie lowest annualized IRR)? Type 1...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT