Project Report

Download as xls, pdf, or txt
Download as xls, pdf, or txt
You are on page 1of 19

I.

OPERATING STATEMENT (To be filled by the Dealing Group from Balance Sheet / Projections)

2021-22 2022-23 2023-24


I. PROFIT AND LOSS ACCOUNT
Projection Projection Projection
SALES:
1. Domestic Sales
- Lead Acid Battery Riksha 136,080,000.00 171,460,800.00 219,542,400.00
- Lithium Battery Riksha 25,515,000.00 32,148,900.00 41,580,000.00
GROSS SALES: 161,595,000.00 203,609,700.00 261,122,400.00
Less: GST @ 5% 7,695,000.00 9,695,700.00 12,434,400.00
Add: Other Operating Income - - -
NET SALES: 153,900,000.00 193,914,000.00 248,688,000.00
Increase in Net Sales (%) 26.00% 28.25%
COST OF SALES:
1. Chassis Body Purchased 27,750,000.00 34,020,000.00 43,659,000.00
2. Under Chassis Kit Puchased 37,000,000.00 45,360,000.00 58,212,000.00
3. Lead Acid Batteries Purchased 52,320,000.00 65,318,400.00 83,825,280.00
4. Lithium Batteries Purchased 14,800,000.00 18,144,000.00 23,284,800.00
5. Seats, Roof, Nut bolts etc 6,475,000.00 7,938,000.00 10,187,100.00
6. Lead Acid Battery Charger 5,927,400.00 7,266,672.00 9,325,800.00
7. Direct Labour 1,800,000.00 2,268,000.00 2,910,600.00
8. Rent 600,000.00 630,000.00 661,500.00
9. Electricity 360,000.00 378,000.00 396,900.00

SUB TOTAL: 147,032,400.00 181,323,072.00 232,462,980.00


Add: Opening Stock of Raw Material - 2,965,200.00 3,113,460.00
Less: Closing Stock of Raw Material 2,965,200.00 3,113,460.00 3,269,133.00
COST OF PRODUCTION: 144,067,200.00 181,174,812.00 232,307,307.00
COP as % of Gross Sales 89.15% 88.98% 88.96%
Add: Opening Stock of Finished Goods - - -
Less: Closing Stock of Finished Goods -
COST OF SALES: 144,067,200.00 181,174,812.00 232,307,307.00
Cost of Sales as % of Gross Sales 89.15% 88.98% 88.96%
Selling, General & Admn. Expenses:
A. Depreciation 177,700.00 141,045.00 114,488.25
B. Salary Expenses 960,000.00 1,008,000.00 1,058,400.00
C. Travelling & Conveyance Expenses 360,000.00 378,000.00 396,900.00
D. Insurance premium 21,416.00 22,486.80 23,611.14
E. Printing & Stationery Expenses 240,000.00 252,000.00 264,600.00
F. Warranty Expenses 769,500.00 969,480.00 969,480.00
G. Misc Expenses 600,000.00 630,000.00 661,500.00
H. Other Expenses 180,000.00 189,000.00 198,450.00
I. Office Expenses 120,000.00 126,000.00 132,300.00

PROFIT BEFORE INTT. & TAX (PBIT) 6,404,184.00 9,023,176.20 12,560,963.61


PBIT as % of Gross Sales 3.96% 4.43% 4.81%
Interest & Other Financial Charges 558,215.64 459,742.19 348,779.84
Intt. & Fin. Charges as % of Sales 0.35% 0.23% 0.13%
OP. PROFIT BEFORE TAX (OPBT) 5,845,968.36 8,563,434.01 12,212,183.77
OPBT as % of Gross Sales 3.62% 4.21% 4.68%
Add: Other Non-operative Income
1. Interest & Dividend - - -
2. Exchange Profit / Export Incentives - - -
3. Excess Provision Written Back - - -
4. Profit on Sale of Assets - - -
5. Sale of Scrap / other misc income - - -
SUB-TOTAL (INCOME) - - -
Less: Other Non-operating Expenses
1. Loss on Investment - - -
2. Loss on Forex - - -
3. Loss on Sale of Fixed Assets - - -
4. Bad Debts Written Off - - -
5. Miscellaneous Expenses Written Off - - -
SUB-TOTAL (EXPENSES) - - -
PROFIT BEFORE TAX / LOSS 5,845,968.36 8,563,434.01 12,212,183.77
Tax Paid 1,823,942.13 2,671,791.41 3,810,201.34

