Preparing the Statement of Cash Flows Using the Balance Sheet “Squeeze” Spreadsheet
Robert Matthews, Joe James, Ronald J. Daigle
Abstract
Open-access reader
Robert Matthews, Joe James, Ronald J. Daigle
Abstract
Open-access reader
The statement of cash flows (SCF), established pursuant to Statement of Financial Accounting Standards No. 95 (FAS 95), is perhaps the most useful of the standard financial statements-balance sheet (BS), income statement (IS), and SCF-in evaluating the financial viability of a company, particularly a small business. Unfortunately, the SCF is probably the least understood of the three statements and the most difficult to prepare, and is frequently not included in the financial statement compilations issued by accountants for many small businesses. This paper describes a spreadsheet methodology commonly employed in private industry to facilitate preparation of the SCF, which can be suitable for teaching accounting and finance students at the undergraduate level.
A significance statement is not available in the OpenAlex record.
A contribution statement is not available in the OpenAlex record.
Method details are not available in the OpenAlex metadata.
Findings are not separately available in the OpenAlex metadata.
Limitations are not available in the OpenAlex metadata.
Application details are not available in the OpenAlex metadata.
The statement of cash flows (SCF), established pursuant to Statement of Financial Accounting Standards No. 95 (FAS 95), is perhaps the most useful of the standard financial statements-balance sheet (BS), income statement (IS), and SCF-in evaluating the financial viability of a company, particularly a small business. Unfortunately, the SCF is probably the least understood of the three statements and the most difficult to prepare, and is frequently not included in the financial statement compilations issued by accountants for many small businesses. This paper describes a spreadsheet methodology commonly employed in private industry to facilitate preparation of the SCF, which can be suitable for teaching accounting and finance students at the undergraduate level.
Key concepts: Cash flow statement, Balance sheet, Statement (logic), Income statement, Financial statement analysis, Accounting, Statement of changes in financial position, Financial statement