Apply in excel and provide a formula sheet ?

You bought a Mega Millions ticket (with Megaplier) and found out that you just missed the jackpot by 1 number, as the second prize winner, you received $5 million. After paying taxes, buying a Maserati, a yacht, and a nice house, you are left with about $1 million. According to statistics, nearly 1/3 of lottery winners declare bankruptcy at one point in their lives, you dont want to be one of them. Now you decide that you are going to blow the rest of your money like a pro! 1. Starting now, you want to put down some money once a year for 30 years to a savings account as a raining day fund. Today you will put down the first saving: $5000, and the amount will grow at 3% every year after that. The savings account with Bank of America offers you 0.03% annual interest rate. You want to know (1) How much is your rainy day fund worth in todays dollars? (2) How much will you accumulate in your rainy day fund after 30 years?