suppose you are going to buy a home worth 110000 making a down payment of 50000. the balance will be borrowed from the capital savings and loan bank.

How can I solve this using Excel.

3.76 Suppose you are going to buy a home worth $110,000, making a down pay- ment in the amount of $50.000. The balance will be borrowed from the Capital Savings and Loan Bank. The loan officer offers the following two financing plans for the property: Option 1: A conventional fixed loan at an interest rate of 13% compounded monthly over 30 years with 360 equal monthly payments Option 2: A graduated payment schedule (FHA 235 plan) at 11.5% interest compounded monthly with the following monthly payment schedule: Monthly Mortgage Year (n) Monthly PaymentInsurance $497.76 $522.65 $548.78 $576.22 $605.03 $635.28 $25.19 $25.56 $25.84 526.01 $26.06 $25.96 4 6-30 For the FHA 235 plan, mortgage insurance is a must. (a) Compute the monthly payment for Option 1. (b) What is the effective annual interest rate you would pay under Option 2? (c) Compute the outstanding balance for each option at the end of five years (d) Compute the total interest payment for each option. (e) Assuming that your only investment alternative is a savings account that earns an interest rte of 6% compounded monthly, which option is a better deal