0% found this document useful (0 votes)
12 views27 pages

Master Balance Sheet

The document contains financial projections for a company, including a profit and loss account, balance sheet analysis, and comments on financial indicators from 2023 to 2033. All financial figures are currently listed as zero, indicating no sales, costs, or liabilities projected for the period. The analysis includes various components such as gross sales, net sales, costs of production, and working capital assessments.
Copyright
© © All Rights Reserved
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)
12 views27 pages

Master Balance Sheet

The document contains financial projections for a company, including a profit and loss account, balance sheet analysis, and comments on financial indicators from 2023 to 2033. All financial figures are currently listed as zero, indicating no sales, costs, or liabilities projected for the period. The analysis includes various components such as gross sales, net sales, costs of production, and working capital assessments.
Copyright
© © All Rights Reserved
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
You are on page 1/ 27

INDEX

PROFIT & LOSS ACCOUNT

BALANCE SHEET ANALYSIS- ASSETS

BALANCE SHEET ANALYSIS- LIABILITY

FINANCIAL INDICATORS

MPBF

LONG/SHORT TERM USES

LONG/SHORT TERM SOURCES

COMMENTS ON FINANCIAL INDICATORS


ANNEXURE - IV
ANALYSIS OF PROFIT AND LOSS ACCOUNT
PROJ PROJ PROJ PROJ PROJ
2023 2024 2025 2026 2027

1 Gross Sales
i. Domestic Sales
ii. Export sales
Gross sales 0.00 0.00 0.00 0.00 0.00
2 Less: Excise duty
3 Net sales 0.00 0.00 0.00 0.00 0.00
4 % Rise or fall in net
sales over previous yr. #DIV/0! #DIV/0! #DIV/0! #DIV/0!
5 Cost of Sales
i. Raw materials
(Including Stores & Spares)
a. Imported
b. Indigenous
ii. Other spares
a. Imported
b. Indigenous
iii. Power & Fuel
iv. Direct Labour
v. Reapirs & Maintenance
vi. Other Mfg. Expenses
vii. Depreciation
viii. Sub Total (I to vii) 0.00 0.00 0.00 0.00 0.00
ix. Add Op. WIP
Sub Total 0.00 0.00 0.00 0.00 0.00
x. Less Cl. WIP
xi. COST OF PRODUCTION 0.00 0.00 0.00 0.00 0.00
xii. Add Op. F.G. 0.00 0.00 0.00 0.00
Sub Total 0.00 0.00 0.00 0.00 0.00
xiii. Less Cl F.G.
xiv. COST OF SALES 0.00 0.00 0.00 0.00 0.00
6 Gross Profit 0.00 0.00 0.00 0.00 0.00
7 Selling, Gen & Admn. Exp.
8 Interest
9 Sub Total (5+7+8) 0.00 0.00 0.00 0.00 0.00
10 Operating Profit 0.00 0.00 0.00 0.00 0.00
11 i. Add Oth. Non Op. Income
a.
b.
Sub Total 0.00 0.00 0.00 0.00 0.00
ii. Deduct Oth. Non Op. Expenses
a.
b.
Sub Total 0.00 0.00 0.00 0.00 0.00
iii. Net Non Op. Income 0.00 0.00 0.00 0.00 0.00
12 Profit before taxes 0.00 0.00 0.00 0.00 0.00
13 Provision for taxes
14 Net Profit / loss 0.00 0.00 0.00 0.00 0.00
15 a. Dividend
b. Dividend rate
16 Retained Profit 0.00 0.00 0.00 0.00 0.00
17 Retained profit/Net Profit(%) #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
PROJ PROJ PROJ
2028 2029 2030

0.00 0.00 0.00

0.00 0.00 0.00

#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.00 0.00 0.00

0.00 0.00 0.00

0.00 0.00 0.00


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

ANALYSIS OF BALANCE SHEET


