41. You are considering buying a house with a mortgage of $250,000. The current interest rates for a mortgage loan for a 15- year period are 7.5% p.a. fixed or 6.75% p.a. variable. Based on historical data, the variation in the variable rate is thought to be from a low of 6.0% to a high of 8.5%, with the most likely value as 7.25%. The variable interest rate is fixed at the beginning of cach year. Answer the following questions: What are the maximum and minimum yearly payments that would be expected if the variable interest option is chosen? For simplicity assume that the compounding period is one year Set up a Monte-Carlo simulation by picking 20 random numbers and using these to choose the variable interest rate for each of the 20 years of the loan Calculate the yearly payments for each year using the data from Part (b). Hint: You should keep track of the interest paid on the loan and the remaining principal. The remaining principal is used to calculate the new yearly payment with the new yearly interest rate. 41. You are considering buying a house with a mortgage of $250,000. The current interest rates for a mortgage loan for a 15- year period are 7.5% p.a. fixed or 6.75%p.a. variable. Based on historical data, the variation in the variable rate is thought to be from a low of 6.0% to a high of 8.5%, with the most likely value as 7 25%. The variable interest rate is fixed at the beginning of each year. Answer the following questions: What are the maximum and minimum yearly payments that would be expected if the variable interest option is chosen? For simplicity assume that the compounding period is one year Set up a Monte-Carlo simulation by picking 20 random numbers and using these to choose the variable interest rate for each of the 20 years of the loan Calculate the yearly payments for each year using the data from Part (b). Hint: You should keep track of the interest paid on the loan and the remaining principal. The remaining principal is used to calculate the new yearly payment with the new yearly interest rate, 41. You are considering buying a house with a mortgage of $250,000. The current interest rates for a mortgage loan for a 15- year period are 7.5% p.a. fixed or 6.75% p.a. variable. Based on historical data, the variation in the variable rate is thought to be from a low of 6.0% to a high of 8.5%, with the most likely value as 7.25%. The variable interest rate is fixed at the beginning of cach year. Answer the following questions: What are the maximum and minimum yearly payments that would be expected if the variable interest option is chosen? For simplicity assume that the compounding period is one year Set up a Monte-Carlo simulation by picking 20 random numbers and using these to choose the variable interest rate for each of the 20 years of the loan Calculate the yearly payments for each year using the data from Part (b). Hint: You should keep track of the interest paid on the loan and the remaining principal. The remaining principal is used to calculate the new yearly payment with the new yearly interest rate. 41. You are considering buying a house with a mortgage of $250,000. The current interest rates for a mortgage loan for a 15- year period are 7.5% p.a. fixed or 6.75%p.a. variable. Based on historical data, the variation in the variable rate is thought to be from a low of 6.0% to a high of 8.5%, with the most likely value as 7 25%. The variable interest rate is fixed at the beginning of each year. Answer the following questions: What are the maximum and minimum yearly payments that would be expected if the variable interest option is chosen? For simplicity assume that the compounding period is one year Set up a Monte-Carlo simulation by picking 20 random numbers and using these to choose the variable interest rate for each of the 20 years of the loan Calculate the yearly payments for each year using the data from Part (b). Hint: You should keep track of the interest paid on the loan and the remaining principal. The remaining principal is used to calculate the new yearly payment with the new yearly interest rate