12 A A Times New Roman BCopy Paste Wrap Text Number A BIU Format Painter Merge & Center S-% 8 Conditiona Formatting Clipboard Font Alignment Number P69 B C 1 COBU 201 M Fall 2019 Assessment Case P 3 INSTRUCTIONS: 4 This project is to be worked individually. The submission must be typed and submitted in THIS Excel file. Prepare the submission as if you are interested in this company and looking to use the company's financial 5 6 7 statements to make some decisions. Show and label all work for the problems. 8 10 VSU Accounting, Inc. General Ledger 11 12 13 Cash (11) Accounts Receivable (12) Accounts Payable (21) 14 Bal. 26,000 Common Stock (31) Bal. 27,000 52,000 Bal. 56,000 15 Bal. 16 17 26,000 18 27,000 52,000 56,000 19 20 Prepaid Insurance (15) 11,000 Office Supplies (14) 25,000 Wages Payable (22) Retained Earnings (33) 21 Bal. 22 23 Bal. Bal 55,500 Bal 24 25 11,000 25,000 55,500 26 Accumulated Depreciation- Equipment (17) Equipment (16) 144,000 27 Dividends (32) 28 Bal. 35,000 29,000 Bal. Bal 29 30 31 32 33 144,000 35,000 29,000 Accumulated Depreciation- Sheet Select destination and press ENTER or choose Paste O e Alignment Clipboard Font Number P69 Pl A B E F K M N Q R T 11,000 25,000 0 25 55,500 26 Accumulated Depreciation - Equipment (17) 35,000 Equipment (16) 144,000 Dividends (32) 29,000 27 28 Bal. Bal. Bal. 29 30 311 144,000 29,000 32 35,000 33 Accumulated Depreciation - Trucks (19) 38,000 Service Revenue (41) 198,000 Trucks (18) 79,000 Wages Expense 51,000 34 Bal 35 Bal Bal. Bal. 36 37 38 $1,000 198,000 79,000 38,000 40 Depreciation Expense- Trucks (54) Depreciation Expease Fquipment (53) 41 Rent Expense (57) 17,000 Supplies Expense (51) Bal 42 Bal. 43 Bal 44 45 46 47 17,000 48 Miscellaneous Expense (58) 13,000 Iasurance Expense (52) Bal Truck Expense (56) 12,500 49 Bal. 50 Bal 51 52 53 13,000 12,500 54 55 E 55 56 57 The unadjusted balances in VSU Accounting, Inc. accounts as of December 31st, 2018 are shown in the General Ledger above. 58 Additional information: 59 60 The data needed to determine year-end adjustments are as follows: a) Supplies on hand at December 31, 2018 are: b) Insurance premiums expired during 2018 are Depreciation of equipment during 2018 is: d) Depreciation of trucks during 2018 is: e) Wages accrued but not paid at December 31, 2018 are: 61 5,700 62 5,900 63 11,100 64 9,200 7,900 65 66 67 Tasks: 1)Use the additional information provided at year-end to record the adjusting entries and post them into ithe ledger accounts to calculate the new year-end balances. 68 69 70 71 2) Prepare the Adjusted Trial Balance. Fill out lines with Account Names and fill in boxes with Dollar Numbers. 72 73 74 Adjusted Trial Balance Unadjusted Bal 75 Adjustments Adjusted Bal. Dr. Cr. 78 Dr. Cr. Dr. Cr. Cash Accounts Receivable Office supplies Prepaid Insurance Equipment Accumulated Depreciation - Equipment 77 26,000 27,000 78 79 25,000 80 11,000 144,000 81 82 35,000 83 Trucks Accumulated Depreciation - Trucks Accounts Payable Wages Payable Common Stock Dividends 79,000 84 38,000 85 52,000 86 87 56,000 88 29,000 Ratsinad Earninas 5520n NM S70 P K J D E F C A B 29,000 Dividends Retained Earnings Service Revenue Supplies Expense Insurance Expense Depreciation Expense - Equipment Depreciation Expense- Trucks Wages Expense Truck Expense Rent Expense Miscellaneous Expense Totals 88 55,500 198,000 89 30 91 92 93 94 51,000 12,500 17,000 13,000 434,500 434,500 95 36 97 98 99 100 101 3) Use the updated general ledger balances to prepare the following 2018 financial statements for VSU Accounting, Inc. [in proper order]: Fill out lines with Account Names and fill in boxes with Dollar Numbers. 102 103 104 105 106 107 108 109 a) Income Statement Income Statement VSU Accounting, Inc. For The Year Ended 12/31/2018 110 111 112 113 114 115 116 117 118 19 120 121 122 Sheet1 8 [ Copy $ Paste Format Painter |nA- EMerge & Center E BIU Alignment Font Clipboard 70 fe M N K L G D E A C b) Statement of Retained Earnings Statement Of Retained Earnings VSU Accounting, Inc. 1 2 For The Year Ended 12/31/2018 4 5 7 88 9 40 41 42 c) Balance sheet 43 44 45 Balance Sheet VSU Accounting, Inc. 46 As Of 12/31/2018 47 48 ASSETS 49 50 151 152 153 154 155 156 157 158 159 160 161 Sheet1 L2 O I U A Format Painter EE Merge & Center $% 8 Conditional Formatting pboard Font Alignment Number C D E G H K P 4) Use the information on the financial statements to answer the following questions: a) Was VSU Accounting, Inc. profitable in 20187 From a management persepctive, what are your thoughts about the company's financial perfromance? b) Has the stockholders' equity grown? How does stockholder's equity grow, and is this good for the business? e) If looking for a loan, can VSU Accounting, Inc. expect to get the loan? Give your reasons for your response. [Hint: Caleulate some appropriate ratios, such as Current ratio, Cash Ratio, Quick ratio, Return on Assets, and Working Capital. These ratio may help.] Current Ratio Answer Quick Ratio Answer 12 A B D E F G K L M N S Quick Ratio Answer Cash Ratio Answer Working Capital Answer Return on Assets Answer d) If you are looking for an investment opportunity, would you invest in VSU Accounting, Inc.? What specifically about the company is appealing? teTSTT eauntina Ine actahlichee annther hranch.nf the hueinare in Pansma Ci Panam ha Sheet1 t destination and press ENTER or choose Paste