Kapalı

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

Beceriler: Excel, Visual Basic, Muhasebe, İş Analizi, Yazılım Mimarisi

Daha fazlasını gör: 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

İşveren Hakkında:
( 37 değerlendirme ) faridabad, India

Proje NO: #20964261

Bu iş için 14 freelancer ortalamada $138 teklif veriyor

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 Daha Fazla

$200 NZD in 5 gün içinde
(22 Değerlendirme)
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 Daha Fazla

$111 NZD in 3 gün içinde
(5 Değerlendirme)
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 ⭐⭐ Daha Fazla

$250 NZD in 10 gün içinde
(2 Değerlendirme)
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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% NZD
(1 Yorum)
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 gün içinde
(0 Değerlendirme)
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 gün içinde
(0 Değerlendirme)
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 gün içinde
(0 Değerlendirme)
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 Daha Fazla

$140 NZD in 3 gün içinde
(0 Değerlendirme)
0.0
$155 NZD in 3 gün içinde
(0 Değerlendirme)
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 gün içinde
(0 Değerlendirme)
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 gün içinde
(0 Değerlendirme)
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 Daha Fazla

$140 NZD in 6 gün içinde
(0 Değerlendirme)
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 Daha Fazla

$166 NZD in 5 gün içinde
(0 Değerlendirme)
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 Daha Fazla

$140 NZD in 7 gün içinde
(0 Değerlendirme)
0.0