A loan for $8,000 with nominal interest rate of 12% that is to be repaid in full at the end of 5 years 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, ieff, 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 then solve using information from the appropriate interest factor table(s) in the back of the textbook or from the internet. 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