Solve using excel:

A. You have taken out a $225,000, 3/1 ARM. The initial rate of 5.8% (annual) is locked in for 3 years and is expected to increase to 6.5% at the end of the lock period. Calculate the initial payment on the loan. (Note: the term on this 3/1 ARM is 30 years)

B. Given the following information, calculate the Effective Borrowing Cost (EBC). Loan amount: $175,000, Term: 30 years, Interest rate: 7 %, Payment: $1,164.28, Discount points: 1, Origination fee: $3,250. Assume the loan is held until the end of year 10.

C. Suppose you have taken out a $200,000 fully-amortizing fixed rate mortgage loan that has a term of 15 years and an interest rate of 4.25%. In month 2 of the mortgage, how much of the monthly mortgage payment does the principal repayment portion consist of?