Every thing is included the excel one is additional information.

Azar Trading Pty Lid, who has advised you that they do not have some of the information requiredpare the cash flow sCreate a new Excel Workbook for Bob's Machinery.You are required to use your problem-solving skills to reconstruct the cash flow account foroperating activities from Azar Trading Student to determine the following:. PurchasesPayment to accounts payable. Receipts from accounts receivable. Wage expenses paid. Cash flow from operating activitiesShow all of your working for purchases, accounts payable, accounts receivable and wagesSave this document as Azar Trading Cash Flow WorkbookTemplate has been uploaded in v-learn.1/1/161/7/17Account receivable60,000$33,000Accounts payable42,00039,000Inventory45,00060.090Accrued wages3,0006,000Prepaid wages18 0009,000Income statement for year end June 2017Sales (credit $330,000/1.1)$300,000Less cost of goods sold195,000Gross prof105,000Less Wages45,000Depreciation15,00Net profit45,000AutoSave on) 4 9Azar Cash Flow Worket Template Assessment 3 - Protected View .File Home Insert Page Layout Formulas Dataa Review View HelpBishal BASNET 88 1 - Q XPROTECTED VIEW Be careful-files from the Internet can contain viruses, Unless you need to edit, it's safer to stay in Protected View. Enable EditingShare CommentB6ix v fx Inventory 01/07/16This document is Azar Trading Cash Flow WorkbookFormula BarN OIt is part of the supporting resources for Assessment Task 3 of FNSACC514.PurchasesInventory 01/07/16Purchasessales45,000Profit and Loss - Gross Profit210,000 inventory210,000360,000105,000360,000Purchases Accounts Payable | Accounts Receivable | Wages Expenses | Cash Flow StatementAD () 7/3/20203