Please use this excel spreadsheet model to work the problem out.

Suppose you want to buy a house of $500,000. You have $100,000 cash. You have the following options: Option 1: Put in 10% down payment, borrow a 15 year mortgage, invest the rest of your cash at time zero. Invest the monthly payment on a monthly basis after the loan is paid off. Option 2: Put in 10% down payment, borrow a 30 year mortgage, invest the rest of your cash at time zero, invest the difference in future monthly payment compared to option 1 || on a monthly basis Option 3: Put in 20% down payment, borrow a 30 year mortgage, invest the difference in future monthly payment compared to option 1 on a monthly basis. Suppose the 15 year mortgage rate is 5.0%, 30 year mortgage rate is 5.5%, investment return rate is 7%. Which option will yield the most financial return at the end of 30 years? Mortgage rate 15 years Mortgage rate 30 years Investment return rate 5.00% 5.50% 7.00% Initial cash House price 10% downpay amount 10% downpay loan amount initial investment 100000 500000 50000 450000 50000 Saving Interest Years Total Interest Paid Payment Amount 15 30 Difference Investing the Difference Years return of monthly inv return of initial investmen total return at 30 years 15 30 20% downpay amount 20% downpay loan amount 100000 400,000 Saving Interest Years Payment Amount 30 Difference Investing the difference Years return of monthly investment 30 figure out mobtly investment amount and return