Answered: What is the Monthly Payment? In…

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?

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 7FPE: Calculating interest and APR of installment loan. Assuming that interest is the only finance charge,...

See similar textbooks

Related questions

Q: (a) What is the amount (in $) of the monthly principal and interest portion, PI, of Michael's loan?…

A: Cost of condominium = $67,000 Time period = 30 years Interest rate = 5% Down Payment = 20%

Q: Amount of Loan $175,000 Interest Rate 6% Down Payment $31,000 Increase in Down paymen $6,000

A: Monthly payment is referred to as the payment which is paid on the amount borrowed that has to be…

Q: Determine the monthly principal and interest payment for a 15-year mortgage when the amount financed…

A: The sum of the monthly principal and interest payment is equal to the equal payments which the…

Q: Determine the monthly principal and interest payment for a 15-year mortgage when the amount…

A: A written agreement through which a lender gets the right to take the property that is put as a…

Q: Determine the monthly principal and interest payment for a 15-year mortgage when the amount…

A: The monthly payment on a loan includes the payment towards the loan amount as well as the interest…

Q: Use the table provided in the handbook. With a mortgage of $91,000 at 12% for 25 years, by what…

A: Solution: Mortgage amount = $91,000 Monthly interest rate = 12% / 12 = 1% Nos of monthly periods =…

Q: Determine the monthly amortization for a 30-year mortgage of P6,000,000 at a 5% interest rate,…

A: This question is an application of annuity. The monthly amortization is the equal monthly instalment…

Q: Consider a 15 year, fixed rate mortgage for $150,000 at a nominal rate of 8%. The loan comes with a…

A: A fixed interest rate loan is where your Interest Rate is locked in (i.e. fixed) for a certain…

Q: Complete the following table, which shows the monthly payments on a $100,000, 30-year mortgage at…

A: Calculate the monthly payment as follows: Formulas:

Q: Make an amortization table to show the first two payments for the mortgage. Amount of Annual…

A: Amortization is a repayment schedule which is generally used by lenders such as banks, financial…

Q: Consider a 30-year, fixed-rate mortgage for $100,000 at a nominal rate of 9%. a)If the borrower…

A: A written agreement through which a lender gets the right to take the property that is put as a…

Q: Consider a 15-year, 9% mortgage for $200,000 with annual payments that are structured in the…

A: Given: Years = 15 Interest rate = 9% Loan amount = $200,000

Q: Given a mortgage of $48,000 for 15 years with a rate of 11%, what are the total finance charges?

A: Mortgage/ Borrowings: Borrowings are the loan which is taken by the individual to meet its…

Q: Which of the following statements regarding a 30-year monthly payment amortized mortgage with a…

A: Amortized schedule is the schedule that depicts the amount of interest paid every month and the…

Q: A $89,000 mortgage is to be amortized by making monthly payments for 20 years. Interest is 6.9%…

A: The question can be solved in excel as follows:

Q: What is the simple interest rate on a loan of 2,000.00 that was paid 2,600.00 after 2 years and 6…

A: Interest = Amount - Principal Interest = 2,600 - 2,000 Interest = 600 Time = 2 years 6 months = 2.5…

Q: Complete the following table, which shows the monthly payments on a $100,000, 30-year mortgage at…

A: The amount of money borrowed is a mortgage and the borrowed money repaid over the period of time…

Q: Consider a $58,331, 30-year mortgage at interest rate 12% compounded monthly with a S600 monthly…

A: When a debt is repaid over a certain length of time, known as the amortization term, it is said to…

Q: A mortgage of $161000 is to be repaid by making payments of $1191 at the end of each month. if…

A: We need to use NPER formula in excel to calculate term of mortgage. The formula is…

Q: 2. A mortgage has the following terms: Amount: Rate: Amortization (Years): $750,000 1-5? 6.25% 30…

A: Loan is a facility under which the borrower gets a lump-sum amount and repays it in small regular…

Q: Consider a 20-year mortgage for $174,334 at an annual interest rate of 5%. After 8 years, the…

A: Time period = 20 years Value of mortgage = $174,344 Annual interest rate = 5% Refinancing time…

