project outline Fall 2018-2019 Q Search in Document Home Share Insert Design Layout References Mailings Review View X, Calibri (Body) , 11 , A-A- A- AaBbCcDd AaBbCcDdEE AaBbC Styles Pane Paste No Spacing Heading Normal Heading2 Title Project Outline Fall 2018-2019 You will find the company's data needed in the Excel file on the portal (MYGUST). Use the data provided to prepare the statement of cash flows (using the indirect method for the operation activities section) You need to prepare the statement of cash flows using excel, excel skills such as reference and formulas. (All calculations are supposed to be done using formulas). Please prepare the Statement in good professional format, as if you are submitting it to the top management. The due date is ThursdayDecember 20th by 12 PM You need to submit 1. a soft copy on the portal (upload the file on the portal ) 2. a hard (printed) copy of you statement of cash flows (showing the amounts) 3. a hard (printed) copy of you statement of cash flows (showing the formulas) to show the formulas click on show formulas from formulas tab Page 1 of 1 153 Words English (USs) 12096 Project Fall 2018-2019 Q Search Sheet Insert Page Layout Formulas Data Review Vievw Share Insert Delete Formatting as Table Styles Format Times New R...-13.5- A-A M , Wrap Text Paste Merge & Center 00Conditional Format Cell Sort & | x fx Prepare a complete statement of cash flows using the indirect method. Changes in accounts receivable and accounts payable relate to sales and cost of goods sold. Do not prepare a Kuwait towers Company has not yet prepared a formal statement of cash flows for the 2015 fiscal year. Comparutive balance sheets as of December 31, 2014 and 2015, and a statement af income und retained eamings for the year ended December 31, 2015, are presented below. Kuwait towers Compsey StATEMENT of INcOME AND RETAINED EARNINCS FOR THE YEAR ENDED DECEMBER 31, 2019 KWD 000 OMITE KWD 3,800 Cost of goods sold Salarits and benefits Hent, Light, and power KWD1200 80 Property axe Patent amortizatiom 26 25 30 64 Income betore income taxes Income taxes Net incomc Rctained canings Jun. 1, 2019 20 KWD 818 .128 Stock dividend declared and issued Retained esmings Dee 3,2019 KWD 528.00 Kuwait towers Compay ARATIVE BALANCE SHEET As ce DECEMRER 31 WD 000 OOOETED Long-crm asscts 150 S 910 70 Buildings and equipme Companys Data St of Cashflow 80% Project Fall 2018-2019 Q Search Sheet Insert Page Layout Formulas Data Review Vievw Share Insert Times New R...-13.5- A-A M , Wrap Text Delete, -, Z Paste Merge & Center 00Conditional Format Cell Sort & Formatting as Table Styles Format B65X Vfc Prepare a complete statement of cash flows using the indirect method. Changes in accounts receivable and accounts payable relate to sales and cost of goods sold. Do not prepare a Kuwai towars Company COMPARATIVE BALANCE SHEETS AS OF DcEMDER 31 (KWD 000 OMITTED 35 Long-term assets Building and equipeneat 910 Patents (less amortizotion Total long-term assets 105 130 Treasury botes( Accounts reecivable 500 Total curtat assets Total asscts B08 S Liabilities and Stockholders' Equity Long-term notes payable due 2022 Current liablities Accounts payiblc Encoane taxes payable Nolcs payable 320 30 Total curcat liabilitics Total liabilitics 680 Stoekholders equity Cormmon stock Retained camings Total stockholders' equity Prepare a complete statement of cash flows using the indirect method. Changes in accounts receivable and Rccounts payable relate to sales and cost of goods sold. Do ot prepare a reconciliation schedule. Companys Data St of Cashflow+ 80%