Need help with the following questions.

5. In cell C3 is the NPER1 (computed automatically). This represents the number of months that you only repay the interest amount.

6. In cell C4, show the total of the first four digits in your student number using the =SUM() function and referencing cell locations. Marks will be deducted if you have + signs inside the brackets. This is interpreted as the number of remaining years with the P&I repayments after the NPER1 months of interest-only period.

7. In cell C5, calculate the number of remaining months, NPER2 with the P&I repayments based on the result in cell C4.

8. In cell C6, the nominal annual interest rate compounding monthly is computed automatically with the input of student number (expressed as a percentage).

9. In cell C7, calculate the monthly interest rate for the loan based on the result in cell C6.

10. In cells C8, the amount of the initial loan is computed automatically with the input of student number.

11. In cell C9, use the =PMT() function to calculate the month-end repayment including both the principal and the interest amount. This is the amount you pay every month-end after the interest only period expires. You must show your answer as a positive number. You must use cell references among cells from C3 to C8.

N 3 23 F G H I J K L M In this part of the assignment, you are required to prepare a loan repayment scheure tor a loan with an interest-only perrou or the first NPER, months. During the first NPER4 months, only the interest amount (10) is paid at the end of each month. After the first NPER, months, an equal month-end repayment including principal and interest (P&I repayments) is made at the end of each| 1 month for NPER2 months until the end of the loan term. The total loan term is NPER1+NPER, months. 2 Complete the table below showing the variables you need for the loan repayment schedule NPER, Number of months with interest only 46 47 23 04 repayments Student number digit by digit First Name Urja Number of years, n, with Principal & Interest (P&I) repayments Family Name Bhatia NPER, Number of months, n*m, with Principal & Interest (P&I) repayments Interest rate, jm, p.a (compounding monthly) 7.00% Interet rate per month (i=jm/m) $928,608 Fixed monthly repayment (P&I) after the interest 9 only periold expires Answer must be positive (greater than 0) 4 21 5 6 7 8 Loan amount Amortisation Schedule Added Questions Ready 1 115% N 3 23 F G H I J K L M In this part of the assignment, you are required to prepare a loan repayment scheure tor a loan with an interest-only perrou or the first NPER, months. During the first NPER4 months, only the interest amount (10) is paid at the end of each month. After the first NPER, months, an equal month-end repayment including principal and interest (P&I repayments) is made at the end of each| 1 month for NPER2 months until the end of the loan term. The total loan term is NPER1+NPER, months. 2 Complete the table below showing the variables you need for the loan repayment schedule NPER, Number of months with interest only 46 47 23 04 repayments Student number digit by digit First Name Urja Number of years, n, with Principal & Interest (P&I) repayments Family Name Bhatia NPER, Number of months, n*m, with Principal & Interest (P&I) repayments Interest rate, jm, p.a (compounding monthly) 7.00% Interet rate per month (i=jm/m) $928,608 Fixed monthly repayment (P&I) after the interest 9 only periold expires Answer must be positive (greater than 0) 4 21 5 6 7 8 Loan amount Amortisation Schedule Added Questions Ready 1 115%