Fermé

Excel Expert to program Private investment tracking, reporting and trending

I have started but over my head to develop an easy to use and update tracking ledger that for private equity investments that can track balances and report out per IRR using XIRR, support updates and new investments and toggle off but retain data on closed investments. This is NOT stock tracking this in Private equity investing. I have included some spreadsheet work and a sample of my NON Integrated way I track today but need it all in an integrated ledger and need summary reporting and trending etc as outlined on the Spec tab.

This spreadsheet should provide for a

Ledger of both active and closed investments

Track each investment with non routine periodic updates for New capital invested, capital returned, dividends returned, dividends reinvested and Updated Investment NAV value

Report balances by

Each investment

By investment class

By investment Type

By investment entity

report IRR on each investment using Excel XIRR function for

Each investment

Investment Class

Investment Type

Investment entity

Provide weighted value of each investment to portfolio and weighted value of class to portfolio and type to portfolio with pie chart graphics

Trend graphs and tables for

Balances and IRR for

Each investment

Investment category

Investment Type

Produce individual investment reports and summary investment reports

Be able to toggle active investment only or closed investments only or both

Dashboard for reporting

Data entry updating and loading new investments and monthly status must be user friendly for NON excel user

Compétences : Excel, Visual Basic, Traitement de Données, Saisie de Données, Architecture Logicielle

en voir plus : excel schedule program, toronto excel expert job, networking vba excel database program, excel expert financial models, excel standalone program, excel vba program front end example, excel database program, creating macro copy excel paste program, excel scheduling program, money excel expert, need excel expert, excel expert independent contractor bid, convert excel standalone program, excel expert finance job, online excel type program, convert excel access database time tracking reporting, excel expert miami private lessons

Concernant l'employeur :
( 0 commentaires ) Houston, United States

Nº du projet : #20950667

24 freelance font une offre moyenne de $495 pour ce travail

schoudhary1553

Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Pl Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(358 Commentaires)
8.0
esalem

Hi, I am interested in your project and like to talk with you about it. Send to me a message to start the discussions.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(43 Commentaires)
7.5
P0L

Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 5 jours
(310 Commentaires)
7.3
elqueabandona

Hello, my name is Cristian, i am Excel/VBA expert. I am in the top 5 of freelancers in this area and i have more than 240 projects successfully completed here. i work alone, i do not have a team or outsource the proje Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(233 Commentaires)
6.9
vsprybhanu

Hi, My name is Virendra. I am experienced Data Analyst and Macro Developer. I have read your instructions carefully. I have excellent knowledge and experience of creating User Form, Command Button, Drop Down, Radi Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(87 Commentaires)
5.6
bhupendrayadav

I am postgraduate (MBA) in finance with more than 5 years of experience in financial modeling, financial analysis, advanced excel based models and tools, VBA automation. I have completed similar projects, please have a Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 5 jours
(29 Commentaires)
4.9
rIbrarahmed

hi, I am very good in Excel vba, macro, chart etc. if you want to see my excel skills i can share with you some of my work on excel. I understand the value of deadline and do not compromise on quality. I feel fit myse Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(25 Commentaires)
4.6
sevillajk01

hi! let me help you. I offer high quality and accurate output with fast turnaround time. Just message me to talk more details on your project. Hope you will consider me, thanks.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(26 Commentaires)
4.4
paulodayto08

Hi Good Day! A serious freelancer here. I want to help you to improve your existing tool. Please message me to discuss what are the enhancement that we can apply to your existing tool. Please consider my bid. I've Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(31 Commentaires)
4.3
dineshmore

Will create application for this. Hi Myself expert in Dot net technologies with 14 yrs of experience in software development. Developed various web and desktop based projects in Finance, Insurance, Research, Educ Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 30 jours
(4 Commentaires)
3.8
ramzanalam98

Hi,I am Ramzan and it will be my pleasure to assist you with this project. I have read your project [login to view URL] can expect from me I strong commitment to a deadline, the highest quality, and a fluid/friendly commun Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(2 Commentaires)
0.0
asimkhan28

Dear Valued Client, We believe you require a best excel based solution implementing both macros and advance formulas to your solution. Looking forward to get your confirmation and provide our best quality solution. Th Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(0 Commentaires)
0.0
Rajneesh4

We have done similar template for a private equity house based out of Saudi. The sheet is fully flexble and tracks the portfolio performance.I'm sure i can accomplish this task for you.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(0 Commentaires)
0.0
%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(0 Commentaires)
0.0
paymentdeveloper

Hi, Thanks for posting !!! I have 14 years of experience in Website and Mobile apps. I have checked the requirement and understand. I have created website SIMILAR to Excel Expert to program Private investment Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(0 Commentaires)
0.0
%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(0 Commentaires)
0.0
sridharmak

As i am currently doing my projects on data entries and as a data analyst i woukd be abke to complete your work effectively with the given time period Relevant Skills and Experience Done projects on food suppliers da Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 8 jours
(0 Commentaires)
0.0
theukwebexpert

Hello there! My name is Chris, I'm a UK based and native English speaking web developer and app expert with 10 years experience building and maintaining complex web apps/websites/software I've built and maintained ap Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(0 Commentaires)
0.0
saulgutman

35 años de experiencia

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(0 Commentaires)
0.0
shimakhamisalmuq

I wish you hire me

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(0 Commentaires)
0.0