Question

In: Finance

On a 30-year, fixed-rate loan with a monthly payment of $1,000 and an interest rate of...

On a 30-year, fixed-rate loan with a monthly payment of $1,000 and an interest rate of 9%, what is the outstanding balance due on the loan with after the borrower has made 18 years of payments?

Solutions

Expert Solution

solved using (I) financial formula and (II) excel function


Related Solutions

Find the monthly payment for a 25-year fixed-rate loan of $200,000 at 5% annual interest.
Find the monthly payment for a 25-year fixed-rate loan of $200,000 at 5% annual interest.
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. (1) Calculate the principal. (2) How much of the principal is paid the first, 5th, 20th and last year? (3) How much interest is paid the first, 5th, 20th and last year year? (4) What is the total amount of money paid during the 30 years? (5) What is the total amount of interest paid during the 30 years? (6) What is...
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. (5) What is the total amount of interest paid during the 30 years? (6) What is the unpaid balance after 25 years? (7) How much has to be deposited into a savings account with an interest rate of 4% compounded quarterly in order to pay the unpaid balance of the mortgage after 25 years? (8) How much has to be deposited each...
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...
A loan is for $600,000 (mortgage), 30 years monthly, 4% fixed rate interest. What is the...
A loan is for $600,000 (mortgage), 30 years monthly, 4% fixed rate interest. What is the payment, 5-year payoff, 5-year principal paid, and 5-year interest paid?
39.) A 3-year fixed payment loan has an annual payment of $906. The interest rate for...
39.) A 3-year fixed payment loan has an annual payment of $906. The interest rate for the loan is 7.7%. What is the duration (in years) of the fixed-payment loan? Round your answer to at least 2 decimal places.
In underwriting a new 30-year, monthly payment mortgage loan at5% interest for Jackie, the lender...
In underwriting a new 30-year, monthly payment mortgage loan at 5% interest for Jackie, the lender requires that Jackie meet three ratios to be approved for the loan.First, the payment on her loan plus the monthly cost of homeowner's insurance of $200 plus monthly property taxes of $225 plus monthly home owner association fees of $100 can be no more than 28% of her gross monthly income.Second, the monthly total of the four items above plus her car loan payment...
5)What is the monthly payment on a 15 year, $350,000 mortgage loan, where interest rate is...
5)What is the monthly payment on a 15 year, $350,000 mortgage loan, where interest rate is 3% per year, Compounded annually Compounded monthly Compounded daily What are effective annual rates for 1,2, and 3 above?
Consider a 30-year fixed-rate home loan of $545,500 with an interest rate of 3.25%. What is...
Consider a 30-year fixed-rate home loan of $545,500 with an interest rate of 3.25%. What is the total amount of interest paid? (Round your answer to the nearest cent.)?
The monthly payment for a given loan pays the principal and the interest. The monthly interest...
The monthly payment for a given loan pays the principal and the interest. The monthly interest is computed by multiplying the monthly interest rate and the balance (the remaining principal). The principal paid for the month is therefore the monthly payment minus the monthly interest. Write a pseudocode and a Python program that let the user enter the loan amount, number of years, and interest rate, and then displays the amortization schedule for the loan (payment#, interest, principal, balance, monthly...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT