0% found this document useful (0 votes)

20 views316 pages

Workbook

This document provides instructions for using a CMA template, including color coding for inputs and specific data entry guidelines for financial projections. It outlines the necessary information required for the Profit & Loss Account, including company details, sales projections, costs, and other financial metrics. Users are advised to enter data in designated blue cells and update relevant columns based on the latest audited financial data.

Uploaded by

rahuldanv55

We take content rights seriously. If you suspect this is your content, claim it here.

Available Formats

Download as XLSX, PDF, TXT or read online on Scribd

0% found this document useful (0 votes)

20 views316 pages

Workbook

Uploaded by

rahuldanv55

We take content rights seriously. If you suspect this is your content, claim it here.

Available Formats

Download as XLSX, PDF, TXT or read online on Scribd

Instructions

Dear User Please note following before you use this CMA template.

Following is the colour coding for input

1
2
3

Other Instructions
1
2
3
4
5

6
7
8
Ver: 15.01.2019
e this CMA template.

User input
Auto generated cell
user input for estimates accepted in last renewal

All the inputs will be in OS & BS sheets. Latest Audited data to be updated in Column E for BS and Column D for OS Sheet.
In OS sheet, first year of DSCR to be filled in cell C9. In case of fresh unit, first full year of commercial operation to be the first year for D
In OS sheet in cell I-128 please mention the value of accumulated profit of last year to arrive at the posotion of accumulated profit in the fi
For CRISIL rating, Company Financial Input (CFI) sheet will be automatically generated. Project financial Sheet (PFI inputs will have to be fed
Ensure to feed values in OS sheet between row number 3 to 24 and 127 to 142 carefully.
in the cell no A 7 user needs to input the number of years for TL projections. This will open up those number of columns on projection sid
click of "add column" and "delete Column" button.
for NBFC proposals, please ensure to select Yes in the sheet BS at cell E2
For DSCR Calculation: Please update the cell reference in "F184" of the BS Sheet and the "Number of projection years" in B7 o
PROFIT & LOSS ACCOUNT INPUT

Please Enter Data In Blue Colored Cell. Projections made at the time of last renewal to be entered in column E
Name of the Company OM HOTEL AND SWEET HOME
Constitution PROPR
Industry (as per HASCROM classification) Retail Trade
Bank rating to be done on
Balance sheet as at (Latest Audited/Un- Monday, March 31, 2025 3/31/2025
Audited Year to be updated)
Projections for how many years 2
NBFC PROPOSAL No
First year for DSCR 3/31/2026 3/31/2026
Is the borrower a Holding Company serving as
a Investment vehicle for subsidiaries of the No
group
Company Code (Bank's RATING CODE)
Currency INR
Currency - Unit Lakhs
Auditors Name / Location / Regn. No.
2023 2024
Yr.End.(DD-MMM-YY) 31/Mar/23 31/Mar/24
No. Of Months 12 12
Exchange Rate 1 1
Audited Audited
Lakhs Lakhs
To be printed on MCB sheet Yes Yes
To be printed in Cash Flow Yes Yes
OPERATING REVENUE
1) Domestic Sales
2) Export Sales
3) GROSS SALES (1 + 2) 0.00 0.00
4) Less : Goods & Services Tax
5) NET SALES (3 - 4) 0.00 0.00
% wise rise/fall in net sales as compared to
previous year 0.00% 0.00%
6) Other Operating Income (to be specified by 0.00 0.00
i) other operating income / export incentives)
ii) Sale of Traded Goods
iii) Others 0.00 0.00
a) Sale of Scrap & Jobwork
A) TOTAL OPERATING REVENUE (5 + 6) 0.00 0.00
COST OF SALES
7) Raw materials consumed 0.00 0.00
i) Imported
ii) Indigenous
8) Other Spares consumed 0.00 0.00
i) Imported
ii) Indigenous
9) Power and fuel
10) Labour and wages
11) Other Manufacturing exps
PROFIT & LOSS ACCOUNT INPUT

Please Enter Data In Blue Colored Cell. Projections made at the time of last renewal to be entered in column E
Name of the Company OM HOTEL AND SWEET HOME
Constitution PROPR
Industry (as per HASCROM classification) Retail Trade
Bank rating to be done on
Balance sheet as at (Latest Audited/Un- Monday, March 31, 2025 3/31/2025
Audited Year to be updated)
Projections for how many years 2
NBFC PROPOSAL No
First year for DSCR 3/31/2026 3/31/2026
Is the borrower a Holding Company serving as
a Investment vehicle for subsidiaries of the No
group
Company Code (Bank's RATING CODE)
Currency INR
Currency - Unit Lakhs
12) Depreciation 0.00 0.00
13) Sub total (sum of 7 TO 11) 0.00 0.00
Add: Op. Stock of WIP
Less: Cl. Stock of WIP
14) Total Cost of Production 0.00 0.00
Add Oping. Stock of Fin.Gds
Less: Cl. Stock of Fin.Gds
15) Total Cost of Goods Sold 0.00 0.00
16) Selling, Distribution & Admin.Exp
B) TOTAL COST OF SALES (15 + 16) 0.00 0.00
C) OPRTNG. PROFIT BEFORE INT.(A-B) 0.00 0.00
INTEREST COST
17) Interest payment to Banks 0.00 0.00
Interest - WC
Interest - Term Loans
18) Interest payment to FIs 0.00 0.00
Interest - WC
Interest - Term Loans
19) Interest payment to USL/Others 0.00 0.00
USL
Other interest
D) TOTAL INTEREST (17+18+19) 0.00 0.00
E) FINANCE COST (OTHER THAN INTEREST)
F) OPRTNG. PROFIT AFTER INT.(C-D-E)-Deprecia 0.00 0.00
Depreciation
20) Non cash/Non Operating Income 0.00 0.00
Cash Income 0.00 0.00
i) Prft. on sale of asts/ invest.
ii) Interests and Dividend
iii) Tax refund
iv) Extraordinary Income
v) Income from subsidiaries / related parties
vi) Other Cash items
Non Cash Income 0.00 0.00
PROFIT & LOSS ACCOUNT INPUT

Non Cash Exps 0.00 0.00

i) Loss on sale of assets
ii) Preliminary exps w/off (Non Cash)
iii) Provision for doubtful debts
iv) Forex loss(Non Cash)
v) Amortization (Non Cash)

G) NET NON OPRTNG. INC. / EXP. (20-21) 0.00 0.00

H) PROFIT BEFORE TAX (PBT) (F+G) 0.00 0.00

PROVISION FOR TAX
i) Current
ii) Deferred
I) TAX PROVISION 0.00 0.00
Tax % 0.00% 0.00%
J) NET PROFIT (Before adjustment of
Extraordinary items post tax) (H-I) 0.00 0.00

K) EXTRAORDINARY ITEM (POST TAX) : 0.00 0.00

Extraordinary Income
Extraordinary Expenses

L) NET PROFIT (After adjustment of Extraordinar 0.00 0.00

% wise rise/fall in net Profit as compared to
previous year 0.00% 0.00%
M) APPROPRIATION OF PROFIT 0.00 0.00
PROFIT & LOSS ACCOUNT INPUT

O) CASH ACCRUALS (After adjusting all non

cash items) 0.00 0.00

EARNING BEFORE INTEREST, DEPRECIATION,

TAXES & AMORTIZATION (EBIDTA) 0.00 0.00

EARNING BEFORE INTEREST & TAX (EBIT) 0.00 0.00

ADJUSTED PAT (Exc. All extraordinary items) 0.00 0.00

Annual Purchase Cost of RM & Spares 0.00 0.00

Accepted Sales as per Bank 0.00 0.00
Additional information for MCB, Ratio and
DSCR Sheets

Data for Previous Year 2022 .=======>

Total of appropriation from Accumulated P&L
Account (including dividend and 0.00 0.00
Withdrawal/cash appropriation)

Additional information for WC sheet

Method (1 or 2) 1 or 2 .=======>

Additional information for BEP sheet

BREAK EVEN POINT CALCULATION Variable
Direct Labour & Wages 75%
S&A 25%
Price Per Unit 10.00
PROFIT & LOSS ACCOUNT INPUT

tions made at
Please
the time
Enter
ofData
last renewal
In Blue Colored
to be entered
Cell. Projections
in column made
E at the time of last renewal to be entered in column E
OM HOTELName
AND SWEET
of the Company
HOME
Constitution
Industry (as per HASCROM classification)
Bank rating to be done on
Balance sheet as at (Latest Audited/Un- Audited
Audited Year to be updated)
Projections for how many years
NBFC PROPOSAL
First year for DSCR
Is the borrower a Holding Company serving as
a Investment vehicle for subsidiaries of the
group
Company Code (Bank's RATING CODE) Latest Audited/Un-
Currency Audited Year details to
be updated in this
Currency - Unit Column
Auditors Name / Location / Regn. No.
2025 2026
Yr.End.(DD-MMM-YY) 31/Mar/25 31/Mar/26
No. Of Months 12 12
Exchange Rate 1 1
Audited Estimated
Lakhs Lakhs
To be printed on MCB sheet Yes Yes
To be printed in Cash Flow Yes Yes
OPERATING REVENUE
1) Domestic Sales 2260250.00 2712300.00
2) Export Sales
3) GROSS SALES (1 + 2) 2260250.00 2712300.00
4) Less : Goods & Services Tax
5) NET SALES (3 - 4) 2260250.00 2712300.00
% wise rise/fall in net sales as compared to
previous year 0.00% 20.00%
6) Other Operating Income (to be specified by 0.00 0.00
i) other operating income / export incentives)
ii) Sale of Traded Goods
iii) Others 0.00 0.00
a) Sale of Scrap & Jobwork
A) TOTAL OPERATING REVENUE (5 + 6) 2260250.00 2712300.00
COST OF SALES
7) Raw materials consumed 1442123.00 1591464.00
i) Imported
ii) Indigenous 1442123.00 1591464.00
8) Other Spares consumed 0.00 0.00
i) Imported
ii) Indigenous
9) Power and fuel 34155.00 36150.00
10) Labour and wages 210000.00 240000.00
11) Other Manufacturing exps 43680.00 47120.00
PROFIT & LOSS ACCOUNT INPUT PROFIT & LOSS ACCOUNT INPUT

tions made at
Please
the time
Enter
ofData
last renewal
In Blue Colored
to be entered
Cell. Projections
in column made
E at the time of last renewal to be entered in column E
OM HOTELName
AND SWEET
of the Company
HOME
Constitution
Industry (as per HASCROM classification)
Bank rating to be done on
Balance sheet as at (Latest Audited/Un- Audited
Audited Year to be updated)
Projections for how many years
NBFC PROPOSAL
First year for DSCR
Is the borrower a Holding Company serving as
a Investment vehicle for subsidiaries of the
group
Company Code (Bank's RATING CODE) Latest Audited/Un-
Currency Audited Year details to
be updated in this
Currency - Unit Column
12) Depreciation 0.00 0.00
13) Sub total (sum of 7 TO 11) 1729958.00 1914734.00
Add: Op. Stock of WIP
Less: Cl. Stock of WIP 560250.00 680250.00
14) Total Cost of Production 1169708.00 1234484.00
Add Oping. Stock of Fin.Gds 525140.00 560250.00
Less: Cl. Stock of Fin.Gds
15) Total Cost of Goods Sold 1694848.00 1794734.00
16) Selling, Distribution & Admin.Exp
B) TOTAL COST OF SALES (15 + 16) 1694848.00 1794734.00
C) OPRTNG. PROFIT BEFORE INT.(A-B) 565402.00 917566.00
INTEREST COST
17) Interest payment to Banks 36397.00 55000.00
Interest - WC 36397.00 55000.00
Interest - Term Loans
18) Interest payment to FIs 0.00 0.00
Interest - WC
Interest - Term Loans
19) Interest payment to USL/Others 0.00 0.00
USL
Other interest
D) TOTAL INTEREST (17+18+19) 36397.00 55000.00
E) FINANCE COST (OTHER THAN INTEREST)
F) OPRTNG. PROFIT AFTER INT.(C-D-E)-Deprecia 529005.00 862566.00
Depreciation
20) Non cash/Non Operating Income 0.00 0.00
Cash Income 0.00 0.00
i) Prft. on sale of asts/ invest.
ii) Interests and Dividend
iii) Tax refund
iv) Extraordinary Income
v) Income from subsidiaries / related parties
vi) Other Cash items
Non Cash Income 0.00 0.00
PROFIT & LOSS ACCOUNT INPUT PROFIT & LOSS ACCOUNT INPUT

Non Cash Exps 0.00 0.00

i) Loss on sale of assets
ii) Preliminary exps w/off (Non Cash)
iii) Provision for doubtful debts
iv) Forex loss(Non Cash)
v) Amortization (Non Cash)

G) NET NON OPRTNG. INC. / EXP. (20-21) 0.00 0.00

H) PROFIT BEFORE TAX (PBT) (F+G) 529005.00 862566.00

PROVISION FOR TAX
i) Current
ii) Deferred
I) TAX PROVISION 0.00 0.00
Tax % 0.00% 0.00%
J) NET PROFIT (Before adjustment of
Extraordinary items post tax) (H-I) 529005.00 862566.00

K) EXTRAORDINARY ITEM (POST TAX) : 0.00 0.00

Extraordinary Income
Extraordinary Expenses

L) NET PROFIT (After adjustment of Extraordinar 529005.00 862566.00

% wise rise/fall in net Profit as compared to
previous year 0.00% 63.05%
M) APPROPRIATION OF PROFIT 0.00 0.00
PROFIT & LOSS ACCOUNT INPUT PROFIT & LOSS ACCOUNT INPUT

O) CASH ACCRUALS (After adjusting all non

cash items) 529005.00 862566.00

EARNING BEFORE INTEREST, DEPRECIATION,

TAXES & AMORTIZATION (EBIDTA) 565402.00 917566.00

EARNING BEFORE INTEREST & TAX (EBIT) 565402.00 917566.00

ADJUSTED PAT (Exc. All extraordinary items) 529005.00 862566.00

Annual Purchase Cost of RM & Spares 1442123.00 1591464.00

Accepted Sales as per Bank 2260250.00 2712300.00
Additional information for MCB, Ratio and
DSCR Sheets
Net Sales Closing RM

Data for Previous Year

Total of appropriation from Accumulated P&L
Account (including dividend and 0.00 0.00
Withdrawal/cash appropriation)

Additional information for WC sheet

Method (1 or 2) 1

Additional information for BEP sheet

BREAK EVEN POINT CALCULATION Fixed
Direct Labour & Wages 25%
S&A 75%
Price Per Unit
PROFIT & LOSS ACCOUNT INPUT PROFIT & LOSS ACCOUNT INPUT

Please Enter Data In Blue Colored Cell. Projections made at the time of last renewal to be entered in column E
Name of the Company
Constitution
Industry (as per HASCROM classification)
Bank rating to be done on
Balance sheet as at (Latest Audited/Un-
Audited
Audited Year to be updated)
Projections for how many years
NBFC PROPOSAL
First year for DSCR
Is the borrower a Holding Company serving as
a Investment vehicle for subsidiaries of the
group
Company Code (Bank's RATING CODE)
Currency
Currency - Unit
Auditors Name / Location / Regn. No. 1 2
2027 2028
Yr.End.(DD-MMM-YY) 31/Mar/27 31/Mar/28
No. Of Months 12 12
Exchange Rate 1 1
Projected Projected
Lakhs Lakhs
To be printed on MCB sheet Yes Yes
To be printed in Cash Flow Yes Yes
OPERATING REVENUE
1) Domestic Sales 3390375.00
2) Export Sales
3) GROSS SALES (1 + 2) 3390375.00 0.00
4) Less : Goods & Services Tax
5) NET SALES (3 - 4) 3390375.00 0.00
% wise rise/fall in net sales as compared to
previous year 25.00% -100.00%
6) Other Operating Income (to be specified by 0.00 0.00
i) other operating income / export incentives)
ii) Sale of Traded Goods
iii) Others 0.00 0.00
a) Sale of Scrap & Jobwork
A) TOTAL OPERATING REVENUE (5 + 6) 3390375.00 0.00
COST OF SALES
7) Raw materials consumed 1819515.00 0.00
i) Imported
ii) Indigenous 1819515.00
8) Other Spares consumed 0.00 0.00
i) Imported
ii) Indigenous
9) Power and fuel 38500.00
10) Labour and wages 270000.00
11) Other Manufacturing exps 50100.00
& LOSS ACCOUNT INPUT PROFIT & LOSS ACCOUNT INPUT

Please Enter Data In Blue Colored Cell. Projections made at the time of last renewal to be entered in column E
Name of the Company
Constitution
Industry (as per HASCROM classification)
Bank rating to be done on
Balance sheet as at (Latest Audited/Un-
Audited
Audited Year to be updated)
Projections for how many years
NBFC PROPOSAL
First year for DSCR
Is the borrower a Holding Company serving as
a Investment vehicle for subsidiaries of the
group
Company Code (Bank's RATING CODE)
Currency
Currency - Unit
12) Depreciation 0.00 0.00
13) Sub total (sum of 7 TO 11) 2178115.00 0.00
Add: Op. Stock of WIP
Less: Cl. Stock of WIP 840120.00
14) Total Cost of Production 1337995.00 0.00
Add Oping. Stock of Fin.Gds 680250.00
Less: Cl. Stock of Fin.Gds
15) Total Cost of Goods Sold 2018245.00 0.00
16) Selling, Distribution & Admin.Exp
B) TOTAL COST OF SALES (15 + 16) 2018245.00 0.00
C) OPRTNG. PROFIT BEFORE INT.(A-B) 1372130.00 0.00
INTEREST COST
17) Interest payment to Banks 55000.00 0.00
Interest - WC 55000.00
Interest - Term Loans
18) Interest payment to FIs 0.00 0.00
Interest - WC
Interest - Term Loans
19) Interest payment to USL/Others 0.00 0.00
USL
Other interest
D) TOTAL INTEREST (17+18+19) 55000.00 0.00
E) FINANCE COST (OTHER THAN INTEREST)
F) OPRTNG. PROFIT AFTER INT.(C-D-E)-Deprecia 1317130.00 0.00
Depreciation
20) Non cash/Non Operating Income 0.00 0.00
Cash Income 0.00 0.00
i) Prft. on sale of asts/ invest.
ii) Interests and Dividend
iii) Tax refund
iv) Extraordinary Income
v) Income from subsidiaries / related parties
vi) Other Cash items
Non Cash Income 0.00 0.00
& LOSS ACCOUNT INPUT PROFIT & LOSS ACCOUNT INPUT

Non Cash Exps 0.00 0.00

i) Loss on sale of assets
ii) Preliminary exps w/off (Non Cash)
iii) Provision for doubtful debts
iv) Forex loss(Non Cash)
v) Amortization (Non Cash)

G) NET NON OPRTNG. INC. / EXP. (20-21) 0.00 0.00

H) PROFIT BEFORE TAX (PBT) (F+G) 1317130.00 0.00

PROVISION FOR TAX
i) Current
ii) Deferred
I) TAX PROVISION 0.00 0.00
Tax % 0.00% 0.00%
J) NET PROFIT (Before adjustment of
Extraordinary items post tax) (H-I) 1317130.00 0.00

K) EXTRAORDINARY ITEM (POST TAX) : 0.00 0.00

Extraordinary Income
Extraordinary Expenses

L) NET PROFIT (After adjustment of Extraordinar 1317130.00 0.00

% wise rise/fall in net Profit as compared to
previous year 52.70% -100.00%
M) APPROPRIATION OF PROFIT 0.00 0.00
& LOSS ACCOUNT INPUT PROFIT & LOSS ACCOUNT INPUT

O) CASH ACCRUALS (After adjusting all non

cash items) 1317130.00 0.00

EARNING BEFORE INTEREST, DEPRECIATION,

TAXES & AMORTIZATION (EBIDTA) 1372130.00 0.00

EARNING BEFORE INTEREST & TAX (EBIT) 1372130.00 0.00

ADJUSTED PAT (Exc. All extraordinary items) 1317130.00 0.00

Annual Purchase Cost of RM & Spares 1819515.00 0.00

Accepted Sales as per Bank 3390375.00 0.00
Additional information for MCB, Ratio and
DSCR Sheets
Closing Spares Closing TNW

Data for Previous Year

Total of appropriation from Accumulated P&L
Account (including dividend and 0.00 0.00
Withdrawal/cash appropriation)

Additional information for WC sheet

Method (1 or 2)

Additional information for BEP sheet

BREAK EVEN POINT CALCULATION
Direct Labour & Wages
S&A
Price Per Unit
& LOSS ACCOUNT INPUT PROFIT & LOSS ACCOUNT INPUT

Please Enter Data In Blue Colored Cell. Projections made at the time of last renewal to be entered in column E
Name of the Company Deviation on Financial Ratios to be derived based on
Constitution column :
Industry (as per HASCROM classification)
Bank rating to be done on
Balance sheet as at (Latest Audited/Un-
Audited Year to be updated)
Projections for how many years
NBFC PROPOSAL
First year for DSCR
Is the borrower a Holding Company serving as
a Investment vehicle for subsidiaries of the
group
Company Code (Bank's RATING CODE)
Currency
Currency - Unit
Auditors Name / Location / Regn. No. 3 4
2029 2030
Yr.End.(DD-MMM-YY) 31/Mar/29 31/Mar/30
No. Of Months 12 12
Exchange Rate 1 1
Projected Projected
Lakhs Lakhs
To be printed on MCB sheet Yes Yes
To be printed in Cash Flow Yes Yes
OPERATING REVENUE
1) Domestic Sales
2) Export Sales
3) GROSS SALES (1 + 2) 0.00 0.00
4) Less : Goods & Services Tax
5) NET SALES (3 - 4) 0.00 0.00
% wise rise/fall in net sales as compared to
previous year 0.00% 0.00%
6) Other Operating Income (to be specified by 0.00 0.00
i) other operating income / export incentives)
ii) Sale of Traded Goods
iii) Others 0.00 0.00
a) Sale of Scrap & Jobwork
A) TOTAL OPERATING REVENUE (5 + 6) 0.00 0.00
COST OF SALES
7) Raw materials consumed 0.00 0.00
i) Imported
ii) Indigenous
8) Other Spares consumed 0.00 0.00
i) Imported
ii) Indigenous
9) Power and fuel
10) Labour and wages
11) Other Manufacturing exps
PROFIT & LOSS ACCOUNT INPUT

Please Enter Data In Blue Colored Cell. Projections made at the time of last renewal to be entered in column E
Name of the Company Deviation on Financial Ratios to be derived based on
Constitution column :
Industry (as per HASCROM classification)
Bank rating to be done on
Balance sheet as at (Latest Audited/Un-
Audited Year to be updated)
Projections for how many years
NBFC PROPOSAL
First year for DSCR
Is the borrower a Holding Company serving as
a Investment vehicle for subsidiaries of the
group
Company Code (Bank's RATING CODE)
Currency
Currency - Unit
12) Depreciation 0.00 0.00
13) Sub total (sum of 7 TO 11) 0.00 0.00
Add: Op. Stock of WIP
Less: Cl. Stock of WIP
14) Total Cost of Production 0.00 0.00
Add Oping. Stock of Fin.Gds
Less: Cl. Stock of Fin.Gds
15) Total Cost of Goods Sold 0.00 0.00
16) Selling, Distribution & Admin.Exp
B) TOTAL COST OF SALES (15 + 16) 0.00 0.00
C) OPRTNG. PROFIT BEFORE INT.(A-B) 0.00 0.00
INTEREST COST
17) Interest payment to Banks 0.00 0.00
Interest - WC
Interest - Term Loans
18) Interest payment to FIs 0.00 0.00
Interest - WC
Interest - Term Loans
19) Interest payment to USL/Others 0.00 0.00
USL
Other interest
D) TOTAL INTEREST (17+18+19) 0.00 0.00
E) FINANCE COST (OTHER THAN INTEREST)
F) OPRTNG. PROFIT AFTER INT.(C-D-E)-Deprecia 0.00 0.00
Depreciation
20) Non cash/Non Operating Income 0.00 0.00
Cash Income 0.00 0.00
i) Prft. on sale of asts/ invest.
ii) Interests and Dividend
iii) Tax refund
iv) Extraordinary Income
v) Income from subsidiaries / related parties
vi) Other Cash items
Non Cash Income 0.00 0.00
PROFIT & LOSS ACCOUNT INPUT

