please input what you would type into each cell to get the right answer

A B D E F G Question 2. You borrow a 20 million dollars loan at 8% annual interest rate for 7 years with 7 equal annual payments at the beginning of each year. 2 3 4 Loan principal 5 Interest rate 6 Years 7 Annual payments 8 (1) Please calculate the annual payment (50% propotion of question 2's points) (2) Please show the amortization schedule (50% propotion of question 2's points) 8 Year Principal at beginning of year Payment at beginning of year Interest occurred Principal reduction Ending Principal 9 10 1 11 2 12 3 13 4 14 5 15 6 16 7 17 18 19