Find Jobs
Hire Freelancers

Monte Carlo Simulation with Excel VBA (Advanced statistics knowledge required)

$30-250 USD

Stengt
Lagt ut over 7 år siden

$30-250 USD

Betalt ved levering
I want to do a Monte Carlo Simulation to compute a profit forecast in the next five years. In the forecasting model spreadsheet, there are 10 parameters/ 10 inputs, the spreadsheet will produce 5 output values which are the test results required. I want to carry 100,000 tests with random deterministic samples in order to compute the simulation. You will need to write a program/ VBA for the following: 1) Randomly generate the 10 parameters according to normal distribution with given mean and variance. 2) Record the 5 outputs for that particular test: estimated profit in Year 1...Year 5 (simply 5 values in 5 cells) in a new sheet. Step 1& 2 is one sample. 3) Repeat the sampling/ test 100,000 times and get 100,000 results, i.e. 500,000 values 4) Construct a distribution function/ table for profit of each of the 5 years. There should be 5 distribution tables, each constructed with 100,000 samples It also would be helpful if you can suggest a method to compute the variance used for the normal distribution in randomizing the parameters, the mean will be a best estimated value for the specific individual parameter.
Prosjekt-ID: 11687777

Om prosjektet

22 forslag
Eksternt prosjekt
Aktiv 8 år siden

Ønsker du å tjene penger?

Fordeler med budgivning på Freelancer

