Financial Statement Preparation Guide
Financial Statement Preparation Guide
Section A
1. Below is a list of accounts with their corresponding balances.
to determine the following:
a) The total overhead costs.
b) The operating profit.
c) The overall financing result
Total, Gastos
Generals = $ 759,590,000.00
INCOME STATEMENT
The integral result of
Service Income $5,807,600
Commissions 0 financiamiento:
Gross Utility $5.807.600
General Expenses $ 759.590,00
Operating utility $ 5,048.01
Integral Result of
Financing 0
Participation in
associations 0
Tax on profit 0
Utility before
operations
discontinued $5.042.961,99
Net Utility $5.042.961,99
2. Soluciones Efectivas, S.A. is a company that offers consulting services in
administration. The following is information for the quarter from April to June of
year 2012:
Efectvas S.A
INCOME STATEMENT
April 1 to June 2012
Service Income $25,340,000
Commissions 0
Operational income $25.340.000
Salary $7,950,000.00
Propaganda
0
Services 0
Other Expenses $761.500
Operational expenses $8.711.500,00
Interests $48,450.00
Result before tax $8.663.050,00
Tax $260.120,00
net utility $8.402.930,00
Efectvas S.A
INCOME STATEMENT
from January 1 to December 31, 2012
Sales $900.322.000
Cost of sales 360000000
Operational income $540,322,000
Salary $7.400.000,00
administrative expenses
$12,500,000
sales expenses $1,860,000
Other Expenses $2,148,160
Operational expenses $23.908.160,00
Interests $450.000,00
Result before tax $23.458.160,00
Tax $21.780.000,00
net utility $1.678.160,00
4. With the listed balances, prepare the financial position statement accordingly.
classification of the company Advanced as of March 31, 2012.
Advanced Company
STATEMENT OF FINANCIAL POSITION
as of March 31, 2012
ACTIVE PASSIVE
CURRENT ASSET Salaries payable $ 235.800
CASH AND EQUIVALENT Mortgage payable $ 3,500,000
Securities and banks $ 2,765,340 Impuestos por pagar $ 4.200.000
Accounts receivable $ 1.345.000 Various creditors $1,378,900
Inventory $ 3,345,000 Dividends payable $ 300,000
Clients $ 400,000 TOTAL, PASIVOS $ 9.614.700
PROPERTY, PLANT AND EQUIPMENT HERITAGE
Transport team $ 1,325,000 Social capital $ 837.400
Land $ 6,500,000 Withheld utilities $ 7.928.240
Office furniture $ 2,700,000 TOTAL, PATRIMONIO $ 8.765.640
5. With the information provided by the company Diamante, corresponding to the period
understood between January 1 and March 31, 2012, prepare the statement of variations
in the corresponding equity capital:
Share capital as of January 1, 2012 $10,000,000
Contributions from partners $ 1 500 000
Reimbursements of contributions to partners $1,000,000
Retained earnings as of January 1, 2012 $23 240 000
Net profit for the period $2,875,200
Declared dividends $1,200,000
7. Abarrotes Doña Lupita presents the following balances in its accounts as of September 30
from 2012:
Sales $ 15 776 000 Total sales expenses $ 1,530,000
Cost of sales $6,875,400 Taxes $ 1 751 210
Total administrative expenses $ 3 500 000 Interests $126,000
Dividends $1,000,000 Registered trademark $ 700 000
Inventory $9,112,000 Salaries payable $ 850 800
Social capital $5,000,000 Land $2,500,000
Dividends payable $ 500 000 Computing equipment $ 2 130 000
Retained earnings $ 7 892 030 Cash and banks $12,126,980
Bank loan (3 months) $ 1,400,000 Suppliers $ 8,789,000
Building $ 5 300 000 Hipoteca por pagar (5 años) $ 2 500 000
Various creditors $2,438,760 Office furniture $ 2 700 000
Transport team $ 895 000 Taxes payable $ 5 100 000
Additional information:
1. The balances of the income, cost, and expense accounts correspond to the period
understood between July 1 and September 30, 2012.
2. The balance of the share capital account was obtained considering that during the period of
From July to September, there were contributions from members totaling $500,000, and there were none.
refunds of contributions.
The balance of the retained earnings account does not yet account for the net income of the period.
not the declared dividends.
a) Prepare the income statement for Abarrotes Doña Lupita corresponding to the period of
July 1 to September 30, 2012.
Contemporary Furniture Store
INCOME STATEMENT
from January 1 to December 31, 2012
sales $15,776,000
Cost of sales 6875400
Operational income $540,322,000
salary $850.800,00
administrative expenses $0
sales expenses $0
Other Expenses $0
Operational expenses 23,908,160.00
Interests $126.000,00
Result before tax $23.458.160,00
Tax $1,751,210.00
net utility $1.678.160,00
SECTION B
1. Below is a list of accounts with their corresponding balances for
that determines
the following:
a) The total general expenses.
b) Operating profit.
c) The integral financing result.
Rent $ 55 000
Salaries $ 385 000
Income from services $ 6 240 000
Telephone service $18,200
Electric energy $24,900
Loss due to exchange rate fluctuations $ 14 700
Advertising $75,000
Depreciation of transport equipment $ 8 400
Insurance expenses $12,100
Office supplies expense $ 8,350
Depreciation of office furniture $23,000
Interest expense $ 12 500
Income - Expenses
Operating Utility = Administration, sales, $5.661.450,00
Financial
INCOME STATEMENT
Service Income $6,240,000
Commissions 0
Gross Utility $5.807.600
General Expenses $578.550,00
Operating utility $5.661.450,00
Integral Financing Result $ 31.400
Participation in associations 0
Tax on profit $6.271.400,00
Profit before operations
discontinued
Net Utility $463.800,00
$ 12 590
Income from services 000
Management salaries $1,200,000
Employee salaries $ 930 000
Expense for materials $ 860 000
Rent $ 210 000
Insurance $ 95 000
Telephone service $3,400
Electric energy $52,800
Depreciation of equipment $48,200
Interests $30,000
Taxes $ 108 230
Prepare the income statement of Quality Impressions for the third quarter of the year
2012.
Quality, Inc.
INCOME STATEMENT
April 1 to June 2012
Service Income $12,590,000
Commissions 0
Operational income $25.340.000
Salary $1.200.000,00
Propaganda 0
Services 0
Other Expenses $1.269.400
Operational expenses $8,711,500.00
Interests $30.000,00
Result before tax $8.663.050,00
Tax $108.230,00
net utility $8.402.930,00
Prepare the income statement for Mueblería Contempo for the fourth quarter of the year.
2012.
Sales $215.650.000
Cost of goods sold 83427500
Operational income $540.322.000
Salary $0,00
administrative expenses $5.608.240
4. With the listed balances, prepare the financial position statement accordingly.
classified of the company La Suprema as of June 31, 2012.
Various debtors $800,000 Salaries payable $ 230 500
$ 15 000
Share capital 000 Land $ 3 250 000
Insurance paid in advance $ 750 000 Documents payable (6 months) $ 1 500 000
Dividends payable $1,200,000 Accounts Receivable $2,680,000
Retained earnings $6,117,910 Cash and banks $ 3 895 310
Payable obligations $5,000,000 Mortgage payable $2,500,000
Building $12,500 Suppliers $2,567,400
000
Various creditors $970,000 Office furniture $ 1 780 000
Transport team $ 3 800 000 Taxes payable $ 1 350 000
Company La Suprema
STATEMENT OF FINANCIAL POSITION
as of March 31, 2012
ACTIVE PASSIVE
$
CURRENT ASSET Insurance paid in advance 750,000
CASH AND EQUIVALENTS Accounts payable $ 5,000,000
$
Effect and banks $ 3,895,310 Salaries payable 230.500
Accounts receivable $ 2.680.000 Suppliers $ 2.567.400
PROPERTY, PLANT AND EQUIPMENT Taxes payable $ 1,350,000
Edificio $ 12,500,000 Documents payable (6 months) $1.500.000
Transport team $ 3.800.000 Mortgage payable $ 2,500,000
Office furniture $ 1,780,000 TOTAL LIABILITIES $ 13.897.900
Land HERITAGE
Social capital $ 3.439.500
Retained utilities $ 6.117.910
Dividends payable $1,200,000
TOTAL ASSET $ 10.757.410
$
TOTAL ASSETS $ 24.655.310 TOTAL LIABILITIES + EQUITY 24,655,310
5. With the information provided by the company Aries, corresponding to the period
understood between July 1 and September 30 of 2012, prepare the report of
variations in the equity capital corresponding to:
Share capital as of June 30, 2012 $15,000,000
Contributions from partners $ 4 000 000
Reimbursement of contributions to partners $ 2 500 000
Retained earnings as of June 30, 2012 $32,635,000
Net loss for the period $ 991 340
Declared dividends $2,000,000
EXERCISE
STATEMENT OF CHANGES IN EQUITY WITH TABLE
SOCIAL CAPITAL TOTAL, SHARE CAPITAL
RETAINED EARNINGS
Initial Balance $15.000.000 $32,635,000 $47.635.000
INCREASES
Utility of the exercise -$991,340.00 -$ 991.340
Disminuciones
Dividend Payment $2,000,000 $ 2,000,000
$2
Final Balance $15,000,000 9.643.660 $44.643.660
a) Prepare the income statement of Antigüedades El Uro for the year 2012.
Income from services $ 33 985 000 Total general expenses $ 31 530 000
Additional information:
1. The balances of the income, costs, and expenses accounts correspond to the period
understood between January 1 and December 31, 2012.
2. The balance of the share capital account was obtained considering that during the period of
From July to September, there were no contributions from members; however, refunds were made to
partners for a total of $800,000.
3. The balance of the retained earnings account does not yet consider the net loss for the period.
nor the declared dividends.
a) Prepare the income statement of Clean and Quick for the year 2012.
Clean and Quick
INCOME STATEMENT
April 1 to June 2012
Commissions 0
Operating income $25,340,000
salary $850,800.00
propaganda 0
Services 0
Other Expenses $11.820.000
Operating expenses $8.711.500,00
Interests $1.580.000,00
Result before tax $8.663.050,00
Tax $2.314.670,00
net utility $8.402.930,00
b) Prepare the statement of changes in equity for Clean and Quick for the year 2012.
STATE OF CHANGES IN EQUITY WITH TABLE
TOTAL CAPITAL
SOCIAL CAPITAL
SOCIAL
RETAINED UTILITIES
INCREASES
Decreases
c) Prepare the financial position statement of Clean and Quick as of December 31, 2012.
$7.
TOTAL, PATRIMONIO 253.700
$2
TOTAL, ASSETS $20.585.970 TOTAL, LIABILITIES + EQUITY 0.585.970
Business vision
1. The financial statements summarize the information of the businesses and are used for decision-making.
Novacero S.A
its profitability is intermediate, as it has financial flexibility to meet the payment
financial spending report, which has historically been covered by EBITDA in
an average of 3.5 times in the year 2018. It is expected that this indicator will remain at least
at similar levels in the coming years, it should be noted that it has been improving in the
last years thanks to the investments made by the company in automation of
processes and technology. It is also clear that thanks to the growth of capacity
production (economies of scale), the company has managed to reduce the unit cost by
general of the products.
According to the Cemex 2008 annual report, that year was extremely complex.
unprecedented financial and economic crisis that began in the United States spread to
Europa, Asia y otras regiones, afectando a empresas e industrias enteras en todo el mundo.
Response
As a result, at Cemex, after having recorded an average growth
above 10% for more than a decade, their results were below the
objectives originally set for the year. However, the company managed to compensate
partially the increase in costs and the effects of the economic slowdown
in the United States, Spain, and the United Kingdom. According to the president of the Council of
Cemex's management, operating cash flow decreased by 5%, to 4,343 million.
de dólares.
Visit the company's website, check the annual reports, review the financial statements.
financial and analyze what the main actions taken by the company were that
they helped obtain the previous results and stay in the market.
Response
The financial statements of those subsidiaries whose functional currency corresponds to a
A country subject to high inflation will be restated to reflect inflation. The
determination of whether a country is in a period of high or low inflation is carried out in
at the end of each year, and inflation is applied as appropriate. As of December 31
2007, except for Venezuela and Costa Rica, all of CEMEX's subsidiaries
they operated in countries during periods of low inflation; therefore, the reexpression was suspended
from historical costs in their financial statements to consider inflation starting from the 1
January 2008. Starting in 2008, the NIF B-10 eliminated the re-expression of the statements.
financial statements for the period, as well as the comparative financial statements for the periods
prior to constant values with respect to the date of the most recent financial statement. To
end of the year 2008, the figures that appear in the income statement, cash flow statement
Cash and statement of changes in financial position are presented in nominal figures;
meanwhile, the figures from the financial statements for previous periods are presented in
constant pesos as of December 31, 2007, the last date on which the accounting
inflationary was applicable. Until that date, this index was calculated based on the rates of
inflation in the countries where we operate and in the fluctuations of exchange rates
each of those countries.
4. Analyzing the risk factors of FEMSA. The Coca-Cola FEMSA business depends
of its relationship with The Coca-Cola Company. Changes in this relationship may affect
adversely affect the results of operation and financial position. Visit the page of
FEMSA, review the latest annual report presented, and answer the following:
The risks would be significant since the two organizations are responsible for
correct handling of raw materials, efficiency in water use in our plants. access to
water, sanitation in our communities, replenishment and water funds. Due to
that our relationship with The Coca Cola Company represents 12% of the sales volume
global of the Coca-Cola System, which consolidates us as the bottler and
largest beverage marketer in the world by sales volume. In this way
they are focused on meeting the needs of clients and consumers, through
building a winning portfolio, from the transformation of our operational models
and the evolution of our culture, we serve more than 290 million people and 2
millions of points of sale, through 48 bottling plants and 297 centers of
distribution in 10 countries in Latin America, covering certain territories in Mexico,
Brazil, Guatemala, Colombia, Argentina, and at the national level, in Costa Rica, Nicaragua,
Panama, Uruguay and Venezuela.
By combining the efforts of The Coca-Cola Company and Coca-Cola FEMSA this year,
a total of 735 evaluations were conducted on suppliers. All our new suppliers
In Mexico, Costa Rica and Nicaragua have been evaluated based on these criteria and
we continue to work to generate improvement action plans. Because Coca-Cola
FEMSA is part of The Coca-Cola Company's System.
of its type that is listed on the market, which makes its business model even more attractive.
This shows that despite the uncertainty that may exist at a market level or
macroeconomic, a solid company, with a successful track record and viable projections
it can generate appetite for the company in the market, resulting in an IPO
successful.
8. Visit the website of the Mexican Stock Exchange, select one of the
stations that list their values in that market, locate the section where it presents its
financial statements and analyze the content of the information included in the statement of
most recent cash flows.
Response
the operation of a new entity within the Mexican Capital Market has begun,
which was called Market Maker, which is a Brokerage House authorized by the
Mexican Stock Exchange whose objectives are to provide liquidity, price stability through the
permanent presence in the market and promote liquidity in the secondary market
through the promotion of a continuous transactional flow. An important factor is that the
Brokerage House intervenes in operations with its own resources to promote liquidity,
establish reference prices and contribute to the stability and continuity of prices of a
value or a set of values.
9. Visit the website of the Mexican Stock Exchange, select any of the
companies that list their values in that market, locate the section where it presents its
most recent financial statements and analyze the content of the report where it shows the
opinion of the independent auditor.
Response
The revenues amounted to 996 million pesos, 151 million or 18% higher compared to
1T19 for three reasons: greater activity in operational businesses, related services.
to the International Quotation System (SIC) and a tax benefit in SIF Chile. • The
Expenses grew by 8% due to projects completed in 2019 that generate operating expenses.
in 2020, mainly in technology and depreciation, as well as variable compensation
due to better income in SIF ICAP. • Operating profit and net profit
they grew by 26% and 39%, respectively. • EBITDA was recorded at 607 million pesos
with a margin of 61%.
The amount financed in development capital certificates in the last 15 months has been
of 118,172 million pesos, which is broken down into: 36,459 million in real estate, 29,963
millions in private capital, 23,158 million in infrastructure, 16,821 million in energy
11.771 million in financial assets.
10. Visit the website of the Mexican Stock Exchange, select any of the
issuers that quote their values in that market, locate the section where it presents its
most recent financial statements and analyze the content of the information they include in the
notes section on expenses.
Response
The total expenses for the first quarter of 2020 were 439 million pesos, which
represents an increase of 34 million or 8% compared to the same period in 2019.
the difference in expenses is mainly explained by:
Personnel increased by 13 million pesos due to higher compensation
variable due to better income in SIF ICAP and annual salary increases.
Technology increased by 9 million pesos, with 6 million explained by the renewal.
of licenses for projects completed in 2019, acquisition of new licenses for
customer service and increase in the bandwidth of the backbone network, as well as 3
millions for the purchase of data for services related to the SIC.
Depreciation showed an increase of 6 million pesos due to the
acquisition of hardware, mainly the increase in storage (SAN)
and risk engine of Asigna, as well as the amortization of completed projects in
2019 (Infomatch, a system to monitor data usage) and improvements to
building.
Rent and Maintenance increased by 1 million pesos due to improvements to the air.
building air conditioning and improvements to the facilities in general.
Fees decreased by 2 million pesos due to non-recurring consultancies.
related to the flexible disaster recovery plan (DRP) in Q1 2019.
Another increased by 6 million pesos, provisions for 5 million in events and
promotion and 1 million for the option to purchase the remaining shares of
SIF Chile, millions of pesos or 26% above what was reported in the first quarter
from 2019.
The total financing result was 170 million pesos in the quarter.
the growth is explained by the exchange gain, mainly in the rate of
peso-dollar exchange rate.
The interest from leases was 1.3 million pesos in the quarter.
The tax rate for the quarter was 29%, in line with that of Q1 19. The profit
Net income of 1T20 reached 457 million pesos, a growth of 39% compared to the
same quarter of last year
Total liabilities grew by 67% explained by the maintenance fees of
bonds that are paid at the beginning of the year and lease liabilities.