Non Cash Exps 0.00 0.00

i) Loss on sale of assets
ii) Preliminary exps w/off (Non Cash)
iii) Provision for doubtful debts
iv) Forex loss(Non Cash)
v) Amortization (Non Cash)

G) NET NON OPRTNG. INC. / EXP. (20-21) 0.00 0.00

H) PROFIT BEFORE TAX (PBT) (F+G) 0.00 0.00

PROVISION FOR TAX
i) Current
ii) Deferred
I) TAX PROVISION 0.00 0.00
Tax % 0.00% 0.00%
J) NET PROFIT (Before adjustment of
Extraordinary items post tax) (H-I) 0.00 0.00

K) EXTRAORDINARY ITEM (POST TAX) : 0.00 0.00

Extraordinary Income
Extraordinary Expenses

L) NET PROFIT (After adjustment of Extraordinar 0.00 0.00

% wise rise/fall in net Profit as compared to
previous year 0.00% 0.00%
M) APPROPRIATION OF PROFIT 0.00 0.00
PROFIT & LOSS ACCOUNT INPUT

O) CASH ACCRUALS (After adjusting all non

cash items) 0.00 0.00

EARNING BEFORE INTEREST, DEPRECIATION,

TAXES & AMORTIZATION (EBIDTA) 0.00 0.00

EARNING BEFORE INTEREST & TAX (EBIT) 0.00 0.00

ADJUSTED PAT (Exc. All extraordinary items) 0.00 0.00

Annual Purchase Cost of RM & Spares 0.00 0.00

Accepted Sales as per Bank 0.00 0.00
Additional information for MCB, Ratio and
DSCR Sheets
TL Instl. pyble in 12 month Accumulated P&L Balance

Data for Previous Year

Total of appropriation from Accumulated P&L
Account (including dividend and
Withdrawal/cash appropriation)

Additional information for WC sheet

Method (1 or 2)

Additional information for BEP sheet

BREAK EVEN POINT CALCULATION
Direct Labour & Wages
S&A
Price Per Unit
PROFIT & LOSS ACCOUNT INPUT

Please Enter Data In Blue Colored Cell. Projections made at the time of last renewal to be entered in column E
Name of the Company
D
Constitution
Industry (as per HASCROM classification)
Bank rating to be done on
Balance sheet as at (Latest Audited/Un-
Audited Year to be updated)
Projections for how many years 31/03/2021
NBFC PROPOSAL 31-Mar-21
First year for DSCR
Is the borrower a Holding Company serving as
a Investment vehicle for subsidiaries of the
group
Company Code (Bank's RATING CODE)
Currency
Currency - Unit
Auditors Name / Location / Regn. No. 5 6
2031 2032
Yr.End.(DD-MMM-YY) 31/Mar/31 31/Mar/32
No. Of Months 12 12
Exchange Rate 1 1
Projected Projected
Lakhs Lakhs
To be printed on MCB sheet Yes Yes
To be printed in Cash Flow Yes Yes
OPERATING REVENUE
1) Domestic Sales
2) Export Sales
3) GROSS SALES (1 + 2) 0.00 0.00
4) Less : Goods & Services Tax
5) NET SALES (3 - 4) 0.00 0.00
% wise rise/fall in net sales as compared to
previous year 0.00% 0.00%
6) Other Operating Income (to be specified by 0.00 0.00
i) other operating income / export incentives)
ii) Sale of Traded Goods
iii) Others 0.00 0.00
a) Sale of Scrap & Jobwork
A) TOTAL OPERATING REVENUE (5 + 6) 0.00 0.00
COST OF SALES
7) Raw materials consumed 0.00 0.00
i) Imported
ii) Indigenous
8) Other Spares consumed 0.00 0.00
i) Imported
ii) Indigenous
9) Power and fuel
10) Labour and wages
11) Other Manufacturing exps
PROFIT & LOSS ACCOUNT INPUT

Please Enter Data In Blue Colored Cell. Projections made at the time of last renewal to be entered in column E
Name of the Company
D
Constitution
Industry (as per HASCROM classification)
Bank rating to be done on
Balance sheet as at (Latest Audited/Un-
Audited Year to be updated)
Projections for how many years 31/03/2021
NBFC PROPOSAL 31-Mar-21
First year for DSCR
Is the borrower a Holding Company serving as
a Investment vehicle for subsidiaries of the
group
Company Code (Bank's RATING CODE)
Currency
Currency - Unit
12) Depreciation 0.00 0.00
13) Sub total (sum of 7 TO 11) 0.00 0.00
Add: Op. Stock of WIP
Less: Cl. Stock of WIP
14) Total Cost of Production 0.00 0.00
Add Oping. Stock of Fin.Gds
Less: Cl. Stock of Fin.Gds
15) Total Cost of Goods Sold 0.00 0.00
16) Selling, Distribution & Admin.Exp
B) TOTAL COST OF SALES (15 + 16) 0.00 0.00
C) OPRTNG. PROFIT BEFORE INT.(A-B) 0.00 0.00
INTEREST COST
17) Interest payment to Banks 0.00 0.00
Interest - WC
Interest - Term Loans
18) Interest payment to FIs 0.00 0.00
Interest - WC
Interest - Term Loans
19) Interest payment to USL/Others 0.00 0.00
USL
Other interest
D) TOTAL INTEREST (17+18+19) 0.00 0.00
E) FINANCE COST (OTHER THAN INTEREST)
F) OPRTNG. PROFIT AFTER INT.(C-D-E)-Deprecia 0.00 0.00
Depreciation
20) Non cash/Non Operating Income 0.00 0.00
Cash Income 0.00 0.00
i) Prft. on sale of asts/ invest.
ii) Interests and Dividend
iii) Tax refund
iv) Extraordinary Income
v) Income from subsidiaries / related parties
vi) Other Cash items
Non Cash Income 0.00 0.00
PROFIT & LOSS ACCOUNT INPUT

Non Cash Exps 0.00 0.00

i) Loss on sale of assets
ii) Preliminary exps w/off (Non Cash)
iii) Provision for doubtful debts
iv) Forex loss(Non Cash)
v) Amortization (Non Cash)

G) NET NON OPRTNG. INC. / EXP. (20-21) 0.00 0.00

H) PROFIT BEFORE TAX (PBT) (F+G) 0.00 0.00

PROVISION FOR TAX
i) Current
ii) Deferred
I) TAX PROVISION 0.00 0.00
Tax % 0.00% 0.00%
J) NET PROFIT (Before adjustment of
Extraordinary items post tax) (H-I) 0.00 0.00

K) EXTRAORDINARY ITEM (POST TAX) : 0.00 0.00

Extraordinary Income
Extraordinary Expenses

L) NET PROFIT (After adjustment of Extraordinar 0.00 0.00

% wise rise/fall in net Profit as compared to
previous year 0.00% 0.00%
M) APPROPRIATION OF PROFIT 0.00 0.00
PROFIT & LOSS ACCOUNT INPUT

O) CASH ACCRUALS (After adjusting all non

cash items) 0.00 0.00

EARNING BEFORE INTEREST, DEPRECIATION,

TAXES & AMORTIZATION (EBIDTA) 0.00 0.00

EARNING BEFORE INTEREST & TAX (EBIT) 0.00 0.00

ADJUSTED PAT (Exc. All extraordinary items) 0.00 0.00

Annual Purchase Cost of RM & Spares 0.00 0.00

Accepted Sales as per Bank 0.00 0.00
Additional information for MCB, Ratio and
DSCR Sheets
Net Profit

Data for Previous Year

Total of appropriation from Accumulated P&L
Account (including dividend and
Withdrawal/cash appropriation)

Additional information for WC sheet

Method (1 or 2)

Additional information for BEP sheet

BREAK EVEN POINT CALCULATION
Direct Labour & Wages
S&A
Price Per Unit
PROFIT & LOSS ACCOUNT INPUT

Please Enter Data In Blue Colored Cell. Projections made at the time of last renewal to be entered in column E
Name of the Company
Constitution
Industry (as per HASCROM classification)
Bank rating to be done on
Balance sheet as at (Latest Audited/Un-
Audited Year to be updated)
Projections for how many years
NBFC PROPOSAL
First year for DSCR
Is the borrower a Holding Company serving as
a Investment vehicle for subsidiaries of the
group
Company Code (Bank's RATING CODE)
Currency
Currency - Unit
Auditors Name / Location / Regn. No. 7 8
2033 2034
Yr.End.(DD-MMM-YY) 31/Mar/33 31/Mar/34
No. Of Months 12 12
Exchange Rate 1 1
Projected Projected
Lakhs Lakhs
To be printed on MCB sheet Yes Yes
To be printed in Cash Flow Yes Yes
OPERATING REVENUE
1) Domestic Sales
2) Export Sales
3) GROSS SALES (1 + 2) 0.00 0.00
4) Less : Goods & Services Tax
5) NET SALES (3 - 4) 0.00 0.00
% wise rise/fall in net sales as compared to
previous year 0.00% 0.00%
6) Other Operating Income (to be specified by 0.00 0.00
i) other operating income / export incentives)
ii) Sale of Traded Goods
iii) Others 0.00 0.00
a) Sale of Scrap & Jobwork
A) TOTAL OPERATING REVENUE (5 + 6) 0.00 0.00
COST OF SALES
7) Raw materials consumed 0.00 0.00
i) Imported
ii) Indigenous
8) Other Spares consumed 0.00 0.00
i) Imported
ii) Indigenous
9) Power and fuel
10) Labour and wages
11) Other Manufacturing exps
PROFIT & LOSS ACCOUNT INPUT

Please Enter Data In Blue Colored Cell. Projections made at the time of last renewal to be entered in column E
Name of the Company
Constitution
Industry (as per HASCROM classification)
Bank rating to be done on
Balance sheet as at (Latest Audited/Un-
Audited Year to be updated)
Projections for how many years
NBFC PROPOSAL
First year for DSCR
Is the borrower a Holding Company serving as
a Investment vehicle for subsidiaries of the
group
Company Code (Bank's RATING CODE)
Currency
Currency - Unit
12) Depreciation 0.00 0.00
13) Sub total (sum of 7 TO 11) 0.00 0.00
Add: Op. Stock of WIP
Less: Cl. Stock of WIP
14) Total Cost of Production 0.00 0.00
Add Oping. Stock of Fin.Gds
Less: Cl. Stock of Fin.Gds
15) Total Cost of Goods Sold 0.00 0.00
16) Selling, Distribution & Admin.Exp
B) TOTAL COST OF SALES (15 + 16) 0.00 0.00
C) OPRTNG. PROFIT BEFORE INT.(A-B) 0.00 0.00
INTEREST COST
17) Interest payment to Banks 0.00 0.00
Interest - WC
Interest - Term Loans
18) Interest payment to FIs 0.00 0.00
Interest - WC
Interest - Term Loans
19) Interest payment to USL/Others 0.00 0.00
USL
Other interest
D) TOTAL INTEREST (17+18+19) 0.00 0.00
E) FINANCE COST (OTHER THAN INTEREST)
F) OPRTNG. PROFIT AFTER INT.(C-D-E)-Deprecia 0.00 0.00
Depreciation
20) Non cash/Non Operating Income 0.00 0.00
Cash Income 0.00 0.00
i) Prft. on sale of asts/ invest.
ii) Interests and Dividend
iii) Tax refund
iv) Extraordinary Income
v) Income from subsidiaries / related parties
vi) Other Cash items
Non Cash Income 0.00 0.00
PROFIT & LOSS ACCOUNT INPUT

Non Cash Exps 0.00 0.00

i) Loss on sale of assets
ii) Preliminary exps w/off (Non Cash)
iii) Provision for doubtful debts
iv) Forex loss(Non Cash)
v) Amortization (Non Cash)

G) NET NON OPRTNG. INC. / EXP. (20-21) 0.00 0.00

H) PROFIT BEFORE TAX (PBT) (F+G) 0.00 0.00

PROVISION FOR TAX
i) Current
ii) Deferred
I) TAX PROVISION 0.00 0.00
Tax % 0.00% 0.00%
J) NET PROFIT (Before adjustment of
Extraordinary items post tax) (H-I) 0.00 0.00

K) EXTRAORDINARY ITEM (POST TAX) : 0.00 0.00

Extraordinary Income
Extraordinary Expenses

L) NET PROFIT (After adjustment of Extraordinar 0.00 0.00

% wise rise/fall in net Profit as compared to
previous year 0.00% 0.00%
M) APPROPRIATION OF PROFIT 0.00 0.00
PROFIT & LOSS ACCOUNT INPUT

O) CASH ACCRUALS (After adjusting all non

cash items) 0.00 0.00

EARNING BEFORE INTEREST, DEPRECIATION,

TAXES & AMORTIZATION (EBIDTA) 0.00 0.00

EARNING BEFORE INTEREST & TAX (EBIT) 0.00 0.00

ADJUSTED PAT (Exc. All extraordinary items) 0.00 0.00

Annual Purchase Cost of RM & Spares 0.00 0.00

Accepted Sales as per Bank 0.00 0.00
Additional information for MCB, Ratio and
DSCR Sheets

Data for Previous Year

Total of appropriation from Accumulated P&L
Account (including dividend and
Withdrawal/cash appropriation)

Additional information for WC sheet

Method (1 or 2)

Additional information for BEP sheet

BREAK EVEN POINT CALCULATION
Direct Labour & Wages
S&A
Price Per Unit
PROFIT & LOSS ACCOUNT INPUT

Please Enter Data In Blue Colored Cell. Projections made at the time of last renewal to be entered in column E
Name of the Company
Constitution
Industry (as per HASCROM classification)
Bank rating to be done on
Balance sheet as at (Latest Audited/Un-
Audited Year to be updated)
Projections for how many years
NBFC PROPOSAL
First year for DSCR
Is the borrower a Holding Company serving as
a Investment vehicle for subsidiaries of the
group
Company Code (Bank's RATING CODE)
Currency
Currency - Unit
Auditors Name / Location / Regn. No. 9 10
2035 2036
Yr.End.(DD-MMM-YY) 31/Mar/35 31/Mar/36
No. Of Months 12 12
Exchange Rate 1 1
Projected Projected
Lakhs Lakhs
To be printed on MCB sheet Yes Yes
To be printed in Cash Flow Yes Yes
OPERATING REVENUE
1) Domestic Sales
2) Export Sales
3) GROSS SALES (1 + 2) 0.00 0.00
4) Less : Goods & Services Tax
5) NET SALES (3 - 4) 0.00 0.00
% wise rise/fall in net sales as compared to
previous year 0.00% 0.00%
6) Other Operating Income (to be specified by 0.00 0.00
i) other operating income / export incentives)
ii) Sale of Traded Goods
iii) Others 0.00 0.00
a) Sale of Scrap & Jobwork
A) TOTAL OPERATING REVENUE (5 + 6) 0.00 0.00
COST OF SALES
7) Raw materials consumed 0.00 0.00
i) Imported
ii) Indigenous
8) Other Spares consumed 0.00 0.00
i) Imported
ii) Indigenous
9) Power and fuel
10) Labour and wages
11) Other Manufacturing exps
PROFIT & LOSS ACCOUNT INPUT

Please Enter Data In Blue Colored Cell. Projections made at the time of last renewal to be entered in column E
Name of the Company
Constitution
Industry (as per HASCROM classification)
Bank rating to be done on
Balance sheet as at (Latest Audited/Un-
Audited Year to be updated)
Projections for how many years
NBFC PROPOSAL
First year for DSCR
Is the borrower a Holding Company serving as
a Investment vehicle for subsidiaries of the
group
Company Code (Bank's RATING CODE)
Currency
Currency - Unit
12) Depreciation 0.00 0.00
13) Sub total (sum of 7 TO 11) 0.00 0.00
Add: Op. Stock of WIP
Less: Cl. Stock of WIP
14) Total Cost of Production 0.00 0.00
Add Oping. Stock of Fin.Gds
Less: Cl. Stock of Fin.Gds
15) Total Cost of Goods Sold 0.00 0.00
16) Selling, Distribution & Admin.Exp
B) TOTAL COST OF SALES (15 + 16) 0.00 0.00
C) OPRTNG. PROFIT BEFORE INT.(A-B) 0.00 0.00
INTEREST COST
17) Interest payment to Banks 0.00 0.00
Interest - WC
Interest - Term Loans
18) Interest payment to FIs 0.00 0.00
Interest - WC
Interest - Term Loans
19) Interest payment to USL/Others 0.00 0.00
USL
Other interest
D) TOTAL INTEREST (17+18+19) 0.00 0.00
E) FINANCE COST (OTHER THAN INTEREST)
F) OPRTNG. PROFIT AFTER INT.(C-D-E)-Deprecia 0.00 0.00
Depreciation
20) Non cash/Non Operating Income 0.00 0.00
Cash Income 0.00 0.00
i) Prft. on sale of asts/ invest.
ii) Interests and Dividend
iii) Tax refund
iv) Extraordinary Income
v) Income from subsidiaries / related parties
vi) Other Cash items
Non Cash Income 0.00 0.00
PROFIT & LOSS ACCOUNT INPUT

Non Cash Exps 0.00 0.00

i) Loss on sale of assets
ii) Preliminary exps w/off (Non Cash)
iii) Provision for doubtful debts
iv) Forex loss(Non Cash)
v) Amortization (Non Cash)

G) NET NON OPRTNG. INC. / EXP. (20-21) 0.00 0.00

H) PROFIT BEFORE TAX (PBT) (F+G) 0.00 0.00

PROVISION FOR TAX
i) Current
ii) Deferred
I) TAX PROVISION 0.00 0.00
Tax % 0.00% 0.00%
J) NET PROFIT (Before adjustment of
Extraordinary items post tax) (H-I) 0.00 0.00

K) EXTRAORDINARY ITEM (POST TAX) : 0.00 0.00

Extraordinary Income
Extraordinary Expenses

L) NET PROFIT (After adjustment of Extraordinar 0.00 0.00

% wise rise/fall in net Profit as compared to
previous year 0.00% 0.00%
M) APPROPRIATION OF PROFIT 0.00 0.00
PROFIT & LOSS ACCOUNT INPUT

O) CASH ACCRUALS (After adjusting all non

cash items) 0.00 0.00

EARNING BEFORE INTEREST, DEPRECIATION,

TAXES & AMORTIZATION (EBIDTA) 0.00 0.00

EARNING BEFORE INTEREST & TAX (EBIT) 0.00 0.00

ADJUSTED PAT (Exc. All extraordinary items) 0.00 0.00

Annual Purchase Cost of RM & Spares 0.00 0.00

Accepted Sales as per Bank 0.00 0.00
Additional information for MCB, Ratio and
DSCR Sheets

Data for Previous Year

Total of appropriation from Accumulated P&L
Account (including dividend and
Withdrawal/cash appropriation)

Additional information for WC sheet

Method (1 or 2)

Additional information for BEP sheet

BREAK EVEN POINT CALCULATION
Direct Labour & Wages
S&A
Price Per Unit
PROFIT & LOSS ACCOUNT INPUT

Please Enter Data In Blue Colored Cell. Projections made at the time of last renewal to be entered in column E
Name of the Company
Constitution
Industry (as per HASCROM classification)
Bank rating to be done on
Balance sheet as at (Latest Audited/Un-
Audited Year to be updated)
Projections for how many years
NBFC PROPOSAL
First year for DSCR
Is the borrower a Holding Company serving as
a Investment vehicle for subsidiaries of the
group
Company Code (Bank's RATING CODE)
Currency
Currency - Unit
Auditors Name / Location / Regn. No. 11 12
2037 2038
Yr.End.(DD-MMM-YY) 31/Mar/37 31/Mar/38
No. Of Months 12 12
Exchange Rate 1 1
Projected Projected
Lakhs Lakhs
To be printed on MCB sheet Yes Yes
To be printed in Cash Flow Yes Yes
OPERATING REVENUE
1) Domestic Sales
2) Export Sales
3) GROSS SALES (1 + 2) 0.00 0.00
4) Less : Goods & Services Tax
5) NET SALES (3 - 4) 0.00 0.00
% wise rise/fall in net sales as compared to
previous year 0.00% 0.00%
6) Other Operating Income (to be specified by 0.00 0.00
i) other operating income / export incentives)
ii) Sale of Traded Goods
iii) Others 0.00 0.00
a) Sale of Scrap & Jobwork
A) TOTAL OPERATING REVENUE (5 + 6) 0.00 0.00
COST OF SALES
7) Raw materials consumed 0.00 0.00
i) Imported
ii) Indigenous
8) Other Spares consumed 0.00 0.00
i) Imported
ii) Indigenous
9) Power and fuel
10) Labour and wages
11) Other Manufacturing exps
PROFIT & LOSS ACCOUNT INPUT

Please Enter Data In Blue Colored Cell. Projections made at the time of last renewal to be entered in column E
Name of the Company
Constitution
Industry (as per HASCROM classification)
Bank rating to be done on
Balance sheet as at (Latest Audited/Un-
Audited Year to be updated)
Projections for how many years
NBFC PROPOSAL
First year for DSCR
Is the borrower a Holding Company serving as
a Investment vehicle for subsidiaries of the
group
Company Code (Bank's RATING CODE)
Currency
Currency - Unit
12) Depreciation 0.00 0.00
13) Sub total (sum of 7 TO 11) 0.00 0.00
Add: Op. Stock of WIP
Less: Cl. Stock of WIP
14) Total Cost of Production 0.00 0.00
Add Oping. Stock of Fin.Gds
Less: Cl. Stock of Fin.Gds
15) Total Cost of Goods Sold 0.00 0.00
16) Selling, Distribution & Admin.Exp
B) TOTAL COST OF SALES (15 + 16) 0.00 0.00
C) OPRTNG. PROFIT BEFORE INT.(A-B) 0.00 0.00
INTEREST COST
17) Interest payment to Banks 0.00 0.00
Interest - WC
Interest - Term Loans
18) Interest payment to FIs 0.00 0.00
Interest - WC
Interest - Term Loans
19) Interest payment to USL/Others 0.00 0.00
USL
Other interest
D) TOTAL INTEREST (17+18+19) 0.00 0.00
E) FINANCE COST (OTHER THAN INTEREST)
F) OPRTNG. PROFIT AFTER INT.(C-D-E)-Deprecia 0.00 0.00
Depreciation
20) Non cash/Non Operating Income 0.00 0.00
Cash Income 0.00 0.00
i) Prft. on sale of asts/ invest.
ii) Interests and Dividend
iii) Tax refund
iv) Extraordinary Income
v) Income from subsidiaries / related parties
vi) Other Cash items
Non Cash Income 0.00 0.00
PROFIT & LOSS ACCOUNT INPUT

Non Cash Exps 0.00 0.00

i) Loss on sale of assets
ii) Preliminary exps w/off (Non Cash)
iii) Provision for doubtful debts
iv) Forex loss(Non Cash)
v) Amortization (Non Cash)

G) NET NON OPRTNG. INC. / EXP. (20-21) 0.00 0.00

H) PROFIT BEFORE TAX (PBT) (F+G) 0.00 0.00

PROVISION FOR TAX
i) Current
ii) Deferred
I) TAX PROVISION 0.00 0.00
Tax % 0.00% 0.00%
J) NET PROFIT (Before adjustment of
Extraordinary items post tax) (H-I) 0.00 0.00

K) EXTRAORDINARY ITEM (POST TAX) : 0.00 0.00

Extraordinary Income
Extraordinary Expenses

