5. Consider a loan to a company for the purpose of financing a new chemical plant. The characteristics of the loan are: Principal: $50 million Interest Rate: 12% per year Term: 20 years Payment Frequency: Once per year, at the end of the year a) What is the annual payment? b) Make a table illustrating the repayment schedule. (If possible, use a spreadsheet program such as Microsoft Excel.) c) Suppose that the new chemical plant generates profits that are higher than anticipated initially. The company then decides to pay 1.1 times each required annual payment, with the additional money used to prepay the principal. How long will it take for the company to pay back the loan in this case? Assume that there are no penalties or charges for any prepayment. d) Comment on the results in b) and c). -- It will be helpful to draw a cash flow diagram, or other relevant figure, to guide my thinking. For questions that ask for an answer involving words please respond in complete and concise sentences. Please state explicitly any assumptions that you think you need to solve a problem. Unless specified otherwise, all interest rates in this problem are compound interest rates.