Estado de Situación Financiera paso a paso en Excel (PLANTILLA GRATIS)
Introduction and Overview
In this video, Felipe will guide us through the process of creating a financial statement in Excel called the "Estado de la Situación Financiera" or Balance Sheet. He will provide step-by-step instructions and a downloadable template for free.
Understanding the Balance Sheet
The balance sheet, also known as the "Estado de la Situación Financiera," is a financial statement that shows what assets a company possesses and how it financed them. It begins with the name of the company, type of business entity, and the date of the information.
- The balance sheet is commonly prepared as of December 31st each year.
- The header should include the currency being used (e.g., pesos, dollars, euros) and how amounts are expressed (e.g., millions).
Organizing Current Assets
Current assets are resources that can be easily converted into cash within one year. They include cash, accounts receivable, and inventory.
- List current assets in order of liquidity, from most liquid to least liquid.
- Use columns to record account names and their respective values.
- Sum up all values to calculate total current assets.
Organizing Non-current Assets
Non-current assets are resources that a company owns but expects to use for more than one year. Examples include buildings, machinery, and vehicles.
- There are two ways to organize non-current assets: by value or by useful life.
- Include accumulated depreciation as a separate line item.
- Depreciation represents the decrease in value over time.
Calculating Total Assets
After listing all current and non-current assets, calculate the total assets.
- Sum up the values of current and non-current assets separately.
- Use formulas in Excel to calculate the sum automatically.
Organizing Liabilities
Liabilities represent a company's debts or obligations. They can be classified as current or non-current liabilities.
- List current liabilities first, followed by non-current liabilities.
- Examples of current liabilities include accounts payable and short-term loans.
- Examples of non-current liabilities include long-term loans and bonds payable.
Calculating Total Liabilities
After listing all current and non-current liabilities, calculate the total liabilities.
- Sum up the values of current and non-current liabilities separately.
- Use formulas in Excel to calculate the sum automatically.
Determining Equity
Equity represents the ownership interest in a company. It is calculated as the difference between total assets and total liabilities.
- Subtract total liabilities from total assets to determine equity.
- Equity can be further divided into contributed capital and retained earnings.
Finalizing the Balance Sheet
Once all sections are completed, finalize the balance sheet by reviewing for accuracy and ensuring that debits equal credits.
- Double-check all calculations and formulas.
- Verify that debits equal credits to ensure accuracy.
- Make any necessary adjustments before finalizing the balance sheet.
Understanding the Balance Sheet
In this section, the speaker explains how to calculate and understand the balance sheet. The focus is on the assets, liabilities, and equity sections of the balance sheet.
Calculating Total Assets
- To calculate total assets, add up the values of current assets and non-current assets.
- Current assets are those that can be converted into cash within a year.
- Non-current assets are those that have a longer lifespan.
Understanding Liabilities
- Liabilities refer to all debts or financial obligations that a company must pay to its creditors.
- Current liabilities are debts that need to be paid within a year.
- Examples of current liabilities include accounts payable, short-term financial obligations, and various creditors.
- Non-current liabilities are debts with payment periods longer than one year.
- Examples of non-current liabilities include long-term financial obligations such as loans from banks or shareholders.
Exploring Equity
- Equity represents the ownership interests in a company held by its owners or shareholders.
- It includes initial capital contributions made by owners as well as retained earnings from previous periods.
- Common accounts found in equity include capital, legal reserves, other reserves, revaluation of equity, profits or losses from previous years, and valuations.
Calculating Total Liabilities and Equity
- To calculate total liabilities and equity, sum up the values of total liabilities (current and non-current) and equity sections.
Finalizing the Balance Sheet
In this section, the speaker concludes the explanation of how to finalize the balance sheet by calculating total liabilities and equity.
Calculating Total Liabilities and Equity
- Add up the values of total current liabilities with total non-current liabilities to obtain total liabilities.
- Sum up all accounts in the equity section to determine total equity.
Obtaining Total Assets
- To verify the accuracy of the balance sheet, compare the total assets with the sum of total liabilities and equity.
- The total assets should be equal to the sum of total liabilities and equity.
Formatting and Presentation
- Customize the balance sheet template by adding colors and formatting options.
- Ensure that all necessary signatures are included for legal and auditing purposes if required.
Conclusion
The transcript provides a comprehensive explanation of how to calculate and understand a balance sheet. It covers topics such as calculating total assets, understanding liabilities, exploring equity, and finalizing the balance sheet. The speaker emphasizes the importance of accurately representing a company's financial position through proper calculations and presentation.