2 Coursework description 2.1 Introduction You will to bottom. Ex for 25 years to buy die x = {last 6 digits of your HW Student ID)) For example, if your student ID wamber is HOGSBS the X-632. 2.2 Two mortgages deals To borrow AX for 25 you, you comoding two powible fixed-rate deal. Under each deal the interest rate is fixed lapecified at the interest rate for a specified time-frame (the initial interest rate period). One the mitial interest rate period is finished, the interest rate changes to another rate called the Variaste Rate The Variable Bateledetemi In the airporader. It is not find and can be changed by the denti The details of the two five rate model antext, with interest rates maliwates Follow Initial Variable Rate. Initial interest Mortal cum rate 2-yurt rate 1.0/ 1. 2 years 10-euriedade 21 3.50 10 W Repayments are made thaly in armats. The initial monthly payment momt in calea lated so that it is constant over the terms of the two on the sumption that the Variable Rates as shown in the tale for the remaining term of the more Please do the following in the spreadsheet Morto All payments in your perdert old become to two decal place (QI) I worked QE (a) Calculate and show the 25-long lolote of the year deal b) Calculate the total interest paid under the year deale do not discount ce ulate the interested) 12 mark (a) Calculate the 25g nedle of the 10-st deal (b) Calculate the total interest post the 30-you deal in de mot ducent acerate the interest puid) mark You decide to run a simple care au on the repayment Suppe that when the initial interest rate prind ends, the variable rates of the following instead of the value in the table bowe SW Variable Rate changes to Law Interest Rate 1.00 Melia Intest Rate GO High Interest Rate SO (QA) I were come Meitlily level punto Total intell unde each of the above cemarios for each of the two fixed ratedrale You should the worksheets Qlod Qz to do the calculation out you do not need to the lo schedule for each calculation only the two item ad above (2) In the same worst plein aiglechurt the totalitate the Variabile Rates in the last table abone, glas the chart style for the 2.etate Jl(b) the 16-yeur filate del (90 buwwaberet explain the clientes in the total interest produk between the twisdrale the Variable Ratech 2.3 Five years later Yoopt for the 16-yu finale deal to IX, ne it with furniture Today, which is exactly three years to the trading jet made the oth me you decide to new model toys hollow The Walking dalawa Food In View Se rate and Your choices are the Do nothing lep the deal which you Switch to the year for at deal. Is that compan Early Repayment Change of LX. the time to exit the stifol tate deal Yote to the Early Chrome it to be paid in full widing to the date dat The Variable Platespected to apply to the 18 y deale the remaining years of its initial interest rate periode is that the Symfoond rate pret (09) tu wakabertos (W) Calculate the 20-year-deeg binan berbalead the editing yeat deal starting from jast after the other (6) Caldate the total were to be in todele distichoke the interest and their the deal (06) In wel (a) Cakulate the 23-yes-kes koon schedule of the Siyasetised to deal Calculate the total interest to be paid 107) In witloset QO: Byssing the total interest fails that of a tape deal, state with om if you should change dealer. Sepse and remember to include the cost of the Faly prayer Total 40 marka 2 Coursework description 2.1 Introduction You will to bottom. Ex for 25 years to buy die x = {last 6 digits of your HW Student ID)) For example, if your student ID wamber is HOGSBS the X-632. 2.2 Two mortgages deals To borrow AX for 25 you, you comoding two powible fixed-rate deal. Under each deal the interest rate is fixed lapecified at the interest rate for a specified time-frame (the initial interest rate period). One the mitial interest rate period is finished, the interest rate changes to another rate called the Variaste Rate The Variable Bateledetemi In the airporader. It is not find and can be changed by the denti The details of the two five rate model antext, with interest rates maliwates Follow Initial Variable Rate. Initial interest Mortal cum rate 2-yurt rate 1.0/ 1. 2 years 10-euriedade 21 3.50 10 W Repayments are made thaly in armats. The initial monthly payment momt in calea lated so that it is constant over the terms of the two on the sumption that the Variable Rates as shown in the tale for the remaining term of the more Please do the following in the spreadsheet Morto All payments in your perdert old become to two decal place (QI) I worked QE (a) Calculate and show the 25-long lolote of the year deal b) Calculate the total interest paid under the year deale do not discount ce ulate the interested) 12 mark (a) Calculate the 25g nedle of the 10-st deal (b) Calculate the total interest post the 30-you deal in de mot ducent acerate the interest puid) mark You decide to run a simple care au on the repayment Suppe that when the initial interest rate prind ends, the variable rates of the following instead of the value in the table bowe SW Variable Rate changes to Law Interest Rate 1.00 Melia Intest Rate GO High Interest Rate SO (QA) I were come Meitlily level punto Total intell unde each of the above cemarios for each of the two fixed ratedrale You should the worksheets Qlod Qz to do the calculation out you do not need to the lo schedule for each calculation only the two item ad above (2) In the same worst plein aiglechurt the totalitate the Variabile Rates in the last table abone, glas the chart style for the 2.etate Jl(b) the 16-yeur filate del (90 buwwaberet explain the clientes in the total interest produk between the twisdrale the Variable Ratech 2.3 Five years later Yoopt for the 16-yu finale deal to IX, ne it with furniture Today, which is exactly three years to the trading jet made the oth me you decide to new model toys hollow The Walking dalawa Food In View Se rate and Your choices are the Do nothing lep the deal which you Switch to the year for at deal. Is that compan Early Repayment Change of LX. the time to exit the stifol tate deal Yote to the Early Chrome it to be paid in full widing to the date dat The Variable Platespected to apply to the 18 y deale the remaining years of its initial interest rate periode is that the Symfoond rate pret (09) tu wakabertos (W) Calculate the 20-year-deeg binan berbalead the editing yeat deal starting from jast after the other (6) Caldate the total were to be in todele distichoke the interest and their the deal (06) In wel (a) Cakulate the 23-yes-kes koon schedule of the Siyasetised to deal Calculate the total interest to be paid 107) In witloset QO: Byssing the total interest fails that of a tape deal, state with om if you should change dealer. Sepse and remember to include the cost of the Faly prayer Total 40 marka