0% found this document useful (0 votes)
16 views13 pages

Comparative Financial Analysis: Gul Ahmed vs Nishat Mills

The document contains comparative financial statements for Gul Ahmed and Nishat Mills, textile companies, including balance sheets and income statements. It shows changes between 2017 and 2018 in key financial metrics like revenue, costs, assets and liabilities. The revenue for both companies increased between 2017 and 2018 while costs of sales increased for Gul Ahmed but decreased for Nishat Mills. Current assets increased for both companies.

Uploaded by

Saqib Jawed
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
16 views13 pages

Comparative Financial Analysis: Gul Ahmed vs Nishat Mills

The document contains comparative financial statements for Gul Ahmed and Nishat Mills, textile companies, including balance sheets and income statements. It shows changes between 2017 and 2018 in key financial metrics like revenue, costs, assets and liabilities. The revenue for both companies increased between 2017 and 2018 while costs of sales increased for Gul Ahmed but decreased for Nishat Mills. Current assets increased for both companies.

Uploaded by

Saqib Jawed
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

COMPARITIVE FINANCIAL STATEMENT:

Gul Ahmed
Nishat Mills
Textile Sector

DOLLAR &PERCENTAGE CHANGE ANALYSIS:

Balance Sheet

A. Non-Current Assets (A1+A3+A4+A5+A6)


1. Capital work in progress
2. Operating fixed assets at cost
3. Operating fixed assets after deducting accumulated depreciation
4. Intangible assets
5. Long term investments
of which: i) Investments in subsidiaries
ii) Investments in associates
6. Other non-current assets
of which: i) Long term loans and advances
ii) Long term deposits
B. Current Assets (B1+B2+B3+B4+B5+B6)
1. Cash & bank balance
2. Inventories; of which
i) Raw material
ii) Work in progress
iii) Finished goods
3. Trade Debt / accounts receivables
4. Short term loans and advances
5. Short term investments
6. Other current assets
of which: i) Stores, spares & loose tools
ii) Trade deposits & pre-payments
Total Assets (A+B) / Equity & Liabilities (C+D+E)
C. Shareholders' Equity (C1+C2+C3)
1. Issued, Subscribed & Paid up capital
i) Ordinary Shares
ii) Preference shares
2. Reserves
i) Capital Reserve
ii) Revenue Reserve
of which: un-appropriated profit(loss) / retained earnings
3. Surplus on revaluation of fixed assets
D. Non-Current Liabilities (D1+D2+D3+D4+D5)
1. Long term borrowings
of which: i) Long term secured loans
ii) Long term unsecured loans
iii) Long term lease finance
2. Subordinated loans / Sponsor's loans
3. Debentures/TFCs (bonds payable)
4. Employees benefit obligations
5. Other non-current liabilities
E. Current Liabilities (E1+E2+E3+E4)
1. Trade credit & other accounts payables
of which: i) Trade credits
2. Short term Borrowings
of which: i) Short term secured loans
ii) Short term unsecured loans
iii) Short term lease finance
3. Current portion of non-current liabilities
4. Other current liabilities
of which: i) Interest / markup payables
ii) Taxes payable
F. Operations:
1. Sales
i) Local sales (Net)
ii) Export sales (Net)
2. Cost of sales
i) Cost of material
ii) Labour
iii) Overhead
3. Gross profit / (loss) (F1-F2)
4. General, administrative and other expenses
i) Selling & distribution expenses
of which: Advertisement & promotions
ii) Administrative and other expenses
of which: Corporate social responsibilities
4. Salaries, wages and employee benefits
5. Other income / (loss)
6. EBIT (F3-F4+F5)
7. Financial expenses
of which: (i) Interest expenses
8. Profit / (loss) before taxation (F6-F7)
9. Tax expenses
i) Current
a) for the year
b) prior year
ii) Deferred
10. Profit / (loss) after tax (F8-F9)

TREND ANALYSIS:

