what formula should I use on excel to solve this equation

i The Nominal Rate of Return Required to Yield $1,000,000 in Purchasing Power N Years Later, Assuming a Given Rate of Inflation and a Given Nominal Investment Each Year What nominal annual rate of interest must you earn if you deposit the next 50 years if you want to have real purchasing power of years from now and you expect the rate of inflation to be 2 30% $870.00 $1,000,000.00 at the end of each year for 50 Nominal Dollar Amount Required Nominal Annual Rate of Interest Requirede Annually Compounded Rate Calculated from a Monthly Periodic Rate 1.25% per month would have A credit card account that charges interest at the rate of an annually compounded rate of (blank) and an APR of (blank)? APRO Annually Compounded Rate=