PLEASE ANSWER IN EXCEL FORMAT

5) So you want to buy a condo and you want to comparison shop. You have 3 different options where the rates and years go together and 3 different condos. You will put down 15% as a down payment for each and borrow the rest from a bank. Please tell me the monthly payment, the total cost, the first month interest and the last months interest for each option. Option 1 15 Option 2 20 Option 3 30 Years Rates .035 .045 .055 Condos costs: A 450,000 B 350,000 C 395,000