Financial Statements from the End-of-Deriod Spreadsheet Bambuo Consulting is a consulting firm owned and operated by Lisa Gooch. The following end-of-period spreadsheet was prepared for the year ended July 31, 2045 Bamboo Consulting End-of-Period Spreadsheet For the Year Ended July 31, 2045 Unadjusted Adjusted Trial Balance Adjustments Trial Balance Account Title Dr. Cr. Dr. Cr. Dr. Cr. Based on the preceding spreadsheet, prepare a statement of Owner's cquity for Bamboo Consulting. Bamboo Consulting Statement of Owner's Equity For the Year Ended July 31, 2015 Lisa Gooch, capital, August 1, 2014 521,800 x Net income $ 17,800 X withdrawals -2450 X 14,850 x Increase in owner's equity Lisa Gooch, capital, July 31, 2045 34.040 X Feedback 59,000 106,200 11,000 58,000 106,200 Chessy Work (a) 7,500 4,400 The first item normally on the statement of owner's equity is the beginning balance of the owner's capitala 515,000 515,000 28,000 (b) 5,600 33,500 20,500 20,500 (c) 2.500 Cash Accounts Receivable Supplies Office Equipment Accumulated Depreciation Accounts Payable santes Salaries Payable Lisa Gooch, Capital ve Lisa Gooch, Drawing Feestared Salary Expense Supplies Expense Depreciation Expense Miscellaneous expense 2,500 516,700 Based on the preceding spreadsheet, prepare a balance sheet for Bamboo Consulting. Bamboo Consulting Balance Sheet July 31, 2045 516,700 25,000 25,000 Assets 348,500 349,500 185,500 (C) 2,500 (a) 7,500 (b) 3,000 58.100 X Current assets: Cach Accounts receivable 199,000 7,500 109,000 X 5,000 Supplies 4.300 x 11,100 11,100 171.400 X 913,700 913,700 15,000 15,000 921,800 921,900 Total current assets Property, plant, and equipment: Office equipment Less documulated depreciation 509,000 x x 36,200 X Total property, plant, and equipment 472.800 x Total assets 14.200 X Based on the preceding spreadsheet, prepare an income statement for Bamboo Consulting. Bamboo Consulting Income Statement For the Year Ended July 31, 2015 Fees camned 347400 x Expenses Salary expense 100.900 X Supplies expense 6.800 x Depreciation expense 6,200 x Miscellaneous expense 12.100 x Liabilities 21.599 X Current liabilities: Accounts payable Salaries payable Total liabilities 3,000 X 24.500X 211.500 X Total expenses Owner's Equity Lisa Gooch, capital 619,700 X Nel income 136.600 x Total liabilities and owner's equity 614.200 x