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