AccessEngineering

Valuation

Valuation Rs.Million Price per Share (Rs.) Share Adjusted Valuation
DCF Valuation %
Price to Earnings %
Price to Book Value %
Price to Sales %
EV to EBITDA %
Blended Valuation (Rs.)

Period FY21 FY22 FY23 4Q23 1Q24 2Q24 3Q24E 4Q24E FY24 1Q25E 2Q25E 3Q25E 4Q25E FY25E FY26E FY27E FY28E FY29E
1 Construction 17,300.1 20,334.8 11,601.9 12,633.9
YoY nan 1754.2 -4294.6 889.6
2 Construction related material 7,643.2 17,653.2 8,230.8 7,082.3
YoY nan 13096.7 -5337.5 -1395.4
3 Property 741.8 841.1 1,499.5 2,939.3
YoY nan 1337.5 7828.8 9602.0
4 Automobile 3,881.6 3,193.9 1,931.0 2,173.5
YoY nan -1771.6 -3954.2 1255.7
5 Adjustments and eliminations -5,729.7 -2,393.4 -2,698.5 -3,327.9
0 nan nan nan nan
Period FY21 FY22 FY23 3Q24E 4Q24E FY24 1Q25E 2Q25E 3Q25E 4Q25E FY25E FY26E FY27E FY28E FY29E
1 COGS 19,698.7 34,317.8 14,705.8 14,145.5
- As a % of sales 78.4% 83.7% 65.5% 60.6%
2 Administration 662.3 1,011.2 861.0 781.1
- As a % of sales 7.0% 5.4% 10.1% 8.7%
3 Selling & Distribution 0.0 0.0 32.6 85.1
- As a % of sales -0.1% -0.1% -0.4% -0.1%
4 Capital Expenditure 1,520.3 5.6 372.4 310.8
- As a % of sales 6.4% 0.0% 1.8% 1.4%


