ASIAN OILFIELD SERVICES LTD SCREENER.

IN

Narration Jun-09 Mar-10 Mar-11 Mar-12 Mar-13 Mar-14 Mar-15 Mar-16 Mar-17 Mar-18 Trailing Best Case Worst Case
Sales 61.70 18.56 64.14 41.43 49.66 121.83 140.83 77.67 124.32 222.22 234.43 397.21 258.09
Expenses 51.56 16.07 58.52 47.54 54.12 123.78 146.59 101.22 142.58 191.03 191.99 325.30 247.74
Operating Profit 10.14 2.49 5.62 -6.11 -4.46 -1.95 -5.76 -23.55 -18.26 31.19 42.44 71.91 10.35
Other Income 2.48 0.87 -3.37 3.68 6.06 2.15 6.35 27.02 23.08 2.68 -15.29 - -
Depreciation 3.90 3.57 8.63 8.51 8.82 14.15 18.11 17.78 15.13 17.03 19.39 19.39 19.39
Interest 0.65 0.32 1.01 2.34 3.19 9.47 9.45 10.89 7.68 6.34 8.41 8.41 8.41
Profit before tax 8.07 -0.53 -7.39 -13.28 -10.40 -23.41 -26.97 -25.20 -18.00 10.50 -0.65 44.11 -17.45
Tax 2.82 0.37 0.16 -4.24 -0.10 0.02 0.04 1.85 0.21 0.20 0.24 0% 0%
Net profit 5.25 -0.90 -7.55 -9.04 -10.29 -23.43 -27.01 -27.06 -18.20 10.30 -0.89 44.11 -17.45
EPS 4.66 -0.59 -4.93 -5.90 -6.71 -10.50 -12.10 -12.12 -6.98 2.71 -0.23 11.59 -4.58
Price to earning 13.00 -112.65 -11.51 -4.93 -2.84 -6.62 -2.97 -2.81 -31.02 72.14 - 72.14 -
Price 60.53 66.16 56.68 29.10 19.04 69.49 35.96 34.12 216.53 195.17 82.95 835.79 -

RATIOS:
Dividend Payout 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00%
OPM 16.43% 13.42% 8.76% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 14.04% 18.10%

TRENDS: 10 YEARS 7 YEARS 5 YEARS 3 YEARS RECENT BEST WORST

Sales Growth 15.30% 19.42% 34.94% 16.42% 78.75% 78.75% 15.30%
OPM 5.36% 4.01% 4.54% 7.35% 18.10% 18.10% 4.01%
Price to Earning 42.57 72.14 72.14 72.14 - 72.14 -
ASIAN OILFIELD SERVICES LTD SCREENER.IN

Narration Sep-16 Dec-16 Mar-17 Jun-17 Sep-17 Dec-17 Mar-18 Jun-18 Sep-18 Dec-18
Sales 3.09 16.63 95.32 51.27 32.85 54.65 83.45 63.15 38.05 49.78
Expenses 18.75 13.63 97.49 38.64 25.65 50.61 66.61 56.04 32.09 37.25
Operating Profit -15.66 3.00 -2.17 12.63 7.20 4.04 16.84 7.11 5.96 12.53
Other Income 10.82 0.26 8.05 3.40 1.16 5.22 -16.60 2.50 0.90 -2.09
Depreciation 3.72 3.67 3.66 3.90 4.30 4.38 4.45 4.76 4.92 5.26
Interest 2.56 2.13 0.41 1.17 1.39 1.40 2.39 1.66 2.91 1.45
Profit before tax -11.12 -2.54 1.81 10.96 2.67 3.48 -6.60 3.19 -0.97 3.73
Tax - - 0.21 - - - 0.20 0.01 0.03 -
Net profit -11.13 -2.54 1.61 10.96 2.67 3.48 -6.80 3.18 -1.00 3.73

OPM -507% 18% -2% 25% 22% 7% 20% 11% 16% 25%
ASIAN OILFIELD SERVICES LTD SCREENER.IN

Narration Jun-09 Mar-10 Mar-11 Mar-12 Mar-13 Mar-14 Mar-15 Mar-16 Mar-17 Mar-18
Equity Share Capital 11.27 15.32 15.32 15.32 15.32 22.32 22.32 22.32 26.07 38.07
Reserves 64.34 85.10 76.18 66.98 56.92 42.68 14.87 -12.26 7.72 102.46
Borrowings 0.02 0.01 11.00 20.03 27.47 46.65 69.97 110.16 82.64 25.90
Other Liabilities 23.53 16.04 20.45 16.15 20.72 60.96 42.70 50.39 92.88 86.06
Total 99.16 116.47 122.95 118.48 120.43 172.61 149.86 170.61 209.31 252.49

