Estado de FLUJOS DE EFECTIVO | Paso a paso y fácil en excel | Contabilidad Intermedia

Estado de FLUJOS DE EFECTIVO | Paso a paso y fácil en excel | Contabilidad Intermedia

Introduction to the State of Cash Flows

In this section, the speaker introduces the topic of the state of cash flows and mentions that it is important to have a basic understanding of the balance sheet and income statement before diving into this topic.

Understanding the Basics (0:00:27 - 0:01:30)

  • It is recommended to watch previous videos on the balance sheet and income statement before proceeding with understanding the state of cash flows.
  • The state of cash flows is derived from information in the balance sheet and income statement.
  • The state of cash flows shows all inflows and outflows of money, as well as their origins and destinations.
  • Understanding whether transactions are made in cash or credit is crucial for analyzing cash flows.

Importance of Cash Flow Analysis (0:01:50 - 0:04:13)

  • Cash flow analysis helps determine if there is enough cash to cover expenses like payroll and supplier payments.
  • The state of cash flows is considered one of the fundamental financial statements but lacks extensive literature on its preparation.
  • By understanding how cash moves within an organization, businesses can make informed decisions about their financial health.

Structure of Cash Flow Statement (0:04:34 - 0:06:26)

  • The structure follows a simplified format consisting of initial funds, inflows, outflows, and a final net flow.
  • There are three main elements in a cash flow statement:
  • Operating activities involve operational transactions such as buying/selling goods or paying wages.
  • Investing activities include buying/selling assets like property or equipment.
  • Financing activities encompass raising capital through loans or issuing stocks.

Note that these summaries are based solely on the provided transcript.

Overview of Financial Statements

In this section, the speaker discusses the different components of financial statements, including the balance sheet and financing activities.

Components of Financial Statements

  • The speaker explains that financial statements consist of various identifiable items found in the balance sheet or statement of financial position.
  • Activities such as financing involve interactions with creditors and debtors, which impact a company's ability to leverage resources for selling goods acquired from suppliers.
  • The main accounts in the balance sheet are assets, liabilities, and equity. For a detailed understanding of these accounts, the speaker recommends referring to other videos on these topics.

Financing Activities

This section focuses on financing activities and how they can impact a company's cash flow.

Examples of Financing Activities

  • Financing activities can include obtaining credit from creditors. For instance, when a company receives credit terms of 90 days from its creditors, it allows them to acquire necessary resources for selling merchandise purchased from suppliers.
  • Another example is involving debtors who are external individuals or entities providing loans to the company.

Understanding Different Accounts

Here, the speaker explains some key accounts related to assets, liabilities, and equity.

Identifying Key Accounts

  • The speaker mentions that it is essential to understand the primary accounts associated with assets, liabilities, and equity. To gain more clarity on this topic, viewers are directed to watch recommended videos.

Introduction to Cash Flow Statement

This section introduces the concept of cash flow statement and highlights two methods: direct method and indirect method.

Two Methods of Preparing Cash Flow Statement

  • The cash flow statement can be prepared using either the direct method or indirect method.
  • The direct method involves recording cash inflows and outflows based on accounting records. Viewers are referred to another video on how to make accounting entries.
  • The indirect method starts with the profit or loss before taxes from the income statement. Understanding concepts like income statement, balance sheet, vertical analysis, and double-entry accounting is crucial for comprehending this method.

Direct Method of Preparing Cash Flow Statement

This section focuses on the direct method of preparing a cash flow statement.

Characteristics of the Direct Method

  • The direct method requires deriving information from accounting records that affect cash inflows and outflows.
  • To understand these accounting records, viewers are directed to watch a video explaining how to make accounting entries.
  • Additionally, each element in the income statement needs to be modified when using the direct method.

Indirect Method of Preparing Cash Flow Statement

This section discusses the indirect method of preparing a cash flow statement.

Characteristics of the Indirect Method

  • The indirect method starts with profit or loss before taxes from the income statement.
  • Prior knowledge about topics such as income statements, balance sheets, vertical analysis, and double-entry accounting is essential for understanding this method.

Importance of Understanding Financial Statements

