Investment analyst John would like to evaluate how well a value fund perform in recent years. He collected five years monthly data and estimated the mean of monthly return is $0\mathrm{.}82\%$ and the standard deviation of monthly returns is $1\mathrm{.}55\%$

NORM.S$.$INV$(95\%)-1\mathrm{.}645$; NORM.S$.$INV$(97\mathrm{.}5\%)-1\mathrm{.}96$; T$.$INV$(95\%,59)=1\mathrm{.}67$; T$.$INV$(97\mathrm{.}5\%,59)=2\mathrm{.}00$; CHISQ.INV$(5\%,59)-42\mathrm{.}34$; CHISQ.INV$(95\%,59)-77\mathrm{.}93$; $39$CHISQ.INV$(2\mathrm{.}5\%,59)-39\mathrm{.}66$: CHISQ.INV$(97\mathrm{.}5\%,59)-82\mathrm{.}12$;

Question A: If the funds target annual return is $8\%$; can this fund meed the target return given $90\%$ of chance? Type the crucial steps to support your conclusion.

Question B: If the funds target standard deviation annual return is $12\%,$ can this fund meed the target return given $95\%$ of chance? Type the crucial steps to support the conclusion.

Question C: If the fund current position is $$1,000,000,$ what is the $95\%$ of VaR $($S$)$ for one year? Assume the annual returns are normally distributed. The mean return and standard deviation are equal to the target return and volatility.