https://1drv.ms/x/s!Ajz1egTFoa8gdBwdTNk36sdsZg4?e=j81zdB&nav=MTVfe0RGQjA2OTJFLUVDMjItNEEzQS04NTAzLTc0NzQxNEM1NjkxQX0

Scenario: Fast Fotos is a new company that provides photography services, specializing in residential home photos for local real estate firms. The owner of Fast Fotos Company opened a business checking account and deposited cash in exchange for common stock on April 1. Fast Fotos bills each realtor when a job is complete and gives the customer 15 days to pay. Fees Earned is the revenue account the company uses when it provides its services. The company hires two online vendors who do photo editing and processing for the business. The vendors bill Fast Fotos on account for their services and give the company 30 days to pay. The company's chart of accounts appears below. Chart of Accounts Cash Accounts Receivable Accounts Payable Common Stock Retained Earnings Dividends Fees Earned Processing Expense Automobile Expense Advertising Expense Administrative Expense Fast Fotos incurs four expenses: a. Processing Expense: photo editing and processing services b. Automobiie Expense: car rental and gas expenditures c. Advertising Expense: online advertisements and purchases of small give-away items with its logo to promote the business d. Administrative Expense: a monthly fee for administrative services The Data worksheet contains a list of Fast Fotosr 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 two accounts. The amount of each transaction appears in column C, once for each account. A positive amount indicates an increase in the account's balance. A negative amount indicates a decrease. U Steps to create a pivot table: 51. Select a cell in the data on the Data worksheet. 52. Select Insert i PivotTable. The data range will automatically be inserted. A \"Create PivotTable" window should appear. 53. In the window, under "Choose where you want the PivotTaple report to be placed," select "New Worksheet."A new worksheet should appear with the PivotTable. 54. A PivotTable Field List should pop up. Drag elds 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 tablesr formulasi andfor functions to answer the following questions. Q1. What is the amount of total revenue? 5:] Q2. What is the amount of net income? 5:] Q3. What is the amount of total assets? 5:] Q4. What is the amount of liabilities + stockholders equity once temporary accounts are closed to retained earnings? 5:] Q5. The retained earnings amount at the end of the first accounting period for a new business equals 1 ) Net income + dividends Net income - dividends Net income - dividends 4- common stock r ~. . . \\ 2 Net income + dimdends- common stock