Please refer to attached An MS Excel file. There are five (5) worksheet tabs as follows: (1) Problem, (2) Ledger, (3) journal, adjust & close entries, (4) adjusted and post trial balance, and (5) financial statements. Please carefully complete the Requirements in the Problem worksheet.

Bluemark Health Care completed the following transactions durin January 201 Trans #/Date Description ved $12,000 from Rivers Company as rent for the use of a vacant office in Blue 1 Jan 1 Rece Health Care's building. Rivers paid rent six months in advance (hint: credit unearned rent revenu Paid $12,000 for an insurance premium on a general business policy. This payment #2 Jan 1. was debited to Prepaid Insurance. #3 Jan 6 Purchased supplies of $6,000 on account Collected $29,000 for services provided to customers on account #4 Jan 9 #5. Jan 11 Paid creditors $22,000 on account. 80,000 in the business in exchange for The sole shareholder invested an additiona #6 Jan 18 capital stock Billed patients $166,000 for services provided on account #7 Jan 20 ved $25,000 for services provided to customers who paid cash #83 Jan 25 Rece $50,000, utilities, $7,000, rent on medical Paid cash for expenses as follows: wages #9 Jan 30 equipment, $7,800, miscellaneous, $500, and advertising, $4,500 Paid dividends of $15,000 to stockholders (Dr. Hancock #10 Jan 30 ved $100,000 cash from customers in payment of services billed on Jan 20 #11 Jan 30 Rece January 31, 2017 ark Health Care adjustment data appears below $2,000 of the prepaid insurance expired during January Adjust A 000 of supplies were on hand on January 31 (hint: check the unad supplies bal first) Adjust B Adjust C $1,200 January depreciation on building was Adjust D $2,000 of unearned rent revenue was earned Adjust E Wages owed employees but not paid was $7,800 Services provided but not yet billed to patients was $12,000 Adjust F as $2,000 in interest payable or 1/31/17 related to the $200,000 notes payabl Adjust G There w Requirements: 1 Under "Journal Entries" in the "journal, adjust & close entries" worksheet, prepare journal entries for the 1 transactions in January 2017 2 Post (enter) the journal entries from (1) to the Ledger (T-Accounts) in the "Ledger" worksheet (Beginning balances have already been entered in the Ledger accounts.) 3 Under "Adjusting Entries in the "journal, adjust & close entries" worksheet, prepare the adjusting entries A through G