JUPITER WAGONS LTD SCREENER.

IN

Narration Mar-15 Mar-16 Mar-17 Mar-18 Mar-19 Mar-20 Mar-21 Mar-22 Mar-23 Mar-24 Trailing Best Case Worst Case
Sales 117.66 107.49 105.34 97.17 215.80 125.74 995.75 1,178.35 2,068.25 3,641.25 3,981.53 6,410.59 5,489.80
Expenses 201.59 120.35 103.72 97.11 203.65 123.65 889.42 1,064.20 1,814.32 3,150.22 3,430.53 5,523.43 4,867.17
Operating Profit -83.93 -12.86 1.62 0.06 12.15 2.09 106.33 114.15 253.93 491.03 551.00 887.16 622.63
Other Income 2.40 -52.54 0.44 1.16 109.04 9.84 1.83 3.39 5.09 20.99 33.91 - -
Depreciation 20.26 14.51 10.36 10.35 10.38 8.32 21.14 23.35 24.94 27.53 29.61 29.61 29.61
Interest 21.57 20.95 27.30 27.78 22.14 6.17 21.12 18.17 28.89 40.81 49.86 49.86 49.86
Profit before tax -123.36 -100.86 -35.60 -36.91 88.67 -2.56 65.90 76.02 205.19 443.68 505.44 807.69 543.16
Tax -20.81 3.90 - - - -2.42 12.40 25.99 79.82 110.89 125.51 25% 25%
Net profit -102.55 -104.76 -35.60 -36.91 88.67 -0.14 53.50 50.03 125.38 332.80 379.93 607.12 408.28
EPS -18.68 -19.08 -6.48 -6.72 9.91 -0.02 5.98 5.59 3.24 8.07 8.95 14.30 9.62
Price to earning -0.99 -0.90 -2.05 -2.18 2.01 -508.23 2.56 7.81 28.49 46.35 42.90 42.90 21.69
Price 18.55 17.10 13.30 14.65 19.95 7.95 15.30 43.65 92.20 374.15 383.95 613.55 208.58

RATIOS:
Dividend Payout 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 15.45% 7.43%
OPM 0.00% 0.00% 1.54% 0.06% 5.63% 1.66% 10.68% 9.69% 12.28% 13.49% 13.84%

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

Sales Growth 46.43% 65.89% 75.97% 54.06% 76.05% 76.05% 46.43%
OPM 11.34% 11.77% 12.08% 12.47% 13.84% 13.84% 11.34%
Price to Earning 21.69 21.69 25.62 31.39 42.90 42.90 21.69
JUPITER WAGONS LTD SCREENER.IN

Narration Sep-22 Dec-22 Mar-23 Jun-23 Sep-23 Dec-23 Mar-24 Jun-24 Sep-24 Dec-24
Sales 416.72 644.43 711.70 753.19 879.30 895.84 1,112.93 894.93 973.63 1,000.04
Expenses 366.78 563.74 618.68 655.85 758.12 771.03 965.21 766.07 840.34 858.91
Operating Profit 49.94 80.69 93.02 97.34 121.18 124.81 147.72 128.86 133.29 141.13
Other Income 0.99 1.92 1.01 2.22 5.38 4.97 8.41 7.27 7.59 10.64
Depreciation 6.58 6.14 6.19 6.54 7.12 6.84 7.02 7.28 7.55 7.76
Interest 7.15 7.43 8.72 8.37 10.42 11.46 10.56 11.86 14.90 12.54
Profit before tax 37.20 69.04 79.12 84.65 109.02 111.48 138.55 116.99 118.43 131.47
Tax 12.40 22.66 38.35 21.05 27.44 28.08 34.33 27.76 29.82 33.60
Net profit 24.80 46.38 40.78 63.60 81.58 83.40 104.22 89.23 88.62 97.86

OPM 12% 13% 13% 13% 14% 14% 13% 14% 14% 14%
JUPITER WAGONS LTD SCREENER.IN

Narration Mar-15 Mar-16 Mar-17 Mar-18 Mar-19 Mar-20 Mar-21 Mar-22 Mar-23 Mar-24
Equity Share Capital 54.94 54.94 54.94 54.94 89.48 89.48 387.45 387.45 387.45 412.29
Reserves 48.68 -56.08 -85.26 -122.12 6.37 5.96 245.83 295.87 421.15 1,209.68
Borrowings 148.75 160.63 162.70 172.18 41.51 50.20 137.68 139.21 288.08 338.07
Other Liabilities 70.35 76.02 92.75 103.53 71.22 54.25 220.28 250.28 542.09 835.65
Total 322.72 235.51 225.13 208.53 208.58 199.89 991.24 1,072.81 1,638.77 2,795.69

