Annu Exports - XLSM

2019 2020 2021 2022
Opening Stock 94.91 122.28 116.70

ADD Purchases 97.09 24.99 308.43
Total 192.00 147.27 425.13
Less Closing stock 122.28 116.70 188.08
RMC 69.72 30.57 237.05
Please fill up details from column E onwards:
Name of the unit Annu Exports
Audited Audited Provis Proj

Status of BS ional
Financial Year 2019 2020 2021 2022
RM Purchases
Retained Profit at the
beginning of FY 2019
Cumulative Depreciation
at the beginning of FY
2019
PROJ PROJ PROJ PROJ PROJ PROJ PROJ PROJ PROJ PROJ
2023 2027 2028 2029 2030 2031 2032 2033 2034

DSCR 2023 2024 2025
Net Profit After Tax 2.32 12.60 51.37
Add : Depreciation 0.88 1.36 0.81
Add : Int on Bank Term Loan 0.00 0.00 0.00
TOTAL 3.20 13.96 52.18
Annual Repayment 0.00 0.00 0.00
Obligation :principal :
Annual Repayment 0.00 0.00 0.00
Obligation :Interest
Total Repayment Obligation 0.00 0.00 0.00
GROSS D.S.C.R. 0.00 0.00 0.00
AVERAGE GROSS D.S.C.R. #NAME
Surplus 3.20 13.96 52.18

WC margin 66.16 151.01 44.38
Available For Investment -62.96 -137.05 7.80
2026 2027 2028 2029 2030
65.98 #NAME? #NAME? #NAME? #NAME?
0.00 0.00 #NAME? #NAME? #NAME?

#NAME?

