Calculate the payment and rate adjustments for the following scenario. 5/1 Interest Only ARM  $600k Loan amount 5% Interest Rate 30 year loan tenure Margin: 2.75 CAPS are 3/2/6 Index: 12 Month Treasury Average    1. What is the payment on this mortgage? 2. If the 5 year fixed period ends this month using the current 12 month Treasury average, what would the fully indexed rate be?  Would it be affected by the CAPS?  I want you to research the web to determine what the current 12 month Treasury average is.  3. If the 12 month Treasury average jumps to 3.75 for next year's adjustment, what is the new rate considering the CAPS?

Q: show steps to calculation with screenshots of excel !! Consider a $ 5,000,000, 8.5% APR, 30-year…

A: Interest Rate 8.50%Loan Amount $      5,00,000.00Mortgage, Year30Coupounding Period12

Q: A loan 1000 is repaid by equal annual amounts of principal for 10 years and annual interest of 7% on…

A: Equal installment  = Loan Amount / present value annuity Factor @rate of interest for life

Q: Estimate the annual percent rate for the add on loan Using the given number of payments and annual…

A: As per the information provided:  N = 48 R = 8% To determine: We have to estimate the annual…

Q: The interest rate is 10%.  There is a 2-year loan with two specific payments:  $110 to be paid next…

A: Given: Interest rate =10%Payment made in next year)=$110 Payment made in two years=$500

Q: Suppose you are considering an ARM with the following characteristics: Mortgage Amount = $ 350,000…

A: Here, Initial Contract Rate5.50%Index for Year 2 Onwards6.50%Margin2.50%Annual Cap2.00%Lifetime…

Q: What would the monthly payments be on a $65,000 loan if the mortgage were set up as:   A 15-year,…

A: A mortgage payment typically refers to the regular payment that a borrower makes to a lender to…

Q: For a $100,000 mortgage for 25 years at a 11.5% rate (monthly payments), find   4) If 8.685 points…

A: We need to use excel RATE function to calculate yield to lander. The formula is…

Q: It is important to know how to build an amortization schedule when firms (or individuals) take out…

A: Given: Loan amount (P): $60,000 Number of periods (n): 3 years =3*12= 36 months Interest (i): 12%…

Q: You are considering the following fixed interest rate mortgage loan alternatives: Alternative 1:…

A: In order to calculate the incremental cost of borrowing, we will have to use the difference in the…

Q: Find the amount of interest and the maturity value of the following loan. Use the formula MV = P+ I…

A: Rate = 7% + (1/4)% Rate = 7% + 0.25% Rate = 7.25% ----------------------- Years = 4 + (1/2) Years =…

Q: Consider two loans with one-year maturities and id and a(n) 8.4% loan with a 4.5% (no-interest) comp…

A: Effective annual rate refers to the interest rate that is being charged by the lender to the…

Q: Determine the periodic payments PMT on the given loan or mortgage. (Round your answer to the nearest…

A: Loan = $90,000 Interest = 3% Monthly interest = 0.03/12 =0.25% Time =10 years Monthly period =10*12…

Q: Compare the monthly payments and total loan costs for the following pairs of loan options. Assume…

A: A mortgage is a loan provided by a bank or lender to help individuals purchase real estate, such as…

Q: Find the interest rate (APR) on a 27-year mortgage with a initial loan amount of $358,000, if the…

A: A mortgage refers to a covered loan borrowed for the purchase of property with the property itself…

Q: a. $64,000, 15-year loan at 7.00 percent. b. $140,000, 30-year loan at 5.50 percent. c. $104,000,…

A: Since you have posted a question with multiple sub-parts, we will solve the first three sub-parts…

Q: You plan to take out a 9 month loan of $12mm in 6 months. The following schedule reports interest…

A: Forward Interest rate for 9 month loan in 6 months = [[(1+r15)/(1+r6)] - 1]*(12/n) r15 =  5 *15/12…

Q: Consider a five-year floating rate loan with principal of $10 million and quarterly payments based…

A: Given information: 5 year floating rate loan of $10 million

Q: Question A loan can be settled by monthly payments of $350 in four years at 5.5% compounded monthly.…

A: In the given case,  Monthly payment = $350 Monthly rate of return = r  No. of payment at the time of…

Q: . Assume you have just taken a 30-year mortgage of $550,000 at 9% with monthly compounding. Further,…

A: Loans are paid by equal monthly installments that carry the payment for interest and payment for…

Q: Use the following information to answer the next 3 questions. $280,000 Loan Amount 30 year loan with…

A: To convert the time period in months, multiply it by 12 To convert interest monthly, divide it by 12…

Q: What is the EAR?

A: Interest = loan amount * interest rate = $10,000*0.13 = $1,300Next, we calculate the points paid on…

Q: Use the following amortization chart: Selling price of home Down payment Principal (loan) Rate of…

A: Number of monthly payment periods = Number of years*12 = 30×12 = 360

Q: Compare the monthly payments and total loan costs for the following pairs of loan options. Assume…

A: Monthly Payment on Loan: This monthly payment is computed from the interest charged on the loan and…

Q: Consider a mortgage of 180,000. What is the payment if it has a 15 year fixed rate at 3.5% with…

A: The monthly mortgage payment is the total of the Principal repayment and interest cost which is due…

Q: Compare the monthly payments and total loan costs for the following pairs of loan options. Assume…

A: Option 1 Loan Amount = $1,10,000 Number of payments = 30 x 12 = 360 Monthly interest rate = 9% / 12…

Q: Compare the monthly payments and total loan costs for the following pairs of loan options. Assume…

A: Total paid amount refers to an amount that is paid in total in the whole period of repayment of the…

Q: What is the yield to maturity (YTM) on a simple loan for $1,500 that requires a repayment of $4,500…

A: Final Value (FV) = $4,500Present Value (PV) = $1,500Number of years (n) = 5

Q: Compare the monthly payments and total loan costs for the following pairs of loan options. Assume…

A: A loan is a financial arrangement in which one party, typically a lender, provides a sum of money to…

Q: The formula below tells us how to obtain the maturity value on a simple discount loan if we are…

A: Simple discount rate = 7.56% How many years for debt to double? Assuming Debt = 100 Future Value = 2…

Effective Interest Rate

The term interest rate can be defined as the amount that is charged by the lender as a percentage on the principal amount. Interest rate which is charged annually is known as annual percentage rate.