A thirty year $200,000.00 mortgage has a monthly payment of $1,199.10 based on a rate of...
A thirty year $200,000.00 mortgage has a monthly payment of $1,199.10 based on a rate of 6% APR. After making 180 payments over fifteen years, how much of the mortgage do you still owe?
Homework Answers
Answer:
Outstanding amount (mortgage amount still owed) will be equal to PV of the remaining monthly installments.
Monthly installment = $1,199.10
Remaining period = 30 * 12 - 180 = 180 months
Monthly rate of interest =6%/12 = 0.5%
We will use PV function of excel to get the outstanding amount:
PV (rate, nper, pmt, fv, type)
PV (0.5%, 180, 1199.10, 0, 0)
= $142,097.56
Or $142,098
Amount of mortgage you still owe = $142,097.56 or $142,098
Add Answer to:
A thirty year $200,000.00 mortgage has a monthly payment of
$1,199.10 based on a rate of...
A. What would be your monthly mortgage payment if you pay for a $250,000
4. A. What would be your monthly mortgage payment if you pay for a $250,000 home by making a 20% down payment and then take out a 3.74% thirty year fixed rate mortgage loan where interest is compounded monthly to cover the remaining balance. All work must be shown justifying the following answers. Mortgage payment = B. How much total interest would you have to pay over the entire life of the loan. Total interest paid = C. Suppose you inherit some money and...
7A) Use excel to build a monthly amortization table for a 30-year 5% fix-rate mortgage on...
7A) Use excel to build a monthly amortization table for a 30-year 5% fix-rate mortgage on a $320,000 home, with a $15,000 down payment. [Please be good to the forests and cut and paste only the first and last few rows of the table, not the whole thing.] 7B) Using the amortization table you built for the previous question, answer the following [Again, just cut and paste the segment of the amortization table that helps you answer the question.]: a....
The mortgage on your house is five years old. It required monthly payments of $ 1,422,...
The mortgage on your house is five years old. It required
monthly payments of $ 1,422, had an original term of 30 years and
had an interest rate of 9% (APR). In the intervening five years,
interest rates have fallen and so you have decided to refinance,
that is, you will roll over the outstanding balance into a new
mortgage. The new mortgage has a 30-year term, requires monthly
payments, and has an interest rate of 6.125 % (APR).
a....
A thirty year monthly payment mortgage loan for 250,000 is offered at a nominal rate of...
A thirty year monthly payment mortgage loan for 250,000 is offered at a nominal rate of 6.3% convertible monthly. The lender charges a fee of 2.5% for which no services are provided. Find the APR.
The mortgage on your house is five years old. It required monthly payments of $ 1...
The mortgage on your house is five years old. It required monthly payments of $ 1 422 , had an original term of 30 years, and had an interest rate of 9 % (APR). In the intervening five years, interest rates have fallen and so you have decided to refinancelong dashthat is, you will roll over the outstanding balance into a new mortgage. The new mortgage has a 30-year term, requires monthly payments, and has an interest rate of 6.625...
What is the monthly payment for a $100500 thirty-year mortgage at 6% APR?
What is the monthly payment for a $100500 thirty-year mortgage at 6% APR?
A thirty year monthly payment mortgage loan for 500,000 is offered at a nominal rate of 8.4% convertible monthly. Find...
A thirty year monthly payment mortgage loan for 500,000 is offered at a nominal rate of 8.4% convertible monthly. Find the a) monthly payment, b) the total principal and interest that would be paid on the loan over 30 years c) the balance in 5 years and d) the principal and interest paid over the first 5 years.
The mortgage on your house is five years old. It required monthly payments of $ 1,422,...
The mortgage on your house is five years old. It required monthly payments of $ 1,422, had an original term of 30 years, and had an interest rate of 9 % (APR). In the intervening five years, interest rates have fallen and so you have decided to refinance long dash that is, you will roll over the outstanding balance into a new mortgage. The new mortgage has a 30-year term, requires monthly payments, and has an interest rate of 6.125...
The mortgage on your house is five years old. It required monthly payments of $1,450, had an original term of 30 years, and had an interest rate of 8% (APR). In the intervening five years, interest rates have fallen and so you have decided to refinance
The mortgage on your house is five years old. It required monthly payments of $1,450, had an original term of 30 years, and had an interest rate of 8% (APR). In the intervening five years, interest rates have fallen and so you have decided to refinance—that is, you will roll over the outstanding balance into a new mortgage. The new mortgage has a 30-year term, requires monthly payments, and has an interest rate of 6.125% (APR). a. What monthly repayments will be required with...
The mortgage on your house is five years old. It required monthly payments of SEK 12,000,...
The mortgage on your house is five years old. It required monthly payments of SEK 12,000, had an original term of 30 years, and had an interest rate of 6.5% (APR). In the intervening five years, interest rates have fallen and so you have decided to refinance - that is, you will roll over the outstanding balance into a new mortgage. The new mortgage has a 30-year term, requires monthly payments, and has an interest rate of 3.5% (APR). (a)...
The mortgage on your house is five years old. It required
monthly payments of $ 1,422, had an original term of 30 years and
had an interest rate of 9% (APR). In the intervening five years,
interest rates have fallen and so you have decided to refinance,
that is, you will roll over the outstanding balance into a new
mortgage. The new mortgage has a 30-year term, requires monthly
payments, and has an interest rate of 6.125 % (APR).
a....
A thirty year monthly payment mortgage loan for 500,000 is offered at a nominal rate of 8.4% convertible monthly. Find the a) monthly payment, b) the total principal and interest that would be paid on the loan over 30 years c) the balance in 5 years and d) the principal and interest paid over the first 5 years.
Most questions answered within 3 hours.
-
Oxidative phosphorylation is achieved through chemiosmotic
coupling, which turns chemical energy into osmotic potential energy
that...
asked 40 minutes ago -
Hollywood Shoes would like to maintain their cash account at a
minimum level of $64,000, but...
asked 38 minutes ago -
Proteins CtrA-P, DnaA, and GcrA behave similarly to what
molecule in the Eukaryotic Cell Cycle?
asked 42 minutes ago -
TRUE OR FALSE
In case of a competitive tender procedure, in the request for
quotation, the...
asked 50 minutes ago -
I am a little behind please provide some explanation, will
provide thumbs up.
This question considers...
asked 53 minutes ago -
Let say the utility function as U(X,Y) = lnX + Y. Show that the
marginal rate...
asked 58 minutes ago -
A current of I=8.0A is flowing in a typical extension cord of
length L=3.00m. The cord...
asked 1 hour ago -
1. When balancing the equation H2SO4 (aq) + NaOH (aq) →
Na2SO4(aq) + H2O(aq), would you...
asked 1 hour ago -
Provide a definition of “classification hierarchy” and
illustrate your definition with an example of how and...
asked 1 hour ago -
1. Describe the four main green solvents. Provide one example of
the use of each solvent....
asked 1 hour ago -
International ethics focus on:
1) exploitation of labor
2)corruption
3) environmental impact
4) none of the...
asked 1 hour ago -
Costing Models You work for XYZ trucking and your boss has asked
you to figure out...
asked 1 hour ago