PARTICULARS PROJ PROJ PROV PROJ PROJ PROJ
LIABILITIES 2023 2024 2025 2026 2027 2028
SHARE HOLDERS FUNDS
Capital
Reserves - General
Reserves - Others
Revaluation Resvers
P & L Account ( Profit ) 0.00 0.00 0.00 0.00 0.00 0.00
Drawing
SUB TOTAL 0.00 0.00 0.00 0.00 0.00 0.00
TERM LIABILITIES
Term Loan - Banks
Term Loan - F.I.s
Deposits payable after one year
Deferred payment Credits
Advances from Dealers
Term Deposits
Debentures
Other Term Liabilities
SUB TOTAL 0.00 0.00 0.00 0.00 0.00 0.00
CURRENT LIABILITIES
Bank Borrowings
Borrowings - Associates
- Directors
- Others
Deposits from dealers
Advance payment from dealers
Creditors - for goods
- Others
Provisions - for tax
- for dividend
- Others
Interest payable
Installments payable in 12 months
Other Current Liabilities
SUB TOTAL 0.00 0.00 0.00 0.00 0.00 0.00

GRAND TOTAL 0.00 0.00 0.00 0.00 0.00 0.00


PROJ PROJ
2029 2030

0.00 0.00

0.00 0.00
115 0.00 0.00 0.00 0.00 0.00
115.00 0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00 0.00

0.00 0.00

0.00 0.00

0.00 0.00
0.00 0.00 0.00 0.00
0.00 0.00 0.00
0.00 0.00 0.00
0

ANALYSIS OF BALANCE SHEET


PARTICULARS PROJ PROJ PROV PROJ PROJ PROJ
ASSETS 2023 2024 2025 2026 2027 2028
FIXED ASSETS
Opening WDV
Addition
Gross Block
Less: Depreciation 0.00 0.00 0.00 0.00 0.00 0.00
Net Block 0.00 0.00 0.00 0.00 0.00 0.00
Capital W.I.P.
Advances for Capital Goods
SUB TOTAL 0.00 0.00 0.00 0.00 0.00 0.00
NON CURRENT ASSETS
Investment in other companies
Deferred receivables
Others
Good will / Misc. expenditure
P & L Account ( Loss )
SUB TOTAL 0.00 0.00 0.00 0.00 0.00 0.00
CURRENT ASSETS
Raw Material - Imported
- Indigenous
Work in progress
Finished Goods
Stores and Spares/Consumables
Debtors < 6 months
Exports
Local
Debtors > 6 months
Exports
Local
Loans and Advances
Associate companies
Advance payment of taxes
Advances to suppliers
Deposits
Cash & Bank Balances
Other current assets
SUB TOTAL 0.00 0.00 0.00 0.00 0.00 0.00

GRAND TOTAL 0.00 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 0.00 0.00


0.00 0.00 0.00 0.00 0.00 0.00
PROJ PROJ
2029 2030

0.00 0.00
0.00 0.00

0.00 0.00

0.00 0.00

0.00 0.00

0.00 0.00

0.00 0.00
0.00 0.00
0
COMMENTS ON WC ASSESSMENT AND COMPUTATION OF
MAXIMUM PERMISSIBLE BANK FINANCE
PROJ PROJ PROJ PROJ PROJ PROJ
2023 2024 2025 2026 2027 2028

Gross Sales 0.00 0.00 0.00 0.00 0.00 0.00


Net sales 0.00 0.00 0.00 0.00 0.00 0.00
% Rise or fall in net #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Raw materials 0.00 0.00 0.00 0.00 0.00 0.00
(Including Stores & Spares)
Imported 0.00 0.00 0.00 0.00 0.00 0.00
Indigenous 0.00 0.00 0.00 0.00 0.00 0.00
Stores and Spares 0.00 0.00 0.00 0.00 0.00 0.00
COST OF PRODUCTION 0.00 0.00 0.00 0.00 0.00 0.00
COST OF SALES 0.00 0.00 0.00 0.00 0.00 0.00
NWC 0.00 0.00 0.00 0.00 0.00 0.00

CURRENT ASSETS
Raw Material - Imported 0.00 0.00 0.00 0.00 0.00 0.00
- Indigenous 0.00 0.00 0.00 0.00 0.00 0.00
Work in progress 0.00 0.00 0.00 0.00 0.00 0.00
Finished Goods 0.00 0.00 0.00 0.00 0.00 0.00
Stores and Spares 0.00 0.00 0.00 0.00 0.00 0.00
Debtors & receivables
Exports 0.00 0.00 0.00 0.00 0.00 0.00
Local 0.00 0.00 0.00 0.00 0.00 0.00
Other current assets 0.00 0.00 0.00 0.00 0.00 0.00
TOTAL CURRENT ASSETS 0.00 0.00 0.00 0.00 0.00 0.00