Net Block 214.96 158.52 144.68 134.53 112.97 111.05 416.24 425.74 462.59 517.52
Capital Work in Progress 13.82 2.00 1.99 1.98 0.13 5.75 20.72 22.20 26.34 29.47
Investments - - - - - - 3.89 10.04 16.45 452.25
Other Assets 93.94 74.99 78.46 72.02 95.48 83.09 550.39 614.83 1,133.39 1,796.45
Total 322.72 235.51 225.13 208.53 208.58 199.89 991.24 1,072.81 1,638.77 2,795.69

Working Capital 23.59 -1.03 -14.29 -31.51 24.26 28.84 330.11 364.55 591.30 960.80
Debtors 16.04 12.34 15.70 6.85 17.75 11.11 72.12 70.97 213.27 469.09
Inventory 16.57 9.80 6.97 9.27 14.44 47.57 244.30 319.43 491.23 906.75

Debtor Days 49.76 41.90 54.40 25.73 30.02 32.25 26.44 21.98 37.64 47.02
Inventory Turnover 7.10 10.97 15.11 10.48 14.94 2.64 4.08 3.69 4.21 4.02

Return on Equity -99% 93% 0% 8% 7% 16% 21%

Return on Capital Emp -39% -6% -8% 91% 3% 19% 12% 24% 32%
JUPITER WAGONS LTD SCREENER.IN

Narration Mar-15 Mar-16 Mar-17 Mar-18 Mar-19 Mar-20 Mar-21 Mar-22 Mar-23 Mar-24
Cash from Operating Activity 8.85 4.43 5.66 -0.75 9.22 -14.75 67.38 59.51 72.90 -6.35
Cash from Investing Activity -8.51 0.05 0.04 0.06 -1.10 -12.54 -60.20 -49.11 -118.99 -486.72
Cash from Financing Activity -6.96 -9.12 -5.33 3.60 11.56 7.08 22.39 -16.76 121.22 489.12
Net Cash Flow -6.61 -4.64 0.38 2.91 19.69 -20.21 29.57 -6.36 75.13 -3.95
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: support@screener.in
s… do ANYTHING.
COMPANY NAME JUPITER WAGONS LTD
LATEST VERSION 2.10 PLEAS
CURRENT VERSION 2.10

META
Number of shares 42.45
Face Value 10.00
Current Price 383.95
Market Capitalization 16,298.60

PROFIT & LOSS

Report Date Mar-15 Mar-16 Mar-17 Mar-18
Sales 117.66 107.49 105.34 97.17
Raw Material Cost 87.81 79.40 82.80 79.70
Change in Inventory -17.13 -4.48 -1.83 1.86
Power and Fuel 1.85 1.96 1.72 1.51
Other Mfr. Exp 6.46 6.66 6.30 5.52
Employee Cost 8.61 7.33 5.91 5.00
Selling and admin 16.52 5.97 4.23 4.48
Other Expenses 63.21 14.55 0.93 2.76
Other Income 2.40 -52.54 0.44 1.16
Depreciation 20.26 14.51 10.36 10.35
Interest 21.57 20.95 27.30 27.78
Profit before tax -123.36 -100.86 -35.60 -36.91
Tax -20.81 3.90
Net profit -102.55 -104.76 -35.60 -36.91
Dividend Amount

Quarters
Report Date Sep-22 Dec-22 Mar-23 Jun-23
Sales 416.72 644.43 711.70 753.19
Expenses 366.78 563.74 618.68 655.85
Other Income 0.99 1.92 1.01 2.22
Depreciation 6.58 6.14 6.19 6.54
Interest 7.15 7.43 8.72 8.37
Profit before tax 37.20 69.04 79.12 84.65
Tax 12.40 22.66 38.35 21.05
Net profit 24.80 46.38 40.78 63.60
Operating Profit 49.94 80.69 93.02 97.34

