AutoSave @ESU. Wk 2-class-cash flow-Assign-8.xls - lome Insert Draw Page Layout Formulas Data Review View Tell me Paste Merge Center H24 Fx (ADD increase, Subtract decrease ( 11 Talya Reyna Fashion Retailers, Inc. - Cash Flow - Indirect Method STUDENT Graded points out of 55 W 1-class cash flow Use statements and notes to the right show Balance Sheet changes in yellow FASHION RETIRS, C. cells TAREHETER, Income Statement 500.000 10 CASH FLOWS FROM OPERATING ACTIVITIES Nincome Antent to recente et Income to Cash Flows from Operating poncash expenses. ADO ADD back.de Cost of Goods Gross Margi Operating expenses Salary expense Der Expense 514.300 Income before we Gain one of Foxtures Income taxes et income SUBTRACT IADO Backes 2.000 Decreasing Current Annet free cash SUBTRACT ADD decr. FARON RETAILERS, INC Comparative Balance Sheets Assets Incing Current Lech TADO w Sulec Depletion pron-current items in Notice Girone Ass Los on sale of Assets [Change in Current Assets & Current Ubes Changes in Dument Assets Increce in Accounts Receivable Incerin entry Ines Deer in Prepaid Exam Ino Decr in Trade Securities Changes in Current Inen Der in Accounts Payable Incer in A Ines Derin income Taxes Pay But of Arments Net Cash Flows from OPERATING ACTIVITIES CASH FLOWS FROM INVESTING ACTIVITIES Purchase of investments Sale of investments Purchase of Patures Net Cash Flows from INVESTING ACTIVITIES CASH FLOWS FROM RINANCING ACTIVITIES Repayment of Bonds Notes Issue of Common Stock Pedividende Acces Men Pred de ture LOTA 100 4.000 300 10 ro 100 SUBTRACT purchase BADO proces from SUBTRACT purchase SADO proceeds from Ace Pay Towy Net 195.000 4.000 Equity Com SUBTRACT payment TOTAL ADD of common SUBTRACT cash payt NOTES ADD of bondal Purch Adjacent bug for 1.200.000 100.000 down duro 1,000 procede Paid off of $10.000 Raised 350.000 treo Como Stock IPad cash dividend at $40.000 Nell Cash Flows from FINANCING ACTIVITIES Nel in der Cash Charleg of the year Chand of the year SCHEDULE OF NORCASH INVESTING AND FINANCING TRANSACTIONS Sheet + Ready MacBook Air Wk 2-Class assign-Cash Flows - Compatibility Mode at References Mallings Review View Tell me ABCD Alesd Aa BbCcDc Abcode AaBbCcDc Abd No Spacing Sub TH Week 2 CLASS ASSIGNMENT - CASH FLOW INDIRECT METHOD Instructions to record the changes in cash flow between periods. Preparing a Cash Flow Statement for Fashion Retailers, Inc using the format given on the worksheet Instructions: You will need a small calculator to complete the assignment. 1) From the information given on the Income Statement and comparative Balance Sheet, prepare entries for the changes necessary to reconcile net income with cash flow from operations 2) After entering the adjustments from analyzing the income Statement, proceed to make additional reconciling entries for Non-current items and Changes in Current Assets and Current Liabilities. 3) Once you have determined Cash Flow from Operations continue on by determining cash flow from investing. 4) The final determination is to calculate the cash flow from Financing. 5) The summation of all changes to cash must end up being the same as the cash balance 12/31/09 as shown on the Comparative Balance Sheets 6) As a final step in preparing the Cash Flow Statement, determine if any non-cash investing and financing transactions need to be reported on the bottom schedule. If so, describe the noncash items in a manner that anyone reading the report will understand the future impact on cash flow 7) When you are ready to begin, activate the link below to download the spreadsheet, where you will enter the required information. 8) Enter your name on the first page of the spreadsheet in the box shown. Note: Failure to do so may cause your work not to be identified. When asked, Don't Update! 9) When you are finished, save the spreadsheet and upload it to the Dropbox under "WK1-class, cash flow." Requirements: Print Instructions Activate Worksheet There are a number of potential adjustments or entries on this standardized form that may not be needed. Use those pre determined descriptions that MOST CLOSELY describe the adjustment or entry needed to determine cash flow. Focus MacBook Air AutoSave @ESU. Wk 2-class-cash flow-Assign-8.xls - lome Insert Draw Page Layout Formulas Data Review View Tell me Paste Merge Center H24 Fx (ADD increase, Subtract decrease ( 11 Talya Reyna Fashion Retailers, Inc. - Cash Flow - Indirect Method STUDENT Graded points out of 55 W 1-class cash flow Use statements and notes to the right show Balance Sheet changes in yellow FASHION RETIRS, C. cells TAREHETER, Income Statement 500.000 10 CASH FLOWS FROM OPERATING ACTIVITIES Nincome Antent to recente et Income to Cash Flows from Operating poncash expenses. ADO ADD back.de Cost of Goods Gross Margi Operating expenses Salary expense Der Expense 514.300 Income before we Gain one of Foxtures Income taxes et income SUBTRACT IADO Backes 2.000 Decreasing Current Annet free cash SUBTRACT ADD decr. FARON RETAILERS, INC Comparative Balance Sheets Assets Incing Current Lech TADO w Sulec Depletion pron-current items in Notice Girone Ass Los on sale of Assets [Change in Current Assets & Current Ubes Changes in Dument Assets Increce in Accounts Receivable Incerin entry Ines Deer in Prepaid Exam Ino Decr in Trade Securities Changes in Current Inen Der in Accounts Payable Incer in A Ines Derin income Taxes Pay But of Arments Net Cash Flows from OPERATING ACTIVITIES CASH FLOWS FROM INVESTING ACTIVITIES Purchase of investments Sale of investments Purchase of Patures Net Cash Flows from INVESTING ACTIVITIES CASH FLOWS FROM RINANCING ACTIVITIES Repayment of Bonds Notes Issue of Common Stock Pedividende Acces Men Pred de ture LOTA 100 4.000 300 10 ro 100 SUBTRACT purchase BADO proces from SUBTRACT purchase SADO proceeds from Ace Pay Towy Net 195.000 4.000 Equity Com SUBTRACT payment TOTAL ADD of common SUBTRACT cash payt NOTES ADD of bondal Purch Adjacent bug for 1.200.000 100.000 down duro 1,000 procede Paid off of $10.000 Raised 350.000 treo Como Stock IPad cash dividend at $40.000 Nell Cash Flows from FINANCING ACTIVITIES Nel in der Cash Charleg of the year Chand of the year SCHEDULE OF NORCASH INVESTING AND FINANCING TRANSACTIONS Sheet + Ready MacBook Air Wk 2-Class assign-Cash Flows - Compatibility Mode at References Mallings Review View Tell me ABCD Alesd Aa BbCcDc Abcode AaBbCcDc Abd No Spacing Sub TH Week 2 CLASS ASSIGNMENT - CASH FLOW INDIRECT METHOD Instructions to record the changes in cash flow between periods. Preparing a Cash Flow Statement for Fashion Retailers, Inc using the format given on the worksheet Instructions: You will need a small calculator to complete the assignment. 1) From the information given on the Income Statement and comparative Balance Sheet, prepare entries for the changes necessary to reconcile net income with cash flow from operations 2) After entering the adjustments from analyzing the income Statement, proceed to make additional reconciling entries for Non-current items and Changes in Current Assets and Current Liabilities. 3) Once you have determined Cash Flow from Operations continue on by determining cash flow from investing. 4) The final determination is to calculate the cash flow from Financing. 5) The summation of all changes to cash must end up being the same as the cash balance 12/31/09 as shown on the Comparative Balance Sheets 6) As a final step in preparing the Cash Flow Statement, determine if any non-cash investing and financing transactions need to be reported on the bottom schedule. If so, describe the noncash items in a manner that anyone reading the report will understand the future impact on cash flow 7) When you are ready to begin, activate the link below to download the spreadsheet, where you will enter the required information. 8) Enter your name on the first page of the spreadsheet in the box shown. Note: Failure to do so may cause your work not to be identified. When asked, Don't Update! 9) When you are finished, save the spreadsheet and upload it to the Dropbox under "WK1-class, cash flow." Requirements: Print Instructions Activate Worksheet There are a number of potential adjustments or entries on this standardized form that may not be needed. Use those pre determined descriptions that MOST CLOSELY describe the adjustment or entry needed to determine cash flow. Focus MacBook Air