L) NET PROFIT (After adjustment of Extraordinar 0.00 0.00

% wise rise/fall in net Profit as compared to
previous year 0.00% 0.00%
M) APPROPRIATION OF PROFIT 0.00 0.00
PROFIT & LOSS ACCOUNT INPUT

O) CASH ACCRUALS (After adjusting all non

cash items) 0.00 0.00

EARNING BEFORE INTEREST, DEPRECIATION,

TAXES & AMORTIZATION (EBIDTA) 0.00 0.00

EARNING BEFORE INTEREST & TAX (EBIT) 0.00 0.00

ADJUSTED PAT (Exc. All extraordinary items) 0.00 0.00

Annual Purchase Cost of RM & Spares 0.00 0.00

Accepted Sales as per Bank 0.00 0.00
Additional information for MCB, Ratio and
DSCR Sheets

Data for Previous Year

Total of appropriation from Accumulated P&L
Account (including dividend and
Withdrawal/cash appropriation)

Additional information for WC sheet

Method (1 or 2)

Additional information for BEP sheet

BREAK EVEN POINT CALCULATION
Direct Labour & Wages
S&A
Price Per Unit
PROFIT & LOSS ACCOUNT INPUT

Please Enter Data In Blue Colored Cell. Projections made at the time of last renewal to be entered in column E
Name of the Company
Constitution
Industry (as per HASCROM classification)
Bank rating to be done on
Balance sheet as at (Latest Audited/Un-
Audited Year to be updated)
Projections for how many years
NBFC PROPOSAL
First year for DSCR
Is the borrower a Holding Company serving as
a Investment vehicle for subsidiaries of the
group
Company Code (Bank's RATING CODE)
Currency
Currency - Unit
Auditors Name / Location / Regn. No. 13 14
2039 2040
Yr.End.(DD-MMM-YY) 31/Mar/39 31/Mar/40
No. Of Months 12 12
Exchange Rate 1 1
Projected Projected
Lakhs Lakhs
To be printed on MCB sheet Yes Yes
To be printed in Cash Flow Yes Yes
OPERATING REVENUE
1) Domestic Sales
2) Export Sales
3) GROSS SALES (1 + 2) 0.00 0.00
4) Less : Goods & Services Tax
5) NET SALES (3 - 4) 0.00 0.00
% wise rise/fall in net sales as compared to
previous year 0.00% 0.00%
6) Other Operating Income (to be specified by 0.00 0.00
i) other operating income / export incentives)
ii) Sale of Traded Goods
iii) Others 0.00 0.00
a) Sale of Scrap & Jobwork
A) TOTAL OPERATING REVENUE (5 + 6) 0.00 0.00
COST OF SALES
7) Raw materials consumed 0.00 0.00
i) Imported
ii) Indigenous
8) Other Spares consumed 0.00 0.00
i) Imported
ii) Indigenous
9) Power and fuel
10) Labour and wages
11) Other Manufacturing exps
PROFIT & LOSS ACCOUNT INPUT

Please Enter Data In Blue Colored Cell. Projections made at the time of last renewal to be entered in column E
Name of the Company
Constitution
Industry (as per HASCROM classification)
Bank rating to be done on
Balance sheet as at (Latest Audited/Un-
Audited Year to be updated)
Projections for how many years
NBFC PROPOSAL
First year for DSCR
Is the borrower a Holding Company serving as
a Investment vehicle for subsidiaries of the
group
Company Code (Bank's RATING CODE)
Currency
Currency - Unit
12) Depreciation 0.00 0.00
13) Sub total (sum of 7 TO 11) 0.00 0.00
Add: Op. Stock of WIP
Less: Cl. Stock of WIP
14) Total Cost of Production 0.00 0.00
Add Oping. Stock of Fin.Gds
Less: Cl. Stock of Fin.Gds
15) Total Cost of Goods Sold 0.00 0.00
16) Selling, Distribution & Admin.Exp
B) TOTAL COST OF SALES (15 + 16) 0.00 0.00
C) OPRTNG. PROFIT BEFORE INT.(A-B) 0.00 0.00
INTEREST COST
17) Interest payment to Banks 0.00 0.00
Interest - WC
Interest - Term Loans
18) Interest payment to FIs 0.00 0.00
Interest - WC
Interest - Term Loans
19) Interest payment to USL/Others 0.00 0.00
USL
Other interest
D) TOTAL INTEREST (17+18+19) 0.00 0.00
E) FINANCE COST (OTHER THAN INTEREST)
F) OPRTNG. PROFIT AFTER INT.(C-D-E)-Deprecia 0.00 0.00
Depreciation
20) Non cash/Non Operating Income 0.00 0.00
Cash Income 0.00 0.00
i) Prft. on sale of asts/ invest.
ii) Interests and Dividend
iii) Tax refund
iv) Extraordinary Income
v) Income from subsidiaries / related parties
vi) Other Cash items
Non Cash Income 0.00 0.00
PROFIT & LOSS ACCOUNT INPUT

Non Cash Exps 0.00 0.00

i) Loss on sale of assets
ii) Preliminary exps w/off (Non Cash)
iii) Provision for doubtful debts
iv) Forex loss(Non Cash)
v) Amortization (Non Cash)

G) NET NON OPRTNG. INC. / EXP. (20-21) 0.00 0.00

H) PROFIT BEFORE TAX (PBT) (F+G) 0.00 0.00

PROVISION FOR TAX
i) Current
ii) Deferred
I) TAX PROVISION 0.00 0.00
Tax % 0.00% 0.00%
J) NET PROFIT (Before adjustment of
Extraordinary items post tax) (H-I) 0.00 0.00

K) EXTRAORDINARY ITEM (POST TAX) : 0.00 0.00

Extraordinary Income
Extraordinary Expenses

L) NET PROFIT (After adjustment of Extraordinar 0.00 0.00

% wise rise/fall in net Profit as compared to
previous year 0.00% 0.00%
M) APPROPRIATION OF PROFIT 0.00 0.00
PROFIT & LOSS ACCOUNT INPUT

O) CASH ACCRUALS (After adjusting all non

cash items) 0.00 0.00

EARNING BEFORE INTEREST, DEPRECIATION,

TAXES & AMORTIZATION (EBIDTA) 0.00 0.00

EARNING BEFORE INTEREST & TAX (EBIT) 0.00 0.00

ADJUSTED PAT (Exc. All extraordinary items) 0.00 0.00

Annual Purchase Cost of RM & Spares 0.00 0.00

Accepted Sales as per Bank 0.00 0.00
Additional information for MCB, Ratio and
DSCR Sheets

Data for Previous Year

Total of appropriation from Accumulated P&L
Account (including dividend and
Withdrawal/cash appropriation)

Additional information for WC sheet

Method (1 or 2)

Additional information for BEP sheet

BREAK EVEN POINT CALCULATION
Direct Labour & Wages
S&A
Price Per Unit
PROFIT & LOSS ACCOUNT INPUT

Please Enter Data In Blue Colored Cell. Projections made at the time of last renewal to be entered in column E
Name of the Company
Constitution
Industry (as per HASCROM classification)
Bank rating to be done on
Balance sheet as at (Latest Audited/Un-
Audited Year to be updated)
Projections for how many years
NBFC PROPOSAL
First year for DSCR
Is the borrower a Holding Company serving as
a Investment vehicle for subsidiaries of the
group
Company Code (Bank's RATING CODE)
Currency
Currency - Unit
Auditors Name / Location / Regn. No. 15 16 17 18
2041 2042 2043 2044
Yr.End.(DD-MMM-YY) 31/Mar/41
No. Of Months 12
Exchange Rate 1
Projected
Lakhs
To be printed on MCB sheet Yes
To be printed in Cash Flow Yes
OPERATING REVENUE
1) Domestic Sales
2) Export Sales
3) GROSS SALES (1 + 2) 0.00
4) Less : Goods & Services Tax
5) NET SALES (3 - 4) 0.00
% wise rise/fall in net sales as compared to
previous year 0.00%
6) Other Operating Income (to be specified by 0.00
i) other operating income / export incentives)
ii) Sale of Traded Goods
iii) Others 0.00
a) Sale of Scrap & Jobwork
A) TOTAL OPERATING REVENUE (5 + 6) 0.00
COST OF SALES
7) Raw materials consumed 0.00
i) Imported
ii) Indigenous
8) Other Spares consumed 0.00
i) Imported
ii) Indigenous
9) Power and fuel
10) Labour and wages
11) Other Manufacturing exps
PROFIT & LOSS ACCOUNT INPUT

Please Enter Data In Blue Colored Cell. Projections made at the time of last renewal to be entered in column E
Name of the Company
Constitution
Industry (as per HASCROM classification)
Bank rating to be done on
Balance sheet as at (Latest Audited/Un-
Audited Year to be updated)
Projections for how many years
NBFC PROPOSAL
First year for DSCR
Is the borrower a Holding Company serving as
a Investment vehicle for subsidiaries of the
group
Company Code (Bank's RATING CODE)
Currency
Currency - Unit
12) Depreciation 0.00
13) Sub total (sum of 7 TO 11) 0.00
Add: Op. Stock of WIP
Less: Cl. Stock of WIP
14) Total Cost of Production 0.00
Add Oping. Stock of Fin.Gds
Less: Cl. Stock of Fin.Gds
15) Total Cost of Goods Sold 0.00
16) Selling, Distribution & Admin.Exp
B) TOTAL COST OF SALES (15 + 16) 0.00
C) OPRTNG. PROFIT BEFORE INT.(A-B) 0.00
INTEREST COST
17) Interest payment to Banks 0.00
Interest - WC
Interest - Term Loans
18) Interest payment to FIs 0.00
Interest - WC
Interest - Term Loans
19) Interest payment to USL/Others 0.00
USL
Other interest
D) TOTAL INTEREST (17+18+19) 0.00
E) FINANCE COST (OTHER THAN INTEREST)
F) OPRTNG. PROFIT AFTER INT.(C-D-E)-Deprecia 0.00
Depreciation
20) Non cash/Non Operating Income 0.00
Cash Income 0.00
i) Prft. on sale of asts/ invest.
ii) Interests and Dividend
iii) Tax refund
iv) Extraordinary Income
v) Income from subsidiaries / related parties
vi) Other Cash items
Non Cash Income 0.00
PROFIT & LOSS ACCOUNT INPUT

Non Cash Exps 0.00

i) Loss on sale of assets
ii) Preliminary exps w/off (Non Cash)
iii) Provision for doubtful debts
iv) Forex loss(Non Cash)
v) Amortization (Non Cash)

G) NET NON OPRTNG. INC. / EXP. (20-21) 0.00

H) PROFIT BEFORE TAX (PBT) (F+G) 0.00

PROVISION FOR TAX
i) Current
ii) Deferred
I) TAX PROVISION 0.00
Tax % 0.00%
J) NET PROFIT (Before adjustment of
Extraordinary items post tax) (H-I) 0.00

K) EXTRAORDINARY ITEM (POST TAX) : 0.00

Extraordinary Income
Extraordinary Expenses

L) NET PROFIT (After adjustment of Extraordinar 0.00

% wise rise/fall in net Profit as compared to
previous year 0.00%
M) APPROPRIATION OF PROFIT 0.00
PROFIT & LOSS ACCOUNT INPUT

O) CASH ACCRUALS (After adjusting all non

cash items) 0.00

EARNING BEFORE INTEREST, DEPRECIATION,

TAXES & AMORTIZATION (EBIDTA) 0.00

EARNING BEFORE INTEREST & TAX (EBIT) 0.00

ADJUSTED PAT (Exc. All extraordinary items) 0.00

Annual Purchase Cost of RM & Spares 0.00

Accepted Sales as per Bank 0.00
Additional information for MCB, Ratio and
DSCR Sheets

Data for Previous Year

Total of appropriation from Accumulated P&L
Account (including dividend and
Withdrawal/cash appropriation)

Additional information for WC sheet

Method (1 or 2)

Additional information for BEP sheet

BREAK EVEN POINT CALCULATION
Direct Labour & Wages
S&A
Price Per Unit
PROFIT & LOSS ACCOUNT INPUT

To be printed on MCB sheet

To be printed in Cash Flow
OPERATING REVENUE
1) Domestic Sales
2) Export Sales
3) GROSS SALES (1 + 2)
4) Less : Goods & Services Tax
5) NET SALES (3 - 4)
% wise rise/fall in net sales as compared to
previous year
6) Other Operating Income (to be specified by
i) other operating income / export incentives)
ii) Sale of Traded Goods
iii) Others
a) Sale of Scrap & Jobwork
A) TOTAL OPERATING REVENUE (5 + 6)
COST OF SALES
7) Raw materials consumed
i) Imported
ii) Indigenous
8) Other Spares consumed
i) Imported
ii) Indigenous
9) Power and fuel
10) Labour and wages
11) Other Manufacturing exps
PROFIT & LOSS ACCOUNT INPUT

Please Enter Data In Blue Colored Cell. Projections made at the time of last renewal to be entered in column E
Name of the Company
Constitution
Industry (as per HASCROM classification)
Bank rating to be done on
Balance sheet as at (Latest Audited/Un-
Audited Year to be updated)
Projections for how many years
NBFC PROPOSAL
First year for DSCR
Is the borrower a Holding Company serving as
a Investment vehicle for subsidiaries of the
group
Company Code (Bank's RATING CODE)
Currency
Currency - Unit
12) Depreciation
13) Sub total (sum of 7 TO 11)
Add: Op. Stock of WIP
Less: Cl. Stock of WIP
14) Total Cost of Production
Add Oping. Stock of Fin.Gds
Less: Cl. Stock of Fin.Gds
15) Total Cost of Goods Sold
16) Selling, Distribution & Admin.Exp
B) TOTAL COST OF SALES (15 + 16)
C) OPRTNG. PROFIT BEFORE INT.(A-B)
INTEREST COST
17) Interest payment to Banks
Interest - WC
Interest - Term Loans
18) Interest payment to FIs
Interest - WC
Interest - Term Loans
19) Interest payment to USL/Others
USL
Other interest
D) TOTAL INTEREST (17+18+19)
E) FINANCE COST (OTHER THAN INTEREST)
F) OPRTNG. PROFIT AFTER INT.(C-D-E)-Deprecia
Depreciation
20) Non cash/Non Operating Income
Cash Income
i) Prft. on sale of asts/ invest.
ii) Interests and Dividend
iii) Tax refund
iv) Extraordinary Income
v) Income from subsidiaries / related parties
vi) Other Cash items
Non Cash Income
PROFIT & LOSS ACCOUNT INPUT

Non Cash Exps

i) Loss on sale of assets
ii) Preliminary exps w/off (Non Cash)
iii) Provision for doubtful debts
iv) Forex loss(Non Cash)
v) Amortization (Non Cash)

G) NET NON OPRTNG. INC. / EXP. (20-21)

H) PROFIT BEFORE TAX (PBT) (F+G)

PROVISION FOR TAX
i) Current
ii) Deferred
I) TAX PROVISION
Tax %
J) NET PROFIT (Before adjustment of
Extraordinary items post tax) (H-I)

K) EXTRAORDINARY ITEM (POST TAX) :

Extraordinary Income
Extraordinary Expenses

L) NET PROFIT (After adjustment of Extraordinar

% wise rise/fall in net Profit as compared to
previous year
M) APPROPRIATION OF PROFIT
PROFIT & LOSS ACCOUNT INPUT

O) CASH ACCRUALS (After adjusting all non

cash items)

EARNING BEFORE INTEREST, DEPRECIATION,

TAXES & AMORTIZATION (EBIDTA)

EARNING BEFORE INTEREST & TAX (EBIT)

ADJUSTED PAT (Exc. All extraordinary items)

Annual Purchase Cost of RM & Spares

Accepted Sales as per Bank
Additional information for MCB, Ratio and
DSCR Sheets

Data for Previous Year

Total of appropriation from Accumulated P&L
Account (including dividend and
Withdrawal/cash appropriation)

Additional information for WC sheet

Method (1 or 2)

Additional information for BEP sheet

BREAK EVEN POINT CALCULATION
Direct Labour & Wages
S&A
Price Per Unit
PROFIT & LOSS ACCOUNT INPUT

Yr.End.(DD-MMM-YY)
No. Of Months
Exchange Rate

To be printed on MCB sheet

Please Enter Data In Blue Colored Cell. Projections made at the time of last renewal to be entered in column E
Name of the Company
Constitution
Industry (as per HASCROM classification)
Bank rating to be done on
Balance sheet as at (Latest Audited/Un-
Audited Year to be updated)
Projections for how many years
NBFC PROPOSAL
First year for DSCR
Is the borrower a Holding Company serving as
a Investment vehicle for subsidiaries of the
group
Company Code (Bank's RATING CODE)
Currency
Currency - Unit
12) Depreciation
13) Sub total (sum of 7 TO 11)
Add: Op. Stock of WIP
Less: Cl. Stock of WIP
14) Total Cost of Production
Add Oping. Stock of Fin.Gds
Less: Cl. Stock of Fin.Gds
15) Total Cost of Goods Sold
16) Selling, Distribution & Admin.Exp
B) TOTAL COST OF SALES (15 + 16)
C) OPRTNG. PROFIT BEFORE INT.(A-B)
INTEREST COST
17) Interest payment to Banks
Interest - WC
Interest - Term Loans
18) Interest payment to FIs
Interest - WC
Interest - Term Loans
19) Interest payment to USL/Others
USL
Other interest
D) TOTAL INTEREST (17+18+19)
E) FINANCE COST (OTHER THAN INTEREST)
F) OPRTNG. PROFIT AFTER INT.(C-D-E)-Deprecia
Depreciation
20) Non cash/Non Operating Income
Cash Income
i) Prft. on sale of asts/ invest.
ii) Interests and Dividend
iii) Tax refund
iv) Extraordinary Income
v) Income from subsidiaries / related parties
vi) Other Cash items
Non Cash Income
PROFIT & LOSS ACCOUNT INPUT

Non Cash Exps

i) Loss on sale of assets
ii) Preliminary exps w/off (Non Cash)
iii) Provision for doubtful debts
iv) Forex loss(Non Cash)
v) Amortization (Non Cash)

G) NET NON OPRTNG. INC. / EXP. (20-21)

H) PROFIT BEFORE TAX (PBT) (F+G)

PROVISION FOR TAX
i) Current
ii) Deferred
I) TAX PROVISION
Tax %
J) NET PROFIT (Before adjustment of
Extraordinary items post tax) (H-I)

K) EXTRAORDINARY ITEM (POST TAX) :

Extraordinary Income
Extraordinary Expenses

L) NET PROFIT (After adjustment of Extraordinar

% wise rise/fall in net Profit as compared to
previous year
M) APPROPRIATION OF PROFIT
PROFIT & LOSS ACCOUNT INPUT

O) CASH ACCRUALS (After adjusting all non

cash items)

EARNING BEFORE INTEREST, DEPRECIATION,

TAXES & AMORTIZATION (EBIDTA)

EARNING BEFORE INTEREST & TAX (EBIT)

ADJUSTED PAT (Exc. All extraordinary items)

Annual Purchase Cost of RM & Spares

Accepted Sales as per Bank
Additional information for MCB, Ratio and
DSCR Sheets

Data for Previous Year

Total of appropriation from Accumulated P&L
Account (including dividend and
Withdrawal/cash appropriation)

Additional information for WC sheet

Method (1 or 2)

Additional information for BEP sheet

BREAK EVEN POINT CALCULATION
Direct Labour & Wages
S&A
Price Per Unit
PROFIT & LOSS ACCOUNT INPUT

Yr.End.(DD-MMM-YY)
No. Of Months
Exchange Rate

To be printed on MCB sheet

Please Enter Data In Blue Colored Cell. Projections made at the time of last renewal to be entered in column E
Name of the Company
Constitution
Industry (as per HASCROM classification)
Bank rating to be done on
Balance sheet as at (Latest Audited/Un-
Audited Year to be updated)
Projections for how many years
NBFC PROPOSAL
First year for DSCR
Is the borrower a Holding Company serving as
a Investment vehicle for subsidiaries of the
group
Company Code (Bank's RATING CODE)
Currency
Currency - Unit
12) Depreciation
13) Sub total (sum of 7 TO 11)
Add: Op. Stock of WIP
Less: Cl. Stock of WIP
14) Total Cost of Production
Add Oping. Stock of Fin.Gds
Less: Cl. Stock of Fin.Gds
15) Total Cost of Goods Sold
16) Selling, Distribution & Admin.Exp
B) TOTAL COST OF SALES (15 + 16)
C) OPRTNG. PROFIT BEFORE INT.(A-B)
INTEREST COST
17) Interest payment to Banks
Interest - WC
Interest - Term Loans
18) Interest payment to FIs
Interest - WC
Interest - Term Loans
19) Interest payment to USL/Others
USL
Other interest
D) TOTAL INTEREST (17+18+19)
E) FINANCE COST (OTHER THAN INTEREST)
F) OPRTNG. PROFIT AFTER INT.(C-D-E)-Deprecia
Depreciation
20) Non cash/Non Operating Income
Cash Income
i) Prft. on sale of asts/ invest.
ii) Interests and Dividend
iii) Tax refund
iv) Extraordinary Income
v) Income from subsidiaries / related parties
vi) Other Cash items
Non Cash Income
PROFIT & LOSS ACCOUNT INPUT

Non Cash Exps

i) Loss on sale of assets
ii) Preliminary exps w/off (Non Cash)
iii) Provision for doubtful debts
iv) Forex loss(Non Cash)
v) Amortization (Non Cash)

G) NET NON OPRTNG. INC. / EXP. (20-21)

H) PROFIT BEFORE TAX (PBT) (F+G)

PROVISION FOR TAX
i) Current
ii) Deferred
I) TAX PROVISION
Tax %
J) NET PROFIT (Before adjustment of
Extraordinary items post tax) (H-I)

K) EXTRAORDINARY ITEM (POST TAX) :

Extraordinary Income
Extraordinary Expenses

L) NET PROFIT (After adjustment of Extraordinar

% wise rise/fall in net Profit as compared to
previous year
M) APPROPRIATION OF PROFIT
PROFIT & LOSS ACCOUNT INPUT

O) CASH ACCRUALS (After adjusting all non

cash items)

EARNING BEFORE INTEREST, DEPRECIATION,

TAXES & AMORTIZATION (EBIDTA)

EARNING BEFORE INTEREST & TAX (EBIT)

ADJUSTED PAT (Exc. All extraordinary items)

Annual Purchase Cost of RM & Spares

Accepted Sales as per Bank
Additional information for MCB, Ratio and
DSCR Sheets

Data for Previous Year

Total of appropriation from Accumulated P&L
Account (including dividend and
Withdrawal/cash appropriation)

Additional information for WC sheet

Method (1 or 2)

Additional information for BEP sheet

BREAK EVEN POINT CALCULATION
Direct Labour & Wages
S&A
Price Per Unit
PROFIT & LOSS ACCOUNT INPUT

Please Enter Data In Blue Colored Cell.

Projections made at the time of last Is it an NBFC proposal?
renewal to be entered in column E

Name of the Company OM HOTEL AND SWEET HOME

Industry (as per HASCROM classification) Retail Trade

Bank's rating to be done on 3/31/2025
Company Code (Bank's RATING CODE)

Currency INR
Auditors 0
2023 2024
Year ended (DD-MMM-YY) 31/Mar/23 31/Mar/24
No. Of Months 12 12
Exchange Rate 1 1

Audited Audited

Lakhs Lakhs

CURRENT LIABILITIES
A) Short Term Borrowings 0.00 0.00
1) Borrowings from Banks & FIs 0.00 0.00
a) from our bank
b) from other bank
c) from other FIs
2) Borrowing from Related Parties 0.00 0.00
a) Secured
b) Unsecured
3) Other Borrowings not classified above 0.00 0.00
a) Commercial Paper
b) PQR
c) PQR
B) Creditors 0.00 0.00
1) Trade Creditors
2) Other Creditors
3) Creditors under LC / Buyer's Credit for
Raw Material

C) Other Current Liability 0.00 0.00