The speaker emphasizes the importance of understanding financial statements for entrepreneurs, students, and accountants.

Importance of Financial Statement Knowledge

  • Entrepreneurs, students, and accountants should familiarize themselves with financial statements as they may need this information in their professional lives.
  • Watching videos on topics like income statements, balance sheets, vertical analysis, making accounting entries can provide valuable insights into financial reporting requirements.

Practical Case: Cash Flow Statement Example

In this section, a practical case example is presented to illustrate how to prepare a cash flow statement.

Analyzing a Practical Case

  • The speaker presents a cash flow statement example with three main categories: operating activities, investing activities, and financing activities.
  • To understand the case fully, viewers are encouraged to refer to other videos on related topics such as vertical analysis and financial statements.

Comparative Balance Sheet

This section introduces a comparative balance sheet as a starting point for preparing a cash flow statement.

Understanding Comparative Balance Sheets

  • A comparative balance sheet shows the final results of two different periods, such as the end of 2019 and the end of 2020.
  • It is crucial to consider how these dates will be compared when preparing a cash flow statement.

Converting Balance Sheet into Vertical Format

This section explains how to convert a balance sheet into a vertical format for further analysis.

Converting to Vertical Format

  • The speaker demonstrates converting the balance sheet into a vertical format for reporting purposes.
  • In this report-style format, percentages are not included. For more information on vertical financial statements, viewers can refer to recommended videos.

Income Statement Overview

This section provides an overview of the income statement used in preparing the cash flow statement.

Understanding the Income Statement

  • The income statement used in preparing the cash flow statement is dated December 31, 2020. However, it is important to note that any relevant date can be used depending on when the cash flow statement is being prepared.
  • Key components of the income statement include net sales, cost of goods sold, gross profit, total expenses, and additional items related to financial reporting.

Additional Items in Income Statement

This section highlights additional items included in the income statement that impact the preparation of the cash flow statement.

Including Additional Items in Income Statement

  • The income statement includes additional items such as office equipment, computer equipment, transportation equipment, buildings, and land. These items are basic elements of the balance sheet.
  • While previous videos discussed essential concepts, this section adds some basic accounts relevant to the income statement.

Analyzing Cash Flow Differences

This section focuses on analyzing cash flow differences between two periods.

Analyzing Cash Flow Differences

  • The speaker emphasizes the importance of understanding cash flow differences between two periods to determine if there has been an inflow or outflow of money.
  • In this case, the speaker analyzes the difference in customer accounts from 2019 to 2020.

Determining Cash Inflows and Outflows

This section explains how to determine cash inflows and outflows based on variations between two periods.

Determining Cash Inflows and Outflows

  • Instead of focusing on specific amounts of money entering or leaving a company, the analysis in the cash flow statement revolves around variations in customer accounts.
  • The speaker demonstrates how to analyze changes in customer accounts from 2019 to 2020 as part of determining cash inflows and outflows.

Conclusion and Practical Application

The speaker concludes by emphasizing practical application and understanding financial theory through real-life examples.

Applying Financial Theory Practically

  • Understanding financial theory is crucial for entrepreneurs, students, and accountants. However, practical application through real-life examples helps solidify comprehension.
  • The presented case study serves as a practical example for applying theoretical knowledge related to preparing a cash flow statement.

Understanding the Concept of Cash Flow

In this section, the speaker explains the concept of cash flow and how it affects different accounts.

Cash Flow in Asset Accounts

  • When the amount in asset accounts increases, it represents an outflow of money as more funds are retained instead of being deposited into banks or cash.
  • For example, an increase in inventory indicates that a certain amount of merchandise has not been sold and is still being held by the company.
  • Similarly, an increase in accounts receivable means that more customers owe money to the company, resulting in a decrease in cash inflow.

Cash Flow in Liability Accounts

  • In contrast to asset accounts, a decrease in liability accounts represents an inflow of money.
  • For instance, a decrease in payable taxes or other liabilities indicates that less money needs to be paid out.
  • The same principle applies to capital and retained earnings accounts where a decrease signifies an inflow of funds.

