AutoSave on W H2 Financial Accounting Project 1 - Student Input Form revised 5.21.21 - Lane M. Coulter LM 1 File Home Insert Draw Page Layout Formulas Data Review View Help Comments Share X X y C Arial 12 ~ A PA ap General Insert Delete 28 Paste BIU Sensitivity CA O A $ % 5829 El Format Conditional Format as Cell Formatting Table Styles Styles Sort & Find & Filter Select Analyze Data Clipboard Font Alignment Number Cels Editing Analysis Sensitivity A1 - H ] K L M N o P P Q s u W Y Income Stalemen! Dell Credi Balance Sheet Debil Credit B C F F 3 For year ended June 30, 20X2 5 Trial Bank Adjustments n. Trial Balance 7 7 DetailCredit Debil Credil Debt Credil lash 15 000.00 Accounts Receivable 11 900 00 10 Inventory 20.000.00 11 Estimated Retums Inventory 1,500.00 12 Store Supplies 900.00 13 Prepaid insurance 1.250.CO 14 store Equipment 23 000 CO IS Accum. Depreciation 2 300.00 16 Accounts Payable 530000 17 Salaries Payable 500 00 10 Customer Refunds Payablo 6.650.00 19 Unearned Rent 12.000.00 20 Common Stock 40.000.00 21 Relaine Lamnings 6.000.00 22 Dnidends 1,200.00 23 Sales 19 000.00 24 Rent Revenue 25 Cost of Goods Sold 7.500 CO 20 Office Salaries Expense 3.000.00 z? Sales salaries Expense 2.200.00 2 Store Supplies Expense 29 Rent Expense 2.200.00 30 Dep. Exp. Soup 700.00 31 Insurance Experse 300 00 Interest Exner 1.000.00 33 M. Boling Expense 1,500.00 34 Misc. Admin Expense 1,600.CO 35 * Total 91.750 00 4.750 00 37 Nel Income Journal Entries Worksheet and Financials Ready Accessibility: Investigate 200000 E lai 60% HE Type here to search O . 99% 65F A D 3:41 PM 4/9/2022 5 AutoSave On H2 on W Financial Accounting Project 1 - Student Input Form revised 5.21.21 - Lane M. Coulter LM 1 File Home Insert Draw Page Layout Formulas Data Review View Help Comments Share X X C Arial 12 - A PA ap General Insert Delete 28 0 Analyze Data Paste Sensitivity BI UB O A A $ % 898 El Format Conditional Format as Cell Formatting Table Styles Styles Sort & Find & Filter Select Clipboard Font Alignment Number Cels Editing Analysis Sensitivity A1 F H ] K M N o P P Q s u W Y points) B C (17 points - 13 points for including correct accounts, 4 points for multistep format) 6 47 Baxter Company 49 Multistep Income Statement 19 For year ended June 30, 20X2 50 Baxter Company Statement of Stockholders' Equity For year ended June 30, 20X2 Total Common Stock Retained Earnings Ralances My 1 21X1 51 5 53 14 33 56 se 50 There were no additional shares of common stock issued during the year 61 | Rea 12 63 C4 67 hil ny TU 71 72 73 74 75 76 + 1 al 60% Journal Entries Worksheet and Financials Ready Accessibility: Investigate HE Type here to search O . 99% 65F A D 3:41 PM 4/9/2022 5 AutoSave on W H2 Financial Accounting Project 1 - Student Input Form revised 5.21.21 - Lane M. Coulter LM 1 File Home Insert Draw Page Layout Formulas Data Review View Help Comments Share X X C Arial 12 - A ap General Insert Delete 28 0 Analyze Data Paste Sensitivity BIU A. $ % 978-98 El Format Conditional Format as Cell Formatting Table Styles Styles Sort & Find & Filter Select Clipboard Font Alignment Number Cels Editing Analysis Sensitivity A1 - A E F ] K M N o P P Q s u W w Y (17 points - 14 points for including correct accounts, 3 for format) B C Baxter Company Balance Sheet June 30, 20X2 79 80 81 82 13 01 Assets De sure to prepares CASSIF bis recher 50 87 88 89 00 91 2 93 04 05 Total Assets 96 97 Liabilties 99 99 491 02 0 Total Liabudies o stockholders' Equity 06 02 06 Total Stockholders' Equity 00 Total Labtes and Stockhaders' Equity 110 111 Journal Entries Ready * Accessibility: Investigate Worksheet and Financials 1 (a 60% HE Type here to search O . 99% 65F D B ICE 3:41 PM 4/9/2022 5 Financial Accounting Project 1 Chapters 1-5 (Problem and Data) 100 points Part 2 Complete the Worksheet Use the following data for adjustments, complete the rest of worksheet (columns 3-10). (Hint it might help to journalize the adjustments first.) Be sure to complete the entire worksheet showing totals and net income. Check Answer: Adjusted Trial Balance = 22 points 97,150.00 Adjustments: 1. Sales earned but not billed yet $ 2000 2. Additional $ 250 in sales salaries has been accrued, but not yet recorded 3. Depreciation expense on the store equipment for the month is $150 4. Insurance expired for the month is $60 5. Store Supplies on hand at end of the month is $50 6. $250 of the unearned rent has now been earned 7. Physical count of merchandise inventory on June 30 is $19900 Part 3 - Complete the Financial Statements 1) The Multistep Income Statement 2) Statement of Stockholders' Equity 3) Balance Sheet (showing current and long term) Check Answers Cash Account Balance = 15,000.00 Total Assets = 72,090.00 17 points 7 points 17 points Page 4 of 4
