| Goodwill Report (This is more correctly a stock worksheet - it
has hard assets too) |
|
|
|
|
|
|
| Prophy Research
Corporation |
|
|
|
|
|
|
|
|
|
|
|
| Year: 2003 |
|
|
|
|
|
|
|
|
|
|
|
| date draft: 1-24-04 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| This worksheet
"zeroed out" from most
recent "Goodwill Report (year)" file |
|
|
|
|
|
|
|
| (easy to do, prob best to use the most
current each year and just take out values) |
|
|
|
|
|
|
| (Left in some
values, like $/share, $/hr, pat helpers amounts, various triggers like
"visit"etc.) |
|
|
|
|
|
| (Watch
out for "manual" numbers, try to mark with * , |
|
|
|
|
|
|
|
|
| these are added
in by me as I do this, from other reports, etc.) |
|
|
|
|
|
|
|
|
| file:Goodwill Report (this year) |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| A good easy
place to see what I was working on each quarter is the floppy disc labels. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| To
whom and why goodwill
stock is given from the company. (Other categories are in other parts of this worksheet,
like hard asset =~cash stock, and givers/traders for when goodwill stock is
given from one individual to another.) |
Total $ value
for the year |
# shares @
value per share: |
|
|
|
|
|
| |
$
10 |
|
|
|
|
|
| Ray - crudely guesstimated hourly
work, no salary. (Patents, licensing, reports, CEO) |
Period |
hours |
$/hr |
sub-total |
|
|
|
|
|
|
|
| 1st Qtr |
100 |
20 |
2000 |
15200 |
1520 |
|
|
|
|
|
| 2nd Qtr |
280 |
20 |
5600 |
|
|
|
|
|
|
|
| 3rd Qtr |
280 |
20 |
5600 |
|
|
|
|
|
|
|
| 4th Qtr |
100 |
20 |
2000 |
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
| Tom
- crudely guesstimated hourly work for year. |
year |
10 |
50 |
500 |
2000 |
200 |
|
|
Tom rresigned 12-31-03 |
| Chairman
"salary" |
year -put in year's
sal: |
|
|
1500 |
|
|
|
|
|
|
|
| bonus |
|
|
|
0 |
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
| Darby-crudely
guesstimated hourly work for year. |
year |
20 |
50 |
1000 |
2000 |
200 |
|
|
|
|
|
| Vice President
"salary" |
year -put in year's
sal: |
|
|
1000 |
|
|
|
|
|
|
|
| bonus |
|
|
|
0 |
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
| Reg stk holders bonuses: |
|
|
|
|
0 |
0 |
|
|
|
|
|
| Sylvia
Pager - director |
|
|
|
100 |
100 |
10 |
Ray Grogan
total (just above and way above) |
|
|
|
|
| |
|
|
|
|
|
0 |
1520 |
|
|
|
|
|
|
|
|
|
|
|
1930 |
Reg total |
|
|
|
| BSA stk club - patent
helpers: |
|
|
|
|
0 |
0 |
|
|
|
|
|
| Heinz
& Julia B - Swiss usual+resp label 3-03 +
Dafalgan find |
|
|
|
60 |
60 |
6 |
|
(They pay ~$600US/yr in Swiss pat fees |
| Heinz
& Julia B-bonus |
|
|
|
300 |
300 |
30 |
|
as joint owners, for 1/2 eventual royalties. |
| Pat rep -
Eric L - assumed S.A. DBW maintain |
|
|
|
100 |
100 |
10 |
BSA tot |
Their investment/success helps us both |
| |
|
|
|
|
0 |
0 |
52 |
as the other owners and as example.) |
| BSA Paul
B inspired lic work with req for iron lic 1-03 |
|
|
|
10 |
10 |
1 |
|
|
|
|
|
| Rest of
BSA stk clb Hans faxed labels 3-03 |
|
|
|
50 |
50 |
5 |
|
|
|
|
|
|
|
|
|
|
0 |
0 |
0 |
|
|
|
|
| PD stk club |
|
|
|
|
0 |
0 |
0 |
PD total |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Total New Goodwill |
OptiDose
* |
|
19,820 |
$ 19,820 |
1982 |
|
|
|
|
|
| (And where it gets added) |
OsteoPat* |
|
0 |
check |
1982 |
|
(Generally no more Osteo GW - abandoned in 2002) |
|
Total (match total new GW?) |
19,820 |
check |
1982 |
|
(If the check ain't right - don't take the wrong number off to balance sheet.) |
|
*manual from total new goodwill (do each year) |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Page break here
- Goodwill Report page 3 |
|
|
|
|
|
|
|
|
|
| To
whom and why hard asset
stock is given from the company. |
Total for year |
(from above) |
|
|
|
|
|
|
|
|
|
|
| Ray Grogan -
expenses (see expense report) |
1st draft |
1942 |
1942 |
194.2 |
|
|
|
|
|
| BSA Heinz
-expenses (see expense report) |
1st draft |
0 |
0 |
0 |
|
|
|
|
|
| BSA Eric
-expenses (see expense report) |
1st draft |
0 |
0 |
0 |
|
Going
zero on Eric expenses until |
| (obvious? note
- no stk credits for expenses pd by bank) |
|
0 |
0 |
|
confirmation. Still giving $100 as GW. |
| |
|
|
|
|
0 |
0 |
|
|
|
|
|
| Ray Grogan -
Bank deposits (see bank report) |
|
0 |
0 |
0 |
|
|
|
|
|
|
|
|
|
|
0 |
0 |
|
|
|
|
|
| |
|
|
|
|
0 |
0 |
|
|
|
|
|
| Total new hard asset |
|
|
|
|
$
1,942 |
194.2 |
|
|
|
|
|
| Checks - total expenses*: |
2067 |
Cash* inc or dec(-): |
-25 |
Check |
194.2 |
|
|
|
|
|
| Ray's
total HA: |
1942 |
Total new HA chk: |
$2,042 |
|
|
|
|
|
|
|
| * manual from other
reports |
|
|
|
|
|
|
|
|
|
|
|
| Check bank
again - how much in checks? I've made some big mistakes here |
|
|
|
|
|
|
| And caught
before too late by this new form. Affected my HA and Cash inc or dec. |
|
|
|
|
|
|
| Total new shares from company (GW & HA) |
|
|
$
21,762 |
2176.2 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| . |
|
|
|
|
|
|
|
|
|
|
|
| Givers/Traders |
|
|
|
|
|
|
|
|
|
|
|
| The goodwill below is not new goodwill. This is goodwill that
was already poofed into existence when the company gave it to someone
earlier. Now it is being given to someone else. Most of these are from me
(Ray) to friends and family. |
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
| To
whom goodwill stock is given and why. If not from Ray make a note. Some of
the family givers are formulas, based on my own GW & HA above. |
Total $ value for the year |
(in effect from above) |
|
|
|
|
|
| Ray's GW from above: |
15200 |
HA from above: |
1942 |
|
$17,142 |
|
|
|
| Mary -
25% of my GW |
Nepotism (instead of real money
they'd get if I had a real job) |
3800 |
|
|
|
|
| Abe - 12.5% of my GW |
1900 |
|
|
|
|
| Lucy - 12.5% of my GW |
1900 |
|
|
|
|
|
|
|
| Mary -
33% of my HA (as GW) |
Family
money spent |
647 |
|
|
|
|
|
|
|
| Abe - 16.7% of my HA (as GW) |
|
" |
|
324 |
|
|
|
|
|
|
|
| Lucy - 16.7% of my HA (as GW) |
|
" |
|
324 |
|
|
|
|
|
|
|
| Note-Mary and Jack used to be
both Reg and FT stockholders. To reduce confusion, I made them both Reg only
in 1997. |
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
| Reg Ray to Reg Mary from
above: |
4447 |
4450 |
Manual roundoff* |
$ 4,450 |
445.00 |
|
|
|
|
|
| Reg Ray to Reg Mark &
Susie U |
50 |
Summer wk,
big red, Yelstn, Xmas visit |
$ 50 |
5 |
|
|
|
|
|
| Reg Ray to Reg Jack: |
50 |
GI bill,
Mtn Vw, Paternalism* |
$
50 |
5 |
|
|
|
|
|
| Total Reg Ray to other
Regs |
4550 |
|
|
|
(Some of these cells have 2
decimal places to remind me that the # of shares should be even) |
|
|
|
|
|
| Now do Abe and
Lucy from above and rest of FT. |
|
|
|
|
|
|
|
| FT (A stock club of Ray's family
who mostly get stock for family reasons, the "Family Trust") totals
on next page. |
|
|
|
|
|
|
|
|
|
|
| Page break here, givers/traders continue from
page above - Goodwill Rep pg 4 |
|
|
|
|
|
| Abe's
total from above: |
2224 |
2230 |
Manual roundoff* |
$
2,230 |
223.00 |
|
|
|
|
|
| Lucy's
total from above: |
2224 |
2230 |
Manual roundoff* |
$ 2,230 |
223.00 |
|
|
|
|
|
| |
|
|
0 |
0 |
|
|
|
|
|
| Nancy
G |
70 |
HI visit,
MH help |
70 |
7 |
|
|
|
|
|
| Kit O |
0 |
Xmas visit |
|
|
0 |
0 |
|
(Kit's on quick New Yrs is in 2004) |
| Sharon O (combo w/ Kit) |
|
Xmas visit |
|
|
0 |
0 |
|
(No Xmas visit this year credited.) |
| Ben
& Tanya O Rhett, Parker |
20 |
Smmr Ark,
Fast devo find |
20 |
2 |
|
|
|
|
|
| Katie O |
|
Xmas visit |
|
|
0 |
0 |
|
|
|
|
|
| Polly G |
0 |
Xmas visit |
|
|
0 |
0 |
|
|
|
|
|
| Stephie G |
0 |
Xmas visit |
|
|
0 |
0 |
|
|
|
|
|
| Dyan H |
10 |
Visit |
|
|
10 |
1 |
|
|
|
|
|
| Elaine H (combo w/ Dylan) |
10 |
Visit |
|
|
10 |
1 |
|
|
|
|
|
| Linda H |
10 |
Visit |
|
|
10 |
1 |
|
|
|
|
|
| Ben & Ruth S |
10 |
Visit |
|
|
10 |
1 |
|
|
|
|
|
| Levon M (now N) |
10 |
Visit, Mary |
|
|
10 |
1 |
|
|
|
|
|
| |
|
|
|
|
0 |
0 |
|
|
|
|
|
| |
|
|
|
|
0 |
0 |
|
|
|
|
|
| Total Reg Ray to FT |
$ |
4,600 |
shares: |
460 |
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
| (Givers/traders cont'd) |
|
|
|
|
|
|
|
|
|
|
|
| NHSC (A stock club of friends who sort of help,
but not enough to deserve company stock, the "No Hair Surf Club") |
2nd entries for same person |
sub total on
last entry |
|
|
|
|
|
|
|
| |
Period |
$ |
|
|
|
|
|
|
|
|
| |
|
|
|
0 |
$0 |
0 |
|
|
|
|
|
| Luke Koninger - Hardin
-Excel on web |
|
10 |
|
10 |
$10 |
1 |
|
new |
|
|
|
| Joe Hyeon - MH shack
building spring 03 |
|
10 |
|
10 |
$10 |
1 |
|
new |
|
|
|
| Mike Elhoff - MH plumb
rescues |
|
20 |
|
20 |
$20 |
2 |
|
new |
|
|
|
| Mike Pokry. MH - liberate
a rock |
|
10 |
|
10 |
$10 |
1 |
|
new |
|
|
|
|
|
|
|
0 |
$0 |
0 |
|
|
|
|
|
| |
|
|
|
0 |
$0 |
0 |
|
|
|
|
|
| |
|
|
|
0 |
$0 |
0 |
|
|
|
|
|
| Don Arnie Arnold -
RAGBRAI ride |
|
10 |
|
10 |
$10 |
1 |
|
|
|
|
|
| Carolyn Carley - Easter
Bunny |
|
10 |
|
10 |
$10 |
1 |
|
|
|
|
|
| Morgan Blank - comp use |
|
20 |
|
20 |
$20 |
2 |
|
|
|
|
|
| Morgan B & Marianna
Dr. Pager summer 03 |
|
10 |
|
10 |
$10 |
1 |
|
|
|
|
|
| |
|
|
|
0 |
$0 |
0 |
|
|
|
|
|
| Totals down NHSC |
|
100 |
0 |
100 |
|
|
|
|
|
|
|
| Totals across NHSC |
|
|
|
100 |
|
|
|
|
|
|
|
| Total Reg Ray to NHSC |
|
$
100 |
shares |
10 |
|
|
|
|
|
|
|
| Total Goodwill Given |
|
|
|
|
$
9,250 |
925 |
|
|
|
|
|
| or Traded |
|
|
|
|
check |
925 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Any hard asset
shares given or traded? |
NO |
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
