Ownership Earn-In Spreadsheet
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
ABCDEFGHI
1
Save, download or copy this worksheet prior to making your own edits.
2
Replace any value in blue to calculate project ownership.
3
4
TheVideoTechBusinessTrafficMoney
5
OriginatorPersonPersonPersonPersonPersonTotals
6
7
Investment Cash In:$0$0$0$0$0$15,000
8
Cash Risk Multiplier:2.002.002.002.002.002.00
9
Basis earned via a cash investment:$0$0$0$0$0$30,000$30,000
10
11
12
The hourly rate this person (typically) earns:$50$50$100$50$0$0
13
Hours invested over the project period:20020040050000
14
$10,000$10,000$40,000$25,000$0$0
15
Cash compensation paid out (subtract):$0$0$10,000$0$0$0
16
Basis earned via labor contributions:$10,000$10,000$30,000$25,000$0$0$75,000
17
18
19
*Basis earned via non-cash contributions:$25,000$0$0$0$25,000$0$50,000
20
*(art, inventions, ideas, equipment, web traffic, etc.)
21
22
Total basis earned via the sum of all sources:$35,000$10,000$30,000$25,000$25,000$30,000$155,000
23
24
Valuation of the project that shares will be earned at:$155,000$155,000$155,000$155,000$155,000$155,000
25
Percent of the project each person will own:22.58%6.45%19.35%16.13%16.13%19.35%100.00%
26
27
28
29
30
31
https://docs.google.com/document/edit?id=1HXDacW_B6_Gke5AHmQJ6WzUtMNSX9RbCpDbGqbRw50E&hl=en
Loading...
Main menu