Closed

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

Skills: Excel, Visual Basic, Accounting, Business Analysis, Software Architecture

See more: 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, reporting sample excel aspnet, money excel expert, need excel expert, excel expert independent contractor bid, convert excel standalone program, program front end users click start excel, convert excel access database time tracking reporting, excel expert miami private lessons

About the Employer:
( 37 reviews ) faridabad, India

Project ID: #20964261

14 freelancers are bidding on average $138 for this job

bizwizz

I think I am a good fit for this project job because I have all the qualities that you are looking for. Experience is the golden factor with this type of project and I have a minimum of 9+ years of working experience i More

$200 NZD in 5 days
(22 Reviews)
5.8
ravim211071

hi there I am an MBA graduate with finance stream working as a manager in investment vertical in a public sector bank.I know all about private equity investment with the use of excel. I am very much familiar with the More

$111 NZD in 3 days
(5 Reviews)
3.0
enghamza12

****** ma shaa Allah ****** I'm are professionals in ✔️MATHEMATICS, ✔️MATLAB, ✔️SOLIDWORKS, ✔️ANSYS FLUENT, ✔️PHYSICS, ✔️COMSOL ✔️PDF to Doc or all format and versa I am a boss. ⭐⭐⭐ Major skills and Qualifications ⭐⭐ More

$250 NZD in 10 days
(2 Reviews)
1.1
brunovilela4219

Hello, I'm an experienced Excel user, and have been working with smart tools and analysis for already 10 years. This experience includes KPI's consolidation, big databases management, budget planning, advanced formulas More

$30 NZD in 1 day
(1 Review)
0.5
pauljayanta97

You can give me. I will never break your believe. I am enough knowledge in Excel and data analysis, which is required for your project completion.

$111 NZD in 4 days
(0 Reviews)
0.0
assharma99

give me one chance. your work is properly done by me yoyu have trust me i have very honest and relible person for your work

$30 NZD in 2 days
(0 Reviews)
0.0
youssriaboelseod

hello sir ,i am analyst , i use many technology in my work as vba , sql , access and excel i will do this job in hight accuracy and fast time get me the messon

$140 NZD in 7 days
(0 Reviews)
0.0
Sharif1843

Hi i am a Excel VBA Expert, I have created a planning software and an Add ins for excel named ES Tools using VBA. so i assure u that i will be able to help u and complete your job within time limit with hundred percent More

$140 NZD in 3 days
(0 Reviews)
0.0
$155 NZD in 3 days
(0 Reviews)
0.0
CARahul1737

Hi There, This job is of my most interest. I can assure you with the best quality work, I had done this type of work for my local clients also. Looking forward to have you on board! Kind regards, PMS & Team

$200 NZD in 7 days
(0 Reviews)
0.0
freelancer1522

I am a qualified chartered accountant holding a MBA in finance degree as well. I am quiet good with macros and VBA

$120 NZD in 7 days
(0 Reviews)
0.0
hamza0321

I"m a Financial Analyst with proficiency in MS Excel that is relevant for this job (Excel Skills such as using Pivot Table to create dashboards, reporting upon different dimensions with data analysis techniques as well More

$140 NZD in 6 days
(0 Reviews)
0.0
ShumsFaruk

Hello Sir/Madam, Hope you are doing well! Though I am new to Freelancer.com, I have 7yrs of experience in Excel & VBA Genius (Expert Level Skill) plus 10 yrs of experience in managing finance team by profession. I h More

$166 NZD in 5 days
(0 Reviews)
0.0
aslammohd028

I'm an experienced Excel user, and have been working with smart tools and analysis for already 3 years. This experience includes big databases management, budget planning, advanced formulas combinations, pivot table, d More

$140 NZD in 7 days
(0 Reviews)
0.0