Amanda has 30 years to save for her retirement. At the beginning of each year, she puts $5000 into her retirement account. At any point in time, all

I need help making this spreadsheet for my homework and i have no idea how to set it up or how to solve

Amanda has 30 years to save for her retirement. At the beginning of each year, she puts $5000into her retirement account. At any point in time, all of Amanda’s retirement funds are tied up inthe stock market. Suppose the annual return on stocks follows a normal distribution with mean12% and standard deviation 25%. What is the probability that at the end of 30 years, Amanda willhave reached her goal of having $1,000,000 for retirement? Assume that if Amanda reaches hergoal before 30 years, she will stop investing. (Hint: Each year you should keep track of Amanda’sbeginning cash position—for year 1, this is $5000—and Amanda’s ending cash position. Ofcourse, Amanda’s ending cash position for a given year is a function of her beginning cashposition and the return on stocks for that year. To estimate the probability that Amanda meets hergoal, use an IF statement that returns 1 if she meets her goal and 0 othenNise.)