Term Paper Fin301
Term Paper Fin301
Term Paper Fin301
Horizontal analysis
Horizontal analysis looks at financial data throughout various time periods to find trends and
changes in the performance of an organization across time frame lines.
The financial performance of Crown Cement PLC is compared between 2020 and 2021 using the
horizontal analysis. The analysis will display the percentage change in each financial item over
the determined period.
Formula:
Percentage Change = [(Current Year (2021) - BaseYear (2020)) / Base Year (2020)] × 100
These tables represent horizontal analysis for Crown Cement PLC for the years 2020 and 2021.
The calculations indicate significant changes in several key areas, providing insights into the
company's financial health and performance.
Examining the balance sheet of the company and comparing its financial records for the years
2020 and 2021 reveals some interesting trends.
Non Current Assets: Property, Plant, and Equipment (PPE) non-current assets rose BDT 590.09
million (8.53%). The primary causes of this were new expenses spent on assets like machinery
and buildings. The Right-of- Use (RoU) assets rose BDT 3.99 million, or 1.29%, over last
month. This shows the rented assets' stability. Recording a 43.64% drop in the Capital Work in
Progress (COPI), the total came to BDT 342.75million. This could point to a slowing down in
the rate of newly proposed capital projects or completion of some current ones. The BDT 5.08
million (16.01%) rise in the value of intangible assets most likely results from the acquisition of
software, patents, and brands. The rise in total non-current assets of BDT 256.42 million (3.19%)
points to mostly moderate long-term investment growth. Moreover, investing in companies and
subsidiaries dropped BDT 49.79 million, or 15.04 percent referring to the sale of subsidiary
stakes or a fall in the shares of linked companies.
Current Assets: The value of the shares dropped to BDT 16.36 million (-26.78%) maybe from
the sale of equity stakes . Moreover, the BDT 80.34 million (4.76%) rise in inventory could point
to extra stock kept in case sales rise or volume decreases. A large BDT 1.12 billion (40.13%)
increase in trade and other receivables means either a drop in revenue collection or a rise in
credit sales. Intercompany Receivables dropped BDT 308.23 million (96.55%), maybe indicating
faster payment of intercompany transactions. Furthermore, better cash management brought
down deposits, advances, and prepayments by BDT 2.42 billion (-85.03%).
BDT 1.71 billion ( 234.56%) saw a rise in advance income tax. Increased expected tax
obligations or more tax prepayment could have been the causes of this rise. With a notable
increase of BDT 1.34 billion (787.27%), fixed savings and other short-term investments show
that people are better in handling their money. As its cash and cash equivalents climbed BDT
201.75 million (118.63%), the company grew more liquid. The fact that the overall current assets
grew by BDT 1.89 billion (21.92%) suggests improved control of working capital and liquidity
levels.
The company’s total assets climbed BDT 2.09 billion (12.33%), suggesting a constant rise in
asset base.
Equity: The Share Capital and Share Premium still show that no further shares have been issued
or capital structure changes have been done. Either more dividend payments or lower earnings
could have caused a BDT 729.64 million (-28.24%) drop in net retained earnings. The
Revaluation Reserves also dropped BDT 207.34 million (-25.96%), most likely in line with
changing asset values. As such, Total Equity dropped BDT 936.97 million (11.98%). Given this
shows a drop in shareholder equity, this should raise some worry.
Non-Current Liabilities: The employee benefits (gratuity) debt dropped by BDT 23.02 million
(-10.41%). This shows a drop in staff-related debt. Rising Long-Term Borrowings by BDT
680.72 million (484.32%) show that the country is depending more and more on debt funding.
Long-term leasing agreements grew in number, which raised asset obligations by BDT 29.72
million (139.22%), most likely owing to changes to the tax code and bookkeeping practices, the
amount of unpaid taxes climbed by BDT 90.97 million (14.75%). The main reason for the BDT
778.38 million (77.88%) rise in total Non-Current Liabilities was a notable rise in long-term
debt.
Current Liabilities: The rise in Short-Term Loans of BDT 2.87 billion (48.46%) shows that the
company depends mostly on short-term debt to run. The better current debt management helped
the Long-Term Borrowing (Current Portion) drop by BDT 156.11 million (20.69%). The Trade
and Other Payables category's BDT 156.15 million (-22.82%) dropped, signifying better control
of supplier payments. With a BDT of 62.68 million, Intercompany Payables—that is, newly
acquired linked company obligations—were first recorded in 2021. The allowance for tax
liabilities dropped BDT 266.12 million, or -71.01%. Early tax payments most certainly had a part
in this. The rise in short-term and intercompany loans accounted mostly for the BDT 2.25 billion
(27.61%) rise in total current liabilities.
Total Liabilities have risen by BDT 3.03 billion (33.9%), signifying a debt growth. This debt
originates with both long-term and short-term borrowing.
Lastly, from BDT 52.69 in 2020 to BDT 46.38 in 2021, the Net Asset Value (NAV) per share
dropped by 6.31 BDT (11.97%), therefore lowering the value of owners' shares.
Although the company's total assets grew, its equity dropped. This was mostly caused by
declining revaluation reserves and kept earnings. The rise in current and non-current obligations
suggests that individuals are leaning more and more on debt, which if improperly controlled
could be dangerous. Although more cash on hand is a benefit, should debt keep rising and net
asset value per share drop, the company might have financial problems down the road.
Maintaining stability could call for better study of income-generating and dividend-paying
strategies.
Between 2020 and 2021 revenue fell BDT 2.44 billion (-14.95%). This significant drop points to
declining sales brought on by operational, financial, or demand issues. Although the cost of sales
ffell by BDT 1.79 billion (-12.74%), not sufficient to offset income loss. Gross profit margin of
Crown Cement PLC dropped. Moreover, Total Income Gross profit fell BDT 647.54 million
(-28.71%). The company battled to turn a profit as expenses did not match declining revenues.
Other Operating Income/Expense dropped BDT 94.37 million (-130.39%). This negative trend
indicates either unanticipated expenses or lost money from other operations performed by the
business. Administrative expenses increased by BDT 22.66 million (9.89%), despite a drop in
income, suggesting operational costs that would point to possible overhead management
inefficiencies. Selling and Distribution Costs dropped by BDT 13.05 million (-2.38%). Operating
profit dropped by BDT 751.52 million (-48.45%) from year before. Reduced gross profit and
increased administrative expenses in this fall affects the profitability. Though it grew really well,
non-operational income fell short of operational profit by BDT 24.18 million (195.08%).
Furthermore, the BDT 431 million (76.77%) rise in the company's financial expenses points to
higher borrowing or interest rates. This limited profitability. Perhaps in response to better deposit
or investment returns, financial income doubled to BDT 58.39 million (111.17%) from the
previous year. Rising loan costs, however, surpassed this. Tax and Net Profit/(Loss) Before
WPPF saw a profit of BDT 1.05 billion in 2020 however 2021 was a deficit of BDT 844.92
million. This loss swing points to problems both financially and logistically. Worker Profit
Participation Fund WPPF is based on profitability, so the allocation dropped by BDT 4.89
million (-9.73%), so lowering earnings. The company's pre-tax loss in 2021 was BDT 890.25
million following a profit in 2020 of BDT 1.0 billion. This is a main sign of business collapse.
Lowering of taxable profits or losses could help to explain the BDT 32.67 million (-65.63%)
income tax expenditure drop. Deferred and income tax expenses Increased the loss by BDT
99.38 million (-139.66%) reversing deferred tax income from BDT 71.16 million in 2020 to
BDT 28.22 million in 2021. From 2020's BDT 859.22 million profit to 2021's BDT 94.37
million loss, a BDT 953.59 million (-111.00%) reduction results. This change from profit to loss
exposes the financial issues of the business. This section's other comprehensive income showed a
BDT 104.23 million loss in 2021, compared to a BDT 859.22 million profit in 2020, suggesting a
similar shareholder value decline. From BDT 5.79 in 2020 to BDT 0.89 in 2021, earnings per
share dropped significantly, losing BDT 6.68 (-115.37%), The significant decline in EPS reveals
how negatively shareholder profitability suffers.
Overall, The company suffered in 2021 with a sharp decline in operating profit, gross profit, and
income. High financing costs and declining sales generated the year-over-year net loss even with
growing non-operational and financial income. The sharply declining profitability and earnings
per share point to financial difficulties for the company. To rebuild, it has to control expenses,
increase output, and maybe reduce debt.
The financial performance of Crown Cement PLC is compared between 2022 and 2023 using the
horizontal analysis. The analysis will display the percentage change in each financial item over
the determined period.
These tables represent horizontal analysis for Crown Cement PLC for the years 2022 and 2023.
The calculations indicate significant changes in several key areas, providing insights into the
company's financial health and performance.
Total assets grew by 27.75%, mostly as long-term investments greatly expanded. The number of
right-of- use assets increased by 656%, while the number of capital projects under progress grew
by 200%. In contrast, cash struck by almost 300% while short-term investments like FDRs
dropped by 64%. A 23% rise in retained earnings generated a small rise in equity, at 6.18%. The
company maintained more of its income this year. The debt load grew shockingly by 42.62%. A
sudden increase in borrowing and lending set most of the developments in motion. Long-term
debt increased above 2,200%. This suggests that the company acquired a lot of debt largely for
long-term needs. People already pay significantly more taxes—more than twice as much. Along
with short-term loans and taxes payable, current expenses grew along with roughly 34%
increase. Trade payables, however, dropped a modest yet almost 10%.
Ultimately, the company increased its assets and retained more of its income during the year, but
it also acquired a lot more debt.
Revenue growth shown by a 26.36% rise in revenue despite a 16.36% rise in the cost of sales.
Consequently, the net profit grew by 136.53%, more than doubled, proving that the company was
benefiting more from its major operations. Operations brought an amazing 246.58% rise in
income. Though marketing and distribution expenses of 14.87% and operational costs of 4.22%,
increased sales and a 122.43% gain in mother vessel operations revenue were the main factors of
this. A rise in finance charges of 75.68% caused net finance costs to rise dramatically, by
80.80%. Still, the great operational performance balances these higher costs. The company's
profit before taxes increased by over 800%, indicating a significant increase in revenue over the
previous year. Through a rise in income tax expenses of 150.31%—more than twice as
much—the company generated a good profit of BDT 610 million instead of losing BDT 229
million in the previous year. The company's whole income also clearly increased from a deficit
to a comfortable profit. This suggests the Crown Cement PLC is starting to bounce back and that
its finances are becoming better.
Ultimately, the business made a profit by sharply increasing sales and earnings even if financing
and taxes cost more.
Vertical Analysis
On the other hand, vertical analysis shows every aspect of a financial statement as a percentage
of the whole. For instance, the statement of financial position reports all asset items as a
percentage of the total assets. Additionally, each item in the income statement is represented as a
percentage of the total income.
Both the Statement of Financial Position and the Statement of Profit or Loss for 2020 and 2021
will reflect every line item as a percentage of the total based on this analysis.
Formula:
Percentage of Base Figure = (Item Value / Base Figure) × 100
These tables represent vertical analysis for Crown Cement PLC for the years 2020 and 2021. The
calculations indicate significant changes in several key areas, providing insights into the
company's financial health and performance.
Examining the situations for 2020 and 2021 shows notable swings:
From 40.69% of total assets in 2020 to 39.32% in 2021, the percentage of property, plant, and
equipment (PPE) investment dropped. This shows a degree of consistency, although with a small
change away from tangible assets. The capital work under progress dropped noticeably,
suggesting that the company either stopped funding some projects or cut new budgets. Rising
trade receivables from 16.49% to 20.57% point to more client debt to the company. This could
be due to either the longer lead times for returns or the higher credit sales. More assets allocated
toward short-term investments and advance income tax suggests that the business is improving
cash flow and getting ready for next tax payments. Rising borrowing needs and lower levels of
savings indicate possible financial challenges for the company as seen by the drop in owner's
equity from 46.05% of total assets in 2020 to 36.08% in 2021. The significant rise in long-term
borrowing points to the company leaning more and more on debt as a long-term source of
finance. From 34.85% to 46.08% the significant rise in current liabilities—especially short-term
loans—indicates that the business might be depending more and more on short-term debt to run
its operations. Neglect of the company to pay these debts could point to a possible danger.
Early-year payments could help to explain part of the drop in provisions for tax obligations.
From BDT 52.69 in 2020 to BDT 46.38 in 2021 the Net Asset Value (NAV) per share dropped.
The primary cause of this decline was the increase in loans and the decrease in retained earnings,
resulting in a reduction in shareholder value. The company depends so much on debt, especially
short-term loans, so there is more possibility for financial risks if not properly regulated. Despite
the improvement in liquidity brought about by higher cash and short-term investments, the drop
in shareholder ownership and net asset value per share points to financial challenges for the
company. Future stability in the future years depends mostly on better debt management and
higher income.
Cost of sales rose from 86.18% in 2020 to 88.42% in 2021. The company's main activities are
less profitable due to more manufacturing expenses. From 13.82% to 11.58% this lowered the
gross profit margin. This indicates the company is losing money. Operating profit of the
company fell from 9.49% in 2020 to 5.76% of revenue in 2021. This indicates that Crown
cement plc is losing profitability as rising administrative and selling expenses overwhelm it.
Administrative expenses climbed from 1.41% to 1.82% of income; selling and distribution costs
jumped from 3.36% to 3.85%. The company's bottom line suffers from more operations,
marketing, and managerial expenses. One significant shift was the explosive increase in finance
expenses from 3.44% to 7.15% of income. Higher debt or interest rates most likely explain this
increase that compromises the company's financial situation. Financial performance dropped for
the company. Its 2020 net profit before tax was 6.16%, but its 2021 loss was -6.42%. The
business recorded a net loss of -0.68% of revenue after taxes, down from 5.36% in 2020.
Overall, rising administrative, financial, and manufacturing expenses have hurt the company's
profitability. Rising finance costs brought on by growing debt dependency are affecting profits.
From earning money in 2020 to losing money in 2021, the company requires improved debt
management and expenditure control to fix its situation.
These tables represent vertical analysis for Crown Cement PLC for the years 2022 and 2023. The
calculations indicate significant changes in several key areas, providing insights into the
company's financial health and performance.
Given its large debt load—that is, 66% of its assets—debt represents a lever for the corporation.
Well-managed debt could produce possible reward as well as higher risk.
2022-2023
Particulars (BDT) % of Total Revenue
Revenue 24,183,479,554 100.00%
Cost of sales -20,418,664,027 84.42%
Gross profit 3,764,815,527 15.58%
Income from mother vessel 93,690,295 0.39%
Administrative expenses -271,147,546 1.12%
Selling and distribution exp. -581,699,874 2.41%
Operating profit 3,005,658,403 12.43%
Non-operating income 6,818,923 0.03%
Finance cost -1,372,945,712 5.68%
Finance income 38,528,919 0.16%
Net finance expenses -1,327,597,870 5.49%
Profit before contribution to WPPF 1,678,060,533 6.94%
Contribution to WPPF -79,907,644 0.33%
Profit before income tax 1,598,152,888 6.61%
Share of profit from associates 40,214,356 0.17%
Profit before income tax 1,638,367,245 6.77%
Income tax expenses -1,027,921,043 4.25%
Profit for the period 610,446,201 2.52%
Other comprehensive income -2,916,852 -0.01%
Total comprehensive income 607,529,349 2.51%
The manufacturing sector accounted for 84.42% of the company's total sales, or 15.58% of its
total sales. These numbers reveal that although the company's operations produce a good profit,
its manufacturing costs are somewhat high.Crown Cement PLC is clearly controlling its
overhead expenses since administrative and marketing charges only make 3.53 percent of the
whole income. Operating profit is the portion of income retained by the corporation after
deducting production and operating costs. These results show how effectively operations were
run overall.Interest and other financial outlays account for 5.68 percent of the company's income.
This degree of debt suggests that obligations are influencing income. After subtracting all of its
taxes and expenses, the corporation maintains 2.52% of its revenues as profit. This number
shows that the business is lucrative, hence it is positive even if it is not especially high.Though
they don't greatly affect the end result, little changes are done to non-operational parts. Crown
Cement PLC usually makes a profit even if borrowing is somewhat expensive. Cutting these
costs could boost the company's earnings.