Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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:* photo editing and processing services* car rental and gas expenditures* online advertisements and purchases of small give-away items with its logo to promote the business.* a monthly fee for administrative servicesThe 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:Open spreadsheetSteps 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 appeahr.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?fill in the blank 1 of 1$Q2. What is the total amount of all liabilities?fill in the blank 1 of 1$Q3. What is the total amount of stockholders' equity?fill in the blank 1 of 1$Q4. What is the total amount on the right side of the accounting equation?fill in the blank 1 of 1$Q5. What is the accounting equation?Assets = Liabilities - Stockholders' EquityRevenue - Expenses = Net IncomeAssets = Liabilities + Stockholders' EquityAssets = Stockholders' Equity - Liabilities

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

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

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

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

Get Started

Recommended Textbook for

Managerial Accounting

Authors: Karen W. Braun, Wendy M. Tietz

5th edition

134128524, 978-0134128528

More Books

Students also viewed these Accounting questions

Question

What must a creditor do to become a secured party?

Answered: 1 week ago

Question

When should the last word in a title be capitalized?

Answered: 1 week ago