Here is what I am working with: On Tab 2 after the instructions, I need to know the missing amounts; how do I determine the missing amounts? On Tab 3 I need to know how to determine the missing amounts On Tab 5, I can't seem to balance my retained earnings and balance sheet

The Template is provided to help you complete your assignment successfully. There are hints and guidance within the templates. For Example, some fields will have a note attached - as designated by the red triangle in the upper right corner of the cell. Some final cell totals or answers will give you a notice if the answer is correct. For example, if you have gotten the right answer, you may see a note "Correct", or "Good!" appear beneath or to the side of that cell. But, not all exercises or problems will provide feedback. So, be sure you do your best on all of the assignments. And, if you have any questions, please do not hesitate to bring your questions to me. The preferred way to communicate your assignment related questions will be in the Virtual Office. However, please remember that we do not discuss solutions in the Virtual Office. So, do not post partially completed template files, and do not post your solutions. But DO ask as specific a question as possible without giving away an answer. One final note - in almost every template, the cells that allow you to enter something will be background highlighted using = Yellow. In each assignment, you will be able to enter you name in the designated cell here in the "Instructions sheet". Please be sure to input you name in the template, and name the file according to the assignment instructions when you save it. Thank you and I look forward to working with you on your assignments. Enter you Name here ======> Faye M Williams GB 518 UNIT 02 ASSIGNMENTS Exercise 3-4, Page 136 in the textbook. Your Name -->: NOTE: To earn full credit, you MUST include your Excel Formula/computations in the YELLOW Cells. Faye M Williams 1 2 3 4 Determine the missing amounts: a b c d Supplies available - prior year end $ 300.00 $1,600.00 $ 1,360.00 ? Supplies purchased during the current year $ 2,100.00 $ 5,400.00 ? $6,000.00 Supplies available - current year end $ 750.00 ? $ 1,840.00 $ 800.00 Supplies expense of the current year ? $ 1,300.00 $9,600.00 $ 6,575.00 NOTE: Do NOT simply replace the "?" mark with a $ amount. You MUST include the computations using the proper Excel Formula. Exercise 3-4 is worth 4 points. GB 518 UNIT 02 ASSIGNMENTS Exercise 3-7, Page 137 in the textbook Your Name -->: NOTE: To earn full credit, you MUST include your Excel Formula/computations in the YELLOW Cells. Faye M Williams Determine the missing anounts: Case a b c d e $ $ $ $ Net Income 5,390.00 87,644.00 93,385.00 55,234.00 $ $ $ $ Net Sales 44,830.00 398,954.00 257,082.00 1,458,999.00 Analysis and Interpretation: Profit margin is a useful measure of a company's operating results, it is the ratio of its net income to net sales. This ratio is interpreted as reflecting the percent of profit in each dollar of sales. Formula = Net Income / Net Sales Exercise 3-7 is worth 16 points. Profit Margin 12% 2% 36% 16% s. Given Data P03-04A: JJW COMPANY Worksheet Account Cash Accounts receivable Office supplies Prepaid insurance Office equipment Accumulated depreciation, Office equipment Accounts payable Interest payable Salaries payable Unearned consulting fees Long-term notes payable Common stock Retained earnings Dividends Consulting fees earned Depreciation expense, Office equipment Salaries expense Interest expense Insurance expense Rent expense Office supplies expense Advertising expense Totals $ $ Unadjusted Trial Balance Debit Credit 27,000 12,000 18,000 7,320 92,000 $ 12,000 9,300 16,000 44,000 5,000 23,420 10,000 156,000 71,000 1,400 13,200 13,800 265,720 $ 265,720 Additional information: Retained earnings, July 31, 2011 Current-year dividends $ $ 23,420 10,000 Check figures: (2) Net income Total assets $ $ 37,020 131,340 Adjustments Debit Credit $ $ Adjusted Trial Balance Debit Credit 27,000 22,460 3,000 4,880 92,000 $ 18,000 10,200 800 6,600 14,300 44,000 5,000 23,420 10,000 168,160 6,000 77,600 2,200 2,440 13,200 15,000 14,700 290,480 $ 290,480 Student Name: Faye M Williams Class: GB 518 UNIT 02 ASSIGNMEN Problem 03-04A JJW COMPANY Worksheet Account Cash Accounts receivable Office supplies Prepaid insurance Office equipment Accumulated depreciation, Office equipment Accounts payable Interest payable Salaries payable Unearned consulting fees Long-term notes payable Common stock Retained earnings Dividends Consulting fees earned Depreciation expense, Office equipment Salaries expense Interest expense Insurance expense Rent expense Office supplies expense Advertising expense Totals Unadjusted Trial Balance Debit Credit (Ltr) $ 27,000 12,000 (a) 18,000 7,320 92,000 $ 12,000 9,300 16,000 44,000 5,000 23,420 10,000 156,000 71,000 1,400 13,200 13,800 $265,720 Adjustments Debit (Ltr) Credit 12,160 (b) (c) 15,000 2,440 (d) (e) (f) (g) 6,000 900 800 6,600 (a) 12,160 (b) (e) $265,720 6,000 6,600 800 2,440 15,000 900 $43,900 $43,900 Correct! (a) (b) (c) (d) (e) (f) (g) (h) (d) (g) (f) (c) Correct! Adjustment description: Earned but uncollected revenues. Cost of consumed office supplies. Cost of expired insurance coverage. Depreciation expense on office equipment. Incurred but unpaid advertising expense. Incurred but unpaid interest expense. Incurred but unpaid salaries expense. Earned revenues previously received in advance. Adjusted Trial Balance Debit Credit $ 27,000 22,460 3,000 4,880 92,000 $ 18,000 10,200 800 6,600 14,300 44,000 5,000 23,420 10,000 168,160 6,000 77,600 2,200 2,440 13,200 15,000 14,700 $290,480 $290,480 Student Name: Faye M Williams Class: GB 518 UNIT 02 ASSIGNMEN Problem 03-04A JJW COMPANY Income Statement For the Year Ended July 31, 2011 Revenues: Consulting fees earned Expenses: Depreciation expense-Office equipment Salaries expense Interest expense Insurance expense Rent expense Office supplies expense Advertising expense Total expenses Net income 168,160 $6,000 77,600 2,200 2,440 13,200 15,000 14,700 131,140 $37,020 Correct! JJW COMPANY Statement of Retained Earnings For the Year Ended July 31, 2011 Retained earnings, July 31, 2010 Plus: Net income Less: Owner withdrawals Retained earnings, July 31, 2011 37,020 $37,020 $37,020 Try again! Student Name: Faye M Williams Class: GB 518 UNIT 02 ASSIGNMEN Problem 03-04A JJW COMPANY Balance Sheet July 31, 2009 Assets Cash Accounts receivable Office supplies Prepaid insurance Office equipment Accumulated depreciation-Office equipment Total assets $27,000 22,460 3,000 4,880 $92,000 18,000 $75,340 Liabilities Accounts payable Interest payable Salaries payable Unearned consulting fees Long-term notes payable Total liabilities $10,200 800 77,600 14,300 4,400 Equity Common stock Retained earnings Total equity Total liabilities and equity 37,020 37,020 #VALUE! #VALUE