2023 2024
PBDIT 21.58 11.02
Sales 139.74 335.55
Cash flows from operating activities
Net Income 2.32 12.60
ADD:Non Cash Expenses 0.88 1.36
Non Operating Expenses: Interest 18.78 11.18
Sub Total 21.98 25.14
Less: Non Operating Income 0.86 18.32
Sub Total 21.12 6.82
ADD : Decrease In Current Assets(Excludimg
Cash and Bank bal) 45.10 0.00
Increase in CL 0.00 0.00
Sub Total 66.22 6.82
0.00 136.57
Less: Increase in CA(Excluding Cash and Bank)
Decrease in CL 35.86 12.92
Cash flows from operating activities(A) 30.36 -142.67
Decrease in FA 0.00 0.00
Decrease in Investments 0.00 1.45
SUB TOTAL 0.00 1.45
Less Increase in FA 8.04 0.30
Increase in Investments 6.45 0.00
SUB TOTAL 14.49 0.30
Cash Flow investing activities (B) -14.49 1.15
ADD:Borrowing 6.25 133.75
Capital Infusion 0.00 4547.20
SUB TOTAL 6.25 4680.95
Less:Repayment of Loan 0.00 0.00
Dividend 0.00 0.00
Interest on Loan` 18.78 11.18
Redemption of Bonds etc 4.33 0.00
SUB TOTAL 23.11 11.18
Cash flows from financing activities© -16.86 4669.77
Net increase in cash and cash
equivalents(A+B+C) -0.99 4528.25
Cash and cash equivalents at beginning of
period(cash+FD) 1.78 1.65
Closing Cash Balance(5+6+7) 0.79 4529.90
Actual CB 1.65 3.17

Difference -0.86 4526.73
CFO/Sales 22% -43%
CFO\PBDIT 141% -1295%
2025 2026 2027 2028 2029 2030
67.10 78.86 #NAME? #NAME? #NAME? #NAME?



-30.60 -37.68 #NAME? #NAME? #NAME? #NAME?
3.17 3.48 3.50 #NAME? #NAME? #NAME?


1% 1% #NAME? #NAME? #NAME? #NAME?
9% 10% #NAME? #NAME? #NAME? #NAME?
Sensitivity to DSCR 2020 2021 2022 2023 #NAME? #NAME?
Sales (when down by) 10% 125.77 302.00 820.80 902.88 #NAME? #NAME?
Variable costs also go down by 8% 99.00 284.14 746.33 817.27 #NAME? #NAME?
Fixed cost 30.22 28.22 57.28 65.37 #NAME? #NAME?
Total cost 129.21 312.36 803.61 882.64 #NAME? #NAME?
Operating Profits Less IT -2.86 -8.60 14.27 16.80 #NAME? #NAME?
Depreciation & non cash charges 0.88 1.36 0.81 0.72 #NAME? #NAME?
Cash Accruals -1.98 -7.24 15.08 17.52 #NAME? #NAME?
Interest on TL 0.00 0.00 0.00 0.00 #NAME? #NAME?
Repayments 0.00 0.00 0.00 0.00 0.00 #NAME?
Gross DSCR 0.00 0.00 0.00 0.00 #NAME? #NAME?
When RM cost goes up by 10%

% can be passed on to customer 2%
Sales 140.91 340.29 925.32 1017.85 #NAME? #NAME?
Variable costs go up to 113.43 332.55 877.81 961.57 #NAME? #NAME?
Operating Profits Less IT -2.28 -17.00 -8.12 -7.55 #NAME? #NAME?
Cash Accruals -1.40 -15.64 -7.31 -6.83 #NAME? #NAME?
Repayments 0.00 0.00 0.00 0.00 0.00 #NAME?
When Variable costs go up by 10%

Sales 141.89 341.73 928.22 1020.97 #NAME? #NAME?
Variable costs sales go up to 118.36 339.73 892.35 977.17 #NAME? #NAME?
Operating Profits Less IT -5.55 -21.77 -17.77 -17.91 #NAME? #NAME?
Cash Accruals -4.67 -20.41 -16.96 -17.19 #NAME? #NAME?
Repayments 0.00 0.00 0.00 0.00 0.00 #NAME?
Sensitivity to DSCR #NAME? #NAME?
Sales (when down by) 10% #NAME? #NAME?
Variable costs also go down by 8% #NAME? #NAME?
Fixed cost #NAME? #NAME?
Total cost #NAME? #NAME?
Operating Profits Less IT #NAME? #NAME?
Depreciation & non cash charges #NAME? #NAME?
Cash Accruals #NAME? #NAME?
Interest on TL #NAME? #NAME?
Repayments #NAME? #NAME?
Gross DSCR #NAME? #NAME?
When RM cost goes up by 10%

Sales #NAME? #NAME?
Variable costs go up to #NAME? #NAME?
When Variable costs go up by 10%

Sales #NAME? #NAME?
Variable costs sales go up to #NAME? #NAME?
Particulars 2023 2021 2025 2023 #NAME? #NAME? #NAME? #NAME?
BREAK EVEN POINT
Installed capacity (kg) 20000 20000 20000 20000 20000 20000 20000 20000
Capacity utilisation(in KG) 5400 5940 6534 7187 7906 8697 9566 10523
Capacity utilisation(in KG)% 27% 30% 33% 36% 40% 43% 48% 53%
Installed capacity (value) 6000 6000 6000 6000 6000 6000 6000 6000
Capacity utilisation% 2% 6% 15% 17% #NAME? #NAME? #NAME? #NAME?
Sales 139.74 335.55 912.00 1003.20 #NAME? #NAME? #NAME? #NAME?
Variable Cost
I.Raw Material 100% 58.30 237.05 665.90 732.34 #NAME? #NAME? #NAME? #NAME?
ii.ETP Processing Cost 100% 0.00 0.00 0.00 0.00 #NAME? #NAME? #NAME? #NAME?
iii.Direct Labour 80% 23.54 39.95 106.40 112.00 #NAME? #NAME? #NAME? #NAME?
iv.Power & Fuel 80% 1.68 0.98 2.80 3.20 #NAME? #NAME? #NAME? #NAME?
v.Selling Expenses 85% 21.88 29.89 34.00 37.40 #NAME? #NAME? #NAME? #NAME?
vi.Other Variable Costs 85% 2.20 0.98 2.13 3.40 #NAME? #NAME? #NAME? #NAME?
Total Variable Costs 107.60 308.85 811.23 888.34 #NAME? #NAME? #NAME? #NAME?
Percent of Sales 77.00% 92.04% 88.95% 88.55% #NAME? #NAME? #NAME? #NAME?
Fixed Costs 30.22 28.22 57.28 65.37 #NAME? #NAME? #NAME? #NAME?
Break Even Level of Sales 131.39 354.65 518.42 570.93 #NAME? #NAME? #NAME? #NAME?
Percentage to Sales 94% 106% 57% 57% #NAME? #NAME? #NAME? #NAME?
Cash Break Even of Sales 127.56 337.56 511.09 564.64 #NAME? #NAME? #NAME? #NAME?
Percentage to Sales 91% 101% 56% 56% #NAME? #NAME? #NAME? #NAME?
COMPUTATION OF MAXIMUM PERMISSIBLE
BANK FINANCE FOR WORKING CAPITAL
Name of the unit : Annu Exports
(AMOUNT RS IN LACS)
SN PARTICULARS Audited AuditedProvisional Proj PROJ
2019 2020 2021 2022 2023
1 Total Current Assets(9 from cma3) 251.28 206.05 344.14 566.28 629.41
2 Other Current Liabilities(ExcludingBank
Borrowing and TL Instl for W.C. )(14 64.90 39.52 75.52 54.73 60.19
3 Working Capital Gap ( 1 - 2) 186.38 166.53 268.62 511.55 569.22
4 Min. stipulated Net Working Capital 62.82 51.51 86.04 141.57 157.35
(i.e.25% of Total Current Assets
excldg. Export Receivables)
5 Actual/ Projected Net Working Capital 75.53 66.16 217.17 261.55 319.22
(45 from cma2)
6 Item 3 minus item 4 123.56 115.02 182.59 369.98 411.87
7 Item 3 minus item 5 110.85 100.37 51.45 250.00 250.00
8 Maximum Permissible Bank Finance 110.85 100.37 51.45 250.00 250.00
(Item 6 or 7 whichever is lower)
9 Excess Borrowing representing 0.00 0.00 0.00 0.00 0.00
Shortfall in Net Working Capital(4 - 5)
2023 2024 2025 2026 2027 2028
PBDIT/Sales 15.44% 3.28% 7.36% 7.86% #NAME? #NAME?
NP/Sales 1.66% 3.76% 5.63% 6.58% #NAME? #NAME?
Current Ratio 1.47 2.71 1.86 2.03 #NAME? #NAME?
TOL 161.14 281.97 451.93 448.36 #NAME? #NAME?
QE #NAME? #NAME? #NAME? #NAME? #NAME? #NAME?
TNW 60.46 75.21 126.58 192.56 #NAME? #NAME?
TOL-QE/TNW+QE 2.15 0.81 1.33 1.04 #NAME? #NAME?
DEBT/EQUITY #NAME? #NAME? #NAME? #NAME? #NAME? #NAME?
2029 2030
#NAME? #NAME?
#NAME? #NAME?
#NAME? #NAME?
#NAME? #NAME?
#NAME? #NAME?
#NAME? #NAME?
#NAME? #NAME?
#NAME? #NAME?
N
NP 226.44
QE 822
Capital 25
Loan 1841
Creditors 66.79
8
2989.23
200
Particulars of Assets Cost (Rs Source of Value (Rs
in lacs) Finance in lacs)
Land 70.35 Capital 10.00

Building 1330.00 Unsecured 1051.63
Loans
Plant & achinery Bank 2000.00
Finance
MFG Equipment 230.86 Accruals 4.09
Quality Control 204.11
Equipment
ETP 200.00
Utilities 101.36
Water System 60.00
HVAC 100.00
Mechanical Piping 100.00
Electrical Fittings 100.00
Furniture Fixtures 97.50
Computers
Fire Fighting System 106.12
Interest during 149.26

moratorium
Contingencies 150.00
WC margin 66.16
Total Cost 3065.72 Total 3065.72
158.53 284.1 125.57
227.7
200
75.59
503.29
284
227
511
158
353
145
208
Produdct Rate Annual Value of SALES( Cost Total Cost RMC
Per Sales (In annual Rs in PKG (Rs In
KG KG) Sales Lacs) Lacs)
2023 Methimazole 34500 1800 62100000 9441 16993800

2023 Carbimazole 25000 3600 90000000 6816 24537600
5400 152100000 1521.00 41531400 415.31
2024 Methimazole 34500 1980 68310000 9441 18693180
2024 Carbimazole 25000 3960 99000000 6816 26991360
5940 167310000 1673.10 45684540 456.85
2005 Methimazole 34500 2178 75141000 9441 20562498
2025 Carbimazole 25000 4356 108900000 6816 29690496
6534 184041000 1840.41 50252994 502.53
2026 Methimazole 34500 2395.8 82655100 9441 22618747.8
2026 Carbimazole 25000 4791.6 119790000 6816 32659545.6
7187.4 202445100 2024.45 55278293.4 552.78
2027 Methimazole 34500 2635.38 90920610 9441 24880622.58
2027 Carbimazole 25000 5270.76 131769000 6816 35925500.16
7906.14 222689610 2226.90 60806122.74 608.06
2028 Methimazole 34500 2898.918 100012671 9441 27368684.838
2028 Carbimazole 25000 5797.836 144945900 6816 39518050.176
8696.754 244958571 2449.59 66886735.014 668.87
2029 Methimazole 34500 3188.8098 110013938 9441 30105553.322
2029 Carbimazole 25000 6377.6196 159440490 6816 43469855.194
9566.4294 269454428 2694.54 73575408.515 735.75
2030 Methimazole 34500 3507.6908 121015332 9441 33116108.654
2030 Carbimazole 25000 7015.3816 175384539 6816 47816840.713
10523.072 296399871 2964.00 80932949.367 809.33
1 Status of the Project
1 Construction
2 Regulatory Approvals obtained /to be obtained.
3 Consstruction quote certified by Architect.
4 Present status of construction
5 Building:Stages of construction. Expected date of completion.
2 Machinery
1 Machinery Quotations.Signed by vendor.
2 Machinery:Time required for delivery after order is placed .
3 Machinery:Will order be placed after completion of
construction.
4 Machinery: Validity of quotes.
5 Machinery:time required for Installation
6 Machinery: Expected date of Trial Run.
7 Machinery: Expected date of Commercial Production.
8 GST cannot be included in the cost if set off is
available.Will be accounted as a Curreeeent Asset.
3 Promoters
1 Age
2 Experience in the line of activity
3 Educational Qualifications
4 Length of association with the company.
4 Product
1 Brief Writeup on product.
5 Sales
1 Market Demand data.
2 Justification of projected sales:Our clients and quantification of
demand for our unit.
6 Disbursement Schedule
1 For Machinery
2 For Building and other Infra
7 Working Capital Requirement
1 Raw material Holding
2 Credit on purchases
3 SIP holding: Brief Process description. Quantification of stock
blocked in processing at any given time.
4 Finished stock : Holding at any given time
5 Debtors.
8 Security Details:
1 Description : Area of Plot and construction etc
2 Valuation
3 Present position of the title
9 RM Suppiers and credit available
1 Names of suppliers
2 Location of suppliers and transit time for delivery in factory.
3 Credit available
4 Cash Purchases
10 Existing unit(i.e. Chin Chem) has never achieved sales
exceeding Rs 7.00 Crs so far. How do we expect the new
unit to achieve sales of RS 15 Crs in first year?
11 Employees:Cost of wages(Direct Cost)
1 Number of workers x salary
2 Skilled Workers Number x alary
3 UnSkilled Workers Number x alary
4 Number of supervisors x salary
5 other employees number x salary
12 Details of security Deposits : Deposited and to be
deposited.i.e. MSEB MIDC Water Supply etc
13 Promoters Loan accounts:
1 Statement of account from beginning
2 Sanction letter
3 Latest position
14 Associate Concerns:
Brief Write up abt activity
last 3 yrs financials
Promoters and their stake.
15 SGA
Employees: Managerial Number X Salary
Employees: Clerical Number X Salary
Category
Housekeeping
Salaries 13.20 Office Staff
Printing & Stationery 2.00 Watchman
Courier 0.25
Factory Insurance 10.00
Commission On sales 30.00
Staff Welfare 5.00
Travelling Exp 15.00
AMC Charges 2.50
Municipal Taxes 1.00
MIDC Charges 3.60
Membership and Subscriptions 2.50
Office Expenses 2.50
Cariage outward 6.00
Canteen Expenses 12.00
Directors' salaries 50.00
Trade Fairs 5.00
160.55
Nos Salary PM Annual Bill Total
2 10000 20000
3.00 20000.00 60000.00
2.00 15000.00 30000.00
110000.00 1320000
EMPLOYEE DESIG Number Salary Per
Month
GM 1 200000.00
Production Manager 2 40000.00
Quality Control Chemis 5 40000.00
Workers 13 20000.00
Monthly Bill Annual Exp
200000.00
80000.00
200000.00
260000.00
740000.00 8880000
DISBURSEMENT SCHEDULE
May June July August Total
Building 250.00 200.00 150.00 100.18 700.18
Machinery 250.00 150.00 34.96 434.96
Firefighting 50.00 25.00 31.00 106.00
ETP 100.00 50.00 50.00 200.00
HVAC 50.00 25.00 25.00 100.00
Utilities 50.00 51.36 101.36
Water System 30.00 30.00 60.00
Mechanical 25.00 50.00 25.00 100.00
Electrical 25.00 50.00 25.00 100.00
Furniture/Fix 50.00 47.50 97.50
500.00 530.00 631.36 338.64 2000.00
REP\DISB
START DATE 2/28/21 Limit Sanctioned 2000.00
INTT 0.10500
INTT DISB EMI BALANCE Principal INTT PRIN
REP` REP
0.00 0.00
0.00 0.00 0.00 0.00
0.00 0.00 0.00
3/31/2021 0.00 0.00 0.00 0.00 0.00
4/30/2021 0.00 0.00 0.00
5/31/2021 0.00 500.00 500.00 0.00
6/30/2021 4.38 530.00 4.38 1030.00 0.00
7/31/2021 9.01 631.36 9.01 1661.36 0.00
8/31/2021 14.54 338.64 14.54 2000.00 0.00
9/30/2021 17.50 17.50 2000.00 0.00
10/31/2021 17.50 17.50 2000.00 0.00
11/30/2021 17.50 17.50 2000.00 0.00
12/31/2021 17.50 17.50 2000.00 0.00
1/31/2022 17.50 17.50 2000.00 0.00
2/28/2022 16.33 16.33 2000.00 0.00
3/31/2022 17.50 17.50 2000.00 0.00 149.26 0.00
1 4/30/2022 17.50 30.00 1987.50 12.50
2 5/31/2022 17.39 30.00 1974.89 12.61
3 6/30/2022 17.28 30.00 1962.17 12.72
4 7/31/2022 17.17 30.00 1949.34 12.83
5 8/31/2022 17.06 30.00 1936.40 12.94
6 9/30/2022 16.94 30.00 1923.34 13.06
7 10/31/2022 16.83 30.00 1910.17 13.17
8 11/30/2022 16.71 30.00 1896.88 13.29
9 12/31/2022 16.60 30.00 1883.48 13.40
10 1/31/2023 16.48 30.00 1869.96 13.52
11 2/28/2023 15.27 30.00 1855.23 14.73
12 3/31/2023 16.23 30.00 1841.47 13.77 201.47 158.53
13 4/30/2023 16.11 30.00 1827.58 13.89
14 5/31/2023 15.99 30.00 1813.57 14.01
15 6/30/2023 15.87 30.00 1799.44 14.13
16 7/31/2023 15.75 30.00 1785.18 14.25
17 8/31/2023 15.62 30.00 1770.80 14.38
18 9/30/2023 15.49 30.00 1756.30 14.51
19 10/31/2023 15.37 30.00 1741.67 14.63
20 11/30/2023 15.24 30.00 1726.91 14.76
21 12/31/2023 15.11 30.00 1712.02 14.89
22 1/31/2024 14.98 30.00 1697.00 15.02
23 2/29/2024 14.35 30.00 1681.35 15.65
24 3/31/2024 14.71 30.00 1666.06 15.29 184.60 175.40
25 4/30/2024 14.58 30.00 1650.64 15.42
26 5/31/2024 14.44 30.00 1635.08 15.56
27 6/30/2024 14.31 30.00 1619.39 15.69
28 7/31/2024 14.17 30.00 1603.56 15.83
29 8/31/2024 14.03 30.00 1587.59 15.97
30 9/30/2024 13.89 30.00 1571.48 16.11
31 10/31/2024 13.75 30.00 1555.23 16.25
32 11/30/2024 13.61 30.00 1538.84 16.39
33 12/31/2024 13.46 30.00 1522.31 16.54
34 1/31/2025 13.32 30.00 1505.63 16.68
35 2/28/2025 12.30 30.00 1487.92 17.70
36 3/31/2025 13.02 30.00 1470.94 16.98 164.88 195.12
37 4/30/2025 12.87 30.00 1453.81 17.13
38 5/31/2025 12.72 30.00 1436.53 17.28
39 6/30/2025 12.57 30.00 1419.10 17.43
40 7/31/2025 12.42 30.00 1401.52 17.58
41 8/31/2025 12.26 30.00 1383.78 17.74
42 9/30/2025 12.11 30.00 1365.89 17.89
43 10/31/2025 11.95 30.00 1347.84 18.05
44 11/30/2025 11.79 30.00 1329.64 18.21
45 12/31/2025 11.63 30.00 1311.27 18.37
46 1/31/2026 11.47 30.00 1292.74 18.53
47 2/28/2026 10.56 30.00 1273.30 19.44
48 3/31/2026 11.14 30.00 1254.44 18.86 143.50 216.50
49 4/30/2026 10.98 30.00 1235.42 19.02
50 5/31/2026 10.81 30.00 1216.23 19.19
51 6/30/2026 10.64 30.00 1196.87 19.36
52 7/31/2026 10.47 30.00 1177.34 19.53
53 8/31/2026 10.30 30.00 1157.65 19.70
54 9/30/2026 10.13 30.00 1137.78 19.87
55 10/31/2026 9.96 30.00 1117.73 20.04
56 11/30/2026 9.78 30.00 1097.51 20.22
57 12/31/2026 9.60 30.00 1077.11 20.40
58 1/31/2027 9.42 30.00 1056.54 20.58
59 2/28/2027 8.63 30.00 1035.17 21.37
60 3/31/2027 9.06 30.00 1014.23 20.94 119.78 240.22
61 4/30/2027 8.87 40.00 983.10 31.13
62 5/31/2027 8.60 40.00 951.70 31.40
63 6/30/2027 8.33 40.00 920.03 31.67
64 7/31/2027 8.05 40.00 888.08 31.95
65 8/31/2027 7.77 40.00 855.85 32.23
66 9/30/2027 7.49 40.00 823.34 32.51
67 10/31/2027 7.20 40.00 790.54 32.80
68 11/30/2027 6.92 40.00 757.46 33.08
69 12/31/2027 6.63 40.00 724.09 33.37
70 1/31/2028 6.34 40.00 690.42 33.66
71 2/29/2028 5.84 40.00 656.26 34.16
72 3/31/2028 5.74 40.00 622.01 34.26 87.78 392.22
73 4/30/2028 5.44 40.00 587.45 34.56
74 5/31/2028 5.14 40.00 552.59 34.86
75 6/30/2028 4.84 40.00 517.42 35.16
76 7/31/2028 4.53 40.00 481.95 35.47
77 8/31/2028 4.22 40.00 446.17 35.78
78 9/30/2028 3.90 40.00 410.07 36.10
79 10/31/2028 3.59 40.00 373.66 36.41
80 11/30/2028 3.27 40.00 336.93 36.73
81 12/31/2028 2.95 40.00 299.88 37.05
82 1/31/2029 2.62 40.00 262.50 37.38
83 2/28/2029 2.14 40.00 224.65 37.86
84 3/31/2029 1.97 40.00 186.61 38.03 44.61 435.39
85 4/30/2029 1.63 40.00 148.24 38.37
86 5/31/2029 1.30 40.00 109.54 38.70
87 6/30/2029 0.96 40.00 70.50 39.04
88 7/31/2029 0.62 40.00 31.12 39.38
89 8/31/2029 0.27 31.39 0.00 31.12 4.78 186.61
1100.65 2000.00
145.00
0.12
Principal Principal Total Principal Total INTT TL I INTT TL Total TL INTT CC
TL I TL I Principal II INTT
Balance
2022 0.00 149.26