Depreciation Accumulated Account

  • The depreciation accumulated account complements the corresponding asset account by reflecting the loss of value over time.
  • Although depreciation is not a cash outflow, it should be considered when calculating cash flow due to its impact on asset values.

Applying the Concept to Other Accounts

  • The same principles discussed above can be applied to other asset and liability accounts such as long-term investments and land.
  • By analyzing changes in these accounts from one year to another, we can determine whether there was a cash inflow or outflow.

Analyzing Specific Accounts for Cash Flow

This section focuses on analyzing specific accounts for their impact on cash flow.

IVA-Acreditable (Tax Creditable)

  • A decrease in IVA-acreditable represents an inflow of money since it indicates a reduction in taxes payable.

Depreciation Accumulated Account

  • The depreciation accumulated account should be considered for its impact on cash flow, even though it is not a cash outflow.
  • By subtracting the amount from the previous year's balance, we can determine whether there was an increase or decrease in value.

Other Accounts

  • Similar to the examples mentioned above, changes in other accounts such as computer equipment and land should be analyzed to determine their impact on cash flow.
  • It is important to ensure that the resulting numbers are positive for easier calculation and interpretation.

Cash Flow Classification and Methodology

This section discusses the classification of cash flow activities and introduces two methods for calculating cash flow: direct method and indirect method.

Cash Flow Activities Classification

  • Cash flow activities are classified into three categories: operating activities, investing activities, and financing activities.
  • Operating activities involve day-to-day business operations, investing activities relate to investments in assets or securities, and financing activities pertain to obtaining or repaying funds.

Direct Method vs. Indirect Method

  • The direct method calculates cash flows by directly analyzing inflows and outflows of cash from operating activities.
  • The indirect method starts with net income from the income statement and adjusts it for non-cash items to arrive at net cash provided by operating activities.

The transcript does not provide further details on these methods.

Determining the Operating Activities

In this section, the speaker discusses how to determine the operating activities in a financial statement. The main focus is on the sales and increase in customers.

Determining Sales

  • Sales are considered the primary category of operating activities.
  • The amount of sales can be obtained from the income statement.
  • In this example, net sales are $2,300,000.

Increase in Customers

  • To determine the increase in customers, compare the number of clients between two periods (e.g., 2019 and 2020).
  • In this case, there was an increase of 33,000 clients.
  • This information will be used to calculate the cash inflow from customers.

Cash Collection from Customers

  • By subtracting the increase in customers from net sales, we can calculate the cash collection from customers.
  • In this example, it amounts to $2,267,000.
  • This represents an operational movement as it arises from business operations.

Cost of Goods Sold Calculation

Here, we learn how to calculate cost of goods sold (COGS) and its impact on cash flow.

COGS Calculation

  • COGS includes all purchases made by a company.
  • It is subtracted from total revenue to determine gross profit.
  • In this case, COGS is $1,088,000.

Impact on Cash Flow

  • COGS affects cash flow because it represents money spent on inventory purchases.
  • To reflect this impact on cash flow statement:
  • Subtract COGS from cash inflow ($2,267,000).
  • Subtract inventory increase ($1,088,000) as it reduces available funds.

Operating Expenses Calculation

This section focuses on calculating operating expenses and their impact on cash flow.

Types of Operating Expenses

  • Operating expenses include selling expenses, administrative expenses, and financial expenses.

Calculation Process

  • Identify the specific expense categories from the income statement.
  • In this example, we have selling expenses, administrative expenses, and financial expenses.
  • Include these amounts in the cash flow statement under their respective categories.

Determining Other Movements

Here, we learn how to determine other movements in the balance sheet that affect cash flow.

Analyzing Balance Sheet Items

  • Different balance sheet items have different impacts on cash flow.
  • We analyze each item to determine its effect on cash flow.

Examples of Movements

  • Deudores Diversos (Diverse Debtors): Represents financing activities as it involves financing individuals outside the organization.
  • IVA Acreditable (Creditable VAT): Considered an operational movement as it arises from business operations.
  • Equipment and Buildings: These are investments and affect cash flow accordingly.
  • Acreedores Diversos (Diverse Creditors): Represents financing activities as it involves external financing.
  • Impuestos a la Utilidad (Income Taxes): Reflects taxes payable due to profits earned by the company.

