please excel solve that!!!please

>Input your student number digit by digit in cells F3 to M3. You must input your own student ID otherwise a penalty of 6.5 marks applies. Enter your name into the cells 03 and 04. 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 years you have to repay the loan. In cell C5, calculate the number of months you have to repay the loan using a reference to cell C4. In cell C6, the nominal annual interest rate compounding monthly is computed automatically with the input of your student number (expressed as a percentage). In cell C7, calculate the monthly interest rate for the loan using a reference to cell C6. In cells C8, the amount of the original loan is computed automatically with the input of your student number. In cell C9, use the EPMT() function to calculate the month-end repayment that includes both the principal and the interest amount. You must show your answer as a positive number. You must use cell references among cells C4 to C8. Prepare a loan amortisation schedule including each month of the loan term using the following detailed steps (all amounts are positive): a) Starting from cell A13, create month labels in terms of integers (e.g., 1, 2, 3, ...) in column A by using a new row for each month of the loan. b) Show the balance of the loan at the beginning of each month in column B. Show the interest paid for each month in column C. Show the principal paid for each month in column D. Show the balance of the loan at the end of each month in column E. c) In columns B, C, D, E you must use Excel formulas or functions with cell references. You will be awarded a zero mark for the whole column if you hardcode any number in any cell. d) You need to use relative and/or absolute cell references where necessary. This means that the contents of cells B14, C13. D13 and E13 can be copied down to the end of the column. You will lose marks for any unnecessary inconsistencies in your functions. Do not round any numbers in the amortisation schedule. Use a currency format (with 2 decimal places) in all cells in columns B, C, D, E of your schedule, showing dollars and cents e.g. $12,345.67. In this part of the assignment, you are required to prepare a loan repayment schedule for a mortgage loan you borrowed from the bank. The loan is to be repaid by equal month-end repayments starting from the end of the first month. The monthly repayments include both the interest and the principal of the loan (P&1). The term of the loan is n years. Complete the table below showing the variables you need for the loan repayment schedule Student number digit by digit Number of years you have to repay the loan, n. Number of months you have to repay the loan, nem Nominal annual interest rate p.a compounded monthly (m) 0.00% Effective monthly interest rate (i=jm/m) Original loan amount Fixed monthly repayment (P&I) amount Answer must be positive (greater than 0) DO NOT Round any amounts in the Amortisation Schedule. Use format commands to display as currency. Loan Amortisation Schedule Month Balance at the beginning of month Interest paid Principal paid Balance at the end of month Based on your amortisation schedule, calculate answers to Q1 to Q7 in the highlighted cells below using excel TVM functions and referencing the relevant cells in worksheet 'Amortisation Schedule'. Answer each question using AT LEAST ONE of Excel's TVM functions from among =PV, EFV, EPMT, ERATE, ENPER, =IPMT, EPPMT, =CUMIPMT, = CUMPRINC. Question 5 to Question 9 are new independent scenarios which are not related to each other. For all the questions below, your answer must be positive (greater than 0). Do NOT round your answer (unless required by the questions) but format as dollars and cents or percentages if necessary. Do NOT include any words such as "months" in your answer. Q1 Calculate the amount of principal paid in the month 30. (0.5 Q2 (0.5 Calculate the total amount of interest paid from the beginning of month 60 to the end of month 90. Q3 (0.5 Calculate the amount of the loan outstanding balance at the end of month 45. Q4 (1 mark) At the end of which month will it be for the loan outstanding balance to be less than 60% of the original loan amount for the first time? Useful clue: Which function gives the number of time periods? Think about the rounding rules for the final answer. Roundup or rounddown? Remember you can check your answer in the amortisation Useful clue: You can start with calculating the loan outstanding balance when the interest changes. You can use a function as an input/argument for another function. Q5 (1 mark) New Scenario (Independent): At the end of the month 75, the interest rate increases. To pay off the loan by the original date, you need to increase the original month-end repayment amount by 3%. Calculate the increased interest rate p.a. compounded monthly. Q6 (1 mark) New Scenario (Independent): At the end of the year 4, the interest rate is increased. The new rate is 3% p.a. compounded monthly more than the original rate. To pay off the loan by the original date, calculate the increased month-end repayment amount. Useful clue: You can start with calculating the loan outstanding balance when the interest changes. You can use a function as an input/argument for another function. Q7 (1 mark) New Scenario (Independent): Because of COVID-19, the bank agrees to extend your total loan term by 5 years. The interest rate is unchanged. Calculate how much more total interest you need to repay in this case. Useful clue: Which function gives the total interest paid? Useful clue: You can start with calculating the required month-end repayment you need to pay off the loan by the original date. You can use a function as an input/argument for another function. Q8 New Scenario (Independent): (1 mark) Suppose you only repay the interest amount of the loan each month end for the first 5 years. To be able to pay off the loan by the original date, you will repay a higher month-end repayment including the principal and the interest when the interest only period expires. Calculate the loan outstanding balance at the end of year 9. Q9 New Scenario (Independent): (1 ark) You lose your job because of COVID-19 and the bank agrees that you do not make any repayment for the first 36 months. The interest keeps accumulating during this period. From month 37, you will need to repay equal month-end repayments including the principal and the interest (P&I). Calculate the month-end repayment you Useful clue: You can start with calculating the loan outstanding balance before you start your repayments. You can use a function as an input/argument for another