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 2 years 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. 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 2 years 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