Calculating Cash Flow

In this section, we discuss how to calculate cash flow based on the information obtained from previous sections.

Cash Flow Calculation

  • Use the information gathered from various sections to calculate cash flow for each category (operating activities, investing activities, financing activities).
  • The goal is to determine whether there was a net increase or decrease in cash during a specific period.

New Section

This section discusses the items in the balance sheet and their impact on cash flow.

Balance Sheet Items

  • Deudores Diversos (Miscellaneous Debtors): This item represents an increasing amount of money going out, so it is considered a cash outflow. It is recorded as a decrease in cash under "IVA Acreditable" (Accredited VAT).
  • IVA Acreditable (Accredited VAT): This item represents a decreasing amount of money, indicating an inflow of cash. It is recorded as an increase in cash.
  • Investments: Items such as office equipment, computers, transportation, buildings, and land are considered cash outflows and are recorded under "Salidas de Efectivo" (Cash Outflows). However, office equipment is the only category that can be considered a cash inflow and is recorded under "Aumenta el Efectivo" (Increase in Cash).
  • Acreedores (Creditors): As creditors increase from one year to another, it indicates a cash outflow. In the balance sheet, this is considered an increase in cash. The difference in amounts should be recorded as an inflow of cash.
  • Impuestos por Pagar (Taxes Payable): Similar to Accredited VAT, taxes payable represent a decrease in cash and should be recorded accordingly.
  • Capital Social (Share Capital): Share capital represents an inflow of money but results in a decrease in cash. It should be recorded as such.

New Section

This section explains how different accounts affect the flow of cash and how to categorize them into operating activities, financing activities, or investment activities.

Activities Classification

Operating Activities

  • Cobro a Clientes (Customer Payments): Recorded as an inflow of $2 million 267.
  • Pago a Proveedores (Supplier Payments): Recorded as an outflow of $1 million 88.
  • Pago por Gastos (Expense Payments): Recorded as an outflow of the previously determined amount.

Investment Activities

  • Equipo de Oficina (Office Equipment): Recorded as an inflow of $2000.
  • Equipo de Cómputo (Computers): Recorded as an outflow.
  • Equipo de Transporte (Transportation Equipment): Recorded as an outflow.

Other Activities

  • IVA Acreditable (Accredited VAT) and Impuesto a la Utilidad (Income Tax): Both recorded as outflows of cash.

New Section

This section concludes the discussion on cash flow activities and summarizes the amounts associated with each activity category.

Cash Flow Summary

Operating Activities

  • Cobro a Clientes: Inflow of $2,267,000.
  • Pago a Proveedores: Outflow of $1,088,000.
  • Pago por Gastos: Outflow of previously determined amount.

Investment Activities

  • Equipo de Oficina: Inflow of $2,000.
  • Equipo de Cómputo: Outflow.
  • Equipo de Transporte: Outflow.

Other Activities

  • IVA Acreditable: Outflow.
  • Impuesto a la Utilidad: Outflow.

Overview of Financial Activities

This section discusses the financial activities related to assets, liabilities, and equity.

Assets

  • Buildings decrease in value while land increases.
  • Depreciation is not a cash outflow but affects investments.

Liabilities

  • Diverse debtors decrease cash.
  • Diverse creditors increase cash.

Equity

  • Capital social (social capital) decreases cash.

Variations in Cash Flow

  • Variations in cash flow are the sum of changes in assets, liabilities, and equity.
  • The previous year's cash balance is added to the variations.
  • Depreciation is included as an expense that affects investments.

Calculation of Cash Flow from Operations

  • Depreciation is added to expenses.
  • The total amount is subtracted from revenues to calculate net income.
  • Net income is adjusted for non-cash items such as depreciation.
  • The resulting amount represents cash flow from operations.

Final Cash Flow Statement

  • Cash flow from operations: 214,000
  • Cash flow from investing activities: -131,000
  • Cash flow from financing activities: +33,000
  • Total cash flow for the period: 197,000

