7. A corporation borrows a $20 million. The loan is repaid in the next 4 years, in 8 equal semi-annual payments, starting in six months. Assuming the loan carries 10% interest rate; calculate the equal payment and the interest charged every year (there are two payments per year, you need to provide the interest for the whole year). Use Excel for this question.