Lindsay is 30 years old and has a new job in web development.She wants to make sure that she is financially sound by the age of55, so she plans to invest the same amount into a retirementaccount at the end of every year for the next 25 years. (a)Construct a data table in Excel that will show Lindsay the balanceof her retirement account for various levels of annual investmentand return. If Lindsay invests $10,000 at return of 6%, what wouldbe the balance at the end of the 25th year? Note that becauseLindsay invests at the end of the year, there is no interest earnedon the contribution for the year in which she contributes. Roundyour answer to a whole dollar amount. $ (b) Develop a two-way tablefor annual investment amounts of $5,000 to $20,000 in increments of$1,000 and for returns of 0% to 12% in increments of 1%. From the2-way table, what are the minimum annual investments Lindsay’s mustcontribute for annual rates ranging from 6% to 11%, if she wants toaccrue a final payout of at least $1 million? Note that becauseLindsay invests at the end of the year, there is no interest earnedon the contribution for the year in which she contributes. AnnualReturn Minimum Annual Investment 6% $ 7% $ 8% $ 9% $ 10% $ 11%$
***Please use excel and upload excel screenshotwith formula