Overview of Financing and Operations

This section discusses the different aspects of financing and operations in a business. It covers topics such as taxes, capital social, and categorizing operations by type.

Types of Outflows

  • Clients: Decrease in cash flow (-33,000)
  • Inventory/Almacén: Decrease in cash flow
  • Diverse debtors/Deudores diversos: Decrease in cash flow
  • IVA Acreditable (tax credit): Increase in cash flow
  • Depreciation/Depreciaciones: Increase in cash flow (68,000)
  • Suppliers/Proveedores: Increase in cash flow
  • IVA Trasladado (transferred tax): Decrease in cash flow
  • Taxes payable/Impuestos por pagar: Decrease in cash flow
  • Capital Social (social capital): Decrease in cash flow (9,000)
  • Net profit/Utilidad neta: Increase in cash flow (212,000)

Cash Flow Calculation for Operating Activities

To calculate the net cash flows from operating activities, we need to consider the changes in each category:

  • Clients: Negative change (-33,000)
  • Inventory/Almacén: Negative change (-70,000)
  • IVA Acreditable (tax credit): Positive change
  • Depreciation/Depreciaciones: Positive change (68,000)
  • Suppliers/Proveedores: Positive change
  • IVA Trasladado (transferred tax): Negative change
  • Taxes payable/Impuestos por pagar: Negative change

The total net cash flows from operating activities is 214,000.

Cash Flow Calculation for Investing Activities

In investing activities, we consider the changes related to equipment and properties:

  • Office equipment/equipo de oficina: Positive change
  • Computer equipment/equipo de cómputo: Negative change
  • Transportation equipment/equipo de transporte: Negative change (-70,000)
  • Buildings/Edificios: Negative change
  • Land/Terrenos: Positive change (76,000)

The total net cash flows from investing activities is 131,000.

Cash Flow Calculation for Financing Activities

In financing activities, we consider the changes related to debtors and creditors:

  • Diverse debtors/Deudores diversos: Positive change
  • Creditors/Acreedores: Positive change
  • Transferred tax/IVA Trasladado: Negative change
  • Taxes payable/Impuestos por pagar: Negative change

No specific values are mentioned in the transcript for these categories.

Activities of Financing Continued

This section continues discussing the activities of financing in a business. It covers topics such as capital social and taxes payable.

Capital Social (Social Capital)

  • Decrease in cash flow (-9,000)

Taxes Payable/Impuestos por Pagar

  • Decrease in cash flow

Net Profit and Operating Activities

This section focuses on the net profit and its impact on operating activities.

Net Profit/Utilidad Neta

  • Increase in cash flow (212,000)

Cash Flow Calculation for Operating Activities

Continuing from previous calculations:

  • Clients: Negative change
  • Inventory/Almacén: Negative change
  • IVA Acreditable (tax credit): Positive change
  • Depreciation/Depreciaciones: Positive change
  • Suppliers/Proveedores: Positive change
  • IVA Trasladado (transferred tax): Negative change
  • Taxes payable/Impuestos por pagar: Negative change

The total net cash flows from operating activities remains at 214,000.

Cash Flow Calculation for Investing Activities

This section focuses on the cash flow calculation for investing activities.

Cash Flow Calculation for Investing Activities

Continuing from previous calculations:

  • Office equipment/equipo de oficina: Positive change
  • Computer equipment/equipo de cómputo: Negative change
  • Transportation equipment/equipo de transporte: Negative change
  • Buildings/Edificios: Negative change
  • Land/Terrenos: Positive change

The total net cash flows from investing activities remains at 131,000.

Cash Flow Calculation for Financing Activities

This section focuses on the cash flow calculation for financing activities.

Cash Flow Calculation for Financing Activities

Continuing from previous calculations:

  • Diverse debtors/Deudores diversos: Positive change
  • Creditors/Acreedores: No specific values mentioned in the transcript
  • Transferred tax/IVA Trasladado: Negative change
  • Taxes payable/Impuestos por pagar: Decrease in cash flow (49,000)

The total net cash flows from financing activities is not provided in the transcript.