Q: floating rate mortgage loan is made for $100,000 for 30yrs at a start rate of 12% interest. The…

A: In this question principal at the end of year one would be the total mount paid in monthly…

Q: Consider a 20-year mortgage for $182,892 at an annual interest rate of 5.3%. After 7 years, the…

A: Mortgage is an amount which is borrowed from external sources like a bank for a specific period.…

Q: What is the total interest paid on a 30 year mortgage for $235000 if it is charged 6.9% interest,…

A: Given: Mortgage Tenure: 30 years Mortgage Amount: $235000 Interest Rate: 6.9%, compounded monthly

Q: Calculate the original loan size of a fixed-payment mortgage if the monthly payment is $1,146.78,…

A: The question can be solved as follows:

Q: A reverse mortgage is made with a balance not to exceed $250,000 on a property valued at $600,000.…

A: Reverse mortgage- Under reverse mortgage, the homeowner is not required to make any loan payment ,…

Q: Consider a $180,000 15-year, fixed-rate mortgage with an annual interest rate of 7.40% and monthly…

A: The fixed-rate mortgage is also called a fixed-rate loan. The fixed-rate mortgage is the lending…

Q: A $87,000 mortgage is to be amortized by making monthly payments for 25 years. Interest is 8.7%…

A: Mortgage is a type of long-term credit which allows borrower to acquire asset by keeping same asset…

Q: Consider a mortgage on a house valued at $480,000 with an interest rate of 6% compounded…

A: Mortgage loan: These loans are issued with the nominal rate that is compounded semi-annually,…

Q: a. What are the monthly principal and interest payments for each loan? b. What is the total amount…

A: Loan Amortization: It is the process of paying the loan amount by the borrower in periodic payments…

Q: A mortgage of $161000 is to be repaid by making payments of $1191 at the end of each month. if…

A: Mortgage repayment in equal amounts is a type of annuity. Annuity can be defined as a series of…

Q: Consider a 30-year, 6% loan for $240,000 with fixed monthly payments. a) What will be the remaining…

A: Annual worth distributes present worth into equivalent uniform value over its useful life.

Q: A 30-year mortgage requires payments of $4,865.46 at the end of each month. If interest is 5.31%…

