1. You plan to purchase a $100,000 house using a 30 - year mortgage obtained from your local credit union. The mortgage rate offered is 8.25 percent. a. Calculate your monthly payments on this mortgage. b. Create an excel file with 7 columns (months, Payment, Interest, Principle, Balance, \%Interest and \%Principle) for all 360 months. c. Calculate the amount of interest paid over the life of this mortgage