ปิด

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

ทักษะ: Excel, Visual Basic, การบัญชี, การวิเคราะห์ธุรกิจ, สถาปัตยกรรมซอฟต์แวร์

ดูเพิ่มเติม : 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

เกี่ยวกับนายจ้าง:
( 37 บทวิจารณ์ ) faridabad, India

หมายเลขโปรเจค: #20964261

freelancer 14 คน กำลังเสนอราคาเฉลี่ยที่ $138 สำหรับงานนี้

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 เพิ่มเติม

$200 NZD ใน 5 วัน
(22 บทวิจารณ์)
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 เพิ่มเติม

$111 NZD ใน 3 วัน
(5 บทวิจารณ์)
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 ⭐⭐ เพิ่มเติม

$250 NZD ใน 10 วัน
(2 บทวิจารณ์)
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 เพิ่มเติม

$30 NZD ใน 1 วัน
(1 บทวิจารณ์)
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 ใน 4 วัน
(0 บทวิจารณ์)
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 ใน 2 วัน
(0 บทวิจารณ์)
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 ใน 7 วัน
(0 บทวิจารณ์)
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 เพิ่มเติม

$140 NZD ใน 3 วัน
(0 บทวิจารณ์)
0.0
$155 NZD ใน 3 วัน
(0 บทวิจารณ์)
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 ใน 7 วัน
(0 บทวิจารณ์)
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 ใน 7 วัน
(0 บทวิจารณ์)
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 เพิ่มเติม

$140 NZD ใน 6 วัน
(0 บทวิจารณ์)
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 เพิ่มเติม

$166 NZD ใน 5 วัน
(0 บทวิจารณ์)
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 เพิ่มเติม

$140 NZD ใน 7 วัน
(0 บทวิจารณ์)
0.0