Use excel to answer and show formulas

2. Suppose you have another option of borrowing the $395,000 from a local bank. There is no stock purchase requirement, no processing fee, and the bank will absorb the appraisal fee. The bank will loan you the money on a 15 year Monthly payment plan for 4.50% annual interest. Calculate the annual IRR of this cash flow stream. Which is the better deal (Bank or Credit Union), and why