7. The money required to pay off a fixed-term mortgage is described by the ordinary annuity equation: c = √(1-(1 + i)"] C where C is the borrowed capital, P is the monthly payment, i is the interest rate, and n is the number of payment periods. If a borrower can afford a monthly payment of $450, what is the maximum interest rate the borrower can afford on a 25-year mortgage of $50,000? (Use any numerical method to approximate the answer)

7. The money required to pay off a fixed-term mortgage is described by the ordinary annuity equation: c = √(1-(1 + i)"] C where C is the borrowed capital, P is the monthly payment, i is the interest rate, and n is the number of payment periods. If a borrower can afford a monthly payment of $450, what is the maximum interest rate the borrower can afford on a 25-year mortgage of $50,000? (Use any numerical method to approximate the answer)

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

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. 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?
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?
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: $
ii) Suppose one estimates that they can afford to repay £1200 a month for 25 years on a mortgage. Interest is calculated at 4.3% p.a., payable monthly. How large a mortgage can the individual afford?
(a) Find the monthly mortgage payment on a $170000 15-year mortgage if the interest rate on the loan is 3.81%. (b) How much will you pay in interest over the life of the loan if you pay the minimum monthly payment each month?
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?
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
Assume the monthly payment of a loan amount of $400,000 is $1450. How long will it take to retire the loan if the annual interest rate is 4% ? Use the equation, Monthly payment= Where : P = principal (the amount of your mortgage r = the annual interest rate y = length of the mortgage P∗r12 1−(1+r12 )−12 y
Suppose a bank offers you a 4.99% interest rate on a 20-year mortgage to be paid back with monthly payments. Suppose the most you can afford to pay in monthly payments is $1500. How much of a mortgage could you afford? a.) $224,787.34 b.) $227,478.34 c.) $227,847.25 d.) $228,743.72
Based on Exhibit 9.9, or using a financial calculator, what would be the monthly mortgage payments for each of the following situations? Note: Round tin value factor and final answers to 2 decimal places. What relationship exists between the length of the loan and the monthly payment? How does the mortgage rate affect the monthly payment? a $120,000, 15-year loan at 5 percent b. $86,000, 30-year loan at 4.5 percent. c$105,000, 20-year loan at 4 percent d-1. Longer mortgage terms mean a d-2 For increase in mortgage rate Monthly Mortgage Payment monthly payment monthly payment is required
Please eolve this question on excell and show formulas please.