1) Term Loan installments due within a
year
2) Other Term Liabilities maturing within
a year 0.00 0.00
a) NCD
b) CCD (unsecured)
c) Term Loan from Others
3) Interest accrued but not due on
borrowings
4) Interest accrued and due on
borrowings

5) Statutory liabilities due within a year

6) Creditors for Capital expenditure due

within a year
7) Dividend Payable
8) Advance from customers / Dealers
Deposits
9) Short term deposits (other than
dealers deposit)
10) Share Application Money (Not
finalized for allotment, oversubscribed
money)
11) Other Payables (Major items to be
specified) 0.00 0.00
a) Employee Benefits Payable
b) Deferred premium on forward
contract
c) other

D) Short Term Provisions 0.00 0.00

1) Tax Provisions
2) Others (to be specified) 0.00 0.00
a) Provision for expenses
b) Prov for Leave Benefits
c) Provision for NPA

I TOTAL CURRENT LIABILTIES (A+B+C+D) 0.00 0.00

TERM LIABILITIES
E) Debentures
Preference Share Capital (Residual
F) Periods < 12 years)

Long Term Borrowings (excluding

G) installments payable within a year) 0.00 0.00

1) Term Loan from Banks & FIs (Secured) 0.00 0.00

a) from bank
b) from FIs
2) Borrowing from Related Parties (In
form of Quasi Equity) 0.00 0.00
a) Secured Borrowings
b) Unsecured Borrowings
3) Borrowing from Related Parties
(other than Quasi Equity) 0.00 0.00
a) Secured Borrowings
b) Unsecured Borrowings
4) Other Borrowings not classified above
(to be specified by the user) 0.00 0.00
other term liability
Long Term Provision
5) Other Unsecured Borrowings not
classified above (to be specified by the 0.00 0.00
user)
a) Unsecured NCD
b) Unsecured Term Loan
H) Other Long Term Liabilities 0.00 0.00
1) Long Term Debts
2) Deferred Tax Liability
3) Sundry cre. for cap goods (Long Term)
4) Others

II TOTAL TERM LIABILTIES (E+F+G+H) 0.00 0.00

III TOTAL OUTSIDE LIABILTIES (I+II) 0.00 0.00

NET WORTH
I) Equity share capital (paid up)
Preference Share Capital (paid up)
J) (Residual Period > 12 year)

Share Application Money (Finalized for

K) allotment) & Share
L) Reserves and Surplus 0.00 0.00
1) Revenue Reserve ( Reserves out of
Profit in normal business course) 0.00 0.00

a) General / Free / Contingency Reserve

i) Other Reserves
Adjustments
2) Capital Reserve (Reserves out of
Capital Profit) 0.00 0.00
a) Share Premium
b) Capital Subsidy
c) Revaluation Reserve
d) Others( Unsecured loans considered as
a part of equity) 0.00 0.00
e) Capital Redemption Reserve
f) Other reserves
3) Accumulated P&L

IV TOTAL NET WORTH (I+J+K+L) 0.00 0.00

V TOTAL LIABILITIES (III + IV) 0.00 0.00

CURRENT ASSETS
M) Cash & Cash equivalent 0.00 0.00
1) Cash in hand
2) Bank Balance
3) Other
N) Receivables 0.00 0.00
1) Domestic (upto 6 Months)
2) Export Receivables
3) Def.recei.(due within 1 year)
Note :
1. All receivable upto 180 days or as
permitted as per sanction
2. Sale bills negotiated under LC to be
excluded.
O) Inventory 0.00 0.00
1) Raw Materials - Imported
2) Raw Materials - Indigenous
3) Work in process
4) Fini.Gds (incl Traded Goods)
5) Other cons.spares - Import.
6) Other consu.spares - Indige.
P) Other Current Assets 0.00 0.00
1) Advances to suppliers
2) Advance payment of tax
3) Advances to related parties (if
permitted for MPBF Assessment)
4) Current Investments (Govt. and other
trustee Sec. , fixed deposits with bank
etc)
5) Other Receivables (Major items to 0.00 0.00
be specified)
a) Short term Loans and advances
b) Unbilled Revenue
C) Other Current assets

VI TOTAL CURRENT ASSETS (M+N+O+P) 0.00 0.00

FIXED ASSETS
Q) Tangible Asset (Net Block) 0.00 0.00
Gross Block (for IT Cos, software may be
entered in row no 148 )
Softwares (Intangible Fixed Asset )
Less : Accumulated depreciation

R) Capital Work in progress

VII TOTAL FIXED ASSETS (Q+R+S) 0.00 0.00

NON CURRENT ASSETS

T) Investments 0.00 0.00
1) Investment in group concerns
2) Other Investments
U) Receivables 0.00 0.00
1) Domestic Debtors > 6 mths
2) Deferred receivables (maturity
exceed. one year)
3) Dues from Related Parties (not
permitted for MPBF Calculation)
V) LOANS & ADVANCES 0.00 0.00
1) To group concerns / related parties
(including ICDs to related parties)
Others
W) Other Non Current Assets 0.00 0.00
1) Inter corporate Deposits (other than
given to related parties)
2) Adv. to Capital goods suppliers
3) Deferred Tax Asset
4) Other
X) Deferred Revenue Expenditure

TOTAL NON CURRENT ASSETS

VIII (T+U+V+W+X) 0.00 0.00

Intangible Assets:
Goodwill, Patents & trademarks
Accumulated Losses,Preliminary
expenses,Miscellaneous expenditure
not w/off, Other deferred revenue
expenses
Intangible Total 0.00 0.00
IX TOTAL ASSETS (VI+VII+VIII) 0.00 0.00
X DIFFERENCE IN B/S (V - IX) 0.00 0.00

TANGIBLE NETWORTH 0.00 0.00

ADDITIONAL INFORMATION
Total Debt to be paid within FY
(Principal Component) 0.00 0.00
Arrears of depreciation

Contingent liabilities 0.00 0.00

Arrears of cumulative dividends
Guarantees issued (relating to business)

Guarantees issued (for group companies)

Gratuity Liability not provided for
Disputed excise / customs / tax Liabilities
LCs
All other contingent liabilities
(incldg. Bills purchased - Under LC)
Repayments due within one year
Preference Share Capital (due in less than
a year)
Capital Commitment

Unhedged Forex
1 2

Audited

2025 2026 2027 2028

31/Mar/25 31/Mar/26 31/Mar/27 31/Mar/28
12 12 12 12
1 1 1 1

Audited Estimated Projected Projected

Lakhs Lakhs Lakhs Lakhs

Latest Audited/Un-
Audited Year details
to be updated in this
Column
0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00

25140.00 30250.00 15230.00 0.00

25140.00 30250.00 15230.00

400268.00 500000.00 500000.00 0.00

400268.00 500000.00 500000.00

0.00 0.00 0.00 0.00

425408.00 530250.00 515230.00 0.00

523935.00 546917.00 687132.00

0.00 0.00 0.00 0.00

523935.00 546917.00 687132.00 0.00

949343.00 1077167.00 1202362.00 0.00

0.00 0.00 0.00 0.00

949343.00 1077167.00 1202362.00 0.00

71120.00 84120.00 91250.00 0.00

71120.00 84120.00 91250.00

0.00 0.00 0.00 0.00

560250.00 680250.00 840120.00 0.00

560250.00 680250.00 840120.00

0.00 0.00 0.00 0.00

631370.00 764370.00 931370.00 0.00

197833.00 172677.00 150842.00 0.00

197833.00 172677.00 150842.00

197833.00 172677.00 150842.00 0.00

0.00 0.00 0.00 0.00

120140.00 140120.00 120150.00 0.00

120140.00 140120.00 120150.00
0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00

120140.00 140120.00 120150.00 0.00

0.00 0.00 0.00 0.00

949343.00 1077167.00 1202362.00 0.00
0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00

0.00 500000.00 500000.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

0.00
0.00

0.00

0.00
0.00

0.00

0.00
0.00
0.00

0.00

0.00
STATEMENT
Annualizing Factor 1.00
Statement Id
Statement Date
No. of Months 12.00
Balance sheet status
STATEMENT INFORMATION
PROFIT & LOSS STATEMENT
1. Gross Sales / Receipts
(i) Domestic Sales 0.00
(ii) Export Sales 0.00
TOTAL Sales 0.00
2. LESS: Excise Duty 0.00
3. Net Sales (1-2) 0.00
4. Increase in % terms over last year 0.00
5. Other Operating Income 0.00
6. Total Operating Income (3 + 5) 0.00
7. Cost of Sales
i) Raw Materials used in the process of Manufacture 0.00
(a) Imported 0.00
(b) Indigenous 0.00
ii) Other Spares 0.00
(a) Imported 0.00
(b) Indigenous 0.00
iii) Power & Fuel 0.00
iv) Direct Wages & Salary 0.00
v) Other Mfg. Expenses 0.00
vi) Depreciation 0.00
vii) Sub-Total (i to vi) 0.00
viii) Add: Opening stock in Process 0.00
Sub-Total (vii + viii) 0.00
ix) Deduct: Closing Stock in process 0.00
x) Cost of Production 0.00
xi) Add: Opening stock of finished goods 0.00
Sub-Total 0.00
xii) Add: Purchase of finished goods
Sub-Total 0.00
xiii) Deduct: Closing stock of finished goods 0.00
xiv) Total Cost of Sales (x + xi) (Cost of Goods 0.00
sold / Cost of Sales)
8. Selling, General and Admin Expenses 0.00
9. Sub-Total (7+8) 0.00
10. OPBIT (6-9) 0.00
11. Interest 0.00
12. Operating Profit after Interest (10 -11) 0.00
13 (i) Add : Other Non-operating Income
(a) Profit on Investments 0.00
(b) Profit on Sale of Fixed Assets Merged
(c) Other Misc. Income 0.00
Sub-Total (Income) 0.00
(ii) Deduct: Other Non-operating Expenses
(a) Preliminary Expenses 0.00
(b) Loss on Investments 0.00
(c) Loss on Sale of Fixed Assets 0.00
(d) Other Misc. Expenses 0.00
Sub-Total (Expenses) 0.00
(iii) Net Non-operating Income/ Expenses 13(i) - 0.00
13(ii)
14. PBT/ LOSS 0.00
15. Provision for Taxes 0.00
16. Net Profit/ LOSS (14 -15) 0.00
(a) Drawings made by prop. / partners during the year 0.00

(b) Equity Dividend Paid/ Proposed 0.00

(c) Dividend Tax 0.00
(d) Dividend Rate (%) 0.00
17. Sub-Total (a+b ) 0.00
18. Retained Profits (16 - 17) 0.00
19. Retained Profit/ Net Profit (%) 0.00
Summarized variables
Total Operating Income 0.00
Cost of Production 0.00
Cost of goods sold 0.00
OPBDIT 0.00
OPBDT 0.00
OPBIT 0.00
OPBT 0.00
OPAT (Net Operating Profit) 0.00
PBDIT 0.00
PBDT 0.00
PBIT 0.00
PBT 0.00
PAT (Net Profit) 0.00
Selling General and Amin Expenses 0.00
Net Cash Accruals 0.00
BALANCE SHEET
Current Liabilities
1. Short Term Borrowings from Banks (including bills
purchased/ discounted and excess borrowing placed
on repayment basis)
(i) From Applicant Bank 0.00
(ii) From other Banks 0.00
(ii) of which BP and BD 0.00
A. Sub-Total 0.00
2. Short Term Borrowings from Others 0.00
3. Sundry Creditors (Trade) 0.00
4. Advance Payment from Customers/ Deposits from 0.00
dealers
5. Provision for Taxation 0.00
6. Dividend Payable 0.00
7. Other Statutory Liabilities (due within 1 year) 0.00
8. Deposits/ Instalments of Term Loans/ DPGs/ Debentures 0.00
etc. (due within 1 year)
9. Other Current Liabilities & Provisions (due within
one year)
(i) Interest Accrued 0.00
(ii) Outstanding Liabilities
(iii) Others (Specify) 0.00
B. Sub-Total 0.00
10. Total Current Liabilities (A + B) 0.00
Term Liabilities
11. Debentures excluding Instalments payable within 1 year 0.00

12. Preference Shares maturing in less than 12 years 0.00

(excluding maturing within 1year)
13. Term Loans (excluding instalments payable within one 0.00
year)
14. Deferred Payment credits (excluding instalments due
within one year)
15. Term Deposits (excluding deposits payable within 1
year)
16. Other Term Liabilities (excluding payable within 1 year) 0.00

Long term liability to be taken as Quasi Equity 0.00

17. Total Term Liabilities (11 to 16) 0.00
18. Total Outside Liabilities (10 + 17) 0.00
Net Worth
19. Equity Capital 0.00
20. Share Application money Pending Allotment 0.00
21. Other Revenue Reserves 0.00
22. Share Premium Reserve
23. Other Capital Reserves 0.00
24. Preference Share Capital 0.00
25. General Reserves
26. Revaluation Reserves
27. Other Reserves excluding provisions
28. Surplus (+) or Deficit (-) in Profit & Loss Account
29. Total Net Worth 0.00
30. Deferred Tax Liability
If the parameter "Long term liability to be taken as Quasi
Equity" shall be treated as debt Enter 2 else 1
31. Total Liabilities 0.00
Assets
Current Assets
32. Cash & Bank Balances 0.00
28. Investments (other than long term investments)

(i) Government & Other Trustee Securities

(ii) Fixed Deposits with Banks
33. (i) Receivables other than Deferred and Exports 0.00
(including bills discounted by banks) < 6 months
(ii) Export Receivables including Bills Purchased/ 0.00
discounted by banks) < 6 months
(iii) Receivables (including Export Receivables) > 6 0.00
months and Instalment of Deferred Receivables < 1 Year

34. Inventory/ Stock in Trade:

i) Raw Materials (incl. Stores and other items used in the
process of manufacture)
(a) Imported 0.00
(b) Indigenous 0.00
ii) Stocks in Process 0.00
iii) Finished Goods 0.00
iv) Other Consumable Spares
(a) Imported 0.00
(b) Indigenous 0.00
Sub Total 0.00
35. Advances to Suppliers of Raw Materials & Stores/ 0.00
Spares/ merchandise
36. Advance Payment of Taxes 0.00
37. Other Current Assets (realizable within one year)

(i) Advances 0.00

(ii) Deposits 0.00
(iii) Prepaid expenses
(iv) Others (Specify major items)
Sub Total 0.00
38. Total Current Assets (32 to 37) 0.00
Fixed Assets
39. Gross Block 0.00
40. Depreciation to Date 0.00
41. Add: Capital Work in Progress 0.00
42. Net Block 0.00
43. Other Non-current Assets
Investments/ Book Debts/ Advances/ Deposits which
are not current assets
i) (a) Investment in Subsidiary Cos/ Affiliates 0.00
(b) Others 0.00
(ii) Advances to Suppliers of Capital Goods and 0.00
contractors
(iii) Deferred Receivables (maturity > 1 year) 0.00
(iv) Security deposits/ Tender deposits 0.00
(v) Others (including overdue debts/ advances/ deposits 0.00
etc.)
44. Non Consumable Stores & Spares / Obsolete stocks

45. Other Non-current Assets including dues from directors

and bad/ doubtful debts not provided for
46. Total Other Non-current Assets (43 to 45) 0.00
47. Intangible Assets
i) Patents, Goodwill, Copyright, IPR, etc. 0.00
ii) Preliminary expenses (to the extent not written off) 0.00

iii) Bad/ doubtful debts not provided for

iv) Deferred revenue expenditure 0.00
v) Deferred Tax Asset
Total Intangible Assets 0.00
48. Total Assets 0.00
49. Tangible Net Worth (29 - 47) 0.00
50. Net Working Capital 0.00
51. Current Ratio 0.00
52. Total Outside Liabilities/ Tangible Net Worth 0.00
53. Total Term Liabilities/ Tangible Net Worth 0.00
54. Additional information
A. Arrears of Depreciation 0.00
B. Contingent Liabilities
(i) Arrears of Cumulative Dividend 0.00
(ii) Gratuity liability not provided for 0.00
(iii) Disputed Excise/ Customs/ Tax liabilities 0.00
(iv) Bills accepted / Guarantees extended to
accommodate associate / sister / group concerns or third
parties.
(v) Other Liabilities not provided for
(vi) Other Contingent Liability 0.00
Total contingent Liabilities 0.00
Summarized Important Variables
Total Outside liabilities 0.00
Total Short term debt 0.00
Total Long Term Debt 0.00
Total other term libilities 0.00
Total Debt 0.00
Total Capital employed 0.00
Total Receivables (Debtors) 0.00
Total Inventories 0.00
Total Accounts payable ( creditors) 0.00
Total Other Income 0.00
Total Other Expense 0.00
Total Other current assets (Excluding Prepaid expenses) 0.00

Prepaid expenses 0.00

Total other current Liabilities (Excluding Accrued expenses) 0.00

Accrued Expenses 0.00

Total Other Non-Current Assets (Excluding Investments) 0.00

Total Intangibles 0.00

Non Current Investments 0.00
Check: Assets = Liabilities 0.00
1.00 1.00

12.00 12.00

0.00 2260250.00
0.00 0.00
0.00 2260250.00
0.00 0.00
0.00 2260250.00
0.00 0.00
0.00 0.00
0.00 2260250.00

0.00 1442123.00
0.00 0.00
0.00 1442123.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 34155.00
0.00 210000.00
0.00 43680.00
0.00 0.00
0.00 3172081.00
0.00 0.00
0.00 3172081.00
0.00 560250.00
0.00 2611831.00
0.00 525140.00
0.00 3136971.00

0.00 3136971.00
0.00 0.00
0.00 3136971.00

0.00 0.00
0.00 3136971.00
0.00 -876721.00
0.00 36397.00
0.00 -913118.00

0.00 0.00
Merged Merged
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 0.00
0.00 0.00

0.00 -913118.00
0.00 0.00
0.00 -913118.00
0.00 0.00

0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 -913118.00
0.00 100.00

0.00 2260250.00
0.00 2611831.00
0.00 3136971.00
0.00 -876721.00
0.00 -913118.00
0.00 -876721.00
0.00 -913118.00
0.00 -913118.00
0.00 -876721.00
0.00 -913118.00
0.00 -876721.00
0.00 -913118.00
0.00 -913118.00
0.00 0.00
0.00 -913118.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 25140.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

0.00 0.00
0.00 25140.00
0.00 25140.00

0.00 0.00

0.00 523935.00

0.00 0.00

0.00 0.00
0.00 523935.00
0.00 549075.00

0.00 0.00
0.00 0.00
0.00 0.00

0.00 549075.00

0.00 71120.00

0.00 0.00

0.00 0.00
0.00 560250.00
0.00 0.00
0.00 560250.00

0.00 0.00
0.00 0.00
0.00 1191620.00
0.00 0.00

0.00 0.00

0.00 0.00
0.00 0.00

0.00 0.00
0.00 1191620.00

0.00 197833.00
0.00 0.00
0.00 0.00
0.00 197833.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

0.00 0.00

0.00 0.00
0.00 1389453.00
0.00 0.00
0.00 1166480.00
0.00 47.40
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 0.00
0.00 0.00
0.00 549075.00
0.00 0.00
0.00 0.00
0.00 523935.00
0.00 0.00
0.00 1364313.00
0.00 0.00
0.00 1120500.00
0.00 25140.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
0.00 0.00
0.00 840378.00
Summarised Information

To be Printed Particulars Audited

Balance Sheet Data/Capital Structure 2023

No Equity Share capital 0.00
No Preference Share Capital 0.00
Share Application (finalized for Allotment) & Securities
No Premium 0.00
No Other Reserves & Surplus (excl. Rev. reserves & net of int 0.00
No Accumulated Profit & Loss 0.00
No Tangible Net worth 0.00
No Deferred Tax Liabilities / (Assets) 0.00
No TNW Adjusted to DTA/DTL 0.00
No Funds Invested Outside Business (FIOB) 0.00
No Adjusted TNW (ATNW) 0.00
No Term Liabilities (of which) 0.00
No -- Term Loans from Banks & FI 0.00
No Quasi Equity 0.00
Yes Other LT Borrowings not classified above 0.00
Yes Debentures 0.00
Yes -- Others Term Liabilities & Provisions 0.00
Yes Capital Employed 0.00
Yes Net Block (Excl. Revaluation Rsv.) 0.00
Yes Non-current assets 0.00
Yes
Yes
Yes
Yes Current Assets 0.00
Yes Inventories 0.00
Yes Debtors 0.00
Yes -- Cash & Bank Balance 0.00
Yes -- ST Investments 0.00
Yes -- Other Current Assets 0.00
Yes Current Liabilities 0.00
Yes -- Creditors 0.00
No -- Creditors for LC / Buyers Credit 0.00
Yes -- Bank Borrowings 0.00
Yes -- Term Borrowings Payable in one year 0.00
Yes -- Other Short Term Borrowings 0.00
Yes -- Other Liabilities & Provisions 0.00
Yes Net Current Assets 0.00
Yes Capital Deployed 0.00
Yes Additional Information
Yes Secured Long Term Borrowings (Excl. Term borrowing matu 0.00
Yes Unsecured Long Term Borrowings 0.00
Yes Operational Data:
Yes Gross Sales 0.00
Yes (-) Goods & Services Tax 0.00
Yes Net sales 0.00
Yes -- of which Export Sales 0.00
Yes Other Operating Income 0.00
Yes Total Operating Income (TOI) 0.00
Yes Net off -Non-Operating Income/Expenses 0.00
Yes Total Income (TI) 0.00
Yes Cost of goods sold 0.00
Yes Admn. Selling expenses/provisions 0.00
Yes Depreciation 0.00
Yes Interest & Financial Charges 0.00
Yes Profit Before Tax (PBT) 0.00
Yes Tax provisions 0.00
Yes Extraordinary Items 0.00
Yes Net profit after tax (PAT) 0.00
Yes Dividend / App. 0.00
Yes Net profit retained in business 0.00
Yes Cash Accruals 0.00
Yes EBIT 0.00
Yes Operating Cash Profit (EBIT+Depreciation - Non Operatin 0.00
Yes EBITDA 0.00
Yes Adjusted Net Profit (Exc. All extraordinary items) 0.00
Yes Ratio Analysis:
Yes Operating Profit margin {OPBDIT/TOI %} #DIV/0!
Yes PBT/NS (in %) #DIV/0!
Yes PAT/NS (in %) #DIV/0!
Yes Total Debt/EBITDA #DIV/0!
Yes Return on capital employed (in %) #DIV/0!
Yes PAT/ATNW #DIV/0!
Yes Current Ratio (Including AMTL ) #DIV/0!
Yes Current Ratio (Excluding AMTL ) #DIV/0!
Yes Debt Equity Ratio (Including AMTL) #DIV/0!
Yes TOL/ANW #DIV/0!
Yes DE Ratio (TTL/TNW) #DIV/0!
Yes TOL/TNW #DIV/0!
No DE Ratio (TTL/ATNW) [Networth includes Quasi Equity] #DIV/0!
No DE Ratio (TOL/ATNW) [Networth includes Quasi Equity] #DIV/0!
No (TOL + Cont. Lia.) / ATNW 0.00
No % of Cont. lia. To ATNW 0.00
Yes Interest Coverage Ratio {EBITDA/Interest} #DIV/0!
No Inventory Holding level (days) 0
No Debtors (days) 0
No Creditors level (days) --
FACR #DIV/0!

Other Additional Information (Other Bifurcation if

Yes Required)
Yes 1) NCD
Yes 2) CP

Calculation of MPBF under Method (1 or 2)? 1

PBF as per MPBF Method 1
Audited
Year 2023
a) Total Current Assets [TCA] 0.00
b) (Minus) Current liabilities less Bank finance & Creditors u 0.00
c) Working Capital Gap {a - b} [WCG] 0.00

d) Total Current Liabilities 0.00

e) Export Receivables 0.00

Less: Margin: Higher of -

25% of (WCG excl Exp Rec) 0.00
Net Working Capital {a - d} 0.00
f) Margin 0.00