BALANCE SHEET
Report Date Mar-15 Mar-16 Mar-17 Mar-18
Equity Share Capital 54.94 54.94 54.94 54.94
Reserves 48.68 -56.08 -85.26 -122.12
Borrowings 148.75 160.63 162.70 172.18
Other Liabilities 70.35 76.02 92.75 103.53
Total 322.72 235.51 225.13 208.53
Net Block 214.96 158.52 144.68 134.53
Capital Work in Progress 13.82 2.00 1.99 1.98
Investments
Other Assets 93.94 74.99 78.46 72.02
Total 322.72 235.51 225.13 208.53
Receivables 16.04 12.34 15.70 6.85
Inventory 16.57 9.80 6.97 9.27
Cash & Bank 4.69 0.05 1.68 4.41
No. of Equity Shares 54,942,964.00 54,942,964.00 54,942,964.00 54,942,964.00
New Bonus Shares
Face value 10.00 10.00 10.00 10.00

CASH FLOW:
Report Date Mar-15 Mar-16 Mar-17 Mar-18
Cash from Operating Activity 8.85 4.43 5.66 -0.75
Cash from Investing Activity -8.51 0.05 0.04 0.06
Cash from Financing Activity -6.96 -9.12 -5.33 3.60
Net Cash Flow -6.61 -4.64 0.38 2.91

PRICE: 18.55 17.10 13.30 14.65

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

Mar-19 Mar-20 Mar-21 Mar-22 Mar-23 Mar-24

215.80 125.74 995.75 1,178.35 2,068.25 3,641.25
180.46 120.72 739.63 916.89 1,580.08 2,842.99
2.52 20.90 -1.99 20.04 5.61 14.61
2.59 2.21 23.70 25.18 33.51 47.76
10.86 7.21 68.08 77.70 119.76 162.87
6.85 9.08 26.34 33.92 41.39 50.95
4.83 4.05 25.43 27.32 33.59 47.97
0.58 1.28 4.25 3.23 11.60 12.29
109.04 9.84 1.83 3.39 5.09 20.99
10.38 8.32 21.14 23.35 24.94 27.53
22.14 6.17 21.12 18.17 28.89 40.81
88.67 -2.56 65.90 76.02 205.19 443.68
-2.42 12.40 25.99 79.82 110.89
88.67 -0.14 53.50 50.03 125.38 332.80
19.37 24.74

Sep-23 Dec-23 Mar-24 Jun-24 Sep-24 Dec-24

879.30 895.84 1,112.93 894.93 973.63 1,000.04
758.12 771.03 965.21 766.07 840.34 858.91
5.38 4.97 8.41 7.27 7.59 10.64
7.12 6.84 7.02 7.28 7.55 7.76
10.42 11.46 10.56 11.86 14.90 12.54
109.02 111.48 138.55 116.99 118.43 131.47
27.44 28.08 34.33 27.76 29.82 33.60
 81.58 83.40 104.22 89.23 88.62 97.86
121.18 124.81 147.72 128.86 133.29 141.13

Mar-19 Mar-20 Mar-21 Mar-22 Mar-23 Mar-24

89.48 89.48 387.45 387.45 387.45 412.29
6.37 5.96 245.83 295.87 421.15 1,209.68
41.51 50.20 137.68 139.21 288.08 338.07
71.22 54.25 220.28 250.28 542.09 835.65
208.58 199.89 991.24 1,072.81 1,638.77 2,795.69
112.97 111.05 416.24 425.74 462.59 517.52
0.13 5.75 20.72 22.20 26.34 29.47
3.89 10.04 16.45 452.25
95.48 83.09 550.39 614.83 1,133.39 1,796.45
208.58 199.89 991.24 1,072.81 1,638.77 2,795.69
17.75 11.11 72.12 70.97 213.27 469.09
14.44 47.57 244.30 319.43 491.23 906.75
23.90 4.50 71.36 68.88 166.07 180.18
89,482,657.00 89,482,657.00 ### ### ### ###

10.00 10.00 10.00 10.00 10.00 10.00

Mar-19 Mar-20 Mar-21 Mar-22 Mar-23 Mar-24

9.22 -14.75 67.38 59.51 72.90 -6.35
-1.10 -12.54 -60.20 -49.11 -118.99 -486.72
11.56 7.08 22.39 -16.76 121.22 489.12
19.69 -20.21 29.57 -6.36 75.13 -3.95

19.95 7.95 15.30 43.65 92.20 374.15

8.95 8.95 8.95 8.95 38.74 41.23