Parts 1 and 2 are complete. I need to know how to figure out how to answer part 3 in the green. If you can please help me out.
AutoSave C - Shawn Mann Project 1 Part 2 - Compatibility Mode O Search Shawn Mann SM File Home Insert Draw Page Layout Formulas Data Review View Help Share Comments AutoSum Times New Roman 12 ~ A A 82 Wrap Text Custom 27 05 ME Brill Paste X Out [Copy Format Painter Cipboard BIU Insert Delete format Ideas Sensitivity H Merge Center Clear Conditional format as Cell Formatting Table Styles Styles Sort & Find & Filter Select Edting Font Alignment Number Cels deas Sensitivity C31 3790 A B D E F G - 7 Submission 1 - due Thursday May 14 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 8 9 Submission 2 - due Thursday May 21 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 10 11 Submission 3 - due Thursday May 28 before 3pm - 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 12 13 14 PARTIAL CREDIT FOR LATE SUBMISSION OF PARTS 1 AND 2 info JE ADJUSTING JE CLOSING JE Worksheet statements worksheet formulas financial statement formu... Ready 730% Type here to search o e * ? (9) 1:54 PM 5/24/2020 P 21 AutoSave Ce CH Shawn Mann Project 1 Part 2 Compatibility Mode O Search Shawn Mann SM File Home Insert Draw Page Layout Formulas Data Review View Help Share Comments AutoSum X Cut [Copy Times New Roman 12 ~ A A === 82 Wrap Text Custom 47 0 4 NE rill Peste Id BIU Sensitivity Insert Delete Format H Merge & Center Format Painter Clear Conditional Format as Cell Formatting Table Styles Styles Sort & Tind Filter Select Eding Clipboard Font Alignment Numer Cels deas Sensity C31 3790 D C G J K M N 0 P R STE Amount Amount 11.040 9,580 25 26 During January, the first month of operations, the following transactions occurred: 27 Date Event za 2-Jan Paid for 12 months rent on office space 5-Jan Purchased oflice furniture Borrowed cash from the bank for operating expenses. The note charges simple interest and is to be 5-Jan paid back in 5 years 11-Jan Performed services for various customers for cash and on account 22 19 Jan Paid salaries to employees for 1 week 32 20-Jani Received cash in advance from Stanley Inc. for work to be performed over the next 12 months. 34 22-Jan Purchased additional office supplies on account. 28-Jan Collected payments for amounts previously billed 36 29 Jan Paid for utilities. 37 29-Jati Paid the bill for supplies purchased previously. 3 31-Jan Dividends were declared and paid 0.01 interest rate on account 31 30,000 loan amt 10.650 cash 5,865 7.800 3,790 13.500 1.988 4,650 1,500 25 40 At the end of January, the following additional information is available to help determine 41 what adjustments are needed: Amount Amount 42 43 31 Jani One month of interest has accrued on the note payable for the bank loan. 44 31-Jan Additional work for customers has been performed during the last week of January but not billed yet 6985 45 91-Jan Supplies were counted at month end 2560 46 31-Jan One month of the prepaid rent has been used up 47 31-Jati Depreciation expense teeds to be recogized for the computer equipment and for the office 165 comp equip 95 of furn 48 31-Jan One month of the services for Stanley Inc. has been performed (see above). 49 31-Jan Salaries are paidi enery Friday (for a 5 day work week). January 31, 2019 was a Thursday 5,865 weekly 50 51 You are encouraged to get help from the tutors in the Accounting Lab. You can also get help by email. You can email your professor and you can email the accounting lab (accountinelab@wave.edu). If you email both please do so in the same email. Replies will be 2 info JE ADJUSTING JE CLOSING JE Worksheet statements worksheet formulas financial statement formu... Ready U 55 Type here to search O e * ? 1:54 PM 5/24/2020 F 22 AutoSave C - Shawn Mann Project 1 Part 2 Compatibility Mode O Search Shawn Mann SM File Home Insert Draw Page Layout Formulas Data Review View Help Share Comments AutoSum Times New Roman 12 ~ A A === 89 Wrap Text General AY O 4 ME Brill Peste X Cut [Copy Format Painter Clipboard Insert Delete format Id Sensitivity BIU H Merge & Center $ -% -8 Conditional Format as Cell Formatting Table Styles Styles Clear Sort & Tind Filter Select Eding Font Alignment Number Cels deas Senstvity C4 G H j K L M N O R S T CREDIT 11040 9580 30000 28510 A 1 JOURNAL ENTRIES - Matar Consulting in 2 DATE ACCOUNT DEBIT 3 1/2/2020 Prepaid Rent 11010 4. Cash 5 1/5/2020 Office Furniture 9580 6 Cash 7 1/5/2020 Cash 30000 Long Term Notes Puyable 9 ### Cash 10650 10 Accounts Receivable 17860 11 Service Revenue 12 Salaries Expense 5865 13 Cash 14 WWW Cash 7800 15 Uncarned Revente 16 # Supplies 3790 11 Accounts Payable 18 #Cash 13500 19 Accounts Receivable 20 * Utilities Tapense 1986 Cash 22 ** Accounts Payable 4650 Cash 24 # Dividends 1500 Cash 5865 7800 3790 13500 21 1986 4650 1500 26 27 info JE ADJUSTING JE CLOSING JE Worksheet statements worksheet formulas financial statement formu ... Ready 845 Type here to search O e * ? A 1:54 PM 5/24/2020 F 22 AutoSave C - Shawn Mann Project 1 Part 2 Compatibility Mode O Search Shawn Mann SM File Home Insert Draw Page Layout Formulas Data Review View Help Share Comments AutoSum Times New Roman 12 ~ A A 82 Wrap Text General 27 NE HEX Insert Delete Format 4 Brill X Cut [Copy Format Painter Clipboard Peste Ideas $ % -8 Sensitivity BIU Merge Center Conditional Format as Cell Formatting Table Styles Clear Sort & Tind Filter Sclect Font Alignment Number Styles Cels Eding deas Sensitity C7 -Worksheet!F6-info.C45 E F J L M N o P 1 2 0 A D ADJUSTING JOURNAL ENTRIES - AugFig Consulting Inc DATE ACCOUNT DEBIT CREDIT 1/31/2020 Interest Expense 25 Interest Payable 25 1/31/2020 Accounts Receivable 6985 8 Service Revenue 6985 7 1/31/2020 Supplies Expense 9880 Supplies 9880 1/31/2020 Rent Expense 920 10 Prepaid Rent 920 11 1/31/2020 Depreciation Expenscc. Comp Equip 165 12 Depreciation Expensec. Office Furniture 95 13 Accumulated Depreciation, Comp Equip 165 14 Accumulated Depreciation, Offic Furniture 95 15 1/31/2020 Uneared Revenue 650 . 16 Service Revenue 650 17 1/31/2020 Salaries Expense 4692 Salaries Payable 4692 19 20 21 21 22 23 10 Screenshot saved The screenshot was added to your OneDrive. info JE ADJUSTING JE CLOSING JE Worksheet statements worksheet formulas | financial statement formu... a Heady Type here to search O * 1:54 PM 5/24/2020 22