CURRENT LIABILITIES
Sundry Creditors 0.00 0.00 0.00 0.00 0.00 0.00
Other Current Liabilities 0.00 0.00 0.00 0.00 0.00 0.00
TOTAL CURRENT LIABILITIES 0.00 0.00 0.00 0.00 0.00 0.00

WC GAP 0.00 0.00 0.00 0.00 0.00 0.00


25% of CA Excl. Export rece. 0.00 0.00 0.00 0.00 0.00 0.00
Actual / Projected NWC 0.00 0.00 0.00 0.00 0.00 0.00
MPBF 0.00 0.00 0.00 0.00 0.00 0.00
Actual / Projected bk. Borrowin 0.00 0.00 0.00 0.00 0.00 0.00
Excess Finance 0.00 0.00 0.00 0.00 0.00 0.00
PROJ PROJ PROJ PROJ PROJ
2029 2030 2031 2032 2033

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

0.00 0.00 0.00 0.00 0.00


0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 0.00


0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 0.00


0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 0.00


0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 0.00


0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00
COMMENTS ON FINANCIAL INDICATORS AS ON 2024

1 Capital has decreased to 0.00 lacs during the current year compared to

2 Reserves has decreased to 0.00 lacs during the current year.

3 Net worth has decreased to 0.00 lacs during the current year
compared to previous year 2023 FALSE
4 Net working capital decreased to 0.00 lacs compared to previous year

5 The Current Ratio has #NAME? #NAME? #NAME?

6 Net sales has decreased to 0.00 compared to previous sales of Rs.

7 Debt Equity ratio has #NAME? #NAME? during the current year compared to previous year

COMMENTS ON FINANCIAL INDICATORS AS ON 2025

1 Capital has decreased to 0.00 lacs during the current year compared to

2 Reserves has decreased to 0.00 lacs during the current year

3 Net worth has decreased to 0.00 lacs during the current year
compared to previous year 2024 FALSE
4 Net working capital decreased to 0.00 lacs compared to previous year

5 The Current Ratio has #NAME? #NAME? #NAME?

6 Net sales has decreased to 0.00 compared to previous sales of Rs.

7 Debt Equity ratio has #NAME? #NAME? during the current year compared to previous year
2023

0.00 lacs

2024

0.00 lacs
Miscellaneous

Capital has
Reserves has
Net worth has
Net working capital
The Current Ratio has
Net sales has
Debt Equity ratio has
lacs
increased by
decreased by
increased to
decreased to
over previous year
during the current year
due to plough back of profit into the system
which is below the benchmark level of 1.33
which is above the benchmark level
compared to previous sales of Rs.
compared to previous year
during the current year compared to
FUND FLOW ANALYSIS PROJ PROJ PROJ PROJ PROJ PROJ PROJ PROJ PROJ PROJ
USES 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033
Increase in
Gross Block 0 0 0 0 0 0 0 0 0 0
Capital W.I.P. 0 0 0 0 0 0 0 0 0 0
Advances for Capital Goods 0 0 0 0 0 0 0 0 0 0
Investment in other companies 0 0 0 0 0 0 0 0 0 0
Deferred receivables 0 0 0 0 0 0 0 0 0 0
Others 0 0 0 0 0 0 0 0 0 0
Good will / Misc. expenditure 0 0 0 0 0 0 0 0 0 0
P & L Account ( Loss ) 0 0 0 0 0 0 0 0 0 0
Dividend
Decrease in
Capital 0 0 0 0 0 0 0 0 0 0
Reserves - General 0 0 0 0 0 0 0 0 0 0
Reserves - Others 0 0 0 0 0 0 0 0 0 0
Term Loan - Banks 0 0 0 0 0 0 0 0 0 0
Term Loan - F.I.s 0 0 0 0 0 0 0 0 0 0
Deposits payable after one year 0 0 0 0 0 0 0 0 0 0
Deferred payment Credits 0 0 0 0 0 0 0 0 0 0
Advances from Dealers 0 0 0 0 0 0 0 0 0 0
Term Deposits 0 0 0 0 0 0 0 0 0 0
Debentures 0 0 0 0 0 0 0 0 0 0
Other Term Liabilities 0 0 0 0 0 0 0 0 0 0
LONG TERM USES 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00

