Question: Prepare an accrual-based income statement for 2018 and a balance sheet as of December 31, 2018 using good form.

HomeVideo, Inc. is a retailer of home theater and wired home 3. The equipment purchased during 2018 is depreciated on a straight-line basis assuming no salvage value. The firm uses a convention where one-half year of depreciation is taken in the year of acquisition (regardless of the actual purchase date) 4. The insurance payment was for a 1-year policy starting on February 1, 2018. 5. At year-end, $21,000 is owed to suppliers for merchandise purchased on credit and received 6. At year-end, merchandise inventory costing $53,700 and supplies totaling $6,400 remained on hand. 7. Salaries earned, but not yet paid to employees at year-end totaled $7,300. products. The company was founded in early 2018 by Jesse Daniels who had significant experience in the industry and numerous contacts. As a result, the business has achieved strong sales in its first year. During 2018, HomeVideo, Inc recorded all cash receipts and cash disbursements. However, HomeVideo, Inc.'s banker is requiring an income statement and balance sheet prepared on an accrual basis. The following is a recap of the cash receipts for 2018: 356,800 Collections from customers Proceeds from bank loan 75,000 100,000 531,800 Proceeds from sale of common stock The cash disbursements data is available on the attached Excel 8. The bank loan requires interest at 10% per year and was sheet. However, the data needs to be analyzed, categorized, and summarized. In addition, HomeVideo, Inc.'s payroll issued on June 1, 2018. The principal and interest are to be repaid together on May 31, 2019 disbursements for wages totaled $105,200. The data was obtained from a separate (not provided) payroll journal Daniels, a family friend, has asked for your assistance in preparing HomeVideo, Inc.'s financial statements at December 31, 2018 on an accrual basis. The following additional information is available: 1. Customers owed the company $16,500 at year-end for credit sales. Also, HomeVideo, Inc.'s cash collections included $7,000 of amounts collected in advance from other customers for services to be performed in 2019. 2. The firm signed a 3-year lease for a retail store with rent payments starting in January 2018. The rent is due on the 15th of every month. Additionally, a security deposit of $5,000 was paid along with the first rent payment. This deposit is likely to be returned at the end of the lease term End of document ACCT 317 FA19 Excel #1 Data - Excel Share Home Insert Page Layout Formulas Data Review View Tell me what you want to do.. Sign in File Wrap Text A Times New Roma General 12 Sort & Find & Share Upload Filter Select Paste Conditional Format as Cell Insert Delete Format B I U Merge & Center 00 Formatting Table Styles Alignment Clipboard Font Number Styles Cells Editing Box K1 A B C E F G H I J 1 Home Video, Inc. 2 Cash Disbursements 1/1/2018 through 3/31/2019 11 12 Date Category Amount 5/9/2018 office equipment 30,000 13 2/1/2018 insurance 14 28,000 office equipment office equipment office equipment 9/23/2018 15 12,000 1/18/2019 16 10,803 6/10/2018 8,000 17 1/15/2018 18 rent 7,000 office equipment 3/30/2019 19 6,528 1/12/2018 merchandise 20 5,948 7/22/2018 merchandise 21 5,914 merchandise 9/16/2018 5,803 22 11/27/2018 merchandise 5,555 23 10/3/2018 merchandise 24 5,522 6/5/2018 merchandise 25 5,276 12/27/2018 merchandise 26 5,263 2/1/2018 merchandise 27 5,243 12/21/2018 merchandise 28 5,220 merchandise 1/20/2018 29 5,208 9/15/2018 merchandise 30 5,160 merchandise 5/15/2018 5,009 31 office equipment 12/8/2018 5,000 32 9/7/2018 merchandise 33 4,976 4/5/2018 merchandise 34 4,880 8/17/2018 merchandise 35 4,827 1/9/2019 merchandise 36 4,800 Sheetl + 120% Ready 1:35 PM 9/20/2019 ACCT 317 FA19 Excel #1 Data - Excel Share Home Insert Page Layout Formulas Data Review View Tell me what you want to do.. Sign in File Wrap Text Times New Roma 12 General Sort & Find & Share Upload Filter Select Paste Conditional Format as Cell Insert Delete Format IU- Merge & Center 0.00 Formatting Table Styles Clipboard Alignment Font Number Styles Cells Editing x K1 A E F G I J ACCT 317 FA19 Excel #1 Data - Excel OShare Tell me what you want to do... Formulas Home Insert Page Layout Data Review View Sign in File Times New Roma 12 EWrap Text General Share Upload Paste Conditional Format as Cell Insert Delete Format Sort & Find & I U Merge & Center Formatting Table Styles Filter Select Clipboard Styles Editing Font Alignment Number Cells x 1 KA A F G I J 8/17/2018 merchandise 35 4,827 1/9/2019 merchandise 36 4,800 11/2/2018 merchandise 37 4,798 8/31/2018 merchandise 38 4,776 3/26/2019 merchandise 39 4,608 merchandise 2/19/2019 40 4,567 10/12/2018 merchandise 41 4,489 2/28/2019 merchandise 4,468 42 3/29/2019 merchandise 4,290 43 1/14/2018 merchandise 44 4,267 3/25/2018 merchandise 45 4,167 5/29/2018 merchandise 4,165 46 3/14/2019 merchandise 4,102 47 2/18/2019 merchandise 4,078 48 7/27/2018 merchandise 49 4,042 3/14/2019 merchandise 4,025 50 8/13/2018 merchandise 3,971 51 6/23/2018 merchandise 52 3,967 3/1/2018 merchandise 3,929 53 3/3/2019 merchandise 54 3,883 11/30/2018 55 merchandise 3,855 11/22/2018 merchandise 3,852 56 3/20/2019 office equipment 57 3,807 | B | | B ACCT 317 FA19 Excel #1 Data - Excel Share Home Insert Page Layout Formulas Data Review View Tell me what you want to do.. Sign in File Wrap Text Times New Roma 12 General Sort & Find & Share Upload Filter Select Paste Conditional Format as Cell Insert Delete Format BI U Merge & Center 0.00 Formatting Table Styles Clipboard Alignment Font Number Styles Cells Editing Box K1 A C E F G H I J ACCT 317 FA19 Excel #1 Data - Excel OShare Tell me what you want to do... Formulas Home Insert Page Layout Data Review View Sign in File EWrap Text General Times New Roma 12 Share Upload Paste Conditional Format as Cell Insert Delete Format Sort & Find & Merge & Center BI U Formatting Table Styles Filter Select Styles Clipboard Editing Font Alignment Number Cells Box K1 KA A C F G H I J merchandise 11/22/2018 56 3,852 office equipment 3/20/2019 57 3,807 1/20/2018 merchandise 58 3,710 2/3/2019 merchandise 3,618 59 9/2/2018 merchandise 60 3,529 5/20/2018 merchandise 61 3,446 12/2/2018 merchandise 62 3,317 12/18/2018 merchandise 3,170 63 4/15/2018 merchandise 3,138 64 12/17/2018 merchandise 65 3,092 1/11/2019 merchandise 66 3,025 12/25/2018 merchandise 67 3,018 11/15/2018 merchandise 3,000 68 11/2/2018 merchandise 2,855 69 6/16/2018 merchandise 70 2,544 3/6/2018 merchandise 71 2,537 2/18/2019 merchandise 72 2,410 merchandise 9/12/2018 2,300 73 1/1/2019 merchandise 2,212 74 5/15/2018 merchandise 75 2,139 2/18/2019 merchandise 2,132 76 3/9/2019 merchandise 77 2,119 2/15/2019 merchandise 78 2.089 | | | ACCT 317 FA19 Excel #1 Data - Excel Sign in Share Home Insert Page Layout Formulas Data Review View Tell me what you want to do... File Wrap Text A A 12 Times New Roma General Sort & Find & Share Upload Filter Select Paste IU- Conditional Format as Cell Insert Delete Format Merge & Center 0 00 .000 Formatting Table Styles Alignment Clipboard Font Number Styles Cells Editing A fox 1 A F G I J K ACCT 317 FA19 Excel #1 Data Excel - Tell me what you want to do.. Home Insert Page Layout Formulas Data Review View Sign in Share File A A EWrap Text General Times New Roma 12 Share Upload Paste Conditional Format as Cell Insert Delete Format Sort & Find & Merge & Center BI U .0 00 .00 0 Formatting Table Styles Styles Filter Select Clipboard Cells Editing Font Alignment Number A fox 1 X Y KA A F G I J merchandise 3/9/2019 77 2,119 2/15/2019 merchandise 2,089 78 2/15/2018 79 2,000 rent 3/15/2018 80 rent 2,000 4/15/2018 81 rent 2,000 5/15/2018 rent 82 2,000 6/15/2018 rent 83 2,000 7/15/2018 2,000 84 rent 8/15/2018 2,000 85 rent 9/15/2018 86 2,000 rent 10/15/2018 87 rent 2,000 11/15/2018 rent 88 2,000 1/5/2019 89 rent 2,000 1/15/2019 90 rent 2,000 2/15/2019 91 rent 2,000 3/15/2019 92 rent 2,000 9/25/2018 1,996 93 merchandise 3/2/2019 merchandise 1,977 94 6/23/2018 merchandise 95 1,944 4/11/2018 merchandise 96 1,903 3/23/2018 merchandise 97 1,845 1/16/2019 merchandise 98 1,843 4/15/2018 merchandise 99 1,833 | | ACCT 317 FA19 Excel #1 Data - Excel Share Home Insert Page Layout Formulas Data Review View Tell me what you want to do.. Sign in File Wrap Text 12 Times New Roma General Sort & Find & Share Upload Filter Select Paste Conditional Format as Cell Insert Delete Format B I U Merge & Center 0.00 Formatting Table Styles Clipboard Alignment Font Number Styles Cells Editing Box K1 A C E F G H I J ACCT 317 FA19 Excel #1 Data - Excel OShare Tell me what you want to do... Formulas Home Insert Page Layout Data Review View Sign in File 12 Times New Roma EWrap Text General Share Upload Paste Conditional Format as Cell Insert Delete Format Sort & Find & Merge & Center BI U Formatting Table Styles Filter Select Clipboard Styles Editing Font Alignment Number Cells Box K1 K A A C F G H J 1/16/2019 merchandise 98 1,843 4/15/2018 merchandise 99 1,833 10/5/2018 merchandise 100 1,764 merchandise 6/25/2018 1,680 101 102 5/1/2018 merchandise 1,614 6/16/2018 merchandise 1,551 103 104 6/2/2018 merchandise 1,486 11/11/2018 merchandise 105 1,463 106 9/1/2018 merchandise 1,441 1/4/2019 merchandise 107 1,425 merchandise 11/9/2018 108 1,415 9/5/2018 supplies 109 1,382 110 1/4/2018 merchandise 1,373 supplies supplies supplies 1/18/2018 111 1,348 7/1/2018 1,336 112 6/9/2018 1,332 113 2/1/2019 merchandise 114 1,325 2/7/2019 merchandise 1,315 115 116 1/10/2018 supplies supplies 1,310 5/15/2018 1,279 117 10/21/2018 merchandise 1,259 118 11/26/2018 supplies 119 1,249 10/19/2018 supplies 120 1222 | B) | | B ACCT 317 FA19 Excel #1 Data - Excel Share Home Insert Page Layout Formulas Data Review View Tell me what you want to do.. Sign in File Wrap Text 12 Times New Roma General Sort & Find & Share Upload Filter Select Paste Conditional Format as Cell Insert Delete Format IU- Merge & Center 0.00 Formatting Table Styles Clipboard Alignment Font Number Styles Cells Editing x K1 A E F G I J ACCT 317 FA19 Excel #1 Data - Excel OShare Tell me what you want to do... Formulas Home Insert Page Layout Data Review View Sign in File 12 Times New Roma EWrap Text General Share Upload Paste Conditional Format as Cell Insert Delete Format Sort & Find & Merge & Center BI U Formatting Table Styles Filter Select Styles Clipboard Editing Font Alignment Number Cells x 1 KA A F G I J 5/15/2018 supplies 117 1,279 10/21/2018 merchandise 118 1,259 11/26/2018 supplies supplies supplies supplies supplies supplies supplies supplies supplies supplies supplies 119 1,249 10/19/2018 120 1,222 1/5/2019 121 1,208 11/12/2018 1,183 122 1/22/2019 1,180 123 9/29/2018 1,170 124 8/26/2018 125 1,162 126 7/19/2018 1,160 2/18/2019 1,111 127 1/24/2018 128 1,108 9/11/2018 1,108 129 merchandise 1/9/2018 1,090 130 12/10/2018 supplies 131 1,047 merchandise 1,040 2/23/2019 132 supplies supplies 9/18/2018 133 1,038 4/19/2018 134 1,012 supplies supplies 8/1/2018 135 984 6/25/2018 136 971 6/22/2018 merchandise 137 959 5/2/2018 merchandise 138 913 supplies 139 6/12/2018 902 | | ACCT 317 FA19 Excel #1 Data - Excel Share Home Insert Page Layout Formulas Data Review View Tell me what you want to do.. Sign in File Wrap Text 12 Times New Roma General Sort & Find & Share Upload Filter Select Paste Conditional Format as Cell Insert Delete Format IU- Merge & Center 0.00 Formatting Table Styles Clipboard Alignment Font Number Styles Cells Editing x K1 A E F G I J ACCT 317 FA19 Excel #1 Data Excel OShare Tell me what you want to do... Formulas Home Insert Page Layout Data Review View Sign in File Times New Roma 12 EWrap Text General Share Upload Paste Conditional Format as Cell Insert Delete Format Sort & Find & Merge & Center BI U Formatting Table Styles Filter Select Styles Clipboard Editing Font Alignment Number Cells x 1 KA A F G I J 6/25/2018 supplies 136 971 6/22/2018 merchandise 137 959 merchandise 5/2/2018 138 913 supplies supplies other expenses 6/12/2018 139 902 140 4/11/2018 894 7/16/2018 141 825 supplies other expenses other expenses 7/31/2018 142 786 2/2/2019 143 773 7/10/2018 144 766 other expenses 1/21/2019 145 758 other expenses 8/28/2018 146 756 9/18/2018 merchandise 147 752 1/22/2018 merchandise 148 736 3/13/2019 merchandise 149 722 other expenses other expenses 10/4/2018 150 711 10/22/2018 151 686 2/22/2019 merchandise 152 677 3/26/2019 supplies supplies 153 677 8/12/2018 154 675 8/6/2018 merchandise 155 671 other expenses 6/10/2018 156 669 8/4/2018 supplies 157 646 12/12/2018 other expenses 158 633 | | ACCT 317 FA19 Excel #1 Data - Excel Share Home Insert Page Layout Formulas Data Review View Tell me what you want to do.. Sign in File Wrap Text 12 Times New Roma General Sort & Find & Share Upload Filter Select Paste Conditional Format as Cell Insert Delete Format IU- Merge & Center 0.00 Formatting Table Styles Clipboard Alignment Font Number Styles Cells Editing x K1 A E F G I J ACCT 317 FA19 Excel #1 Data Excel OShare Tell me what you want to do... Formulas Home Insert Page Layout Data Review View Sign in File EWrap Text General Times New Roma 12 Share Upload Paste Conditional Format as Cell Insert Delete Format Sort & Find & Merge & Center BI U Formatting Table Styles Filter Select Styles Clipboard Editing Font Alignment Number Cells x 1 KA A F G I J 8/4/2018 supplies other expenses 157 646 12/12/2018 158 633 3/3/2019 supplies 159 627 4/2/2018 merchandise 160 625 12/5/2018 merchandise 161 619 162 supplies supplies other expenses other expenses 6/25/2018 617 3/18/2018 163 605 7/12/2018 164 597 9/19/2018 165 571 supplies other expenses 6/17/2018 166 567 3/27/2018 167 556 other expenses 5/17/2018 168 548 169 1/21/2018 supplies supplies other expenses other expenses other expenses 536 170 8/18/2018 533 4/16/2018 171 523 2/27/2019 172 521 9/14/2018 173 515 1/29/2019 other expenses 174 499 3/14/2019 merchandise 175 499 other expenses other expenses 1/15/2019 176 497 177 8/24/2018 492 3/25/2018 supplies 178 484 5/24/2018 supplies 179 479 | | ACCT 317 FA19 Excel #1 Data - Excel Share Home Insert Page Layout Formulas Data Review View Tell me what you want to do.. Sign in File Wrap Text 12 Times New Roma General Sort & Find & Share Upload Filter Select Paste Conditional Format as Cell Insert Delete Format IU- Merge & Center 0.00 Formatting Table Styles Clipboard Alignment Font Number Styles Cells Editing x K1 A E F G I J ACCT 317 FA19 Excel #1 Data - Excel OShare Tell me what you want to do... Formulas Home Insert Page Layout Data Review View Sign in File EWrap Text General Times New Roma 12 Share Upload Paste Conditional Format as Cell Insert Delete Format Sort & Find & Merge & Center BI U Formatting Table Styles Filter Select Clipboard Styles Editing Font Alignment Number Cells x 1 KA A F G I J other expenses 8/24/2018 177 492 supplies supplies supplies 3/25/2018 178 484 179 5/24/2018 479 1/1/2019 180 474 3/15/2019 merchandise 181 452 3/4/2018 supplies other expenses 182 448 5/6/2018 183 447 2/7/2019 supplies 184 444 185 1/27/2019 merchandise 442 other expenses 9/19/2018 186 426 other expenses 3/14/2019 187 394 other expenses 11/24/2018 188 375 189 other expenses other expenses 10/12/2018 373 190 4/3/2018 353 3/1/2019 other expenses 191 343 1/29/2018 supplies other expenses 192 325 4/19/2018 193 322 supplies other expenses 8/26/2018 194 313 7/21/2018 195 301 7/2/2018 supplies other expenses 196 300 1/25/2018 197 284 supplies other expenses 4/18/2018 198 269 199 10/18/2018 264 | | ACCT 317 FA19 Excel #1 Data - Excel Share Home Insert Page Layout Formulas Data Review View Tell me what you want to do.. Sign in File Wrap Text 12 Times New Roma General Sort & Find & Share Upload Filter Select Paste Conditional Format as Cell Insert Delete Format B I U Merge & Center 0.00 Formatting Table Styles Clipboard Alignment Font Number Styles Cells Editing Box K1 A C E F G H I J ACCT 317 FA19 Excel #1 Data - Excel OShare Tell me what you want to do... Formulas Home Insert Page Layout Data Review View Sign in File 12 Times New Roma EWrap Text General Share Upload Paste Conditional Format as Cell Insert Delete Format Sort & Find & BI U Merge & Center Formatting Table Styles Filter Select Clipboard Styles Editing Font Alignment Number Cells Box K1 KA A B C F G H I J merchandise 1/27/2019 185 442 other expenses 186 9/19/2018 426 other expenses 3/14/2019 187 394 other expenses other expenses 11/24/2018 188 375 10/12/2018 189 373 other expenses 4/3/2018 190 353 other expenses 3/1/2019 191 343 1/29/2018 supplies other expenses 192 325 4/19/2018 193 322 8/26/2018 supplies other expenses 194 313 7/21/2018 195 301 supplies other expenses 7/2/2018 196 300 1/25/2018 197 284 4/18/2018 supplies other expenses 198 269 199 10/18/2018 264 9/27/2018 supplies 200 244 1/27/2019 merchandise 201 212 202 other expenses 8/26/2018 210 other expenses 11/21/2018 203 198 4/13/2018 supplies other expenses 204 183 6/15/2018 205 178 206 207 other expenses 2/3/2019 151 4/22/2018 supplies 141 | | HomeVideo, Inc. is a retailer of home theater and wired home 3. The equipment purchased during 2018 is depreciated on a straight-line basis assuming no salvage value. The firm uses a convention where one-half year of depreciation is taken in the year of acquisition (regardless of the actual purchase date) 4. The insurance payment was for a 1-year policy starting on February 1, 2018. 5. At year-end, $21,000 is owed to suppliers for merchandise purchased on credit and received 6. At year-end, merchandise inventory costing $53,700 and supplies totaling $6,400 remained on hand. 7. Salaries earned, but not yet paid to employees at year-end totaled $7,300. products. The company was founded in early 2018 by Jesse Daniels who had significant experience in the industry and numerous contacts. As a result, the business has achieved strong sales in its first year. During 2018, HomeVideo, Inc recorded all cash receipts and cash disbursements. However, HomeVideo, Inc.'s banker is requiring an income statement and balance sheet prepared on an accrual basis. The following is a recap of the cash receipts for 2018: 356,800 Collections from customers Proceeds from bank loan 75,000 100,000 531,800 Proceeds from sale of common stock The cash disbursements data is available on the attached Excel 8. The bank loan requires interest at 10% per year and was sheet. However, the data needs to be analyzed, categorized, and summarized. In addition, HomeVideo, Inc.'s payroll issued on June 1, 2018. The principal and interest are to be repaid together on May 31, 2019 disbursements for wages totaled $105,200. The data was obtained from a separate (not provided) payroll journal Daniels, a family friend, has asked for your assistance in preparing HomeVideo, Inc.'s financial statements at December 31, 2018 on an accrual basis. The following additional information is available: 1. Customers owed the company $16,500 at year-end for credit sales. Also, HomeVideo, Inc.'s cash collections included $7,000 of amounts collected in advance from other customers for services to be performed in 2019. 2. The firm signed a 3-year lease for a retail store with rent payments starting in January 2018. The rent is due on the 15th of every month. Additionally, a security deposit of $5,000 was paid along with the first rent payment. This deposit is likely to be returned at the end of the lease term End of document ACCT 317 FA19 Excel #1 Data - Excel Share Home Insert Page Layout Formulas Data Review View Tell me what you want to do.. Sign in File Wrap Text A Times New Roma General 12 Sort & Find & Share Upload Filter Select Paste Conditional Format as Cell Insert Delete Format B I U Merge & Center 00 Formatting Table Styles Alignment Clipboard Font Number Styles Cells Editing Box K1 A B C E F G H I J 1 Home Video, Inc. 2 Cash Disbursements 1/1/2018 through 3/31/2019 11 12 Date Category Amount 5/9/2018 office equipment 30,000 13 2/1/2018 insurance 14 28,000 office equipment office equipment office equipment 9/23/2018 15 12,000 1/18/2019 16 10,803 6/10/2018 8,000 17 1/15/2018 18 rent 7,000 office equipment 3/30/2019 19 6,528 1/12/2018 merchandise 20 5,948 7/22/2018 merchandise 21 5,914 merchandise 9/16/2018 5,803 22 11/27/2018 merchandise 5,555 23 10/3/2018 merchandise 24 5,522 6/5/2018 merchandise 25 5,276 12/27/2018 merchandise 26 5,263 2/1/2018 merchandise 27 5,243 12/21/2018 merchandise 28 5,220 merchandise 1/20/2018 29 5,208 9/15/2018 merchandise 30 5,160 merchandise 5/15/2018 5,009 31 office equipment 12/8/2018 5,000 32 9/7/2018 merchandise 33 4,976 4/5/2018 merchandise 34 4,880 8/17/2018 merchandise 35 4,827 1/9/2019 merchandise 36 4,800 Sheetl + 120% Ready 1:35 PM 9/20/2019 ACCT 317 FA19 Excel #1 Data - Excel Share Home Insert Page Layout Formulas Data Review View Tell me what you want to do.. Sign in File Wrap Text Times New Roma 12 General Sort & Find & Share Upload Filter Select Paste Conditional Format as Cell Insert Delete Format IU- Merge & Center 0.00 Formatting Table Styles Clipboard Alignment Font Number Styles Cells Editing x K1 A E F G I J ACCT 317 FA19 Excel #1 Data - Excel OShare Tell me what you want to do... Formulas Home Insert Page Layout Data Review View Sign in File Times New Roma 12 EWrap Text General Share Upload Paste Conditional Format as Cell Insert Delete Format Sort & Find & I U Merge & Center Formatting Table Styles Filter Select Clipboard Styles Editing Font Alignment Number Cells x 1 KA A F G I J 8/17/2018 merchandise 35 4,827 1/9/2019 merchandise 36 4,800 11/2/2018 merchandise 37 4,798 8/31/2018 merchandise 38 4,776 3/26/2019 merchandise 39 4,608 merchandise 2/19/2019 40 4,567 10/12/2018 merchandise 41 4,489 2/28/2019 merchandise 4,468 42 3/29/2019 merchandise 4,290 43 1/14/2018 merchandise 44 4,267 3/25/2018 merchandise 45 4,167 5/29/2018 merchandise 4,165 46 3/14/2019 merchandise 4,102 47 2/18/2019 merchandise 4,078 48 7/27/2018 merchandise 49 4,042 3/14/2019 merchandise 4,025 50 8/13/2018 merchandise 3,971 51 6/23/2018 merchandise 52 3,967 3/1/2018 merchandise 3,929 53 3/3/2019 merchandise 54 3,883 11/30/2018 55 merchandise 3,855 11/22/2018 merchandise 3,852 56 3/20/2019 office equipment 57 3,807 | B | | B ACCT 317 FA19 Excel #1 Data - Excel Share Home Insert Page Layout Formulas Data Review View Tell me what you want to do.. Sign in File Wrap Text Times New Roma 12 General Sort & Find & Share Upload Filter Select Paste Conditional Format as Cell Insert Delete Format BI U Merge & Center 0.00 Formatting Table Styles Clipboard Alignment Font Number Styles Cells Editing Box K1 A C E F G H I J ACCT 317 FA19 Excel #1 Data - Excel OShare Tell me what you want to do... Formulas Home Insert Page Layout Data Review View Sign in File EWrap Text General Times New Roma 12 Share Upload Paste Conditional Format as Cell Insert Delete Format Sort & Find & Merge & Center BI U Formatting Table Styles Filter Select Styles Clipboard Editing Font Alignment Number Cells Box K1 KA A C F G H I J merchandise 11/22/2018 56 3,852 office equipment 3/20/2019 57 3,807 1/20/2018 merchandise 58 3,710 2/3/2019 merchandise 3,618 59 9/2/2018 merchandise 60 3,529 5/20/2018 merchandise 61 3,446 12/2/2018 merchandise 62 3,317 12/18/2018 merchandise 3,170 63 4/15/2018 merchandise 3,138 64 12/17/2018 merchandise 65 3,092 1/11/2019 merchandise 66 3,025 12/25/2018 merchandise 67 3,018 11/15/2018 merchandise 3,000 68 11/2/2018 merchandise 2,855 69 6/16/2018 merchandise 70 2,544 3/6/2018 merchandise 71 2,537 2/18/2019 merchandise 72 2,410 merchandise 9/12/2018 2,300 73 1/1/2019 merchandise 2,212 74 5/15/2018 merchandise 75 2,139 2/18/2019 merchandise 2,132 76 3/9/2019 merchandise 77 2,119 2/15/2019 merchandise 78 2.089 | | | ACCT 317 FA19 Excel #1 Data - Excel Sign in Share Home Insert Page Layout Formulas Data Review View Tell me what you want to do... File Wrap Text A A 12 Times New Roma General Sort & Find & Share Upload Filter Select Paste IU- Conditional Format as Cell Insert Delete Format Merge & Center 0 00 .000 Formatting Table Styles Alignment Clipboard Font Number Styles Cells Editing A fox 1 A F G I J K ACCT 317 FA19 Excel #1 Data Excel - Tell me what you want to do.. Home Insert Page Layout Formulas Data Review View Sign in Share File A A EWrap Text General Times New Roma 12 Share Upload Paste Conditional Format as Cell Insert Delete Format Sort & Find & Merge & Center BI U .0 00 .00 0 Formatting Table Styles Styles Filter Select Clipboard Cells Editing Font Alignment Number A fox 1 X Y KA A F G I J merchandise 3/9/2019 77 2,119 2/15/2019 merchandise 2,089 78 2/15/2018 79 2,000 rent 3/15/2018 80 rent 2,000 4/15/2018 81 rent 2,000 5/15/2018 rent 82 2,000 6/15/2018 rent 83 2,000 7/15/2018 2,000 84 rent 8/15/2018 2,000 85 rent 9/15/2018 86 2,000 rent 10/15/2018 87 rent 2,000 11/15/2018 rent 88 2,000 1/5/2019 89 rent 2,000 1/15/2019 90 rent 2,000 2/15/2019 91 rent 2,000 3/15/2019 92 rent 2,000 9/25/2018 1,996 93 merchandise 3/2/2019 merchandise 1,977 94 6/23/2018 merchandise 95 1,944 4/11/2018 merchandise 96 1,903 3/23/2018 merchandise 97 1,845 1/16/2019 merchandise 98 1,843 4/15/2018 merchandise 99 1,833 | | ACCT 317 FA19 Excel #1 Data - Excel Share Home Insert Page Layout Formulas Data Review View Tell me what you want to do.. Sign in File Wrap Text 12 Times New Roma General Sort & Find & Share Upload Filter Select Paste Conditional Format as Cell Insert Delete Format B I U Merge & Center 0.00 Formatting Table Styles Clipboard Alignment Font Number Styles Cells Editing Box K1 A C E F G H I J ACCT 317 FA19 Excel #1 Data - Excel OShare Tell me what you want to do... Formulas Home Insert Page Layout Data Review View Sign in File 12 Times New Roma EWrap Text General Share Upload Paste Conditional Format as Cell Insert Delete Format Sort & Find & Merge & Center BI U Formatting Table Styles Filter Select Clipboard Styles Editing Font Alignment Number Cells Box K1 K A A C F G H J 1/16/2019 merchandise 98 1,843 4/15/2018 merchandise 99 1,833 10/5/2018 merchandise 100 1,764 merchandise 6/25/2018 1,680 101 102 5/1/2018 merchandise 1,614 6/16/2018 merchandise 1,551 103 104 6/2/2018 merchandise 1,486 11/11/2018 merchandise 105 1,463 106 9/1/2018 merchandise 1,441 1/4/2019 merchandise 107 1,425 merchandise 11/9/2018 108 1,415 9/5/2018 supplies 109 1,382 110 1/4/2018 merchandise 1,373 supplies supplies supplies 1/18/2018 111 1,348 7/1/2018 1,336 112 6/9/2018 1,332 113 2/1/2019 merchandise 114 1,325 2/7/2019 merchandise 1,315 115 116 1/10/2018 supplies supplies 1,310 5/15/2018 1,279 117 10/21/2018 merchandise 1,259 118 11/26/2018 supplies 119 1,249 10/19/2018 supplies 120 1222 | B) | | B ACCT 317 FA19 Excel #1 Data - Excel Share Home Insert Page Layout Formulas Data Review View Tell me what you want to do.. Sign in File Wrap Text 12 Times New Roma General Sort & Find & Share Upload Filter Select Paste Conditional Format as Cell Insert Delete Format IU- Merge & Center 0.00 Formatting Table Styles Clipboard Alignment Font Number Styles Cells Editing x K1 A E F G I J ACCT 317 FA19 Excel #1 Data - Excel OShare Tell me what you want to do... Formulas Home Insert Page Layout Data Review View Sign in File 12 Times New Roma EWrap Text General Share Upload Paste Conditional Format as Cell Insert Delete Format Sort & Find & Merge & Center BI U Formatting Table Styles Filter Select Styles Clipboard Editing Font Alignment Number Cells x 1 KA A F G I J 5/15/2018 supplies 117 1,279 10/21/2018 merchandise 118 1,259 11/26/2018 supplies supplies supplies supplies supplies supplies supplies supplies supplies supplies supplies 119 1,249 10/19/2018 120 1,222 1/5/2019 121 1,208 11/12/2018 1,183 122 1/22/2019 1,180 123 9/29/2018 1,170 124 8/26/2018 125 1,162 126 7/19/2018 1,160 2/18/2019 1,111 127 1/24/2018 128 1,108 9/11/2018 1,108 129 merchandise 1/9/2018 1,090 130 12/10/2018 supplies 131 1,047 merchandise 1,040 2/23/2019 132 supplies supplies 9/18/2018 133 1,038 4/19/2018 134 1,012 supplies supplies 8/1/2018 135 984 6/25/2018 136 971 6/22/2018 merchandise 137 959 5/2/2018 merchandise 138 913 supplies 139 6/12/2018 902 | | ACCT 317 FA19 Excel #1 Data - Excel Share Home Insert Page Layout Formulas Data Review View Tell me what you want to do.. Sign in File Wrap Text 12 Times New Roma General Sort & Find & Share Upload Filter Select Paste Conditional Format as Cell Insert Delete Format IU- Merge & Center 0.00 Formatting Table Styles Clipboard Alignment Font Number Styles Cells Editing x K1 A E F G I J ACCT 317 FA19 Excel #1 Data Excel OShare Tell me what you want to do... Formulas Home Insert Page Layout Data Review View Sign in File Times New Roma 12 EWrap Text General Share Upload Paste Conditional Format as Cell Insert Delete Format Sort & Find & Merge & Center BI U Formatting Table Styles Filter Select Styles Clipboard Editing Font Alignment Number Cells x 1 KA A F G I J 6/25/2018 supplies 136 971 6/22/2018 merchandise 137 959 merchandise 5/2/2018 138 913 supplies supplies other expenses 6/12/2018 139 902 140 4/11/2018 894 7/16/2018 141 825 supplies other expenses other expenses 7/31/2018 142 786 2/2/2019 143 773 7/10/2018 144 766 other expenses 1/21/2019 145 758 other expenses 8/28/2018 146 756 9/18/2018 merchandise 147 752 1/22/2018 merchandise 148 736 3/13/2019 merchandise 149 722 other expenses other expenses 10/4/2018 150 711 10/22/2018 151 686 2/22/2019 merchandise 152 677 3/26/2019 supplies supplies 153 677 8/12/2018 154 675 8/6/2018 merchandise 155 671 other expenses 6/10/2018 156 669 8/4/2018 supplies 157 646 12/12/2018 other expenses 158 633 | | ACCT 317 FA19 Excel #1 Data - Excel Share Home Insert Page Layout Formulas Data Review View Tell me what you want to do.. Sign in File Wrap Text 12 Times New Roma General Sort & Find & Share Upload Filter Select Paste Conditional Format as Cell Insert Delete Format IU- Merge & Center 0.00 Formatting Table Styles Clipboard Alignment Font Number Styles Cells Editing x K1 A E F G I J ACCT 317 FA19 Excel #1 Data Excel OShare Tell me what you want to do... Formulas Home Insert Page Layout Data Review View Sign in File EWrap Text General Times New Roma 12 Share Upload Paste Conditional Format as Cell Insert Delete Format Sort & Find & Merge & Center BI U Formatting Table Styles Filter Select Styles Clipboard Editing Font Alignment Number Cells x 1 KA A F G I J 8/4/2018 supplies other expenses 157 646 12/12/2018 158 633 3/3/2019 supplies 159 627 4/2/2018 merchandise 160 625 12/5/2018 merchandise 161 619 162 supplies supplies other expenses other expenses 6/25/2018 617 3/18/2018 163 605 7/12/2018 164 597 9/19/2018 165 571 supplies other expenses 6/17/2018 166 567 3/27/2018 167 556 other expenses 5/17/2018 168 548 169 1/21/2018 supplies supplies other expenses other expenses other expenses 536 170 8/18/2018 533 4/16/2018 171 523 2/27/2019 172 521 9/14/2018 173 515 1/29/2019 other expenses 174 499 3/14/2019 merchandise 175 499 other expenses other expenses 1/15/2019 176 497 177 8/24/2018 492 3/25/2018 supplies 178 484 5/24/2018 supplies 179 479 | | ACCT 317 FA19 Excel #1 Data - Excel Share Home Insert Page Layout Formulas Data Review View Tell me what you want to do.. Sign in File Wrap Text 12 Times New Roma General Sort & Find & Share Upload Filter Select Paste Conditional Format as Cell Insert Delete Format IU- Merge & Center 0.00 Formatting Table Styles Clipboard Alignment Font Number Styles Cells Editing x K1 A E F G I J ACCT 317 FA19 Excel #1 Data - Excel OShare Tell me what you want to do... Formulas Home Insert Page Layout Data Review View Sign in File EWrap Text General Times New Roma 12 Share Upload Paste Conditional Format as Cell Insert Delete Format Sort & Find & Merge & Center BI U Formatting Table Styles Filter Select Clipboard Styles Editing Font Alignment Number Cells x 1 KA A F G I J other expenses 8/24/2018 177 492 supplies supplies supplies 3/25/2018 178 484 179 5/24/2018 479 1/1/2019 180 474 3/15/2019 merchandise 181 452 3/4/2018 supplies other expenses 182 448 5/6/2018 183 447 2/7/2019 supplies 184 444 185 1/27/2019 merchandise 442 other expenses 9/19/2018 186 426 other expenses 3/14/2019 187 394 other expenses 11/24/2018 188 375 189 other expenses other expenses 10/12/2018 373 190 4/3/2018 353 3/1/2019 other expenses 191 343 1/29/2018 supplies other expenses 192 325 4/19/2018 193 322 supplies other expenses 8/26/2018 194 313 7/21/2018 195 301 7/2/2018 supplies other expenses 196 300 1/25/2018 197 284 supplies other expenses 4/18/2018 198 269 199 10/18/2018 264 | | ACCT 317 FA19 Excel #1 Data - Excel Share Home Insert Page Layout Formulas Data Review View Tell me what you want to do.. Sign in File Wrap Text 12 Times New Roma General Sort & Find & Share Upload Filter Select Paste Conditional Format as Cell Insert Delete Format B I U Merge & Center 0.00 Formatting Table Styles Clipboard Alignment Font Number Styles Cells Editing Box K1 A C E F G H I J ACCT 317 FA19 Excel #1 Data - Excel OShare Tell me what you want to do... Formulas Home Insert Page Layout Data Review View Sign in File 12 Times New Roma EWrap Text General Share Upload Paste Conditional Format as Cell Insert Delete Format Sort & Find & BI U Merge & Center Formatting Table Styles Filter Select Clipboard Styles Editing Font Alignment Number Cells Box K1 KA A B C F G H I J merchandise 1/27/2019 185 442 other expenses 186 9/19/2018 426 other expenses 3/14/2019 187 394 other expenses other expenses 11/24/2018 188 375 10/12/2018 189 373 other expenses 4/3/2018 190 353 other expenses 3/1/2019 191 343 1/29/2018 supplies other expenses 192 325 4/19/2018 193 322 8/26/2018 supplies other expenses 194 313 7/21/2018 195 301 supplies other expenses 7/2/2018 196 300 1/25/2018 197 284 4/18/2018 supplies other expenses 198 269 199 10/18/2018 264 9/27/2018 supplies 200 244 1/27/2019 merchandise 201 212 202 other expenses 8/26/2018 210 other expenses 11/21/2018 203 198 4/13/2018 supplies other expenses 204 183 6/15/2018 205 178 206 207 other expenses 2/3/2019 151 4/22/2018 supplies 141 | |