I need help with my excel project
€8-30 EUR
Paid on delivery
I am doing an excel project on investment advice. I have been able to do fund A and B but i do not know how to complete C. Assume that Fund C produces annual returns that are normally distributed with mean of 8% p.a. and standard deviation of 6% p.a. However assume also that for Fund C the company applies a guarantee each year that the annual return given to clients will not fall below 3% p.a. and, in lieu of this guarantee, only then returns 97.5% of the accumulated value at the end of the 5-year term to its clients. Assume the returns on all funds are independent. I have the mean and standard deviation completed but i cannot figure out to make sure that the interest stays above 3% each time i run it. I Carried out a simulation analysis, to analyse the distribution of returns the client will make under each fund and therefore the likely returns and value the client will see under the fund.
How do i make sure for the 500 times the macro runs that the interest does not fall below 3%
Project ID: #31872484
About the project
12 freelancers are bidding on average €26 for this job
Hello there, Are you struggling to get your financial transactions recorded, organized, and analyzed through a reliable & proficient accountant? In accounting, the following are some of the hard skills that are I am More
Being an experienced excel user which enables me to undertake the project effectively. Please contact so that i may begin working on it on immediate basis
Hello! I am really interested in this job. I’m data scientist working remotely with various analytical companies. I’m offering best quality and highest performance at a price we are both comfortable with. I can compl More
Hi Sir My name is Nguyen Hoang Anh, Currently a 2nd year student at Can Tho University, used to work in sales at TPbank, MBbank.
I can help you with this and I am an expert in data analysis and work on data processing in Excel......
I think I can perfectly fit in this project because of my 4+ years of experience full time in the field of data analytics in well versed consulting companies like Mu Sigma where I have always impressed my clients with More