Need help with formulas to be used to calculate in excel.

1. The Knutson Corporation needs to save $15 million to retire a $15 million mortgage that matures in 10years. To retire this mortgage, the company plans to put a fixed amount into an account at the end of each year for 10years. The Knutson Corporation expects to earn 5.7 percent annually on the money in this account.
2. What equal annual contribution must the firm make to this account to accumulate the $15 million by the end of 10years?
3. Prepare, on a spreadsheet, how the deposits will accumulate to $15 Million