Increase in
Raw Material - Imported 0 0 0 0 0 0 0 0 0 0
- Indigenous 0 0 0 0 0 0 0 0 0 0
Work in progress 0 0 0 0 0 0 0 0 0 0
Finished Goods 0 0 0 0 0 0 0 0 0 0
Stores and Spares 0 0 0 0 0 0 0 0 0 0
Debtors<6months 0 0 0 0 0 0 0 0 0 0
Export 0 0 0 0 0 0 0 0 0 0
Local 0 0 0 0 0 0 0 0 0 0
Debtors>6months 0 0 0 0 0 0 0 0 0 0
Export 0 0 0 0 0 0 0 0 0 0
Local 0 0 0 0 0 0 0 0 0 0
Loans and Advances 0 0 0 0 0 0 0 0 0 0
Associate companies 0 0 0 0 0 0 0 0 0 0
Advnace payment of taxes 0 0 0 0 0 0 0 0 0 0
Advances to suppliers 0 0 0 0 0 0 0 0 0 0
Deposits 0 0 0 0 0 0 0 0 0 0
Cash & Balances 0 0 0 0 0 0 0 0 0 0
Other current assets 0 0 0 0 0 0 0 0 0 0
Decrease in
Bank Borrowings 0 0 0 0 0 0 0 0 0 0
Borrowings - Associates 0 0 0 0 0 0 0 0 0 0
- Directors 0 0 0 0 0 0 0 0 0 0
- Others 0 0 0 0 0 0 0 0 0 0
Deposits from dealers 0 0 0 0 0 0 0 0 0 0
Advance payment from dealers 0 0 0 0 0 0 0 0 0 0
Creditors - for goods 0 0 0 0 0 0 0 0 0 0
- Others 0 0 0 0 0 0 0 0 0 0
Provisions - for tax 0 0 0 0 0 0 0 0 0 0
- for dividend 0 0 0 0 0 0 0 0 0 0
- Others 0 0 0 0 0 0 0 0 0 0
Interest payable 0 0 0 0 0 0 0 0 0 0
Installments payable in 12 months 0 0 0 0 0 0 0 0 0 0
Other Current Liabilities 0 0 0 0 0 0 0 0 0 0
SHORT TERM USES 0 0 0 0 0 0 0 0 0 0
TOTAL USES 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00

PROJ PROJ PROJ PROJ PROJ PROJ PROJ PROJ PROJ PROJ
2024 2025 2026 2027 2028 2029 2030 2031 2032 2033

Long Term Sources 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Less: Long Term Uses 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Long Term Surplus / deficit 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00

Short Term Sources 0 0 0 0 0 0 0 0 0 0


Less: Short Term Uses 0 0 0 0 0 0 0 0 0 0
Short Term Surplus / deficit 0 0 0 0 0 0 0 0 0 0

Long Term Surplus / deficit 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Add : Previous NWC 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Current NWC 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00

If Current NWC is correct say TRUE 1 1 1 1 1 1 1 1 1 1


Decrease in Depreciation 0 0 0 0 0 0 0 0 0 0
Decrease in P&L(Profit) 0 0 0 0 0 0 0 0 0 0
0
2034

0
0
0
0
0
0
0
0

0
0
0
0
0
0
0
0
0
0
0
0.00

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

0.00
2034

0.00
0.00
0.00

0
0
0

0.00
0.00
0.00

