An ARM is made for $150,000 for 30 years with the following terms: initial interest rate = 7 percent index = 1-year treasuries payments reset each year margin = 2 percent interest rate cap = none payment cap = 5 percent increase in any year discount points = 2 percent Fully amortizing; however, negative amotrization allowed if payment cap reached. (BOY) 2 = 7 percent ; (BOY) 3 = 8.5 percent ; (BOY) 4 = 9.5 percent ; (BOY) 5 = 11 percent Compute the payments, loan balances, and yield for the ARM for the five-year

A 3/1 ARM is made for $250,000 at 7 percent with a 30-year maturity. Fixed payments are to be made monthly for three years, after which the interest rate will reset. Refer to the original question (1, 2), assuming the INTEREST RATE CAP of 2%, what would new payments be beginning in year 4 if the interest rate instead rose to 10%? Hint: the capped rate does not allow the new rate to go above certain point. (question one was If the loan is fully amortizing, what will be the monthly payments? 1663.26; and question two was What will be the loan balance after three years? 241,817.41) Please asnwer as excell format using rate, NPER. PV, FV, and PMT

Find the future values of these ordinary annuities. Compounding occurs once a year. Do not round intermediate calculations. Round your answers to the nearest cent. $300 per year for 8 years at 10%. $   $150 per year for 4 years at 5%. $   $200 per year for 4 years at 0%. $   Rework parts a, b, and c assuming they are annuities due. Future value of $300 per year for 8 years at 10%: $   Future value of $150 per year for 4 years at 5%: $   Future value of $200 per year for 4 years at 0%: $

Prepare an amortization schedule for a four-year loan of $40000. The interest rate is 8 percent per year, and the loan calls for equal annual payments. Rework it by assuming that the loan agreement calls for a principal reduction of $10000 every year instead of equal annual payments. include excel file