How do i create this grid with the following information?
Fleming, Inc. began business operations on January 1, 2019. Fleming's annual reporting period ends December 31. Some events have already occurred and have been recorded; these are reflected in the beginning balances shown n the basic accounting equation grid. Analyze the following additional events during 2019 and complete the requirements on the following pages. Events: a) Paid an accounts payable balance of $5,500. b) Purchased $21,000 of equipment for use in the business, signed a promissory note to pay the supplier in 6 months. c) Earned $88,000 in service revenues for 2019, collecting $40,000 in cash and the rest on credit. d) Purchased $3,400 supplies on account for future use. e) On July 1, paid $18,000 to rent a building for the rest of 2019 and the first half of 2020. f) Customer paid $5,400 in advance for future services. g) Collected accounts receivable, $9,600. h) Declared and paid a $15,000 cash dividend. Data for adjusting entries: i) Wages of $5,600 earned by employees since the December 24 payroll were not yet paid. j) Determined after a year-end count that $6,800 of supplies had been used during the year. k) Fleming provided $4,500 in service that had been prepaid in transaction (f). 1) During December, Fleming provided $6,700 in service on account that was not recorded earlier. m) Depreciation for the year on the equipment was $5,900. n) Accrued $2,300 interest on an outstanding loan (promissory note). o) Building rental expenses for the year, paid in transaction (e), had not yet been recorded. p) Income tax for the year was $39,400. It will be paid in 2020. Llabilities Equity Accounts Prepaid Supplies Rebel Services in hand Accounts Payable Unearned Revenue Notes Common Retained Current Period Payable Stock Earnings Dividends Revenues lope 20,000 + 60,000 37,400 (0) 0 4,600 0 Beginning 64,500 Oper (5,500) 8,600 56,000 (8,700) - 0 7,600 (5,500) 21000 21000 Le Oper 40,000 45000 88000 3400 Page 2 of 2 entries, use the appropriate expense account names from the Unadjusted Trial Be nly one column is provided for Expenses in this grid due to limited space. When events a) - h) in the basic accounting equation grid provided below. Project 1 - Accounting Cycle 9000 000 Brooper (15000) 1./Oper | 3400 s over 9600-900 5400 unadjusted 11,000 43 000 (15,00 60000 21400-15000 48000 -9 000 12000 4001 - 8700 | 5500/5400 41000 213, soo 213500 Check cct 2400 nes Accounts Prepaid Receivable Services Supplies on hand) Notes Payable Retained Revenue Stock Unadjusted Oper 5600 (1095) 9 (0039) 6380) (4.500) 4500 - Oper 16700 Page 6 of 12 6700 (5900 2500) (59oo) journal entries, use the appropriate expense account names from the Unadjusted Trial Balance Note: Only one column is provided for Expenses in this grid due to limited space. When you preparet ) Record items i) - p) in the basic accounting equation grid provided below. Project 1 - Accounting Cycle lom Oper (18,000) loper (3400) 002961410ugns 1 (6800) (5400) | 14500) 5600 | (48800 Closing Period End 24000 - 25700 Check
