My Project Yunzelah Nauman (060) (BBA)

Download as xlsx, pdf, or txt
Download as xlsx, pdf, or txt
You are on page 1of 42

Project

Name:Yunzelah Nauman
Roll no: 060
Group Mate: Shayan Ghazi (idle)
Roll no: 061

Rupees (Rs)
Years: 2016
Assets
Current assets:
Cash 29,908,284
Stores and spares 6,530,512
Stock in trade 171,452,185
Trade debts 231,358,044
Advances 12,583,939
Trade deposits and short-term prepayments 4,480,277
Advance tax 5,136,306
Account receivables 292,938
Short-term investments 439,428,293
Inventories -
Total current assets: 901,170,778

Non-current assets:
Tangible/Fixed Assets 534,102,175
In-tangible Assets 32,643,304
Long-term investments 1,778,600
Total non- current assets 568,524,079

Total Assets 1,469,694,857

Liabilities
Current liabilities:
Trade and other payables 195,904,130
Accured interest 5,207,812
Short-term borrowings 285,691,438
Unclaimed dividend 21,022,630
Unpaid dividend -
Current portion of lease liabilities -
Total current liabilities 507,826,010

Non-current liabilities:
Employee benefits 2,957,812
Deffered tax liability 34,364,406
Lease laibilities -
Long term loan -
Total non-current liabilities 37,322,218

Total Liabilities/debts 545,148,228

Shareholder's Equity
Equity Capital 200,000,000
Revenue reserve 452,034,872
Capital reserve 272,511,757
Total Shareholder's Equity 924,546,629

Total Liabilities & Shareholder's Equi 1,469,694,857

Check 0.000
(Biafo industry)

2017 2018 2019 2020

28,432,880 25,630,333 40,534,570 43,269,280


4,734,712 4,881,880 - -
142,752,225 180,984,146 - -
208,638,227 353,437,290 279,538,533 373,238,956
12,989,221 5,767,595 14,151,399 11,372,700
4,714,825 4,650,777 13,102,981 26,603,135
20,563,768 10,399,824 24,139,827 57,704,434
1,983,418 3,635,096 - -
429,431,919 455,593,056 491,618,034 267,619,583
- - 330,795,309 383,602,284
854,241,195 1,044,979,997 1,193,880,653 1,163,410,372

536,943,456 531,030,305 1,046,351,416 1,057,817,867


31,827,222 31,031,540 30,255,752 29,499,358
1,793,600 1,793,600 1,793,600 1,777,650
570,564,278 563,855,445 1,078,400,768 1,089,094,875

1,424,805,473 1,608,835,442 2,272,281,421 2,252,505,247

140,371,630 166,515,956 182,056,475 189,505,531


5,135,461 5,495,901 - 10,861,805
302,542,529 419,694,378 595,079,117 458,812,389
29,106,897 16,136,061 23,391,830 23,029,521
- 7,909,501 11,295,615 13,061,372
- - - 1,984,151
477,156,517 615,751,797 811,823,037 697,254,769

3,731,466 4,256,427 5,438,514 5,182,759


30,401,013 25,737,772 49,780,166 34,397,655
- - - 6,060,656
- - - 31,840,182
34,132,479 29,994,199 55,218,680 77,481,252

511,288,996 645,745,996 867,041,717 774,736,021

220,000,000 220,000,000 264,000,000 348,480,000


422,429,334 472,997,002 429,984,402 421,955,643
271,087,143 270,092,444 711,255,302 707,333,583
913,516,477 963,089,446 1,405,239,704 1,477,769,226

1,424,805,473 1,608,835,442 2,272,281,421 2,252,505,247

0.000 0.000 0.000 0.000


Income
Rupees (Rs)
Years:

Net sales/Turnover/Revenue
Cost of good sales

Gross profit/income
Net income
Distribution cost
Administrative expenses
Finance costs

Operating profit/income
Worker's profit participation fund
Worker's welfare fund
Finance costs
Finance income
Net finance cost/income
Worker's profit participation fund
Worker's welfare fund

Profit before taxation


Income tax expense

Taxation
Current
Deffered
Total taxation

Profit for the year


Income statement
2016 2017 2018 2019

1,447,883,189 1,199,632,223 1,678,537,097 1,409,578,431


772,383,456 641,340,658 841,706,262 800,813,888

