Advanced Excel Formula Creation

$30-250 USD

Abgeschlossen

Veröffentlicht

vor fast 9 Jahren

$30-250 USD

Bezahlt bei Lieferung

Hi I need to develop a couple of excel formulas related to dividend distribution and IRR calculations. I start of with a projected cash flow from a project. Based on the CF I want to distribute dividends under two conditions: a) keep a minimum cash level at all times and b) increase this minimum cash level if my expected monthly cost over the next three months exceeds the minimum cash level established under a). From there on I want to calculate investor IRR. After having determined the investor IRR I want to charge a performance fee for any return over a certain threshold with a toggle that lets me switch on/off the "catch-up" function. After this I want to calculate the investor IRR net of the performance fee. I have put together a small spreadsheet which shows what I need and should be quite self explanatory. Please let me know if you need further clarifications to provide a quote. Thanks Tobias

Excel

Visual Basic

Projekt-ID: 8226473

Über das Projekt

6 Vorschläge

Remote Projekt

Aktiv vor 9 Jahren

Möchten Sie etwas Geld verdienen?

E-Mail-Adresse

Vorteile einer Ausschreibung auf Freelancer

Legen Sie Ihr Budget und Ihren Zeitrahmen fest

Für Ihre Arbeit bezahlt werden

Skizzieren Sie Ihren Vorschlag

Sie können sich kostenlos anmelden und auf Aufträge bieten

Vergeben an:

@raghav1101

Hi, I would love to work on this project. I am a chartered accountant (CPA equivalent) with 5 years of experience in the field of accounts and finance. I have 8 years of experience in Microsoft Excel including working with excel modeling, dashboards and macros. Please contact with further details if interested. Regards Raghav Bansal

$176 USD in 2 Tagen

5,0

(57 Bewertungen)

5,7

6 Freelancer bieten im Durchschnitt $166 USD für diesen Auftrag

@jaylancer43

Hello Sir, I am an expert techno-functional analysis into lots of areas including Excel Formulas and Macros. I am an engineer graduate with an MBA degree. If you see I am among the niche bidders who have 0 failed project and a very high completion rate. Please give me an opportunity to work with you. Thanks, Jay

$120 USD in 3 Tagen

5,0

(153 Bewertungen)

6,7

@priyal1997

Hi There, My name is Priyal. I’ve read your brief and happy to discuss the project in more detailed. I am highly qualified for this project, because I'm currently working for the largest fund management company in Sri Lanka and very much familiar with all financial calculations and functions. If you'd like to view my qualifications, experience and previous work, take a look at my Freelancer Portfolio I assure you that I will go beyond your expectations. I look forward to hearing from you. Best regards,

$200 USD in 4 Tagen

5,0

(143 Bewertungen)

6,4

@elqueabandona

Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. They speak for themselves. Best regards

$123 USD in 2 Tagen

4,9

(65 Bewertungen)

5,7

@kevivu

Having more than 14 years of experience in banking /finance /accounting, Business analysis, Data analysis, Software development, Software Testing, SDLC, Budgeting, estimation, Project management, Process re-engineering, Statistics, Bookkeeping, HR, Payroll, AR/AP, copy typing, ebook creation, publishing, Web research, Social media marketing, lead generation, etc. Expert in MS office, which includes formatting, powerpoint presentation, mail merge, complex Formulae, Statistical analysis, Macros (VBA), pivot, Charts, formatting, templates, dashboard, etc. Worked on several complex excel VBA projects, viz converting Raw data to structured using vba, sales dashboard, PO tracking, budgeting, profitability, estimation, time management dashboards, etc. Also I am a quick learner and complete tasks very quickly using keyboard shortcuts and multitasking skills. And I have been consistently rated as excellent by all the employers.

$117 USD in 2 Tagen