Centre 5_feed_sons assignm. ALE HOME INSERT PAGE LAYOUT FORMULAS DATA VIEW REVIEW Enable PROTECTED VIEW Be careful files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View 13 fx (2) The Casual Clothing Balance Sheet & Income Statement Tab contains data you will need to E H 1 K M A D Instructions for Module S Assignment (1) Continue working with the same Reed & Company numbers, located in the Module 5 Assignment document. Use the template in the Reed Indirect Cash Flow tab to create an indirect cash flow statement for Reed & Company. Hint: The Reed Direct Cash Flow tab has the solution for Module 4; the investing and financing sections from this solution 2 will be the same for the indirect cash flow statement you are creating. (2) The Casual Clothing Balance Sheet & Income Statement Tab contains data you will need to complete this part of the assignment. You will need to create a column that calculates the change in all the balance sheet accounts. Use the template on the Casual Clothing Indirect CF tab to complete the indirect operating, investing financing, and change in cash sections of the cash flow statement. Use the template on the Casual Clothing Direct CFO tab to complete the 3 direct operating section only, making sure cash flow from operations matches the amount from the indirect method. 4 5 6 7 9 10 11 12 13 14 15 16 17 18 19 20 21 23 24 22 20 33 34 XH 5 G FILE INSERT HOME PAGE LAYOUT FORMULAS DATA REVIEW PROTECTED VIEW Be careful_files from the Internet can contain viruses. Unless you nee A1 Transactions!A1 B C D E F 41,250 (3,100) 38,150 (13,000) (8,500) (4,500) (3,375) (500) 8,275 (320) 1 Reed & Sons 2 Sales 3 Cost of Goods Sold 4 Gross Profit 5 Wage Expense 6 Operating Expenses 7 Rent Expense 8 Depreciation Expense 9 Amortization Expense 10 11 12 Operating Profit 13 Interest Expense 14 15 16 17 Income Before Tax 18 Tax Expense 19 Net Income 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 7,955 (3,400) 4,555 PROTECTED VIEW Be carefulfiles from the Internet can contain viruses. Unless you need to edit, it's sa A1 = Transactions!A1 B D E 1 Reed & Sons 2 Cash 3 Accounts Receivable 4 Inventory 5 Prepaid Rent 6 Short Term Investments 7 8 10,250 13,800 4,400 4,500 1,700 34,650 16,875 3,500 20,375 55,025 9 10 Current Assets 11 12 Equipment 27,000 13 Accumulated Depreciation (10,125) 14 Equipment, Net 15. Patents 16 17 18 19 Noncurrent Assets 20 Total Assets 21 22 Accounts Payable 23 Unearned Revenue 24 Interest Payable 25 Taxes Payable 26 27 28 29 Current Liabilities 30 31 Loans Payable 32 33 34 Noncurrent Liabilities 35 Total Liabilities 36 37 38 Common Stock 39 Retained Earnings 40 41 Total Shareholders Equity 42 Total Liabilities and Shareholders Equity 8,840 1,500 320 3,400 14,060 8,000 8,000 22,060 15,700 17,265 32,965 55,025 44 Instructions Transactions Income Statement Stmt of Retained Earnings Ba READY x FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW PROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit, it's safert B12 fr =SUM(B2:B11) B C D E F A 1 Reed & Sons 2 3 Cash Collected from Customers 4 Cash Paid to Employees 5 Cash Paid to Suppliers 6 Cash Paid for Misc Exp 7 8 9 10 31,950 (14,000) (1,900) (8,500) 7,550 (4,000) (1,700) (5,700) 12 Cash Flow from Operations 13 14 Purchase of Patent 15 Short Term Investments 16 17 18 19 20 Cash Flow from Investing 21 22 Loan Principal Repayment 23 Dividends Paid 24 Common Stock Issuance 25 26 27 28 Cash Flow from Financing 29 30 Change in Cash 31 Beginning Cash 32 Ending Cash 33 (5,000) (3,800) 5,200 (3,600) (1,750) 12,000 10,250 35 36 37 39 40 41 42 43 44 U 5 FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW PROTECTED VIEW Be careful--files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View B12 A B Indirect Method G H 1 Reed & Sons 3 Net Income UN 6 7 8 9 10 11 12 13 14 15 16 17 Cash Flow from Operations 18 19 20 21 22 23 24 25 Cash Flow from Investing 26 27 28 29 30 31 32 33 Cash Flow from Financing 34 35 Change in Cash 36 Beginning Cash 37 Ending Cash 38 39 40 41 42 Instructions Transactions Income Statement Stmt of Retained Earnings Balance Sheet Reed Direct READY Type here to search