TRUE
0
0
FUND FLOW ANALYSIS
SOURCES 2024 2025 2026 2027 2028 2029 2030 2031 2032
Net Profit before taxes
Provision for taxes
Net Profit / loss
Add Depreciation
Funds Generated
Increase in
Depreciation 0 0 0 0.00 0.00 0.00 0.00 0.00 0.00
Capital 0 0 0 0.00 0.00 0.00 0.00 0.00 0.00
Reserves - General 0 0 0 0.00 0.00 0.00 0.00 0.00 0.00
Reserves - Others 0 0 0 0.00 0.00 0.00 0.00 0.00 0.00
Revaluation Reserve 0 0 0 0.00 0.00 0.00 0.00 0.00 0.00
P&L a/c (Profit) 0 0 0 0.00 0.00 0.00 0.00 0.00 0.00
Term Loan - Banks 0 0 0 0.00 0.00 0.00 0.00 0.00 0.00
Term Loan - F.I.s 0 0 0 0.00 0.00 0.00 0.00 0.00 0.00
Deposits payable after one year 0 0 0 0.00 0.00 0.00 0.00 0.00 0.00
Deferred payment Credits 0 0 0 0.00 0.00 0.00 0.00 0.00 0.00
Advances from Dealers 0 0 0 0.00 0.00 0.00 0.00 0.00 0.00
Term Deposits 0 0 0 0.00 0.00 0.00 0.00 0.00 0.00
Debentures 0 0 0 0.00 0.00 0.00 0.00 0.00 0.00
Other Term Liabilities 0 0 0 0.00 0.00 0.00 0.00 0.00 0.00
Decrease in
Gross Block 0 0 0 0.00 0.00 0.00 0.00 0.00 0.00
Capital W.I.P. 0 0 0 0.00 0.00 0.00 0.00 0.00 0.00
Advances for Capital Goods 0 0 0 0.00 0.00 0.00 0.00 0.00 0.00
Investment in other companies 0 0 0 0.00 0.00 0.00 0.00 0.00 0.00
Deferred receivables 0 0 0 0.00 0.00 0.00 0.00 0.00 0.00
Others 0 0 0 0.00 0.00 0.00 0.00 0.00 0.00
Good will / Misc. expenditure 0 0 0 0.00 0.00 0.00 0.00 0.00 0.00
P & L Account ( Loss ) 0 0 0 0.00 0.00 0.00 0.00 0.00 0.00
LONG TERM SOURCES 0 0 0 0 0 0 0 0 0

Increase in
Bank Borrowings 0 0 0 0.00 0.00 0.00 0.00 0.00 0.00
Borrowings - Associates 0 0 0 0.00 0.00 0.00 0.00 0.00 0.00
- Directors 0 0 0 0.00 0.00 0.00 0.00 0.00 0.00
- Others 0 0 0 0.00 0.00 0.00 0.00 0.00 0.00
Deposits from dealers 0 0 0 0.00 0.00 0.00 0.00 0.00 0.00
Advance payment from dealers 0 0 0 0.00 0.00 0.00 0.00 0.00 0.00
Creditors - for goods 0 0 0 0.00 0.00 0.00 0.00 0.00 0.00
- Others 0 0 0 0.00 0.00 0.00 0.00 0.00 0.00
Provisions - for tax 0 0 0 0.00 0.00 0.00 0.00 0.00 0.00
- for dividend 0 0 0 0.00 0.00 0.00 0.00 0.00 0.00
- Others 0 0 0 0.00 0.00 0.00 0.00 0.00 0.00
Interest payable 0 0 0 0.00 0.00 0.00 0.00 0.00 0.00
Installments payable in 12 months 0 0 0 0.00 0.00 0.00 0.00 0.00 0.00
Other Current Liabilities 0 0 0 0.00 0.00 0.00 0.00 0.00 0.00

