Please answer completely and if possible provide the excel attachments with explainations. PMT for the first scenario would be : 7432

BMAT toto Amortization Project In a group of 2-4, construct an Essel rile which answers the questions given in the following scenarios. You are expected to use the financial functions in Excel. Make your Excel spreadsheet as automa as possible by using cell references so that if one value is changed. subsequent calculations will autotnatically update Use absolute cell refercr in special situations Scenario 1-Personal Loan You just obtained a personal loan for S66.500 at 5.29% compounded monthly. For the fun of it you are choosing to make regular quarterly payments the same size as the first four digits (ignoring the leading zeros) of one of your SAIT student IDs. (eg: if ID is 000123456, then PMT $1234) How many payments will be required to pay off your personal loan? (3 marks) 2) What will be the term of your personal loan in years and months? (2 marks) Prepare a complete amortization schedule for your oar. RoUND an monetary values to the nearest cent Express the values as currency. Don't forget the totals! (8 markr) 4 Perform the following calculations separate from the amortization schedule if you calculate a value, cell reference it in a subsequent step whenever useful a) What will be the interest and principal portions of the 5th payment? (5 marks) What will be the size of the final loan payment? (5 marks) co what will be the total interest charges on this personal loan? (2 marks) Compare the answer to each of the above questions with your results from the amortization too schedule by highlighting the cells in the table corresponding to your caleulated values Choose different colour for each question. Make sure to highlight your calculated answers Note: Calculated values might not match the schedule perfectly due to rounding! This is okay