Answered step by step
Verified Expert Solution
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 Foto bills the school when a job is complete and gives the customer 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 days to pay.Foto incurs four expenses: photo editing and processing services car rental and gas expenditures online advertisements and purchases of small giveaway items with its logo to promote the business. a monthly fee for administrative servicesThe Data worksheet contains a list of Fotos transactions for April, the first month of operations.The transactions are listed in chronological order. Their dates appear in column AEach 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:S Select a cell in the data on the Data worksheet.S Select Insert PivotTable. The data range will automatically be inserted. A Create PivotTable window should appeahr.S 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.S 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, andor functions to answer the following questions.Q What is the total amount of all assets?fill in the blank of $Q What is the total amount of all liabilities?fill in the blank of $Q What is the total amount of stockholders' equity?fill in the blank of $Q What is the total amount on the right side of the accounting equation?fill in the blank of $Q 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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started