Decrease in
Raw Material - Imported 0 0 0 0.00 0.00 0.00 0.00 0.00 0.00
- Indigenous 0 0 0 0.00 0.00 0.00 0.00 0.00 0.00
Work in progress 0 0 0 0.00 0.00 0.00 0.00 0.00 0.00
Finished Goods 0 0 0 0.00 0.00 0.00 0.00 0.00 0.00
Stores and Spares 0 0 0 0.00 0.00 0.00 0.00 0.00 0.00
Debtors<6months 0 0 0 0.00 0.00 0.00 0.00 0.00 0.00
Export 0 0 0 0.00 0.00 0.00 0.00 0.00 0.00
Local 0 0 0 0.00 0.00 0.00 0.00 0.00 0.00
Debtors>6months 0 0 0 0.00 0.00 0.00 0.00 0.00 0.00
Export 0 0 0 0.00 0.00 0.00 0.00 0.00 0.00
Local 0 0 0 0.00 0.00 0.00 0.00 0.00 0.00
Loans and Advances 0 0 0 0.00 0.00 0.00 0.00 0.00 0.00
Associate companies 0 0 0 0.00 0.00 0.00 0.00 0.00 0.00
Advance payment of taxes 0 0 0 0.00 0.00 0.00 0.00 0.00 0.00
Advances to suppliers 0 0 0 0.00 0.00 0.00 0.00 0.00 0.00
Deposits 0 0 0 0.00 0.00 0.00 0.00 0.00 0.00
Cash & Balances 0 0 0 0.00 0.00 0.00 0.00 0.00 0.00
Other current assets 0 0 0 0.00 0.00 0.00 0.00 0.00 0.00
SHORT TERM SOURCES 0 0 0 0 0 0 0 0 0
TOTAL SOURCES 0 0 0 0 0 0 0 0 0
2033 2034

0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00

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

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

Holding levels ( in months )


PROJ PROJ PROJ PROJ PROJ PROJ PROJ
2023 2024 2025 2026 2027 2028 2029

Raw Material #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!


Work in Progress #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Finished goods #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Receivables #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Creditors for goods #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!

Purchases 0.00 0.00 0.00 0.00 0.00 0.00 0.00

FINANCIAL INDICATORS PROJ PROJ PROJ PROJ PROJ PROJ PROJ


2023 2024 2025 2026 2027 2028 2029

Capital 0.00 0.00 0.00 0.00 0.00 0.00 0.00


Reserves & Surplus 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Intangible assets/accumulated
losses 0.00 0.00 0.00 0.00 0.00 0.00 0.00
TNW 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Long Term Loan from Banks/FIs 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Debentures/Bonds/FCCB etc. 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Unsecured Loans 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Total Capital Funds 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Current Assets 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Current Liabilities 0.00 0.00 0.00 0.00 0.00 0.00 0.00
NWC 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Gross Block 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Net Block 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Investment 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Non-Current Assets 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Net Sales 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Net Sales of which exports 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Other Income 0.00 0.00 0.00 0.00 0.00 0.00 0.00
PBDIT 0.00 0.00 0.00 0.00 0.00 0.00 0.00
NPBT/(loss) 0.00 0.00 0.00 0.00 0.00 0.00 0.00
NPAT/Loss) 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Net Profit/Capital Employed (%) #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Interest 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Depreciation 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Cash Accruals 0.00 0.00 0.00 0.00 0.00 0.00 0.00
RATIOS
Current Ratio #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
TOL:TNW #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
DER #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
PBDIT:Net Sales #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
NPBT:NS(%) #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Term Debt/PBDIT #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
PBDIT/Interest #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
PAT/Equity (Return on Equity) #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Inventory Turnover #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Debtors Velocity #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Creditors Velocity #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Inventory + Receivables - Bills
Discounted/Sales #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
FATR #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!
PROJ
2030

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

0.00

PROJ
2030

0.00
0.00

0.00
0.00
0.00
0.00
0.00
0.00
0.00
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!
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!
#DIV/0!
#DIV/0!
#DIV/0!
Turnover Method 2023 2024 2025 2026.00 2027 2028
SALES 0.00 0.00 0.00 0.00 0.00 0.00
25% of the sales 0 0 0 0.00 0 0
Margin 5 % 0 0 0 0.00 0 0
NWC 0.00 0.00 0.00 0.00 0.00 0.00
MPBF 0.00 0.00 0.00 0.00 0.00 0.00

MPBF METHOD 2023 2024 2025 2026.00 2027 2028


CA 0.00 0.00 0.00 0.00 0.00 0.00
25% of CA 0.00 0.00 0.00 0.00 0.00 0.00
CL other than bank 0.00 0.00 0.00 0.00 0.00 0.00
NWC 0.00 0.00 0.00 0.00 0.00 0.00
2029 2030
0.00 0.00
0 0
0 0
0.00 0.00
0.00 0.00

2029 2030
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00

You might also like