Excel Rate of Return calc

Rate of Return (ROR) template/macro in Excel that uses ongoing imported data received via email. The more automated the better. I'll provide formula/method and sample data files that will have to be imported into Excel.

One twist is there are two different sets of data coming in, one one-time data file from a? former supplier, one ongoing from the current supplier. Both say they’ll provide me? with Excel readable files...which I take to mean CSV files...and which I'll confirm.

So the hope is that I can bolt the two sources of info together in Excel so as to produce client RORs seamlessly starting from the data from the old supplier.

The main report I’d like to be able to generate at the click of a button would have to show: 1) how much client has invested (“net invested??); 2) market value; 3) ROR. (All of these numbers drive off cash flows--i.e. money in? an money outs--and dates they happened.)A householding/linking feature would be necessary as well for related accounts.

There are two other things on the report I’m contemplating, which, from a Excel-macro point-of-view probably amount to the same or very similar things.?

First, a? section that? compares the ROR number of the a given investment fund? (which number I'll supply and update? manually) to a benchmark ROR number (which I'll also d manually). This would be the normal 1, 3, 5 yr, format that is standard in the investment industry and could therefore probably be automated.

Second, in effect the same comparison as just mentioned but with a different timeframe. In other words, not the? the usual 1, 3, 5 yr thing,? but rather over a timeframe I specify and manually enter in.

## Deliverables

I will supply sample data files.

* * *This broadcast message was sent to all bidders on Friday May 9, 2008 1:47:13 PM:

Thanks for your interest everybody. I will post/send out the sample files and formula as soon as I get them myself. Those of you that requested them before you bid, rest assured, I will not close the auction until you've had a chance to see the files and bid.

* * *This broadcast message was sent to all bidders on Tuesday May 20, 2008 6:43:19 PM:

1) I will be amending the original bid request. I can't seem to get workable data files from my current supplier and as such will not need to "bolt" this info onto the new stuff. 2)I have extended the bid closing for another two weeks due to my delay in getting you the data files (which I expect some time this week). My apologies.

Skills: Engineering, Excel, Microsoft Access, Microsoft Exchange, MySQL, PHP, Powerpoint, Project Management, Software Architecture, Software Testing, Word

See more: project calc, benchmark email, uses excel, my rate, excel uses, return, excel formula, calc, ror view, time management excel macro, excel update net, formula mean, excel format formula, data comparison template excel, excel macro csv, generate project file macro, macro template email, excel report macro, return file, net excel update, macro formula, point excel, excel investment, excel macro send email, return time excel

About the Employer:
( 0 reviews ) Canada

Project ID: #3918927

8 freelancers are bidding on average $247 for this job


See private message.

$170 USD in 14 days
(160 Reviews)

See private message.

$212.5 USD in 14 days
(210 Reviews)

See private message.

$212.5 USD in 14 days
(58 Reviews)

See private message.

$127.5 USD in 14 days
(20 Reviews)

See private message.

$85 USD in 14 days
(73 Reviews)

See private message.

$187 USD in 14 days
(8 Reviews)

See private message.

$127.5 USD in 14 days
(18 Reviews)

See private message.

$850 USD in 14 days
(1 Review)