Consider a Sh. 124,000, 7.00%, 30-year, constant payment mortgage (CPM) with monthly payments. Required a) What is the required monthly payment on this mortgage?
Q: Consider the following fixed-rate level-payment mortgage pass-through security: Total principal…
A: Scheduled monthly mortgage The weighted average rate is rate paid borrower Where r is the rate of…
Q: If an adjustable-rate 30-year mortgage for $120,000 starts at 4.0 percent and increase to 5.5…
A: interest rate =4% Period =30 years Loan amount =120000 Present value FACTOR =1-(1+r)^-n/r Present…
Q: Determine the periodic payments PMT on the given loan or mortgage. (Round your answer to the nearest…
A: Borrowed amount = $200,000 Rate =3% paid quarterly So, quarterly rate =0.03/4 = 0.25% Time =9 years…
Q: Consider that you take out a $250,000, 15-year mortgage with 3.5% interest with monthly payments.…
A: Loan amount (P) = $250,000 Monthly period of loan (n) = 180 (i.e. 15 years * 12) Monthly interest…
Q: Solve the problem. If necessary, use the accompanying table of monthly payments. Round your answer…
A: Mortgage Amount (PV) = $73,500Interest rate (rate) = 10.5%Term of Mortgage = 20 yearsNumber of…
Q: Develop the table below comparing the monthly paymentsfor a 30-year $200,000 mortgage loan with its…
A: Installment is the amount of periodic payments a borrower makes to its lender in order to pay back…
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 periodic payments on the given mortgage. HINT [See Example 5.] (Round your answer to…
A: A fixed rate mortgage is a type of mortgage in which interest rate does not vary and remains…
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: A borrower obtains a fully amortizing loan for $80,000 at 10 percent for 7 year. Payments are…
A: A mortgage is a loan that allows a buyer to acquire a house or other real estate property and repay…
Q: fixed-rate mortgage
A: Introduction: Fixed rate mortgages are home loans that carries a fixed rate of interest for the…
Q: A 30-year mortgage requires payments of $5,455.84 at the end of each month. If interest is 3.23%…
A: Data given: PMT= $5455.84 Interest = 3.23% (compounded semi-annually) n=30 year nper=30*2 = 60…
Q: Consider the following fixed-rate level-payment mortgage pass-through security: Total principal…
A:
Q: Determine the periodic payments on the given loan or mortgage. HINT [See Example 5.] (Round your…
A: Present Value of interest annuity = P * {1-[1/(1+r)^n]/r} Where, r = rate of interest per period…
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: alance on a mortgage was $48,200 and an interest rate of 4.50% compounded semi-annually was charged…
A: Loans are paid by the equal monthly payments that carry the payment for interest and payment for…
Q: Suppose you have a $175,000 30-year mortgage with a 4.5% interest rate on the loan. a. Find the…
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 financed…
A: Given, Principal amount= $95,000 Time period= 15 years Annual percentage rate= 6% The next step…
Q: The effective interest rate on a mortgage with monthly payments is 9.38%. What is the monthly…
A: An Annuity is a series of payments of fixed amounts and at fixed intervals. These can be of two…
Q: Consider a£100,000 mortgage paying a fixed annual rate of 5% which is com- pounded monthly. What are…
A: Borrowings are the liability that is used to finance the requirement of the funds. The borrower…
Q: If an adjustable-rate 30-year mortgage for $121,000 starts at 4 percent and increases to 5.5…
A: Using excel PMT function
Q: A 25 year mortgage requires payments of $3443.75 at the end of each month. If interest 5.84%…
A: Monthly Payment is the payment that is to be paid monthly for a specific period of time to repay the…
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: Determine the periodic payments PMT on the given loan or mortgage. (Round your answer to the nearest…
A: Periodic Payment on Loan: These are payments made to the lender by the borrower for taking on a…
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: You want to take a $172260 mortgage at j2 = 11.59 % and can afford topay up to $5030 per quartely.…
A: Quarterly Payment = $5030 Amount of Mortgage = $172260 Interest Rate per annum = 11.59% Interest…
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: Solve the problem. If necessary, use the table of monthly payments below. Round your answer to the…
A: Mortgage Amount (PV) = $177,000Interest rate (rate) = 9%Term of Mortgage = 10 yearsNumber of…
Q: A $96,000 mortgage is to be amortized by making monthly payments for 20 years. Interest is 7.1%…
A: Mortgage means amount which is borrowed by external sources to meet financial obligation or purchase…
Q: Determine the monthly principal and interest payment for a 15-year mortgage when the amount financed…
A: Excel Spreadsheet:
Q: Consider a standard mortgage (360 months) with monthly payments and a nominal rate of 6.80%. What…
A: Given information: Assume present value is 100 Nominal interest rate is 6.80% Number of periods is…
Q: Consider a $100,000, 30-year, 6.2% mortgage with monthly payments. What portion of the payments…
A: Borrowings are the liability of the company which is used to finance the requirement of the funds.…
Q: Suppose you have a $175,0000 30-year mortgage with a 4.5% interest rate on the loan. a. Find the…
A: The mortgage is a type of loan taken by providing a collateral asset to secure the loan. This kind…
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: Develop the table below by comparing the monthly pay- ments for a $200,000 mortgage loan with an…
A: When time is 100 years N = 100*12, FV = 0, PV = 200,000, rate = 8%/12 use PMT function in Excel…
Q: What is the total interest paid on a 30-year mortgage for $235,000 if it is charged 6.9% interest,…
A: Working note:
Q: Consider a 30-year, fixed-rate mortgage for $50,000 at a nominal rate of 8%. If the borrower wants…
A: In this question we need to calculate the remaining balance on the mortgage after the 10th payment…
Q: A 30-year mortgage for $175,000 is issued at a 6% nominal interest rate. (a) What is the monthly…
A: Mortgage is a long-term amortized loan which is discharged by making periodic payments, generally…
Q: How much you will pay for a 30-years mortgage if the annual payment es $11,147 at a 3.99% annual…
A: Annual compound interest rate is that rate at which interest is charged on annual basis by compound…
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: What is the monthly payment on a 30 year, $250,000 mortgage, with an interest rate of 4%, compounded…
A: The concept of time value of money(TVM) is working on the purchasing power capacity of money which…
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
Q: Consider a 30-year, $115,000 fixed-rate mortgage with a nominal annual rate of 4.65 percent. All…
A: 1)-Amount of loan =$115000Number of monthly payments,n=30 years *12…
Consider a Sh. 124,000, 7.00%, 30-year, constant payment mortgage (CPM) with monthly payments.
Required
a) What is the required monthly payment on this mortgage?
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 1 images
- 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.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 borrower wants to know the monthly mortgage payment (P&I) for a minimum down FHA loan on a $206273 home purchase with 6.0% APR and a 30 year term. What is the principle and interest payment? round answer to nearest dollar.
- 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 itYou want to take a $172260 mortgage at j2 = 11.59 % and can afford topay up to $5030 per quartely. What repayment period in the whole years should you request ? What will be your payment year to repay mortgage in calculatednumber of years ?Q) Compute the interest paid on a 30-year mortgage for $315,073 if the annual interest rate is 4.3%. Solve it early
- G. Find the interest rate (APR) on a 27-year mortgage with a initial loan amount of $358,000, if the monthly payment is $2229.45 Let's use references for input values; and be sure to annualize the rate! INPUTS: OUTPUT: Period Rate is APR Payment Loan amount9) 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?Consider the following fixed-rate level-payment mortgage pass-through security: Total principal outstanding = $5,000,000 Weighted average mortgage (Note) rate = 8.25% Weighted average remaining maturity = 30 years (360 months) Pass-through rate=7.5% What is the scheduled monthly mortgage payment if there is no prepayment?
- 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: $1. Assuming the cost of mortgage is $400,000, and the owner of the house makes a down payment of $40,000, with 8% interest rate and 10 years repayment plan. a. calculate the total amount of loan, monthly rate, number of payment periods, monthly payment, total interest paid, and amount borrowed. b. With the aid of what PMT function in a one variable condition, calculate monthly payment, total amount payable, total interest payable for: 12 yrs, 16 yrs, 20 yrs ,25 yrs, 30 yrs, 35 yrs mortgage.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?