I need help with some practice questions. I have attached an excel spreadsheet that needs to be completed in full.

Fill in the missing amounts (show work) Sales Revenue Beginning Inventory Purchases Available for Sale Ending Inventory Cost of Goods Sold Gross Profit Operating Expenses Net Income $1,000 $400 $500 ? $300 ? ? $100 ? Read Scenario and Answer following Questions Assume you serve on the board of a local golf and country club. In preparation for renegotiating the club's bank loans, the president indicates that the club needs to increase its operating cash flows before the end of the current year. The club's treasurer reassures the president and other board members that he knows a couple of ways to boost the club's operating cash flows. First, he says, the club can sell some of its accounts receivable to a collections company that is willing to pay the club $97,000 up front for the right to collect $1 00,000 of the overdue accounts. That will immediately boost operating cash flows. Second, he indicates that the club paid about $200,000 last month to relocate the 18th fairway and green closer to the clubhouse. The treasurer indicates that although these costs have been reported as expenses in the club's own monthly financial statements, he feels an argument can be made for reporting them as part of land and land improvements (a long-lived asset) in the year-end financial statements that would be provided to the bank. He explains that, by recording these payments as an addition to a longlived asset, they will not be shown as a reduction in operating cash flows. QUESTIONS: 1. Does the sale of accounts receivable to generate immediate cash harm or mislead anyone? Would you consider it an ethical business activity? ANSWER: 2. What category in the statement of cash flows is used when reporting cash spent on long-lived assets, such as land improvements? What category is used when cash is spent on expenses, such as costs for regular upkeep of the grounds? ANSWER: 3. What facts are relevant to deciding whether the costs of the 18th hole relocation should be reported as an asset or as an expense? Is it appropriate to make this decision based on the impact it could have on operating cash flows? ANSWER: 4. As a member of the board, how would you ensure that an ethical decision is made? ANSWER: Following is the adjusted trial balance of XYZ Company. Based on this information prepare a Balance Sheet, Income Statement and State of Retained Earnings. XYZ Company ADJUSTED TRIAL BALANCE Cash Accounts Receivable Prepaid Insurance Equipment Accumulated Depreciation Supplies Accounts Payable Wages Payable Unearned Revenue Contributed Capital Retained Earnings Sales Gas Expense Supply Expense Insurance Expense Depreciation Expense Wage Expense Dividends Debit Credit $ 80,000.00 $ 11,100.00 $ 1,500.00 $ 5,000.00 $ 1,000.00 $ 500.00 $ 900.00 $ 300.00 $ 1,500.00 $ 80,000.00 $ $ 17,000.00 $ 400.00 $ 200.00 $ 200.00 $ 200.00 $ 600.00 $ 1,000.00 $ 99,700.00 ### XYZ Company Balance sheet XYZ Company Income Statement Amount XYZ Company Statement of Retained Earnings atement Explain the closing entry process and prepare the closing entries in journal form based on the information in question 3. 1. EXPLAIN THE CLOSING ENTRY PROCESS: Journal Entry DB CR n 3. Prepare a bank reconciliation Shown the accounting entries that must be made by Matrix in journal entry and T-Account format. (Put T-Accounts on next Tab) MATRIX INC. BANK RECONCILIATION Cash balance per bank Cash balance per books (general ledger) Outstanding checks Check mailed to the bank for deposit had not reached the bank by the statement date. NSF check returned by the bank for accounts receivable July interest earned on the bank statement Check no. 700 for misc. expense cleared the bank for $200; erroneously recorded in the Matrix books for $20 Journal Entry DB $8,500 $7,320 $2,000 $450 $200 $10 CR Continuation of Question 5 Show the accounting entries that must be made by Matrix in T-Account format. (This is just an example, but please use this format on the T accounts) Cash Beg. Bal (a) (b) Total