Balance Sheet
Particulars Mar-23 Mar-22
Rs. Rs. In Lakhs Rs.
LIABILITIES
Equity and Laiblities
Share Capital -
R&S -
Total Networth - - -
Share application money pending
allotment
A) Non Current Liabilities:
Long Term provisions - - -
Long Term Borrowings
Deffered tax liabilities (Net) - ###
- -
Other long term liabilities - - -
Total (A) - - -
B) Current Liablities:
Short Term Borrowings -
Trade Payables -
Other current liabilities -
Other Current Financial Liablilities -
- -
Short Term Provision
Total (B) - - -
Total (A +B) - - -
-
-
ASSETS -
A) Non Current Asset: -
Fixed Assets - Tangible -
Fixed Assets - Intangible -
Fixed Assets -WIP -
Non Current Investment -
Deffered tax Assets -
Long Term Loans and Advances -
Other Non Current Financial Asset -
Other Non Current Assets -
Total (A) - - -
-
B) Current Assets: -
Inventories -
Trade Receivables -
Cash and Banks -
Short Term Loans and Advances -
Current Investments -
Current Tax Assets -
Other current Assets -
Total (B) - - -
Total (A +B) - - -
Balancesheet Check - -
ROCE % #DIV/0! #DIV/0!
RONW % #DIV/0! #DIV/0!
Asset turnover #DIV/0! #DIV/0!
Debtors days #DIV/0! #DIV/0!
Net working cap days #DIV/0! #DIV/0!
Debt/Equity #DIV/0! #DIV/0!
Net Tangible Assets - -
Profit & Loss
Particulars Mar-23
Rs. In Lakhs Rs. Rs. In Lakhs
Revenues -
Other Income -
- Total Revenue - -
- Expenses - -
- EBDITA -
- Finance Cost -
Depreciation & Amortization exp -
Total FC + D/A - -
-
- Extraordinary Items -
- Profit before tax - -
- Prior Period Taxes -
- Less: Current Tax -
Less: Deferred Tax -
Profit for the year - -
-
-
- #DIV/0!
Earning per equity share for face
value Rs. 10 each basic and diluted
- (in Rs.) #DIV/0!
-
-
EBIDTA % #DIV/0!
- PAT % #DIV/0!
- Book Value #DIV/0!
-
- EBIT -
- Capital Employeed -
- ROCE #DIV/0! ###
- CA 0.00
- CL 0.00
- Total revenue 0.00
- WC Days #DIV/0!
-
-
-
- Total Sales
- Inventory #DIV/0!
- Trade Receivable #DIV/0!
- Trade Payable #DIV/0!
- WC Days #DIV/0!
-
-
-
-
-
-
-
Mar-22
Rs. Rs. In Lakhs
- -
-
- -
- - -
-
- -
-
- -
-
- -
-
-
-
- -
-
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
-
-
#DIV/0!
0.00
0.00
0.00
#DIV/0!
Particulars FY 23 FY 22
Revenue from Operations 0.00 0.00
Other Income 0.00 0.00
Total Income 0.00 0.00
Total Expenses 0.00 0.00
EBITDA 0.00 0.00
EBITDA % #DIV/0! #DIV/0!
Finance Cost 0.00 0.00
Deprecation 0.00 0.00
Extra Ordinary Items 0.00 0.00
PBT 0.00 0.00
PAT 0.00 0.00
PAT % #DIV/0! #DIV/0!
Particulars FY 23 FY 22
Profitability (%)
PAT Margin #DIV/0! #DIV/0!
RONW #DIV/0! #DIV/0!
Leverage
Debt/ Equity #DIV/0! #DIV/0!
ROCE #DIV/0! #DIV/0!
Particulars FY 23
Sources of Funds
Share Capital 0.00
Reserves & Surplus 0.00
Total Net-Worth 0.00
Long Term Borrowings 0.00
Long Term Provisions 0.00
Other Long Term Liabilities 0.00
Short Term Borrowing 0.00
Trade Payables 0.00
Other Current Liabilities 2498.16
Other Current Financial Liabilities 0.00
Short Term Provisions 0.00
Total 0.00
Application of Funds
Fixed Assets - Tangible 0.00
Fixed Assets - Intangible 0.00
Capital WIP 0.00
Non Current Investment 0.00
Deferred Tax Asset 0.00
Long Term Loans & Advances 0.00
Other Non Current Financial Assets 0.00
Other Non Current Assets 0.00
Current Assets 0.00
Total 0.00
FY 22
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
1618.87
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
Amount in Rs.
Issue related statistics
No. of Shares Pre-issue -
Bonus issue
Bonus shares -
Total shares post bonus allotment -
Conversion of existing loan from promoters' #DIV/0!
Preferential Allotment at IPO price #DIV/0!
Promoter Holding Pre-issue (no of shares) #DIV/0!
Promoter Holding % 100%
Required Post-issue Promoter holding % 73%
Total promoter holding #DIV/0!
Post issue no of shares #DIV/0!
Min Issue Size (No. of shares) #DIV/0!
Post Issue Paid up Capital (Rs Cr) #DIV/0!
Issue Size at face Value (Rs Cr) #DIV/0!
-
Conversion of loan from director's/shareholders
Existing loan from directors' and shareholders'
Conversion of loan at IPO price #DIV/0!
Preference Allotment
Amount of preference allotment
No. of shares #DIV/0!
Particulars March 24 March 23 March 22
PAT - -
EPS #DIV/0! #DIV/0! #DIV/0!
Bonus shares - - -
EPS after bonus #DIV/0! #DIV/0! #DIV/0!
Weigths 3.00 2.00 1.00
EPS Product #DIV/0! #DIV/0! #DIV/0!
Wtd Avg EPS #DIV/0!
EPS (Post Issue) #DIV/0!
P/E Post issue #DIV/0! #DIV/0! #DIV/0!
Sensitivity Analysis (Issue Price & Size)
PE Ratio
Price (Rs)
Issue Size (Rs Cr) - Public #DIV/0! #DIV/0! #DIV/0!
Post Issue Valuation of
Company (Rs Cr) #DIV/0! #DIV/0! #DIV/0!
Book Value #DIV/0!
2022 2023 2024
PAT
EPS #DIV/0! #DIV/0! #DIV/0!
Price
PE #DIV/0! #DIV/0! #DIV/0!
Market Cap #DIV/0! #DIV/0! #DIV/0!
Promoter Wealth #DIV/0! #DIV/0! #DIV/0!
CHECK
Promoter contribution available for lock should be >20%
Bonus issue shound not be >existing reserves & surplus
#DIV/0!
0.00
690
11000
1.30434782608696
14347.8260869565
3347.82608695652
17070.55
2725.55
6073.37608695652
PARTICULARS
Share Capital (Rs.)
Existing Share Capital (No. of Shares)
Networth (in Rs) (Estimated for FY 2024)
Share Capital (No. of Shares)(FV-Rs. 10)
Issue of Bonus Shares (3:1)
Total No. of Shares (Post Bonus)
Proposed Fresh Issue of Shares in IPO (in No. )
Total No. of Shares (Post IPO)
Dilution / Public Issue (%)
Promoters Holding Post Public Issue (%)
PAT (Rs .) (Estimated for FY 2024)
EPS (Post Issue) (in Rs)
Tentative Issue Price (in Rs)
P/E Ratio based on Post Issue EPS
Issue Size (Rs in Cr.)
Post Issue Valuation of Company (in Cr.)
Share Capital (Rs.)
Existing Share Capital (No. of Shares)
Reserves & Surplus (in Rs)
Networth (in Rs)
Share Capital (No. of Shares) (FY21) Note 1
Issue of Bonus Shares
Total No. of Shares (Post Bonus)
OFS
Proposed Fresh Issue of Shares in IPO (in No. )
Total No. of Shares for IPO
Total No. of Shares (Post IPO)
Dilution / Public Issue (%)
Promoters Holding Post Public Issue (%)
PAT (Rs .) (Estimated for FY 2020)
EPS (Post Issue) (in Rs)
Tentative Issue Price (in Rs)
P/E Ratio based on Post Issue EPS
Issue Size (Rs in Cr.)
Post Issue Valuation of Company (in Cr.)
TICULARS
0
0
0
0
0
0
#DIV/0!
#DIV/0!
27%
73%
0
#DIV/0!
0 0 0
#DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0!
4565200
45652000
83840130
129492130
4565200
913040
5478240
2026198.35616438
7504438.35616438
0.27
0.73
18000000
1.33254475890067
10 12 14
7.50443835616439 9.00532602739726 10.5062136986301
2.02619835616438 2.43143802739726 2.83667769863014
7.50443835616438 9.00532602739726 10.5062136986301
1040800
104080
264041199
265081999
104080
6244800 60
6348880 Pre Issue
#REF!
#REF! OFS 320,000,000.00
#REF!
#REF! Fresh Issue #REF!
#REF! Total
0.73
60000000
#REF!
33
#REF!
#REF!
#REF!
Illustrative Example
> Growth in Turnover & PAT has been assumed for Init
The listed peer trading at a PE multiple ranging from
Turnover in PROFITS in
YEARS (EPS in Rs.) P/E MULTIPLE
Crores Crores
2024 80 8.00 #DIV/0! Issue Price
2025 100 10.00 #DIV/0! 10
2026 125 12.00 #DIV/0! 12
2027 156 16.00 #DIV/0! 15
2028 200 20.00 #DIV/0! 18
Illustrative Example
It has been assumed that Company will plough back all pro
Market Capitalisation has been derived from previ
Valuation of
PROFITS in your Company
Turnover in
YEARS Crore (EPS in Rs.) on basis of Net
Crores
worth
Rs. In Crores
2024 80 8.00 #DIV/0! 36
2025 100 10.00 #DIV/0! 46
2026 125 12.00 #DIV/0! 58
2027 156 16.00 #DIV/0! 74
2028 200 20.00 #DIV/0! 94
ve Example
as been assumed for Initial Years
PE multiple ranging from 8-22
Personal Net
Market Capitalisation of worth of the
Per Share Fair the Company (Listed Promoter (73%
Valuation on PE Shares = 4 109 589 Equity Holding =
multiple Shares) 3,000,000 Equity
Rs. In Crores Shares)
Rs. In Crores
57 #DIV/0! #DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
ve Example
ill plough back all profits into business
en derived from previous slide
Market Capitalisation of
the Company (Listed
Shares = 4 109 589
Equity Shares)
Rs. In Crores
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
10000000
10000000
10000000
10000000
10000000
PAT Mar Net
Name Sales Rs.Cr. 12M Rs.Cr. Cap Rs.Cr. worth Rs.Cr. CMP Rs. B.V. Rs. P/E
Debt /
Eq ROCE%
