Chapter 2 Excel Problem The following are transation incurred by Albert Co during the month of January 2023. Requirements: 1. Enter and analyze the transactions and month-end adjusting transactions in the horizontal financial statement model. 2. Create Albert Co.'s month-end financial statements (in good form!). 1 TRANSACTIONS a Alberts Co. received $780 cash for services provided. b Alberts Co. paid $420 cash for operating expenses. c Alberts Co. paid $3,000 for a one-year rental of office space. d Alberts Co. earned $960 for services, allowing the customer to put in on account. e A customer paid Alberts Co. $900 for 6 months of services to be performed. f Alberts Co. collected $550 of accounts receivable. g Alberts Co. obtained a $2,000 loan from the bank. ADJUSTING ENTRIES INFORMATION h Alberts Co. recognized use of one month of rent expense. i Alberts Co. earned one month of services that had been prepaid by the customer. j Alberts Co. incurred $230 wages to be paid later. 2. Create Financial Statements Income Statement Statement of Owner's Equity Balance Sheet Cash Flow Statement