2023•Journal of Instructional Techniques in FinanceOpen access

Preparing the Statement of Cash Flows Using the Balance Sheet “Squeeze” Spreadsheet

Robert Matthews, Joe James, Ronald J. Daigle

Open full text 0 citations

Abstract

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.

Open-access reader

About this research paper

What this paper is about

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.

Why it matters

A significance statement is not available in the OpenAlex record.

Key contribution

A contribution statement is not available in the OpenAlex record.

Method / approach

Method details are not available in the OpenAlex metadata.

Main findings

Findings are not separately available in the OpenAlex metadata.

Limitations

Limitations are not available in the OpenAlex metadata.

Applications

Application details are not available in the OpenAlex metadata.

Available abstract

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

Related papers

Back to paper searchBrowse research topicsOriginal source
Preparing the Statement of Cash Flows Using the Balance Sheet “Squeeze” Spreadsheet — Research Paper | ScholarLens