answers has to be in excel

and my ID number ends with odd number, so 12 months FD rates

You intend to save up to at least RM60,000 in 3 years' time as the down payment for an apartment. In order to do so, you are thinking of saving RM1,000 per month for 3 years based on the following saving options. Fixed deposits Stocks Bonds Weights Saving Plan A B 60 40 20 20 30 20 20 30 60 You may use the P/E ratio of Bursa Malaysia's composite index to roughly gauge the return of stocks. If your student ID ends with an even number, use 6 months FD rates and those ending with an odd number, use 12 months FD rates to compute the return of savings in FD. (a) Discuss the total value of each savings option will reach. 10 marks (b) Simulate 1000 iterations based on your findings in (a). Are your results in (a) similar to those in (b)? Why or why not? 10 marks (c) Suggest two real-world factors that might be important to consider in designing this simulation problem. 4 marks You intend to save up to at least RM60,000 in 3 years' time as the down payment for an apartment. In order to do so, you are thinking of saving RM1,000 per month for 3 years based on the following saving options. Fixed deposits Stocks Bonds Weights Saving Plan A B 60 40 20 20 30 20 20 30 60 You may use the P/E ratio of Bursa Malaysia's composite index to roughly gauge the return of stocks. If your student ID ends with an even number, use 6 months FD rates and those ending with an odd number, use 12 months FD rates to compute the return of savings in FD. (a) Discuss the total value of each savings option will reach. 10 marks (b) Simulate 1000 iterations based on your findings in (a). Are your results in (a) similar to those in (b)? Why or why not? 10 marks (c) Suggest two real-world factors that might be important to consider in designing this simulation problem. 4 marks