Please show how to solve this problem. Interest-only mortgage with monthly payments and loan amount: $56,000; Term: 15 years; Annual interest rate: 7.5% What is the total payment in the 180th month? What is the outstanding balance at the end of 10 years (120 months)? What is the total interest payment during the entire loan term (180 months)?

Please show how to solve this problem. Interest-only mortgage with monthly payments and loan amount: $56,000; Term: 15 years; Annual interest rate: 7.5% What is the total payment in the 180th month? What is the outstanding balance at the end of 10 years (120 months)? What is the total interest payment during the entire loan term (180 months)?

Pfin (with Mindtap, 1 Term Printed Access Card) (mindtap Course List)

7th Edition

ISBN:9780357033609

Author:Randall Billingsley, Lawrence J. Gitman, Michael D. Joehnk

Publisher:Randall Billingsley, Lawrence J. Gitman, Michael D. Joehnk

Chapter7: Using Consumer Loans

Section: Chapter Questions

Problem 6FPE

See similar textbooks

Similar questions

Calculating and comparing add-on and simple interest loans. Eli Nelson is borrowing 10,000 for five years at 7 percent. Payments, which are made on a monthly basis, are determined using the add-on method. a. How much total interest will Eli pay on the loan if it is held for the full five-year term? b. What are Elis monthly payments? c. How much higher are the monthly payments under the add-on method than under the simple interest method?
Cost of Bank Loan Mary Jones recently obtained an equipment loan from a local bank. The loan is for 15,000 with a nominal interest rate of 11%. However, this is an installment loan, so the bank also charges add-on interest. Mary must make monthly payments on the loan, and the loan is to be repaid in 1 year. What is the effective annual rate on the loan (assuming a 365-day year)?
Please show how to solve a. b. and c. using the information below and Excel. Interest-only mortgage with monthly payments and loan amount: $56,000; Term: 15 years; Annual interest rate: 7.5% a. What is the total payment in the 180th month? b. What is the outstanding balance at the end of 10 years (120 months)? c. What is the total interest payment during the entire loan term (180 months)?
Please show how to solve this problem using excel and please show the spreadsheet formulas. Interest-only mortgage with monthly payments and loan amount: $56,000; Term: 15 years; Annual interest rate: 7.5% What is the total payment in the 180th month? What is the outstanding balance at the end of 10 years (120 months)? What is the total interest payment during the entire loan term (180 months)?
Prepare the first row of a loan amortization schedule based on the following information. The loan amount is for $17,900 with an annual interest rate of 09.00%. The loan will be repaid over 22 years with monthly payments. 1. What is the Loan Payment? 2. What portion of this payment is Interest? 3. What portion of this payment is Principal? 4. What is the Loan balance after first monthly payment?
A mortgage has the following terms: Amount: $750,000 Rate: 6.25% Amortization (Years): 30 Term (Years): 20 Please determine the following: What is the Monthly Payment? In preparing an Income Statement, what is the Interest Expense for years 1 – 5? What is the Principal Balance at the end of year 6? What is the value of the loan at the expiration? If rates remain constant (flat), what would the benefit be to refinance this loan after year 10? do all the questions 1-5 and show the formulas in excel and show how you got it
Find the length of the loan in months, if $1000 is borrowed with an annual simple interest rate of 3% and with $1030 repaid at the end of the loan. what is the length of the loan in months?
A 30-year mortgage for $175,000 is issued at a 6% nominal interest rate. (a) What is the monthly payment? (b) How long does it take to pay off the mortgage, if $1250 per month is paid? (c) How long does it take to pay off the mortgage, if double payments are made?
Problem: Please answer the following questions regarding a $300,000 Mortgage Loan with monthly amortization over 30 years and an annual interest rate of 6%. What is the loan payment for a (30 year loan (360 monthly payments) of $300,000 at 6%? Question Answer What is the monthly payment amount? Loan Monthly Payment: How much interest and how much is principle on the first payment? Interest: Principle: How much interest and how much is principle on the second payment? Interest: Principle: If after the second payment an addition $10,000 was paid on principle. How much would the interest be on the third payment? Interest:
A $127,000 mortgage has a 30-year term and a 10% nominal interest rate. (a) What is the monthly payment? (b) After the first year of payments, what is the outstanding balance? (c) Calculate the interest and principal amount for the first month mortgage payment.
Using a spreadsheet program, create an amortization schedule for a 30-year mortgage of $500,000 at an annual interest rate of 4.24%. (a) In which month does the amount of principal in a monthly payment first exceed the amount of interest? _____ (b) How much interest is repaid for the term of the loan? (Round your answer to the nearest cent.) _____$ (c) If the loan amount was $750,000 instead of $500,000, would the month in which the amount of principal in a monthly payment first exceeded the amount of interest change?
A fully amortizing mortgage loan is made for $84,000 at 6 percent interest for 25 years. Payments are to be made monthly. Required: a. Calculate monthly payments. b. Calculate interest and principal payments during month 1. c. Calculate total principal and total interest paid over 25 years. d. Calculate the outstanding loan balance if the loan is repaid at the end of year 10. e. Calculate total monthly interest and principal payments through year 10. f. What would the breakdown of interest and principal be during month 50?