Ratio Analysis Mapple Leaf & BestWay Cement
Ratio Analysis Mapple Leaf & BestWay Cement
Ratio Analysis Mapple Leaf & BestWay Cement
HORIZONTAL ANALYSIS
CURRENT LIABILITIES
Current portion of :
- Long term loans from financial institutions - secured
Trade and other payables
Unclaimed dividend
Mark-up accrued on borrowings
Short term borrowings
ASSETS
NON - CURRENT ASSETS
Property, plant and equipment
Intangible assets
Long term investment
Long term loans to employees - secured
Long term deposits
CURRENT ASSETS
Stores, spare parts and loose tools
Stock-in-trade
Trade debts
Loans and advances
Short term investment
Short term deposits and prepayments
Accrued profit
Other receivables
Income tax refundable
Cash and bank balances
UNCONSOLIDATED STATEMENT OF PROFIT OR LOSS FOR THE YEAR ENDED JUNE 30, 2019
Sales - net
Cost of sales
Gross profit
Distribution cost
Administrative expenses
Other charges
Other Income
Profit from operations
Finance cost
Profit before taxation
Taxation
UNCONSOLIDATED STATEMENT OF COMPREHENSIVE INCOME FOR THE YEAR ENDED JUNE 30, 2019
Profit after taxation
UNCONSOLIDATED STATEMENT OF CASH FLOWS FOR THE YEAR ENDED JUNE 30, 2019
CASH FLOWS FROM OPERATING ACTIVITIES
CURRENT LIABILITIES
Current portion of :
- Long term loans from financial institutions - secured
Trade and other payables
Unclaimed dividend
Mark-up accrued on borrowings
Short term borrowings
ASSETS
NON - CURRENT ASSETS
Property, plant and equipment
Intangible assets
Long term investment
Long term loans to employees - secured
Long term deposits
CURRENT ASSETS
Stores, spare parts and loose tools
Stock-in-trade
Trade debts
Loans and advances
Short term investment
Short term deposits and prepayments
Accrued profit
Other receivables
Income tax refundable
Cash and bank balances
UNCONSOLIDATED STATEMENT OF PROFIT OR LOSS FOR THE YEAR ENDED JUNE 30, 2019
Sales - net
Cost of sales
Gross profit
Distribution cost
Administrative expenses
Other charges
Other Income
Profit from operations
Finance cost
Profit before taxation
Taxation
UNCONSOLIDATED STATEMENT OF COMPREHENSIVE INCOME FOR THE YEAR ENDED JUNE 30, 2019
Profit after taxation
UNCONSOLIDATED STATEMENT OF CASH FLOWS FOR THE YEAR ENDED JUNE 30, 2019
CASH FLOWS FROM OPERATING ACTIVITIES
9,000,000 7,000,000
5,937,007 5,937,007
5,640,300 5,640,300
15,052,799 14,069,289
3,884,480 4,264,543
30,514,586 29,911,139 0.46 0.51 (0.09)
15,990,227 12,942,080
1,000,000 -
8,664 8,714
3,705,927 3,418,172
368,499 310,735
205,354 183,764
21,278,671 16,863,465 0.32 0.29 0.12
1,315,135 810,616
8,218,303 5,388,729
40,564 110,743
575,029 283,415
4,015,487 5,360,421
14,164,518 11,953,924 0.21 0.20 0.06
65,957,775 58,728,528 1.00 1.00 -
46,640,664 40,894,010
13,529 16,811
5,020,000 5,020,000
19,824 9,472
56,880 56,554
51,750,897 45,996,847 0.78 0.78 0.00
7,208,762 6,505,283
1,739,014 1,193,506
2,683,758 1,131,753
805,159 2,303,402
17,887 32,062
173,598 114,208
2,272 1,179
35,319 43,534
1,046,711 774,092
494,398 632,662
14,206,878 12,731,681 0.22 0.22 (0.01)
2.47 6.29
1,465,299 3,632,201
(33,620) (27,012)
8,411 6,737
(25,209) (20,275)
1,440,090 3,611,926
1,664,176 4,395,236
2,356,110 2,144,497
8,501 8,395
10,189 25,000
88,125 235,035
- 70,431
15,913 3,036
14,175 67,594
22,968 -
25,990 46,058
1,149,589 644,121
- 12,895
(19,889) (28,793)
5,335,847 7,623,505
(703,479) 245,303
(545,508) 107,729
(1,688,194) (474,227)
1,498,243 (1,468,489)
(59,390) (38,341)
8,215 217,102
(1,490,113) (1,410,923)
2,922,380 1,815,694
1,432,267 404,771
6,768,114 8,028,276
(10,352) (3,673)
(326) (80)
(50) 15
34,796 310,735
(38,020) (40,084)
(93,768) (175,916)
- (135,635)
418,939 -
(798,373) (2,393,707)
6,280,960 5,589,931
(8,220,851) (19,445,846)
(5,219) -
102,173 51,965
- (350,000)
- (21,997)
18,796 28,970
(8,105,101) (19,736,908)
3,552,666 10,648,936
1,000,000 -
- 4,241,830
- (480,615)
(1,215,654) 1,038,909
(857,975) (462,171)
(663,880) (1,804,561)
1,815,157 13,182,328
(8,984) (964,649)
(806,581) 158,068
(815,565) (806,581)
2019 2018
SALES 900 100.00% 500 100.00%
COST OF SALES 150 16.67% 100 20.00%
GP 750 83.33% 400 80.00%
IND. EXP. 400 44.44% 200 40.00%
IND. INC. 800 88.89% 600 120.00%
GP-IND. EXP+IND. INC EBITA 1150 127.78% 800 160.00%
TAX -500 -55.56% -300 -60.00%
INTREST -100 -11.11% -50 -10.00%
EAITA 550 61.11% 450 90.00%
Horizontal of vertical
0.00%
-16.67%
4.17%
11.11%
-25.93%
-20.14%
-7.41%
11.11%
-32.10%
MAPPLE LEAF CEMENT FACTORY
RATIO ANALYSIS
CURRENT LIABILITIES
Current portion of :
- Long term loans from financial institutions - secured
Trade and other payables
Unclaimed dividend
Mark-up accrued on borrowings
Short term borrowings
ASSETS
NON - CURRENT ASSETS
Property, plant and equipment
Intangible assets
Long term investment
Long term loans to employees - secured
Long term deposits
CURRENT ASSETS
Stores, spare parts and loose tools
Stock-in-trade
Trade debts
Loans and advances
Short term investment
Short term deposits and prepayments
Accrued profit
Other receivables
Income tax refundable
Cash and bank balances
UNCONSOLIDATED STATEMENT OF PROFIT OR LOSS FOR THE YEAR ENDED JUNE 30, 2019
Sales - net
Cost of sales
Gross profit
Distribution cost
Administrative expenses
Other charges
Other Income
Profit from operations
Finance cost
Profit before taxation
Taxation
UNCONSOLIDATED STATEMENT OF COMPREHENSIVE INCOME FOR THE YEAR ENDED JUNE 30, 2019
Profit after taxation
UNCONSOLIDATED STATEMENT OF CASH FLOWS FOR THE YEAR ENDED JUNE 30, 2019
CASH FLOWS FROM OPERATING ACTIVITIES
2,019 2,018
1. Liquidity Analysis
a)
9,000,000 7,000,000
5,937,007 5,937,007
5,640,300 5,640,300 b)
15,052,799 14,069,289
3,884,480 4,264,543
30,514,586 29,911,139 2. Profitability Ratio
15,990,227 12,942,080
1,000,000 - 3. Solvency
8,664 8,714 a)
3,705,927 3,418,172
368,499 310,735
205,354 183,764 b)
21,278,671 16,863,465
c)
1,315,135 810,616
8,218,303 5,388,729
40,564 110,743
575,029 283,415
4,015,487 5,360,421
14,164,518 11,953,924
65,957,775 58,728,528
46,640,664 40,894,010
13,529 16,811
5,020,000 5,020,000
19,824 9,472
56,880 56,554
51,750,897 45,996,847
7,208,762 6,505,283
1,739,014 1,193,506
2,683,758 1,131,753
805,159 2,303,402
17,887 32,062
173,598 114,208
2,272 1,179
35,319 43,534
1,046,711 774,092
494,398 632,662
14,206,878 12,731,681
65,957,775 58,728,528
26,005,944 25,699,113
(21,088,864) (18,676,562)
4,917,080 7,022,551
(933,244) (736,142)
(733,607) (730,551)
(456,493) (572,436)
(2,123,344) (2,039,129)
42,997 55,935
2,836,733 5,039,357
(1,172,557) (644,121)
1,664,176 4,395,236
(198,877) (763,035)
1,465,299 3,632,201
2.47 6.29
1,465,299 3,632,201
(33,620) (27,012)
8,411 6,737
(25,209) (20,275)
1,440,090 3,611,926
1,664,176 4,395,236
2,356,110 2,144,497
8,501 8,395
10,189 25,000
88,125 235,035
- 70,431
15,913 3,036
14,175 67,594
22,968 -
25,990 46,058
1,149,589 644,121
- 12,895
(19,889) (28,793)
5,335,847 7,623,505
(703,479) 245,303
(545,508) 107,729
(1,688,194) (474,227)
1,498,243 (1,468,489)
(59,390) (38,341)
8,215 217,102
(1,490,113) (1,410,923)
2,922,380 1,815,694
1,432,267 404,771
6,768,114 8,028,276
(10,352) (3,673)
(326) (80)
(50) 15
34,796 310,735
(38,020) (40,084)
(93,768) (175,916)
- (135,635)
418,939 -
(798,373) (2,393,707)
6,280,960 5,589,931
(8,220,851) (19,445,846)
(5,219) -
102,173 51,965
- (350,000)
- (21,997)
18,796 28,970
(8,105,101) (19,736,908)
3,552,666 10,648,936
1,000,000 -
- 4,241,830
- (480,615)
(1,215,654) 1,038,909
(857,975) (462,171)
(663,880) (1,804,561)
1,815,157 13,182,328
(8,984) (964,649)
(806,581) 158,068
(815,565) (806,581)
Ratio Analysis
Current Ratio =
LIABILITIES
Non-current liabilities
Long term inancing -
Long term musharaka -
Deferred tax liability - net 10,617,491
Employee beneit obligations 24,890
10,642,381
Current liabilities
Trade and other payables 8,059,754
Short-term borrowings 10,835,368
Current portion of long term inancing 3,375,360
Current portion of long term musharaka 2,249,733
Unclaimed dividend 213,797
24,734,012
Total liabilities 35,376,393
ASSETS
Non-current assets
Property, plant and equipment 57,242,086
Intangible assets and goodwill 7,794,154
Investment property 262,349
Long term investments 12,512,039
Long term deposits 118,038
77,928,666
Current assets
Stores, spare parts and loose tools 5,511,210
Stock in trade 2,689,443
Trade debts 2,101,856
Advances 407,771
Deposits and prepayments 26,862
Other receivables 641,090
Advance tax - net 3,212,501
Cash and bank balances 462,912
15,053,645
Total Assets 92,982,311
Changes in:
Stores, spares parts and loose tools 2,251,345
Stock in trade 1,669,038
Trade debts (316,128)
Advances 263,595
Deposits and prepayments 15,308
Other receivables 1,135,000
Trade and other payables (1,562,452)
3,455,706
Cash generated from operating activities 19,852,536
5,962,528 - 0.00%
6,784,945 719,676 10.61%
40,562,399 3,576,370 8.82%
53,309,872 4,296,046 8.06%
- (2,700,000)
- (1,800,000)
7,173,509 (13,631,783) -190.03%
7,173,509 (18,131,783) -252.76%
LIABILITIES
Non-current liabilities
Long term inancing -
Long term musharaka -
Deferred tax liability - net 10,617,491
Employee beneit obligations 24,890
10,642,381
Current liabilities
Trade and other payables 8,059,754
Short-term borrowings 10,835,368
Current portion of long term inancing 3,375,360
Current portion of long term musharaka 2,249,733
Unclaimed dividend 213,797
24,734,012
Total liabilities 35,376,393
ASSETS
Non-current assets
Property, plant and equipment 57,242,086
Intangible assets and goodwill 7,794,154
Investment property 262,349
Long term investments 12,512,039
Long term deposits 118,038
77,928,666
Current assets
Stores, spare parts and loose tools 5,511,210
Stock in trade 2,689,443
Trade debts 2,101,856
Advances 407,771
Deposits and prepayments 26,862
Other receivables 641,090
Advance tax - net 3,212,501
Cash and bank balances 462,912
15,053,645
Total Assets 92,982,311
Changes in:
Stores, spares parts and loose tools 2,251,345
Stock in trade 1,669,038
Trade debts (316,128)
Advances 263,595
Deposits and prepayments 15,308
Other receivables 1,135,000
Trade and other payables (1,562,452)
3,455,706
Cash generated from operating activities 19,852,536
5,962,528
6,784,945
40,562,399
53,309,872 0.62 0.56 0.10
3,300,000
2,200,000
9,111,362
497,337
15,108,699 0.11 0.16 (0.28)
9,602,383
12,260,179
2,779,023
1,854,521
55,963
26,552,069 0.27 0.28 (0.05)
41,660,768 0.38 0.44 (0.13)
56,085,733
7,816,902
257,656
11,375,186
132,477
75,667,954 0.84 0.80 0.05
7,641,242
4,358,080
1,785,728
671,366
42,169
1,776,089
2,737,748
290,264
19,302,686 0.16 0.20 (0.20)
94,970,640 1.00 1.00 -
22.07
(25,667)
6,730
(18,937)
(281)
42
(239)
(19,176)
481,112
(4)
(1,087,046)
163,058
(442,880)
(462,056)
12,695,650
14,964,464
(8,563)
2,229,818
1,446,135
(28,315)
(641)
(1,841)
(5,420)
(7,442)
600,435
393,189
(1,347,545)
110,593
3,380,403
18,344,867
(1,193,372)
(867,364)
(323,373)
712,995
41,684
(458,293)
1,077,943
(1,009,780)
17,335,087
2,212
(951,608)
(19,795)
(4,417,248)
11,948,648
(13,349,971)
(300)
20,890
27,901
1,217,447
641
(12,083,392)
-
-
7,173,509
7,173,509
(7,272,253)
(4,697,662)
(11,969,915)