VC Excel Star? Downround Venture Capital - Complex Anti-dilution calculation is breaking our Excel Model

Job Description:

Our venture company has 3 levels of preferred stock, each with anti-dilution protection. The prior excel model worked fine, but now we are raising new capital at such a low valuation it breaks the Excel model because the circular references can’t be processed.

We want the answer of what should be the new share prices for each of the existing preferred shares classes and for the new money.

Attached is a model with breaks. If you can fix it and provide the correct answer we will pay USD200.

Skills: Excel, Finance, Business Analysis

About the Client:
( 0 reviews ) Jakarta, Hong Kong

Project ID: #36275672

15 freelancers are bidding on average $45/hour for this job


Hello, I can perfectly assist you with that. I am a professional Financial Analyst and Excel expert from one of the Big 4 Financial Advisory firms holding years of experience in Financial Analysis, Financial Modeling, More

$20 USD / hour
(327 Reviews)

Hi! We are a professional business solutions firm having seven years long experience serving clients across the globe. We provide high-level Management Consulting, Business Management, Business Development, Business A More

$25 USD / hour
(24 Reviews)

I am an expert in Excel Formula, Advance Excel, Excel VBA, Excel Power Query, Excel Integration, Excel Macro, Excel Data Entry, Excel Data Scrapping, Excel Dashboard and API Integration, Excel financial models, Excel F More

$20 USD / hour
(42 Reviews)

Hello! I am confident that I am the perfect candidate for this job, hence I would like to submit my proposal for your consideration. I have rich experience in Excel, Business Analysis and Finance. In the two years I' More

$15 USD / hour
(3 Reviews)

Hi there, I'm experienced Advanced Level Excel formulas, nested formulas, logics, complex calculations, dashboards, power queries, graphs, charts, pivot tables, macros & VBA expert. I've 5+ years of experience as a More

$15 USD / hour
(14 Reviews)

Hi, can I check it? Still is available the task. Im an expert excel freelancer and ill could help you. Write at the private and lets fix it

$25 USD / hour
(3 Reviews)

Hello, I have 4+ years of experience on in financial banking and private equity, working across multiple industries structuring different kinds of deals. Also I understand that market conditions are though right now, b More

$20 USD / hour
(1 Review)

I believe that I am the ideal candidate for this project due to my extensive experience in financial modeling and analysis. As a financial analyst at an investment bank in California, I have gained over 5 years of exp More

$20 USD / hour
(0 Reviews)