A: Present value = Annuity * PVAF ( Monthly rate, Number of months Interest Amount = Total Amount paid…

Q: Using a spreadsheet program, create an amortization schedule for a 30-year mortgage of $500,000 an…

A: Annual interest rate = 4.29% Monthly interest rate = 4.29%/12 = 0.3575% Loan = $500,000 Time = 30*12…

Q: a. What will be the monthly payment on a 30-year, $250,000 mortgage loan, where the interest rate is…

A: Calculation of Monthly Payment and Interest Paid on the Loan:Excel Spreadsheet:

Q: A mortgage has an interest rate of 200 basis points over the treasury rate of 4%, an amortization…

A: Excel Spreadsheet:

Q: The balance on a mortgage was $42,600 and an interest rate of 4.25% compounded semi-annually was…

A: Monthly payments is calculated by present value of annuity formula. In excel monthly payments is…

Q: An mortgage of $200000 is amortized at 30 years, with an interest rate of 3.5% compounded…

A: Loan amount (PV) = $200,000 Interest rate = 3.5% Monthly interest rate (r) = [[1+(0.0350/2)]2]1/12-1…

Q: Consider a $180,000 15-year, fixed-rate mortgage with an annual interest rate of 7.40% and monthly…

A: The present value is the value of the sum received at time 0 or the current period. It is the value…

Q: What is the monthly payment on a 30 year, $666,000 mortgage, with an interest rate of 2%, compounded…

A: Given data; mortgage amount = $ 666,000 number of years = 30 interest rate = 2% compounded monthly…

Q: The monthly payments for the first three-year term of a $250,000 mortgage loan were based on a…

A: Installment is the periodic amount paid by the borrower to the lender in order to pay back the loan…

Q: A mortgage balance of $26,000 is to be repaid over a 12-year term by equal monthly payments at 4.9%…

A: Mortgage is a kind of loan which is provided by the lender to the borrower to purchase the real…

Q: Assume a $175,000 mortgage loan and 10-year term. The lender is charging an annual interest rate of…

A: Given, Mortgage amount is $175000 Annual interest rate is 6%

Q: Assume we have a $500,000 mortgage at 3.5% original interest rate, with a 30-year term and monthly…

A: Loan (mortgage) amortization schedule refers to a schedule which is prepared to shows the periodic…

Q: Make an amortization table to show the first two payments for the mortgage. Amount of Annual…

A: Amortization table is as under-

Q: suppose a 25- year mortgage of $400,000 at a fixed nominal interest rate of 3.5% per year,…

A: Data given: Mortgage = $ 400,000 N= 25 years Rate= 3.5% p.a. compounded annually

Question

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

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

This is a popular solution!

SEE SOLUTION Check out a sample Q&A here

Step 1

Step 2

Step 3

Step 4

Step 5

Trending now

This is a popular solution!

Step by step

Solved in 5 steps with 5 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.

Similar questions

Calculating interest and APR of installment loan. Assuming that interest is the only finance charge, how much interest would be paid on a 5,000 installment loan to be repaid in 36 monthly installments of 166.10? What is the APR on this loan?
2. A mortgage has the following terms: Amount: $750,000 Rate: 6.25% Amortization (Years): 30 Term (Years): 20 Please determine the following: A. What is the Monthly Payment? B. In preparing an Income Statement, what is the Interest Expense for years 1-5? C. What is the Principal Balance at the end of year 6? D. What is the value of the loan at the expiration? E. If rates remain constant (flat), what would the benefit be to refinance this loan after year 10?
Consider a home mortgage of $ at a fixed APR of % for years. a. Calculate the monthly payment. b. Determine the total amount paid over the term of the loan. c. Of the total amount paid, what percentage is paid toward the principal and what percentage is paid for interest.
Use an amortization table (Use Spreadsheet application such as Excel) that determines the monthly mortgage payment based on interest rate of 35% and a principal of GHS1000,000 with a 15-year maturity and then for a 30-year maturity. Is the monthly payment for the 15-year maturity twice the amount for the 30-year maturity or less than twice the amount? Explain.
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?
Consider a home mortgage of $17500 at a fixed APR of %6 for 15 years. a. Calculate the monthly payment. b. Determine the total amount paid over the term of the loan. c. Of the total amount paid, what percentage is paid toward the principal and what percentage is paid for interest. Please show all work computaion explanation formulas clearly with steps
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?
What is the monthly payment (beginning) of a 30 year, 4.8%, $200,000 mortgage?
1. You have just obtained a commercial mortgage for $6.25M with a 5-year term, 25-year amortization period and 6.50% mortgage interest rate. (a) Construct an amortization table for the term of the loan assuming annual payments. What is the annual payment? What is the balance at maturity? (b) What is the e¤ective cost of borrowing if the borrower pays an origination fee of $30,000? (c) The borrower can repay the balance of the loan at any time prior to its maturity, but must pay a penalty of 5% of the outstanding balance. What is the cost of borrowing if the borrower pays an origination fee of $30,000 and pays off the remaining balance of the loan after making payments for 4 years?
Suppose you purchase a home and obtain a 15-year fixed-rate loan of $195,000 at an annual interest rate of 6.0%. a) What is your monthly payment? N: months I %: P.V: $ PMT: $ F.V: 0 P/Y: 12 C/Y: 12 b) Of the first month's mortgage payment, how much is interest? HINT: I=Prt Interest: I=$ c) Of the first month's mortgage payment, how much is applied to the principal? HINT: PMT - Interest Amount Applied to Principal: $ d) How much is your outstanding balance after the first month’s payment? HINT: Principal - Amount Applied to Principal Outstanding Balance after first payment: $
Using this table as needed, calculate the required information for the mortgage. (Round dollars to the nearest cent.) AmountFinanced InterestRate Termof Loan(years) Numberof $1,000sFinanced TableFactor(in $) MonthlyPayment(in $) TotalInterest(in $) $162,300 5.25% 15 ? $ ? $ ? $ ?
Using a spreadsheet program, create an amortization schedule for a 30-year mortgage of $500,000 at an annual interest rate of 4.28%. (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.)