Fermé

I need help with my excel project

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%

Compétences : Excel, Comptabilité, Finance, Traitement de Données, Saisie de Données

En voir plus : need help maya project, need help writing project plan, need help animation project, need help circuits project, help excel project, need help flash project, need help gis project, need help statistics project, need help accounting project, need help law project, need help technology project, need help database project php mysql, need help excel contacts, i need help in writing my project, please somebody help me i m trying to write a very good song for a project and i need help in making the following rhyming words, i need a developer to help develop a web based software program i will provide full project details once you place a placeholder, i need help with excel, i need help with writing an email to ask a principal for a job, i need help with my senior project, i need help with my research project

Concernant l'employeur :
( 0 commentaires ) Ireland

Nº du projet : #31872484

13 freelances font une offre moyenne de 25 € pour ce travail

(229 Commentaires)
6.8
thinkitltd4

Hi there, I can do your project with 100% accuracy. I have reviewed your project brief carefully and would like to assist you with the task. I can start your project right now. I work efficiently and will finish on tim Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% EUR en 1 jour
(88 Commentaires)
6.9
ShaikhAneesa

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 7 jours
(13 Commentaires)
6.0
kevivu

Hi there, I have reviewed your requirements carefully and I can definitely start immediately. I worked on numerous similar projects in the past and always impressed the clients with my excellent solutions. But I have Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 2 jours
(85 Commentaires)
6.2
Ghulamali1656067

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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% EUR en 1 jour
(50 Commentaires)
5.2
(19 Commentaires)
3.9
varimaxanalytic

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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% EUR en 1 jour
(2 Commentaires)
3.5
stevekimm

Hello, I have read your project and fits my skills in Microsoft Office. I'm interested to hear more about the project and about the particulars of the information. If you award me the project I'd be very happy to di Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% EUR en 1 jour
(5 Commentaires)
2.7
rushabhmeru

Hello, I am Rushabh Shah, I am a Chartered Accountant from the Institute of Chartered Accountants of India and I have been working for clients based globally providing Bookkeeping and Accounting services to various In Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 7 jours
(1 Évaluation)
2.9
Jamshaidsiddiq13

I'm scrolling through freelancing and saw that you're searching for a writer that make your work easy and help to complete your work as soon as possible So I'm here for helping you complete your important work I have Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% EUR en 1 jour
(0 Commentaires)
0.0
Hoangannh

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.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 7 jours
(0 Commentaires)
0.0
eslam155

I can help you with this and I am an expert in data analysis and work on data processing in Excel......

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 5 jours
(0 Commentaires)
0.0
Revathi150895

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 3 jours
(0 Commentaires)
0.0