in excel

Problem 1: A loan for $8,000 with nominal interest rate of 12% that is to be repaid in full at the end of 5 vears has two installment repayment options: a) Monthly b) Yearly Calculate the monthly and yearly payment amounts, "A", by first identifying for each repayment option: The present value, " p " the effective interest rate, lem, the number of time periods, n Next, develop a cash flow table in MS Excel for each of the two repayment options for this loan. Identify the correct time period units to use in the cash flow tables, the total number of time periods, and the correct dollar amounts for your cash inflows and outflows at each time period. Then develop a cash flow diagram in MS Excel using the cash flow table with a stacked column chart. Next, Show the correct "traditional" interest factor equation for each option, and solve using information from the appropriate interest factor table(s) provided in the textbook or in Canvas. Include screen shots of the interest factor tables you used and explain your specific choices of interest factor values from the table(s). Does the annual payment amount equal 12 times the monthly payment amount? Why or why not? Re-solve this problem using appropriate excel functions. Explain why you chose your particular excel function(s), and how it is used (i.e., input values, etc.). Explain any differences you can identify between the traditional method solution and the excel function method solution