Deferred Tax Liability/(Deffered Tax Asset) - - -


Provision for Taxes - - -
NET PROFIT / LOSS (PAT) 4,022,026.23 5,891,642.60 8,401,982.43
PAT as % of Gross Sales 2.49% 2.89% 3.22%
Equity / Preference Dividend Paid:
1. Dividend paid - - -
2. Preference Dividend - - -
RETAINED PROFIT 4,022,026.23 5,891,642.60 8,401,982.43
II. LIABILITIES (To be filled by the Dealing Group from Balance Sheet / Projections)
2021-22 2022-23 2023-24
II. BALANCE SHEET - LIABILITIES
Projection Projection Projection
CURRENT LIABILITIES (CL):
Short Term borrowings from banks (including bill
purchased/discounted)
1. from applicant bank 874,924.67 985,887.02 1,110,922.17
2. from other banks
(Out of Total Bank Borrowings - BP & BD) - - -
SUB-TOTAL 874,924.67 985,887.02 1,110,922.17
1. Short Term Borrowings from others incl. CPs - - -
2. Sundry Creditors (Trade) - - -
3. Advance Payment from Customers / Deposit from
- - -
Dealers
4. Provision for Taxation - - -
5. Dividend payable - - -
6. Other Stat.Liabilities (due within 1 yr.) - - -
7. Instalments of TLs / Debentures / Pref.Shares / DPGs /
- - -
Deposits / Unsecured Loans etc. (due within 1 yr.)
8. Other CL & Provisions (due within one year) - - -
9. Interest accrued bot not due - - -
10. Dues to Directors - - -
11. Security Deposit - Suppliers & Contractors - - -
12. Other Current Liabilities - - -
SUB-TOTAL - - -
TOTAL CURRENT LIABILITIES 874,924.67 985,887.02 1,110,922.17
TERM LIABILITIES
1. Debentures (not maturing within 1 yr.) - - -
2. Preference Shares (redeemable with residual tenor for
- - -
>1 yr. & <5 yrs.)

3. Term Loans (Excluding installments payable within 1 yr.) 3,348,624.10 2,362,737.08 1,251,814.91

4. Term Deposits (repayable after 1 yr.) - - -


5. Unsec.Loans (repayable after 1 yr.) - - -
6. Mobilisation Adv. (repayable after 1 yr.) - - -
7. Sundry Creditors for Capital Goods - - -
8. Deferred Sales Tax - - -
9. Deferred Tax Liability - - -
10 - - -
TOTAL TERM LIABILITIES 3,348,624.10 2,362,737.08 1,251,814.91

1. Ordinary Share Capital 1,700,000.00 5,722,026.23 11,613,668.83


