The cash flow statement will be prepared in the following manner:
Amount in $ | |
Cash Flows from Operating Activities: | |
Net Income | 1,77,500 |
Depreciation expense | 16,000 |
Gain on sale of land | -6,500 |
Changes in current assets and current liabilities | |
Accounts Receivable | 14,300 |
Inventory | -6,500 |
Prepaid insurance | 1,580 |
Accounts payable | -54,500 |
Income taxes payable | -2,300 |
Interest payable | 1,100 |
Cash Flows from Operating Activities: | 1,40,680 |
Cash Flows from Investing Activities: | |
Purchase Investments | -91,000 |
Sale of land | 53,000 |
Cash Flows from Investing Activities: | -38,000 |
Cash Flows from Financing Activities: | |
Issue Common Stock | 43,000 |
Issue long term note | 13,000 |
Cash Flows from Financing Activities: | 56,000 |
Net Increase in Cash | 1,58,680 |
Add: Beginning Cash balance | 25,740 |
Ending Cash Balance | 1,84,420 |
Notes
The workings for the preparation of CFS are given below:
AC313 required: Preparing a Statement of Cash Flows Using the Direct Method using Excel's SUM Function...
Innovation Electronics, Inc. has provided you with the year end Income Statement Balance Sheet. The Controller has asked you to prepare the Statement of Cash Flows for the same year ended December 31. Use the information included in the Excel Simulation and the Excel functions described below to complete the task. • Multi-Tab Cell Reference: Allows you to refer to data from another cell in a separate tab in the worksheet. When using the multi-tab cell reference, type the equal...
Ac313 Preparing an Income Statement using Excel's SUM, IF and Basic Math Functions 2 Reading Readiness, Inc. has provided you its list of accounts and balances as of January 31. The Controller has asked you to prepare an Income Statement for the month ended January 31. Use the information included in the Excel Simulation and the Excel functions described below to complete the task nts Cell Reference; Allows you to refer to data from another cell in the worksheet. From...
Please show formula !!! Preparing a Cash Budget with Supporting Schedules using Excel's Multi-Tab Cell Referencing and Basic Math Functions S&P Enterprises has provided data from the first three months of the year. The Controller has asked you to prepare the Cash Budget and the related Schedules for Expected cash collections and Payments to suppliers. Use the information included in the Excel Simulation and the Excel functions described below to complete the task. • Cell Reference: Allows you to refer...
1 The Statement of Cash Flows 2 Using Excel to prepare the statement of cash flows, indirect method 4 5 The James Island Clothing Company began operations on July 1, 2018. The adjusted trial balance as of December 31, 2018, appears below, along with transaction data for 2018. JAMES ISLAND CLOTHING COMPANY Adjusted Trial Balance 12/31/18 Account Title Cash Accounts Receivable Inventory Office Equipment Truck Accumulated Depreciation-Plant Assets Accounts Payable Note Payable-Short Term Note Payable-Long Term Common Stock Retained Earnings...
Financial Statements using Excel's SUM Function and Cell Referencing A set of financial statements for Great Taste Restaurants Inc. are presented with missing information. The Controller has asked you to determine the missing amounts in the Income Statement, Statement of Stockholders’ Equity, and Balance Sheet. Use the information included in the Excel Simulation and the Excel functions described below to complete the task. Cell Reference: Allows you to refer to data from another cell in the worksheet. From the Excel...
Spreadsheet for Statement of Cash Flows Balance 7/1/18 Balance 12/31/18 Panel A Balance Sheet 0 Cash Accounts Receivable Inventory Office Equipment Truck Accumulated Depreciation-Plant Assets Total Assets Transaction Analysis Debit Credit 95,700 $ 12.000 4,400 6,000 5,000 6,000 123,100 6000 $ 95,700 12,000 4,400 6,000 5,000 (6,000) 117,100 0 $ $ o 5,500 10,000 5,500 10,000 Accounts Payable Note Payable-Short Term Note Payable - Long Term Total Liabilities 0 15500 15,500 100,000 Common Stock Retained Earnings Total Liabilities and Stockholders'...
i need help with this question Preparing an Income Statement using Excel's SUM, Basic Math Functions and Cell Referencing Great Taste Restaurants, Inc. has provided a list of select accounts as of March 31, 2016. The Controller has asked you to prepare the company's Income statement at the month ended March 31, 2016. Use the information included in the Excel Simulation and the Excel functions described below to complete the task . Cell Reference Allows you to refer to data...
IX Note: To complete the assignment to the worksheet tab labeled Cash Flow 1 Note: To complete the assignment, go to the worksheet tab labeled Cash Flow 2 and complete the statement of cash flows. INNOVATION ELECTRONICS, INC. HYGN For the Year Ended December 31, 20X2 Net sales $ Gain on sale of land 2,430,000 6,500 Total revenues 2.436,500 T $ Expenses: Cost of goods sold Operating expenses Depreciation expense Interest expense Income tax expense 1.565.000 598.000 16.000 17.000 63,000...
IX Note: To complete the assignment to the worksheet tab labeled Cash Flow 1 Note: To complete the assignment, go to the worksheet tab labeled Cash Flow 2 and complete the statement of cash flows. INNOVATION ELECTRONICS, INC. HYGN For the Year Ended December 31, 20X2 Net sales $ Gain on sale of land 2,430,000 6,500 Total revenues 2.436,500 T $ Expenses: Cost of goods sold Operating expenses Depreciation expense Interest expense Income tax expense 1.565.000 598.000 16.000 17.000 63,000...
velue 100.00 polnts Preparing a Classifled Balance Sheet using Excel's SUM Function and Cell Referencing Lantana Company has opened its company and has recorded its first month of transactions in T-accounts. The Controller has asked you to prepare the companys classified balance sheet at the month end based on those transactions. Use the information included in the Excel Simulation and the Excel functions described below to complete the task. . Cell Reference: Allows you to refer to data from another...