Question: Please do it in excel and show excel formular Fiona has taken an annuity loan The amount of loan she took was 150,000.00 The loan

Please do it in excel and show excel formular
Fiona has taken an annuity loan The amount of loan she took was 150,000.00 The loan term is 18 years with monthly payments. The interest rate of the loan is Euribor 12-month rate + margin The margin is 105 %-points and in the beginning the Euribor 12-month rate was 0,75% After the first year the 12-month Euribor changes to 0,84% a) Calculate the remainder of loan after the first year. b) Calculate the new equal payment after the change in the rate. c) How many percent and to which direction does the equal payment change? Original equal payment Amount of loan Annual interest rate Payments in a year Loan term (in years) Relative interest rate Number of payments Original equal payment Remainder of loan Number of payments made already Number of unpaid payments Remainder of loan Change in interest rate New annual interest rate New relative interest rate New equal payment
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