2. Pref.Share Cap.(Residual tenor >5 yrs.) - - -
3. General Reserve - - -
4. Capital Reserve - - -
5. Surplus(+) or deficit(-) in P&L Account 4,022,026.23 5,891,642.60 8,401,982.43
6. Share Application Money - - -
7. Share Premium - - -
8. Capital Redemption Reserve - - -
9. Quasi Equity - - -
10. Less: Revaluation Reserve - - -
NET WORTH 5,722,026.23 11,613,668.83 20,015,651.27
TOTAL LIABILITIES 9,945,575.01 14,962,292.94 22,378,388.35
III. ASSETS (To be filled by the Dealing Group from Balance Sheet / Projections)
2021-22 2022-23 2023-24
II. BALANCE SHEET - ASSETS
Projection Projection Projection
CURRENT ASSETS
Cash and Bank Balances 3,642,325.01 8,418,412.94 15,473,808.60
Short Term unencumbered Investments (Other than
- - -
Long Term)
1. Government and other securities - - -
2. Fixed Deposits with banks - - -
RECEIVABLES 897,750.00 1,131,165.00 1,450,680.00
3. Domestic Sales 897,750.00 1,131,165.00 1,450,680.00
4. Export Receivables (incl. contingent B/P & Discounted by
- - -
banks)
INVENTORY 2,965,200.00 3,113,460.00 3,269,133.00
7. Raw Material - Indigenous 2,965,200.00 3,113,460.00 3,269,133.00
8. Raw Material - Imported - - -
9. Consumables Spares - Indigenous - - -
10. Consumables Spares - Imported - - -
11. Stock in process - - -
12. Finished Goods - - -
13. Goods in Transit - - -
14. Closing Stock of Traded goods - - -
15 - - -
OTHER CURRENT ASSETS - - -
16. Deposits - - -
17. Duties & Taxes paid in Advance - - -
18. Others (receivables within 1 yr.) - - -
19. Advance to suppliers of Raw Material - - -
20 - - -
TOTAL CURRENT ASSETS 7,505,275.01 12,663,037.94 20,193,621.60
GROSS FIXED ASSETS (GFA) 1,118,000.00 940,300.00 799,255.00
1. Land - - -
2. Building - - -
3. Plant & Machinery 718,000.00 580,300.00 475,255.00
4. Furnitures & Fixtures 400,000.00 360,000.00 324,000.00
5. Other Fixed Assets
6. Capital Works in progress - - -
Less: Depreciation on FA 177,700.00 141,045.00 114,488.25
Less: Revaluation Reserves, if any - - -
NET BLOCK 940,300.00 799,255.00 684,766.75
NON CURRENT ASSETS
1. Investments in Subsidiary/Affiliates Cos. - - -
2. Other Investments - - -
3. Loans & Advances to Subsidiary / Affiliates / Associates
- - -
Companies
4. Advance to suppliers of Capital Goods / Contractors - - -
5. Deferred receivables (maturity >1 yr.) - - -
6. Margin money kept with banks. - - -
7. Debtors exceedings six months - - -
8. Long Term Deposits - -
9. Non-consumables stores & spares - - -

10. Other Non Current Assets including dues from directors - - -

TOTAL NON CURRENT ASSETS - - -


Intangible Assets (deferred tax assets, patents, goodwill,
preliminary expenses, bad/doubtful expenses not provided 1,500,000.00 1,500,000.00 1,500,000.00
for, etc. to the extent not written off)
TOTAL ASSETS 9,945,575.01 14,962,292.94 22,378,388.35
TOTAL LIABILITIES less TOTAL ASSETS - - -
IV. WORKING CAPITAL ASSESSMENT (Auto generated and hence not required to be filled)
2021-22 2022-23 2023-24
BUILD UP OF CURRENT ASSETS
Projection Projection Projection
Raw Material - Indigenous 2,965,200.00 3,113,460.00 3,269,133.00
Month's Consumption 1.28 1.10 0.90
Raw Material - Imported - - -
Month's Consumption - - -
Consumable Spares - Indigenous - - -
Month's Consumption - - -
Consumable Spares - Imported - - -
Month's Consumption - - -
Stock in Process - - -
Month's Cost of Production - - -
Finished Goods - - -
Month's Cost of Sales - - -
Receivables (Domestic) other than deferred & exports
897,750.00 1,131,165.00 1,450,680.00
(including bills purchased & discounted by banks)
Month's Domestic Sales #DIV/0! #DIV/0! #DIV/0!
Export Receivables (including bills purchased & discounted
- - -
by banks)
Month's Export Sales - - -

2021-22 2022-23 2023-24


BUILD UP OF CURRENT LIABILITIES
Projection Projection Projection
Trade Ceditors - - -
Month's Trade Creditors - - -

2021-22 2022-23 2023-24


