If you want a 20-year, fixed mortgage loan of $500,000, with an annual interest rate of 3.25% APR and no down payment. 1) Determine the monthly mortgage payment, determine the total amount paid over the full term of the loan, and how much interest will be paid on the loan over the 20 years. 2) Of the first month's mortgage payment, how much goes towards the interest and how much is applied to the principal? 3) What is the new balance on the 20-year loan after the first mortgage payment?

If you want a 20-year, fixed mortgage loan of $500,000, with an annual interest rate of 3.25% APR and no down payment. 1) Determine the monthly mortgage payment, determine the total amount paid over the full term of the loan, and how much interest will be paid on the loan over the 20 years. 2) Of the first month's mortgage payment, how much goes towards the interest and how much is applied to the principal? 3) What is the new balance on the 20-year loan after the first mortgage payment?

Corporate Fin Focused Approach

5th Edition

ISBN:9781285660516

Author:EHRHARDT

Publisher:EHRHARDT

Chapter4: Time Value Of Money

Section4.17: Amortized Loans

Problem 1ST

See similar textbooks

Similar questions

a. What will be the monthly payment on a 30-year, $250,000 mortgage loan, where the interest rate is 6% per year, compounded monthly? How much interest is paid over the life of the loan? b. What will be the monthly payment on a 30-year, $250,000 mortgage loan, where the interest rate is 6% per year, compounded continuously? How much interest is paid over the life of the loan? c. What will be the monthly payment on a 15-year, $250,000 mortgage loan, where the interest rate is 6% per year, compounded monthly? How much interest is paid over the life of the loan?
Consider a 15 year, fixed rate mortgage for $150,000 at a nominal rate of 8%. The loan comes with a facility to pay end of year installments. What is the duration of the loan? If interest rates increase to 8.25% immediately after the mortgage is made, how much is the loan worth to the lender?
Suppose you take out a $117,000, 20-year mortgage loan to buy a condo. The interest rate on the loan is 5%. To keep things simple, we will assume you make payments on the loan annually at the end of each year. a. What is your annual payment on the loan? b. Construct a mortgage amortization. c. What fraction of your initial loan payment is interest? d. What fraction of your initial loan payment is amortization? e. What is the total of the loan amount paid off after 10 years (halfway through the life of the loan)? f. If the inflation rate is 3%, what is the real value of the first (year-end) payment? g. If the inflation rate is 3%, what is the real value of the last (year-end) payment? h. Now assume the inflation rate is 6% and the real interest rate on the loan is unchanged. What must be the new nominal interest rate? i-1. Recompute the amortization table. i-2. What is the real value of the first (year-end) payment in this high-inflation scenario? j. What is the real value of the last…
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?
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
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: $
TOTAL INTEREST PAID. You are considering purchasing a home that requires $450,000 mortgage at 5.25%. Using a simple interest Loan amortization schedule:A) What is the total amount that you would pay for the 30 year mortgage, including interest?B) What is the total amount that you would pay for the 15 year mortgage, including interest?C) What is the difference in the total interest paid between the two different maturities?
Suppose you purchase a house for $200,000.00 by getting a mortgage for $180,000.00 and paying a $20,000.00 down payment. (i). If you get a 30-year mortgage with a 7% interest rate p.a. compounded quarterly, what are the quarterly payments? (ii). What would the loan balance be at the end of the first year?
9) Mortgage Payment You take out a 20-year fixed mortgage. The annual interest rate is ? = 0.10 and the monthly payment is $4,000. a. What is the total amount of this Mortgage? E.g., What is the PV of this mortgage payment stream? b. If you make an additional payment of $4,000 in period t=1 and period t=2, how long will it take to repay the mortgage?
1. You have been approved for a mortgage for a property. The mortgage is for a 20-year period with a 7.2% annual interest rate for a total amount of $1,700,000 What is the annual payment if payments are made annually What would you put in your annual cash flow if you were paying the mortgage on a monthly basis? What will be the interest and principal payments for the second and third years of the mortgage? What will be the remaining principal balance at the end of the fifth year? Answer question using excel formulas
assume a $175,000 mortgage loan and 10-year term. The lender is charging an annual interest rate of 6 percent and 4 discount points at origination. a. What is the monthly payment Assuming that it is based on an amortization period of 30 years? b. What will be the required balloon payment at the end of the tenth year? c. What is the effective borrowing cost on the loan if it is held to maturity? Give typing answer with explanation and conclusion
3. A) What would be the monthly payment on a 15 year mortgage of $200,000 with an APR of 12.3% compounded monthly? 12 B) If you could only afford to pay half of that amount, how long would it take to pay off the mortgage?