Advanced Excel Formula Creation

$30-250 USD

Completed

Posted

almost 9 years ago

$30-250 USD

Paid on delivery

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

Project ID: 8226473

About the project

6 proposals

Remote project

Active 9 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

Awarded to:

@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 days

5.0

(57 reviews)

5.7

6 freelancers are bidding on average $166 USD for this job

@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 days

5.0

(153 reviews)

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 days

5.0

(143 reviews)

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 days

4.9

(65 reviews)

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 days