III. CALCUATION OF ASSESSED BANK FINANCE (ABF)
Projection Projection Projection
1. Total Current Assets 7,505,275.01 12,663,037.94 20,193,621.60
2. Other Current Liabilities (Other than Bank Borrowings &
- - -
TL Instalments due within one Year)
3. Working Capital Gap 7,505,275.01 12,663,037.94 20,193,621.60
4. Minimum stipulated Net Working Capital (NWC) (25% of
1,876,318.75 3,165,759.48 5,048,405.40
Total Current Assets excluding Export Receivables)
5. Actual / Projected NWC 6,630,350.34 11,677,150.92 19,082,699.43
6. Item 3 Minus Item 4 5,628,956.26 9,497,278.45 15,145,216.20
7. Item 3 Minus Item 5 874,924.67 985,887.02 1,110,922.17
8. MPBF (lower of 6 or 7 ) 874,924.67 985,887.02 1,110,922.17
9. Excess borrowings representing Shortfall in NWC NIL NIL NIL
V. SUMMARY OF FINANCIAL POSITION (Auto generated and hence not required to be filled)
2021-22 2022-23 2023-24
IV. STATEMENT OF FINANCIAL ANALYSIS
Projection Projection Projection
A. PROFILE ANALYSIS
Total Assets (Tangible) 8,445,575.01 13,462,292.94 20,878,388.35
Total Outside Liabilities (TOL) 4,223,548.78 3,348,624.10 2,362,737.08
Tangible Networth (TNW) 4,222,026.23 10,113,668.83 18,515,651.27
Net Sales 153,900,000.00 193,914,000.00 248,688,000.00
PBDIT 6,581,884.00 9,164,221.20 12,675,451.86
Operating Profits (OPBT) 5,845,968.36 8,563,434.01 12,212,183.77
Net Profit 4,022,026.23 5,891,642.60 8,401,982.43
Gross Cash Accruals 4,199,726.23 6,032,687.60 8,516,470.68
Term Liabilities to Gross Cash Accruals 0.80 0.39 0.15
Net Working Capital 6,630,350.34 11,677,150.92 19,082,699.43
% of NWC to Current Assets 0.88 0.92 0.94
Current Assets to Net Sales 0.05 0.07 0.08
B. LIQUIDITY ANALYSIS
Current Ratio 8.58 12.84 18.18
Quick Ratio 5.19 9.69 15.23
C. PROFITABILITY ANALYSIS
PBDIT/ Net Sales (%) 0.04 0.05 0.05
OPBT / Net Sales (%) 0.04 0.04 0.05
Net Profit/ Net Sales (%) 0.03 0.03 0.03
Return on Assets (%) 0.48 0.44 0.40
Retained Profits / Net Profits (%) 1.00 1.00 1.00
Return on Net Worth (%) 0.70 0.51 0.42
D. ACTIVITY ANALYSIS (IN DAYS)
Receivable Turnover - Domestic #DIV/0! #DIV/0! #DIV/0!
Receivable Turnover - Export - - -
Inventory Turnover 6.70 5.58 4.57
Fixed Assets Turnover Ratio 163.67 242.62 363.17
E. GROWTH RATIOS
Net Sales Growth (%) 0.26 0.28
Net Profit Growth (%) 0.46 0.43
Net Worth Growth (%) 1.40 0.83
VI. FUND FLOW STATEMENT (Auto generated and hence not required to be filled)
2021-22 2022-23 2023-24
V. FUNDS FLOW STATEMENT
Projection Projection Projection
Profit After Tax 5,891,642.60 8,401,982.43
Depreciation 141,045.00 114,488.25
Dividends - -
Funds From Operations - 6,032,687.60 8,516,470.68
Long Term Sources:
Change in Capital 4,022,026.23 5,891,642.60
Net Change in Reserve (4,022,026.23) (5,891,642.60)
Change in Term Loans (985,887.02) (1,110,922.17)
Total [Source(+) / Deficit(-)] - 5,046,800.58 7,405,548.51
Long Term Uses:
Net Change in Fixed Assets - -
Change in Other Non Current Assets (including
- -
Investments)
Change in Investments in Group Companies - -

Change in Intangibles - -
Contribution to Working Capital - 5,046,800.58 7,405,548.51
Short Term Uses
Change in Net Working Assets 381,675.00 475,188.00
Change in Other Current Assets - -
Short Term Sources
Change in Other Current Liabilities - -
Change in Bank Borrowings/Loans 110,962.35 125,035.15
- (270,712.65) (350,152.85)

Net Movement in Liquid Assets - 4,776,087.93 7,055,395.66