Angi budsjettet og tidsrammen
Få betalt for arbeidet ditt
Skisser forslaget ditt
Det er gratis å registrere seg og by på jobber
22 frilansere byr i gjennomsnitt $186 USD for denne jobben
Brukeravatar
Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. They speak for themselves. Best regards
$200 USD om 5 dager
5,0 (135 omtaler)
6,4
6,4
Brukeravatar
-----------------------------Master in Math! Best Result in Time!---------------------- Dear, sir. I read your requirement very carefully, and I'm sure this project is just for me. I'm a professional mathematician on the fields of calculus, differential equation, optimization and probability&statistics and have high level skill for using MATLAB. So, I have a good experience for developing programs based on deep mathematics knowledge. More important, I don't have another project now and just ready to start for you. I'm looking forward your reply.
$200 USD om 3 dager
4,8 (114 omtaler)
6,4
6,4
Brukeravatar
Hi, This is Santhosh from India. I am a Business Management Graduate with Computer Science engineering background who is passionate about Data, Mathematics and Technology. I have worked in many data analytics projects involving SAS & R. Also I have worked in projects involving Excel (Pivot Table, Macros) and VBA. I believe I have enough expertise in R & Excel to complete this project as per your requirement. I am sure that you will be 100% satisfied with my work. Please get in touch. Looking forward to hear from you. Thanks & Regards, Santhosh Kanna
$155 USD om 3 dager
5,0 (37 omtaler)
5,6
5,6
Brukeravatar
Hello. 35 % of employers hiring me once hired me again. I have experience in the same. I CAN do this job, and do it well!
$150 USD om 3 dager
5,0 (62 omtaler)
5,3
5,3
Brukeravatar
Hello, I am VB, VBA, C#, WPF, Java, Delphi, PHP, ASP.NET, CAD and GIS developer, I developed many desktop applications and custom tools, macros and Add-Ins. For reference see my profile. I am ready to discuss and doing the project. Regards, Eyad
$884 USD om 15 dager
5,0 (13 omtaler)
5,1
5,1
Brukeravatar
HI I am an excel-vba Expert and I can help you with your project start the chat to discuss more ..........................................................................
$133 USD om 5 dager
5,0 (27 omtaler)
5,0
5,0
Brukeravatar
Hello, I have been working as freelancer since last ~ 3 years,prior to this was working with a MNC as an Sr. Software Professional. The project is Product based development and integration of the product with various already existing Products and processes.. Below are some key areas of my skills: -- VBA and Excel,Word,Office Applications -- Expert on C# using .NET framework using Visual Studio 2012 and 2013 -- Expert in ASP.NET,MVC -- Expert in VB.NET using VS2012/VS2013 -- WPF and Windows Forms Application I have experience in all the above areas and during my project work I have completed all of the above tasks. As a Freelancer also I have worked in few of the above areas where I got a chance and delivered the best. Delivering best & Customer satisfaction is the key for any individual and I always worked keeping these things during project execution. Would be looking forward to work on this opportunity and will ensure to deliver best. Regards, Abhinov
$200 USD om 4 dager
5,0 (29 omtaler)
5,0
5,0
Brukeravatar
Experienced programmer with more than 10 years of development experience here. I have handled production applications with various technologies like .NET, PHP, Classic ASP and many more using databases like MySQL, Microsoft SQL, Access and etc. Mentioned below are a few USPs for choosing me: 1. Well written codes with proper documentation 2. Highest possible code optimization 3. Quick support through email / skype / telephone 4. Daily / Weekly status reporting Some reference projects: a) Responsive website on .NET - https://www.freelancer.com/projects/C-Sharp-Programming-ASP-NET/ASP-Net-Responsive-Web-Application/ --> Review -> “Thanks Hardik! Great work.” b) VB 2013 Desktop Application with AWS integration -https://www.freelancer.com/projects/Amazon-Web-Services-Windows/Visual-Basic-Express-Desktop-Application/ --> Review--> "Great Job! Would hire again!" c) Data pull application from Facebook using VB.NET -https://www.freelancer.com/projects/PHP-Social-Networking/Timeline-Posts-Extraction-with-Likes/ --> Feedback by Client --> "I was extremely satisfied by hardikshah83's work. Excellent communication skills. Very professional. I asked for a couple of changes in the course of the project and he delivered them gracefully." Let's discuss and make this project a success. This is a tentative bid, and may change post understanding exact scope.
$150 USD om 3 dager
4,7 (12 omtaler)
4,9
4,9
Brukeravatar
Hi, I have gone through a requirement. I am interested in the project because it sounds like super fun. I have worked as quant analyst for Investment banks and have a masters degree in physics. I am very much familiar with monte-carlo. The SD can be estimated from the type of input parameters. Also, Excel will be very slow handling this amount of data.
$155 USD om 3 dager
4,9 (54 omtaler)
4,3
4,3
Brukeravatar
Hi! I am risk manager with more than 10 years experience. Since 2005 I have been dealing with credit (including financial statement analysis), market, liquidity risks and interest rate risk of banking book, including model building (VaR,HW, Libor, Heston, SABR, Vanna-Volga), quantitative analysis, valuation, reporting. I had several projects of building risk management system in line with Basel requirements from scratch. I have FRM and CFA certifications. I am expert in R and Matlab. Also I can use Eviews, Stata, Spss and SAS
$250 USD om 3 dager
5,0 (7 omtaler)
4,1
4,1
Brukeravatar
Hi! My name is Fernando Téllez. I am a senior year student of electrical engineering at Universidad Simón Bolívar (USB), one of the most prestigious universities in my country (Ranked 34° at the QS University Rankings: Latin America 2015). In August the first (2016) My Undergraduate Thesis ''R.A.M Analysis of Electrical Power Systems on the operative context using Monte Carlo Methods'' was awarded with honors. I code using matlab, Octave, Excel and C/C++ ON A DAILY BASIS to solve any kind of engineering, logical, statistical and mathematical problem.
$100 USD om 1 dag
5,0 (6 omtaler)
4,0
4,0
Brukeravatar
***** Hello, I am interested in your project and would like to discuss with you. please reply to me on chat, I am waiting for your response. You may visit my profile to know about me and my experience. This is My Profile link> https://www.freelancer.com/u/sajibdigital.html Thanks, Sajib
$161 USD om 3 dager
5,0 (11 omtaler)
3,6
3,6
Brukeravatar
I have a Master's degree in system analysis (Mths, Statistics and IT related). Have a previous experience in completing such work.
$200 USD om 2 dager
4,8 (23 omtaler)
3,9
3,9
Brukeravatar
Wonderful project! We are pro in Excel and VBA. As we are masters of mathematics and control engineering, we will give you a successful result in time. Keep in touch with us,please... Thanks a lot!
$100 USD om 1 dag
4,8 (24 omtaler)
4,0
4,0
Brukeravatar
Dear Sir, I carefully read your instructions and I am interested in this project. I can propose for you two different solutions: i) A VBA solution, integrated in excel, like required for points (1)-(2)-(3)-(4). My bid for this solution is 200 AUD. Excel Analysis tool pack has a function to generate a random number, accordingly to a normal distribution, given mean and devSt. ii) Alternatively, I can suggest a simple C++ tool (one time compile to obtain an exe tool) that runs the work. This tool would generate a single csv output file, containing the 500,000 values (namely points (1),(2) and (3)). The CSV can be imported in excel for point (4). This kind of solution is faster (speaking about execution time) and cheaper (my bid in that case is 100 AUD). Please contact me if you have some questions or if you want to share with me some further details. Best Regards, Marzio
$100 USD om 3 dager
4,7 (5 omtaler)
3,8
3,8
Brukeravatar
hello there, I will introduce myself, I´m a civil/informatic engineer, working as a freelancer for quite a long time, my professional formation allows me to resolve any kind of mathematical and programing problem. I have worked mostly all my carreer with MS excel, so this task won´t be a problem at all for me, I can guarantee you great results, in the shortest time, with very reasonable budget. Montecarlo simulation is an apporach I have worked with a couple of times, so this isn´t new for me. Let me know
$111 USD om 1 dag
4,9 (11 omtaler)
3,4
3,4
Brukeravatar
HI, I am Postgraduate engineer with bachelors in civil engineering and masters in solid mechanics from Indian Institute of Technology Madras. I am currently pursuing PhD in earthquake engineering at the University of Melbourne. I have used MATLAB and excel extensively for over 7 years and have developed working proficiency in it. I have successfully completed 3 matlab-excel projects with freelancers in last 3 weeks. I have gone through your problems, and I am confident I will be able to help you with your work.
$155 USD om 3 dager
4,2 (2 omtaler)
3,6
3,6
Brukeravatar
Hi, I have experience with Excel and VBA. I look forward to an opportunity to work with you on this project. Thanks!
$50 USD om 5 dager
5,0 (2 omtaler)
1,4
1,4
Brukeravatar
I am a former Big4 consultant and financial markets professional that is used to work with large size multi-dimensional data. I have extended experience in data management as well as automation, be it through native excel functionnalities (pivot tables, formulas, etc.) or using more sophisticated automation using VBA. I am a quantitative risk modelling expert, and am experienced with Monte-Carlo simulations based forecasting methodologies.
$200 USD om 7 dager
5,0 (1 omtale)
0,6
0,6
Brukeravatar
I am an expert at statistics and i can do this job for you right away. I am a graduate of civil engineering and i dealt with similar problems in school so this should not pose a problem. I work fast and deliver my job on time. Looking forward to working with you.
$166 USD om 3 dager
0,0 (0 omtaler)
0,0
0,0

Om klienten

UNITED KINGDOMs flagg
London, United Kingdom
5,0
4
Betalingsmetode bekreftet
Medlem siden jul. 17, 2016

Klientbekreftelse

Takk! Vi har sendt deg en lenke for at du skal kunne kreve din gratis kreditt.
Noe gikk galt. Vær så snill, prøv på nytt.
Registrerte brukere Publiserte jobber
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Forhåndsvisning innlasting
Tillatelse gitt for geolokalisering.
Påloggingsøkten din er utløpt og du har blitt logget ut. Logg på igjen.