Question

SHOW CLEAR WORK ON EXCEL A fully amortizing mortgage is made for $80,000 for 25 years....

SHOW CLEAR WORK ON EXCEL

A fully amortizing mortgage is made for $80,000 for 25 years. Total monthly payments will be $900 per month. What is the interest rate on the loan?

Homework Answers

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
A fully amortized mortgage is made for $100,000 for 10 years. Interest rate is 6 percent...
A fully amortized mortgage is made for $100,000 for 10 years. Interest rate is 6 percent per year compounded monthly. What is the monthly payment amount? What is balance of the loan at the end of 5 years? What is the total interest paid by the end of the fifth year? What is the total principal paid by the end of the tenth year? SHOW WORK AND DONT USE EXCEL
An investor obtained a fully amortizing mortgage five years ago for $175,000 at 11.5% for 30...
An investor obtained a fully amortizing mortgage five years ago for $175,000 at 11.5% for 30 years. Mortgage rates have dropped so that a fully amortizing 20-year loan can be obtained at 10%. There is no prepayment penalty on the mortgage balance of the original loan, but 3 points will be charged on the new loan and other closing costs will be $3000. All payments are monthly. What is the effective "cost" of refinancing?
PLEASE SHOW FORMULA USED(NOT FROM EXCEL) AND STEPS USING FINANCIAL CALC 7. Ann obtains a fully...
PLEASE SHOW FORMULA USED(NOT FROM EXCEL) AND STEPS USING FINANCIAL CALC 7. Ann obtains a fully amortizing 30 year Fixed Rate Mortgage with monthly payments for $135,000 at 5.25%. What will be Ann’s mortgage balance after 20 years of payments (ie after 240 months)? 8. Ann obtains a fully amortizing 30 year Fixed Rate Mortgage with monthly payments for $135,000 at 5.25%. What percent of Ann’s 20th payment goes to interest? 9. Ann obtains a fully amortizing 30 year Fixed...
A borrower obtains a fully amortizing constant payment mortgage loan for $75,000 at 12 percent for...
A borrower obtains a fully amortizing constant payment mortgage loan for $75,000 at 12 percent for 3 years. Payments are monthly. What will be the amount of remaining balance at the end of the second month? (Answer is rounded)
A borrower has a 30-year fully amortizing mortgage loan for $200,000 with an interest rate of...
A borrower has a 30-year fully amortizing mortgage loan for $200,000 with an interest rate of 6% and monthly payments. If she wants to pay off the loan after 8 years, what would be the outstanding balance on the loan? (I know the correct answer would be $175,545, but how to find the amount that goes in interest and principal?)
Suppose you have taken out a $200,000 fully amortizing fixed rate mortgage loan that has a...
Suppose you have taken out a $200,000 fully amortizing fixed rate mortgage loan that has a term of 15 years and an interest rate of 4.25%. In month two of the mortgage, how much of the monthly mortgage payment does the principal repayment portion consist of?
you are applying for a $1,000,000 mortgage. If the interest rate on your 360-month fully amortizing,...
you are applying for a $1,000,000 mortgage. If the interest rate on your 360-month fully amortizing, fixed rate, level payment loan is 3% annual, what is the percentage increase in your monthly payment if the interest rate were 6% annual ?
1) Ann is looking for a fully amortizing 30 year Fixed Rate Mortgage with monthly payments...
1) Ann is looking for a fully amortizing 30 year Fixed Rate Mortgage with monthly payments for $4,500,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, what is Ann’s annualized IRR from mortgage A? 2)Ann is looking for a fully...
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)?
Ann is looking for a fully amortizing 30 year Fixed Rate Mortgage with monthly payments for...
Ann is looking for a fully amortizing 30 year Fixed Rate Mortgage with monthly payments for $4,500,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 30 years, what is Ann’s annualized IRR from mortgage A?