Hello, I am finish working on my worksheet for Sound Bytes Electronics and I need help with the Income Statement, Statement of Changes in Owner’s Equity and a Balance Sheet. I was wondering if you could help me?
This is the worksheet that I did:
Income statement | ||||||||
$ | $ | |||||||
Net sales | (Note:1) | 77336 | ||||||
Less: Net cost of goods sold | (Note:2) | 39094.57 | ||||||
Gross profit | 38241.43 | |||||||
Less: Expenses | ||||||||
Rent expense | 6000 | |||||||
Store salaries expense | 3762 | |||||||
Store supplies expense | 598 | |||||||
Insurance expense | 600 | |||||||
Hydro and water expense | 1186 | |||||||
Depreciation Exp. Store equip | 1558 | |||||||
Advertising expense | 4040 | |||||||
Miscellaneous/Other expense | 195 | |||||||
Bank charges/Interest expense | 272 | |||||||
Bookkeeping expense | 400 | |||||||
Total expenses | 18611 | |||||||
Net income | 19630.43 | |||||||
Note:1 | ||||||||
$ | $ | |||||||
Sales-Electronic devices | 33795 | |||||||
Sales-Music CDs | 24901 | |||||||
Sales-Movies | 19850 | |||||||
Sales-Other | 1005 | |||||||
Total sales | 79551 | |||||||
Less: | ||||||||
Sales-returns | 840 | |||||||
Sales-Discounts | 1375 | 2215 | ||||||
Net sales | 77336 | |||||||
Note:2 | ||||||||
$ | ||||||||
Cost of goods sold | 39900.57 | |||||||
Less: Purchase-Discounts | 806 | |||||||
Net cost of goods sold | 39094.57 | |||||||
Statement of changes in owner's equity | ||||||||
$ | ||||||||
Capital John stammers,Beginning balance | 6938 | |||||||
Add: Net income | 19630.43 | |||||||
26568.43 | ||||||||
Less: Drawings | 3231 | |||||||
Capital John stammers,Ending balance | 23337.43 | |||||||
Balance sheet | ||||||||
$ | $ | $ | ||||||
Assets | ||||||||
Current assets: | ||||||||
Bank account chequing | 4071.2 | |||||||
Accounts receivable | 1708 | |||||||
Merchandise inventory | 12969.43 | |||||||
Store supplies on hand | 354 | |||||||
Prepaid insurance | 300 | |||||||
HST on purc/Serv | 1157 | |||||||
Less:HST on sales | 226.2 | |||||||
HST Refundable | 930.8 | |||||||
Total current assets | 20333.43 | |||||||
Property,plant and equipment (net) | ||||||||
Store equipment | 29500 | |||||||
Less: Accum Deprec Store equipment | 17758 | |||||||
Store equipment (net) | 11742 | |||||||
Total assets | 32075.43 | |||||||
Liabilities and owner's equity | ||||||||
Current liabilities: | ||||||||
Accounts payable | 1808 | |||||||
Accrued payable | 330 | |||||||
Total current liabilities | 2138 | |||||||
Long-term liabilities: | ||||||||
Bank loan payable | 6600 | |||||||
Total liabilities | A | 8738 | ||||||
Owner's equity: | ||||||||
Capital John stammers | B | 23337.43 | ||||||
Total liabilities and owner's equity | A+B | 32075.43 |
Hello, I am finish working on my worksheet for Sound Bytes Electronics and I need help...
Hello and good evening, I finish doing my worksheet and I need help making a income statement, balance sheet and statement of changes in owner’s equity. Would you be able to help me? You can download the ice Spreadsheet Ws 2018 Apr Perpetual from www.nelson.com/student to complete the worksheet Sound Bytes Blectronics Worksheet for 4 months ending April 30, 2018 Adjustments Debit Trial Balance Debit 114.964900 1,017.00 7,475.00 1.045.20 600.00 628.00 354.00 600.00 29,500.00 17,100.00 1,695.00 0.00 1,387.00 841 001...
Hello, I need help making an accounting "worksheet" with these entries. If you'd like to update the journal entries it's fine. But, please help me on finishing the worksheet? Thank you. ACC 111 Project 1B The adjustment data as of September 30, 2016, the end of the fiscal year, for Diaz Company were as follows: a. Merchandise Inventory taken on September 30 was $65,800. b. The depreciation on the Delivery Truck for the month amounted to $700. C. The depreciation...
Financial Accounting Help With Project! Hello, I am having some trouble with the first page of my homework for my financial accounting class. I am having some trouble analyzing the differences between LIFO and FIFO in this specific question and how exactly I begin and end the question. Any help on this problem so I can refresh my memory after being gone over spring break would absolutely help a ton, especially considering I have another 4 pages of this stuff...
need help with this finding the answer and I have to plug in a formula with excel to get the answer thanks to anyone who helps I posted this but the other user didnt give me a good formula that works to get the answer thanks Name Liban Ahmed Your score The trial balance of the Liban Ahmed Company as of December 31, 2019 is presented below. Prepare a multiple step income statement for the year ended (date of) December...
I need help making the single step income statement for fiscal year 2018 and I also need help coming help with the multiple step income please. NELSON COMPANY Unadjusted Trial Balance January 31, 2018 Debit Credit $ 7,650 14,e00 5, 300 2,400 43,000 Cash Merchandise inventory Store supplies Prepaid insurance Store equipment Accumulated depreciation-Store equipment Accounts payable Common stock Retained earnings Dividends Sales Sales discounts Sales returns and allowances Cost of goods sold Depreciation expense-Store equipment Salaries expense Insurance expense...
I need help with this worksheet, I mostly with the I/S and B/S. Have I done it right so far? I also need to generate an Income statement, statement of retained earnings, Ballance sheet, and closing entries with this information. Any help would be appreciated! Account Title Cash Accounts Receivable Allowance for Doubtful Accounts Interest Receivable Note Receivable Merchandise Inventory Prepaid Insurance Prepaid Rent Supplies Fauipment Accumulated Depreciation - Equipment Accounts Payable Salaries & Wages Payable Unearned Revenue Interest Pavable...
Pretty sure I've got this but I would love to have something to cross check against. Thanks! Required Prepare a clasified balance sheet for Babylon Lighting of December 31, 20 اللعنه 27300 too The following adjusted trial balance was taken from the worksheet of Babylon Lighting. Prim u s Ton Tongan, hade hon intuits during the year Babylon Lighting Adjusted Trial Balance December 31, 20.. Debit Acces Receivable Merchandise Store Supplies Ofte Supplies Prepaid Insurance Store Equipment Aerulind Depreciation Store...
please if someone can help me out with this I would be very grateful I am not so good with excel and need this extra credit to pass the class thank you so much to anyone who helps Click on the "Multi-Step" tab and enter your name in Cell C1. If Cell Cl is left blank, you will not be able to see your score Each graded cell is highlighted in yellow. Select all account titles/labels using dropdowns. Enter formulas...
I need help figuring out the ss payable, medicare, savings plan, and cash. Electronics Service Co. pays salaries monthly on the last day of the month. The following information is available from Electronics for the month ended December 31, Year 1: Administrative salaries Sales salaries office salaries $80,000 67.000 36,000 Assume the Social Security tax rate is 6.0 percent on the first $110,000 of salaries and the Medicare tax rate is 1.5 percent on all salaries. Duke reached the $110,000...
I am needing help with the general ledger portion of this problem. Also, please check my work on the journal portion. I am struggling with the unadjusted and adjusted trial balance so i want to make sure the ledger is correct. Project Data: Taylor Scott owns and operates a consulting firm called Scott Consulting. The business began operating in October 2019. Transactions for October and November 2019 have been recorded and posted. Scott Consulting had the following transactions in December...