2023 158.53 201.47 21.00
2024 175.40 184.60 21.00
2025 195.12 164.88 21.00
2026 216.50 143.50 21.00
2027 240.22 119.78 21.00
2028 392.22 87.78 21.00
2029 435.39 44.61 21.00
2030 186.61 4.78 21.00
2000.00 1100.65
Total
INTT
Rate of 2022 2023
Asset Particulars Dep
GB DEP
LAND & SITE DEVELOPMENT 70.35 0.00
BUILDINGS FACTORY 10.00% 1479.26 147.93
Fire Fighting System 5.00% 106.11 5.31
PLANT & MACHINERY 15.00% 434.96 65.24
Electrical Installations 5.00% 100.00 5.00
FURNITURE & FIXTURES 5.00% 75.00 3.75
Utilities& Water System 10.00% 161.36 16.14
ET PLant 5.00% 200.00 10.00
Hvac MECH piping 10.00% 200.00 20.00
Computrs Printers etc 15.00% 22.50 3.38
SUB TOTAL 2849.54 276.74
2023 2024 2024 2025 2025 2026 2026 2027 2027
NB DEP NB DEP NB DEP NB DEP NB
70.35 0.00 70.35 0.00 70.35 0.00 70.35 0.00 70.35
1331.33 133.13 1198.20 119.82 1078.38 107.84 970.54 97.05 873.49
100.80 5.04 95.76 4.79 90.98 4.55 86.43 4.32 82.11
369.72 55.46 314.26 47.14 267.12 40.07 227.05 34.06 192.99
95.00 4.75 90.25 4.51 85.74 4.29 81.45 4.07 77.38
71.25 3.56 67.69 3.38 64.30 3.22 61.09 3.05 58.03
145.22 14.52 130.70 13.07 117.63 11.76 105.87 10.59 95.28
190.00 9.50 180.50 9.03 171.48 8.57 162.90 8.15 154.76
180.00 18.00 162.00 16.20 145.80 14.58 131.22 13.12 118.10
19.13 2.87 16.26 2.44 13.82 2.07 11.75 1.76 9.98
2572.80 246.83 2325.97 220.38 2105.59 196.95 1908.64 176.18 1732.47
2028 2028 2029 2029 2030 2030 2031 2031
DEP NB DEP NB DEP NB DEP NB
0.00 70.35 0.00 70.35 0.00 70.35 0.00 70.35
87.35 786.14 78.61 707.52 70.75 636.77 63.68 573.09
4.11 78.00 3.90 74.10 3.71 70.40 3.52 66.88
28.95 164.04 24.61 139.44 20.92 118.52 17.78 100.74
3.87 73.51 3.68 69.83 3.49 66.34 3.32 63.02
2.90 55.13 2.76 52.38 2.62 49.76 2.49 47.27
9.53 85.75 8.58 77.18 7.72 69.46 6.95 62.51
7.74 147.02 7.35 139.67 6.98 132.68 6.63 126.05
11.81 106.29 10.63 95.66 9.57 86.09 8.61 77.48
1.50 8.49 1.27 7.21 1.08 6.13 0.92 5.21
157.75 1574.72 141.38 1433.34 126.83 1306.51 113.89 1192.62
Unhide Ribbon CNTRL+F1
Goal Seek ALT+T+G
Merge Sells ALT+H+M+M
View Macros ALT+F8
Keep cell reference c F4(Cursor on Cell REF)
FURNIT
LAND & Fire URE & Utilities Hvac
Asset SITE
Fighting P&M Electrical
DEVELOP BUILDINGS Installation FIXTUR & Water ET MECH Comps
Particulars MENT FACTORY System s ES System PLant piping Printers
Rate of Dep 10.00% 5.00% 15.00% 5.00% 5.00% 10.00% 5.00% 10.00% 15.00%
2022 GB 70.35 1479.26 106.11 434.96 100.00 75.00 161.36 200.00 200.00 22.50
2023 DEP 0.00 147.93 5.31 65.24 5.00 3.75 16.14 10.00 20.00 3.38
2023 NB 70.35 1331.33 100.80 369.72 95.00 71.25 145.22 190.00 180.00 19.13
2024 DEP 0.00 133.13 5.04 55.46 4.75 3.56 14.52 9.50 18.00 2.87
2024 NB 70.35 1198.20 95.76 314.26 90.25 67.69 130.70 180.50 162.00 16.26
2025 DEP 0.00 119.82 4.79 47.14 4.51 3.38 13.07 9.03 16.20 2.44
2025 NB 70.35 1078.38 90.98 267.12 85.74 64.30 117.63 171.48 145.80 13.82
2026 DEP 0.00 107.84 4.55 40.07 4.29 3.22 11.76 8.57 14.58 2.07
2026 NB 70.35 970.54 86.43 227.05 81.45 61.09 105.87 162.90 131.22 11.75
2027 DEP 0.00 97.05 4.32 34.06 4.07 3.05 10.59 8.15 13.12 1.76
2027 NB 70.35 873.49 82.11 192.99 77.38 58.03 95.28 154.76 118.10 9.98
2028 DEP 0.00 87.35 4.11 28.95 3.87 2.90 9.53 7.74 11.81 1.50
2028 NB 70.35 786.14 78.00 164.04 73.51 55.13 85.75 147.02 106.29 8.49
2029 DEP 0.00 78.61 3.90 24.61 3.68 2.76 8.58 7.35 10.63 1.27
2029 NB 70.35 707.52 74.10 139.44 69.83 52.38 77.18 139.67 95.66 7.21
2030 DEP 0.00 70.75 3.71 20.92 3.49 2.62 7.72 6.98 9.57 1.08
2030 NB 70.35 636.77 70.40 118.52 66.34 49.76 69.46 132.68 86.09 6.13
SUB
TOTAL
2849.54
276.74
2572.80
246.83
2325.97
220.38
2105.59
196.95
1908.64
176.18
1732.47
157.75
1574.72
141.38
1433.34
126.83
1306.51