Change in cash 4,776,087.93 7,055,395.66
Change in Marketable Investments - -
Net Movement in Liquid Assets - 4,776,087.93 s
VII. CASH FLOW STATEMENT (Auto generated and hence not required to be filled)
2021-22 2022-23 2023-24
VI. CASH FLOW STATEMENT
Projection Projection Projection
Operating Sector
Net Sales 193,914,000.00 248,688,000.00
Debtors (Trade) [Inc.(+)/Dec.(-)] 233,415.00 319,515.00
Cash From Sales 193,680,585.00 248,368,485.00
Costs- Interest & Finance Charges 459,742.19 348,779.84
Expenses on Stocks Purchases 34,020,000.00 43,659,000.00
Trade Creditors [Inc.(-)/Dec.(+)] - -
Manufacturing Expenses #VALUE! #VALUE!
Cash Cost of Sales #VALUE! #VALUE!
Cash from Asset Conversion Cycle #VALUE! #VALUE!
Selling, Gen. & Adm. Expenses 3,574,966.80 3,705,241.14
Advance Payments [Inc.(+)/Dec.(-)] - -
Advances Received [Inc.(-)/Dec.(+)] - -
Taxation 2,671,791.41 3,810,201.34
Dividends - -
Cash From Operations #VALUE! #VALUE!
Other Current Assets [Inc.(+)/Dec.(-)] - -
Other Current Liabilities [Inc.(-)/Dec.(+)] - -
Other Income / Expenses (Net) - -
Net Cash From Operations #VALUE! #VALUE!
Investment Sector
Capital Expenditure [Inc.(+)/Dec.(-)] - -
Investment in Group Companies [Inc.(+)/Dec.(-)] - -
Intangible / Other Term Assets [Inc.(+)/Dec.(-)] - -
Cash Before Funding #VALUE! #VALUE!
Financing Sector
Dues to Banks [Inc.(+)/Dec.(-)] 110,962.35 125,035.15
Short Term Debts [Inc.(+)/Dec.(-)] - -
Term Debts [Inc.(+)/Dec.(-)] (985,887.02) (1,110,922.17)
Equity [Inc.(+)/Dec.(-)] 4,022,026.23 5,891,642.60
Other Loans & Reserves [Inc.(+)/Dec.(-)] (4,022,026.23) (5,891,642.60)
Total (874,924.67) (985,887.02)
Movement in Cash Assets #VALUE! #VALUE!
Cash & Bank Balance [Inc.(+)/Dec.(-)] 4,776,087.93 7,055,395.66
Investments (Other Than Long Term) [Inc.(+)/Dec.(-)] - -
Movement in Cash Assets 4,776,087.93 7,055,395.66
Loan Repayment Schedule

Loan Amount 5,000,000.00 Means of Finance


Tenure in months 60.00 5 Years 5,000,000.00 Term Loan
Rate/Month 0.01 12% p.a. 1,700,000.00 Own Funding

S No. Month Opening Balance Installment Principle Interest Closing Balance