675,499,733 558,291,565 836,830,835 608,764,543


27,104,160 31,298,127 47,264,729 5,487,108
22,478,815 24,223,730 28,756,466 39,514,703
100,375,068 105,439,631 119,065,144 123,413,595
21,043,926 24,954,088 22,908,377 -

558,706,084 434,972,243 713,365,577 451,323,353


27,935,304 21,748,612 35,668,279 -
19,222,142 5,999,285 14,267,312 -
- - 63,245,156
- - - 97,538,010
- - - 34,292,854
- - - 24,280,810
- - - 1,093,898

502,548,638 407,224,346 663,429,986 460,241,499


- - - 100,349,495

113,932,424 90,217,891 134,520,258 -


8,181,168 3,572,169 3,700,639 -
122,113,592 93,790,060 138,220,897 -

398,435,046 320,578,624 532,610,367 359,892,004


2020

1,586,550,076
1,022,846,086

563,703,990
5,295,704
59,851,112
128,090,277
33,233,875

347,823,800
-
-
71,602,785
51,089,578
20,513,207
16,365,530
6,417,855

304,527,208
58,656,561

-
-
-

245,870,647
Ratio Anal

1 Current ratio: CA/CL


2 Quick ratio: (CA-INV)/CL
3 Net working capital to sales ratio: (CA-CL)/Sales
4 Gross profit margin: Gross income/Sales
5 Operating profit margin: Operating income/Sales
6 Net profit margin: Net income/Sales
7 Inventory turnover: Cost of goods sale/INV
8 Account receivable turnover: Sales on credit/AR
9 Total Assets turnover: Sales/Total Assets
10 Fixed Assets turnover: Sales/Fixed Assets
11 Total debt to assest ratio: Total debt/Total Assets
12 Long-term debt to assets ratio: Long-term debt/Total Assets
13 Debt to equity ratio: Total debt/Total equity
Ratio Analysis
2016 2017 2018 2019 2020
177.46% 179.03% 169.71% 147.06% 166.86%
131.90% 135.30% 112.31% 106.31% 111.84%
27.17% 31.43% 25.57% 27.10% 29.38%
46.65% 46.54% 49.85% 43.19% 35.53%
38.59% 36.26% 42.50% 32.02% 21.92%
1.87% 2.61% 2.82% 0.39% 0.33%
450.49% 449.27% 465.07% 242.09% 266.64%
494262.67% 60483.08% 46175.87% #VALUE! #VALUE!
98.52% 84.20% 104.33% 62.03% 70.43%
271.09% 223.42% 316.09% 134.71% 149.98%
37.09% 35.88% 40.14% 38.16% 34.39%
2.54% 2.40% 1.86% 2.43% 3.44%
37.09% 35.88% 40.14% 38.16% 34.39%
1 2016 2017 2018 2019 2020
177.46% 179.03% 169.71% 147.06% 166.86%

Chart Title
Row 5
200.00%
177.46% 179.03%
180.00% 169.71% 166.86%
160.00% 147.06%
140.00%
120.00%
100.00%
80.00%
60.00%
40.00%
20.00%
0.00%
2016 2017 2018 2019 2020

2 2016 2017 2018 2019 2020


131.90% 135.30% 112.31% 106.31% 111.84%

Chart Title
Row 25
160.00%

131.90% 135.30%
140.00%

120.00% 112.31% 111.84%


106.31%
100.00%

80.00%

60.00%

40.00%

20.00%

0.00%
2016 2017 2018 2019 2020
3 2016 2017 2018 2019 2020
27.17% 31.43% 25.57% 27.10% 29.38%

Chart Title
35.00% 31.43%
29.38%
30.00% 27.17% 27.10%
25.57%
25.00%

20.00%

15.00%

10.00%

5.00%

0.00%
2016 2017 2018 2019 2020

Row 45

4 2016 2017 2018 2019 2020


46.65% 46.54% 49.85% 43.19% 35.53%

Chart Title
60.00%
49.85%
50.00% 46.65% 46.54%
43.19%
40.00% 35.53%

30.00%

20.00%

10.00%

0.00%
2016 2017 2018 2019 2020

Row 65

5 2016 2017 2018 2019 2020


38.59% 36.26% 42.50% 32.02% 21.92%