Item
Revenue
Cost of Sales
Gross Profit

Item
Revenue
Cost of Sales
Gross Profit

A. Non-Current Assets (A1+A3+A4+A5+A6)


B. Current Assets (B1+B2+B3+B4+B5+B6)
C. Shareholders' Equity (C1+C2+C3)
D. Non-Current Liabilities (D1+D2+D3+D4+D5)
E. Current Liabilities (E1+E2+E3+E4)

A. Non-Current Assets (A1+A3+A4+A5+A6)


B. Current Assets (B1+B2+B3+B4+B5+B6)
C. Shareholders' Equity (C1+C2+C3)
D. Non-Current Liabilities (D1+D2+D3+D4+D5)
E. Current Liabilities (E1+E2+E3+E4)

COMPONENT PERCENTAGE:

Assets
Current assets:
Cash & equivalents
A/R, net
Inventory
prepaid expenses
Total current assets
Property and Equipment:
Land
Building and Equipment, net
Total property and equipment
Total assets
*Percent rounded to one decimal points

BALANCE SHEET

A. Non-Current Assets (A1+A3+A4+A5+A6)


1. Capital work in progress
2. Operating fixed assets at cost
3. Operating fixed assets after deducting accumulated depreciation
4. Intangible assets
5. Long term investments
of which: i) Investments in subsidiaries
ii) Investments in associates
6. Other non-current assets
of which: i) Long term loans and advances
ii) Long term deposits
B. Current Assets (B1+B2+B3+B4+B5+B6)
1. Cash & bank balance
2. Inventories; of which
i) Raw material
ii) Work in progress
iii) Finished goods
3. Trade Debt / accounts receivables
4. Short term loans and advances
5. Short term investments
6. Other current assets
of which: i) Stores, spares & loose tools
ii) Trade deposits & pre-payments
Total Assets (A+B) / Equity & Liabilities (C+D+E)

INCOME STATEMENT

1. Sales
i) Local sales (Net)
ii) Export sales (Net)
2. Cost of sales
i) Cost of material
ii) Labour
iii) Overhead
3. Gross profit / (loss) (F1-F2)
4. General, administrative and other expenses
i) Selling & distribution expenses
of which: Advertisement & promotions
ii) Administrative and other expenses
of which: Corporate social responsibilities
4. Salaries, wages and employee benefits
5. Other income / (loss)
6. EBIT (F3-F4+F5)
7. Financial expenses
of which: (i) Interest expenses
8. Profit / (loss) before taxation (F6-F7)
9. Tax expenses
i) Current
a) for the year
b) prior year
ii) Deferred
10. Profit / (loss) after tax (F8-F9)
2017 2018
169,496 393,231
97,410 116,608
645,036,516 744,534,034

2018

2017 2018 PKR Change Percentage Change