g) MAXIMUM PERMISSIBLE BANK FINANCE {c - f} 0.00

h) Bank Borrowing 0.00
i) Excess Borrowing 0.00

Working Capital Cycle

Item [Basis] 2023
a) Debtors [Gross Sales] 0
-- Domestic Receivables (incl > 6 months) --
-- Export Receivables --
-- Deferred Receivables --
b) Total Inventory 0
-- RM & Stores [RM & Stores Consumed] --
-- WIP [COP] --
-- Finished Goods [COGS] --
c) Advance to Suppliers [RM & Stores Consumed] --
d) Funding Requirement for --
e) Creditors & Buyer's Credit [RM & Stores Purchase Cost] --
f) Advance from Customers [Gross Sales] --
g) External Credit Available for 0
h) Net WC Cycle --

Year End Mar/23

Audited
No of Months 12
i) I. CURRENT ASSETS 0.00
Export receivables 0.00
II. CURRENT LIABILITIES (excl Bank borrowing) 0.00
III W Cap Gap (I - II) 0.00
III(a) W Cap Gap (I - II)-Excl export Rcvbl 0.00
25% of Working capital Gap - Excl Export Rcvbl 0.00
IV. Act./Proj Bank Bor. Incl. LC Creditors and Buyers
Credit 0.00
V. Total Cur Lia (II+IV) 0.00
VI. Act./Proj NWC 0.00
VII Mini.Stip.NWC 25 % of III(a) or I as applicable 0.00
VIII. Item III - Item VII 0.00
IX. Item III - Item VI 0.00
X. M P B F 0.00
XI. Excess Borr. if any. 0.00

Yes PBDIT/TA 0.00

Yes Paid up capital 0.00
Yes Deferred Tax Liability 0
Yes Unsecured Loan 0.00
No FACR 0.00
Audited Audited Estimated Projected

2024 2025 2026 2027

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 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 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 0.00
0.00 523935.00 546917.00 687132.00
0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00
0.00 523935.00 546917.00 687132.00
0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00
0.00 523935.00 546917.00 687132.00
0.00 197833.00 172677.00 150842.00
0.00 120140.00 140120.00 120150.00

0.00 631370.00 764370.00 931370.00

0.00 560250.00 680250.00 840120.00
0.00 0.00 0.00 0.00
0.00 71120.00 84120.00 91250.00
0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00
0.00 425408.00 530250.00 515230.00
0.00 25140.00 30250.00 15230.00
0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00
0.00 400268.00 500000.00 500000.00
0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00
0.00 205962.00 234120.00 416140.00
0.00 523935.00 546917.00 687132.00

0.00 0.00 0.00 0.00

0.00 2260250.00 2712300.00 3390375.00

0.00 0.00 0.00 0.00
0.00 2260250.00 2712300.00 3390375.00
0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00
0.00 2260250.00 2712300.00 3390375.00
0.00 0.00 0.00 0.00
0.00 2260250.00 2712300.00 3390375.00
0.00 1694848.00 1794734.00 2018245.00
0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00
0.00 36397.00 55000.00 55000.00
0.00 529005.00 862566.00 1317130.00
0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00
0.00 529005.00 862566.00 1317130.00
0.00 0.00 0.00 0.00
0.00 529005.00 862566.00 1317130.00
0.00 529005.00 862566.00 1317130.00
0.00 565402.00 917566.00 1372130.00
0.00 565402.00 917566.00 1372130.00
0.00 565402.00 917566.00 1372130.00
0.00 529005.00 862566.00 1317130.00

#DIV/0! 25.02% 33.83% 40.47%

#DIV/0! 23.40% 31.80% 38.85%
#DIV/0! 0.23 0.32 0.39
#DIV/0! 1.63 114.10% 0.87
#DIV/0! 107.91% 1.68 199.69%
#DIV/0! #DIV/0! #DIV/0! #DIV/0!
#DIV/0! 148.42% 144.15% 180.77%
#DIV/0! 2511.42% 2526.84% 6115.36%
#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!
0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00
#DIV/0! 15.53 16.68 24.95
0 121 138 152
0 19 19 13
-- 6 7 3
#DIV/0! 0.49 0.35 0.30

Lakhs
Audited Audited Estimated Projected
2024 2025 2026 2027
0.00 631370.00 764370.00 931370.00
0.00 425408.00 530250.00 515230.00
0.00 205962.00 234120.00 416140.00

0.00 425408.00 530250.00 515230.00

0.00 0.00 0.00 0.00

0.00 51490.50 58530.00 104035.00

0.00 205962.00 234120.00 416140.00
0.00 205962.00 234120.00 416140.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

Days
2024 2025 2026 2027
0 19 19 13
-- 19 19 13
-- -- -- --
-- 0 0 0
0 121 138 152
-- 0 0 0
-- 0 0 0
-- 121 138 152
-- 0 0 0
-- 140 157 165
-- 6 7 3
-- 0 0 0
0 6 7 3
-- 134 150 162

Mar/24 Mar/25 Mar/26 Mar/27

Audited Audited Estimated Projected
12 12 12 12
0.00 631370.00 764370.00 931370.00
0.00 0.00 0.00 0.00
0.00 425408.00 530250.00 515230.00
0.00 205962.00 234120.00 416140.00
0.00 205962.00 234120.00 416140.00
0.00 51490.50 58530.00 104035.00
0.00 0.00 0.00 0.00
0.00 425408.00 530250.00 515230.00
0.00 205962.00 234120.00 416140.00
0.00 51490.50 58530.00 104035.00
0.00 154471.50 175590.00 312105.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

0.00 0.60 0.85 1.14

0.00 0.00 0.00 0.00
0 0 0 0
0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00
Projected Projected

2028 2029
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 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
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 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
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 0.00
0.00 0.00

0.00 0.00
0.00 0.00

Projected Projected
2028 2029
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 0.00
0.00 0.00

2028 2029
0 0
-- --
-- --
-- --
0 0
-- --
-- --
-- --
-- --
-- --
-- --
-- --
0 0
-- --

Mar/28 Mar/29
Projected Projected
12 12
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 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
0.00 0.00

0.00 0.00
0.00 0.00
0 0
0.00 0.00
0.00 0.00
Lakhs

Cash Flow Analysis 1 2 3 4 5

Particulars Audited Audited Audited Projected Projected Projected Projected Projected
Year Ending 31.03… 3/31/2023 3/31/2024 3/31/2025 3/31/2027 3/31/2028 3/31/2029 3/31/2030 3/31/2031
Cash flow from Operating activities
PAT 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Less: All Appropriations
Add: Tax Provisions 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Subtotal 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Adjustment for:
Depreciation 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Intangibles w/o 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Profit / Loss on sale of F 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Interest & Finance Costs 0.00 36397.00 55000.00 0.00 0.00 0.00 0.00
Dividends proposed 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Net Non-Operating Inco 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Extraordinary Items 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Adjustment for Working Capital Changes:
Sundry Debtors 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Inventories 0.00 -560250.00 -279870.00 840120.00 0.00 0.00 0.00
Other Receivables, Loan 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Sundry Creditors 0.00 25140.00 -9910.00 -15230.00 0.00 0.00 0.00
Other Liabilities & Provi 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Operating cash flows befo 0.00 -498713.00 -234780.00 824890.00 0.00 0.00 0.00
Extraordinary Items 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Operating cash flows befo 0.00 -498713.00 -234780.00 824890.00 0.00 0.00 0.00
Taxes Paid 0.00 0.00 0.00 0.00 0.00 0.00 0.00
from Operating Activities 0.00 -498713.00 -234780.00 824890.00 0.00 0.00 0.00

Cash flow from Investing activities

Gross Block (incl Capital W 0.00 -197833.00 46991.00 150842.00 0.00 0.00 0.00
Investments 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Other LT Loans & Advance 0.00 -120140.00 -10.00 120150.00 0.00 0.00 0.00
Net Non-Operating Incom 0.00 0.00 0.00 0.00 0.00 0.00 0.00
from Investing Activities 0.00 -317973.00 46981.00 270992.00 0.00 0.00 0.00

Cash flow from Financing activities

Shareholders Funds 0.00 0.00 0.00 0.00 0.00 0.00 0.00
S/T Bank Borrowings 0.00 0.00 0.00 0.00 0.00 0.00 0.00
S/T Other Borrowings 0.00 0.00 0.00 0.00 0.00 0.00 0.00
L/T Other Borrowings 0.00 523935.00 163197.00 -687132.00 0.00 0.00 0.00
Term Loans (Banks & FI) 0.00 400268.00 0.00 -500000.00 0.00 0.00 0.00
Dividends Paid (incl tax th 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Interest & Finance Costs P 0.00 -36397.00 -55000.00 0.00 0.00 0.00 0.00
Others 0.00 0.00 0.00 0.00 0.00 0.00 0.00
from Financing Activities 0.00 887806.00 108197.00 ### 0.00 0.00 0.00

Net Cash Generated 0.00 71120.00 -79602.00 -91250.00 0.00 0.00 0.00
Opening Cash & Bank Bala 0.00 0.00 71120.00 91250.00 0.00 0.00 0.00
Closing Cash & Bank Balan 0.00 71120.00 -8482.00 0.00 0.00 0.00 0.00
Closing Cash & Bank Balanc 0.00 71120.00 91250.00 0.00 0.00 0.00 0.00
Difference 0.00 0.00 99732.00 0.00 0.00 0.00 0.00

Calculation of certain specific Cash Outflows

1.TAXES PAID
Opening Provision for Tax 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Opening Deferred Tax Liabi 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Less: Opening Advance Tax 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Net PFT 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Add: Current Year Tax 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Add: Current Year DTL 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Less: Closing Provision for 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Less: Closing Deferred Tax L 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Add: Closing Advance Taxe 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Taxes Paid during the year 0.00 0.00 0.00 0.00 0.00 0.00 0.00

2.DIVIDEND PAID
Opening Provision for Divi 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Add: Curr.Year Appro.for D 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Less:Closing Provision for 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Dividend Paid 0.00 0.00 0.00 0.00 0.00 0.00 0.00
6 7 8 9 10 11 12 13 14 15
Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected
3/31/2032 3/31/2033 3/31/2034 3/31/2035 3/31/2036 3/31/2037 3/31/2038 3/31/2039 3/31/2040 3/31/2041

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 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 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 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 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 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 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 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 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 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

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 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 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 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 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 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 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 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 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 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
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 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 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 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 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00

FUNDS FLOW STATEMENT

Year End 2023 2024

No. Of Months 12 12

Audited Audited
Lakhs Lakhs
SOURCES

Profit before tax 0.00

Add Depreciation 0.00
Gross Fund Generated 0.00
Less: Provision for tax 0.00
Less: Appropriations incl. Dividend paid/ payable 0.00
Net Funds Generated from operations 0.00
Add: Extraordinary Items 0.00
A - Net Funds Generated from operations (after adjustments) 0.00

Increase in
a. Capital 0.00
b. Reserves & Surplus (Revenue and Capital) 0.00
c. Long term borrowings, debentures etc. 0.00
d. Other term liabilities 0.00
Decrease in
a. Fixed assets 0.00
b. Investments, receivables, loans & advances 0.00
c. Other non current assets 0.00
B - Sub Total 0.00

Increase in Short term Bank borrowings 0.00

Increase in other current liabilities 0.00
Decrease in Inventory 0.00
Decrease in receivables 0.00
Decrease in other current assets 0.00
C - Sub Total 0.00
TOTAL FUND AVAILABLE (A+B+C) 0.00

USES

Increase in Fixed assets 0.00

Decrease in
a. Long term borrowings, debentures etc. 0.00
b. Capital 0.00
c. Reserves & Surplus (Revenue and Capital) 0.00
d. Other Term Liabilities. 0.00
Increase in Investments, receivables, loans & advances 0.00
Increase in other non current assets 0.00
D - sub Total 0.00
Decrease in Short term Bank borrowings 0.00
Decrease in other current liabilities 0.00
Increase in inventory 0.00
Increase in receivables 0.00
Increase in other current asset. 0.00
E - Sub Total 0.00

Loss 0.00
Less - Depreciation 0.00
Gross Fund Lost (-)/ Generated (+) 0.00
Add - Provision for tax 0.00
Add - Appropriations incl. Dividend paid/ payable 0.00
Less-extraordinary items 0.00
F - Sub Total 0.00
G - Net Fund Generated (if 'F' is - ve) 0.00
H - Net Fund Lost (if F is + ve) 0.00

TOTAL FUNDS USED (D+F+G) 0.00

SUMMARY

Long Term Sources (A+B+G) 0.00

Less - Long Term uses (D+H) 0.00
Surplus (+) / Short Fall (-) 0.00

Short Term Sources ( C ) 0.00

Less - Short Term uses (E) 0.00
Surplus (+) / Short fall (-) 0.00
Gap in Funds Flow 0.00
1 2
2025 2026 2027 2028
12 12 12 12

Audited Estimated Projected Projected

Lakhs Lakhs Lakhs Lakhs

529005.00 862566.00 1317130.00 0.00

0.00 0.00 0.00 0.00
529005.00 862566.00 1317130.00 0.00
0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00
529005.00 862566.00 1317130.00 0.00
0.00 0.00 0.00 0.00
529005.00 862566.00 1317130.00 0.00

0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00
924203.00 1046917.00 262929.00 0.00
0.00 0.00 0.00 0.00

0.00 0.00 46991.00 150842.00

0.00 0.00 0.00 120150.00
0.00 0.00 0.00 0.00
924203.00 1046917.00 309920.00 270992.00

0.00 0.00 0.00 0.00

25140.00 30250.00 0.00 0.00
0.00 0.00 0.00 840120.00
0.00 0.00 0.00 0.00
0.00 0.00 0.00 91250.00
25140.00 30250.00 0.00 931370.00
1478348.00 1939733.00 1627050.00 1202362.00

197833.00 172677.00 0.00 0.00

.
0.00 0.00 0.00 1187132.00
0.00 0.00 0.00 0.00
529005.00 862566.00 1317130.00 0.00
0.00 0.00 0.00 0.00
120140.00 140120.00 10.00 0.00
0.00 0.00 0.00 0.00
846978.00 1175363.00 1317140.00 1187132.00
0.00 0.00 0.00 0.00
0.00 0.00 9910.00 15230.00
560250.00 680250.00 279870.00 0.00
0.00 0.00 0.00 0.00
71120.00 84120.00 20130.00 0.00
631370.00 764370.00 309910.00 15230.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
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 0.00 0.00 0.00
0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00

1478348.00 1939733.00 1627050.00 1202362.00

Projected
Lakhs

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
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
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
0.00
0.00
0.00

0.00

0.00
0.00
0.00

0.00
0.00
0.00
0.00
BREAK EVEN POINT CALCULATION Variable
Direct Labour & Wages 75%
S&A 25%

2023 2024
Yr.End.(DD-MMM-YY) 31/Mar/23 31/Mar/24
No. Of Months 12 12
Audited Audited

1) Net Sales including operating income 0.00 0.00

Changes in Inventory 0.00 0.00
2) Sale Value of Production 0.00 0.00

3) Variable Costs:-
a) Material, Power, Mfg exp etc 0.00 0.00
b) Direct Labour & Wages @ 75% 0.00 0.00
c) Selling & Administrative Exp @ 25% 0.00 0.00
d) Int on WC 0.00 0.00
Total Variable Costs 0.00 0.00

4) Contribution [2 - 3] 0.00 0.00

5) PV Ratio [4 ÷ 1] 0.00 0.00
6) Fixed Costs:-
a) Direct Labour & Wages @ 25% 0.00 0.00
b) Selling & Administrative Exp @ 75% 0.00 0.00
c) Int on TL & others 0.00 0.00
d) Depreciation 0.00 0.00
Total Fixed Costs 0.00 0.00

Operating Profit 0.00 0.00

7) Break Even Sales [6 ÷ 5] #DIV/0! #DIV/0!

8) BE Sales / Net Sales [7 ÷ 1 x 100%] #DIV/0! #DIV/0!
9) Margin of Safety [1 - 7] #DIV/0! #DIV/0!
10) Margin of Safety % [9 ÷ 1 x 100%] #DIV/0! #DIV/0!

Cash Break Even Calculation

11) Cash Fixed Costs 0.00 0.00
12) Cash Break Even Sales [11 ÷ 5] #DIV/0! #DIV/0!
13) Cash BE Sales / Net Sales [12 ÷ 1 x 100%] #DIV/0! #DIV/0!
Fixed
25%
75%
1 2
2025 2026 2027 2028
31/Mar/25 31/Mar/26 31/Mar/27 31/Mar/28
12 12 12 12
Audited Estimated Projected Projected

2260250.00 2712300.00 3390375.00 0.00

35110.00 120000.00 159870.00 0.00
2295360.00 2832300.00 3550245.00 0.00

1519958.00 1674734.00 1908115.00 0.00

157500.00 180000.00 202500.00 0.00
0.00 0.00 0.00 0.00
36397.00 55000.00 55000.00 0.00
1713855.00 1909734.00 2165615.00 0.00

581505.00 922566.00 1384630.00 0.00

0.26 0.34 0.41 0.00

52500.00 60000.00 67500.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 0.00
52500.00 60000.00 67500.00 0.00

529005.00 862566.00 1317130.00 0.00

#DIV/0! #DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0! #DIV/0!

0.00 0.00 0.00 0.00

#DIV/0! #DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0! #DIV/0!
7 8 9 10
2033 2034 2035 2036
31/Mar/33 31/Mar/34 31/Mar/35 31/Mar/36
12 12 12 12
Projected Projected Projected Projected

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 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 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 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

0.00 0.00 0.00 0.00

#DIV/0! #DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0! #DIV/0!

0.00 0.00 0.00 0.00

#DIV/0! #DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0! #DIV/0!
15
2041
31/Mar/41
12
Projected

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
0.00
0.00

Cash Flow DSCR 0.00

Additional data -
Calculation of Purchases 0.00

Closing Stock - RM & other Stores 0.00

Add - Material & Spares Consumed 0.00
Less - Opening Stock - RM & other Stores 0.00
Name of the Company OM HOTEL AND SWEET HOME

Project Debt Equity Ratio

1
DSCR Computation BASE CASE
Year end 31/Mar/26 31/Mar/27
No. Of Months for which PAT to be considered 12 12
Estimated Projected
Lakhs Lakhs
Net profit after tax 862566.00 1317130.00
Add - Depreciation 0.00 0.00
Add - Non cash expenses (net) 0.00 0.00
Add - Interest on Term Loans 0.00 0.00
Total Fund Available 862566.00 1317130.00
Term Loan instalments 0.00 500000.00
Add - Interest on Term Loans 0.00 0.00
Total Repayment obligation 0.00 500000.00

DSCR 0.00 2.63

Average DSCR #DIV/0! 4.36
Minimum DSCR 0.00
DSCR If Projected Sales Price reduces by
10%
Year end 31/Mar/26 31/Mar/27
No. Of Months 12 12
Estimated Projected
Lakhs Lakhs
Profit Before Tax 591336.00 978092.50
Less - Revised Tax 0.00 0.00
Add - Extraordinary items (Post tax) 0.00 0.00
Net profit after tax 591336.00 978092.50
Add - Depreciation 0.00 0.00
Add - Non cash expenses (net) 0.00 0.00
Add - Interest on Term Loans 0.00 0.00
Total Fund Available 591336.00 978092.50
Term Loan instalments 0.00 500000.00
Add - Interest on Term Loans 0.00 0.00
Total Repayment obligation 0.00 500000.00

DSCR 0.00 1.96

Average DSCR #DIV/0! 3.14
Minimum DSCR 0.00
DSCR If Projected Raw Material Cost increases by
10%
Year end 31/Mar/26 31/Mar/27
No. Of Months 12 12
Estimated Projected
Lakhs Lakhs
Profit Before Tax 703419.60 1135178.50
Less - Revised Tax 0.00 0.00
Add - Extraordinary items (Post tax) 0.00 0.00
Net profit after tax 703419.60 1135178.50
Add - Depreciation 0.00 0.00
Add - Non cash expenses (net) 0.00 0.00
Add - Interest on Term Loans 0.00 0.00
Total Fund Available 703419.60 1135178.50
Term Loan instalments 0.00 500000.00
Add - Interest on Term Loans 0.00 0.00
Total Repayment obligation 0.00 500000.00

DSCR 0.00 2.27

Average DSCR #DIV/0! 3.68
Minimum DSCR 0.00
ND SWEET HOME For DSCR Calculation: Please update the cell reference in "F184" of the BS Sheet and the "Num

2 3 4 5

31/Mar/28 31/Mar/29 31/Mar/30 31/Mar/31

12 12 12 12
Projected Projected Projected Projected
Lakhs Lakhs Lakhs Lakhs
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 0.00 0.00 0.00
0.00 0.00 0.00 0.00
500000.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00
500000.00 0.00 0.00 0.00

#DIV/0! #DIV/0! #DIV/0! #DIV/0!

31/Mar/36 31/Mar/37 31/Mar/38 31/Mar/39

12 12 12 12
Projected Projected Projected Projected
Lakhs Lakhs Lakhs Lakhs
0.00 0.00 0.00 0.00
#DIV/0! #DIV/0! #DIV/0! #DIV/0!
0.00 0.00 0.00 0.00
#DIV/0! #DIV/0! #DIV/0! #DIV/0!
0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00
#DIV/0! #DIV/0! #DIV/0! #DIV/0!
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 0.00 0.00 0.00

#DIV/0! #DIV/0! #DIV/0! #DIV/0!

31/Mar/36 31/Mar/37 31/Mar/38 31/Mar/39

12 12 12 12
Projected Projected Projected Projected
Lakhs Lakhs Lakhs Lakhs
0.00 0.00 0.00 0.00
#DIV/0! #DIV/0! #DIV/0! #DIV/0!
0.00 0.00 0.00 0.00
#DIV/0! #DIV/0! #DIV/0! #DIV/0!
0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00
#DIV/0! #DIV/0! #DIV/0! #DIV/0!
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 0.00 0.00 0.00

#DIV/0! #DIV/0! #DIV/0! #DIV/0!
14 15

31/Mar/40 31/Mar/41
12 12
Projected Projected
Lakhs Lakhs
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 0.00
0.00 0.00

0.00 0.00
#DIV/0! #DIV/0!

31/Mar/40 31/Mar/41
12 12
Projected Projected
Lakhs Lakhs
0.00 0.00
#DIV/0! #DIV/0!
0.00 0.00
#DIV/0! #DIV/0!
0.00 0.00
0.00 0.00
0.00 0.00
#DIV/0! #DIV/0!
0.00 0.00
0.00 0.00
0.00 0.00

0.00 0.00
#DIV/0! #DIV/0!

31/Mar/40 31/Mar/41
12 12
Projected Projected
Lakhs Lakhs
0.00 0.00
#DIV/0! #DIV/0!
0.00 0.00
#DIV/0! #DIV/0!
0.00 0.00
0.00 0.00
0.00 0.00
#DIV/0! #DIV/0!
0.00 0.00
0.00 0.00
0.00 0.00

0.00 0.00
#DIV/0! #DIV/0!
Method (1 or 2) 1 or 2 1

Name of the Company OM HOTEL AND SWEET HOME

Year End Mar/23 Mar/24 Mar/25

Audited Audited Audited

No. Of Months 12 12 12
Sales 0.00 0.00 2260250.00
Cost of sales 0.00 0.00 1694848.00
CURRENT ASSETS
Raw Material - Imported 0.00 0.00 0.00
Raw Material - Indigenous 0.00 0.00 0.00
Work in process 0.00 0.00 0.00
Finished Goods 0.00 0.00 560250.00
Stores and spares 0.00 0.00 0.00
Domestic Receivables 0.00 0.00 0.00
Export Receivables 0.00 0.00 0.00
Defferd Recivable 0.00 0.00 0.00
Advances to suppliers 0.00 0.00 0.00
Cash & Cash equivalent 0.00 0.00 71120.00
Other current Assets 0.00 0.00 0.00
I. - TOTAL 0.00 0.00 631370.00
CURRENT LIABILITIES
Sundry Creditors (Trade& Exp) 0.00 0.00 25140.00
Advances from customers 0.00 0.00 0.00
TL inst-due in 1 yr 0.00 0.00 400268.00
Other Cur Lia & Prov 0.00 0.00 0.00
Statu Lia (due in 1 yr) 0.00 0.00 0.00
Other short term borrowing 0.00 0.00 0.00
II. - TOTAL 0.00 0.00 425408.00
III W Cap Gap (I - II) 0.00 0.00 205962.00

