1. Using Excel, compute the effective interest rate on each of the following loans. Each is for $100,000, fully amortizing over 20 years, and the contract interest rate is 9%:

a) A 6% front-end fee, with no prepayment anticipated b) A 5% front-end fee, with prepayment planned after five years (no prepayment penalty) c) A 4% front-end fee and prepayment planned after 10 years (a prepayment penalty equal to 2% of the unpaid balance)