Chart Title
45.00% 42.50%
38.59%
40.00% 36.26%
35.00% 32.02%
30.00%
25.00% 21.92%
20.00%
15.00%
10.00%
5.00%
0.00%
2016 2017 2018 2019 2020

Row 85

6 2016 2017 2018 2019 2020


1.87% 2.61% 2.82% 0.39% 0.33%

Chart Title
Row 105
3.00% 2.82%
2.61%
2.50%

2.00% 1.87%

1.50%

1.00%

0.50% 0.39% 0.33%

0.00%
2016 2017 2018 2019 2020

7 2016 2017 2018 2019 2020


450.49% 449.27% 465.07% 242.09% 266.64%

Chart Title
500.00% 450.49% 465.07%
449.27%
450.00%
400.00%
Chart Title
500.00% 450.49% 465.07%
449.27%
450.00%
400.00%
350.00%
300.00% 266.64%
242.09%
250.00%
200.00%
150.00%
100.00%
50.00%
0.00%
2016 2017 2018 2019 2020

Row 125

8 2016 2017 2018 2019 2020


494262.67% 60483.08% 46175.87% #VALUE! #VALUE!

Chart Title
600000.00%
494262.67%
500000.00%

400000.00%

300000.00%

200000.00%

100000.00% 60483.08% 46175.87%


0.00% 0.00%
0.00%
2016 2017 2018 2019 2020

Row 145

9 2016 2017 2018 2019 2020


98.52% 84.20% 104.33% 62.03% 70.43%

Chart Title
Row 163
120.00%
104.33%
98.52%
100.00%
84.20%
80.00% 70.43%
62.03%
60.00%
120.00%
104.33%
98.52%
100.00%
84.20%
80.00% 70.43%
62.03%
60.00%

40.00%

20.00%

0.00%
2016 2017 2018 2019 2020

10 2016 2017 2018 2019 2020


271.09% 223.42% 316.09% 134.71% 149.98%

Chart Title
350.00% 316.09%
300.00% 271.09%

250.00% 223.42%

200.00%
149.98%
150.00% 134.71%

100.00%

50.00%

0.00%
2016 2017 2018 2019 2020

Row 183

11 2016 2017 2018 2019 2020


37.09% 35.88% 40.14% 38.16% 34.39%

Chart Title
41.00% 40.14%
40.00%
39.00% 38.16%
38.00% 37.09%
37.00%
35.88%
36.00%
35.00% 34.39%
34.00%
33.00%
32.00%
31.00%
2016 2017 2018 2019 2020

Row 203
36.00%
35.00% 34.39%
34.00%
33.00%
32.00%
31.00%
2016 2017 2018 2019 2020

Row 203

12 2016 2017 2018 2019 2020


2.54% 2.40% 1.86% 2.43% 3.44%

Chart Title
4.00%
3.44%
3.50%
3.00%
2.54% 2.43%
2.40%
2.50%
1.86%
2.00%
1.50%
1.00%
0.50%
0.00%
2016 2017 2018 2019 2020

Row 222

13 2016 2017 2018 2019 2020


37.09% 35.88% 40.14% 38.16% 34.39%

Chart Title
Row 241
41.00%
40.00% 40.14%

39.00%
38.00% 38.16%

37.00% 37.09%
36.00% 35.88%
35.00%
34.39%
34.00%
33.00%
32.00%
31.00%
2016 2017 2018 2019 2020
66.86%

2020

11.84%

2020
66.64%

2020
49.98%

2020
1 2016 2017 2018 2019 2020
177.46% 179.03% 169.71% 147.06% 166.86%

Chart Title
2016 2017 2018 2019 2020
200.00%
177.46% 179.03%
180.00% 169.71% 166.86%
160.00% 147.06%
140.00%
120.00%
100.00%
80.00%
60.00%
40.00%
20.00%
0.00%

2 2016 2017 2018 2019 2020


131.90% 135.30% 112.31% 106.31% 111.84%

Chart Title
2016 2017 2018 2019 2020
160.00%

140.00% 131.90% 135.30%

120.00% 112.31% 111.84%


106.31%
100.00%

80.00%

60.00%

40.00%

20.00%

0.00%
3 2016 2017 2018 2019 2020
27.17% 31.43% 25.57% 27.10% 29.38%

Chart Title
2016 2017 2018 2019 2020
35.00%
31.43%
29.38%
30.00%
27.17% 27.10%
25.57%
25.00%

20.00%