IV. Act./Proj Bank Bor. Incl. LC

Creditors and Buyers Credit 0.00 0.00 0.00

V. Total Cur Lia (II+IV) 0.00 0.00 425408.00

VI. Act./Proj NWC 0.00 0.00 205962.00
VII Mini.Stip.NWC 25 % of III or
I as applicable 0.00 0.00 51490.50
VIII. Item III - Item VII 0.00 0.00 154471.50
IX. Item III - Item VI 0.00 0.00 0.00
X. M P B F 0.00 0.00 0.00
XI. Excess Borr. if any. 0.00 0.00 0.00

% of other Current asst to total

current assets 0.00% 0.00% 0.00%

% of other Current asst to Net

Sales 0.00% 0.00% 0.00%

% of other current lia. to total

current lia. 0.00% 0.00% 0.00%
Name of the Company OM HOTEL AND SWEET HOME
Year End Mar/23 Mar/24 Mar/25

Audited Audited Audited

No. Of Months 12 12 12
% of other current lia. to cost of
sales 0.00% 0.00% 0.00%
Method (1 or 2)

Name of the Company 1 2

Year End Mar/26 Mar/27 Mar/28

Estimated Projected Projected

No. Of Months 12 12 12
Sales 2712300.00 3390375.00 0.00
Cost of sales 1794734.00 2018245.00 0.00
CURRENT ASSETS
Raw Material - Imported 0.00 0.00 0.00
Raw Material - Indigenous 0.00 0.00 0.00
Work in process 0.00 0.00 0.00
Finished Goods 680250.00 840120.00 0.00
Stores and spares 0.00 0.00 0.00
Domestic Receivables 0.00 0.00 0.00
Export Receivables 0.00 0.00 0.00
Defferd Recivable 0.00 0.00 0.00
Advances to suppliers 0.00 0.00 0.00
Cash & Cash equivalent 84120.00 91250.00 0.00
Other current Assets 0.00 0.00 0.00
I. - TOTAL 764370.00 931370.00 0.00
CURRENT LIABILITIES
Sundry Creditors (Trade& Exp) 30250.00 15230.00 0.00
Advances from customers 0.00 0.00 0.00
TL inst-due in 1 yr 500000.00 500000.00 0.00
Other Cur Lia & Prov 0.00 0.00 0.00
Statu Lia (due in 1 yr) 0.00 0.00 0.00
Other short term borrowing 0.00 0.00 0.00
II. - TOTAL 530250.00 515230.00 0.00
III W Cap Gap (I - II) 234120.00 416140.00 0.00

IV. Act./Proj Bank Bor. Incl. LC

Creditors and Buyers Credit 0.00 0.00 0.00

V. Total Cur Lia (II+IV) 530250.00 515230.00 0.00

VI. Act./Proj NWC 234120.00 416140.00 0.00
VII Mini.Stip.NWC 25 % of III or
I as applicable 58530.00 104035.00 0.00
VIII. Item III - Item VII 175590.00 312105.00 0.00
IX. Item III - Item VI 0.00 0.00 0.00
X. M P B F 0.00 0.00 0.00
XI. Excess Borr. if any. 0.00 0.00 0.00

% of other Current asst to total

current assets 0.00% 0.00% 0.00%

% of other Current asst to Net

Sales 0.00% 0.00% 0.00%

% of other current lia. to total

current lia. 0.00% 0.00% 0.00%
Name of the Company 1 2
Year End Mar/26 Mar/27 Mar/28

Estimated Projected Projected

No. Of Months 12 12 12
% of other current lia. to cost of
sales 0.00% 0.00% 0.00%
Method (1 or 2)

Name of the Company 3 4 5

Year End Mar/29 Mar/30 Mar/31

Projected Projected Projected

No. Of Months 12 12 12
Sales 0.00 0.00 0.00
Cost of sales 0.00 0.00 0.00
CURRENT ASSETS
Raw Material - Imported 0.00 0.00 0.00
Raw Material - Indigenous 0.00 0.00 0.00
Work in process 0.00 0.00 0.00
Finished Goods 0.00 0.00 0.00
Stores and spares 0.00 0.00 0.00
Domestic Receivables 0.00 0.00 0.00
Export Receivables 0.00 0.00 0.00
Defferd Recivable 0.00 0.00 0.00
Advances to suppliers 0.00 0.00 0.00
Cash & Cash equivalent 0.00 0.00 0.00
Other current Assets 0.00 0.00 0.00
I. - TOTAL 0.00 0.00 0.00
CURRENT LIABILITIES
Sundry Creditors (Trade& Exp) 0.00 0.00 0.00
Advances from customers 0.00 0.00 0.00
TL inst-due in 1 yr 0.00 0.00 0.00
Other Cur Lia & Prov 0.00 0.00 0.00
Statu Lia (due in 1 yr) 0.00 0.00 0.00
Other short term borrowing 0.00 0.00 0.00
II. - TOTAL 0.00 0.00 0.00
III W Cap Gap (I - II) 0.00 0.00 0.00

IV. Act./Proj Bank Bor. Incl. LC

Creditors and Buyers Credit 0.00 0.00 0.00

V. Total Cur Lia (II+IV) 0.00 0.00 0.00

V. Total Cur Lia (II+IV) 0.00 0.00 0.00

% of other Current asst to total

current assets 0.00% 0.00% 0.00%

% of other Current asst to Net

Sales 0.00% 0.00% 0.00%

% of other current lia. to total

current lia. 0.00% 0.00% 0.00%
Name of the Company 12 13 14
Year End Mar/38 Mar/39 Mar/40

Projected Projected Projected

No. Of Months 12 12 12
% of other current lia. to cost of
sales 0.00% 0.00% 0.00%
Method (1 or 2)

Name of the Company 15

Year End Mar/41

Projected

No. Of Months 12
Sales 0.00
Cost of sales 0.00
CURRENT ASSETS
Raw Material - Imported 0.00
Raw Material - Indigenous 0.00
Work in process 0.00
Finished Goods 0.00
Stores and spares 0.00
Domestic Receivables 0.00
Export Receivables 0.00
Defferd Recivable 0.00
Advances to suppliers 0.00
Cash & Cash equivalent 0.00
Other current Assets 0.00
I. - TOTAL 0.00
CURRENT LIABILITIES
Sundry Creditors (Trade& Exp) 0.00
Advances from customers 0.00
TL inst-due in 1 yr 0.00
Other Cur Lia & Prov 0.00
Statu Lia (due in 1 yr) 0.00
Other short term borrowing 0.00
II. - TOTAL 0.00
III W Cap Gap (I - II) 0.00

IV. Act./Proj Bank Bor. Incl. LC

Creditors and Buyers Credit 0.00

V. Total Cur Lia (II+IV) 0.00

VI. Act./Proj NWC 0.00
VII Mini.Stip.NWC 25 % of III or
I as applicable 0.00
VIII. Item III - Item VII 0.00
IX. Item III - Item VI 0.00
X. M P B F 0.00
XI. Excess Borr. if any. 0.00

% of other Current asst to total

current assets 0.00%

% of other Current asst to Net

Sales 0.00%

% of other current lia. to total

current lia. 0.00%
Name of the Company 15
Year End Mar/41

Projected

No. Of Months 12
% of other current lia. to cost of
sales 0.00%
1
2
3
4
5
6 Last year of audited / provisional results 2025
7 Company Code
8 Name of the Company OM HOTEL AND SWEET HOME
9 Industry (as per ASCROM classification) Retail Trade
10 Currency INR
11 Auditors 0
12 2023
13 Year ended (DD-Mon-YYYY) 31-Mar-23
14 No. Of Months 12
15 Exchange Rate 1
16 Audited
17
18 Gross Sales
19 - Domestic 0.00
20 - Export 0.00
21 Sub Total (Gross Sales) 0.00
22
23 Less Excise Duty 0.00
24
25 Net Sales 0.00
26
% wise rise/fall in net sales as compared to
27 previous year 0%
28
29 Other Operating Income
30 Export Incentives 0.00
31 Duty Drawback 0.00
32 Others 0.00
33 Total Operating Income 0.00
34
35 Cost of Sales
36 Raw materials consumed
37 i) Imported 0.00
38 ii) Indigenous 0.00
39
40 Other Spares consumed
41 i) Imported 0.00
42 ii) Indigenous 0.00
43
44 Power and fuel 0.00
45 Labour and wages 0.00
46 Other manufacturing expenses 0.00
47 Depreciation 0.00
48 Sub Total 0.00
49
50 Add: Op. Stock of WIP 0.00
51 Less: Cl. Stock of WIP 0.00
52 Total Cost of Production 0.00
53
54 Add Opening Stock of Finished Goods 0.00
55 Less: Cl. Stock of Finished Goods 0.00
56 Total Cost of goods sold 0.00
57
58 Selling, Gen. & Administration Exp 0.00
59
60 Cost of Sales 0.00
61
62 Operating Profit before Interest 0.00
63
64 Interest payment to Banks & FIs
65 Interest - WC 0.00
66 Interest - Term Loans 0.00
67 Interest payment to USL & Others
68 Interest - USL 0.00
69 Interest - other Borrowing cost (incl. finance char 0.00
70 Total Interest 0.00
71
72 Operating Profit after Interest 0.00
73
74 Non Operating Items
75
76 Add Non Operating Income
77 Profit on sale of assets/ investments 0.00
78 Investments and Dividend 0.00
79 Forex gains 0.00
80 Non-op. income from subsidiaries 0.00
81 Tax Refund 0.00
82 Other Non Operating Income 0.00
83 Total non-operating Income 0.00
84
85 Deduct Non Operating Expenses
86 Loss on sale of assets 0.00
87 Prem. Expenses w/off 0.00
88 Other Non- operating exp. 0.00
89 Total Non-operating expenses 0.00
90
91 Net of Non-operating Income / Expenses 0.00
92
Profit Before Interest Depreciation & Taxes
93 (PBIDT) 0.00
94
95 Profit Before tax 0.00
96
97 Provision for taxation:
98 Current 0.00
99 Deferred 0.00
100 Sub Total: Provision for taxation 0.00
101
102 Net Profit After tax 0.00
103
104 Extraordinary Items adjustments:
105 Extraordinary Income adjustments (+) 0.00
106 Extraordinary Expenses adjustments (-) 0.00
107 SubTotal Extraordinary items 0.00
108
109 Adjusted PAT (excl Extraordinary Items) 0.00
110
111 Cash Appropriation from Profit
112 Dividend 0.00
113 Dividend Tax 0.00
114 Other Cash Appropriation 0.00
115 Partners' withdrawal 0.00
116 Dividend (%) 0.00%
117 Retained Profit 0.00
118
119 Cash Accruals 0.00
120
121
122
123 CURRENT LIABILITIES
124
Short term borrowings from Banks (including
bills payable, discounted & excess borrowings
125 placed on repayment basis)
126 Bank Borrowings - From our Bank 0.00
127 Bank Borrowings - From other Banks & FI 0.00
128 Sub Total 0.00
129
Short term borrowings from Associates &
130 Group Concerns 0.00
131
132 Short term borrowings from Others 0.00
133
134 Creditors for purchases & Expenses 0.00
135
Advances/ payments from customers/deposits
136 from dealers. 0.00
137
138 Provisions
139 - Tax 0.00
140 -Others 0.00
141
142 Dividends Payable 0.00
143
144 Statutory liabilities due within one year 0.00
145
Installments of Term Loans / Deferred payment
credits / Debentures / deposits / redeemable
preference shares (due within one year) - To
146 Banks 0.00
147
148 Deposits 0.00
149
150 Other Current Liabilities due within one year 0.00
151
152 Total Current Liabilities 0.00
153
154 TERM LIABILITIES
155
156 Debentures 0.00
157 Preference Share Capital (Residual Periods < 12 y 0.00
158 Long Term Deposit 0.00
159 Deferred Tax Liability 0.00
160 Term Loans - From Banks 0.00
161 Term Loans - From FIs 0.00
Borrowings from subsidiaries / affiliates (Not
162 treated as quasi equity) 0.00
Borrowings from subsidiaries / affiliates (Quasi
163 Equity) 0.00
Other Long Term Borrowings (Not Classified
164 above) [Secured + Unsecured] 0.00
165 Other terms liabilities 0.00
166 Total Term Liabilities 0.00
167
168 TOTAL OUTSIDE LIABILITIES 0.00
169
170 NET WORTH
171 Share Capital
172 Equity Share Capital (Paid-up) 0.00
173 Preference Share Capital (paid up) (Residual Peri 0.00
174 Sub Total (Share Capital) 0.00
175
176 General Reserve 0.00
177 Revaluation Reserve 0.00
178 Share Application Money (Finalized for allotment) 0.00
179
180 Other Reserves & Surplus:
181 Share Premium 0.00
182 Capital subsidy 0.00
183 Others 0.00
184 Balance in P&L Account (+ / - ) 0.00
185
186 NET WORTH 0.00
187
188 TOTAL LIABILITIES 0.00
189
190
191
192 CURRENT ASSETS
193
194 Cash & Bank Balances 0.00
195
196 Investments
197 Govt. and other trustee Securities, Fixed Deposits 0.00
198 Fixed Deposits with Banks
199 Others
200
201 Receivables
202 Receivables Other than Deferred & exports (Dome 0.00
203 Export Receivables 0.00
204 Note :
205 1. All receivable upto 180 days only to be included.
206 2. Sale bills negotiated under LC to be excluded.
207
208 Deferred receivable (due within one year.) 0.00
209
210 Inventory
211 Raw Materials - Imported 0.00
212 Raw Materials - Indigenous 0.00
213 Work in process 0.00
214 Finished Goods (incl Traded Goods) 0.00
215 Other consumable spares - Imported 0.00
216 Other consumable spares - Indigenous 0.00
217 Sub total (Inventory) 0.00
218
219 Advances to suppliers 0.00
220
221 Advance payment of tax 0.00
222
223 Other Current Assets 0.00
224
225 TOTAL CURRENT ASSETS 0.00
226
227 FIXED ASSETS
228 Gross Block 0.00
229 Less: Accumulated Depreciation 0.00
230 Net Block 0.00
231
232 Capital Work in progress 0.00
233
234 NON-CURRENT ASSETS
235
Investments / Book Debts / Advances /
236 Deposits (which are not current assets):
237 Investments in Group concerns 0.00
238 Loans to group concerns / Advances to subsidiari 0.00
239 Investments in others 0.00
Advances to suppliers of capital goods and
240 contractors 0.00
241 Deferred receivables (maturity exceeding one yea 0.00
242 Debtors > 6 mths. 0.00
Others (Loans & Advances non current in nature
243 etc.) 0.00
244
245 Deferred Tax Asset 0.00
246
Other Non-current Assets
247 (incld. Dues from directors, ICDs) 0.00
248
249 TOTAL NON CURRENT ASSETS 0.00
250

251 0.00
Accumulated Losses,Preliminary
expenses,Miscellaneous expenditure not w/off,
252 Other deferred revenue expenses 0.00
253
254 TOTAL ASSETS 0.00
255
256 ADJUSTED TANGIBLE NETWORTH (Including Qua 0.00
257
258
259 DIFFERENCE IN B/S 0.00
260 Capital Employed (Ecl. FIOB) 0.00
261 Net working capital 0.00
262 Current Ratio (Considering TL installments due with 0.00
263 TOL / ATNW (treating quasi equity as part of TNW) 0.00
264
265 ADDITIONAL INFORMATION
266 Arrears of depreciation 0.00
267
268 Contingent liabilities
269 Arrears of cumulative dividends 0.00
270 Guarantees issued (relating to business) 0.00
271 Guarantees issued (for group companies) 0.00
272 Gratuity Liability not provided for 0.00
273 Disputed excise / customs / tax Liabilities 0.00
274 LCs 0.00

275 0.00
276 Repayments due within one year 0.00
277 Preference Share Capital (due in less than a year) 0.00
LCM INPUT

BASIC INFORMATION

OME

2024 2025
31-Mar-24 31-Mar-25
12 12
1 1
Audited Audited
PROFIT & LOSS ACCOUNT INPUT

0.00 2260250.00
0.00 0.00
0.00 2260250.00

0.00 0.00

0.00 2260250.00

0% 0%

0.00 0.00
0.00 0.00
0.00 0.00
0.00 2260250.00

0.00 0.00
0.00 1442123.00

0.00 0.00
0.00 0.00

0.00 34155.00
0.00 210000.00
0.00 43680.00
0.00 0.00
0.00 1729958.00

0.00 0.00
0.00 560250.00
0.00 1169708.00
0.00 525140.00
0.00 0.00
0.00 1694848.00

0.00 0.00

0.00 1694848.00

0.00 565402.00

0.00 36397.00
0.00 0.00

0.00 0.00
0.00 0.00
0.00 36397.00

0.00 529005.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
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 565402.00

0.00 529005.00

0.00 0.00
0.00 0.00
0.00 0.00

0.00 529005.00
0.00 0.00
0.00 0.00
0.00 0.00

0.00 529005.00

0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00% 0.00%
0.00 529005.00

0.00 529005.00

BALANCE SHEET (LIABILITIES ) INPUT

0.00 0.00
0.00 0.00
0.00 0.00

0.00 0.00

0.00 25140.00

0.00 0.00

0.00 0.00
0.00 0.00

0.00 0.00

0.00 400268.00

0.00 0.00

0.00 0.00
0.00 425408.00

0.00 0.00
0.00 523935.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
0.00 0.00
0.00 523935.00

0.00 949343.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
0.00 0.00

0.00 0.00

0.00 949343.00

BALANCE SHEET (ASSETS) INPUT

0.00 71120.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
0.00 0.00
0.00 560250.00
0.00 0.00
0.00 0.00
0.00 560250.00

0.00 0.00

0.00 631370.00

0.00 197833.00
0.00 0.00
0.00 197833.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
0.00 120140.00

0.00 0.00

0.00 120140.00
0.00 0.00

0.00 0.00

0.00 949343.00

0.00 0.00

0.00 0.00
0.00 924203.00
0.00 205962.00
0.00 1.48
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 0.00
0.00 0.00

0.00 0.00
0.00 0.00
0.00 0.00
Value in Lacs

2026 2027
31/Mar/26 31-Mar-27
12 12
1 1
Estimated Projected
PUT

2712300.00 3390375.00
0.00 0.00
2712300.00 3390375.00

0.00 0.00

2712300.00 3390375.00

20% 25%

0.00 0.00
0.00 0.00
0.00 0.00
2712300.00 3390375.00

0.00 0.00
1591464.00 1819515.00

0.00 0.00
0.00 0.00

36150.00 38500.00
240000.00 270000.00
47120.00 50100.00
0.00 0.00
1914734.00 2178115.00

0.00 0.00
680250.00 840120.00
1234484.00 1337995.00
560250.00 680250.00
0.00 0.00
1794734.00 2018245.00

0.00 0.00

1794734.00 2018245.00

917566.00 1372130.00

55000.00 55000.00
0.00 0.00

0.00 0.00
0.00 0.00
55000.00 55000.00

862566.00 1317130.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
0.00 0.00

0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00

0.00 0.00

917566.00 1372130.00

862566.00 1317130.00

0.00 0.00
0.00 0.00
0.00 0.00

862566.00 1317130.00
0.00 0.00
0.00 0.00
0.00 0.00

862566.00 1317130.00

0.00 0.00
0.00 0.00
0.00 0.00
1.00 0.00
0.00% 0.00%
862565.00 1317130.00

862566.00 1317130.00

INPUT

0.00 0.00
0.00 0.00
0.00 0.00

0.00 0.00

30250.00 15230.00

0.00 0.00

0.00 0.00
0.00 0.00

0.00 0.00

500000.00 500000.00

0.00 0.00

0.00 0.00
530250.00 515230.00

0.00 0.00
546917.00 687132.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
0.00 0.00
546917.00 687132.00

1077167.00 1202362.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
0.00 0.00

0.00 0.00

1077167.00 1202362.00

NPUT

84120.00 91250.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
0.00 0.00
680250.00 840120.00
0.00 0.00
0.00 0.00
680250.00 840120.00

0.00 0.00

764370.00 931370.00

172677.00 150842.00
0.00 0.00
172677.00 150842.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
140120.00 120150.00

0.00 0.00

140120.00 120150.00
0.00 0.00

0.00 0.00

1077167.00 1202362.00

0.00 0.00

0.00 0.00
1046917.00 1187132.00
234120.00 416140.00
1.44 1.81
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 0.00
0.00 0.00

0.00 0.00
0.00 0.00
0.00 0.00
Value in Lacs

2028
31-Mar-28
12
1
Projected

0.00
0.00
0.00

0.00

-100%

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
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
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

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
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
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

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

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
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
Particulars Audited Audited

Balance Sheet Data/Capital Structure 2023 2024

Net Revenue / Sales 0.00 0.00
NPAT 0.00 0.00
TNW 0.00 0.00
Operating Cash Profit 0.00 0.00
EBITDA 0.00 0.00
Debt (O/S) 0.00 0.00
-Long Term 0.00 0.00
- Short Term 0.00 0.00
Total Debt/EBITDA #N/A #N/A
Interest Coverage ratio #N/A #N/A
Leverage (TOL/ATNW) #N/A #N/A
Current Ratio #N/A #N/A
Contingent Liabilities & Commitments 0.00 0.00
Capital Commitment 0.00 0.00
Unhedged Forex 0.00 0.00
Audited Estimated Projected

2025 2026 2027

2260250.00 2712300.00 3390375.00
529005.00 862566.00 1317130.00
0.00 0.00 0.00
565402.00 917566.00 1372130.00
565402.00 917566.00 1372130.00
924203.00 1046917.00 1187132.00
523935.00 546917.00 687132.00
400268.00 500000.00 500000.00
#N/A #N/A #N/A
#N/A #N/A #N/A
#N/A #N/A #N/A
#N/A #N/A #N/A
0.00 0.00 0.00
0.00 0.00 0.00
0.00 0.00 0.00
Projected

2028
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
#N/A
#N/A
#N/A
#N/A
0.00
0.00
0.00
1
2 LCM - Project Input
3
4 BASIC INFORMATION
5 Please Enter Data In Blue Coloured
6 Base Year of the Project (YYYY) 2023
7 Company Code
8 Name of the Company OM HOTEL AND SWEET HOME
9 Industry (as per ASCROM classification) 0
10 BREAKEVEN SALES YEAR (YYYY)
11 Years 2023
12
13 Stress Testing for DSCR
% by which the cash revenues are shocked
14 downwards 10.00%
15
16
17 Gearing:
18
Total Debt required for the entire Project (from start
19 to end)
Total Equity required for the entire Project (from
20 start to end)
21 Total Project Cost 0.000
22 Gearing Worst Case
23
24 CASH FLOWS
25 Incremental Equity (Optional)
26 Incremental Debt (Optional)
Incremental investment in Fixed Assets/ Capital
27 Investments (cash investments)
28 Gross Fixed Assets 0.00
29 Depreciation charged for the year
30 Accumalated Depreciation 0.00
31 Net fixed Assets 0.00
32
33 Net Working Capital
34
35 Net Fixed Assets + Net Working Capital 0.00
36
37
38 Sales / Revenue from the project
Expenses incurred due to the functioning of the
project other than capital expenditure, depreciation
39 and interest
All Non cash revenue such as profit on sale of fixed
assets, appreciation in the value of assets, forex
40 gains etc.
All Non Cash expenses including loss on sale of
41 fixed assets but excluding depreciation
42 Depreciation 0.00
43 Interest and finance charges
44 Profit before tax 0.00
Profit Before Tax if Revenues are shocked
45 downwards 0.00
46
47 Tax
48 PAT 0.00
49 PAT if Revenues are shocked downwards 0.00
50
51
52 Cash generated from sale of fixed assets
53
54 Fixed Cost
55 Variable Cost
56
Enter year from which the cash flows stabalize and
are presumed to be the same in every period after
57 this year (YYYY)
58
59
60 Discounting Rate based on Project Risk
61
62 Debt Schedule
63
Starting year of the loan sanctioned/ to be
64 sanctioned by our bank (YYYY)
Ending year of the loan santioned/ to be
65 sanctioned by our bank (YYYY)
66
67
Total Debt payable within one year (Principal
68 component)
69 Total Interest & Finance Charges 0.00
Total Debt payable within one year including
70 Interest & Finance Charges 0.000

0.000 0.000 0.000

0.00 0.00 0.00

2033 2034 2035

0.00 0.00 0.00

0.000 0.000 0.000

0.00 0.00 0.00

2036 2037 2038

0.00 0.00 0.00

0.000 0.000 0.000

0.00 0.00 0.00

Summarised Information

To be
Printed Particulars

Balance Sheet Data/Capital Structure

Yes Equity Share capital
Yes Preference Share Capital

Yes Share Application (finalized for Allotment) & Securities

Premium
Yes Other Reserves & Surplus (excl. Rev. reserves & net of intan
Yes Accumulated Profit & Loss
Yes Tangible Net worth
Yes Deferred Tax Liabilities / (Assets)
Yes Adjusted TNW
Yes Funds Invested Outside Business (FIOB)
Yes Net Owned Funds
Yes Term Liabilities (of which)
Yes -- Term Loans from Banks & FI
Yes Quasi Equity
Yes Other LT Borrowings not classified above
Yes Debentures
Yes -- Others Term Liabilities & Provisions
Yes Capital Employed
Yes Net Block (Excl. Revaluation Rsv.)
Yes Non-current assets
Yes
Yes
Yes
Yes Current Assets
Yes Inventories
Yes Debtors
Yes -- Cash & Bank Balance
Yes -- ST Investments
Yes -- Other Current Assets
Yes Current Liabilities
Yes -- Creditors
Yes -- Creditors for LC / Buyers Credit
Yes -- Bank Borrowings
Yes -- Term Borrowings Payable in one year
Yes -- Other Short Term Borrowings
Yes -- Other Liabilities & Provisions
Yes Net Current Assets
Yes Capital Deployed
Yes Additional Information
Yes Secured Long Term Borrowings (Excl. Term borrowing maturi
Yes Unsecured Long Term Borrowings
Yes Operational Data:
Yes Gross Sales
Yes (-) Goods & Services Tax
Yes Net sales
Yes -- of which Export Sales
Yes Other Operating Income
Yes Total Operating Income (TOI)
Yes Non-Operating Income
Yes Total Income (TI)
Yes Cost of goods sold
Yes Admn. Selling expenses
Yes Depreciation
Yes Interest & Financial Charges
Yes Profit Before Tax (PBT)
Yes Tax provisions
Yes Extraordinary Items (Post Tax)
Yes Net profit after tax (PAT)
Yes Dividend / App.
Yes Net profit retained in business
Yes Cash Accruals
Yes EBIT
Yes Operating Cash Profit (EBIT+Depreciation - Non Operating
Yes EBITDA
Yes Adjusted Net Profit (Exc. All extraordinary items)
Yes Ratio Analysis:
Yes Operating Profit margin {OPBDIT/TOI %}
Yes PBT/NS (in %)
Yes PAT/NS (in %)
Yes Total Debt/EBITDA
Yes Return on capital employed (in %)
Yes PAT/ATNW
Yes Current Ratio (Considering TL inst.)
Yes Current Ratio (without considering TL inst.)
Yes DE Ratio (TTL/ATNW)
Yes DE Ratio (TOL/ATNW)
Yes DE Ratio (TTL/TNW)
Yes DE Ratio (TOL/TNW)
Yes DE Ratio (TTL/ATNW) [Networth includes Quasi Equity]
Yes DE Ratio (TOL/ATNW) [Networth includes Quasi Equity]
Yes (TOL + Cont. Lia.) / ATNW
Yes % of Cont. lia. To ATNW
Yes Interest Coverage Ratio {EBITDA/Interest}
Yes Inventory Holding level (days)
Yes Debtors (days)
Yes Creditors level (days)
Yes
Yes
Other Additional Information (Other Bifurcation if
Yes Required)
Yes 1) NCD
Yes 2) CP

Calculation of MPBF under Method (1 or 2)?

PBF as per MPBF Method 2
Year
a) Total Current Assets [TCA]
b) (Minus) Current liabilities less Bank finance & Creditors und
c) Working Capital Gap {a - b} [WCG]

d) Total Current Liabilities

e) Export Receivables

Less: Margin: Higher of -

25% of (TCA excl Exp Rec)
Net Working Capital {a - d}
f) Margin

g) MAXIMUM PERMISSIBLE BANK FINANCE {c - f}

h) Bank Borrowing
i) Excess Borrowing

