how to calculate cash on hand from balance sheet

"Calculating Cash on Hand from Balance Sheet: Step-by-Step Guide"

By Hannah Walker
AD

Calculating cash on hand from a balance sheet is a crucial step in understanding a company's liquidity and financial health. Here's a step-by-step guide on how to perform this calculation, along with an explanation of the relevant financial terms and a real-world example.

Understanding Cash on Hand and its Importance

Cash on hand refers to the physical cash and cash equivalents that a company has on hand. Cash equivalents are short-term, highly liquid investments that can be easily converted into cash, such as money market funds, commercial paper, and short-term government bonds. Understanding cash on hand is vital for businesses to manage their working capital, meet short-term obligations, and make informed decisions about investments and expansions.

Identifying Cash on Hand from the Balance Sheet

The balance sheet is the primary financial statement that lists a company's assets, liabilities, and equity. Cash on hand can be found under the current assets section, which includes assets that are expected to be converted into cash within one year or less. Here's how to locate and calculate cash on hand:

AD
Cash Count Worksheet
Cash Count Worksheet
how to read a balance sheet with pictures on the bottom and below it, which is also
how to read a balance sheet with pictures on the bottom and below it, which is also
a balance sheet is shown on top of a spiral bound notebook with the words balance sheet written below it
a balance sheet is shown on top of a spiral bound notebook with the words balance sheet written below it

Step 1: Locate the Cash and Cash Equivalents Line Item

On the balance sheet, look for the line item labeled "Cash and Cash Equivalents" or something similar. This line item represents the total amount of cash and cash equivalents that the company has.

Step 2: Break Down the Cash and Cash Equivalents

In some cases, the cash and cash equivalents line item may be further broken down into separate line items for cash and cash equivalents. If this is the case, you'll need to add these two line items together to calculate the total cash on hand.

Free Accounting Spreadsheets for Small Business | Basic Accounting Help
Free Accounting Spreadsheets for Small Business | Basic Accounting Help
someone is holding a yellow marker over a balance sheet
someone is holding a yellow marker over a balance sheet
The Big 3 Financial Statements: Income, Balance Sheet & Cash Flow
The Big 3 Financial Statements: Income, Balance Sheet & Cash Flow

Step 3: Adjust for Any Rounding or Estimates

Sometimes, the balance sheet may round numbers or use estimates. If this is the case, you'll need to adjust your calculation accordingly. For example, if the cash and cash equivalents line item is rounded to the nearest thousand, you may need to estimate the exact amount based on the company's disclosure notes or other financial statements.

Calculating Cash on Hand as a Percentage of Current Assets

In addition to calculating the total cash on hand, it's also useful to calculate cash on hand as a percentage of current assets. This calculation helps you understand how much of a company's current assets are in the form of cash or cash equivalents. Here's how to perform this calculation:

AD

Step 1: Locate the Current Assets Line Item

On the balance sheet, look for the line item labeled "Current Assets" or something similar. This line item represents the total amount of assets that the company expects to convert into cash within one year or less.

Bank Reconciliation Statements
Bank Reconciliation Statements
Statement of Cash Flows
Statement of Cash Flows
Daily Cash Sheet | Templates at allbusinesstemplates.com
Daily Cash Sheet | Templates at allbusinesstemplates.com
a white sheet with writing on it and an image of the words trial balance written in red
a white sheet with writing on it and an image of the words trial balance written in red
a spreadsheet showing the balances and numbers for each item in this financial statement
a spreadsheet showing the balances and numbers for each item in this financial statement
two worksheets with numbers and money for each student to use in the classroom
two worksheets with numbers and money for each student to use in the classroom

Step 2: Divide Cash on Hand by Current Assets

To calculate cash on hand as a percentage of current assets, divide the total cash on hand by the total current assets. Then, multiply the result by 100 to convert it into a percentage.

For example, let's say a company has $50,000 in cash and cash equivalents and $200,000 in current assets. The calculation would look like this:

AD

($50,000 / $200,000) * 100 = 25%

Beautiful chart idea
Beautiful chart idea
Enter Begin Cash and Reconcile Cash Drawer
Enter Begin Cash and Reconcile Cash Drawer
Profit β‰  Cash Flow πŸ’‘
Profit β‰  Cash Flow πŸ’‘
the balance sheet for making sense of your balance sheet
the balance sheet for making sense of your balance sheet
A Beginner's Guide to Financial Analysis
A Beginner's Guide to Financial Analysis
Golden Rules of Accounting πŸ“Š
Golden Rules of Accounting πŸ“Š
How to Adjust the Long-Term Debt on Balance Sheets
How to Adjust the Long-Term Debt on Balance Sheets
the balance sheet for cash flow statement is shown in black and white, with an image of
the balance sheet for cash flow statement is shown in black and white, with an image of
How to Analyze a Balance Sheet in 10 Simple Steps Original post by Oana Labes, MBA, CPA - follow her for more. 1 Cash Balances & Liquidity Start by reviewing cash and short-term… | Financiario
How to Analyze a Balance Sheet in 10 Simple Steps Original post by Oana Labes, MBA, CPA - follow her for more. 1 Cash Balances & Liquidity Start by reviewing cash and short-term… | Financiario
πŸ“˜ Trial Balance Notes | Accounting Cycle Explained | Handwritten Study Notes
πŸ“˜ Trial Balance Notes | Accounting Cycle Explained | Handwritten Study Notes
the balance sheet shows how to use balance sheets for balances, and how to use balance
the balance sheet shows how to use balance sheets for balances, and how to use balance
the balance sheet for financial statements
the balance sheet for financial statements
Brian - The Balance Sheet explained simply: | Facebook
Brian - The Balance Sheet explained simply: | Facebook
a white sheet that has some writing on it with words and numbers in the middle
a white sheet that has some writing on it with words and numbers in the middle

In this example, cash on hand represents 25% of the company's current assets.

Real-World Example: Apple Inc.

Let's take a look at Apple Inc.'s balance sheet as of September 25, 2021, to see how to calculate cash on hand in a real-world scenario:

AD
Line Item Amount (in billions)
Cash and Cash Equivalents $194.1
Current Assets $234.2

To calculate cash on hand, we simply take the amount listed under "Cash and Cash Equivalents." In this case, Apple has $194.1 billion in cash on hand.

To calculate cash on hand as a percentage of current assets, we use the following calculation:

($194.1 / $234.2) * 100 β‰ˆ 82.8%

In this example, cash on hand represents approximately 82.8% of Apple's current assets.

Factors to Consider When Analyzing Cash on Hand

When analyzing cash on hand, it's essential to consider several factors to get a complete picture of a company's liquidity and financial health:

  • Industry Norms: Different industries have different cash on hand requirements. For example, retail companies may need more cash on hand to manage inventory, while software companies may need less.
  • Business Cycle: A company's cash on hand needs may fluctuate depending on the stage of the business cycle. For example, companies may need more cash on hand during a recession to weather the economic downturn.
  • Capital Expenditures: Companies that are planning significant capital expenditures, such as building a new factory or purchasing new equipment, may need to increase their cash on hand to fund these projects.
  • Debt Obligations: Companies with significant debt obligations may need to maintain higher levels of cash on hand to meet their debt service requirements.

By considering these factors, you can gain a more comprehensive understanding of a company's cash on hand and its implications for the company's financial health and liquidity.

In summary, calculating cash on hand from the balance sheet is a crucial step in understanding a company's liquidity and financial health. By following the steps outlined in this article and considering the relevant factors, you can gain valuable insights into a company's cash management practices and make more informed investment decisions.

AD