Changes in Capital Social

In this section, the speaker discusses the changes in capital social and how it affects the financial statement.

Understanding the Changes in Capital Social

  • The capital social is decreasing, indicated by a negative sign.
  • The amount of 33,000 is mentioned as both an example and a known value.
  • Variations in cash flow are considered when determining the amount to be placed under capital social.

Summation of Importes

This section focuses on calculating the summation of importes.

Calculating the Summation of Importes

  • The speaker mentions that the summation of three importes needs to be calculated.
  • The total sum obtained is 116,000.

Adding Cash Balance from Previous Period

Here, the speaker explains how to add cash balance from the previous period to calculate final cash flow.

Adding Cash Balance from Previous Period

  • To calculate final cash flow, add the existing cash balance (caja y banco) from the previous period.
  • The information can be obtained from the balance general.
  • By adding 81 (the sum of caja and bancos), we get a total of 116,081 for this period's cash flow.

Determining Final Cash Flow

This section demonstrates how to determine final cash flow using specific calculations.

Calculating Final Cash Flow

  • Final cash flow for this period is determined by summing up current period's caja (cash) with current period's banco (bank).
  • By following these steps, we obtain a final cash flow value of 197.

Importance of Cash Flow Statement

The speaker emphasizes the importance of the cash flow statement for decision-making purposes.

Importance of Cash Flow Statement

  • The cash flow statement is crucial for making informed financial decisions.
  • It provides valuable insights into various operations and whether they result in an increase or decrease in cash flow.
  • Viewers are encouraged to subscribe to the channel for more videos on finance and accounting concepts.

Timestamps have been associated with relevant bullet points to help navigate through the transcript.

Turn any video into a summary like this

YouTube links, meetings, lectures. With transcripts, search, and chat.

Video description

En el siguiente video explicamos como elaborar el estado de FLUJOS DE EFECTIVO, uno de los cuatro estados financieros básicos de la contabilidad. Este video está basado en la NIF B2 de la Normas de Información Financiera, mismas que están basadas en las Normas Internacionales de Información Financiera. El estado de Flujos de efectivo se divide en 3 principales rubros: Actividades de Operación Actividades de Inversión Actividades de Financiamiento Este Estado de Flujos de Efectivo permite conocer el destino y origen del dinero que generalmente se encuentra en las cuentas de bancos y cajas. Para poder entender este estado de resultados, es importante se tengan previos conocimientos de estados financieros, tales como el Balance General o el Estado de Resultados. ✔️ Descarga el excel para hacer tu propio estado de flujos de efectivo: https://bit.ly/2mCUkkH 🔴Balance General: https://bit.ly/2GF0wyN 🔴Estado de Resultados: https://bit.ly/2mEaB8S 🔴Estados Financieros en Vertical: https://bit.ly/2lH7Ovt 🔴Balanza de Comprobación: https://bit.ly/2GCaqmc #FlujosDeEfectivo #Contabilidad Suscríbete a nuestro canal: https://www.youtube.com/contadorcontado?sub_confirmation=1 Visita nuestra página: https://contadorcontado.com/ Síguenos en Facebook: https://www.facebook.com/ContadorContado ¿Tienes dudas? Déjanos tu comentario. 10:54: Balance general sin ser estado financiero vertical 11:27: Balance general en modo de estado financiero vertical 11:38: Estado de resultados 20:22: Balance general en modo de estado financiero vertical con entradas y salidas de dinero 32:40: Papel de trabajo de flujos de efectivo (Método Directo) 38:51: Estado de flujos de efectivo sin considerar la depreciación 42:15: Estado de flujos de efectivo considerando la depreciación (Método Indirecto) Track: Arensky - Balade Free Download / Stream here: http://www.arenskymusic.com/balade/ Arensky: https://www.youtube.com/c/Arenskymusic https://open.spotify.com/artist/4FOWaU8YpEU4SsLMMxVeza https://soundcloud.com/arenskymusic https://www.facebook.com/arenskymusic/ https://twitter.com/arenskymusic Moorea: https://soundcloud.com/mooorea https://www.facebook.com/mooorea/