Can you please help me with the closing je, worksheet, statement, and financial statements tab i have attached the project below. thank you

Date 1-Sep 2-Sep 3-Sep 5-Sep 8-Sep 15-Sep 20-Sep 21-Sep 25-Sep 27-Sep 29-Sep 30-Sep 30-Sep 30-Sep 30-Sep 30-Sep 30-Sep 30-Sep 30-Sep 30-Sep 1 2 3 4 5 6 7 8 9 10 ACC 3010 PROJECT 1 WINTER 2017 DUE February 3 by 8pm submitted to the assignment link in Blackboard You have been hired as an accountant for FigMint Consulting Inc. This business was created when some friends decided to make use of their newly minted college degrees and go into business together. The business was created on September 1, 2016. The company will have a fiscal year end of August 31st. The initial formation transactions and early purchases for FigMint Consulting Inc. resulted in the balances that are included in the first 2 columns of the Worksheet. (see the worksheet tab) During September, the first month of operations, the following transactions occurred: Event Paid $10,800 for 12 months rent on office space Purchased office furniture for $11,650. Purchased $13,950 of additional office supplies on account. Signed a contract with Imagine Inc. for work to be done over the next 12 months Borrowed 40,000 from the bank for operating cash. The note has a 3% interest rate (simple interest) and is to be paid back in 4 years Received $26,400 from Imagine Inc. for the work to be performed over the next 12 months. Paid $1,560 for maintenance on the equipment. Performed services for various customers for $16,200 cash and another $20,100 on account. Paid $9,750 to suppliers for purchases previously made on account. Paid salaries to employees totaling $6,800 for services rendered for 1 week. Paid utility bill totaling $1,790. Collected $16,700 as payment for amounts previously billed. Dividends of $2,000 were declared and paid. At the end of September, the following additional information is available to help determine what adjustments are needed: One month of interest has accrued on the note payable for the bank loan. Salaries of $6,800 are paid every Friday (for a 5 day work week). September 30, 2016 was a Thursday. One month of the prepaid rent has been used up Supplies on hand are $10,300. Additional work for customers of $11,680 has been performed during the last week of September but not yet billed Depreciation expense for the computer equipment is $280 and for the office furniture is $190 One month of the services for the Imagine Inc. has been performed (see above). SUGGESTED STEPS FOR COMPLETION OF THE PROJECT: Prepare journal entries to record the September transactions given. Please refer to the Worksheet tab for Account Title Post the journal entries to ledger accounts using T-accounts to represent ledger accounts. Don't forget the opening balances from the information given on the Worksheet. There is a tab to use for T Accounts if you want Add the September journal entry information to the Worksheet in the September columns Prepare an unadjusted trial balance as of September 30, 2016. This will be part of the Worksheet you prepare. There i tab in this file that you will use for this. Excel formulas must be used throughout the project to obtain full credit. Prepare adjusting entries for the month of September given the information provided. Post the adjusting entries to the T-accounts and to the Adjusting entries columns on the worksheet Prepare an adjusted trial balance as of September 30, 2016. This will be part of the Worksheet you prepare. There is a tab in this file that you will use for this. Prepare financial statements for the month of September 30, 2016. (Income Statement, Statement of Retained Earning Classified Balance Sheet ). Formatting is important and will be graded so be sure you use dollar signs and underlines appropriate. Also be sure you have headings and proper column usage for all statements. There is a tab for these statements. Heading are PARTIALLY completed for the 3 statements. Prepare and post closing entries for the end of the period and to the T Accounts Copy the Worksheet from the Worksheet tab to the Worksheet formulas tab and the Financial Statements from the Financial Statements tab to the Financial Statements tab. Highlight the entire worksheet/financial statements area respecively and press the "ctrl" key and the "~" key. This will cause the formulas used to display instead of the numbers. Save your file with the formulas displayed. REQUIRED TO BE SUBMITTED - You must submit your excel file which must include all Journal entries, tr balances, the worksheet and the financial statements to the correct assignments link on the class Blackboard si by 8 pm Saturday February 3. Your file must be named - "Your name (first and last) Project 1". Failure to nam your file correctly will result in a 1 point deduction. Each student must submit an ORIGINAL excel file that is their own work. While students are encouraged to work together, each student must process and format his/her own set of excel worksheets. Duplicate submissio (format, not numbers) will result in the students receiving a 0 for the assignment. Submissions will NOT be accepted via email attachment. Submission to other than the correct link on BlackBoard will result in a 5 point deduction. NO LATE SUBMISSIONS WILL BE ACCEPTED. JOURNAL ENTRIES - FigMint Consulting Inc DATE ACCOUNT DEBIT 1-Sep PREPAID RENT CREDIT 10,800 CASH 10,800 2-Sep OFFICE FURNITUE 11,650 CASH 11,650 3-Sep SUPPLIES 13,950 ACC PAYABLE 13,950 5-Sep NO ENTRY 8-Sep CASH 40,000 NOTES PAYABLE 15-Sep CASH 40,000 26,400 UNEARNED SERVICE REVENUE 20-Sep MAINTENANCE EXPENSE 26,400 1,560 CASH 1,560 21-Sep CASH 16,200 ACC RECEIVABLE 20,100 SERVICE REVENUE 36,300 25-Sep SUPPLIER EXPENSE 9,750 SUPPLIER 9,750 27-Sep SALARIER EXPENSE 6,800 CASH 6,800 29-Sep UTILITY EXPENSE 1,790 CASH 1,790 30-Sep CASH 16,700 ACC RECEIVABLE 30-Sep CASH DIVIDENDS 16,700 2,000 CASH 2,000 30-Sep INTEREST EXPENSE 1,083 INTEREST PAYABLE 30-Sep SALARY EXPENSE 1,083 5,440 SALARY PAYABLE 30-Sep RENT EXPENSE 5,440 900 Page 2 PREPAID RENT 900 30-Sep SUPPLIES EXPENSE 3,650 SUPPLIES 3,650 30-Sep UNBILLED SERVICE 11,680 Page 2 ADJUSTING JOURNAL ENTRIES - FigMint Consulting Inc DATE ACCOUNT DEBIT 1-Sep PREPAID RENT CREDIT 10,800 CASH 10,800 2-Sep OFFICE FURNITUE 11,650 CASH 11,650 3-Sep SUPPLIES 13,950 ACC PAYABLE 13,950 5-Sep NO ENTRY 8-Sep CASH 40,000 NOTES PAYABLE 15-Sep CASH 40,000 26,400 UNEARNED SERVICE REVENUE 20-Sep MAINTENANCE EXPENSE 26,400 1,560 CASH 1,560 21-Sep CASH 16,200 ACC RECEIVABLE 20,100 SERVICE REVENUE 36,300 25-Sep SUPPLIER EXPENSE 9,750 SUPPLIER 9,750 27-Sep SALARIER EXPENSE 6,800 CASH 6,800 29-Sep UTILITY EXPENSE 1,790 CASH 1,790 30-Sep CASH 16,700 ACC RECEIVABLE 30-Sep CASH DIVIDENDS 16,700 2,000 CASH 2,000 30-Sep INTEREST EXPENSE 1,083 Page 3 CLOSING JOURNAL ENTRIES -FigMint Consulting Inc DATE 1-Sep ACCOUNT DEBIT Rent CREDIT 900 cash 900 2-Sep furniture 11,460 cash 11,460 3-Sep supplies expense 10,300 supplies 10,300 4-Sep salaries expesne 12,240 salaries 12,240 5-Sep SERVICE REVENUE 50,180 serivce 50,180 6-Sep notes payable 40,000 cash 7-Sep 40,000 cash 2,000 cash dividend 2,000 Page 4 Page 4 ACCOUNT Cash BEGINNING NUMBERS September ENTRIES DEBIT CREDIT DEBIT CREDIT 303,500 UNADJUSTED TRIAL BALANCE DEBIT CREDIT 99,300 Accounts Receivable Supplies 9,750 Prepaid Rent Land 50,000 Computer Equipment 46,500 Accumulated Depreciation, Comp Equip Office Furniture Accumulated Depreciation, Off Furn Accounts Payable 9,750 Salaries Payable Interest Payable Unearned Revenue Long-term Notes Payable Common Stock 400,000 Retained Earnings Dividends Service Revenue 50,180 Salaries Expense 12,240 Rent Expense Supplies Expense Maintenance Expense Utilities Expense Interest Expense Depreciation Expense, Comp Equip Depreciation Expense, Office Furniture Net Income 409,750 409,750 111,540 50,180 Page 9 ADJUSTMENTS DEBIT CREDIT ADJUSTED TRIAL BALANCE DEBIT CREDIT FigMint Consulting Inc Income Statement FigMint Consulting Inc Statement of Retained Earnings FigMint Consulting Inc Balance Sheet Cash 40,000 26,400 16,200 16,700 99,300 Cash 10,800 11,650 1,560 6,800 1,790 2,000 34,600 Prepaid renPrepaid rent 10,800 900 office furniture 11,650 unearned service rev 2,200 26,400 MAINTENANCE EXPENSE ACC RECEIVABLE UTILITY EXPENSE CASH DIVIDENDS 1,790 DEPRECIATION EXPENSE E 280 1,560 20,100 2,000 EQUIPMENT 280 16,700 INTEREST EXPENSE 1,083 DEPRECIATION EXPENSE F 190 supplies supplies 13,950 3,650 acc payable SERVICE REVENUE SUPPLIER EXPENSE 36,300 11,680 2,200 50,180 RENT EXPENSE 900 notes payable 13,950 40,000 SALARY EXPENSE 9,750 6,800 5,440 12,240 SUPPLIES EXPENSE UNBILLED SERVICE 3,650 11,680 ACCUMULATED DEP FURNITURE 190