1. Assume that you can get a home loan from your local cooperatively owned credit union. It is a $375,000 loan, but you must pay a S1000 not refundable processing fee, and you must purchase stock in the amount of $2000.00 which earns nothing but you get it back at the end of the loan period). The annual interest rate offered would be 6.6%, and you would make MONTHLY payments for 15 years until the loan is paid off. a. Calculate the Monthly payment on the $350,000 loan at 6,6% annual interest b. What would be the period 0 cash flow (loan proceeds - the stock purchase - the processing fee). c. What would be the final period cash flow (the final payment + the stock back). d. Set the problem up in a spreadsheet and calculate the IRR of the cash flow stream. (be sure to convert it back to an annual rate and go to 4 places past the decimal) 2. Suppose you have another option of borrowing the $375,000 from a local bank. There is no stock purchase requirement, and no processing fee. The bank will loan you the money on a 15 year Monthly payment plan for 6.68% annual interest. Calculate the annual IRR of this cash flow stream. Which is the better deal (Bank or Credit Union), and why. 3. Your have made a decision to purchase a new Pickup, and have negotiated a purchase price of $44,300. The dealer is giving you two finance options. They will finance the entire purchase price ($44,300) at a bargain rate of 1.9% annual interest for 36 equal monthly payments, or they will give you an additional $2,000 rebate on the purchase and finance the balance at 6.0% annual interest for 36 equal monthly payments. (A) Which of these two alternatives is a better financing deal? (Hint: in either case you are getting the equivalent of $44.300 (the truck) in period 0, so compare the payments on the full purchase price at 1.9% with the payments on the lower purchase price after the rebate at 6.0%). (B) What would the rebate need to be in order to make these two options equal? (C) As recently as 1 year ago dealers were offering similar deals with 60 month financing. Why have they shortened the length of loans they are willing to commit too? Please turn in enough of your spreadsheet that we can see how you approached the problems