Two years ago Peter borrowed from a bank 20 000 euros for 6 years. The interest rate for the bank loan was 8% and the repayment schedule is based on monthly annuity payments. Now, after two years have passed, the interest rates have declined and his economic situation has improved (e.g. interest margin declined). Peter now has an opportunity to refinance the remaining loan balance with a 4% interest rate. However, there is a catch. The fee for refinancing is 300 euros.
Questions: PLEASE SOLVE WITHOUT USING EXCELL
a) Find the initial monthly loan payment
b) Find the loan balance after two years
c) Now find the new monthly payment if loan is refinanced (maturity is still 4 years)
d) Should Peter refinance?