Fixed Assets - Cost FY21 FY22 FY23 3Q24E 4Q24E FY24E 1Q25E 2Q25E 3Q25E 4Q25E FY25E FY26E FY27E FY28E FY29E
1 Balance B/F 11,220.1 12,689.9 14,076.5 14,295.4 15,709.9
Capital Expenditure 1,520.3 5.6 372.4
Balance C/F 12,689.9 14,076.5 14,295.4 15,709.9
1.1 Depreciation FY21 FY22 FY23 3Q24E 4Q24E FY24 1Q25E 2Q25E 3Q25E 4Q25E FY25E FY26E FY27E FY28E FY29E
Balance B/F 6,283.2 6,982.1 7,917.2 8,725.6 9,643.1
Depreciation charge 1,016.6 1,162.6 1,235.2 1,115.9
- As a % of sales 4.3% 2.9% 6.0% 5.2%
Balance C/F 6,982.1 7,917.2 8,725.6 9,643.1 111 111 111 111 111
Net Book Value at end 5,707.8 6,159.3 5,569.7 6,066.8
2 Working Capital
Period FY21 FY22 FY23 3Q24E 4Q24E FY24 1Q25E 2Q25E 3Q25E 4Q25E FY25E FY26E FY27E FY28E FY29E
2.1 Accounts and notes receivables 14,185.4 25,160.6 15,587.4 15,794.4
- As a % of sales 59.5 63.5 75.8 73.5
Four Qtr Cum. Revenue
Four Qtr Cum. COGS
2.2 Inventories 8,714.5 14,619.9 15,945.3 20,341.3
- As a % of COGS 44.2 42.6 108.4 143.8
2.3 Prepayments 0.0 0.0 0.0 0.0
- As a % of sales 0 0 0 0
2.4 Accounts payable 17,307.3 25,161.7 28,870.4 34,061.2
- As a % of COGS 87.9 73.3 196.3 240.8
2.5 Other 0.0 0.0 0.0 0.0
- As a % of COGS 0.0 0.0 0.0
Working Capital
Change in Working Capital 438.7
3 Interest Bearing Debt FY21 FY22 FY23 3Q24E 4Q24E FY24 1Q25E 2Q25E 3Q25E 4Q25E FY25E FY26E FY27E FY28E FY29E
Opening balance 10,784.2 8,963.1 23,046.9 0.0
Issuance of debt 26,806.6 42,174.0 14,992.0 36,456.8
Repayment of debt 28,753.9 28,090.3 21,800.0 31,437.8
Closing balance 126.3 0.0 0.0 0.0
Adjustments 8,963.2 23,046.9 16,238.8
Interest Expenses 432.2 1,009.1 3,706.6 2,479.2
Average Interest rate (%) 437.7 630.5 1887.0 % % 1322.4 % % % % % % % % %
4 Leases FY21 FY22 FY23 3Q24E 4Q24E FY24 1Q25E 2Q25E 3Q25E 4Q25E FY25E FY26E FY27E FY28E FY29E
Leases - Opening balance 147.8 143.9 262.7 263.5 267.3
Additions 7.8 2,420.0 122.9 0.0 0.0 0.0
Payments 25.4 2,328.8 55.8 64.1
Closing balance 143.9 262.3 263.5 267.3
Adjustments -4.8 -0.4 -101.0 -0.0
Lease Interest expenses 18.5 27.5 34.8 29.6
Average Interest rate (%) 12.7 13.6 13.2 % % 11.2 % % % % % % % % %
5 Interest Income FY21 FY22 FY23 3Q24E 4Q24E FY24 1Q25E 2Q25E 3Q25E 4Q25E FY25E FY26E FY27E FY28E FY29E
i. Cash & CE Balance C/F 2,208.0 696.1 3,459.0
ii. Interest Income 557.0 503.8 893.7 390.5
Average Interest Income Rate 10.3 8.7 22.5 % % 6.0 % % % % % % % % %
6 Tax FY21 FY22 FY23 3Q24E 4Q24E FY24 1Q25E 2Q25E 3Q25E 4Q25E FY25E FY26E FY27E FY28E FY29E
Profit Before Tax 2,406.9 4,613.1 4,377.3 4,304.6
Opening balance 126.9 257.2 -9.0
Current Income Tax 13.6 -517.5 1,940.9 -2,549.0
Taxes paid 288.0 709.7 181.5 667.5 -2,549.0
Closing balance - Calculated 257.2 -9.0 198.0 188.6
Effective Tax Rate (%) 0 0 0 % % % % % % % % % % %


