A bank is considering giving a loan of 5000 to a customer at a rate of % where is the last non-zero digit of your Student Identity Number (SID).

The loan is repaid in annual instalments over a fixed number of years. You have been asked to provide information about the loan.

Using Excel, or otherwise, produce a table showing the annual repayment amount for a range of repayment terms from 5 years up to 10 years inclusive. You must show your working for at least one of the repayment terms.

The loan was issued for 10 years.

You are preparing the accounts for the bank 5 years after the loan was issued i.e. immediately after the 5th repayment was made.

The rate at which the loan was issued has now doubled.

Calculate the value of the remaining payments to be included in the accounts.

Calculate the interests and the capital payed by the customer each of the remaining years of the loan.

student ID? what do you mean ?

oh i see, my student number is 2597416

Investigation 5 - Loans A bank is considering giving a loan of 5000 to a customer at a rate of n% where n is the last non-zero digit of your Student Identity Number (SID). The loan is repaid in annual instalments over a fixed number of years. You have been asked to provide information about the loan. r U TU C Task 8 - Basic Information (Maximum Mark 3) Using Excel, or otherwise, produce a table showing the annual repayment amount for a range of repayment terms from 5 years up to 10 years inclusive. You must show your working for at least one of the repayment terms. Task 9 Change of rate (Maximum Mark 6) The loan was issued for 10 years. You are preparing the accounts for the bank 5 years after the loan was issued i.e. immediately after the 5th repayment was made. The rate at which the loan was issued has now doubled. Calculate the value of the remaining payments to be included in the accounts. Calculate the interests and the capital payed by the customer each of the remaining years of the loan