1 Apr-20 5,000,000.00 111,222.24 61,222.24 50,000.00 4,938,777.76
2 May-20 4,938,777.76 111,222.24 61,834.46 49,387.78 4,876,943.30
3 Jun-20 4,876,943.30 111,222.24 62,452.81 48,769.43 4,814,490.50
4 Jul-20 4,814,490.50 111,222.24 63,077.33 48,144.90 4,751,413.16
5 Aug-20 4,751,413.16 111,222.24 63,708.11 47,514.13 4,687,705.06
6 Sep-20 4,687,705.06 111,222.24 64,345.19 46,877.05 4,623,359.87
7 Oct-20 4,623,359.87 111,222.24 64,988.64 46,233.60 4,558,371.23
8 Nov-20 4,558,371.23 111,222.24 65,638.53 45,583.71 4,492,732.70
9 Dec-20 4,492,732.70 111,222.24 66,294.91 44,927.33 4,426,437.79
10 Jan-21 4,426,437.79 111,222.24 66,957.86 44,264.38 4,359,479.93
11 Feb-21 4,359,479.93 111,222.24 67,627.44 43,594.80 4,291,852.49
12 Mar-21 4,291,852.49 111,222.24 68,303.71 42,918.52 4,223,548.78
13 Apr-21 4,223,548.78 111,222.24 68,986.75 42,235.49 4,154,562.03
14 May-21 4,154,562.03 111,222.24 69,676.62 41,545.62 4,084,885.41
15 Jun-21 4,084,885.41 111,222.24 70,373.38 40,848.85 4,014,512.02
16 Jul-21 4,014,512.02 111,222.24 71,077.12 40,145.12 3,943,434.91
17 Aug-21 3,943,434.91 111,222.24 71,787.89 39,434.35 3,871,647.02
18 Sep-21 3,871,647.02 111,222.24 72,505.77 38,716.47 3,799,141.25
19 Oct-21 3,799,141.25 111,222.24 73,230.83 37,991.41 3,725,910.42
20 Nov-21 3,725,910.42 111,222.24 73,963.13 37,259.10 3,651,947.29
21 Dec-21 3,651,947.29 111,222.24 74,702.77 36,519.47 3,577,244.52
22 Jan-22 3,577,244.52 111,222.24 75,449.79 35,772.45 3,501,794.73
23 Feb-22 3,501,794.73 111,222.24 76,204.29 35,017.95 3,425,590.44
24 Mar-22 3,425,590.44 111,222.24 76,966.33 34,255.90 3,348,624.10
25 Apr-22 3,348,624.10 111,222.24 77,736.00 33,486.24 3,270,888.11
26 May-22 3,270,888.11 111,222.24 78,513.36 32,708.88 3,192,374.75
27 Jun-22 3,192,374.75 111,222.24 79,298.49 31,923.75 3,113,076.26
28 Jul-22 3,113,076.26 111,222.24 80,091.48 31,130.76 3,032,984.78
29 Aug-22 3,032,984.78 111,222.24 80,892.39 30,329.85 2,952,092.39
30 Sep-22 2,952,092.39 111,222.24 81,701.31 29,520.92 2,870,391.08
31 Oct-22 2,870,391.08 111,222.24 82,518.33 28,703.91 2,787,872.75
32 Nov-22 2,787,872.75 111,222.24 83,343.51 27,878.73 2,704,529.24
33 Dec-22 2,704,529.24 111,222.24 84,176.95 27,045.29 2,620,352.29
34 Jan-23 2,620,352.29 111,222.24 85,018.72 26,203.52 2,535,333.58
35 Feb-23 2,535,333.58 111,222.24 85,868.90 25,353.34 2,449,464.67
36 Mar-23 2,449,464.67 111,222.24 86,727.59 24,494.65 2,362,737.08
37 Apr-23 2,362,737.08 111,222.24 87,594.87 23,627.37 2,275,142.21
38 May-23 2,275,142.21 111,222.24 88,470.82 22,751.42 2,186,671.40
39 Jun-23 2,186,671.40 111,222.24 89,355.52 21,866.71 2,097,315.87
40 Jul-23 2,097,315.87 111,222.24 90,249.08 20,973.16 2,007,066.79
41 Aug-23 2,007,066.79 111,222.24 91,151.57 20,070.67 1,915,915.22
42 Sep-23 1,915,915.22 111,222.24 92,063.09 19,159.15 1,823,852.14
43 Oct-23 1,823,852.14 111,222.24 92,983.72 18,238.52 1,730,868.42
44 Nov-23 1,730,868.42 111,222.24 93,913.55 17,308.68 1,636,954.87
45 Dec-23 1,636,954.87 111,222.24 94,852.69 16,369.55 1,542,102.18
46 Jan-24 1,542,102.18 111,222.24 95,801.22 15,421.02 1,446,300.96
47 Feb-24 1,446,300.96 111,222.24 96,759.23 14,463.01 1,349,541.73
48 Mar-24 1,349,541.73 111,222.24 97,726.82 13,495.42 1,251,814.91
49 Apr-24 1,251,814.91 111,222.24 98,704.09 12,518.15 1,153,110.82
50 May-24 1,153,110.82 111,222.24 99,691.13 11,531.11 1,053,419.69
51 Jun-24 1,053,419.69 111,222.24 100,688.04 10,534.20 952,731.65
52 Jul-24 952,731.65 111,222.24 101,694.92 9,527.32 851,036.73
53 Aug-24 851,036.73 111,222.24 102,711.87 8,510.37 748,324.86
54 Sep-24 748,324.86 111,222.24 103,738.99 7,483.25 644,585.87
55 Oct-24 644,585.87 111,222.24 104,776.38 6,445.86 539,809.49
56 Nov-23 539,809.49 111,222.24 105,824.14 5,398.09 433,985.34
57 Dec-23 433,985.34 111,222.24 106,882.38 4,339.85 327,102.96
58 Jan-24 327,102.96 111,222.24 107,951.21 3,271.03 219,151.75
59 Feb-24 219,151.75 111,222.24 109,030.72 2,191.52 110,121.03
60 Mar-24 110,121.03 111,222.24 110,121.03 1,101.21 0.00
558,215.64 874,924.67 3,348,624.10