Income Statement Notes FY21 FY22 FY23 1Q24 2Q24 3Q24E 4Q24E FY24 1Q25E 2Q25E 3Q25E 4Q25E FY25E FY26E FY27E FY28E FY29E
Combined Revenue 23,837.0 39,629.6 20,564.6 21,501.1
COGS 19,698.7 34,317.8 14,705.8
Gross Profit 4,138.4 5,311.8 5,858.8 7,355.6
Administration Exp. 662.3 1,011.2 861.0
Selling & Distribution Exp. 0.0 0.0 32.6
Depreciation 1,016.6 1,162.6 1,235.2 1,115.9
7. Amortisation
Other Operating Expenses -53.0 -42.8 2,752.4 nan
Operating Income 2,978.8 4,211.7 7,833.7 6,867.8
Interest Expenses 1,129.6 1,537.5 4,757.0 2,986.9
Interest Income 557.0 503.8 893.7
Other (Expenses)/Income 0.7 1,435.1 406.9 nan
Profit Before Tax 2,406.9 4,613.1 4,377.3 4,304.6
Tax Expenses 13.6 -517.5 1,940.9
Profit After Tax 2,393.3 5,130.2 2,436.3
Other 0.0 0.0 0.0 nan
Net Income 2,393.3 5,130.2 2,436.3
Cash Flow Statement Forecast Ref. FY21 FY22 FY23 1Q24 2Q24 3Q24E 4Q24E FY24 1Q25E 2Q25E 3Q25E 4Q25E FY25E FY26E FY27E FY28E FY29E
Profit Before Tax From IS 2,406.9 4,613.1 4,377.3 4,304.6
Depreciation From OA 1.1 1,016.6 1,162.6 1,235.2 1,115.9
Change in Working Capital From OA 2 5,734.6 -9,494.9 11,881.7 438.7
Income Tax Paid From OA 5 288.0 709.7 181.5 667.5
Other -394.9 -1,636.4 -3,800.1 -825.4
Net Cash Flow from / (used in) Operating Activities 8,528.6 -5,994.9 13,644.5 4,486.5
Capital Expenditure From CA 4 1,520.3 5.6 372.4 310.8
Other -4,277.8 -1,870.6 -8,677.4 -4,266.9
Cash Flows from Investing Activities -5,808.3 -4,477.2 -9,172.8 -4,619.3
Borrowings 26,806.5 42,174.0 14,991.9 36,456.8
Debt Repayments 23,929.8 21,800.0 21,800.0 31,437.2
10. Lease Additions
Lease Repayments 25.4 55.8 55.8 64.1
Other -5,324.1 -1,102.8 -750.0 -500.6
Net Cash flows from / (used in) Financing Activities -2,472.8 10,653.4 -7,613.9 4,455.0
Other 0.0 0.0 0.0 0.0
Net Increase/(Decrease) in Cash and Cash Equivalents 247.6 181.3 -3,142.1 4,322.1
Balance adjustments as per company 327.1 130.9 1,761.1 201.9
Cash and CE at Start 1,648.2 1,895.8 2,077.1 -1,065.0 3,257.1
Cash and CE at End 1,895.8 2,077.1 -1,065.0 3,257.1
Balance Sheet Notes FY21 FY22 FY23 1Q24 2Q24 3Q24E 4Q24E FY24 1Q25E 2Q25E 3Q25E 4Q25E FY25E FY26E FY27E FY28E FY29E
Assets
Property Plant and Equipment - Net Book value From OA 1 5,707.8 6,159.3 5,569.7 6,066.8
2. Right-of-use assets 10,573.1 17,831.5 21,307.7 36,362.6 35,050.0 35,050.0 35,050.0 35,050.0 35,050.0
3. Intangible assets 6,605.1 1,768.8 11,721.0 2,263.4 2,537.6 2,537.6 2,537.6 2,537.6 2,537.6
4. Investment in an associate 1,235.1 1,257.8 578.3 563.7 561.7 561.7 561.7 561.7 561.7
5. Other financial assets 228.8 2,736.7 2,674.6 2,610.7 nan nan nan nan nan
6. Deferred income tax assets 48.0 0.5 0.5 1.4 0.5 0.5 0.5 0.5 0.5
Other 1,290.1 3,811.2 2,559.9 6,383.4 6,817.5 6,817.5 6,817.5 6,817.5 6,817.5
Non Current Assets 25,688.0 33,565.8 44,411.8 54,252.0
Inventories From OA 2.2 8,714.5 14,619.9 15,945.3 20,341.3
Trade and Other Receivables From OA 2.1 14,185.4 25,160.6 15,587.4 15,794.4
Prepayments From OA 2.3 0.0 0.0 0.0 0.0
Other 348.4 599.2 285.7 348.0 86.5 86.5 86.5 86.5 86.5
12. Other financial assets 3,120.4 3,557.4 3,220.2 2,920.8 2,984.0 2,984.0 2,984.0 2,984.0 2,984.0
13. Income tax recoverable 1,779.9 2,136.0 2,569.3 1,416.9 1,585.8 1,585.8 1,585.8 1,585.8 1,585.8
Cash and Cash Equivalents From CFS 2,223.0 2,208.0 696.1 3,459.0
Current Assets 30,371.5 48,281.1 38,304.0 44,280.3
Total Assets 56,059.5 81,846.9 82,715.9
Equities and Liabilities
1. Stated capital 9,000.0 9,000.0 9,000.0 9,000.0 9,000.0 9,000.0 9,000.0 9,000.0 9,000.0
2. Reserves 19,741.3 580.2 580.2 815.6 816.0 812.0 812.0 812.0 812.0 812.0
Retained Earnings 14,245.3 18,610.2 19,741.3 26,018.2
nan nan nan nan nan nan nan nan nan nan
Equity attributable to equity holders of parent
5. Non-controlling interest 2,689.3 2,460.6 2,415.1 2,408.8 2,465.9 2,465.9 2,465.9 2,465.9 2,465.9
Total Equity 26,514.8 30,647.3 31,972.0 38,243.0
Long Term Debt From OA 3 6,166.8 18,847.0 12,786.6 17,029.6
Financing and Lease Payables From OA 4 143.9 262.3 263.5 267.3
Government grants 5.3 5.0 4.8 4.6 4.6 4.6 4.6 4.6 4.6
Defined benefit obligations 426.2 323.5 261.0 366.3 370.4 370.4 370.4 370.4 370.4
Deferred tax liability 1,980.8 2,116.6 2,958.6 3,383.2 3,069.4 3,069.4 3,069.4 3,069.4 3,069.4
Non Current Liabilities 8,694.8 21,419.5 16,233.3 20,961.9
Current Maturities of Long Term Debt Added to LT debt in the forecast 2,796.4 2,796.4 3,452.2 4,228.3
Trade Payables From OA 2.4 17,307.3 25,161.7 28,870.4 34,061.2
13. Amounts due to related parties nan nan nan nan 0.0 0.0 0.0 0.0 0.0
Income Tax Liabilities From OA 6 257.2 -9.0 198.0 188.6
Other Accruals From OA 2.5 0 0 0 0 0
Other 62.1 107.7 135.1 404.6 367.5 367.5 367.5 367.5 367.5
Bank Overdraft 327.1 130.9 1,761.1 201.9 nan nan nan nan nan
Current Liabilities 20,850.0 29,780.1 34,510.6 39,327.4
Total Equity and Liabilities 56,059.5 81,846.9 82,715.9 98,532.3

