Calculations 1

Yr: 2014
Yr: 2013
Remarks
1.1

Profitibality Ratio

1.1.1
ROE=
x 100 = 10.71% x100 = 10.30%
Higher the better

1.1.2
ROTA=
x100
= 18.27% x100 = 19.45%
Higher the better

1.1.3
GPM=
x100
= 71.67% x100 =70.35%
Higher the better

1.1.4
OPM=
x100
=28.72%
x100
=29.79%
Higher the better

1.1.5
NPM=
x100
=43.48%
x100
=39.46%
Higher the better

1.1.6
NPM=
x100
=38.74%
x100
=35.04%
Higher the better
1.2

Asset Utilisation

1.2.1
TA TURN= x100 =18.27% x100 =19.45%
Higher the better

1.2.2
Accounts recievable

=8.52 times

=8.51 times

= 42.84 days
=42.89 days
Shorter the better

1.2.3
Inventory Turnover

=
14.37 times
=
15.38 times
Higher the better

=25.40 days
=23.73 days

1.2.4
Accounts Payable Days

=
1.16 times
=
1.36 times
Higher the better

=
314.66 days
=
268.38 days

1.2.5
Cash Conversion Cycle

Collection days + inventory days – payment days
42.84 + 25.40 -314.66 =

-246.42 days
42.89 + 23.73 –
268.38 =

-268.38 days
Lower the better
1.3

Liquidity

1.3.1
NWC= CA-CL
1640252 – 1285573= 354679
1650369-
342730= 1307639
Higher the better

1.3.2
CR=
x100
=1.28
x100
=4.82
Higher the better
1.4

Gearing

1.4.1
Gearing=
x100
=33.90
x100
=33.85
Lower is better

1.4.2
Times Interest
Earned = x100 =9.95 times x100 =11.57 times
Higher is better
1.5

Stock Market Power

1.5.1
EPS=

= 0.900 times

=0.832 times
Higher is better
1.6

Market Price
= 4.18$

1.6.1
PE=

= 4.65

1.6.2
DPS=

$0.21 per share (holding, n.d.)

1.6.3
Dividend Yield =

= 0.0501

PART B:

Company: Breadtalk
1) Incremental Cash Flow for 4 years

Incremental Cash Flow for 4 years Year
Particulars
1
2
3
4
Sales
600000
800000
800000
800000
Direct Cost
240000
320000
320000
320000
Depreciation
237500
237500
237500
237500
Overheads
85000
85000
85000
85000
Return on Investment
37500
157500
157500
157500
Return on Investment in %
3.95%
16.58%
16.58%
16.58%

Annual after tax cash flow for 4 years:
Annual After Tax Cash Flow for 4