459,742.19 985,887.02 2,362,737.08

348,779.84 1,110,922.17 1,251,814.91


FIXED ASSETS & DEPRECIATION THEREON
Addition
Rate of
Opening Addition upto after
Name of Assets Depreciatio
Balance 30.09.2021 30.09.202
n
1
Plant & Machinery
Air Conditioner 15% 35,000.00
CCTV Camera 15% 25,000.00
Printer 15% 18,000.00
Tools & Tackles 15% 500,000.00
LAN & Network 15% 20,000.00
Furnitue & Fixtures
Furniture & Fixture 10% 400,000.00 -
Computer & IT
Computer 40% 120,000.00 -
Total - 1,118,000.00 -

FIXED ASSETS & DEPRECIATION THEREON


Rate of Addition
Opening Addition upto after
Name of Assets Depreciatio Balance 30.09.2022 30.09.202
n
2
Plant & Machinery
Air Conditioner 15% 29,750.00
CCTV Camera 15% 21,250.00
Printer 15% 15,300.00
Tools & Tackles 15% 425,000.00
LAN & Network 15% 17,000.00
Furnitue & Fixtures
Furniture & Fixture 10% 360,000.00 -
Computer & IT
Computer 40% 72,000.00 -
Total 940,300.00 - -

FIXED ASSETS & DEPRECIATION THEREON


Addition
Rate of
Opening Addition upto after
Name of Assets Depreciatio
Balance 30.09.2023 30.09.202
n
3
Plant & Machinery
Air Conditioner 15% 25,287.50
CCTV Camera 15% 18,062.50
Printer 15% 13,005.00
Tools & Tackles 15% 361,250.00
LAN & Network 15% 14,450.00
Furnitue & Fixtures
Furniture & Fixture 10% 324,000.00 -
Computer & IT
Computer 40% 43,200.00 -
Total 799,255.00 - -
FY- 2021-22
ON THEREON

Closing WDV as on
Deletion Total Depreciation
31.03.2022

35,000.00 5,250.00 29,750.00


25,000.00 3,750.00 21,250.00
18,000.00 2,700.00 15,300.00
500,000.00 75,000.00 425,000.00
20,000.00 3,000.00 17,000.00

- 400,000.00 40,000.00 360,000.00

- 120,000.00 48,000.00 72,000.00


- 1,118,000.00 177,700.00 940,300.00

FY- 2022-23
ON THEREON

Closing WDV as on
Deletion Total Depreciation 31.03.2023

29,750.00 4,462.50 25,287.50


21,250.00 3,187.50 18,062.50
15,300.00 2,295.00 13,005.00
425,000.00 63,750.00 361,250.00
17,000.00 2,550.00 14,450.00

- 360,000.00 36,000.00 324,000.00

- 72,000.00 28,800.00 43,200.00


- 940,300.00 141,045.00 799,255.00

FY- 2023-24
ON THEREON

Closing WDV as on
Deletion Total Depreciation
31.03.2024

25,287.50 3,793.13 21,494.38


18,062.50 2,709.38 15,353.13
13,005.00 1,950.75 11,054.25
361,250.00 54,187.50 307,062.50
14,450.00 2,167.50 12,282.50

- 324,000.00 32,400.00 291,600.00

- 43,200.00 17,280.00 25,920.00


- 799,255.00 114,488.25 684,766.75
Calculation of initial investment requirement
Particular Amount
Fixed Assets 1,118,000.00
Stock in hand
- Chassis Body Purchased 750,000.00
- Under Chassis Kit Puchased 1,000,000.00
- Lithium Batteries Purchased 400,000.00
- Seats, Roof, Nut bolts etc 175,000.00
- Lead Acid Battery Charger 160,200.00
- Lead Acid Batteries Purchased 480,000.00
GST on Stock in Hand Err:522
Cash in hand 200,000.00
License 1,500,000.00
Security deposit for rent 100,000.00
Contingencies 200,000.00