Working Capital Cycle

Item [Basis]
a) Debtors [Gross Sales]
-- Domestic Receivables (incl > 6 months)
-- Export Receivables
-- Deferred Receivables
b) Total Inventory
-- RM & Stores [RM & Stores Consumed]
-- WIP [COP]
-- Finished Goods [COGS]
c) Advance to Suppliers [RM & Stores Consumed]
d) Funding Requirement for
e) Creditors & Buyer's Credit [RM & Stores Purchase Cost]
f) Advance from Customers [Gross Sales]
g) External Credit Available for
h) Net WC Cycle

Year End

No of Months
i) I. CURRENT ASSETS
Export receivables
II. CURRENT LIABILITIES (excl Bank borrowing)
III W Cap Gap (I - II)
III(a) W Cap Gap (I - II)-Excl export Rcvbl
25% of Working capital Gap - Excl Export Rcvbl
IV. Act./Proj Bank Bor. Incl. LC Creditors and Buyers
Credit
V. Total Cur Lia (II+IV)
VI. Act./Proj NWC
VII Mini.Stip.NWC 25 % of III(a) or I as applicable
VIII. Item III - Item VII
IX. Item III - Item VI
X. M P B F
XI. Excess Borr. if any.

Yes PBDIT/TA
Yes Paid up capital
Yes Deferred Tax Liability
Yes Unsecured Loan
Yes FACR
Audited Audited Audited

2023 2024 2025

0.00 0.00 157842.50

0.00 0.00 205962.00
0.00 0.00 205962.00

0.00 0.00 0.00

0.00 0.00 0.00
0.00 0.00 0.00

Days
2023 2024 2025
0 0 19
-- -- 19
-- -- --
-- -- 0
0 0 0
-- -- 0
-- -- 0
-- -- 0
-- -- 121
-- -- 140
-- -- 6
-- -- 0
0 0 6
-- -- 134

Mar/23 Mar/24 Mar/25

Audited Audited Audited
12 12 12
0.00 0.00 631370.00
0.00 0.00 0.00
0.00 0.00 425408.00
0.00 0.00 205962.00
0.00 0.00 205962.00
0.00 0.00 51490.50
0.00 0.00 0.00
0.00 0.00 425408.00
0.00 0.00 205962.00
0.00 0.00 51490.50
0.00 0.00 154471.50
0.00 0.00 0.00
0.00 0.00 0.00
0.00 0.00 0.00

0.00 0.00 0.60

0.00 0.00 0.00
0 0 0
0.00 0.00 0.00
0.00 0.00 0.00
1 2 3

Estimated Projected Projected Projected

2026 2027 2028 2029

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 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 0.00 0.00
0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00
546917.00 687132.00 0.00 0.00
0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00
546917.00 687132.00 0.00 0.00
0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00
546917.00 687132.00 0.00 0.00
172677.00 150842.00 0.00 0.00
140120.00 120150.00 0.00 0.00

764370.00 931370.00 0.00 0.00

680250.00 840120.00 0.00 0.00
0.00 0.00 0.00 0.00
84120.00 91250.00 0.00 0.00
0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00
530250.00 515230.00 0.00 0.00
30250.00 15230.00 0.00 0.00
0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00
500000.00 500000.00 0.00 0.00
0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00
234120.00 416140.00 0.00 0.00
546917.00 687132.00 0.00 0.00

0.00 0.00 0.00 0.00
0 0 0 0
0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00
4 5 6 7

Projected Projected Projected Projected

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 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 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 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
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 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 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 0.00

#DIV/0! #DIV/0! #DIV/0! #DIV/0!

2034 2035 2036 2037

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 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 0.00 0.00

0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00

2034 2035 2036 2037

0 0 0 0
-- -- -- --
-- -- -- --
0 0 0 0
0 0 0 0
-- -- -- --
-- -- -- --
-- -- -- --
-- -- -- --
-- -- -- --
-- -- -- --
-- -- -- --
0 0 0 0
-- -- -- --

Mar/34 Mar/35 Mar/36 Mar/37

Projected Projected Projected Projected

2038 2039 2040 2041

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 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 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 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
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 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 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 0.00
0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00

#DIV/0! #DIV/0! #DIV/0! #DIV/0!

2038 2039 2040 2041

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 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 0.00 0.00

0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00

2038 2039 2040 2041

0 0 0 0
-- -- -- --
-- -- -- --
0 0 0 0
0 0 0 0
-- -- -- --
-- -- -- --
-- -- -- --
-- -- -- --
-- -- -- --
-- -- -- --
-- -- -- --
0 0 0 0
-- -- -- --

Mar/38 Mar/39 Mar/40 Mar/41

Projected Projected Projected Projected
12 12 12 12
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 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 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 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
0.00 0.00 0.00 0.00
Balance Sheet Data/ Capital Structure
All the particulars field will be left aligned and ratio values will be centrally aligned
Particulars Y1
For FY ended 31-Mar-23
Type of Financials Audited
Equity Share Capital 0.00
Reserves & Surplus (Excl. revaluation reserves and net of 0.00
intangible assets)
Tangible Net worth (TNW) 0.00
Deferred Tax Liability 0.00
Adjusted Net Worth 0.00
Net Owned Funds [TNW - FIOB] 0.00
Term Liabilities, of which 0.00
Term Loans from Banks & FI 0.00
Quasi Equity 0.00
Other LT Borrowings not classified above 0.00
Debentures 0.00
Others Term Liabilities & Provisions 0.00
Capital Employed 0.00
Net Block (incl CWIP and preoperative expenses/ IDC) 0.00
Funds Invested outside Business (FIOB) 0.00
Other Non-Current assets 0.00
Current Assets (CA), of which 0.00
Inventories 0.00
Debtors 0.00
Cash & Bank Balance 0.00
Short Term Demand Loans & Advances 0.00
Current Liabilities (CL), of which 0.00
Creditors 0.00
Unsecured Loans 0.00
Other liabilities/ prov. 0.00
Net Current Assets (CA-CL) 0.00
Capital Deployed 0.00

Operational Data
Particulars Y1
For FY ended 31-Mar-23
Type of Financials Audited
Revenue from operations 0.00
Of Which Export Sales 0.00
Less: Excise / Sales Tax 0.00
Net Sales 0.00
Other Income 0.00
Cost of goods sold 0.00
Adm. & Selling Expenses 0.00
Depreciation 0.00
Interest 0.00
Extraordinary Items 0.00
Net Profit before Tax 0.00
EBITDA 0.00
Tax provisions 0.00
Cash Accruals 0.00

Ratio Analysis
Particulars Y1
For FY ended 31-Mar-23
Type of Financials Audited
PBT/NS (in %) #DIV/0!
PAT/NS (in %) #DIV/0!
NWC 0.00
DE Ratio (TTL/ATNW) [Networth includes Quasi Equity] #DIV/0!
DE Ratio (TOL/ATNW) [Networth includes Quasi Equity] #DIV/0!
Current Ratio (Considering TL inst.) #DIV/0!
Quasi DE ratio #DIV/0!
Fixed Assets Coverage Ratio (FACR) #DIV/0!
Total Debt/EBITDA #DIV/0!
PAT/ATNW #DIV/0!
Interest Coverage Ratio {EBITDA/Interest} #DIV/0!
Interest Coverage Ratio {EBITDA/Sales} #DIV/0!
Inventory Holding level (days) 0.00
Debtors (days) 0.00
Creditors level (days) #VALUE!
Net Cash Accurals / Total Debt 0.00
Operating Profit margin % #DIV/0!
EBITDA / Net Sales % #DIV/0!
Return on capital employed (in %) #DIV/0!
Current Ratio (without considering TL inst.) #DIV/0!
Interest Coverage Ratio #DIV/0!
Working Capital Cycle (Days) #VALUE!
DE Ratio(TOL/TNW) #DIV/0!
DE Ratio(TOL/ ATNW) #DIV/0!
DE Ratio(TTL/TNW) #DIV/0!
DE Ratio(TTL/ATNW) #DIV/0!
Net Block (Excl. Revaluation Resv.) 0.00
O/s Term Loan 0.00
(TOL + Cont. Lia.) / ATNW 0.00
% of Cont. lia. To ATNW 0.00
Asset Turnover Ratio= Net Sales / Total Tangible Assets 0.00
Return on investment=EBITDA / Total Tangible Assets 0.00
(TOL + Cont. Lia.) / ATNW 0.00
% of Cont. lia. To ATNW 0.00
% of outside investment to ATNW 0.00
BEP sales as % to net sales & Quantity #DIV/0!
Cash Flow Interest Coverage #VALUE!
Cash Flow DSCR #VALUE!
Minimum DSCR 0.00
Average Debt Service Coverage Ratio(DSCR) 4.36
Gross Profit margin % #DIV/0!
Cash Flow Extract for the Audited Period
Particulars Y1
For FY ended 31-Mar-23
Type of Financials Audited
Net cash flow from operating activities 0.00
Net cash flow / (used) in investing activities 0.00
Net cash flow / (used) in financing activities 0.00
Net Cash Generated 0.00
Opening Balance of cash and cash equivalents 0.00
Closing Balance of cash and cash equivalents 0.00

Funds Flow Summary

Particulars Y1
For FY ended 31-Mar-23
Type of Financials Audited
Long Term Sources 0.00
Less - Long Term uses 0.00
Surplus (+) / Short Fall (-) 0.00
Short Term Sources 0.00
Less - Short Term uses 0.00
Surplus (+) / Short fall (-) 0.00
Gap in Funds Flow 0.00

CMA Working Capital Assessment

MPBF II method of lending- Label
Particulars Audited
For FY ended 2024.00
Total Current Assets 0.00
Current Liabilities (Excl. Bank Borrowings) 0.00
Working Capital Gap 0.00
Total Current Liabilities 0.00
Export Receivables 0.00
Actual/ Projected NWC 0.00
Minimum required NWC [25% of (WCG excl Exp Rec)] 0.00
Margin (Higher of above two) 0.00
MPBF 0.00
Actual Projected Bank Borrowing 0.00
Excess Borrowings 0.00
Turnover Method- Label (1+Latest Audited Year)
Particulars Audited
For FY ended 2024.00
Projected Sales 0.00
Accepted level by Bank 0.00
25% of Turnover (A) 0.00
Margin: 5% of turnover (B) 0.00
Actual/ Projected NWC 0.00
Eligible Limit 0.00
Term Loan Assessment- Label
(1+Latest Audited Year)
Currency Unit
Particulars Y1
For FY ended 2026.00
Profit After Tax 862566.00
Interest on Term Loan 0.00
Depreciation 0.00
Non Cash expenses 0.00
Total Funds Available 862566.00
Term Loan Installments 0.00
Interest of Term Loans 0.00
Total Repayment Obligations 0.00
DSCR 0.00
Average DSCR 4.36
Minimum DSCR 0.00
Debt equity ratio of the project 0.00

Formula will be confirmed

Financial Trends

Sales Comments - Output Denomination

Firm achieved sales of Rs.207.38Lakhs and Rs.95.39Lakhs in

FY2020 and FY2021respectively. Firm has further achieved sales
of Rs.146.54Lakhs as per Audited2022 Lakhs

From the above chart it is visible that sales of firm is decreased by

-54.91% in FY2021. Sales of the firm is increased by 56.35% in
FY2022.
Firm has estimated total revenue of Rs.134.41Lakhs in last
financials accepted by Bank Lakhs
Firm has estimated and projected to attain sales of Rs.221.01,
Rs.321.67Lakhs in FY2023 and FY2024 respectively Lakhs

Profit Comment - Output

The Company has registered PAT of Rs.2.61Lakhs and

Rs.1.16Lakhs in FY2020 and FY2021respectively. Firm has further
achieved PAT of Rs.2.3Lakhs as per Audited2022. Lakhs

NP/ sales has been1.31% and 1.66% in FY2021and in FY2022

Firm has estimated and projected to achieve Net Profit

Rs.3.99Lakhs and Rs.8.04Lakhs in FY2023 and FY2024 respectively

Net worth Comment

The Firm has estimated and projected to maintain TNW of

Rs.44.75Lakhs and Rs.52.78Lakhs in FY2023and FY2024
respectively Lakhs
Inventory Holding Level

Inventory Holding level of Firm is 91 days and 251 days in FY2020

and FY2021 respectively. Firm has further attained inventory
holding at 177 days as per Audited 2022.

Firm has estimated and projected inventory holding level at 114

days in FY2023 and 91 days in FY2024 respectively.

Debtors Holding Level

Debtors Holding level of Firm is 54 days and 82 days in FY2020

and FY2021 respectively. Firm has further attained inventory
holding at 78 days as per Audited2022.

Firm has estimated and projected inventory holding level at 61

days in FY2023 and 49 days in FY2024 respectively.

Creditors Holding Level

Creditors Holding level of Firm is 12 days and 36 days in FY2020

and FY2021 respectively. Firm has further attained inventory
holding at 14 days as per Audited 2022.

Firm has estimated and projected inventory holding level at 10

days in FY2023 and 8 days in FY2024 respectively.

Turnover Method- Digial Sale (1+Latest Audited Year)

Particulars Audited
For FY ended 2024.00
Projected Sales 0.00
Accepted level by Bank 0.00
25% of Turnover (A) 0.00
Margin: 5% of turnover (B) 0.00
Actual/ Projected NWC 0.00
Eligible Limit 0.00

Total of Turnover Method

Particulars Audited
For FY ended 2024.00
Limit Assessed for Non- Digital Mode 0.00
Limit Assessed for Digital Mode 0.00
Total Limit assessed as per turnover method 0.00

WC Limit Eligibility
Particulars Audited
For FY ended 2024.00
MPBF II method of lending 0.00
Turnover Mehtod 0.00
Assessment of PC/PCFC:
Particulars Audited
For FY ended 2024.00
Total Sales 0.00
Export Sales 0.00
Export sales as % of total sales #N/A
Total Raw Material consumed 0.00
Proportionate Raw material procured for export (A) #N/A
Estimated/Projected Inventory Holding (B) 30.00
Eligible Packing Credit (C) (A*B/365) #N/A
Margin @10% (D) #N/A
Limit Eligible (C-D) #N/A
Pre shipment limit requested by company
Pre shipment regular limit
Untied
Our Share [ E ]
Interchangeability (F)
Stand-by limit under Gold Card (G) 0.00
Total limit requested under PC/PCFC (including interchangeability 0.00
(subject to availability))

Assessment of PSDL/FBP/FBD
Particulars Audited
For FY ended 2024.00
Total export sales (A) 0.00
Usance period 30.00
Eligible FBP/FBD for 120 days (A/365)*120 (B) 0.00
Margin @ 10% ( C) 0.00
Limit Eligible (B-C) 0.00
Post shipment regular limit (Consortium)
Our Share (D)
Interchangeability [ E ]
Stand-by limit under Gold Card (F) 0.00
Total limit requested under Post shipment limit including 0.00
interchangeability (D+E)

Assessment of Gold Card

Particulars Audited
For FY ended 2024.00
Pre-shipment Limit 0.00
PSDL/FBP/FBD Limit 0.00
Total 0.00

Product A - Assessment
1a. Pre funded DSCR as per last Audited Balance Sheet
Particulars Y3
Type of Financials Audited
For FY ended 31-Mar-25
Net profit after tax 529005.00
Add - Depreciation 0.00
Add - Non cash expenses (net) 0.00
Add - Interest on Term Loans 0.00
Total Fund Available 529005.00
Term Loan instalments 400268.00
Add - Interest on Term Loans 0.00
Total Repayment obligation 400268.00
Pre-Funded DSCR 1.32

1b. Repayment Capacity Assessment

Particulars Y3
Type of Financials Audited
For FY ended 31-Mar-25
Profit Before Tax 529005.00
Depriciation 0.00
Directors Remuneration / Partners Salary 0.00
Interest paid to Partners / Directors 0.00

0.00
Other income generated by the entity or partners or directors
Interest paid on loans debited to P&L account of entity 0.00
Interest paid on Bank OD/CC 36397.00

0.00
Less Total Tax (both entity and individual directors / partners)
Total Cash Accruals 565402.00
EMI of all the Term loans 400268.00
Interest on Bank CC / OD 36397.00
EMI on proposed Loan 99732.00
Total Debt Service 536397.00
DSCR 1.05

Cash Profit (Year 2) Cash Profit (Year 3)

0 529005.00

Highlight if less than 3 lacs

2. Debt Equity Ratio
Particulars Y3
Type of Financials Audited
For FY ended 31-Mar-25
Total Debt (including CPLTD classified under ST 949343.00
borrowings or other CL)
Less Unsecured Loan from promoters (subject to the conditions 0.00
mentioned below)
Revised Debt Level 949343.00
Share Capital 0.00
Reserves 0.00
Unsecured Loan from promoters 0.00
Less Loans and Advances given to directors / partners 0.00
Total Net-worth 0.00
Debt Equity Ratio #DIV/0!

BG Assessment
Particular Audited 2
For FY ended 31-Mar-23
Amount of Bids Participated in
Amount of Contracts awarded from the bids participated
Success Rate (%)

Contractors Assessment
Particulars Y1
Year 2026.00
Total revenue estimate as per work order position
Revunue estimate as per CMA data 3390375.00
Difference -3390375.00
Y2 Y3
31-Mar-24 31-Mar-25
Audited Audited
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 523935.00
0.00 0.00
0.00 0.00
0.00 523935.00
0.00 0.00
0.00 0.00
0.00 523935.00
0.00 197833.00
0.00 0.00
0.00 120140.00
0.00 631370.00
0.00 560250.00
0.00 0.00
0.00 71120.00
0.00 0.00
0.00 425408.00
0.00 25140.00
0.00 0.00
0.00 0.00
0.00 205962.00
0.00 523935.00

Y2 Y3
31-Mar-24 31-Mar-25
Audited Audited
0.00 2260250.00
0.00 0.00
0.00 0.00
0.00 2260250.00
0.00 0.00
0.00 1694848.00
0.00 0.00
0.00 0.00
0.00 36397.00
0.00 0.00
0.00 529005.00
0.00 565402.00
0.00 0.00
0.00 529005.00

Y2 Y3
31-Mar-24 31-Mar-25
Audited Audited
#DIV/0! 23.40
#DIV/0! 23.40
0.00 205962.00
#DIV/0! #DIV/0!
#DIV/0! #DIV/0!
#DIV/0! 1.48
#DIV/0! #DIV/0!
#DIV/0! 0.49
#DIV/0! 1.63
#DIV/0! #DIV/0!
#DIV/0! 15.53
#DIV/0! 0.25
0.00 121.00
0.00 19.00
#VALUE! 6.00
0.00 0.57
#DIV/0! 25.02
#DIV/0! 25.02
#DIV/0! 107.91
#DIV/0! 25.11
#DIV/0! 15.53
#VALUE! 134.00
#DIV/0! #DIV/0!
#DIV/0! #DIV/0!
#DIV/0! #DIV/0!
#DIV/0! #DIV/0!
0.00 197833.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 2.38
0.00 0.60
0.00 0.00
0.00 0.00
0.00 0.00
#DIV/0! 9.03
0.00 0.00
0.00 0.00

