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

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!