13,686,609 13,190,947 (495,662) -3.62%
537,737 670,774 133,037 24.74%
23,341,204 23,880,436 539,232 2.31%
12,021,636 11,148,509 (873,127) -7.26%
71,635 92,420 20,785 29.02%
- - - #DIV/0!
- - - #DIV/0!
- - - #DIV/0!
1,055,601 1,279,244 223,643 21.19%
27,187 15,243 (11,944) -43.93%
56,444 55,477 (967) -1.71%
8,531,721 9,577,519 1,045,798 12.26%
68,468 100,665 32,197 47.02%
2,645,994 3,020,190 374,196 14.14%
2,173,157 2,076,103 (97,054) -4.47%
200,171 401,252 201,081 100.45%
322,775 592,694 269,919 83.62%
170,639 400,313 229,674 134.60%
114,699 223,998 109,299 95.29%
- - - #DIV/0!
5,531,921 5,832,353 300,432 5.43%
740,423 620,937 (119,486) -16.14%
42,648 67,953 25,305 59.33%
22,218,330 22,768,466 550,136 2.48%
9,721,024 9,341,060 (379,964) -3.91%
7,665,961 7,665,961 - 0.00%
7,665,961 7,665,961 - 0.00%
- - - #DIV/0!
2,055,063 1,675,099 (379,964) -18.49%
1,082,547 945,438 (137,109) -12.67%
972,516 729,661 (242,855) -24.97%
972,516 729,661 (242,855) -24.97%
- - - #DIV/0!
5,408,658 4,616,413 (792,245) -14.65%
4,121,344 4,000,000 (121,344) -2.94%
4,000,000 4,000,000 - 0.00%
- - - #DIV/0!
121,344 - (121,344) -100.00%
- - - #DIV/0!
- - - #DIV/0!
- - - #DIV/0!
1,287,314 616,413 (670,901) -52.12%
7,088,648 8,810,993 1,722,345 24.30%
5,125,725 6,427,662 1,301,937 25.40%
3,270,847 4,408 (3,266,439) -99.87%
1,204,201 2,076,516 872,315 72.44%
1,204,201 2,076,516 872,315 72.44%
- - - #DIV/0!
- - - #DIV/0!
651,956 121,506 (530,450) -81.36%
106,766 185,309 78,543 73.57%
97,742 175,958 78,216 80.02%
- - - #DIV/0!
- - - #DIV/0!
34,653,486 32,439,451 (2,214,035) -6.39%
34,653,486 32,439,451 (2,214,035) -6.39%
- - - #DIV/0!
29,017,336 27,285,392 (1,731,944) -5.97%
21,198,337 20,259,414 (938,923) -4.43%
1,420,036 1,446,135 26,099 1.84%
6,398,963 5,579,843 (819,120) -12.80%
5,636,150 5,154,059 (482,091) -8.55%
4,907,217 5,271,308 364,091 7.42%
3,933,248 4,205,762 272,514 6.93%
1,372,070 1,665,790 293,720 21.41%
973,969 1,065,546 91,577 9.40%
21,575 40,185 18,610 86.26%
2,679,430 2,693,208 13,778 0.51%
358,541 622,269 263,728 73.56%
1,087,474 505,020 (582,454) -53.56%
524,497 675,340 150,843 28.76%
505,343 660,180 154,837 30.64%
562,977 (170,320) (733,297) -130.25%
183,680 (234,103) (417,783) -227.45%
502,190 436,798 (65,392) -13.02%
382,199 413,081 30,882 8.08%
119,991 23,717 (96,274) -80.23%
(318,510) (670,901) (352,391) 110.64%
379,297 63,783 (315,514) -83.18%

2003 2002 2001 2000 1999


$400,000 $355,000 $320,000 $290,000 $275,000
285,000 250,000 225,000 198,000 190,000
115,000 105,000 95,000 92,000 85,000

2003 2002 2001 2000 1999


145% 121.80% 116.30% 105.40% 100%
150% 131.50% 118.40% 104.20% 100%
135.30% 123.50% 111.70% 108.20% 100%

2017 2018
179,206,893 179,206,893
41,412,113 41,412,113
(224,514,154) (224,514,154)
183,759,135 183,759,135
261,374,025 261,374,025

2017 2018
106.283211077 106.283211077
134.607867082 134.607867082
209.646971901 209.646971901
183.226342113 183.226342113
126.770835117 126.770835117

COMPONENT PERCENTAGE
2003 2002 2003 2002

$12,000 $23,500 3.80952381 8.11183983431136


60,000 40,000 19.04761905 13.8073869520193
80,000 100,000 25.3968254 80
3,000 1,200 0.952380952 0.41422160856058
$155,000 $164,700 49.20634921 56.8519157749396

40,000 40,000 12.6984127 13.8073869520193


120,000 85,000 38.0952381 29.3406972730411
$160,000 $125,000 50.79365079 43.1480842250604
$315,000 $289,700 100% 100%

