PLEASE SHOW HOW TO SOLVE IN EXCEL THANK YOU ALSO THE B ABOVE IS PART OF THIS QUESTION

b. For which option are you going to repay the least total amount? In other words, which mortgage will cost you the least so that you are going to apply for it? (Hint: Suppose for a loan you repay $10 every month for 12 months, total amount you repay is $120.) 4. Suppose that you consider some mortgage options. The price of home is $200k. (1 point) a. Calculate your monthly payments for each option: Option A: 20% down payment at 15-year fixed APR of 4% Option B: 15% down payment at 30-year fixed APR of 4.5% Option C: 10% down payment at 30-year fixed APR of 6%