My wife wants us to purchase a rental house at the beach in Delaware, where we like to go periodically. We would need to borrow approximately $200,000.00 to make the deal. We can get a loan from a local Credit Union. It would be a $200,000 loan, but we must pay a $2500 not refundable processing fee, and we must purchase stock in the amount of $1000.00 which earns nothing (but we get it back at the end of the loan period) In addition, we would also incur a $1,000 not refundable appraisal fee (all of these would be withheld from the loan proceeds). The annual interest rate offered would be 4.6%, and we would make MONTHLY payments for 15 years until the loan is paid off.

a. calculate monthly pmt on the $200,000 loan at 4.6% annual interest

b. What would be the period 0 cash flow (loan proceeds the stock purchase the processing fee the appraisal fee).

If the house costs $235,000.00, how much would we have to come up with for the total out of pocket down payment?

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)

E. Suppose you have another option of borrowing the $200,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.80% annual interest.

Calculate the annual IRR of this cash flow stream. Which is the better deal (Bank or Credit Union), and why.