BALANCE SHEET
2017 2018 2017 2018
82,965,431 80,896,728
2,721,908 621,090
66,583,520 68,008,218
31,629,702 32,153,880
1,951,383 1,941,784 1.386218225 1.08464624341062
45,665,306 45,035,025
44,197,788 40,756,975
- -
997,132 1,144,949
965,959 1,113,854
31,173 31,095
57,804,829 98,127,909
2,772,312 4,671,027 1.969387568 2.60915317482252
640,655 13,286,402
113,885 254,632
165,182 165,343
361,588 12,624,141
4,817,924 4,850,235
585,527 541,903
31,657,685 55,773,304
17,330,726 19,005,038
3,511,899 3,489,324
83,824 82,733
140,770,260 179,024,637 100% 100%

OME STATEMENT
2017 2018 2017 2018
93,583,447 109,433,588 100% 100%
88,302,823 109,071,243
5,280,624 362,345
74,478,825 80,282,515 79.58546878 73.361859432042
25,317,857 27,268,343
6,774,365 7,108,549
42,386,603 45,905,623
19,104,622 29,151,073
10,725,844 11,619,885 11.46126195 10.6182070901303
9,093,469 9,508,770
337,515 386,496
1,632,375 2,111,115
- -
9,381,031 10,676,264
11,631,832 8,447,240
20,010,610 25,978,428
3,228,723 2,244,609
3,098,961 2,217,842
16,781,887 23,733,819
5,285,987 7,295,615
5,151,903 7,369,615
4,688,357 6,917,615
463,546 452,000
134,084 (74,000)
11,495,900 16,438,204
Assets 2003 2002 Dollar change Percentage change
Current assets:
Cash & equivalents $12,000 $23,500 ($11,500) -48.90%
A/R, net 60,000 40,000 20,000 50%
Inventory 80,000 100,000 -20,000 -20%
prepaid expenses 3,000 1,200 1,800 150%
Total current assets $155,000 $164,700 -9,700 -5.80%
Property and Equipment:
Land 40,000 40,000 0 0
Building and Equipment, net 120,000 85,000 35,000 41.17%
Total property and equipment $160,000 $125,000 35,000 28%
Total assets $315,000 $289,700 25,300 8.70%
*Percent rounded to one decimal points
A. Non-Current Assets (A1+A3+A4+A5+A6)
B. Current Assets (B1+B2+B3+B4+B5+B6)
C. Shareholders' Equity (C1+C2+C3)
D. Non-Current Liabilities (D1+D2+D3+D4+D5)
E. Current Liabilities (E1+E2+E3+E4)

TREND ANALYSIS:

A. Non-Current Assets (A1+A3+A4+A5+A6)


B. Current Assets (B1+B2+B3+B4+B5+B6)
C. Shareholders' Equity (C1+C2+C3)
D. Non-Current Liabilities (D1+D2+D3+D4+D5)
E. Current Liabilities (E1+E2+E3+E4)
2013 2014 2015 2016 2017 2018
168,612,607 156,914,009 153,269,264 174,374,748 179,206,893 179,206,893
30,765,002 31,100,171 31,953,597 35,757,213 41,412,113 41,412,113
(107,091,532) (140,370,192) (170,965,812) (189,594,106) (224,514,154) (224,514,154)
100,290,784 109,536,323 149,699,650 184,163,245 183,759,135 183,759,135
206,178,357 218,848,049 206,489,023 215,562,822 261,374,025 261,374,025

2013 2014 2015 2016 2017 2018


100% 93.0618485722 90.900239743 103.417384443 106.283211077 106.283211077
100% 101.089448978 103.863464725 116.226915896 134.607867082 134.607867082
100% 131.074968654 159.644566482 177.039306899 209.646971901 209.646971901
100% 109.218732401 149.26560949 183.629280433 183.226342113 183.226342113
100% 106.145015502 100.150678279 104.551624689 126.770835117 126.770835117

You might also like