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
-
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.
-
Using data from the stockholders' equity section of Soong Corporation's balance sheet shown below, compute the book value per share for both the preferred and the common stock. Contributed capital...
-
One problem with the selection sort routine is that it can only be used on arrays with numeric data types. True of False
-
This case stems from a rocky relationship between two Texans. Lawrence Shipley was the president of Shipley Do-Nut Flour & Supply Co., and Andrea Vasquez was a substitute school teacher in the...
-
Wade Corp. has 150,000 shares of common stock outstanding. In 2012, the company reports income from continuing operations before income tax of $1,210,000. Additional transactions not considered in...
-
Nick went out for dinner with a few friends. The restaurant bill should have been $175, but instead, the waitress brings the bill for $160. Find the absolute error and relative percentage error for...
-
r Preferred stock valuation TXS Manufacturing has an outstanding preferred stock issue with a par value of $63 per share. The preferred shares pay dividends annually at a rate of 12%. a. What is the...
-
If parents increasingly worry about the costs their adult children and grandchildren will face because of climate change, how might that change their savings behavior?
-
Explain why total spending on T-shirts in the previous question is also equal to the total incomes earned in the economy. there are two sides to every transaction. Data from in previous question...
-
Classify the following scenarios as examples of frictional, structural, or cyclical unemployment, and explain your answer. a. Nava just finished a computer science degree and wants to live in Austin....
-
If actual output falls from being equal to potential output to being 5 percentage points below potential output, how would you expect the unemployment rate to change?
-
You tell your grandmother about a car youre thinking of buying and, as expected, she tells you a story about buying her first brand new car for $1,500. You feel envious of older generations and wish...
-
A survey of a large number of buyers at a suburban Sam's Club gave the proportions of buyers falling in the following income-residential categories: If a single buyer Is selected from among all...
-
Describe the Operations (+,,*,/) that can cause negligible addition (NA), error magnification (EM), or subtractive cancellation (SC) in calculating ?((x^2)+1) - x . Give the range of where they might...
-
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...
-
Which firms look best for someone wishing to buy stocks on margin?
-
Which firm looks best for someone planning to pay cash to buy 100 shares?
-
Examine all of the views available in the drop-down box menu (Snapshot, Performance, Portfolio, and Nuts and Bolts) to answer the following questions: a. Which fund has the best expense ratio? b....
Study smarter with the SolutionInn App