Annu Exports - XLSM

Uploaded by

Copyright:

Available Formats

Annu Exports - XLSM

Uploaded by

Document Information

Original Title

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

Annu Exports - XLSM

Uploaded by

Copyright:

Available Formats

2019 2020 2021 2022

Opening Stock 94.91 122.28 116.70

Audited Audited Provis Proj

2023 2027 2028 2029 2030 2031 2032 2033 2034

Surplus 3.20 13.96 52.18

0.00 #NAME? #NAME? #NAME? #NAME?

0.00 #NAME? #NAME? #NAME? #NAME?

66.70 #NAME? #NAME? #NAME? #NAME?

Actual CB 1.65 3.17

51.37 65.98 #NAME? #NAME? #NAME? #NAME?

0.00 0.00 #NAME? #NAME? #NAME? #NAME?

0.00 0.00 #NAME? #NAME? #NAME? #NAME?

-24.69 -29.98 #NAME? #NAME? #NAME? #NAME?

3.17 3.48 3.50 #NAME? #NAME? #NAME?

3.48 3.50 #NAME? #NAME? #NAME? #NAME?

When RM cost goes up by 10%

When Variable costs go up by 10%

When RM cost goes up by 10%

When Variable costs go up by 10%

Land 70.35 Capital 10.00

Interest during 149.26

2023 Methimazole 34500 1800 62100000 9441 16993800

2022 0.00 149.26

You might also like