DCF Enterprise Value

Period Notes 3Q24E 4Q24E FY24E 1Q25E 2Q25E 3Q25E 4Q25E FY25E FY26E FY27E FY28E FY29E
1. EBIT From FF 6
2. Tax From OA 4
3. Depreciation From OA 1
4. Adjustments User Input
5. Capital Expenditure From CA 4
6. Changes in Working Capital From OA 2
7. Free Cash Flow
8. Terminal Value
9. Total Free Cash Flow
10. Discount factor Calculation
11. Present Value of Free Cash Flows 7*10=11
12. DCF Enterprise Value
13. Net (Debt)/Cash -15,193.4
14. Pension Underfunding From BS
15. Other User input cell
14. Adjustment User Input
15. DCF Valuation - Equity Value
16. Number of Shares 1,000.0
17. Price per Share (Rs.)

Weighted Average Costs of Capital (WACC)

Symbol User Input Reference Source for Reference
1. Risk Free Rate Rf % 18.8% SL 10yr bond yield
2. Long term cost of debt Kd % 25.0% Weighted avg. int. rate
3. Equity risk premium Rp % 10.0% External Source
4. Beta B % 125.0% CSE
5.Tax Rate t % 30.0% SL tax rate
6. Debt Weighting Wd % 50.0%
7. Equity Weighting We % 50.0%
8. Cost of Equity Ke 1+(3*4)=8 25.0%
9. WACC Dr (6*(2*(1-5)))+(7*8)=9 21.0%
10. Terminal Growth Rate % 5.0%
Notes Price to Earnings Price to Book Value Price to Sales
1. Earnings/Book Value/Sales 38,243.0
2. Adjusted Multiple
3. Valuation (Rs. Millions) 1*2=3
4. Number of Shares (Millions) 1,000.0 1,000.0 1,000.0
5. Price per Share(Rs.)
>
Peer Multiples Notes Price to Earnings Price to Book Value Price to Sales
Average
Adjustment
Adjusted Multiple
Date Research Organisation Recommendation Target Price (Rs.)
0 2736.746067 0 0

Insert Your Report Prompt Here


AI Draft

Your Draft