Hey, can anyone help me with the questions 10,21-27 in the file attached below.

Name: ________________________________________ Fargo Homework Assignment This assignment focuses on account analysis. You have Fargo's adjusted trial balance and are asked to analyze the activity in selected accounts to determine information about beginning balances, ending balances and activity during the period. We will discuss how to get started with this exercise in class on Monday, January 30. Bring your copy of the case to class. This is a hand-in assignment - you are to work independently. I will check your work on Monday, February 6 and Monday, March 20 (these will count as two separate homework checks). The completed assignment is due April 10 (hard copy). The July 31, 2014 adjusted trial balance of Fargo Company is presented below. Notice that the total debits and credits for each account are listed (including the beginning balances) rather than the usual account ending balance. Fargo's fiscal year end is June 30. All adjusting entries have been made for the month of July 2014, except the adjustment for inventory. ACCOUNT Cash Accounts Receivable Allowance for Credit Losses Inventory Prepaid Advertising Office Supplies Office Equipment Accumulated Depreciation Accounts Payable Salaries Payable Interest Payable Dividends Payable Notes Payable Common Stock APIC - C/S Retained Earnings Sales Revenue Sales Returns Sales Discounts Purchases Purchase Returns and Allowances Purchase Discounts Salaries Expense Office Supplies Expense Insurance Expense Advertising Expense Bad Debt Expense Miscellaneous Expense Depreciation Expense Interest Expense Gain/Loss on Sale of Equipment Totals DEBIT $ 68,500 58,000 700 60,000 1,200 2,200 22,000 400 31,900 3,500 3,000 7,200 CREDIT $ 54,600 54,400 1,100 400 1,300 1,500 7,600 40,000 800 100 8,200 30,000 14,200 20,000 19,900 61,000 2,200 500 42,000 900 400 9,200 1,300 700 600 500 400 300 300 $ 316,600 200 $ 316,600 1 Using the trial balance of gross balances for Fargo and the additional information given below, answer the following questions about the operations of Fargo. Put answers in box when given. Show all work for credit. Complete the general ledger T-Accounts on the Excel schedule to support your answers. 1. Compute the amount of interest paid in July. At June 30, 2014, none was payable. 2. What was the amount of cash received on the sale of office equipment? 3. Assuming that the office equipment has a five year estimated life, no estimated salvage value, and no depreciation is taken during the month of purchase or sale, how much office equipment was acquired during the month? 4. How old is the office equipment that was neither sold nor acquired during the month? 5. How much cash was paid on accounts payable during the month? Assume the beginning balance in Accounts Payable for July was zero. 2 6. What is the amount of Accounts Receivable written off during the month? 7. What is Fargo's net realizable value of Accounts Receivable at July 31, 2014? 8. If the beginning balance in Notes Payable was $20,000, how much new debt did Fargo incur in July? 9. How much debt did Fargo pay off in July? 10. If all vendors sell to Fargo on terms of 2/10, n/30, what was the total amount of purchase discounts that were lost in July? Assume that no purchases were made in the last 10 days of July? 3 11. If there was no prepaid advertising at the beginning of the period, what was the total cash outlay for advertising in July? 12. How much cash was used to pay salaries during the month? Assume the balance in Salaries Payable on July 1 was zero. 13. What was the balance of Retained Earnings at the beginning of the fiscal year? 14. If office supplies valued at $300 were on hand at the beginning of the month, what were the total purchases of office supplies during the month? 15. What journal entry does Fargo make to record the purchase of office supplies? Date Accounts Debit Credit 16. The beginning balance in Dividends Payable on July 1 was $1,000. What amount of cash dividends were paid during the month? 4 17. Of the cash dividends paid, how much related to dividends declared in the current period? 18. What are net sales for July? 19. If 90% of sales are made on credit and all returns relate to credit sales, what was the beginning balance in Accounts Receivable on July 1? 20. How much cash was received on accounts receivable in July? 21. Does Fargo record purchases of inventory using the gross method or net method? How is this determined? 22. What was the beginning balance in Inventory at July 1? 23. What are net purchases for July? 5 24. Fargo performed a physical count of inventory at July 31 and valued it at $70,000. What is the cost of goods sold for the month of July? 25. Provide the journal entry to adjust inventory at July 31. Date Accounts Debit Credit Debit Credit 26. Provide the closing journal entry (ies) to close the books at July 31. Date Accounts 27. After recording these final journal entries, what is the ending balance in Retained Earnings on July 31? 6