using excel do the following

Create an amoritization schedule for a $1,000,000 loan that requires equal annual payments in each of the next 10 years. The annual rate is 6%. (16 points) How much is the remaining loan balance after 5 years? (8 points) Analyze the amount of each equal payment that goes towards interest and principal in each year. What do you notice? (6 points)