Due to the large volatility in VICs real estate market over 2020-2021, Andy wanted to explore alternative investment options instead of holding the investment property. Suppose that Andy persuaded his parents to sell the house at the current market price ($1,000,000). The gained cash will be invested to a mutual fund, which will distribute a certain percentage (d) of annuity at the end of year (note that the annuity is paid by the mutual fund company, not from the balance of the fund). For instance, if d=5%, and the end-of-year mutual fund balance is $1,000,000, Andy's family will receive an annuity of $50,000 at the year end. Also, 10% of this annuity will be re-invested into the fund, whereas the rest will be used to pay for life expenditure of Andys family. In addition, the mutual fund will grow at a rate of r each year. You are told that:

Both d and r are variant in each year. For instance, d of 2021 and of 2022 may be different;

In each year, the dividend rate d follows a uniform distribution with lower and upper bounds of 0 and 10%, respectively; and

The fund growth rate r follows a normal distribution with mean and standard deviation of 8% and 6%, respectively.

With the above information, build a spreadsheet model to explore the balance of the mutual fund when Andys parents die, using at least 1000 simulations. Demonstrate your results under three scenarios: the maximum of human life is 85, 90 and 95 years, respectively. Also, suppose that the investment property will grow at the constant rate of 5% per year. Discuss whether or not Andy should invest in the mutual fund.

SHOULD ANDY INVEST IN THE MUTUAL FUND , ONLY LOOKING FOR HELP IN WRITING IF ANDY SHOULD INVEST OR NOT AND WHY?