Elements of The Accounting Equation Completing this activity will help you learn to: Analyze elements...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Elements of The Accounting Equation Completing this activity will help you learn to: • Analyze elements of the accounting equation. • Extract information from a data set using Excel formulas, functions, and/or pivot tables. Scenario: Foto+ is a new company that provides photography services, specializing in headshot pictures of children in elementary schools. The owner of Foto+ Company opened a business checking account and deposited cash in exchange for common stock on April 1. Foto+ bills the school when a job is complete and gives the customer 15 days to pay. The company hires two online vendors who do photo editing and processing for the business. The vendors bill Foto+ on account for their services and give the company 30 days to pay. Foto+ incurs four expenses: a. photo editing and processing services b. car rental and gas expenditures c. online advertisements and purchases of small give-away items with its logo to promote the business. d. a monthly fee for administrative services The Data worksheet contains a list of Foto+'s transactions for April, the first month of operations. The transactions are listed in chronological order. Their dates appear in column A. Each transaction occupies two rows and impacts either two accounting equation elements OR one accounting equation element with opposite effects. Each accounting equation element in column B is either Asset, Liability, or Stockholders' Equity. The amount of each transaction appears in column C. A positive amount indicates an increase in the accounting equation element. A negative amount indicates a decrease. Required: ☑ Required: X Open spreadsheet Steps to create a pivot table: S1. Select a cell in the data on the Data worksheet. S2. Select Insert/ PivotTable. The data range will automatically be inserted. A "Create PivotTable" window should appear. S3. In the window, under "Choose where you want the PivotTable report to be placed," select "New Worksheet." A new worksheet should appear with the PivotTable. S4. A PivotTable Field List should pop up. Drag fields into rows, columns, filters, and values areas as needed. (If this gray work box does not appear, right click in the pivot table and select "Show Field List.") Questions: Use the information on the Data worksheet and pivot tables, formulas, and/or functions to answer the following questions. Q1. What is the total amount of all assets? $ Q2. What is the total amount of all liabilities? $ Q3. What is the total amount of stockholders' equity? $ Q4. What is the total amount on the right side of the accounting equation? $ Q5. What is the accounting equation? Assets Liabilities - Stockholders' Equity Open spreadsheet Steps to create a pivot table: S1. Select a cell in the data on the Data worksheet. S2. Select Insert/ PivotTable. The data range will automatically be inserted. A "Create PivotTable" window should appear. S3. In the window, under "Choose where you want the PivotTable report to be placed," select "New Worksheet." A new worksheet should appear with the PivotTable. S4. A PivotTable Field List should pop up. Drag fields into rows, columns, filters, and values areas as needed. (If this gray work box does not appear, right click in the pivot table and select "Show Field List.") Questions: Use the information on the Data worksheet and pivot tables, formulas, and/or functions to answer the following questions. Q1. What is the total amount of all assets? $ Q2. What is the total amount of all liabilities? Q3. What is the total amount of stockholders' equity? Q4. What is the total amount on the right side of the accounting equation? Q5. What is the accounting equation? Assets Liabilities - Stockholders' Equity Revenue - Expenses = Net Income Assets Liabilities + Stockholders' Equity Assets Stockholders' Equity - Liabilities III template (2).pdf 1 / 7 - 71% + لنا Transaction Elements Amounts 4/1 Paid cash for common stock 4/1 Paid for rental car for the month 4/1 Purchased gas with a credit card 4/1 Billed customer for completed job Asset 5,000 Stockholders' Equity 5,000 Asset -2,183 Stockholders' Equity -2,183 Asset -52 Stockholders' Equity -52 Asset 360 Stockholders' Equity 360 1 4/1 Billed customer for completed job Asset 574 Stockholders' Equity 574 „……....... 2 4/1 Billed customer for completed job 4/2 Received invoice for photo processing work 4/2 Billed customer for completed job 4/2 Billed customer for completed job 4/2 Billed customer for completed job 4/3 Received invoice for photo processing work 4/3 Received invoice for logo items purchase Asset 213 Stockholders' Equity 213 Liability 585 Stockholders' Equity -585 Asset 259 Stockholders' Equity 259 Asset 508 Stockholders' Equity 508 Asset 534 Stockholders' Equity 534 Liability 585 Stockholders' Equity -585 Liability 905 Stockholders' Equity -905 4/3 Billed customer for completed job Asset 328 Stockholders' Equity 328 4/3 Billed customer for completed job 4/3 Billed customer for completed job 4/4 Received invoice for photo processing work 4/4 Purchased gas with a credit card Asset 209 Stockholders' Equity 209 Asset 531 Stockholders' Equity 531 Liability 502 Stockholders' Equity -502 Asset -44 Stockholders' Equity -44 4/4 Billed customer for completed job Asset 285 Stockholders' Equity 285 3 4/4 Billed customer for completed job Asset 253 Stockholders' Equity 253 4/4 Billed customer for completed job Asset 361 Stockholders' Equity 361 4/5 Received invoice for photo processing work Liability 378 Stockholders' Equity -378 4/5 Billed customer for completed job Asset 285 Stockholders' Equity 285 4/5 Received full payment for April 2 invoice Asset 534 Asset -534 4 4 = template (2).pdf 2 / 7 - 71% + │ نا 4/5 Billed customer for completed job Asset 575 Stockholders' Equity 575 4/5 Billed customer for completed job 4/8 Received invoice for photo processing work 4/8 Purchased gas with a credit card Asset 480 Stockholders' Equity 480 Liability 697 Stockholders' Equity -697 Asset -48 Stockholders' Equity -48 4/8 Billed customer for completed job Asset 476 Stockholders' Equity 476 1 4/8 Billed customer for completed job 4/8 Billed customer for completed job 4/8 Received full payment for April 1 invoice 4/8 Received full payment for April 1 invoice 4/9 Received invoice for photo processing work 4/9 Billed customer for completed job Asset 270 Stockholders' Equity 270 Asset 525 Stockholders' Equity 525 Asset 360 Asset -360 Asset 574 Asset -574 Liability 559 Stockholders' Equity -559 Asset 331 Stockholders' Equity 331 4/9 Billed customer for completed job Asset 476 2 Stockholders' Equity 476 4/9 Received full payment for April 2 invoice Asset 508 Asset -508 4/9 Billed customer for completed job Asset 267 Stockholders' Equity 267 4/9 Received full payment for April 3 invoice 4/10 Received invoice for photo processing work 4/10 Received full payment for April 3 invoice 4/10 Received invoice for social media advertising Asset 531 Asset -531 Liability 537 Stockholders' Equity -537 Asset Asset 328 -328 Liability 567 Stockholders' Equity -567 4/10 Billed customer for completed job Asset 415 3 Stockholders' Equity 415 4/10 Received full payment for April 2 invoice Asset 259 Asset -259 4/10 Billed customer for completed job Asset 379 Stockholders' Equity 379 4/10 Billed customer for completed job 4/11 Received invoice for photo processing work 4/11 Purchased gas with a credit card Asset 273 Stockholders' Equity 273 Liability 491 Stockholders' Equity -491 Asset -46 III template (2).pdf 3 / 7 71% + Stockholders' Equity -46 4/11 Billed customer for completed job Asset 296 Stockholders' Equity 296 4/11 Received full payment for April 1 invoice Asset 213 Asset -213 4/11 Billed customer for completed job Asset 289 Stockholders' Equity 289 4/11 Received full payment for April 4 invoice Asset 253 Asset -253 4/11 Billed customer for completed job Asset 193 1 4/12 Received invoice for photo processing work 4/12 Received full payment for April 3 invoice Stockholders' Equity 193 Liability 373 Stockholders' Equity -373 Asset 209 Asset -209 4/12 Billed customer for completed job Asset 217 Stockholders' Equity 217 2 4/12 Billed customer for completed job 4/12 Billed customer for completed job 4/15 Received invoice for photo processing work 4/15 Received full payment for April 5 invoice Asset 238 Stockholders' Equity 238 Asset 379 Stockholders' Equity 379 Liability 442 Stockholders' Equity -442 Asset 285 Asset -285 4/15 Purchased gas with a credit card Asset -41 Stockholders' Equity -41 4/15 Billed customer for completed job Asset 355 Stockholders' Equity 355 4/15 Received full payment for April 4 invoice Asset 361 Asset -361 4/15 Billed customer for completed job Asset 539 Stockholders' Equity 539 4/15 Billed customer for completed job Asset 469 Stockholders' Equity 469 3 4/16 Received invoice for photo processing work 4/16 Received full payment for April 4 invoice Liability 722 Stockholders' Equity -722 Asset 285 Asset -285 4/16 Billed customer for completed job Asset 442 Stockholders' Equity 442 4/16 Received full payment for April 5 invoice Asset 480 Asset -480 4/16 Billed customer for completed job Asset 489 Stockholders' Equity 489 4/16 Billed customer for completed job Asset 588 Stockholders' Equity 588 4 III template (2).pdf 1 2 3 4 4 / 7 I 71% + A 4/16 Received full payment for April 8 invoice 4/17 Received invoice for photo processing work 4/17 Received full payment for April 5 invoice 4/17 Received invoice for advertising materials Asset Asset Asset Asset 270 -270 Liability 744 Stockholders' Equity -744 575 -575 Liability 351 Stockholders' Equity -351 4/17 Billed customer for completed job Asset 457 Stockholders' Equity 457 4/17 Received full payment for April 9 invoice Asset 267 Asset -267 4/17 Billed customer for completed job Asset 516 Stockholders' Equity 516 4/17 Billed customer for completed job 4/18 Paid invoice dated April 3 4/18 Received invoice for photo processing work 4/18 Received full payment for April 10 invoice Asset 210 Stockholders' Equity 210 Asset -905 Liability -905 Liability 568 Stockholders' Equity -568 Asset 379 Asset -379 4/18 Purchased gas with a credit card Asset -50 Stockholders' Equity -50 4/18 Billed customer for completed job Asset 368 Stockholders' Equity 368 4/18 Received full payment for April 8 invoice Asset 476 Asset -476 4/18 Billed customer for completed job Asset 397 Stockholders' Equity 397 4/18 Billed customer for completed job 4/19 Received invoice for photo processing work 4/19 Received full payment for April 9 invoice Asset 419 Stockholders' Equity 419 Liability 580 Stockholders' Equity -580 Asset 331 Asset -331 4/19 Received full payment for April 10 invoice Asset 273 Asset -273 4/19 Billed customer for completed job Asset 375 Stockholders' Equity 375 4/19 Billed customer for completed job Asset 317 Stockholders' Equity 317 4/19 Received full payment for April 9 invoice Asset 476 Asset -476 4/19 Billed customer for completed job Asset 523 Stockholders' Equity 523 4/22 Received invoice for photo processing work Liability 632 III template (2).pdf 5 / 7 71% + |f Stockholders' Equity -632 4/22 Purchased gas with a credit card Asset -54 Stockholders' Equity -54 4/22 Received full payment for April 8 invoice Asset 525 Asset -525 4/22 Billed customer for completed job 4/22 Billed customer for completed job Asset 431 Stockholders' Equity 431 Asset 551 Stockholders' Equity 551 4/22 Received full payment for April 11 invoice Asset 289 2 4/22 Billed customer for completed job 4/23 Received invoice for photo processing work 4/23 Billed customer for completed job Asset -289 Asset 223 Stockholders' Equity 223 Liability 542 Stockholders' Equity -542 Asset 496 Stockholders' Equity 496 4/23 Received full payment for April 12 invoice Asset 238 Asset -238 4/23 Billed customer for completed job Asset 517 Stockholders' Equity 517 4/23 Received full payment for April 10 invoice Asset 415 Asset -415 3 4/23 Received full payment for April 16 invoice 4/24 Received invoice for photo processing work 4/24 Received full payment for April 15 invoice 4/24 Received invoice for online advertising 4/23 Billed customer for completed job Asset 201 Stockholders' Equity 201 Asset 442 Asset -442 Liability 522 Stockholders' Equity -522 Asset Asset Liability 539 -539 404 Stockholders' Equity -404 4/24 Billed customer for completed job Asset 491 Stockholders' Equity 491 4/24 Received full payment for April 11 invoice Asset 296 Asset -296 4 4/24 Billed customer for completed job Asset 391 Stockholders' Equity 391 4/24 Billed customer for completed job Asset 428 Stockholders' Equity 428 4/24 Received full payment for April 17 invoice Asset 210 Asset -210 4/25 Received invoice for photo processing work 4/25 Purchased gas with a credit card Liability 498 Stockholders' Equity -498 Asset -53 Stockholders' Equity -53 5 LO template (2).pdf 7 / 7 - 71% + | ◉ 4/30 Received full payment for April 16 invoice 4/30 Billed customer for completed job 4/30 Received full payment for April 23 invoice Stockholders' Equity 509 Asset 588 Asset -588 Asset 328 Stockholders' Equity 328 Asset 517 Asset -517 Liability 2,780 Stockholders' Equity -2,780 Asset -2,000 Stockholders' Equity -2,000 4 4/30 Received invoice for monthly administrative services 4/30 The company paid dividends to the owner. 5 LO 6 7 III template (2).pdf 6 / 7 71% + 4/25 Billed customer for completed job Asset 197 Stockholders' Equity 197 4/25 Received full payment for April 11 invoice Asset 193 Asset -193 4/25 Billed customer for completed job Asset 248 Stockholders' Equity 248 4/25 Received full payment for April 12 invoice Asset 379 Asset -379 3 4/25 Billed customer for completed job 4/26 Received invoice for photo processing work 4/26 Received full payment for April 12 invoice Asset 463 Stockholders' Equity 463 Liability 390 Stockholders' Equity -390 Asset 217 Asset -217 4/26 Billed customer for completed job Asset 245 Stockholders' Equity 245 4/26 Billed customer for completed job Asset 255 Stockholders' Equity 255 4/26 Received full payment for April 19 invoice Asset 317 Asset -317 4/26 Paid invoice dated April 10 Asset -567 Liability -567 4/26 Billed customer for completed job Asset 551 4 Stockholders' Equity 551 4/26 Received full payment for April 15 invoice Asset 469 Asset -469 4/29 Received invoice for photo processing work 4/29 Purchased gas with a credit card Liability 420 Stockholders' Equity -420 Asset -39 Stockholders' Equity -39 4/29 Billed customer for completed job Asset 454 Stockholders' Equity 454 4/29 Received full payment for April 18 invoice Asset 368 Asset -368 4/29 Billed customer for completed job Asset 197 Stockholders' Equity 197 4/29 Billed customer for completed job Asset 281 LO 5 4/29 Received full payment for April 15 invoice Stockholders' Equity 281 Asset 355 Asset -355 4/30 Received invoice for photo processing work Liability 485 Stockholders' Equity -485 4/30 Billed customer for completed job Asset 518 Stockholders' Equity 518 4/30 Received full payment for April 16 invoice Asset 489 Asset -489 4/30 Billed customer for completed job Asset 509 6 Elements of The Accounting Equation Completing this activity will help you learn to: • Analyze elements of the accounting equation. • Extract information from a data set using Excel formulas, functions, and/or pivot tables. Scenario: Foto+ is a new company that provides photography services, specializing in headshot pictures of children in elementary schools. The owner of Foto+ Company opened a business checking account and deposited cash in exchange for common stock on April 1. Foto+ bills the school when a job is complete and gives the customer 15 days to pay. The company hires two online vendors who do photo editing and processing for the business. The vendors bill Foto+ on account for their services and give the company 30 days to pay. Foto+ incurs four expenses: a. photo editing and processing services b. car rental and gas expenditures c. online advertisements and purchases of small give-away items with its logo to promote the business. d. a monthly fee for administrative services The Data worksheet contains a list of Foto+'s transactions for April, the first month of operations. The transactions are listed in chronological order. Their dates appear in column A. Each transaction occupies two rows and impacts either two accounting equation elements OR one accounting equation element with opposite effects. Each accounting equation element in column B is either Asset, Liability, or Stockholders' Equity. The amount of each transaction appears in column C. A positive amount indicates an increase in the accounting equation element. A negative amount indicates a decrease. Required: ☑ Required: X Open spreadsheet Steps to create a pivot table: S1. Select a cell in the data on the Data worksheet. S2. Select Insert/ PivotTable. The data range will automatically be inserted. A "Create PivotTable" window should appear. S3. In the window, under "Choose where you want the PivotTable report to be placed," select "New Worksheet." A new worksheet should appear with the PivotTable. S4. A PivotTable Field List should pop up. Drag fields into rows, columns, filters, and values areas as needed. (If this gray work box does not appear, right click in the pivot table and select "Show Field List.") Questions: Use the information on the Data worksheet and pivot tables, formulas, and/or functions to answer the following questions. Q1. What is the total amount of all assets? $ Q2. What is the total amount of all liabilities? $ Q3. What is the total amount of stockholders' equity? $ Q4. What is the total amount on the right side of the accounting equation? $ Q5. What is the accounting equation? Assets Liabilities - Stockholders' Equity Open spreadsheet Steps to create a pivot table: S1. Select a cell in the data on the Data worksheet. S2. Select Insert/ PivotTable. The data range will automatically be inserted. A "Create PivotTable" window should appear. S3. In the window, under "Choose where you want the PivotTable report to be placed," select "New Worksheet." A new worksheet should appear with the PivotTable. S4. A PivotTable Field List should pop up. Drag fields into rows, columns, filters, and values areas as needed. (If this gray work box does not appear, right click in the pivot table and select "Show Field List.") Questions: Use the information on the Data worksheet and pivot tables, formulas, and/or functions to answer the following questions. Q1. What is the total amount of all assets? $ Q2. What is the total amount of all liabilities? Q3. What is the total amount of stockholders' equity? Q4. What is the total amount on the right side of the accounting equation? Q5. What is the accounting equation? Assets Liabilities - Stockholders' Equity Revenue - Expenses = Net Income Assets Liabilities + Stockholders' Equity Assets Stockholders' Equity - Liabilities III template (2).pdf 1 / 7 - 71% + لنا Transaction Elements Amounts 4/1 Paid cash for common stock 4/1 Paid for rental car for the month 4/1 Purchased gas with a credit card 4/1 Billed customer for completed job Asset 5,000 Stockholders' Equity 5,000 Asset -2,183 Stockholders' Equity -2,183 Asset -52 Stockholders' Equity -52 Asset 360 Stockholders' Equity 360 1 4/1 Billed customer for completed job Asset 574 Stockholders' Equity 574 „……....... 2 4/1 Billed customer for completed job 4/2 Received invoice for photo processing work 4/2 Billed customer for completed job 4/2 Billed customer for completed job 4/2 Billed customer for completed job 4/3 Received invoice for photo processing work 4/3 Received invoice for logo items purchase Asset 213 Stockholders' Equity 213 Liability 585 Stockholders' Equity -585 Asset 259 Stockholders' Equity 259 Asset 508 Stockholders' Equity 508 Asset 534 Stockholders' Equity 534 Liability 585 Stockholders' Equity -585 Liability 905 Stockholders' Equity -905 4/3 Billed customer for completed job Asset 328 Stockholders' Equity 328 4/3 Billed customer for completed job 4/3 Billed customer for completed job 4/4 Received invoice for photo processing work 4/4 Purchased gas with a credit card Asset 209 Stockholders' Equity 209 Asset 531 Stockholders' Equity 531 Liability 502 Stockholders' Equity -502 Asset -44 Stockholders' Equity -44 4/4 Billed customer for completed job Asset 285 Stockholders' Equity 285 3 4/4 Billed customer for completed job Asset 253 Stockholders' Equity 253 4/4 Billed customer for completed job Asset 361 Stockholders' Equity 361 4/5 Received invoice for photo processing work Liability 378 Stockholders' Equity -378 4/5 Billed customer for completed job Asset 285 Stockholders' Equity 285 4/5 Received full payment for April 2 invoice Asset 534 Asset -534 4 4 = template (2).pdf 2 / 7 - 71% + │ نا 4/5 Billed customer for completed job Asset 575 Stockholders' Equity 575 4/5 Billed customer for completed job 4/8 Received invoice for photo processing work 4/8 Purchased gas with a credit card Asset 480 Stockholders' Equity 480 Liability 697 Stockholders' Equity -697 Asset -48 Stockholders' Equity -48 4/8 Billed customer for completed job Asset 476 Stockholders' Equity 476 1 4/8 Billed customer for completed job 4/8 Billed customer for completed job 4/8 Received full payment for April 1 invoice 4/8 Received full payment for April 1 invoice 4/9 Received invoice for photo processing work 4/9 Billed customer for completed job Asset 270 Stockholders' Equity 270 Asset 525 Stockholders' Equity 525 Asset 360 Asset -360 Asset 574 Asset -574 Liability 559 Stockholders' Equity -559 Asset 331 Stockholders' Equity 331 4/9 Billed customer for completed job Asset 476 2 Stockholders' Equity 476 4/9 Received full payment for April 2 invoice Asset 508 Asset -508 4/9 Billed customer for completed job Asset 267 Stockholders' Equity 267 4/9 Received full payment for April 3 invoice 4/10 Received invoice for photo processing work 4/10 Received full payment for April 3 invoice 4/10 Received invoice for social media advertising Asset 531 Asset -531 Liability 537 Stockholders' Equity -537 Asset Asset 328 -328 Liability 567 Stockholders' Equity -567 4/10 Billed customer for completed job Asset 415 3 Stockholders' Equity 415 4/10 Received full payment for April 2 invoice Asset 259 Asset -259 4/10 Billed customer for completed job Asset 379 Stockholders' Equity 379 4/10 Billed customer for completed job 4/11 Received invoice for photo processing work 4/11 Purchased gas with a credit card Asset 273 Stockholders' Equity 273 Liability 491 Stockholders' Equity -491 Asset -46 III template (2).pdf 3 / 7 71% + Stockholders' Equity -46 4/11 Billed customer for completed job Asset 296 Stockholders' Equity 296 4/11 Received full payment for April 1 invoice Asset 213 Asset -213 4/11 Billed customer for completed job Asset 289 Stockholders' Equity 289 4/11 Received full payment for April 4 invoice Asset 253 Asset -253 4/11 Billed customer for completed job Asset 193 1 4/12 Received invoice for photo processing work 4/12 Received full payment for April 3 invoice Stockholders' Equity 193 Liability 373 Stockholders' Equity -373 Asset 209 Asset -209 4/12 Billed customer for completed job Asset 217 Stockholders' Equity 217 2 4/12 Billed customer for completed job 4/12 Billed customer for completed job 4/15 Received invoice for photo processing work 4/15 Received full payment for April 5 invoice Asset 238 Stockholders' Equity 238 Asset 379 Stockholders' Equity 379 Liability 442 Stockholders' Equity -442 Asset 285 Asset -285 4/15 Purchased gas with a credit card Asset -41 Stockholders' Equity -41 4/15 Billed customer for completed job Asset 355 Stockholders' Equity 355 4/15 Received full payment for April 4 invoice Asset 361 Asset -361 4/15 Billed customer for completed job Asset 539 Stockholders' Equity 539 4/15 Billed customer for completed job Asset 469 Stockholders' Equity 469 3 4/16 Received invoice for photo processing work 4/16 Received full payment for April 4 invoice Liability 722 Stockholders' Equity -722 Asset 285 Asset -285 4/16 Billed customer for completed job Asset 442 Stockholders' Equity 442 4/16 Received full payment for April 5 invoice Asset 480 Asset -480 4/16 Billed customer for completed job Asset 489 Stockholders' Equity 489 4/16 Billed customer for completed job Asset 588 Stockholders' Equity 588 4 III template (2).pdf 1 2 3 4 4 / 7 I 71% + A 4/16 Received full payment for April 8 invoice 4/17 Received invoice for photo processing work 4/17 Received full payment for April 5 invoice 4/17 Received invoice for advertising materials Asset Asset Asset Asset 270 -270 Liability 744 Stockholders' Equity -744 575 -575 Liability 351 Stockholders' Equity -351 4/17 Billed customer for completed job Asset 457 Stockholders' Equity 457 4/17 Received full payment for April 9 invoice Asset 267 Asset -267 4/17 Billed customer for completed job Asset 516 Stockholders' Equity 516 4/17 Billed customer for completed job 4/18 Paid invoice dated April 3 4/18 Received invoice for photo processing work 4/18 Received full payment for April 10 invoice Asset 210 Stockholders' Equity 210 Asset -905 Liability -905 Liability 568 Stockholders' Equity -568 Asset 379 Asset -379 4/18 Purchased gas with a credit card Asset -50 Stockholders' Equity -50 4/18 Billed customer for completed job Asset 368 Stockholders' Equity 368 4/18 Received full payment for April 8 invoice Asset 476 Asset -476 4/18 Billed customer for completed job Asset 397 Stockholders' Equity 397 4/18 Billed customer for completed job 4/19 Received invoice for photo processing work 4/19 Received full payment for April 9 invoice Asset 419 Stockholders' Equity 419 Liability 580 Stockholders' Equity -580 Asset 331 Asset -331 4/19 Received full payment for April 10 invoice Asset 273 Asset -273 4/19 Billed customer for completed job Asset 375 Stockholders' Equity 375 4/19 Billed customer for completed job Asset 317 Stockholders' Equity 317 4/19 Received full payment for April 9 invoice Asset 476 Asset -476 4/19 Billed customer for completed job Asset 523 Stockholders' Equity 523 4/22 Received invoice for photo processing work Liability 632 III template (2).pdf 5 / 7 71% + |f Stockholders' Equity -632 4/22 Purchased gas with a credit card Asset -54 Stockholders' Equity -54 4/22 Received full payment for April 8 invoice Asset 525 Asset -525 4/22 Billed customer for completed job 4/22 Billed customer for completed job Asset 431 Stockholders' Equity 431 Asset 551 Stockholders' Equity 551 4/22 Received full payment for April 11 invoice Asset 289 2 4/22 Billed customer for completed job 4/23 Received invoice for photo processing work 4/23 Billed customer for completed job Asset -289 Asset 223 Stockholders' Equity 223 Liability 542 Stockholders' Equity -542 Asset 496 Stockholders' Equity 496 4/23 Received full payment for April 12 invoice Asset 238 Asset -238 4/23 Billed customer for completed job Asset 517 Stockholders' Equity 517 4/23 Received full payment for April 10 invoice Asset 415 Asset -415 3 4/23 Received full payment for April 16 invoice 4/24 Received invoice for photo processing work 4/24 Received full payment for April 15 invoice 4/24 Received invoice for online advertising 4/23 Billed customer for completed job Asset 201 Stockholders' Equity 201 Asset 442 Asset -442 Liability 522 Stockholders' Equity -522 Asset Asset Liability 539 -539 404 Stockholders' Equity -404 4/24 Billed customer for completed job Asset 491 Stockholders' Equity 491 4/24 Received full payment for April 11 invoice Asset 296 Asset -296 4 4/24 Billed customer for completed job Asset 391 Stockholders' Equity 391 4/24 Billed customer for completed job Asset 428 Stockholders' Equity 428 4/24 Received full payment for April 17 invoice Asset 210 Asset -210 4/25 Received invoice for photo processing work 4/25 Purchased gas with a credit card Liability 498 Stockholders' Equity -498 Asset -53 Stockholders' Equity -53 5 LO template (2).pdf 7 / 7 - 71% + | ◉ 4/30 Received full payment for April 16 invoice 4/30 Billed customer for completed job 4/30 Received full payment for April 23 invoice Stockholders' Equity 509 Asset 588 Asset -588 Asset 328 Stockholders' Equity 328 Asset 517 Asset -517 Liability 2,780 Stockholders' Equity -2,780 Asset -2,000 Stockholders' Equity -2,000 4 4/30 Received invoice for monthly administrative services 4/30 The company paid dividends to the owner. 5 LO 6 7 III template (2).pdf 6 / 7 71% + 4/25 Billed customer for completed job Asset 197 Stockholders' Equity 197 4/25 Received full payment for April 11 invoice Asset 193 Asset -193 4/25 Billed customer for completed job Asset 248 Stockholders' Equity 248 4/25 Received full payment for April 12 invoice Asset 379 Asset -379 3 4/25 Billed customer for completed job 4/26 Received invoice for photo processing work 4/26 Received full payment for April 12 invoice Asset 463 Stockholders' Equity 463 Liability 390 Stockholders' Equity -390 Asset 217 Asset -217 4/26 Billed customer for completed job Asset 245 Stockholders' Equity 245 4/26 Billed customer for completed job Asset 255 Stockholders' Equity 255 4/26 Received full payment for April 19 invoice Asset 317 Asset -317 4/26 Paid invoice dated April 10 Asset -567 Liability -567 4/26 Billed customer for completed job Asset 551 4 Stockholders' Equity 551 4/26 Received full payment for April 15 invoice Asset 469 Asset -469 4/29 Received invoice for photo processing work 4/29 Purchased gas with a credit card Liability 420 Stockholders' Equity -420 Asset -39 Stockholders' Equity -39 4/29 Billed customer for completed job Asset 454 Stockholders' Equity 454 4/29 Received full payment for April 18 invoice Asset 368 Asset -368 4/29 Billed customer for completed job Asset 197 Stockholders' Equity 197 4/29 Billed customer for completed job Asset 281 LO 5 4/29 Received full payment for April 15 invoice Stockholders' Equity 281 Asset 355 Asset -355 4/30 Received invoice for photo processing work Liability 485 Stockholders' Equity -485 4/30 Billed customer for completed job Asset 518 Stockholders' Equity 518 4/30 Received full payment for April 16 invoice Asset 489 Asset -489 4/30 Billed customer for completed job Asset 509 6
Expert Answer:
Related Book For
Horngrens Accounting
ISBN: 978-0133866889
11th edition
Authors: Tracie L. Miller Nobles, Brenda L. Mattison, Ella Mae Matsumura
Posted Date:
Students also viewed these accounting questions
-
sample graph to visualize the distribution of different house prices. NOTE: I just want to see an example so I can have a format to follow.
-
How do environmental factors, such as pollutants, endocrine disruptors, and climate change, impact reproductive health and fertility outcomes in wildlife and human populations, and what strategies...
-
SMART Specific What specifically do you plan to do? Measurable How much? How often? Achievable How confident are you that you will be able to accomplish your goal? Relevant Is the goal worthwhile?...
-
Equation 11.14 can be expressed in "coordinate-free" form by writing P0 cos = P0 r. Do so, and likewise for Eqs. 11.17, 11.18. 11.19, and 11.21.
-
Northeast Servotech Corporation, which offers services to the computer industry, has expanded rapidly in recent years. Because of its profitability, the company has been able to grow without...
-
Assume you are put in charge of launching a new Website for a local nonprofit organization. What costs would you need to account for? Make a list of expected costs and benefits for the project. You...
-
\(7>-6\) Determine if the comparison is true or false.
-
Clemson Company prepares its budgets on the basis of standard costs. A responsibility report is prepared monthly showing the differences between master budget and actual results. Variances are...
-
Analysts announced estimated earnings per share of $4 for the coming year for O Zone Company. The company plans not to pay any dividends for the next three years. For the subsequent two years, the...
-
Examine the time-series pattern of Amazon??s Revenue from inception through December 31, 2005 (see Exhibit 2 of the supplement). Based on this evidence, what stage of development in a company??s l 1...
-
Find the determinant. 34 A= 57
-
Can you provide a BUDGET PLAN (for 3 consecutive years) and CONTINGENCY PLAN in detailed for SM Supermall (Philippines) in relation in expanding in Canada.
-
What is the main pressure that purchasing professionals feel from internal customers especially senior management when making purchasing decisions?
-
Could you elaborate on the factors contributing to interest rate differentials across international bond markets, and how do these disparities influence capital flows and foreign exchange rates?
-
Mecca Copy, a photocopying center located on University Avenue, provided the following data to prepare a budgeted balance sheet for next year: Ending Balances Cash Accounts receivable Supplies...
-
3. Simple binomial tree. We consider a binomial model with two periods and one risky asset. The market evolves as follows. The risky asset has value 40 at time 0, and is either 50 or 20 at time 1....
-
Write a paper about medication error system 2016.
-
What is the price/earnings ratio, and how is it calculated? Discuss.
-
Use the Starbucks Corporation financial statements to answer the following questions. Visit www.pearsonhighered.com/Horngren to view a link to Starbucks Corporation's Fiscal 2013 Annual Report....
-
Jaylin Smith and Heff Talas are forming a partnership, Vintage Leather Goods, to import merchandise from Spain. Smith is especially artistic and will travel to Spain to buy the merchandise. Talas is...
-
Answer the same question as in the previous problem but for the scheme n+1 u+ - u i At un i+1 1 -u-1 +c. = 0. 2Ax
-
Modify the scheme (7.39) for the Burgers equation by changing the central difference approximation of the convective term to the upwind approximation. Assume that \(u\) is always positive. How does...
-
Repeat Problem 7.4 for the scheme based on the Runge-Kutta method of the second order (7.51).
Study smarter with the SolutionInn App