Home Insert Page Layout Fermulas Data Review Help Search PROTECTED VIEW Bewees from the Internet can contain vies. Unless you need to edit, its sales to stay in Protected View Enable Editing 165 A B D E G 6 7 8 9 10 Income Statement for year 2011 230,000 2010 200,000 Net Sales Revenue (al Credit Sales) Cost of Goods Sok 165,000 150 000 Gross Profit 65,000 50,000 Salaries & admin Expense Depreciation Expense Income before Tax 9,500 14,500 41,000 10.000 14.000 26.000 Tax expense 11,000 5,000 Net Income Shares Outstanding Stock Price 30,000 120,000 16.00 21000 120,000 12 00 $ $ 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 2010 Balance sheet year end 2011 Current Assets Cash 33,000 Accounts Receivables, net (2009 ending 20,000) 33 000 Inventory (2009 ending 25,000) 27000 Total Current Assets 93,000 20,000 14,000 20.000 54,000 Property Plant & Equipment Accumulated depreciation 60,000 (29,000) 78,000 (24.000) Total Assets 124,000 108,000 35 36 37 30 39 Accounts Payable Income Tax Payable Total Current Liabilities Bonds Payable Total Liabilities 29,000 7,000 36,000 27,000 63,000 15,000 8,000 23,000 33 000 56.000 41 42 43 45 46 Common Stock Retained Earnings Total Liabilities and Shareholders Equity 18,000 43,000 124,000 14,000 38.000 108,000 47 48 Find 2011 2010 49 50 1 Current Ratio 2 Debt Ratio 51 52 53 3 Accounts Receivable Turnover 55 4 Quick ratio (Acid Test) 57 58 5 Earning per share (ignore Dividends) 59 6 Price Earnings Ratio Sheet PROTECTED VIEW Be carefules from the Internet can contain viruses. Unless you need to edit, it's safe to stay in Protected View Enable Editing 365 C D 61 7 Inventory Turnover 62 63 8 Do a Horizontal Analysis of the Balance sheet above difference and % do it right next to the balance sheet 54 9 Do a Vertical analysis of the Income Statement above do it right next to the income statement 2011 2010 65 ADDI NONAL INFORMATION 66 Dividends declared and paid 25000 67 Equipment was sold for 8,500, it was bought for 18,000 and had a book value of 8,500 when sold 68 All sales are credit sales 69 70 10 In the space below, create the Cash Flow Statement for 2011 71 72 73 74 T5 76 77 78 79 80 31 B2 83 84 85 86 87 88 89 90 91 92 93 94 95 You are the accountant for Security Software. The month just ended 1/31/2002 96 Create journal entries for the following 97 98 11. During the month software sales were 50,000, al on account, and sales tax is 8.5% 99 in addition to that amount Describe the above with a journal entry 100 101 Account Debit Credit 102 103 104 106 106 12 On Feb 15th you send this sales tax from number 11 to the state. Make the Journal 107 106 Account Debut Credit 109 110 112 113 13. Customers also were invoiced $12,000 for 1 year maintenance contracts Describe the 114 transaction there is no sales tax on this) 116 Account Debit Credit Home Page Layout formulas Data View Help O PROTECTED VIEW Beetle from the were can come you need to stay > C D 30 G 90 * You are the accountant for Security Software. The month just ended 1/31/2002 55 Create journal entries for the following 97 9 11. During the month software sales were 50,000, all on account and sales taxis 85% 99 in addition to that amount Describe the above with a journal entry 100 101 Account Debit Credit 102 103 104 105 106 12 On Feb 15th you send this sales tax from number 11 to the state. Make the Journal 107 108 Account Debit Credit 109 110 111 112 113 13 Customers also were invoiced $12,000 for 1 year maintenance contracts Describe the 114 transaction there is no sales tax on this) 115 116 Account Dobit Credit 117 118 119 120 121 14 The month's payroll paid on 1/31 needs to be recorded Total payrol is $20,000 122 4,000 is withheld for federal taxes, 1,000 for state taxes, and 7 65% is withheld for FICA tax Account Debit Credit 125 126 128 129 130 131 132.15. On 10/31/2011 The company takes out a $120,000 bank loan and signs a 4 year note at 8% interest 130 paid every 3 months Make Journals for the following 134 a. 10/31/2011 - record the loan b. 12/31/2011 year end needs to have everything accurate including interest Rabaties 136 c 1/31/2012 it has been 3 months 137 138 Date Account Debat Credit 140 142 143 144 145 1.41 Given the following Thai Balance for Year Ended 2019 Trialane PROTECTID VIIW Be careful-files from the Internet can contain viruses. Unless you need to edit, ' se to stay in Protected View C D F H Given the following Trial Balance for Year Ended 2019 143 149 150 151 152 153 154 155 156 Trial Balance Debil Credit 27,000 00 5,000.00 2,000.00 1,500 00 8,500.00 2,000.00 10,000.00 15 159 160 151 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 Cash Accounts Receivable Prepaid Insurance Inventory Computer Eauipment Accumulated Depreciation Long term investments Accounts Payable Salary Payable Uneamed Revenue Long term Loan Payable Common stock Retained earnings (beginning) Dividends Sales/Revenue Cost of Goods Sold Salary Expense Advertising Expense Insurance Expense Depreciation Expense Totals 17,500.00 1,150.00 1,000.00 2,000.00 17,500.00 11.250 00 3,200.00 9,00000 1,000.00 1,500 00 1,000.00 400.00 300.00 61.400.00 61,400.00 16 Create the Mutti step Income Satement below 178 179 180 181 12 18 184 185 186 187 188 189 190 191 192 193 194 196 197 190 199 200 201 202 204 205 205 Type here to search 34 05 06 07 17 Create the Statement of Retained Earnings 99 70 12 13 14 15 16 17 18 19 20 21 22 23 24 25 226 27 28 229 230 18 Create the Classified Balance Sheet 232 233 234 235 235 237 238 239 240 242 243 244 245 246 247 248 250 252 253 254 255 256 257 258 259 260 261 263 Sheet1 Sheet