either one or both if you can. Pls do on excel if possible. Thank you!

40 Interest for a floating rate deal with 2.% teaser rate, 2% annual cap, 7.5% lifetime cap 3% spread with Index of 2%, 2.25%,3%,3.5%, 5% for years 1,2,3,4,5, respectively. + 41 A property was bought for 17 million and was sold 10 years later for $30 million. The property was initially financed with a 75% LTV mortgage. The interest rate on the mortgage was 4.25% and had a 30 year amortization schedule. The property generates $1,360,000 per year. What is the annualized return