Spreadsheet: 842039d1694115136-is-there-a-way-to-summarize-data-by-year-with-a-table-or-other-simple-measure-summary-example-updated
Sheet: Sheet2

Investment Name | DATE | PAYMENT | Gross In Deal | RECEIPT | [NAME] | Refinancing | NET INVESTMENT | Year
Initial Payment | 2010-08-11 00:00:00 | 200000
1st pmt | 2010-09-30 00:00:00 | 320000 |  |  |  |  |  | 2010
Adjustment Payment | 2010-10-01 00:00:00 |  |  | 20000 |  |  |  | 2010
3rd Payment | 2011-01-15 00:00:00 | 170000 |  |  |  |  |  | 2011
4th Payment | 2011-03-16 00:00:00 | 172500 |  |  |  |  |  | 2011
Payment for additional 2 units | 2011-05-03 00:00:00 | 205000 |  |  |  |  |  | 2011
Adjustment Payment | 2011-05-02 00:00:00 |  |  | 5000 |  |  |  | 2011
4th Payment | 2011-07-20 00:00:00 | 132500 |  |  |  |  |  | 2011
Distribution | 2011-09-02 00:00:00 |  |  |  | 23400 |  |  | 2011
5th Payment | 2011-10-05 00:00:00 | 200000 |  |  |  |  |  | 2011
Distribution | 2011-11-14 00:00:00 |  |  |  | 25000 |  |  | 2011
6th Payment | 2011-12-23 00:00:00 | 312500 |  |  |  |  |  | 2011
Distribution | 2012-02-14 00:00:00 |  |  |  | 28000 |  |  | 2012
7th Payment | 2012-04-15 00:00:00 | 60000 |  |  |  |  |  | 2012
Distribution | 2012-05-23 00:00:00 |  |  |  | 34250 |  |  | 2012
Distribution | 2012-08-25 00:00:00 |  |  |  | 34450 |  |  | 2012
8th Payment | 2012-08-26 00:00:00 | 125000 |  |  |  |  |  | 2012
9th Payment | 2012-10-31 00:00:00 | 162500 |  |  |  |  |  | 2012
Distribution | 2012-11-15 00:00:00 |  |  |  | 35880 |  |  | 2012
Distribution | 2013-02-20 00:00:00 |  |  |  | 35880 |  |  | 2013
Distribution | 2013-05-21 00:00:00 |  |  |  | 35880 |  |  | 2013
10th Payment | 2013-06-13 00:00:00 | 65000 |  |  |  |  |  | 2013
Refinancing Proceeds (Income) | 2013-08-20 00:00:00 |  |  |  |  |  |  | 2013
Refinancing Proceeds (From Refin) | 2013-08-20 00:00:00 |  |  |  |  |  |  | 2013
Return of Payment | 2013-11-29 00:00:00 | -100000 |  |  |  |  |  | 2013
Distribution | 2013-11-29 00:00:00 |  |  |  | 28430 |  |  | 2013
Proceeds from [NAME] | 2013-11-29 00:00:00 |  |  |  |  |  |  | 2013
Distribution | 2014-03-03 00:00:00 |  |  |  | 20000 |  |  | 2014
Distribution | 2014-05-25 00:00:00 |  |  |  | 20000 |  |  | 2014
Distribution | 2014-08-21 00:00:00 |  |  |  | 20000 |  |  | 2014
Refinancing Proceeds (From Refin) | 2014-08-21 00:00:00 |  |  |  |  | 60000 |  | 2014
Investment Name | DATE | PAYMENT | Gross In Deal | RECEIPT | [NAME] | Refinancing | NET INVESTMENT | Year
Initial Payment | 40401 | 200000 | 200000 |  |  |  | -200000 | 2010
1st pmt | 40451 | 320000 | 520000 |  |  |  | -520000 | 2010
Adjustment Payment | 40452 |  | 520000 | 20000 |  |  | -500000 | 2010
 |  |  |  |  |  |  |  | 2010 Total
3rd Payment | 40558 | 170000 | 690000 |  |  |  | -670000 | 2011
4th Payment | 40618 | 172500 | 862500 |  |  |  | -842500 | 2011
Payment for additional 2 units | 40666 | 205000 | 1067500 |  |  |  | -1047500 | 2011
Adjustment Payment | 40665 |  | 1067500 | 5000 |  |  | -1042500 | 2011
4th Payment | 40744 | 132500 | 1200000 |  |  |  | -1175000 | 2011
Distribution | 40788 |  | 1200000 |  | 23400 |  | -1151600 | 2011
5th Payment | 40821 | 200000 | 1400000 |  |  |  | -1351600 | 2011
Distribution | 40861 |  | 1400000 |  | 25000 |  | -1326600 | 2011
6th Payment | 40900 | 312500 | 1712500 |  |  |  | -1639100 | 2011
 |  |  |  |  |  |  |  | 2011 Total
Distribution | 40953 |  | 1712500 |  | 28000 |  | -1611100 | 2012
7th Payment | 41014 | 60000 | 1772500 |  |  |  | -1671100 | 2012
Distribution | 41052 |  | 1772500 |  | 34250 |  | -1636850 | 2012
Distribution | 41146 |  | 1772500 |  | 34450 |  | -1602400 | 2012
8th Payment | 41147 | 125000 | 1897500 |  |  |  | -1727400 | 2012
9th Payment | 41213 | 162500 | 2060000 |  |  |  | -1889900 | 2012
Distribution | 41228 |  | 2060000 |  | 35880 |  | -1854020 | 2012
 |  |  |  |  |  |  |  | 2012 Total
Distribution | 41325 |  | 2060000 |  | 35880 |  | -1818140 | 2013
Distribution | 41415 |  | 2060000 |  | 35880 |  | -1782260 | 2013
10th Payment | 41438 | 65000 | 2125000 |  |  |  | -1847260 | 2013
Refinancing Proceeds (Income) | 41506 |  | 2125000 |  | 35879.98062641266 |  | -1811380.019373587 | 2013
Refinancing Proceeds (From Refin) | 41506 |  | 2125000 |  |  | 214120.0193735873 | -1597260 | 2013
Return of Payment | 41607 | -100000 | 2025000 |  |  |  | -1497260 | 2013
Distribution | 41607 |  | 2025000 |  | 28430 |  | -1468830 | 2013
Proceeds from [NAME] | 41607 |  | 2025000 |  | 91570 | 91570 | -1285690 | 2013
 |  |  |  |  |  |  |  | 2013 Total
Distribution | 41701 |  | 2025000 |  | 20000 |  | -1265690 | 2014
Distribution | 41784 |  | 2025000 |  | 20000 |  | -1245690 | 2014
Distribution | 41872 |  | 2025000 |  | 20000 |  | -1225690 | 2014
Refinancing Proceeds (From Refin) | 41872 |  | 2025000 |  |  | 60000 | -1165690 | 2014
 |  |  |  |  |  |  |  | 2014 Total
 |  |  |  |  |  |  |  | Grand Total