Do the following by looking at Transactions, (Supplies bought on the account is $600 and paid for that was 700 but I guess should be balanced in the end).

1. Journal Entries

2. Ledger Balances ( T accounts)

3. Trial Balance

4. Adjust Entries

5. Adjusted Ledger Balances

6. Adjusted Trial Balances

7. Financial statements (Retained Earnings, Income Statements, Balance Sheet).

Aura Accounting Cycle Excel Project - Version 3 HK - Excel Sign in Page Layout Formula Data REICH View Hep Share Comments Calibri Auringum II WA = = = Guneral Goud Bad Neutral Fle Home Insert X Cut Copy Paste 3 format Panter Cipherd Wap Test 45 Merge & Cartier F Normal Condone format Calculation Furmaling talu 47 Sort & linda File - S BTW- 5 - % 912 0-A- Check Cell Insert Delme met Explanatory... put ON Anstre Dalal Clear Font Alignment Number deng Salus B14 f Nighthawk Services pays employees $3,000 in salaries c . D E G H 1 ] L M N P G- Nighthawk Services was incorporated in the state of VA. The company will provide management consulting services to business and 1 1-Jan governmental clients 2 2-Jan Tom M. contributed $275,000 of personal funds to the business in exchange for shares of common stock 3 3-Jan Nighthawk Services signed a contract to provide consulting services for $100.000 to ABC diant 4 4-Jan Nighthawk Services received $100,000 from ABC for work to be performed half in January and half in February 5 5-Jan Nighthawk Services boughts of office supplies on wount 6 6-Jan Nighthawk Services bought $50,000 of office equipment using cash 7 7-Jan Nighthawk Services hired 2 consultants B-Jan Nighthawk Services purchased a 12 month insurance contract for $12,000 9 9. Jan Nighthawk Services paid $1750 cash for rental at office space for January 10 10 Jan Nighthawk Services paid $10 on account for advertising during January 11 11-Jan Nighthawk Services was paid $10,750 from Ted Corp to perform services during January 12 12-Jan Nighthawk Services purchased $450 of supplies using cash Nighthawk Services signed a contract to provide consulting services for $54,000 to DMV client. Services to be provided equally over the next 13 13-Jan 12 months beginning in the month of Janusry, Client will be billed at end of each month. 14 14.Jan Nighthawk Services pays employees $3,000 in salarios 13 15-Jan Nighthawk Services borrowed $450,000 on a 5% note payable. . 16 16-Jan Nighthawk Services purchased and for $300,000st with plans to build an office building within the next year 17 17-Jan Nighthawk Services paid $2000 cash tar repairs and maintenace to equipment 18 20-Jan Nighthawk Services loans $24,000 to Corp cn a 10% (interest) not receivable 19 21-Jan Nighthawk Services pays employees $3,000 in salaries 22-Jan Nighthawk Services gets paid $12,850 for services performed to Vector Corp 21 23 Jan Nighthawk Services purchases $150,000 in stock investments 22 26-Jan Nighthawk Services gets a $8375 bill for utilities used in January 23 25. Jan Nighthawk Services pays $1750 in ottice rent for month of February 26 Jan Nighthawk Services pays $70,000 in dividends 27-Jan Nighthawk Services pays $400 cash to attends event to promote business at a convention in Janusry 28-Jan Nighthawk Services pays $490 cash tortaxes 27 29 Jan Nighthawk Services pays employees $3,000 in salaries 30-Jan Nighthawk Services paid for $700 office supplies previously purchased on account 31-Jan Nighthawk Services has to prepare financial statements for the owner and the bank from which the funds were borrowed. 30 January Month End Adjustments 31 31-Jan Nighthawk Services cakulale $550 in depreciation 31-Jan Nighthawk Services owes January interest on the loan 31 Jan Nighthawk Services counted Sooo in remaining supplies (on hand supplies 34 31-Jan Nighlik Services owes employees $1.500 in salaries for work performed in January 35 Are there any other counts that and adjusting?!! 20 Adjusted Trial Balance Financial Statements Financial Statement Analysis Ready 29 Aura PH Accounting Cycle Excel Project - Version 3 H-K - Excel Sign in Fle Home Insert Page Layout Formula: Data REICH View Hep Share Comments 11AA Auringum Caibi Guneral Bad @ X Cut Copy 3 Format Panter = = = Wrap Test === & * Marge Cantar- F | Goud Neutral Exploratory input Normal Condone format Calculation Furmaliny - to 47 0 Sort Find & File - S BI- 5 % 913 Check Cell Insert Dele omst ON Anste Dalai Clear Clipboard Fant Alignment Number Eden Salus DZ A B C - G G H J K L M N 0 P O R 5 T w w Debit Credit Debited Amount Credited Amount 1 21 3 4 5 3 6 7 7 9 10 11 12 13 14 15 16 17 18 19 20 22 23 24 26 27 28 29 30 31 33 34 35 36 37 28 Transactions Journal Entries Ledger Balonces Trial Balance Adjusting Entries Adjusted Ledger Balances Adjustec Trial Balance Financial Statements Financial Statement Analysis Ready 100% Aura Accounting Cycle Excel Project - Version 3 H-K - Excel Search Sign in Fle Home Insert Page Layout Formula Data REICH View Hep Share Comments Calibri 11 AA Guneral Bad Goud Neutral Paste X Cut Copy 3 rammet anter Clipboard = = = 2 Wrap Test === & 45 E Merge Cartier Alq BTW- -A Normal Condona Tomates Calculation Fumetting Table ON Anshine 5 - % 912 Check Cell Exploratory...nput Auringum 47 0 F Sort find Clear File - Sci- de ng Insert Delene Format Fant Nunc Salus D30 Io C E F . L L 0 V B Debit M Debit N Credit S Debit R Account 1 Account Balance Credit Account U Balance Debit Credit Balance Balance Account Credit Debit Credit Balance Debit Credit Balance Debit Credit Balance Men Debit Credit Balance Account Account Debit Gel Balance Debil Credit Balance Debit Credit Dalam Account Debit Credit Balance 2 3 4 5 Account 6 7 7 8 9 9 Account 10 11 12 13 Account 14 15 16 17 Account 10 19 20 Account Account Debit Credit Balance Debit Credit Balance Account Debit Credit Balance Autant Debit Credit Balance Debit Credit Balance Account Debat Credit Balance 22 Account Debit Credit Balance Account 24 25 20 Account 271 28 Debit Credit Balance Debit Credit Balance Account Debat Credit Balance Debit Credit Balance 20 31 Account 22 30 34 Account 36 37 Transactions Journal Entries Ledger Balances Trial Balance Adjusting Entries Adjusted Ledger Balances Adjustec Trial Balance Financial Statements Financial Statement Analysis Ready 100% Audi DP Accounting Cycle Excel Project - Version 3 H-K - Excel Sign in Fle Home Insert Page Layout Formula Data REICH View Hep Share Comments Auringum Calibri = = = II AA Guneral Bad X Cut Copy 3 Format Panter 27 O Wrap Test 45 E Merge Cartier Goud Neutral Explanatory... put ON F -A Normal Condon Format Calculation Fumetting Title BIU- === 5 % Check Cell leert De Form Sortid File - Susi Anstyte Clear Clipboard Fant Alq Nunc Nu Eden Jalus A D E G H H. J K L M N 0 P O R 5 T v w Y B Debit Credit 1 Account 2 3 4 5 7 7 9 10 11 12 13 14 15 16 17 18 19 20 211 22 241 20 27 28 29 30 31 22 32 34 30 37 39 Transactions Journal Entries Ledger Balance Trial Balance Adjusting Entries Adjusted Ledger Balances Adjusted Trial Balance Financial Statements Financial Statement Analysis Ready 100%