I made a little calculation sheet at work and it's out 2 cents. I
figure it's because of the forumulas in the bottom part where the
calculations of n/180 share.

Any idea how I can make the sheet at least clue me in that it's not accurate?

I cut and pasted the sheet below. I don't know how to attach it so you
can see my calculations. They are simple adding and subtracting except
for the share calculations, such as =D33/180*27

Thanks for any suggestions.


RECEIPTS


Public Guardian and Trustee
1,563,000.00

Government of Canada €“ tax refund
2,223.92

Public Guardian and Trustee - balance of funds
3,729.21

Vancouver Coastal Health
320.33




Total receipts

1,569,273.46



DISBURSEMENTS


BC SPCA €“ specific bequest
15,000.00

Salvation Army €“ specific bequest
15,000.00

Law LLP €“ account Dec. 15, 2011
8,925.35

Total disbursements

38,925.35



Balance remaining held in trust

1,530,348.11



PROPOSED €“ HOLDBACK & DISBURSEMENTS

Holdback to cover final Canadian taxes,


Legal and accounting fees
100,000.00




Holdback to cover UK taxes and Accounting fees

Nil
* (No UK Taxes payable as per advice the Administratrix

received from her English accountant. No advice given on

this matter by Law)





Administrators Fees at 1%
15,692.73




BALANCE AVAILABLE FOR INTERIM DISTRIBUTION
1,414,655.38



PROPOSED INTERIM DISTRIBUTION


Mary (90/180 share)

707,327.69
Jean (27/180 share)

212,198.31
David (27/180 share)

212,198.31
Pat (4/180 share)

31,436.79
John (4/180 share)

31,436.79
Peter (4/180 share)

31,436.79
John B (4/180 share)

31,436.79
Frederick (4/180 share)

31,436.79
William (8/180 share)

62,873.57
James (8/180 share)

62,873.57



Total interim distribution:

1,414,655.38
(All funds in Canadian Dollars)