AutoSaver Topel, Wyatt, Project2 e i O ... Draw Page Layout Formulas Home Data Review View Tell me Share Comments Insert & Cui [Com Format Garamond v 12 A al: Wat General Zuum v Paste BTU " == Margo Cia 5 % % Insert Delta Format Conditional Format CNI Formatting Table Styes Sort & End & Floor Solici Idees Sensitivity 89 A D F F G H L M A) fs Decrease Accounts Payable B We Really Love Cash, Co. Statement nt cash lily For the year ended December 31, 2020 Case: Fluws God upesulay Acuvities Net Incode 2 3 4 In order to ger full points for this project 18 Rows in blue should accursrely reflect financial content worth 1 pxxint each. Cells in teen in the template should utilize tumulas worth 1 point each. cals ir yellow slow be pupce Cuttias zud vales of ttu suatu wodu: 1 points cach. Cells in Orange provides a corect response to the analysis question * Toul Points available $ 11,300 7 S 8 Deras i Acuits Receivable Decrease in Tasco Decrease Accounts Payable Income tax Payable 300 4.200 (4,200) Net cash provided by operating activities Cash tkw from investing Activities Sale of Equipocal Net Cash outf. iw truri investing Activities Tutal Cash flow frums investiu Activities 10 11 12 13 14 15 16 17 16 19 20 21 22 23 24 25 26 27 28 29 20 31 Cash flow's Tours Tuancing activities Toral Cash flow finom financing activities !!) Free Cash Flow Net increase ir cash and cash equivalents Causkizuc cast equivalents at luptid Cash and cash equivalents at cod o petiiod 32 33 34 35 36 37 IR -ranmrnr TN-namithri Excel Project 2 Template Ready -20% AutoSaver iO... Topel, Wyatt, Project2 Home Ingert Draw Page Layout Formulas Data Review View Tell me Share Comments Garamond v 12 ali ya mtv General Cui [Com Form 47. O. Paste BTU == " Idees Mug C Insert Dolce 5 % % Format Conditional Format CN Fortetting a Table Styles Sorte Floor Finde Selict Sensitivity 629 X A B C F H I K L M N a P TE Helpful tip: If you need a teleesher on how to complete this project, watch M2 Part 2: Example from Professor C. and the recording of the M2 discussion sessions where these topics are covered! We Really Lowe Cush, Co. Comparative Balance Sheet December 31 We Really Lure Cash, Co. Lucude Statetxat For the Year coded Deccrober 31, 2020 2020 2019 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 Assets Cash Accounts Receivable Inventory Peperty, plant & equipment, net Total Assets $6,200 5.200 30.000 211,5KI S252,900 $4,300 5,500 34,200) 215, MX $259,300 Sales revenue Coxst of acids wild Gruss profit Operating capaca Tacome from before gain and taxes Gain on sele of equipment Income tax expence Ner income $127,9K 49,66 58,100 46.900 11,200 WE HO $11.300 Liabilities and Stockholders' Equity Accounts payable Accued capcoses Taxes payable Bonds payable Tool liabilities Cow stuck Retained cuties Tool Stockholders' Equity Total Liabilities and Stockholders' Equity $1,700 2,000 2.500 60,XII ,200 125,000 61,700 $5,900 2,200 2,600 50,000 64,700 125,000 73,6001 199,600 $259,300 $252,900 38 39 40 41 42 43 44 45 46 47 49 49 Additional data: Depsuciativu expuse u $1,900 is included in the Opetuucy Expcuses on the Irwoce Stencil 2. Equipment with an original cost of $35.000 was soll for $20,300. The gain on sale was $900, 3. On June 1, 2121), the company purchased new equipment for cash at a cost of $17,500. 4. The company paid $21,200 in cash dividends for the year. Excel Project 2 Template + Ready -20%
