Please Help Complete the Unadjusted Trial Balance

INSTRUCTIONS Complete each of the following parts of the comprehensive problem in its entirety. You must complete this assignment in the provided Excel template. Maximum number of points for this problem is 50 . Late submissions of work will be docked points at the rate of 10% per day. Michael Scott Consulting Corporation started business operations on July 1. Michael Scott is the sole owner of the corporation. Part A: Journalize the following transactions for July. During July, the following transactions were completed by Michael Scott Consulting Corporation. 1-Jul Michael Scott invested $10,000 in exchange for common stock in Michael Scott Consulting Corporation. 1-Jul Michael Scott Consulting Corporation received $30,000 - a business loan from his nana. His nana will charge him 7\% APR interest, and the loan will be due in 3 years. The first payment is due on December 31st. The interest amount is calculated for you later in the problem. 1-Jul Prepaid $9,600 for one year of rent for office space. 1-Jul HIRED Ryan Howard and Pam Beesly as salespeople. Each will be paid $1,000 per month. 1-Jul Purchased two office computers (PPE) for a total of $1,100 cash. 5-Jul Bought a copy machine (PPE) for $1,300 cash. 7-Jul Purchased office supplies for $900 on account. 8-Jul Pam provided consulting services of $2,500 to Dunder-Mifflin on account due in 10 days. 10-Jul Paid for utilities with $150 cash. 13-Jul Paid for office supplies purchased on account on July 7 in full. 15-Jul Incurred 2 weeks of wages for a total of $1,000 to be paid on July 31. 16-Jul Pam provided consulting services to Jim Halpert of $500, and was paid in cash. 18-Jul Received the payment for services provided on July 8 in full. 22-Jul Ryan provided consulting services for $1,500 to Dwight Schrute on account. 27-Jul Received the payment in full for the services provided on July 22. 31-Jul Paid employee wages incurred on July 15 in full. 31-Jul Incurred one month of interest on the loan from Michael's nana, \$175. Part B: Post the above transactions to the appropriate general ledger accounts and find balances. Part C: Prepare an unadjusted trial balance for Michael Scott Consulting Corporation as of July 31. Part D: Journalize and post to general ledger accounts the following adjustments for July: 1) Wages incurred but not yet paid or recorded for Ryan and Pam are $1,000. 2) Services that had been provided by Michael at the end of July but were not billed or recorded totaled $1,200. 3) $200 of supplies have been used. 4) One month of rent has expired. 5) July depreciation on the computers and copier is $40. 6) A $150 dividend was declared on July 31 , but has not been paid. Part E: Prepare an adjusted trial balance for Michael Scott Consulting Corporation as of July 31st. Part F: Prepare in good form an Income Statement, Retained Earnings Statement, and Classified Balance Sheet for Michael Scott Consulting Corporation at July 31st. Part G: Journalize and post closing entries for Michael Scott Consulting Corporation for the month of July. Part H: Prepare a post-closing trial balance for Michael Scott Consulting Corporation as of July 31st