• 100% Satisfaction Guarantee
Richard - Bizlaw, Attorney
Satisfied Customers: 9372
Experience:  30 years of corporate, litigation and international law
18695994
Richard - Bizlaw is online now

# What is the appropriate Excel calculation to figure share ownership--w

### Customer Question

What is the appropriate Excel calculation to figure share ownership--when there are diluted AND non-diluted shares of stock?
Submitted: 3 years ago.
Expert:  Richard - Bizlaw replied 3 years ago.

bizlaw :

What do you mean by non-diluted shares? Does this mean that certain shareholders' percentage interest in the company does ot change as additional shares are issued by the corporation?

JACUSTOMER-r98rrfsj- :

Yes. You are correct.

bizlaw :

I can tell you how to do it but I need to know how many shares are outstanding and how many shares are being issued by the company. Also, are the new shareholders just getting a specified number of shares or a specified percentage interest in the company?

JACUSTOMER-r98rrfsj- :

So sorry for the delay, but I was out of the office for a few days. To answer your question to me:

Currently, the company has issued 1,000 units (it's an LLC). Only one investor has an undiluted position--he will be purchasing up to 15% of the company in installments. So going forward, here's the scenario:

Present:

Investor 1: 50% diluted position

Investor 2: 25% diluted position

Investor 3: 15% diluted position

Investor 4: 10% Undiluted position

NEXT:

What is the Excel calculation, if Investor 4 purchases at additional 2%...then a 12% Undiluted Postion, how do I derive the other percentages?

JACUSTOMER-r98rrfsj- :

Ask-a-doc Web sites: If you've got a quick question, you can try to get an answer from sites that say they have various specialists on hand to give quick answers... Justanswer.com.
...leave nothing to chance.
Traffic on JustAnswer rose 14 percent...and had nearly 400,000 page views in 30 days...inquiries related to stress, high blood pressure, drinking and heart pain jumped 33 percent.
Tory Johnson, GMA Workplace Contributor, discusses work-from-home jobs, such as JustAnswer in which verified Experts answer people’s questions.
I will tell you that...the things you have to go through to be an Expert are quite rigorous.

### What Customers are Saying:

• Mr. Kaplun clearly had an exceptional understanding of the issue and was able to explain it concisely. I would recommend JustAnswer to anyone. Great service that lives up to its promises! Gary B. Edmond, OK
< Previous | Next >
• Mr. Kaplun clearly had an exceptional understanding of the issue and was able to explain it concisely. I would recommend JustAnswer to anyone. Great service that lives up to its promises! Gary B. Edmond, OK
• My Expert was fast and seemed to have the answer to my taser question at the tips of her fingers. Communication was excellent. I left feeling confident in her answer. Eric Redwood City, CA
• I am very pleased with JustAnswer as a place to go for divorce or criminal law knowledge and insight. Michael Wichita, KS
• PaulMJD helped me with questions I had regarding an urgent legal matter. His answers were excellent. Three H. Houston, TX
• Anne was extremely helpful. Her information put me in the right direction for action that kept me legal, possible saving me a ton of money in the future. Thank you again, Anne!! Elaine Atlanta, GA
• It worked great. I had the facts and I presented them to my ex-landlord and she folded and returned my deposit. The 50 bucks I spent with you solved my problem. Tony Apopka, FL
• Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help. Mary C. Freshfield, Liverpool, UK

• ### Dimitry K., Esq.

#### Satisfied Customers:

1561
Run my own successful business/contract law practice.
< Last | Next >

### Dimitry K., Esq.

#### Satisfied Customers:

1561
Run my own successful business/contract law practice.

### MShore Law

#### Satisfied Customers:

1233
Drafted Negotiated and/or Reviewed Thousands of Commercial Agreements

577

### Barrister

#### Satisfied Customers:

454
15 years practicing attorney, MBA

### J.Hazelbaker

#### Satisfied Customers:

393
Experienced and trained in the area of business law.

### MDLaw

#### Satisfied Customers:

293
Experience in business law, contract law and related matters.

### J. Warren

#### Satisfied Customers:

282
Experience in general business transaction and formation matters.