Net Block 23.97 39.78 41.62 39.10 38.39 116.76 106.01 95.41 83.40 100.10
Capital Work in Progress - 0.85 4.18 0.07 3.59 8.17 - - - -
Investments 35.09 39.72 4.00 10.79 5.95 - - - - -
Other Assets 40.10 36.12 73.15 68.52 72.50 47.68 43.85 75.20 125.91 152.39
Total 99.16 116.47 122.95 118.48 120.43 172.61 149.86 170.61 209.31 252.49

Working Capital 16.57 20.08 52.70 52.37 51.78 -13.28 1.15 24.81 33.03 66.33
Debtors 19.90 9.84 25.32 18.59 15.29 10.98 18.86 42.91 27.51 61.61
Inventory - - 2.32 3.49 5.91 4.22 3.81 5.67 1.57 1.88

Debtor Days 117.72 193.51 144.09 163.78 112.38 32.90 48.88 201.65 80.77 101.20
Inventory Turnover - - 27.65 11.87 8.40 28.87 36.96 13.70 79.18 118.20

Return on Equity 7% -1% -8% -11% -14% -36% -73% -269% -54% 7%
Return on Capital Emp 0% -6% -11% -7% -13% -16% -13% -9% 12%
ASIAN OILFIELD SERVICES LTD SCREENER.IN

Narration Jun-09 Mar-10 Mar-11 Mar-12 Mar-13 Mar-14 Mar-15 Mar-16 Mar-17 Mar-18
Cash from Operating Activity 13.62 1.29 -7.84 -6.47 -10.55 15.31 -7.57 -1.11 -18.22 27.33
Cash from Investing Activity -9.69 -25.21 21.88 -12.91 -3.10 -45.41 -12.43 -2.41 -3.62 -29.21
Cash from Financing Activity -0.69 24.46 10.00 10.32 4.64 29.77 17.66 9.00 41.70 -16.99
Net Cash Flow 3.24 0.54 24.04 -9.06 -9.01 -0.33 -2.34 5.48 19.87 -18.87
How to use it?
You can customize this workbook as you want.
You can add custom formating, add conditional formating, add your own formulas… do ANYTHING.
Please don't edit the "Data Sheet" only.

After customization, you can upload this back on Screener.

Upload on: https://www.screener.in/excel/

Download your customized workbooks now onwards.

Now whenever you will "Export to excel" from Screener, it will export your customized file.

TESTING:
This is a testing feature currently.
You can report any formula errors on the worksheet at: [email protected]
COMPANY NAME ASIAN OILFIELD SERVICES LTD
LATEST VERSION 2.10 PLEASE
CURRENT VERSION 2.10

META
Number of shares 3.81
Face Value 10
Current Price 82.95
Market Capitalization 315.83

PROFIT & LOSS

Report Date Jun-09 Mar-10 Mar-11 Mar-12
Sales 61.70 18.56 64.14 41.43
Raw Material Cost
Change in Inventory
Power and Fuel 0.03 0.34 1.65 1.76
Other Mfr. Exp 42.22 7.85 22.75 24.73
Employee Cost 2.89 3.69 10.23 10.66
Selling and admin 4.51 3.95 13.16 9.10
Other Expenses 1.91 0.24 10.73 1.29
Other Income 2.48 0.87 -3.37 3.68
Depreciation 3.90 3.57 8.63 8.51
Interest 0.65 0.32 1.01 2.34
Profit before tax 8.07 -0.53 -7.39 -13.28
Tax 2.82 0.37 0.16 -4.24
Net profit 5.25 -0.90 -7.55 -9.04
Dividend Amount

Quarters
Report Date Sep-16 Dec-16 Mar-17 Jun-17
Sales 3.09 16.63 95.32 51.27
Expenses 18.75 13.63 97.49 38.64
Other Income 10.82 0.26 8.05 3.40
Depreciation 3.72 3.67 3.66 3.90
Interest 2.56 2.13 0.41 1.17
Profit before tax -11.12 -2.54 1.81 10.96
Tax 0.21
Net profit -11.13 -2.54 1.61 10.96
Operating Profit -15.66 3 -2.17 12.63

