Scribd
Upload
68 views4 pages

Solar Power Doc 4

The document provides financial information for a company over multiple years, including income tax payable, EBITDA, interest expenses, tax depreciation, annual taxable income, MAT credit balances, and depreciation calculations. It shows that the company had tax losses carried forward for several years but became profitable starting in FY2029-30, with income tax payable each year and a growing MAT credit balance.

Uploaded by

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

Solar Power Doc 4

The document provides financial information for a company over multiple years, including income tax payable, EBITDA, interest expenses, tax depreciation, annual taxable income, MAT credit balances, and depreciation calculations. It shows that the company had tax losses carried forward for several years but became profitable starting in FY2029-30, with income tax payable each year and a growing MAT credit balance.

Uploaded by

Sunil Peeroji
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 4

Dep & Tax Schedule

All Numbers in INR Crore


Income Tax Payable 31/Mar/18 31/Mar/19 31/Mar/20 31/Mar/21
EBITDA 15.44 30.43 29.96 29.48
Interest on Term Loan 8.68 15.84 14.99 14.02
Interest on Working Capital 0.11 0.16 0.21 0.21
Tax Depreciation 17.27 32.21 27.86 24.10
Annual taxable income (10.62) (17.79) (13.11) (8.86)
less: carryforward of losses - (10.62) (7.17) (5.94)
Taxable Income (10.62) (7.17) (5.94) (2.91)
Income Tax Rate 33.99% 33.99% 33.99% 33.99%
Income Tax as per IT Act - - - -

Profit before tax 1.57 4.25 4.58 5.07


MAT Rate 20.96% 20.96% 20.96% 20.96%
Tax as per MAT Act 0.33 0.89 0.96 1.06

Diff. to be set off - - - -


MAT Credit earned 0.33 0.89 0.96 1.06
MAT credit op. balance - 0.33 1.22 2.18
MAT set off - - - -
MAT credit cl. Balance 0.33 1.22 2.18 3.24
MAT credit being lapsed
Adjust. Of credit availed before lapsing
MAT credit available after lapsed 0.33 1.22 2.18 3.24

Income Tax Payable 0.33 0.89 0.96 1.06

Depreciation Calculations 31/Mar/18 31/Mar/19 31/Mar/20 31/Mar/21


Months of Operation 6 12 12 12
Total Project Cost 255.88
Book Dep Rate 3.98%
Tax Dep Rate 13.50%
Depreciatable Value 230.29

Book Depreciation
Op. Bal 255.88 250.79 240.62 230.45
Less: Depreciation 5.09 10.17 10.17 10.17
Cl. Bal 250.79 240.62 230.45 220.28

Tax Depreciation
Op. Bal 255.88 238.61 206.40 178.53
Less: Depreciation 17.27 32.21 27.86 24.10
Cl. Bal 238.61 206.40 178.53 154.43
31/Mar/22 31/Mar/23 31/Mar/24 31/Mar/25 31/Mar/26 31/Mar/27 31/Mar/28
28.99 28.48 27.96 27.43 26.88 26.32 25.74
13.04 12.00 11.10 10.26 9.40 8.51 7.59
0.21 0.21 0.21 0.21 0.21 0.20 0.20
20.85 18.03 15.60 13.49 11.67 10.10 8.73
(5.11) (1.76) 1.06 3.48 5.60 7.51 9.21
(2.91) (2.20) - - - - -
(2.20) 0.43 1.06 3.48 5.60 7.51 9.21
33.99% 33.99% 33.99% 33.99% 33.99% 33.99% 33.99%
- 0.15 0.36 1.18 1.91 2.55 3.13

5.56 6.10 6.48 6.80 7.11 7.44 7.77


20.96% 20.96% 20.96% 20.96% 20.96% 20.96% 20.96%
1.17 1.28 1.36 1.42 1.49 1.56 1.63

- - - - 0.42 0.99 1.50


1.17 1.13 1.00 0.24 - - -
3.24 4.41 5.54 6.54 6.78 6.37 5.37
- - - - 0.42 0.99 1.50
4.41 5.54 6.54 6.78 6.37 5.37 3.87
0.33
0.33
4.41 5.54 6.54 6.78 6.37 5.37 3.87

