Question

Determine the monthly payment for a 30-year real estate loan with an annual percentage rate of...

Determine the monthly payment for a 30-year real estate loan with an annual percentage rate of 6.5% and an initial principal of $150,000.

how much of the first payment is used to reduce the principal (loan balance)?

Homework Answers

Answer #1

Amount borrowed = $150,000

Annual interest rate = 6.50%
Monthly interest rate = 0.5417%

Period = 30 years or 360 months

Monthly payment * PVIFA(0.5417%, 360) = $150,000
Monthly payment * (1 - (1/1.005417)^360) / 0.005417 = $150,000
Monthly payment * 158.20435 = $150,000
Monthly payment = $948.14

Interest paid in 1st payment = 0.5417% * $150,000
Interest paid in 1st payment = $812.55

Principal paid in 1st payment = $948.14 - $812.55
Principal paid in 1st payment = $135.59

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Consider a 30-year mortgage with an interest rate of 10% compounded monthly and a monthly payment...
Consider a 30-year mortgage with an interest rate of 10% compounded monthly and a monthly payment of $850. Cannot use excel must be equation based . If principal is 96,858.20 than....How much of the principal is paid the first, 5th, 20th and last year
Housing cost: $345,000 Number of years (T) = 30 How much are the Real Estate taxes?...
Housing cost: $345,000 Number of years (T) = 30 How much are the Real Estate taxes? Rate of Interest: (R) = 4.553% Down payment 20% of asking price What is the Principal of the loan? What is the Interest of the loan? Suppose that in order to qualify for the loan, the total monthly amount paid cannot exceed 30 percent of monthly income. What is the minimum monthly income needed to qualify for the loan? What is the minimum annual...
A $10000 loan has an interest rate of 12% per year, compounded monthly, and 30 equal...
A $10000 loan has an interest rate of 12% per year, compounded monthly, and 30 equal monthly payments are required. a) If payments begin at the end of the first month, what is the value of each payment? b) How much interest is in the 10th payment? c) What would you enter into Excel to solve part b? d) What is the unpaid balance immediately after the 10th payment? e) If the 30 loan payments are deferred and begin at...
You have just taken out a $40,000 car loan with a 6% annual percentage rate, compounded...
You have just taken out a $40,000 car loan with a 6% annual percentage rate, compounded monthly. The loan is for 10 years. When you make your second payment in two months, how much of this payment will go toward the principal of the loan?
You are borrowing $200,000 on a 30 year, 12% apr, monthly payment, mortgage loan. How much...
You are borrowing $200,000 on a 30 year, 12% apr, monthly payment, mortgage loan. How much will be your principal repayment from your monthly mortgage payment at the end of the second month?(Make a table for the mortgage loan payment schedule) Can you explain how to get interest and principle repaid please
A borrower takes out a 30-year adjustable rate mortgage loan for $500,000 with monthly payments. The...
A borrower takes out a 30-year adjustable rate mortgage loan for $500,000 with monthly payments. The first year of the loan has a “teaser” rate of 3%, after that, the rate can reset with a 7% annual payment cap. On the reset date, the composite rate is 5%. What would be the Year 2 monthly payment be? Please show how to solve using a financial calculator.
Catherine received a 30 year loan of $240,000 to purchase a house. The interest rate on...
Catherine received a 30 year loan of $240,000 to purchase a house. The interest rate on the loan was 5.90% compounded monthly. a. What is the size of the monthly loan payment? $ Round to the nearest cent b. What is the principal balance of the loan at the end of 3 years?$ Round to the nearest cent c. By how much will the amortization period shorten if Catherine made an extra payment of $54,000 at the end of the...
What is the principal portion of the required monthly payment on a 30-year, 6.5% rate, $100,000...
What is the principal portion of the required monthly payment on a 30-year, 6.5% rate, $100,000 conventional fixed-rate mortgage that has monthly mortgage payments of $632.07? A. $871 B. $632 C. $542 D. $90 E. $0
Ann gets a fully amortizing 30-year fixed rate mortgage with monthly payments. The initial balance is...
Ann gets a fully amortizing 30-year fixed rate mortgage with monthly payments. The initial balance is $1,000,000. The interest rate is 3.50%, compounded monthly. What will be Ann’s loan balance after her 240th payment (if Ann makes exactly the required monthly payment for 20 years)? Using your answer from abovr, what fraction of the 241st payment will go to principal (in percent)?
Jane borrows a loan of $200,000 with minimum payment of 3% in the first 3 years....
Jane borrows a loan of $200,000 with minimum payment of 3% in the first 3 years. The loan is 30 years term and annual interest rate is 6.5%. Payment is made monthly. What is the ending balance at the end of the first month?