Difference between revisions of "Griever/accounting/summary"
< Griever | accounting
Jump to navigation
Jump to search
m (→Data: update from spreadsheet) |
m (updated links) |
||
| (3 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
{{ | {{hdr/Griever/accountings}} | ||
==Nick Notes== | ==Nick Notes== | ||
* The final total does not include monies spent on merchandise; if the merchandise is not returned in full, then a figure will have to be calculated for that as well and added to the total. | * The final total does not include monies spent on merchandise; if the merchandise is not returned in full, then a figure will have to be calculated for that as well and added to the total. | ||
* Interest is 7.00%, compounded annually. Interest for each year is calculated from the previous year's ending balance. The ending balance for the year is the previous year's balance plus interest plus new activity. | * Interest is 7.00%, compounded annually. Interest for each year is calculated from the previous year's ending balance. The ending balance for the year is the previous year's balance plus interest plus new activity. | ||
* For the sake of accounting simplicity, the Benz expenses are being counted as if they were incurred in 2004, although most of the activity was in 2002. | * For the sake of accounting simplicity, the Benz expenses are being counted as if they were incurred in 2004, although most of the activity was in 2002. | ||
* I am not counting transactions during 1997-1998, as there is some ambiguity about which debits were intended as donations and which were intended as loans. As a gesture of good will (not that they have earned it) and to help simplify the situation, I am forgiving any loans (including over $2000 in YMCA membership fees which were ''not'' intended as donations) made to the Defendants during this time. | |||
==Data== | ==Data== | ||
{| | {| | ||
| Line 12: | Line 13: | ||
| Ending Balance | | Ending Balance | ||
|- | |- | ||
| | | {{l/same|1999}} | ||
| $0.-- | | $0.-- | ||
| $0.-- | | $0.-- | ||
| Line 18: | Line 19: | ||
| -$1,933.39 | | -$1,933.39 | ||
|- | |- | ||
| | | {{l/same|2000}} | ||
| -$1,933.39 | | -$1,933.39 | ||
| -$135.34 | | -$135.34 | ||
| Line 24: | Line 25: | ||
| -$4,775.74 | | -$4,775.74 | ||
|- | |- | ||
| | | {{l/same|2001}} | ||
| -$4,775.74 | | -$4,775.74 | ||
| -$334.30 | | -$334.30 | ||
| Line 30: | Line 31: | ||
| -$7,137.00 | | -$7,137.00 | ||
|- | |- | ||
| | | {{l/same|2002}} | ||
| -$7,137.-- | | -$7,137.-- | ||
| -$499.59 | | -$499.59 | ||
| Line 36: | Line 37: | ||
| -$10,014.77 | | -$10,014.77 | ||
|- | |- | ||
| | | {{l/same|storage}}: 2003 Storage Losses | ||
| -$10,014.77 | | -$10,014.77 | ||
| | | | ||
| Line 42: | Line 43: | ||
| -$11,452.77 | | -$11,452.77 | ||
|- | |- | ||
| | | {{l/same|2003}} | ||
| -$11,452.77 | | -$11,452.77 | ||
| -$801.69 | | -$801.69 | ||
| Line 48: | Line 49: | ||
| -$12,845.94 | | -$12,845.94 | ||
|- | |- | ||
| | | {{l/same|Benz}} rental | ||
| -$12,845.94 | | -$12,845.94 | ||
| | | | ||
| Line 54: | Line 55: | ||
| -$26,166.98 | | -$26,166.98 | ||
|- | |- | ||
| | | {{l/same|2004}} | ||
| -$26,166.98 | | -$26,166.98 | ||
| -$1,831.69 | | -$1,831.69 | ||
| Line 60: | Line 61: | ||
| -$30,993.66 | | -$30,993.66 | ||
|- | |- | ||
| | | {{l/same|2005}} | ||
| -$30,993.66 | | -$30,993.66 | ||
| -$2,169.56 | | -$2,169.56 | ||
| -$5, | | -$5,997.35 | ||
| -$39, | | -$39,160.57 | ||
|- | |- | ||
| 2006 | | 2006 – no new activity | ||
| -$39, | | -$39,160.57 | ||
| -$2,741.24 | |||
| $0.00 | |||
| -$41,901.81 | |||
|- | |||
| balance as of 2007-01-01 | |||
| -$41,901.81 | |||
| n/a | | n/a | ||
| | | | ||
| -$ | | -$41,901.81 | ||
|- | |- | ||
|} | |} | ||
Latest revision as of 01:47, 15 August 2015
--Totals-- | 1997 .. 1998 .. 1999 .. 2000 .. 2001 .. 2002 .. 2003 .. Benz .. Storage .. 2004 .. 2005
Nick Notes
- The final total does not include monies spent on merchandise; if the merchandise is not returned in full, then a figure will have to be calculated for that as well and added to the total.
- Interest is 7.00%, compounded annually. Interest for each year is calculated from the previous year's ending balance. The ending balance for the year is the previous year's balance plus interest plus new activity.
- For the sake of accounting simplicity, the Benz expenses are being counted as if they were incurred in 2004, although most of the activity was in 2002.
- I am not counting transactions during 1997-1998, as there is some ambiguity about which debits were intended as donations and which were intended as loans. As a gesture of good will (not that they have earned it) and to help simplify the situation, I am forgiving any loans (including over $2000 in YMCA membership fees which were not intended as donations) made to the Defendants during this time.
Data
| Year or Item | Previous Balance | Interest | New Activity | Ending Balance |
| 1999 | $0.-- | $0.-- | -$1,933.39 | -$1,933.39 |
| 2000 | -$1,933.39 | -$135.34 | -$2,707.01 | -$4,775.74 |
| 2001 | -$4,775.74 | -$334.30 | -$2,026.96 | -$7,137.00 |
| 2002 | -$7,137.-- | -$499.59 | -$2,378.18 | -$10,014.77 |
| storage: 2003 Storage Losses | -$10,014.77 | -$1,438.00 | -$11,452.77 | |
| 2003 | -$11,452.77 | -$801.69 | -$591.47 | -$12,845.94 |
| Benz rental | -$12,845.94 | -$13,321.04 | -$26,166.98 | |
| 2004 | -$26,166.98 | -$1,831.69 | -$2,995.00 | -$30,993.66 |
| 2005 | -$30,993.66 | -$2,169.56 | -$5,997.35 | -$39,160.57 |
| 2006 – no new activity | -$39,160.57 | -$2,741.24 | $0.00 | -$41,901.81 |
| balance as of 2007-01-01 | -$41,901.81 | n/a | -$41,901.81 |