BALANCE SHEET
Report Date Jun-09 Mar-10 Mar-11 Mar-12
Equity Share Capital 11.27 15.32 15.32 15.32
Reserves 64.34 85.1 76.18 66.98
Borrowings 0.02 0.01 11 20.03
Other Liabilities 23.53 16.04 20.45 16.15
Total 99.16 116.47 122.95 118.48
Net Block 23.97 39.78 41.62 39.1
Capital Work in Progress 0.85 4.18 0.07
Investments 35.09 39.72 4 10.79
Other Assets 40.1 36.12 73.15 68.52
Total 99.16 116.47 122.95 118.48
Receivables 19.90 9.84 25.32 18.59
Inventory 2.32 3.49
Cash & Bank 7.45 7.98 32.03 26.99
No. of Equity Shares 11274444 15324444 15324444 15324444
New Bonus Shares
Face value 10 10 10 10

CASH FLOW:
Report Date Jun-09 Mar-10 Mar-11 Mar-12
Cash from Operating Activity 13.62 1.29 -7.84 -6.47
Cash from Investing Activity -9.69 -25.21 21.88 -12.91
Cash from Financing Activity -0.69 24.46 10.00 10.32
Net Cash Flow 3.24 0.54 24.04 -9.06

PRICE: 60.53 66.16 56.68 29.10

DERIVED:
Adjusted Equity Shares in Cr 1.13 1.53 1.53 1.53
 PLEASE DO NOT MAKE ANY CHANGES TO THIS SHEET

Mar-13 Mar-14 Mar-15 Mar-16 Mar-17 Mar-18

49.66 121.83 140.83 77.67 124.32 222.22

2.62 2.20 4.76 2.22 0.69 0.86

24.59 82.26 94.97 61.06 55.91 123.61
12.57 15.61 22.96 17.46 22.53 36.93
13.94 22.86 23.03 16.46 19.08 19.15
0.40 0.85 0.87 4.02 44.37 10.48
6.06 2.15 6.35 27.02 23.08 2.68
8.82 14.15 18.11 17.78 15.13 17.03
3.19 9.47 9.45 10.89 7.68 6.34
-10.40 -23.41 -26.97 -25.20 -18.00 10.50
-0.10 0.02 0.04 1.85 0.21 0.20
-10.29 -23.43 -27.01 -27.06 -18.20 10.30

Sep-17 Dec-17 Mar-18 Jun-18 Sep-18 Dec-18

32.85 54.65 83.45 63.15 38.05 49.78
25.65 50.61 66.61 56.04 32.09 37.25
1.16 5.22 -16.60 2.50 0.90 -2.09
4.30 4.38 4.45 4.76 4.92 5.26
1.39 1.40 2.39 1.66 2.91 1.45
2.67 3.48 -6.60 3.19 -0.97 3.73
0.20 0.01 0.03
 2.67 3.48 -6.80 3.18 -1.00 3.73
7.2 4.04 16.84 7.11 5.96 12.53

Mar-13 Mar-14 Mar-15 Mar-16 Mar-17 Mar-18

15.32 22.32 22.32 22.32 26.07 38.07
56.92 42.68 14.87 -12.26 7.72 102.46
27.47 46.65 69.97 110.16 82.64 25.9
20.72 60.96 42.7 50.39 92.88 86.06
120.43 172.61 149.86 170.61 209.31 252.49
38.39 116.76 106.01 95.41 83.4 100.1
3.59 8.17
5.95
72.5 47.68 43.85 75.2 125.91 152.39
120.43 172.61 149.86 170.61 209.31 252.49
15.29 10.98 18.86 42.91 27.51 61.61
5.91 4.22 3.81 5.67 1.57 1.88
18.24 9.35 3 9.66 29.14 24.57
15324444 22324444 22324444 22324444 26074444 38074444

10 10 10 10 10 10

Mar-13 Mar-14 Mar-15 Mar-16 Mar-17 Mar-18

-10.55 15.31 -7.57 -1.11 -18.22 27.33
-3.10 -45.41 -12.43 -2.41 -3.62 -29.21
4.64 29.77 17.66 9.00 41.70 -16.99
-9.01 -0.33 -2.34 5.48 19.87 -18.87

19.04 69.49 35.96 34.12 216.53 195.17

1.53 2.23 2.23 2.23 2.61 3.81