Construct a simulation model in Excel

$30-250 AUD

In Progress

Posted

over 12 years ago

$30-250 AUD

Paid on delivery

You are required to construct a simulation model in Excel so that 1000 simulation runs are used to produce projected fund values each time a new asset allocation is selected. Each simulation should project the fund balance after 12 months (1 year). Simulated returns should be on a monthly basis; hence each simulation will require 12 separate returns to be generated for each asset class in order to calculate the projected balance after 12 months. Construct the model in such a way so that the default asset allocation for each month is from the table above (i.e., monthly rebalancing to the default asset allocation is performed). Note that there are no contributions, withdrawals or other cashflows either in or out of the fund over the 12 month period.

Project ID: 1187379

About the project

6 proposals

Remote project

Active 13 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

Awarded to:

@vbexcel

Excel / VBA expert with a financial background, ten years experience.

$50 AUD in 1 day

4.9

(25 reviews)

5.3

@jadinv

Hello, I have extensive VBA and financial experience to provide a high-quality result for you. I will be sending you examples of previous projects/experience for your review. Thanks for reviewing this bid. Jeff

$200 AUD in 4 days

5.0

(3 reviews)

3.9

@chanchal5jan

Dear sir, I am an Accountant with 3 year of Experience. I have a good knowledge of excel and Tally ERP. I am very good in making project reports in excel sheet with the help of vlookup, hlookup and all airthmetic funcation. kindly give me an oppurtunity to assist you with my best knowledge. Looking forward for your support. With Regards Chanchal Saini

$150 AUD in 3 days