Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

A 00 D E F G H 12/31/2013 1 Date: e . 5 5 - B 0 1 2 3 4 5 6 7 8

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed

A 00 D E F G H 12/31/2013 1 Date: e . 5 5 - B 0 1 2 3 4 5 6 7 8 9 date customer sales to cust amount purchased date paid 1 178,790 123,503 9/29/2013 2/9/2014 2 175,635 108,028 9/14/2013 3/6/2014 3 65,366 7,639 9/10/2013 1/20/2014 4 73,728 55,580 10/22/2013 1/25/2014 5 68,357 31,787 11/29/2013 1/23/2014 6 104,679 72,156 11/8/2013 1/17/2014 7 83,139 61,459 10/3/2013 1/25/2014 8 115,376 62,547 10/8/2013 1/28/2014 9 118,309 53,797 11/4/2013 1/22/2014 10 75,210 41,194 9/18/2013 2/10/2014 11 194,738 97,751 10/3/2013 1/5/2014 12 98,713 58,701 10/11/2013 1/30/2014 13 142,627 93,272 12/24/2013 2/22/2014 14 189,176 141,056 12/28/2013 2/23/2014 15 107,447 53,077 11/30/2013 1/30/2014 16 170,355 143,984 10/13/2013 1/18/2014 17 82,707 60,074 12/25/2013 1/14/2014 66,395 54,542 9/15/2013 3/15/2014 19 120,204 60,077 12/13/2013 1/21/2014 199,134 104,177 10/1/2013 3/2/2014 11,168 2,570 9/30/2013 2/21/2014 22 149,133 77,922 10/30/2013 1/14/2014 93,797 4,089 9/14/2013 1/2/2014 24 218,125 142,409 9/14/2013 2/6/2014 25 169,838 70,975 9/20/2013 26 153,987 142,448 9/25/2013 4/2/2014 221,150 144,984 12/12/2013 1/9/2014 151,384 72,738 10/17/2013 1/6/2014 29 162,274 132,915 12/24/2013 1/26/2014 30 94,041 17,247 11/16/2013 1/6/2014 31 153,724 121,314 12/6/2013 2/5/2014 32 51,761 18,703 11/26/2013 1/1/2014 33 215,978 116,254 11/8/2013 1/10/2014 98,159 14,181 10/7/2013 35 142,099 64,592 11/7/2013 1/30/2014 Dec 31 2013 Dec 31 2014 Dec 31 2015 Dec 31 2016 0 18 1 20 2 3 21 4 5 23 6 7 8 9 27 28 0 1 2 3 0 4 5 6 7 34 Dec 31 2017 Dec 31 2018 Solu AutoSave Off Have ReceivablesDataSimulation Search File Home Insert Page Layout Formulas Data Review View Help Calibri 11 ~ AA == ce Wrap Text General 14 IL X Cut LECopy Paste Format Painter Clipboard B I U y ara- Es Merge & Center 3 Y $ % -28 Conditional Formatting Font Alignment Number A1 X fic Last Name B D E F G H 1 Last Name 2 First Name 3 ID 4 5 6 Year Percent of sales Total Outstanding on account written Percent of outstanding receivables written off by receivale age Receivables off group 0-30 31-60 61-90 over 90 7 8 2013 2014 9 10 2015 2016 11 12 2017 13 2018 (perdicted) 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 AutoSave Off Have ReceivablesDataSimul File Home Insert Page Layout Formulas Data Review View Calibri 11 AA = = ab X Cut LECopy Format Painter Paste BIU y y Clipboard Font Alignment B8 X X for 85441 A B D E E F G 12/31/2018 1 Date: 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 date customer sales to cust amount purchased 1 141,275 127,229 11/8/2018 2 184,148 111,895 10/14/2018 3 93,051 41,453 9/29/2018 4 88,292 35,996 10/31/2018 5 168,205 104,513 10/6/2018 6 85,441 23, 274 12/5/2018 7 89,245 77,435 12/12/2018 8 125,393 122,097 11/22/2018 9 98,305 24,961 11/27/2018 10 208,797 122,505 12/10/2018 11 95,977 86,430 12/6/2018 12 147,942 108,059 9/13/2018 13 164, 151 139,552 11/9/2018 14 138,392 99,286 10/21/2018 15 195,607 136,971 9/15/2018 16 221,755 133,588 12/5/2018 17 71,471 24,952 11/24/2018 18 97,170 66,391 9/5/2018 19 183,574 147,212 10/24/2018 20 127,472 95,188 12/8/2018 21 107,533 70,609 12/9/2018 22 30,105 15,891 11/16/2018 23 119,007 44,622 9/8/2018 24 193,222 110,403 9/6/2018 25 136,512 66,341 9/27/2018 26 78,071 48,835 11/19/2018 27 98,771 25,934 12/2/2018 28 211,715 113,467 11/30/2018 29 135,746 82,303 9/17/2018 30 60,762 2,741 11/17/2018 31 81,583 14,673 9/28/2018 32 99,407 20,660 11/12/2018 33 123,692 100,694 10/31/2018 34 124,029 33,440 9/23/2018 35 115,596 40,356 12/1/2018 Dec 31 2013 Dec 31 2014 Dec 31 2015 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 Dec 31 2016 Dec 31 20 AutoSave Off Have ReceivablesDataSimulation File Home Insert Page Layout Formulas Data Review View Help Calibri 11AA == ab ce Wrap TE X Cut LECopy Format Painter Paste BIUD y A y E- - Merge Clipboard Font Alignment A1 X for A D F E F G H B Date: c 12/31/2017 1 date 2 customer sales to cust amount purchased date paid 3 1 183,627 89,077 12/21/2017 1/31/2018 4 2 75,934 19,254 10/1/2017 3/3/2018 5 3 180,615 141,476 11/7/2017 1/13/2018 6 4 4 59,626 25,783 11/3/2017 1/23/2018 7 5 5 126,636 96,523 12/24/2017 1/9/2018 8 6 167,076 149,400 9/28/2017 1/20/2018 9 7 149,119 101,573 12/14/2017 1/4/2018 10 8 111,754 30,064 10/2/2017 1/18/2018 11 9 153,078 90,548 9/27/2017 2/17/2018 12 10 127,787 96,724 12/20/2017 1/10/2018 13 11 83,669 53,938 9/11/2017 2/21/2018 14 12 160,800 91,507 10/30/2017 1/30/2018 15 13 115,526 106,104 10/12/2017 1/27/2018 16 14 185,528 137,333 10/5/2017 1/13/2018 17 15 135,772 121,247 10/17/2017 1/7/2018 18 16 111,097 22,676 11/12/2017 1/3/2018 19 17 82,815 60,320 10/25/2017 1/1/2018 20 18 122,353 75,665 9/19/2017 3/6/2018 21 19 118,281 77,026 10/10/2017 1/8/2018 22 20 162,905 90,746 10/15/2017 1/10/2018 23 21 75,462 64,803 12/7/2017 1/25/2018 24 22 47,908 23,329 11/15/2017 1/30/2018 25 23 153,825 142,933 9/23/2017 1/20/2018 26 24 117,291 64,446 9/17/2017 1/18/2018 27 25 113,747 42,159 12/23/2017 3/1/2018 28 26 100,222 56,297 10/3/2017 1/30/2018 29 27 84,339 69,647 10/11/2017 1/22/2018 30 28 206,167 115,144 11/3/2017 1/6/2018 31 29 182,911 147,246 9/29/2017 3/23/2018 32 30 90,410 59,047 9/5/2017 2/28/2018 33 31 29,877 27,547 9/7/2017 3/8/2018 34 32 117,678 25,246 12/15/2017 1/10/2018 35 33 69,021 21,194 12/18/2017 1/20/2018 36 34 103,503 54,233 9/10/2017 1/25/2018 37 35 54,083 30,706 10/27/2017 1/25/2018 Dec 31 2013 Dec 31 2014 Dec 31 2015 Dec 31 2016 Ready Accessibility: Good to an Dec 31 2017 G H B D F Date: 12/31/2014 date customer sales to cust amount purchased date paid 1 174,124 96,610 9/23/2014 2/13/2015 2 98,552 65,408 11/8/2014 1/7/2015 3 68,937 23,685 9/13/2014 2/18/2015 4 181,582 111,258 11/23/2014 1/16/2015 5 100,355 58,517 9/29/2014 1/12/2015 6 42,938 7,866 11/3/2014 1/6/2015 7 93,499 28,409 10/21/2014 1/24/2015 8 146,931 108,608 10/23/2014 1/13/2015 1 9 173,988 106,728 12/29/2014 2/20/2015 2 10 105,194 91,720 12/18/2014 2/5/2015 3 11 170,943 86,590 9/21/2014 1/31/2015 12 141,686 87,948 12/13/2014 1/19/2015 13 106,482 85,402 11/22/2014 1/7/2015 14 99,089 41,600 10/6/2014 1/13/2015 7 15 95,310 83,946 12/5/2014 1/24/2015 3 16 133,229 86,787 11/23/2014 1/1/2015 17 222,724 136,416 11/30/2014 1/14/2015 18 120,593 57,170 10/16/2014 1 19 185,217 85,710 11/21/2014 1/21/2015 20 162,106 68,104 12/14/2014 1/25/2015 21 235,581 137,165 12/1/2014 1/30/2015 22 86,790 63,031 11/18/2014 1/24/2015 23 130,023 105,839 11/18/2014 1/11/2015 24 101,707 9,283 11/1/2014 1/20/2015 25 92,155 35,149 11/10/2014 1/18/2015 26 233,129 143,885 10/14/2014 1/21/2015 27 101,363 6,052 11/14/2014 1/12/2015 28 154,654 113,705 9/17/2014 3/7/2015 1 29 80,152 2,762 9/15/2014 1/29/2015 2 30 127,043 112,406 10/16/2014 1/23/2015 3 31 144,636 122,675 12/6/2014 1/25/2015 4 32 130,607 72,193 10/18/2014 1/27/2015 5 33 199,511 105,862 12/1/2014 2/3/2015 34 75,224 26,835 12/14/2014 1/12/2015 35 134,463 89,051 12/19/2014 2/9/2015 Dec 31 2013 Dec 31 2014 Dec 31 2015 Dec 31 2016 eady Accessibility: Good to go 3 7 Dec 31 2017 Dec 31 AutoSave Off Have ReceivablesDataSimulati File Home Insert Page Layout Formulas Data Review View Calibri 11AA == ab ce w X Cut LECopy Format Painter Paste BIUD y A y -- += M M Clipboard Font Alignment A1 X for A D E F G G B Date: 12/31/2016 1 date 2 customer sales to cust amount purchased date paid 3 1 54,261 12,801 12/12/2016 1/23/2017 4 2 2 150,751 126,919 12/13/2016 1/13/2017 5 3 3 99,033 31,984 12/18/2016 2/2/2017 6 4 89,648 44,592 10/26/2016 1/18/2017 7 5 213,434 123,255 9/5/2016 2/10/2017 8 6 121,228 58,835 11/18/2016 1/28/2017 9 7 95,788 49,825 10/2/2016 1/22/2017 10 8 193,934 140,052 11/25/2016 1/4/2017 11 9 123,842 39,425 9/28/2016 3/25/2017 12 10 60,873 29,354 12/14/2016 1/10/2017 13 11 125,408 69,410 12/17/2016 1/14/2017 14 12 132,294 55,372 12/21/2016 2/3/2017 15 13 88,801 50,012 11/20/2016 1/20/2017 16 14 155,742 108,145 11/6/2016 1/22/2017 17 15 91,878 16,735 10/12/2016 1/5/2017 18 16 102,769 6,664 12/4/2016 1/2/2017 19 17 159,861 133,322 11/10/2016 1/26/2017 20 18 78,004 21,023 12/21/2016 1/8/2017 21 19 181,495 115,979 10/12/2016 1/19/2017 22 20 123,157 72,591 12/23/2016 1/27/2017 23 21 166,121 123,538 12/26/2016 2/17/2017 24 22 140,513 127,930 10/21/2016 1/11/2017 25 23 159,073 114,966 9/22/2016 1/25/2017 26 24 210,965 144,738 9/30/2016 1/29/2017 27 25 137,069 67,341 9/6/2016 3/13/2017 28 26 138,074 51,426 12/16/2016 1/9/2017 29 27 152,415 81,985 12/24/2016 2/15/2017 30 28 221,924 141,892 9/8/2016 3/11/2017 31 29 120,033 70,702 12/22/2016 2/20/2017 32 30 186,887 144,514 11/13/2016 1/9/2017 33 31 38,551 9,969 9/21/2016 3/6/2017 34 32 87,902 83,441 10/3/2016 1/14/2017 35 33 166,181 135,935 10/26/2016 1/11/2017 36 34 101,106 23,694 10/7/2016 1/1/2017 37 35 82,231 45,695 12/13/2016 2/9/2017 Dec 31 2013 Dec 31 2014 Dec 31 2015 Dec 31 2016 Ready Accessibility: Good to go Dec 31 2017 AutoSave Off Have ReceivablesDataSimulation File Home Insert Page Layout Formulas Data Review View Help Calibri 11AA == ab ce Wrap T X Cut LECopy Format Painter Paste BIUD y A y E == Merge Clipboard Font Alignment A1 X fic A D F E F G H B Date: c 12/31/2015 1 103,475 date 2 customer sales to cust amount purchased date paid 3 1 94,649 8,102 9/5/2015 4/4/2016 4 2 2 69,894 61,332 12/15/2015 2/4/2016 5 3 3 132,382 123,556 12/16/2015 1/6/2016 6 4 179,205 97,361 10/23/2015 1/3/2016 7 5 5 125,383 75,599 9/10/2015 1/27/2016 8 6 199,805 146,506 9/7/2015 1/2/2016 9 7 56,994 42,603 12/24/2015 2/13/2016 10 8 48,595 39,769 11/11/2015 1/28/2016 11 9 174,259 106,286 12/30/2015 2/1/2016 12 10 53,753 26,289 11/17/2015 1/17/2016 13 11 120,469 99,566 9/14/2015 3/9/2016 14 12 101,598 88,087 10/25/2015 1/14/2016 15 13 127,864 110,838 10/13/2015 1/27/2016 16 14 55,748 51,343 11/26/2015 1/28/2016 17 15 140,999 9/23/2015 3/11/2016 18 16 94,791 73,973 9/3/2015 1/10/2016 19 17 67,727 19,730 11/18/2015 20 18 131,712 97,714 11/7/2015 1/30/2016 21 19 76,238 72,347 9/3/2015 2/28/2016 22 20 104,045 28,201 11/5/2015 1/17/2016 23 21 155,317 132,784 11/4/2015 1/26/2016 24 22 205,371 128,643 12/5/2015 1/11/2016 25 23 111,128 76,426 10/25/2015 1/17/2016 26 24 100,081 28,507 10/27/2015 1/8/2016 27 25 55,932 28,513 11/19/2015 1/18/2016 28 26 105,198 79,113 10/13/2015 1/3/2016 29 27 172,834 79,860 9/18/2015 2/14/2016 30 28 138,437 129,318 10/19/2015 1/30/2016 31 29 102,665 10,927 12/4/2015 2/9/2016 32 30 163,175 67,696 9/9/2015 33 31 121,173 72,961 12/5/2015 2/7/2016 34 32 168,798 132,905 11/17/2015 1/10/2016 35 33 112,804 61,183 9/16/2015 1/21/2016 36 34 193,890 149,871 10/20/2015 1/21/2016 37 35 204,753 127,130 12/25/2015 1/4/2016 Dec 31 2013 Dec 31 2014 Dec 31 2015 Dec 31 2016 Ready Accessibility: Good to go Dec 31 2017 HH E Type here to search O $ A 00 D E F G H 12/31/2013 1 Date: e . 5 5 - B 0 1 2 3 4 5 6 7 8 9 date customer sales to cust amount purchased date paid 1 178,790 123,503 9/29/2013 2/9/2014 2 175,635 108,028 9/14/2013 3/6/2014 3 65,366 7,639 9/10/2013 1/20/2014 4 73,728 55,580 10/22/2013 1/25/2014 5 68,357 31,787 11/29/2013 1/23/2014 6 104,679 72,156 11/8/2013 1/17/2014 7 83,139 61,459 10/3/2013 1/25/2014 8 115,376 62,547 10/8/2013 1/28/2014 9 118,309 53,797 11/4/2013 1/22/2014 10 75,210 41,194 9/18/2013 2/10/2014 11 194,738 97,751 10/3/2013 1/5/2014 12 98,713 58,701 10/11/2013 1/30/2014 13 142,627 93,272 12/24/2013 2/22/2014 14 189,176 141,056 12/28/2013 2/23/2014 15 107,447 53,077 11/30/2013 1/30/2014 16 170,355 143,984 10/13/2013 1/18/2014 17 82,707 60,074 12/25/2013 1/14/2014 66,395 54,542 9/15/2013 3/15/2014 19 120,204 60,077 12/13/2013 1/21/2014 199,134 104,177 10/1/2013 3/2/2014 11,168 2,570 9/30/2013 2/21/2014 22 149,133 77,922 10/30/2013 1/14/2014 93,797 4,089 9/14/2013 1/2/2014 24 218,125 142,409 9/14/2013 2/6/2014 25 169,838 70,975 9/20/2013 26 153,987 142,448 9/25/2013 4/2/2014 221,150 144,984 12/12/2013 1/9/2014 151,384 72,738 10/17/2013 1/6/2014 29 162,274 132,915 12/24/2013 1/26/2014 30 94,041 17,247 11/16/2013 1/6/2014 31 153,724 121,314 12/6/2013 2/5/2014 32 51,761 18,703 11/26/2013 1/1/2014 33 215,978 116,254 11/8/2013 1/10/2014 98,159 14,181 10/7/2013 35 142,099 64,592 11/7/2013 1/30/2014 Dec 31 2013 Dec 31 2014 Dec 31 2015 Dec 31 2016 0 18 1 20 2 3 21 4 5 23 6 7 8 9 27 28 0 1 2 3 0 4 5 6 7 34 Dec 31 2017 Dec 31 2018 Solu AutoSave Off Have ReceivablesDataSimulation Search File Home Insert Page Layout Formulas Data Review View Help Calibri 11 ~ AA == ce Wrap Text General 14 IL X Cut LECopy Paste Format Painter Clipboard B I U y ara- Es Merge & Center 3 Y $ % -28 Conditional Formatting Font Alignment Number A1 X fic Last Name B D E F G H 1 Last Name 2 First Name 3 ID 4 5 6 Year Percent of sales Total Outstanding on account written Percent of outstanding receivables written off by receivale age Receivables off group 0-30 31-60 61-90 over 90 7 8 2013 2014 9 10 2015 2016 11 12 2017 13 2018 (perdicted) 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 AutoSave Off Have ReceivablesDataSimul File Home Insert Page Layout Formulas Data Review View Calibri 11 AA = = ab X Cut LECopy Format Painter Paste BIU y y Clipboard Font Alignment B8 X X for 85441 A B D E E F G 12/31/2018 1 Date: 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 date customer sales to cust amount purchased 1 141,275 127,229 11/8/2018 2 184,148 111,895 10/14/2018 3 93,051 41,453 9/29/2018 4 88,292 35,996 10/31/2018 5 168,205 104,513 10/6/2018 6 85,441 23, 274 12/5/2018 7 89,245 77,435 12/12/2018 8 125,393 122,097 11/22/2018 9 98,305 24,961 11/27/2018 10 208,797 122,505 12/10/2018 11 95,977 86,430 12/6/2018 12 147,942 108,059 9/13/2018 13 164, 151 139,552 11/9/2018 14 138,392 99,286 10/21/2018 15 195,607 136,971 9/15/2018 16 221,755 133,588 12/5/2018 17 71,471 24,952 11/24/2018 18 97,170 66,391 9/5/2018 19 183,574 147,212 10/24/2018 20 127,472 95,188 12/8/2018 21 107,533 70,609 12/9/2018 22 30,105 15,891 11/16/2018 23 119,007 44,622 9/8/2018 24 193,222 110,403 9/6/2018 25 136,512 66,341 9/27/2018 26 78,071 48,835 11/19/2018 27 98,771 25,934 12/2/2018 28 211,715 113,467 11/30/2018 29 135,746 82,303 9/17/2018 30 60,762 2,741 11/17/2018 31 81,583 14,673 9/28/2018 32 99,407 20,660 11/12/2018 33 123,692 100,694 10/31/2018 34 124,029 33,440 9/23/2018 35 115,596 40,356 12/1/2018 Dec 31 2013 Dec 31 2014 Dec 31 2015 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 Dec 31 2016 Dec 31 20 AutoSave Off Have ReceivablesDataSimulation File Home Insert Page Layout Formulas Data Review View Help Calibri 11AA == ab ce Wrap TE X Cut LECopy Format Painter Paste BIUD y A y E- - Merge Clipboard Font Alignment A1 X for A D F E F G H B Date: c 12/31/2017 1 date 2 customer sales to cust amount purchased date paid 3 1 183,627 89,077 12/21/2017 1/31/2018 4 2 75,934 19,254 10/1/2017 3/3/2018 5 3 180,615 141,476 11/7/2017 1/13/2018 6 4 4 59,626 25,783 11/3/2017 1/23/2018 7 5 5 126,636 96,523 12/24/2017 1/9/2018 8 6 167,076 149,400 9/28/2017 1/20/2018 9 7 149,119 101,573 12/14/2017 1/4/2018 10 8 111,754 30,064 10/2/2017 1/18/2018 11 9 153,078 90,548 9/27/2017 2/17/2018 12 10 127,787 96,724 12/20/2017 1/10/2018 13 11 83,669 53,938 9/11/2017 2/21/2018 14 12 160,800 91,507 10/30/2017 1/30/2018 15 13 115,526 106,104 10/12/2017 1/27/2018 16 14 185,528 137,333 10/5/2017 1/13/2018 17 15 135,772 121,247 10/17/2017 1/7/2018 18 16 111,097 22,676 11/12/2017 1/3/2018 19 17 82,815 60,320 10/25/2017 1/1/2018 20 18 122,353 75,665 9/19/2017 3/6/2018 21 19 118,281 77,026 10/10/2017 1/8/2018 22 20 162,905 90,746 10/15/2017 1/10/2018 23 21 75,462 64,803 12/7/2017 1/25/2018 24 22 47,908 23,329 11/15/2017 1/30/2018 25 23 153,825 142,933 9/23/2017 1/20/2018 26 24 117,291 64,446 9/17/2017 1/18/2018 27 25 113,747 42,159 12/23/2017 3/1/2018 28 26 100,222 56,297 10/3/2017 1/30/2018 29 27 84,339 69,647 10/11/2017 1/22/2018 30 28 206,167 115,144 11/3/2017 1/6/2018 31 29 182,911 147,246 9/29/2017 3/23/2018 32 30 90,410 59,047 9/5/2017 2/28/2018 33 31 29,877 27,547 9/7/2017 3/8/2018 34 32 117,678 25,246 12/15/2017 1/10/2018 35 33 69,021 21,194 12/18/2017 1/20/2018 36 34 103,503 54,233 9/10/2017 1/25/2018 37 35 54,083 30,706 10/27/2017 1/25/2018 Dec 31 2013 Dec 31 2014 Dec 31 2015 Dec 31 2016 Ready Accessibility: Good to an Dec 31 2017 G H B D F Date: 12/31/2014 date customer sales to cust amount purchased date paid 1 174,124 96,610 9/23/2014 2/13/2015 2 98,552 65,408 11/8/2014 1/7/2015 3 68,937 23,685 9/13/2014 2/18/2015 4 181,582 111,258 11/23/2014 1/16/2015 5 100,355 58,517 9/29/2014 1/12/2015 6 42,938 7,866 11/3/2014 1/6/2015 7 93,499 28,409 10/21/2014 1/24/2015 8 146,931 108,608 10/23/2014 1/13/2015 1 9 173,988 106,728 12/29/2014 2/20/2015 2 10 105,194 91,720 12/18/2014 2/5/2015 3 11 170,943 86,590 9/21/2014 1/31/2015 12 141,686 87,948 12/13/2014 1/19/2015 13 106,482 85,402 11/22/2014 1/7/2015 14 99,089 41,600 10/6/2014 1/13/2015 7 15 95,310 83,946 12/5/2014 1/24/2015 3 16 133,229 86,787 11/23/2014 1/1/2015 17 222,724 136,416 11/30/2014 1/14/2015 18 120,593 57,170 10/16/2014 1 19 185,217 85,710 11/21/2014 1/21/2015 20 162,106 68,104 12/14/2014 1/25/2015 21 235,581 137,165 12/1/2014 1/30/2015 22 86,790 63,031 11/18/2014 1/24/2015 23 130,023 105,839 11/18/2014 1/11/2015 24 101,707 9,283 11/1/2014 1/20/2015 25 92,155 35,149 11/10/2014 1/18/2015 26 233,129 143,885 10/14/2014 1/21/2015 27 101,363 6,052 11/14/2014 1/12/2015 28 154,654 113,705 9/17/2014 3/7/2015 1 29 80,152 2,762 9/15/2014 1/29/2015 2 30 127,043 112,406 10/16/2014 1/23/2015 3 31 144,636 122,675 12/6/2014 1/25/2015 4 32 130,607 72,193 10/18/2014 1/27/2015 5 33 199,511 105,862 12/1/2014 2/3/2015 34 75,224 26,835 12/14/2014 1/12/2015 35 134,463 89,051 12/19/2014 2/9/2015 Dec 31 2013 Dec 31 2014 Dec 31 2015 Dec 31 2016 eady Accessibility: Good to go 3 7 Dec 31 2017 Dec 31 AutoSave Off Have ReceivablesDataSimulati File Home Insert Page Layout Formulas Data Review View Calibri 11AA == ab ce w X Cut LECopy Format Painter Paste BIUD y A y -- += M M Clipboard Font Alignment A1 X for A D E F G G B Date: 12/31/2016 1 date 2 customer sales to cust amount purchased date paid 3 1 54,261 12,801 12/12/2016 1/23/2017 4 2 2 150,751 126,919 12/13/2016 1/13/2017 5 3 3 99,033 31,984 12/18/2016 2/2/2017 6 4 89,648 44,592 10/26/2016 1/18/2017 7 5 213,434 123,255 9/5/2016 2/10/2017 8 6 121,228 58,835 11/18/2016 1/28/2017 9 7 95,788 49,825 10/2/2016 1/22/2017 10 8 193,934 140,052 11/25/2016 1/4/2017 11 9 123,842 39,425 9/28/2016 3/25/2017 12 10 60,873 29,354 12/14/2016 1/10/2017 13 11 125,408 69,410 12/17/2016 1/14/2017 14 12 132,294 55,372 12/21/2016 2/3/2017 15 13 88,801 50,012 11/20/2016 1/20/2017 16 14 155,742 108,145 11/6/2016 1/22/2017 17 15 91,878 16,735 10/12/2016 1/5/2017 18 16 102,769 6,664 12/4/2016 1/2/2017 19 17 159,861 133,322 11/10/2016 1/26/2017 20 18 78,004 21,023 12/21/2016 1/8/2017 21 19 181,495 115,979 10/12/2016 1/19/2017 22 20 123,157 72,591 12/23/2016 1/27/2017 23 21 166,121 123,538 12/26/2016 2/17/2017 24 22 140,513 127,930 10/21/2016 1/11/2017 25 23 159,073 114,966 9/22/2016 1/25/2017 26 24 210,965 144,738 9/30/2016 1/29/2017 27 25 137,069 67,341 9/6/2016 3/13/2017 28 26 138,074 51,426 12/16/2016 1/9/2017 29 27 152,415 81,985 12/24/2016 2/15/2017 30 28 221,924 141,892 9/8/2016 3/11/2017 31 29 120,033 70,702 12/22/2016 2/20/2017 32 30 186,887 144,514 11/13/2016 1/9/2017 33 31 38,551 9,969 9/21/2016 3/6/2017 34 32 87,902 83,441 10/3/2016 1/14/2017 35 33 166,181 135,935 10/26/2016 1/11/2017 36 34 101,106 23,694 10/7/2016 1/1/2017 37 35 82,231 45,695 12/13/2016 2/9/2017 Dec 31 2013 Dec 31 2014 Dec 31 2015 Dec 31 2016 Ready Accessibility: Good to go Dec 31 2017 AutoSave Off Have ReceivablesDataSimulation File Home Insert Page Layout Formulas Data Review View Help Calibri 11AA == ab ce Wrap T X Cut LECopy Format Painter Paste BIUD y A y E == Merge Clipboard Font Alignment A1 X fic A D F E F G H B Date: c 12/31/2015 1 103,475 date 2 customer sales to cust amount purchased date paid 3 1 94,649 8,102 9/5/2015 4/4/2016 4 2 2 69,894 61,332 12/15/2015 2/4/2016 5 3 3 132,382 123,556 12/16/2015 1/6/2016 6 4 179,205 97,361 10/23/2015 1/3/2016 7 5 5 125,383 75,599 9/10/2015 1/27/2016 8 6 199,805 146,506 9/7/2015 1/2/2016 9 7 56,994 42,603 12/24/2015 2/13/2016 10 8 48,595 39,769 11/11/2015 1/28/2016 11 9 174,259 106,286 12/30/2015 2/1/2016 12 10 53,753 26,289 11/17/2015 1/17/2016 13 11 120,469 99,566 9/14/2015 3/9/2016 14 12 101,598 88,087 10/25/2015 1/14/2016 15 13 127,864 110,838 10/13/2015 1/27/2016 16 14 55,748 51,343 11/26/2015 1/28/2016 17 15 140,999 9/23/2015 3/11/2016 18 16 94,791 73,973 9/3/2015 1/10/2016 19 17 67,727 19,730 11/18/2015 20 18 131,712 97,714 11/7/2015 1/30/2016 21 19 76,238 72,347 9/3/2015 2/28/2016 22 20 104,045 28,201 11/5/2015 1/17/2016 23 21 155,317 132,784 11/4/2015 1/26/2016 24 22 205,371 128,643 12/5/2015 1/11/2016 25 23 111,128 76,426 10/25/2015 1/17/2016 26 24 100,081 28,507 10/27/2015 1/8/2016 27 25 55,932 28,513 11/19/2015 1/18/2016 28 26 105,198 79,113 10/13/2015 1/3/2016 29 27 172,834 79,860 9/18/2015 2/14/2016 30 28 138,437 129,318 10/19/2015 1/30/2016 31 29 102,665 10,927 12/4/2015 2/9/2016 32 30 163,175 67,696 9/9/2015 33 31 121,173 72,961 12/5/2015 2/7/2016 34 32 168,798 132,905 11/17/2015 1/10/2016 35 33 112,804 61,183 9/16/2015 1/21/2016 36 34 193,890 149,871 10/20/2015 1/21/2016 37 35 204,753 127,130 12/25/2015 1/4/2016 Dec 31 2013 Dec 31 2014 Dec 31 2015 Dec 31 2016 Ready Accessibility: Good to go Dec 31 2017 HH E Type here to search O $

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Forensic Accounting And Fraud Investigation For Non-Experts

Authors: Stephen Pedneault, Frank Rudewicz, Howard Silverstone, Michael Sheetz

3rd Edition

0470879599, 9780470879597

More Books

Students also viewed these Accounting questions