15.00%

10.00%

5.00%

0.00%

4 2016 2017 2018 2019 2020


46.65% 46.54% 49.85% 43.19% 35.53%

Chart Title
2016 2017 2018 2019 2020
60.00%

49.85%
50.00% 46.65% 46.54%
43.19%
40.00% 35.53%

30.00%

20.00%

10.00%

0.00%

5 2016 2017 2018 2019 2020


38.59% 36.26% 42.50% 32.02% 21.92%

Chart Title
2016 2017 2018 2019 2020
45.00% 42.50%
40.00% 38.59%
36.26%
35.00% 32.02%
30.00%
25.00% 21.92%
20.00%
15.00%
10.00%
5.00%
0.00%

6 2016 2017 2018 2019 2020


1.87% 2.61% 2.82% 0.39% 0.33%

Chart Title
2016 2017 2018 2019 2020
3.00% 2.82%
2.61%
2.50%

2.00% 1.87%

1.50%

1.00%

0.50% 0.39% 0.33%

0.00%

7 2016 2017 2018 2019 2020


450.49% 449.27% 465.07% 242.09% 266.64%

Chart Title
2016 2017 2018 2019 2020
500.00% 465.07%
450.49% 449.27%
450.00%
Chart Title
2016 2017 2018 2019 2020
500.00% 465.07%
450.49% 449.27%
450.00%
400.00%
350.00%
300.00% 266.64%
242.09%
250.00%
200.00%
150.00%
100.00%
50.00%
0.00%

8 2016 2017 2018 2019 2020


494262.67% 60483.08% 46175.87% #VALUE! #VALUE!

Chart Title
2016 2017 2018 2019 2020
600000.00%
494262.67%
500000.00%

400000.00%

300000.00%

200000.00%

100000.00% 60483.08% 46175.87%


0.00% 0.00%
0.00%

9 2016 2017 2018 2019 2020


98.52% 84.20% 104.33% 62.03% 70.43%

Chart Title
2016 2017 2018 2019 2020
120.00%
104.33%
98.52%
100.00%
84.20%
80.00%
70.43%
62.03%
60.00%
120.00%
104.33%
98.52%
100.00%
84.20%
80.00%
70.43%
62.03%
60.00%

40.00%

20.00%

0.00%

10 2016 2017 2018 2019 2020


271.09% 223.42% 316.09% 134.71% 149.98%

Chart Title
2016 2017 2018 2019 2020
350.00%
316.09%
300.00%
271.09%
250.00% 223.42%
200.00%
149.98%
150.00% 134.71%

100.00%

50.00%

0.00%

11 2016 2017 2018 2019 2020


37.09% 35.88% 40.14% 38.16% 34.39%

Chart Title
2016 2017 2018 2019 2020
41.00%
40.14%
40.00%
39.00%
38.16%
38.00%
37.09%
37.00%
35.88%
36.00%
35.00% 34.39%
34.00%
33.00%
32.00%
31.00%
37.09%
37.00%
35.88%
36.00%
35.00% 34.39%
34.00%
33.00%
32.00%
31.00%

12 2016 2017 2018 2019 2020


2.54% 2.40% 1.86% 2.43% 3.44%

Chart Title
2016 2017 2018 2019 2020
4.00%
3.44%
3.50%

3.00%
2.54% 2.43%
2.50% 2.40%

2.00% 1.86%

1.50%

1.00%

0.50%

0.00%

13 2016 2017 2018 2019 2020


37.09% 35.88% 40.14% 38.16% 34.39%

Chart Title
2016 2017 2018 2019 2020
41.00%
40.00%
39.00%
38.00%
37.00%
36.00%
40.14%
35.00%
38.16%
34.00% 37.09%
35.88%
33.00%
34.39%
32.00%
31.00%
1 2016 2017 2018 2019 2020
177.46% 179.03% 169.71% 147.06% 166.86%

Chart Title
2020 2019 2018 2017 2016

166.86%

147.06%

169.71%

179.03%

177.46%

0.00% 20.00% 40.00% 60.00% 80.00% 100.00% 120.00% 140.00% 160.00% 180.00% 200.00%

2 2016 2017 2018 2019 2020


131.90% 135.30% 112.31% 106.31% 111.84%

Chart Title
2020 2019 2018 2017 2016

111.84%

106.31%

112.31%

135.30%