1.17 1.28 1.36 1.42 1.49 1.56 1.63

31/Mar/22 31/Mar/23 31/Mar/24 31/Mar/25 31/Mar/26 31/Mar/27 31/Mar/28


12 12 12 12 12 12 12

220.28 210.11 199.94 189.77 179.60 169.42 159.25


10.17 10.17 10.17 10.17 10.17 10.17 10.17
210.11 199.94 189.77 179.60 169.42 159.25 149.08

154.43 133.58 115.55 99.95 86.46 74.78 64.69


20.85 18.03 15.60 13.49 11.67 10.10 8.73
133.58 115.55 99.95 86.46 74.78 64.69 55.96
31/Mar/29 31/Mar/30 31/Mar/31 31/Mar/32 31/Mar/33 31/Mar/34 31/Mar/35
25.13 24.51 23.87 23.21 22.52 21.80 21.06
6.60 5.57 4.50 3.38 2.20 0.97 0.08
0.20 0.20 0.20 0.20 0.20 0.19 0.19
7.55 6.53 5.65 4.89 4.23 1.51 -
10.78 12.21 13.52 14.73 15.89 19.13 20.79
- - - - - - -
10.78 12.21 13.52 14.73 15.89 19.13 20.79
33.99% 33.99% 33.99% 33.99% 33.99% 33.99% 33.99%
3.66 4.15 4.60 5.01 5.40 6.50 7.07

8.17 8.57 9.00 9.45 9.95 10.47 10.61


20.96% 20.96% 20.96% 20.96% 20.96% 20.96% 20.96%
1.71 1.80 1.89 1.98 2.09 2.19 2.22

1.95 2.35 2.71 3.03 3.32 4.31 4.84


- - - - - - -
3.87 1.92 - - - - -
1.95 1.92 - - - - -
1.92 - - - - - -
0.89 0.96 - - - - -
0.89 0.96 - - - - -
1.92 - - - - - -

1.71 2.23 4.60 5.01 5.40 6.50 7.07

31/Mar/29 31/Mar/30 31/Mar/31 31/Mar/32 31/Mar/33 31/Mar/34 31/Mar/35


12 12 12 12 12 12 12

149.08 138.91 128.74 118.57 108.40 98.23 88.05


10.17 10.17 10.17 10.17 10.17 10.17 10.17
138.91 128.74 118.57 108.40 98.23 88.05 77.88

55.96 48.40 41.87 36.22 31.33 27.10 25.59


7.55 6.53 5.65 4.89 4.23 1.51 -
48.40 41.87 36.22 31.33 27.10 25.59 25.59
31/Mar/36 31/Mar/37 31/Mar/38 31/Mar/39 31/Mar/40 31/Mar/41 31/Mar/42
20.29 19.49 18.66 17.80 16.90 15.96 14.98
- - - - - - -
0.19 0.19 0.19 0.19 0.19 0.18 0.18
- - - - - - -
20.10 19.30 18.47 17.61 16.71 15.77 14.79
- - - - - - -
20.10 19.30 18.47 17.61 16.71 15.77 14.79
33.99% 33.99% 33.99% 33.99% 33.99% 33.99% 33.99%
6.83 6.56 6.28 5.99 5.68 5.36 5.03

9.93 9.13 8.30 7.44 6.54 14.33 14.79


20.96% 20.96% 20.96% 20.96% 20.96% 20.96% 20.96%
2.08 1.91 1.74 1.56 1.37 3.00 3.10

4.75 4.65 4.54 4.43 4.31 2.36 1.93


- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -

6.83 6.56 6.28 5.99 5.68 5.36 5.03

31/Mar/36 31/Mar/37 31/Mar/38 31/Mar/39 31/Mar/40 31/Mar/41 31/Mar/42


12 12 12 12 12 12 12

77.88 67.71 57.54 47.37 37.20 27.03 25.59


10.17 10.17 10.17 10.17 10.17 1.44 0.00
67.71 57.54 47.37 37.20 27.03 25.59 25.59

25.59 25.59 25.59 25.59 25.59 25.59 25.59


- - - - - - -
25.59 25.59 25.59 25.59 25.59 25.59 25.59

You might also like