Prepare finiancial statements gor the month ending January 31, 2019. (Income Statement, Statement of Retained Earnings, Classisfied Balance Sheet. Use dollar signs and unlerlines as appropriate. Also be sure you have headings ans proper column usage for all statements. Theres a tab for these statements. Heading are partially completed for the 3 statements.

Prepare financial statements for the month ending January 31, 2019. (Income Statement, Statement of Retained Earnings, Classified Balance Sheet). Formatting is important and will be graded so be sure you use dollar signs and underlines as 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 closing entries for the end of the period Format Painter Clipboard Formatting Font Alignment Number X fx MEN EG CLOSING JOURNAL ENTRIES -SeeGoin Consulting Inc ACCOUNT DEBIT CREDIT DATE into ADJUSTING JE CLOSING JE Worksheet statements worksheet formulate financial statement to eneva 14 .KA Copy Weap Test Merge Center - General- $ . Bed Calculation a constam vala met Norm Conditional format as Neutral Formatting table- -A . . Check Cell Format Painter BI Chipboard "we a Center - S-%, O Fort Am 15 SeeGoin Consulting Inc Income Statement SeeGoin Consulting Inc Balance Sheet statements financial statement formu worksheet formulas info E CLOSING JE Worksheet ADJUSTING JE P U LS Review View Te me what you want to do Geneva y Copy mat Bunter B I 9 8 - * - A. . P ap Test Merge Center U S. , Normal Conditional Formatas Neutral Formatting table- Bad Calculation Good Check Cell Clipboard J K DEBIT CREDIT 125,700 9.490 5570 10,450 38,500 B C D E F G H I Worksheet See Goin Consulting Inc BEGINNING NUMBERS JANUARY ENTRIES UNADJUSTED TRIAL BALANCE ADJUSTMENTS ACCOUNT DEBIT CREDIT DEBIT CREDIT DEBIT CREDIT DEBIT CREDIT 4 Cash 38.500 74,410 37 150 125,760 5 Accounts Receivable 22.500 19.6501 2,910 6 Supplies MO 9502 19.422 13.752 7 Prepaid Rent 11.400 11.400 8 Land 35.000 9 Computer Equipment 38.500 3000 10 Accumulated Depreciation Comp Equip 11 Office Furniture 12 Accumulated Depreciation Off Furn 13 Accounts Payable 14 Salaries Payable 15 Interest Payable 16 Unearned Revenue 13,200 13200 17 Long term Notes Payable 30.000 30 000 100.000 18 Common Stock 19 Retained Earnings 20 Dividends 21 Service Revenue 400 22 Series Expanse 23 Rent Expense E ADJUSTING JE CLOSING JE Worksheet statements worksheet formulas financial statement formulas 9860 90 12.100 30,000 100,000 format Puintet B IU D A + Merge & Center - $ % Conditional Formatas Neutral Formatting - Table Calculation Check call Worksheet Seecon Consulting Inc UNADJUSTED TRIAL JANUARY ENTRIES BALANCE N BEGINNING NUMBERS ADJUSTMENTS ISTED THE BALANCE 8.590 9.880 900 950 95 11 13 200 13 200 12 100 11 Office Furniture 12 Accumulated Depreciation Off Furn 13 Accounts Payable 14 Salaries Payable 15 Interest Payable 16 Unearned Revenue 17 Longform Notes Payable 18 Common Stock 19 Retained Earnings 20 Didends 21 Service Revenue 22 Series Expense 23 Ron Experte 24 Supplies Expense 160.000 100.00 1.000 1.000 26 Interest Expense 27 Deprecation Expense. Comp Equip 28 Depreciation Expense Omice Furniture 109 800143621436 2468 100 MO 27437 27437 2 517 258,517 JE ADJUSTING JE CLOSING E Worksheet statements worksheet formulas financial statement formulas File Home Insert Page Layout Formulas Data Review View Tell me what you want to do X Cut Times New Ro - 12 -AA 2. Wrap Text General Copy Paste BIU... A = Merge & Center - $ - % , Format Painter Clipboard Font Alignment Number B41 - X fx =+Worksheet!A4 B JOURNAL ENTRIES - SeeGoin Consulting Inc DATE ACCOUNT DEBIT CREDIT 1-Jan Prepaid Rent 11400 Cash 11400 (To record rent paid in advance) 3-Jan 9562 Supplies Accounts Payable (To record purchase of supplies) 9562 4-Jan 8590 Office Furniture Cash (To record purchase of furniture) 8590 8-Jan 30000 Cash Long-term Notes Payable (To record amount borrowed) 30000 10-Jan 1650 Utilities Expense Cash (To record payment of utilities expense) 23 24 14-Jan Cash Unearned Revenue into JE ADJUSTING JE 13200 13200 Worksheet statements worksheet formulas CLOSING JE financi BIU - H. = A. ste e Merge & Cente Copy Format Painter Clipboard Font Alignment AL x fx =+Worksheet!A4 13200 14-Jan Cash Unearned Revenue (To received services provided) 13200 11560 22560 15-Jan Cash Accounts Receivable Service Revenue (To record service provided) 34120 9860 26-Jan Accounts Payable Cash (To record bill paid) 9860 28-Jan Salaries Expense Cash (To record salaries paid) 4650 29-Jan Dividends Cash (To record Dividend 1000 1000 31-Jan Cash Accounts Receivable (To record cash received) 19650 19650 Tento E ADJUSTING JE CLOSING JE Worksheet statements worksho Formulas Data View Tell me what you Review Page Layout Insert e Home of cut Gener > PWrap Text AA == Times New Ro - 12 Copy . BIU. te $ . Merge & Center - . A. Format Painter Alignment Font Clipboard #20 x r fx " A ADJUSTING JOURNAL ENTRIES - SeeGoin Consulting Inc 2 DATE ACCOUNT DEBIT CREDIT 3 31-Jan Supplies Expense 13.752 Supplies 13,752 (Supplies adjusted against Supplies Expense) 1,100 1.100 31-Jan Unearned Revenue Service Revenue (Unearned Service has been performed during month) 11 31-Jan Interest Expense Interest Payable (One month interest accrued on Note Payable) 15 6580 31-Jan Accounts Receivable Service Revenue (Additional work performed but not billed yet) 6580 9501 1931-Jan Rent Expense Prepaid Rent 21 One month prepaid rent has been used) 950 23 31-Jan Depreciation Expense Depreciation Expense. Comp Equip no IE ADJUSTINE JE CLOSING JE Worksheet statements Worksheet G Home Insert Page Layout Formulas Dald Review X Cut Times New Ro - 12 AA == > PWrap Text Copy Format Painter BTU 9.A. EE37 M erge & Center - Clipboard Alignment - X fr Font LCD (One month interest accrued on Note Payable) 6580 31-Jan Accounts Receivable Service Revenue (Additional work performed but not billed yet) 6580 31-Jan 950 Rent Expense Prepaid Rent (One month prepaid rent has been used) 950 1 S- 23 31-Jan Depreciation Expense Depreciation Expense, Comp Equip Depreciation Expense, Office Furniture (Depreciation changed on Assets) 165 190 31-Jan Salaries Expense Salaries Payable (Salaries not paid yet) 4650 4650 E ADJUSTING JE CLOSING JE Worksheet statements