131.90%

0.00% 20.00% 40.00% 60.00% 80.00% 100.00% 120.00% 140.00% 160.00%


3 2016 2017 2018 2019 2020
27.17% 31.43% 25.57% 27.10% 29.38%

Chart Title
2020 2019 2018 2017 2016

29.38%

27.10%

25.57%

31.43%

27.17%

0.00% 5.00% 10.00% 15.00% 20.00% 25.00% 30.00% 35.00%

4 2016 2017 2018 2019 2020


46.65% 46.54% 49.85% 43.19% 35.53%

Chart Title
2020 2019 2018 2017 2016

35.53%

43.19%

49.85%

46.54%

46.65%

0.00% 10.00% 20.00% 30.00% 40.00% 50.00% 60.00%

5 2016 2017 2018 2019 2020


38.59% 36.26% 42.50% 32.02% 21.92%

Chart Title
2020 2019 2018 2017 2016

21.92%

32.02%

42.50%

36.26%

38.59%

0.00% 5.00% 10.00% 15.00% 20.00% 25.00% 30.00% 35.00% 40.00% 45.00%

6 2016 2017 2018 2019 2020


1.87% 2.61% 2.82% 0.39% 0.33%

Chart Title
2020 2019 2018 2017 2016

0.33%

0.39%

2.82%

2.61%

1.87%

0.00% 0.50% 1.00% 1.50% 2.00% 2.50% 3.00%

7 2016 2017 2018 2019 2020


450.49% 449.27% 465.07% 242.09% 266.64%

Chart Title
2020 2019 2018 2017 2016

266.64%
Chart Title
2020 2019 2018 2017 2016

266.64%

242.09%

465.07%

449.27%

450.49%

0.00% 50.00% 100.00% 150.00% 200.00% 250.00% 300.00% 350.00% 400.00% 450.00% 500.00%

8 2016 2017 2018 2019 2020


494262.67% 60483.08% 46175.87% #VALUE! #VALUE!

Chart Title
2020 2019 2018 2017 2016

0.00%

0.00%

46175.87%

60483.08%

494262.67%

0.00% 100000.00% 200000.00% 300000.00% 400000.00% 500000.00% 600000.00%

9 2016 2017 2018 2019 2020


98.52% 84.20% 104.33% 62.03% 70.43%

Chart Title
2020 2019 2018 2017 2016

70.43%

62.03%

104.33%

84.20%
70.43%

62.03%

104.33%

84.20%

98.52%

0.00% 20.00% 40.00% 60.00% 80.00% 100.00% 120.00%

10 2016 2017 2018 2019 2020


271.09% 223.42% 316.09% 134.71% 149.98%

Chart Title
2020 2019 2018 2017 2016

149.98%

134.71%

316.09%

223.42%

271.09%

0.00% 50.00% 100.00% 150.00% 200.00% 250.00% 300.00% 350.00%

11 2016 2017 2018 2019 2020


37.09% 35.88% 40.14% 38.16% 34.39%

Chart Title
2020 2019 2018 2017 2016

34.39%

38.16%

40.14%

35.88%

37.09%

31.00% 32.00% 33.00% 34.00% 35.00% 36.00% 37.00% 38.00% 39.00% 40.00% 41.00%
40.14%

35.88%

37.09%

31.00% 32.00% 33.00% 34.00% 35.00% 36.00% 37.00% 38.00% 39.00% 40.00% 41.00%

12 2016 2017 2018 2019 2020


2.54% 2.40% 1.86% 2.43% 3.44%

Chart Title
2020 2019 2018 2017 2016

3.44%

2.43%

1.86%

2.40%

2.54%

0.00% 0.50% 1.00% 1.50% 2.00% 2.50% 3.00% 3.50% 4.00%

13 2016 2017 2018 2019 2020


37.09% 35.88% 40.14% 38.16% 34.39%

Chart Title
Row 241

2020 34.39%

2019 38.16%

2018 40.14%

2017 35.88%

2016 37.09%

31.00% 32.00% 33.00% 34.00% 35.00% 36.00% 37.00% 38.00% 39.00% 40.00% 41.00%
%

1%

79.03%

7.46%

0% 200.00%

5.30%

90%

0% 160.00%
465.07%

49.27%

50.49%

0% 500.00%
316.09%

350.00%
Analysis:
analysis.docx

You might also like