Please show all work in a spreadsheet.

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 the Monthly payment 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).

b2) 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)