Question

YOU MUST USE FORMULAS AND CELL REFERENCES FOR INPUTS IN THE WORKSHEETS AND FINANCIAL STATEMENTS FOR YOUR PROJECT TO BE CONSIDERED FOR FULL CREDIT

Submission 1 - due Friday January 17 before 5pm - You must submit your completed Journal entries, the Worksheet complete through the Trial Balance (with totals for all columns), and the worksheet formulas tab complete through the Trial Balance. Your file must be named correctly - "Your name (first and last) Project 1 part 1. Failure to name your file correctly will result in a 1 point deduction Submission 2 - due Friday January 31 before 5pm - You must submit your completed Adjusting Journal Entries, the worksheet with the Trial Balance and adjustments and Adjusted Trial Balance Columns (with totals for all columns), and the Worksheet formulas tabs completed/redone. Your file must be named correctly - "Your name (first and last) Project 1 part 2. Failure to name your file correctly will result in a 1 point deduction Submission 3 - due Friday February 7 before 5pm - You must submit your completed Closing entries, the financial statements completed, and the financial statements formulas tab completed. Your file must be named correctly - "Your name (first and last) Project 1 part 3. Failure to name your file correctly will result in a 1 point deduction

Answer 1

From the Information given I have prepared Journal Entries, Adustment Entries, Trial Balance for your reference.
Aug Fug donsultino Ime. Tournal Enteie a uhe month o Janury 2019. 6850 Office &upplies/Supplis Mc To Auounte Payable 1 Jan 6850 3 Jam lash Alc 11760 Re 11760 To Uneamed Pevenue from ( Advonu keuied from slanley Inc) 4 Jan losh Alc 26000 Dee 26000 To Motes Payable Prepaid fentAl ar To losh Ale 8 Jan 8100 8100 10 Jan effice furmeturel Pr To losh A/c 11260 11260. utility Erpense AlC To closh A(c 2340 14 Jan 2340 9750 losh Alc 15 Jan Accounti feceieble Ale Ra 18950 28700 To &evice fevenue Salaries Ale 26 Jan 4375 To Cosh Alc 4375 28 Jam lash Alc 16250 To Account Recavable Ale 16850 Auounts Payakle Ak Rr Te Cash A/c 29 Jan 8650 8650 Diidend A/e 2000 31 Jan To losh 2000

Aug Fig coneulting Inc Adjustment Entris tor the month eud of Januery 675 31 Jan Rent Ae 675 To Prepaid Reut 31 Jan unearned Revenue He Re Te Servrie Ruenue 980 980 31 Jan 65 Interest Expeuse Alc la To Interest Payable Ak 65 31 Jan Salariu Ale 1750 To Salaries Payable 1750. L 4375 f5 oteg doys . FeR 2doys 4375 = 875 ) 875x 2doys =1750] %3D (Suice 31 Sam is Tuudoy) Repreciation Erp-Computer Equipment Der Repreciotion Ery - Office Fuaniture To Accumuleted Rep-Comp Equipuent To Aeuumuleteal Rep - 0fie Furinthre 31 Jan 185 135 Der 185 135

31 Jau Suppliee Erpeuse c R 4380 To Suppliss A/c 4380

Aug Fig Consulting Inc 2 Beginning numbers January Entries Unadjusted Trail Balance Adjusting Entries Adjusted Trail Balance 4. 5 Account Dr Cr Dr Cr Dr Dr Cr Cr Dr Cr 6 Cash 49200 64360 36725 76835 76835 7 Account Receivables 2100 5480 2100 7580 8 Supplies 9 Prepaid Rent 8650 6850 15500 4380 11120 8100 8100 7425 675 10 Land 28000 28000 28000 11 Computer Equipment 42800 42800 42800 Accumulated Depreciation Computer 12 Equipment 13 Office Furniture Accumulated 185 185 11260 11260 11260 Depreciation Office 14 Furniture 15 Accounts Payable 16 Salaries payable 17 Interest Payable 135 135 8650 -1800 6850 6850 1750 1750 65 0. 65 18 Unearned revenue 11760 11760 ol 980 10780 19 Long Term Notes payable 20 Common Stock 21 Retained Earnings 22 Dividend 26000 26000 26000 120000 120000 120000 2000

1750 17 Interest Payable 18 Unearned revenue 65 65 11760 11760 980 0. 10780 19 Long Term Notes payable 20 Common Stock 21 Retained Earnings 26000 26000 26000 120000 120000 ol 120000 22 Dividend 2000 2000 2000 23 Service Revenue 28700 28700 of 6460 35160 24 Salaries Expense 25 Utility Expense 26 Rent Expense 4375 4375 1750 6125 2340 2340 2340 675 675 27 Supplies Expense 28 Interest Expense Depreciation Expense 29 Computer Equipment Depreciation Expense 30 Office Furniture 4380 4380 65 65 185 185 135 135 101385 128650 128650 31 Total 101385 193310 193310 200925 101385 13650 13650 200925 32 33