You are required to produce an individual report for this assignment. Your submitted report must include all the three parts to this assignment:- Part 14 An investor with 4 million wants to invest in either of the two following possible options: Option 1: A cash loan for one year, with 6% interest per month, compounded over 12 months. Option 2: Investing in the company that you had chosen in your Coursework 1, using the most recent share price. The plan guarantees a payment based on the latest basic Earnings Per Share (EPS).- Required: (a) Use Excel to compute the returns on both options (attach this working as an appendix to your report)- (b) Present your findings graphically in your report, and briefly comment on your findings. You are required to produce an individual report for this assignment. Your submitted report must include all the three parts to this assignment:- Part 14 An investor with 4 million wants to invest in either of the two following possible options: Option 1: A cash loan for one year, with 6% interest per month, compounded over 12 months. Option 2: Investing in the company that you had chosen in your Coursework 1, using the most recent share price. The plan guarantees a payment based on the latest basic Earnings Per Share (EPS).- Required: (a) Use Excel to compute the returns on both options (attach this working as an appendix to your report)- (b) Present your findings graphically in your report, and briefly comment on your findings