#DIV/0! 25.02
Y2 Y3
31-Mar-24 31-Mar-25
Audited Audited
0.00 -498713.00
0.00 -317973.00
0.00 887806.00
0.00 71120.00
0.00 0.00
0.00 71120.00

Y2 Y3
31-Mar-24 31-Mar-25
Audited Audited
0.00 1453208.00
0.00 846978.00
0.00 606230.00
0.00 25140.00
0.00 631370.00
0.00 -606230.00
0.00 0.00

(1+Latest Audited Year) (First year where type of Financials=Projected)

Audited Projected
2025.00 2026.00
631370.00 764370.00
425408.00 530250.00
205962.00 234120.00
425408.00 530250.00
0.00 0.00
205962.00 234120.00
51490.50 58530.00
205962.00 234120.00
0.00 0.00
0.00 0.00
0.00 0.00
(First year where type of Financials=Projected)
Audited Projected
2025.00 2026.00
2260250.00 2712300.00
2260250.00 2712300.00
565062.50 678075.00
113012.50 135615.00
205962.00 234120.00
359100.50 443955.00

(First year where type of Financials=Projected)

3.00
Y2 Y3
2027.00 2028.00
1317130.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
1317130.00 0.00
500000.00 500000.00
0.00 0.00
500000.00 500000.00
2.63 0.00

Input1 Input2

0.00 0.00

#N/A #DIV/0!

2712300.00

3390375.00 0.00

0.00 0.00

#DIV/0! 0.23

1317130.00 0.00

0.00 0.00
0.00 0.00

152.00 2027.00

0.00 0.00

13.00 2027.00

#VALUE! #VALUE!

3.00 2027.00

(First year where type of Financials=Projected)

Audited Estimated
2025.00 2026.00
2260250.00 2712300.00
2260250.00 2712300.00
565062.50 678075.00
113012.50 135615.00
205962.00 234120.00
359100.50 443955.00

Audited Estimated
2025.00 2026.00
359100.50 443955.00
359100.50 443955.00
718201.00 887910.00

Audited Estimated
2025.00 2026.00
0.00 0.00
359100.50 443955.00
Audited Estimated
2025.00 2026.00
2260250.00 2260250.00
0.00 0.00
#N/A #N/A
1442123.00 1442123.00
#N/A #N/A
30.00 30.00
#N/A #N/A
#N/A #N/A
#N/A #N/A

0.00 0.00
0.00 0.00

Audited Estimated
2025.00 2026.00
0.00 0.00
30.00 30.00
0.00 0.00
0.00 0.00
0.00 0.00

0.00 0.00
0.00 0.00

Audited Estimated
2025.00 2026.00
0.00 0.00
0.00 0.00
0.00 0.00
OS D123 529005.00
OS D48
OS D97
OS D62 + OS D65
0.00
BS E35 + BS E36
OS D62 + OS D65

OS D99
OS D48
to be input manually
To be input manually to be input manually

To be input manually To be input manually

OS D62 + OS D63 + OS D66
OS D61

To be input manually OS D103+ manually

Total -
OS D62 + OS D65 + BS E35 + BS E36
OS D61 + OS D64
BS G35 - BS E35 + OS F62 - OS D62

Average Cash Profit

264502.50

Highlight in red if negative

BS E89

BS E69
0.00
BS E92
BS E95 - BS E105
BS E105
BS E165

Highlight if greater than 4

Audited 1 Current Year

31-Mar-24 31-Mar-25

Y2 Y3
2027.00 2028.00

0.00 0.00
0.00 0.00
Y4 Y5 Y6
31-Mar-26 31-Mar-27 31-Mar-28
Estimated Projected Projected
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 0.00 0.00
546917.00 687132.00 0.00
0.00 0.00 0.00
0.00 0.00 0.00
546917.00 687132.00 0.00
0.00 0.00 0.00
0.00 0.00 0.00
546917.00 687132.00 0.00
172677.00 150842.00 0.00
0.00 0.00 0.00
140120.00 120150.00 0.00
764370.00 931370.00 0.00
680250.00 840120.00 0.00
0.00 0.00 0.00
84120.00 91250.00 0.00
0.00 0.00 0.00
530250.00 515230.00 0.00
30250.00 15230.00 0.00
0.00 0.00 0.00
0.00 0.00 0.00
234120.00 416140.00 0.00
546917.00 687132.00 0.00

Y4 Y5 Y6
31-Mar-26 31-Mar-27 31-Mar-28
Estimated Projected Projected
2712300.00 3390375.00 0.00
0.00 0.00 0.00
0.00 0.00 0.00
2712300.00 3390375.00 0.00
0.00 0.00 0.00
1794734.00 2018245.00 0.00
0.00 0.00 0.00
0.00 0.00 0.00
55000.00 55000.00 0.00
0.00 0.00 0.00
862566.00 1317130.00 0.00
917566.00 1372130.00 0.00
0.00 0.00 0.00
862566.00 1317130.00 0.00

Y4 Y5 Y6
31-Mar-26 31-Mar-27 31-Mar-28
Estimated Projected Projected
31.80 38.85 #DIV/0!
31.80 38.85 #DIV/0!
234120.00 416140.00 0.00
#DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0!
1.44 1.81 #DIV/0!
#DIV/0! #DIV/0! #DIV/0!
0.35 0.30 #DIV/0!
1.14 0.87 #DIV/0!
#DIV/0! #DIV/0! #DIV/0!
16.68 24.95 #DIV/0!
0.34 0.40 #DIV/0!
138.00 152.00 0.00
19.00 13.00 0.00
7.00 3.00 #VALUE!
0.82 1.11 0.00
33.83 40.47 #DIV/0!
33.83 40.47 #DIV/0!
167.77 199.69 #DIV/0!
25.27 61.15 #DIV/0!
16.68 24.95 #DIV/0!
150.00 162.00 #VALUE!
#DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0!
172677.00 150842.00 0.00
0.00 0.00 0.00
0.00 0.00 0.00
0.00 0.00 0.00
2.52 2.82 0.00
0.85 1.14 0.00
0.00 0.00 0.00
0.00 0.00 0.00
0.00 0.00 0.00
6.50 4.87 #DIV/0!
0.00 0.00 0.00
0.00 0.00 0.00

33.83 40.47 #DIV/0!

Y4 Y5 Y6
31-Mar-26 31-Mar-27 31-Mar-28
Estimated Projected Projected
0.00 -234780.00 824890.00
0.00 46981.00 270992.00
0.00 108197.00 -1187132.00
0.00 -79602.00 -91250.00
0.00 71120.00 91250.00
0.00 -8482.00 0.00

Y4 Y5 Y6
31-Mar-26 31-Mar-27 31-Mar-28
Estimated Projected Projected
1909483.00 1627050.00 270992.00
1175363.00 1317140.00 1187132.00
734120.00 309910.00 -916140.00
30250.00 0.00 931370.00
764370.00 309910.00 15230.00
-734120.00 -309910.00 916140.00
0.00 0.00 0.00

Projected TAB ROW

2027.00 MCB H6
931370.00 MCB 102.00
515230.00 MCB 103.00
416140.00 MCB 104.00
515230.00 MCB 106.00
0.00 MCB 107.00
416140.00 MCB 111.00
104035.00 MCB 110.00
416140.00 MCB 112.00
0.00 MCB 114.00
0.00 MCB 115.00
0.00 MCB 116.00

Projected
2027.00
3390375.00 MCB Additional 50.00
3390375.00 This to be kept editable on form
847593.75
169518.75
416140.00
431453.75

4.00 5.00 6.00

Y4 Y5 Y6
2029.00 2030.00 2031.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
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 0.00 0.00

Input3 Input4 Input 5

2023.00 2024.00 2260250.00

2024.00 #N/A #DIV/0!

2027.00 2028.00

2023.00 2024.00 529005.00

2024.00 2025.00

2027.00 2028.00

2027.00 2028.00
2023.00 2024.00 121.00

0.00 2028.00

2023.00 2024.00 19.00

0.00 2028.00

2023.00 2024.00 6.00

#VALUE! 2028.00

Projected
2027.00
3390375.00
3390375.00
847593.75
169518.75
416140.00
431453.75

Projected
2027.00
431453.75
431453.75
862907.50

Projected
2027.00
0.00
431453.75
Projected
2027.00 Mapping
2260250.00 CMA
0.00 CMA
#N/A Calculate
1442123.00 CMA
#N/A Calculate
30.00 Facility -> Usance Days
#N/A Calculate
#N/A Calculate - Margin % from particulars
#N/A Calculate
Consortium
Consortium
Consortium
Facility -> Proposed Amount
Enter manually
0.00 Calculate - Limit requested by company [ E ] * 20%
0.00
Calculate

Projected
2027.00
0.00 CMA
30.00 Facility -> Usance Days
0.00 Calculate
0.00 Calculate - Margin % from particulars
0.00 Calculate
Consortium table mapping
Facility -> Proposed Amount
Enter manually
0.00 Calculate - Limit requested by company [ E ] * 20%
0.00
Calculate

Projected
2027.00
0.00 Stand-by limit under Gold Card (G)
0.00 Stand-by limit under Gold Card (F)
0.00
Cash Profit (Year 2) Will be
auto populate from CMA
( Mappimg to be confirm
from bank)
Total Average
Tab Row

MCB 7
MCB 10

MCB 12
MCB 13
MCB 14
MCB 16
MCB 17
MCB 18
MCB 19
MCB 20
MCB 21
MCB 22
MCB 23
MCB 24
MCB 15
MCB 25
MCB 29
MCB 30
MCB 31
MCB 32
BS 139
MCB 35
MCB 36
MCB 46
MCB 41
MCB 42
MCB 43

Tab Row

MCB 48
MCB 51
MCB 49
MCB 50
MCB 55
MCB 56
MCB 57
MCB 58
OS 69
MCB 62
MCB 63
MCB 69
MCB 61
MCB 66

3 4 5 6
Y7 Y8 Y9 Y10
31-Mar-29 31-Mar-30 31-Mar-31 31-Mar-32
Projected Projected Projected Projected
#DIV/0! 0.00 0.00 0.00
#DIV/0! 0.00 0.00 0.00
0.00 0.00 0.00 0.00
#DIV/0! 0.00 0.00 0.00
#DIV/0! 0.00 0.00 0.00
#DIV/0! 0.00 0.00 0.00
#DIV/0! 0.00 0.00 0.00
#DIV/0! 0.00 0.00 0.00
#DIV/0! 0.00 0.00 0.00
#DIV/0! 0.00% 0.00% 0.00%
#DIV/0! 0.00 0.00 0.00
#DIV/0! #DIV/0! #DIV/0! #DIV/0!
0 0 0 0
0 0 0 0
#VALUE! 0 0 0
0.00% 0.00% 0.00% 0.00%
#DIV/0! 0.00 0.00 0.00
#DIV/0! #DIV/0! #DIV/0! #DIV/0!
#DIV/0! 0.00 0.00 0.00
#DIV/0! 0.00 0.00 0.00
#DIV/0! 0.00 0.00 0.00
#VALUE! 0 0 0
#DIV/0! 0.00 0.00 0.00
#DIV/0! 0.00 0.00 0.00
#DIV/0! 0.00 0.00 0.00
#DIV/0! 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 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% 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%
0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00

#DIV/0! #DIV/0! #DIV/0! #DIV/0!

7 8 9 10
Y7 Y8 Y9 Y10
2032 2033 2034 2035
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 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 0.00 0.00
0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00

Input 6
2025

2025

2025
2025

2025

2025
7 8 9 10 11 12 13 14
Y11 Y12 Y13 Y14 Y15 Y16 Y17 Y18
31-Mar-33 31-Mar-34 31-Mar-35 31-Mar-36 31-Mar-37 31-Mar-38 31-Mar-39 31-Mar-40
Projected Projected Projected Projected Projected Projected Projected Projected
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 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 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 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 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 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% 0.00% 0.00%
0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
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 0.00 0.00 0.00
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
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 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
0 0 0 0 0 0 0 0
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 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 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 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 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 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% 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% 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%
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 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00

#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!

11 12 13 14 15 16
Y11 Y12 Y13 Y14 Y15 Y16
2036 2037 2038 2039 2040 2041
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 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 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 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 0.00 0.00
15
Y19
31-Mar-41
Projected
0.00 MCB B73
0.00 MCB B74
0.00 MCB B111
0.00 MCB B84
0.00 MCB B85
0.00 MCB B78
0.00 MCB 84
0.00 MCB B160
0.00 MCB B75
0.00% MCB B77
0.00 MCB B88
#DIV/0! MCB
0 MCB B89
0 MCB B90
0 MCB B91
0.00% Ratios B9
0.00 MCB B72
#DIV/0! MCB
0.00 MCB B76
0.00 MCB B79
0.00 MCB B88
0 MCB B135
0.00 MCB B83
0.00 MCB B81
0.00 MCB B82
0.00 MCB B80
0.00 MCB B24
0.00 MCB 18
0.00 MCB B86
0.00 MCB B87
0.00 Ratios 11
0.00% Ratios B12
0.00 Ratios B14
0.00% Ratios B15
0.00% Ratios B16
0.00 Ratios B22
0.00 Ratios B27
0.00 Ratios B28
DSCR 21
DSCR 20
#DIV/0!
Proj.DSCR

Name of the Company OM HOTEL AND SWEET HOME

Lakhs

DSCR Computation
Year end 2026 2027 2028

Projected Projected Projected

Net profit after tax 0.00 0.00 0.00
Add - Depreciation 0.00 0.00 0.00
Add - Non cash expenses (net) 0.00 0.00 0.00
Add - Interest on Term Loans 0.00 0.00 0.00
Total Fund Available 0.00 0.00 0.00
Term Loan instalments 0.00 0.00 0.00
Add - Interest on Term Loans 0.00 0.00 0.00
Total Repayment obligation 0.00 0.00 0.00

DSCR 0.00 0.00 0.00

#DIV/0! #DIV/0! #DIV/0! #DIV/0!

2033 2034 2035 2036

Projected Projected Projected Projected

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 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 0.00 0.00
0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00

#DIV/0! #DIV/0! #DIV/0! #DIV/0!

2037 2038 2039 2040

#DIV/0! #DIV/0! #DIV/0! #DIV/0!

2045 2046 2047 2048

New Balaji Stone Merchant Latest
No ratings yet
New Balaji Stone Merchant Latest
63 pages
Sunil Raghunath Bhosale
No ratings yet
Sunil Raghunath Bhosale
42 pages
Instructions Dear User Please Note Following Before You Use This CMA Template. Following Is The Colour Coding For Input
No ratings yet
Instructions Dear User Please Note Following Before You Use This CMA Template. Following Is The Colour Coding For Input
29 pages
Msme Cma Format
No ratings yet
Msme Cma Format
121 pages
Balaji Sales Cma Data
No ratings yet
Balaji Sales Cma Data
206 pages
Msme Cma Format
No ratings yet
Msme Cma Format
122 pages
CMA Instructions and Financial Input Guide
No ratings yet
CMA Instructions and Financial Input Guide
160 pages
Cma (Copy of Cma LLPS) .XLSM
No ratings yet
Cma (Copy of Cma LLPS) .XLSM
65 pages
Ak Studio Cma
No ratings yet
Ak Studio Cma
45 pages
CMA MITTAL KNITWEAR PRIVATE LIMITED-BOB Format
No ratings yet
CMA MITTAL KNITWEAR PRIVATE LIMITED-BOB Format
45 pages
1 Data To Be Entered in First Two Sheets Only I.E. "Profit & Loss Statement" and "Balance Sheet" Following Is The Color Coding For Input
No ratings yet
1 Data To Be Entered in First Two Sheets Only I.E. "Profit & Loss Statement" and "Balance Sheet" Following Is The Color Coding For Input
32 pages
2016 Accountancy Sample Paper
No ratings yet
2016 Accountancy Sample Paper
5 pages
Five-Year Service Industry Financial Plan
100% (1)
Five-Year Service Industry Financial Plan
4 pages
Hotel Financial Model PDF v3
No ratings yet
Hotel Financial Model PDF v3
11 pages
Financial Model (Shell) - Solutions
No ratings yet
Financial Model (Shell) - Solutions
9 pages
NBFC Financial Proposal Overview 2024
No ratings yet
NBFC Financial Proposal Overview 2024
8 pages
SAP FICO Consultant Resume Overview
No ratings yet
SAP FICO Consultant Resume Overview
3 pages
Bonus Provision Adjustment Report
No ratings yet
Bonus Provision Adjustment Report
7 pages
Project Report Tashu Saini
No ratings yet
Project Report Tashu Saini
7 pages
1 Data To Be Entered in First Two Sheets Only I.E. "Profit & Loss Statement" and "Balance Sheet" Following Is The Color Coding For Input
No ratings yet
1 Data To Be Entered in First Two Sheets Only I.E. "Profit & Loss Statement" and "Balance Sheet" Following Is The Color Coding For Input
33 pages
Adjustments
No ratings yet
Adjustments
6 pages
ABC Properties Financial Projection Model
No ratings yet
ABC Properties Financial Projection Model
9 pages
Hots Accounts 11th
No ratings yet
Hots Accounts 11th
24 pages
Financial Modelling Coursework Guide
No ratings yet
Financial Modelling Coursework Guide
13 pages
Icrrs ABC Tradings
No ratings yet
Icrrs ABC Tradings
93 pages
Annu Exports - XLSM
No ratings yet
Annu Exports - XLSM
35 pages
MSME Loan Project Report Summary
No ratings yet
MSME Loan Project Report Summary
4 pages
Praktan C. Dhaneshwar
No ratings yet
Praktan C. Dhaneshwar
1 page
1
No ratings yet
1
17 pages
FA DCF Modelling Test 1
0% (2)
FA DCF Modelling Test 1
17 pages
Financial Modeling Guide & Assumptions
100% (1)
Financial Modeling Guide & Assumptions
17 pages
CAM Pushkar Lal 2
No ratings yet
CAM Pushkar Lal 2
41 pages
Ridge Business Center Investment Analysis
No ratings yet
Ridge Business Center Investment Analysis
20 pages
Cfi Fmva Final Assessment Case Study 1a
No ratings yet
Cfi Fmva Final Assessment Case Study 1a
12 pages
HDFC Bank Financial Analysis
No ratings yet
HDFC Bank Financial Analysis
58 pages
Project Report: Alisaa Group, Bengaluru
No ratings yet
Project Report: Alisaa Group, Bengaluru
9 pages
Fsa Nmims
No ratings yet
Fsa Nmims
86 pages
Financial Accounting
No ratings yet
Financial Accounting
16 pages
Financial Analysis & Valuation Exam 2014
No ratings yet
Financial Analysis & Valuation Exam 2014
20 pages
Class 11 Trading & Profit Loss Accounts
No ratings yet
Class 11 Trading & Profit Loss Accounts
19 pages
Fa 1 (MDC) MDC-1
No ratings yet
Fa 1 (MDC) MDC-1
6 pages
CAP-I June2022 Final
100% (1)
CAP-I June2022 Final
37 pages
Final Acc Wid Adjustment Practical
No ratings yet
Final Acc Wid Adjustment Practical
20 pages
Pankaj's Resume
No ratings yet
Pankaj's Resume
1 page
Account MTP Answers - Fake Subscribers
No ratings yet
Account MTP Answers - Fake Subscribers
151 pages
Formulated Project Report
No ratings yet
Formulated Project Report
47 pages
Financial Statement
No ratings yet
Financial Statement
21 pages
FA DCF Modelling Test 1
0% (1)
FA DCF Modelling Test 1
21 pages
Mid Spring 25 AR
No ratings yet
Mid Spring 25 AR
56 pages
Badminton Court Project
No ratings yet
Badminton Court Project
5 pages
Financial Statements Preparation Guide
No ratings yet
Financial Statements Preparation Guide
16 pages
Revised CAM Format Salaried SENP Version 1 - Final
No ratings yet
Revised CAM Format Salaried SENP Version 1 - Final
58 pages
Reliance (2023) Gr3
No ratings yet
Reliance (2023) Gr3
5 pages
ABC Financial Services Year End 2008
No ratings yet
ABC Financial Services Year End 2008
3 pages
Cash Flow Problems
No ratings yet
Cash Flow Problems
9 pages
Pharma Business Financial Model v2 Unpopulated
No ratings yet
Pharma Business Financial Model v2 Unpopulated
24 pages
F Account Sem 1 WBSU (2018)
No ratings yet
F Account Sem 1 WBSU (2018)
3 pages
7th Motilal Oswal Wealth Creation Study
No ratings yet
7th Motilal Oswal Wealth Creation Study
28 pages
Economic Analysis of Supply and Demand
No ratings yet
Economic Analysis of Supply and Demand
7 pages
Unraveling The Connection Between Budgeting Practices and Financial Performance of Start-Up Businesses
No ratings yet
Unraveling The Connection Between Budgeting Practices and Financial Performance of Start-Up Businesses
10 pages
Important Sections of LLP Act
No ratings yet
Important Sections of LLP Act
4 pages
MCQs On Company Law 100
No ratings yet
MCQs On Company Law 100
18 pages
CH 1 Defining Marketing For The New Realities
No ratings yet
CH 1 Defining Marketing For The New Realities
29 pages
Bluebell's Luxury Distribution in Asia
No ratings yet
Bluebell's Luxury Distribution in Asia
18 pages
SBR Specimen Exam
No ratings yet
SBR Specimen Exam
10 pages
SAP Organisation Structure
100% (1)
SAP Organisation Structure
23 pages
Basic Accounting Terms PPT Grade 11
No ratings yet
Basic Accounting Terms PPT Grade 11
26 pages
Jewellery Marketing Case Study Shivamogga
No ratings yet
Jewellery Marketing Case Study Shivamogga
62 pages
Business Plan for Golden Smart-MS Café
No ratings yet
Business Plan for Golden Smart-MS Café
24 pages
Steel Supply Chain Project
No ratings yet
Steel Supply Chain Project
21 pages
Buyers-Seller Relationship in B2b
No ratings yet
Buyers-Seller Relationship in B2b
25 pages
Sana Safinaz: Marketing Report On
No ratings yet
Sana Safinaz: Marketing Report On
13 pages
Levis
No ratings yet
Levis
2 pages
Screener Excel
No ratings yet
Screener Excel
15 pages
Marketing Strategy Literature Review Guide
100% (3)
Marketing Strategy Literature Review Guide
7 pages
Tesco Strategy and Challenges Report
No ratings yet
Tesco Strategy and Challenges Report
20 pages
Untitled
No ratings yet
Untitled
667 pages
Retail Flipping
No ratings yet
Retail Flipping
160 pages
Comprehensive Job Analysis Guide
No ratings yet
Comprehensive Job Analysis Guide
4 pages
Security Analysis & Portfolio Management
No ratings yet
Security Analysis & Portfolio Management
3 pages
BBA 5th Semester Dec 2023
No ratings yet
BBA 5th Semester Dec 2023
18 pages
Europe Caseins & Caseinates Market 2021
No ratings yet
Europe Caseins & Caseinates Market 2021
7 pages
ch.4 Managerial Accounting 17e
No ratings yet
ch.4 Managerial Accounting 17e
13 pages
FA2 SampleNotes
No ratings yet
FA2 SampleNotes
15 pages
Stcs (Scotland) LTD Annual Report and Unaudited Accounts For The Year Ended 31 January 2020
No ratings yet
Stcs (Scotland) LTD Annual Report and Unaudited Accounts For The Year Ended 31 January 2020
11 pages
Panera Bread LBO Model Analysis
No ratings yet
Panera Bread LBO Model Analysis
167 pages
Chapter 3 Accounting Question Review
No ratings yet
Chapter 3 Accounting Question Review
10 pages