Total Err:522
RATHI BARS LTD.

CALCULATION OF S.L.M. DEPRECIATION


(Rs. in Lacs)
Items Amount Add.durin Total Deprn. Deprn.
g 2009-10 rate % Amount

Land 39.21 0.00 39.21 0.00 0.00

Building 322.32 0.00 322.32 3.34 10.77

Plant & Machinery 2681.50 200.00 2881.50 4.75 136.87

Miscellaneous Fixed Assets 142.96 0.00 142.96 4.75 6.79

Capital Work in Progress 742.51 0.00 742.51 0.00

Total 3928.49 200.00 4128.49 154.43

ESTIMATION OF TAX PROVISION


(Rs. in Lacs)
PARTICULARS 2009-10 2010-11 2011-12 2012-13 2013-14 2014-15

Profit before Taxation #REF! #REF! #REF! #REF! #REF! #REF!

Mat 10.00% #REF! #REF! #REF! #REF! #REF! #REF!


Surcharge 10.00% #REF! #REF! #REF! #REF! #REF! #REF!
Cess 3.00% #REF! #REF! #REF! #REF! #REF! #REF!
Total #REF! #REF! #REF! #REF! #REF! #REF!

Provision for Tax #REF! #REF! #REF! #REF! #REF! #REF!


Shrishti Alloys Pvt. Limited

Interest & Repayment Schedule

AMOUNT 1450.00 Lacs


(Rs. in Lacs)
Particulars Construc
tion 2013-14 2014-15 2015-16 2016-17 2017-18 2018-19 2019-20
Period

Ist Quarter

Opening Balance 0.00 1230.00 1230.00 988.33 746.67 505.00 263.33 21.67
Recd. during the Period 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Less: Quarterly Installment 0.00 0.00 60.42 60.42 60.42 60.42 60.42 21.67
Closing Balance 0.00 1230.00 1169.58 927.92 686.25 444.58 202.92 0.00
Quarterly Interest 0.00 44.59 44.59 35.83 27.07 18.31 9.55 0.79

IInd quarter

Opening Balance 0.00 1230.00 1169.58 927.92 686.25 444.58 202.92 0.00
Recd. during the Period 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Less: Quarterly Installment 0.00 0.00 60.42 60.42 60.42 60.42 60.42 0.00
Closing Balance 0.00 1230.00 1109.17 867.50 625.83 384.17 142.50 0.00
Quarterly Interest 0.00 44.59 42.40 33.64 24.88 16.12 7.36 0.00

IIIrd quarter

Opening Balance 0.00 1230.00 1109.17 867.50 625.83 384.17 142.50 0.00
Recd. during the Period 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Less: Quarterly Installment 0.00 0.00 60.42 60.42 60.42 60.42 60.42 0.00
Closing Balance 0.00 1230.00 1048.75 807.08 565.42 323.75 82.08 0.00
Quarterly Interest 0.00 44.59 40.21 31.45 22.69 13.93 5.17 0.00

IVth quarter

Opening Balance 0.00 1230.00 1048.75 807.08 565.42 323.75 82.08 0.00
Recd. during the Period 1230.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Less: Quarterly Installment 0.00 0.00 60.42 60.42 60.42 60.42 60.42 0.00
Closing Balance 1230.00 1230.00 988.33 746.67 505.00 263.33 21.67 0.00
Quarterly Interest 29.63 44.59 38.02 29.26 20.50 11.74 2.98 0.00

Total Disb. during the yr. 1230.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00

Total Repayment during the yr. 0.00 0.00 241.67 241.67 241.67 241.67 241.67 21.67

Total Interest during the year 29.63 178.36 165.22 130.18 95.14 60.10 25.06 0.79

Less:Int. during Cons. period 29.63

NET INTEREST 0.00 178.36 165.22 130.18 95.14 60.10 25.06 0.79

No. of Installments 24
Rate of Interest 14.50 % p.a.

You might also like