Borrow $100,000 with a 20 year fixed mortgage at 6%. Calculate the monthly payment if the...

Borrow $100,000 with a 20 year fixed mortgage at 6%. Calculate the monthly payment if the loan is

Partially Amortizing- Lender and borrower agree to have a balance of $80,000 at maturity?

		256.22
		543,78
		356.71
		6543.69

Solutions

Expert Solution

Monthly payment is calculated using PMT function:

=PMT(rate,nper,pv,fv)

=PMT(6%/12,20*12,100000,-80000)

=543.78

jeff jeffy answered 2 years ago

Next > < Previous

Related Solutions

Borrow $100,000 with a 20 year fixed mortgage at 6%. Calculate the monthly payment if the...

Borrow $100,000 with a 20 year fixed mortgage at 6%. Calculate the monthly payment if the loan is Fully Amortizing? A. 726.53 B. 6000 C. 716.43 D. 216.43

What is the monthly mortgage payment on a $300,000 30 year fixed rate mortgage with an...

What is the monthly mortgage payment on a $300,000 30 year fixed rate mortgage with an interest rate of 5.125 percent. A friend who knows you have studied amortization asks your help to find the interest portion of their house payments for tax purposes (assuming they itemize). The monthly payments are $2,107.02 on a 30 year loan with a 5 percent interest rate. a) What was the total amount of interest paid during year 2? b) At what point in...

Calculate the monthly payment required to the nearest whole penny for a 30-year fixed-rate mortgage made...

Calculate the monthly payment required to the nearest whole penny for a 30-year fixed-rate mortgage made by the lender at 4.67% annual percentage rate (APR) if the home buyer borrowed $158,000.

Calculate the monthly payment on a $220,000 mortgage if payment is made at the beginning of...

Calculate the monthly payment on a $220,000 mortgage if payment is made at the beginning of each month, and the annual interest rate is 3.75 percent for 20 years. Group of answer choices $1,304.35 $1,300.29 $1,319.25 $1,355.65

Assuming a 5/1 ARM, calculate the monthly mortgage payment on a 30 year $200,000 mortgage with...

Assuming a 5/1 ARM, calculate the monthly mortgage payment on a 30 year $200,000 mortgage with an initial rate of 2.75%, a rate of 4% at the time of the first adjustment, a rate of 5% at second adjustment and a rate of 4% at the third adjustment.

Consider a 6%, 30 year, $200,000 level payment mortgage with a monthly payment of $1,199.10. Assume...

Consider a 6%, 30 year, $200,000 level payment mortgage with a monthly payment of $1,199.10. Assume up front financing cost (includes all costs paid to the lender and third parties except discount points) equal $3,000. Find the EBC if the borrower repays the loan after two years (assuming no direct points). What is the EBC if the lender charges one discount point? What is the EBC if the lender charges 2.5 discount point?

Case 1: You apply for a 20-year, fixed-rate (APR 6.48%) monthly-payment-required mortgage loan for a house...

Case 1: You apply for a 20-year, fixed-rate (APR 6.48%) monthly-payment-required mortgage loan for a house selling for $150,000 today. Your bank requires 22% initial down payment of house value (to be paid upfront in cash immediately, thus not included in the loan balance), and $3,000 application-process-closing cost (to be carried into the beginning loan balance and amortized later). (a) What is your monthly loan payment if you stick to the mortgage deal till the end (assuming each payment is...

You take out a $200,000 mortgage for 20 years at 6%. a. What is your monthly payment?

You take out a $200,000 mortgage for 20 years at 6%.a. What is your monthly payment?b. What is the principle and interest on the first payment?c. What is the principle and interest on the twelfth payment?d. How much interest will you pay over the 20 years?

Calculating the Payment for a Constant Payment Mortgage (CPM) $100000 Mortgage 5% Interest 20 Years Monthly...

Calculating the Payment for a Constant Payment Mortgage (CPM) $100000 Mortgage 5% Interest 20 Years Monthly Payments If he wants to pay off the loan after 8 years, what would be the outstanding balance on the loan? Present Value Method

Ann obtains a 30 year Fixed Rate, Constant Payment Mortgage with monthly payments for $4,500,000 at 4.38%. Her monthly payment is $20,000. What is the balloon payment for this mortgage after 360 payments are made?

Ann obtains a 30 year Fixed Rate, Constant Payment Mortgage with monthly payments for $4,500,000 at 4.38%. Her monthly payment is $20,000. What is the balloon payment for this mortgage after 360 payments are made?

Subjects