0% found this document useful (0 votes)
19 views45 pages

Project Cost Breakdown and Funding Analysis

The document provides cost details for setting up a cement manufacturing project with an annual capacity of 99,000 tonnes. It includes the cost of various fixed assets like land, buildings, plant and machinery. It also provides details of raw material requirements, power costs, manpower costs and projected profits over the first 5 years of operations. The total project cost is estimated to be ₹720.74 lacs to be funded through a debt-equity ratio of 0.321 with ₹365 lacs from equity and ₹175 lacs as term loan.

Uploaded by

Rohit Singh
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLS, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
19 views45 pages

Project Cost Breakdown and Funding Analysis

The document provides cost details for setting up a cement manufacturing project with an annual capacity of 99,000 tonnes. It includes the cost of various fixed assets like land, buildings, plant and machinery. It also provides details of raw material requirements, power costs, manpower costs and projected profits over the first 5 years of operations. The total project cost is estimated to be ₹720.74 lacs to be funded through a debt-equity ratio of 0.321 with ₹365 lacs from equity and ₹175 lacs as term loan.

Uploaded by

Rohit Singh
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLS, PDF, TXT or read online on Scribd

(All figures are in lacs)

Cost of Project
A). Land & Site Development
B). Buildings & Civil works

C). Plant & Machinery


D).Miscellaneous Fixed asset
E).Premilary Expense
G).Pre-Operative Expense
H).Conteingencies
I).Margin Money for working capital 1st year
Total Cost of project

(All figures are in lacs)

Cost of Project
Contents

). Land & Site Development


Basic Cost
). Buildings & Civil works
Buildings
Site Development
). Plant & Machinery
D).Miscellaneous Fixed asset
).Premilary Expense
Public Issue Expense
).Pre-Operative Expense
H).Conteingencies
.Margin Money for working capital 1st year
otal Cost of project

Sources of Fund (in lac


Amount
20.47
20.47
77.84
64.00
13.84
214.00
238.00
16.50
16.50
69.50
35.09
49.34
720.74

Contents
Debt
Equity
Shareholder contribution
Total

ces of Fund (in lacs)

d/E RATIO
Amount
175.00
365.00
180.74
720.74

0.321
175.14

Minm Contribution
180.1856006944

545.74
54.5742402778
81.8613604167
Conteingencies
Firm Items
Contengencies @ 5%
Building & Site development
77.84
3.892
Plant & Machinery
214.00
10.7
Miscellaneous Fixed asset
238.00
11.9
Total
26.492
Non Firm Item
Contengencies @ 10%
Public Issue Expense
16.50
1.65
Pre-Operative Expense
69.50
6.95
Total
8.6
Total Contengencies
35.092

Initial cash Flow

(All figures are in lacs)


Cash flows from long-term funds point
Year 0
#REF!

Operating cash flow


(+) PAT
(+)
(+)
(+)
Less

Interest on term Loan (1-T), tax rate=33%


Depreciation
Preminary Expenses
Increase in WC Margin

Terminal cash Flow


(+) Net salvage value of fixed assets
(+) Net salvage value of WC margin

TOTAL

#REF!

es are in lacs)
-term funds point of view
Year 1
Year 2

Year 3

Year 4

Year 5

72.62

87.36

124.35

123.83

124.16

23.45
39.53
2.75
0.00

20.52
39.53
2.75
8.14

15.83
39.53
2.75
16.28

11.14
39.53
2.75
0.03

6.45
39.53
2.75
0.03

#REF!
73.83

138.35 142.02 166.19 177.22

#REF!

Salvage value of fixed assets


Category
Book value
Land
#REF!
93.21
Building & Civil Works
256.24
Plant & Machinery
Miscellaneous Fixed
Assets
284.98
Total

Depreciation Terminal Value


0.00
#REF!
13.98
79.22
140.93
115.31
42.75
197.66

242.23
#REF!

Particulars\Years
Sales
Variable Expenses
Raw Material
Consumables
Power
Repairs
Wages ( 5% increase, 3rd year)
Contengencies (@5%)
Total variable Expenses
Fixed Expenses
Administrative OH
Salaries( 5% increase, 3rd year)
Selling Expenses( @ 3% of sales)
Total Fixed Expense
OPBIDT
Less: Depreciation
OPBIT
Less: Financial Charges
Interest on working capital
Interest on term loan
Total Financial charges
OPBT
Preliminary Expenses Written off ( in 5 years)
PBT
Provision for tax (@ 35%)
PAT
Dividends
RE

(All figures are in lacs)


Year 1
831.006
519.540
1.998
43.200
12.88
9.33
3.27
590.22
22.00
7.33
24.93
54.26
186.52
39.53
146.99
31.08
35.00
66.08
80.90
2.75
78.15
5.53
72.62
0
72.62

s are in lacs)
Year 2
Year 3
Year 4
Year 5
Year 6
969.507
1246.509
1246.509
1246.509
1246.509
606.130
2.331
48.400
14.81
10.89
3.70
686.26

779.310
2.997
58.800
19.32
14.00
4.61
879.03

779.310
2.997
58.800
19.32
14.70
4.64
879.77

779.310
2.997
58.800
19.32
15.44
4.68
880.54

779.310
2.997
58.800
19.32
16.21
4.72
881.35

25.00
8.56
29.09
62.64
220.60
39.53
181.07

30.00
11.00
37.40
78.40
289.08
39.53
249.55

30.00
11.55
37.40
78.95
287.80
39.53
248.26

30.00
12.13
37.40
79.52
286.45
39.53
246.91

30.00
12.73
37.40
80.13
285.03
39.53
245.50

36.21
46.47
46.49
46.51
46.54
30.63
23.63
16.63
9.63
2.63
66.84
70.09
63.12
56.14
49.16
114.23
179.45
185.15
190.78
196.34
2.75
2.75
2.75
2.75
2.75
111.48
176.70
182.40
188.03
193.59
24.13
52.35
58.57
63.87
68.46
87.36
124.35
123.83
124.16
125.13
54.57 81.8613604 81.8613604 81.8613604 81.8613604
32.78
42.49
41.97
42.30
43.27

(All figures are in lacs)


WACC
Cost of Equity
Cost of debt

15.00%
20.00%

Equity
Debt
Tax
NPV
Cash Flows

#REF!
#REF!
33%

#REF!
#REF!

Year 0
Year 1
Year 2
#REF! 138.35 142.02
NPV

#REF! IRR

are in lacs)

WACC

#REF!

Year 3
Year 4
Year 5
166.19 177.22
#REF!
#REF!

PAT
Depreciation
Premiliary Expense
Total
Interest on Term Loan
Principal repayed
Total
DSCR

Calculation of DS
Year 1
72.62
39.53
2.75
114.90
35.00
0.00
35.00
3.28

Calculation of DSCR
Year 2
Year 3
87.36
124.35
39.53
39.53
2.75
2.75
129.64
166.64

Year 4
123.83
39.53
2.75
166.11

Year 5
124.16
39.53
2.75
166.44

8.31
8.75
17.06

7.88
8.75
16.63

7.44
8.75
16.19

7.00
8.75
15.75

7.60

10.02

10.26

10.57

[Link]. Category
1
PVC pipe 90mm
2
PVC Pipe 110mm

Selling Price(per Meter)


100.00
150.00

Year on Growth
6%
6%

Product/Year
Production (tpa)
S/P Per Tonn
Total Sales(a)
Total Sales
Total Sales ( in lacs)

Year 1
59400
1399.00
83100600.00
83100600.00
831.01

Year
Capicity Utilization

Cement

Year 1

Year 2
60%

70%

Installed Capacity (100%)


99000 tpa

Year 2

Year 3

Year 4

69300
1399.00
96950700.00

89100
1399.00
124650900.00

89100
1399.00
124650900.00

96950700.00
969.51

124650900.00
1246.51

124650900.00
1246.51

Year 3

Year 4
90%

Year 5

90%

Year 6

89100
1399.00
124650900.00

89100
1399.00
124650900.00

124650900.00
1246.51

124650900.00
1246.51

Year 5
90%

Year 6
90%

Raw Material Requirement @ 100% Capacity (


[Link].
Material
1
Clincker
2
Slag
3
Gypsum

[Link].
1
2
3

Raw Material Requirement @ 60% Ca


Material
Clincker
Slag
Gypsum

Raw Material Requirement @ 70% Capacity (9


[Link].
Material
1
Clincker
2
Slag
3
Gypsum

Raw Material Requirement @ 90% Capacity (9


[Link].
Material
1
Clincker
2
Slag
3
Gypsum

Requirement @ 100% Capacity (99000tpa)


Quantity(in lakh tonnes) Rate (/tonn)
0.6

1,130.00
0.41

300.00
0.59

110.00

Material Requirement @ 60% Capacity (99000tpa)


Quantity(in lakh tonnes) Rate (/tonn) Total (in lackhs)
0.36

1,130.00
406.80
0.246

300.00
73.80
0.354

110.00
38.94
Total (in lackhs)
519.54

Requirement @ 70% Capacity (99000tpa)


Total (in lackhs)
Quantity(in lakh tonnes) Rate (/tonn)
0.42

1,130.00
474.60
0.287

300.00
86.10
0.413

110.00
45.43
Total (in lackhs)
606.13
Requirement @ 90% Capacity (99000tpa)
Total (in lackhs)
Quantity(in lakh tonnes) Rate (/tonn)
0.54

1,130.00
610.20
0.369

300.00
110.70
0.531

110.00
58.41
Total (in lackhs)
779.31

Year
Capicity Utilization

Raw Material(in lacs)

Consumables @ 100% (lacs)


Consumables (lacs)

Year 1
60%

Year 2
70%

Year 3
90%

Year 1

Year 2

Year 3

519.54

606.13

779.31

3.33

Year 1

Year 2
1.998

Year 3
2.331

2.997

Year 4
90%

Year 5
90%

Year 4

Year 5
779.31

Year 4

Year 6
90%

Year 6
779.31 779.31

Year 5
2.997

Year 6
2.997

2.997

AT 100% Capacity

Fixed Charges
Energy Charges

12.00
52.00

Year
Capicity Utilization

Year 1
Fixed Charges
Energy charges
Total Power Cost
Total Power Cost (lacs)

12.00
31.20
43.20
43.20

Year 1
60%

Year 2
70%

Year 3
90%

Year 4
90%

Year 2

Year 3

Year 4

Year 5

12.00
36.40
48.40

12.00
46.80
58.80

12.00
46.80
58.80

12.00
46.80
58.80

48.40

58.80

58.80

58.80

Year 5
90%

Year 6
12.00
46.80
58.80
58.80

Year 6
90%

Sl. No.
1
2
3
4
5
6
7

Designation
Manager
Chemist
Clerk cum typist
Accountant
Storekeeper
Skilled workers
Peon cum watchman

Wages ( In Lacs)

No.

Salary
1
1
2
1
2
5
2

Total salary

120,000.00 120,000.00
84,000.00
84,000.00
72,000.00 144,000.00
72,000.00
72,000.00
60,000.00 120,000.00
48,000.00 240,000.00
36,000.00
72,000.00
Total
852,000.00
Total(in lacs)
8.52
YoY growth
5%

Year 2015
Year 2016
Year 2017
8.52
8.95
9.39

Year 2018
Year 2019
9.86
10.36

(All figures

Allocation of Pre-opera
Assets
Costs
a). Buildings & Site Development
77.84
b).Plant & Machienry
214.00
c).Miscellaneous Fixed asset
238.00
Total
529.84

Pre-Operative Expense
Conteingencies

69.50
35.09

Depreciation as
Year 1
a). Buildings & Civil works
b).Plant & Machienry
c).Miscellaneous Fixed asset
Total

2.80
28.19
8.55
39.53

Depreciation as p
Year 1
a). Buildings & Civil works
b).Plant & Machienry
c).Miscellaneous Fixed asset
Total

9.32
64.06
28.50
101.88

(All figures are in lacs)

ocation of Pre-operative & Conteingencies


% in total
Pre-Operative Expense Conteingencies
0.15
10.21
5.16
0.40
28.07
14.17
0.45
31.22
15.76
1.00
69.50
35.09

Depreciation as per Companies Act ( SLM)


Year 2
Year 3
Year 4
2.80
2.80
28.19
28.19
8.55
8.55
39.53
39.53

2.80
28.19
8.55
39.53

Depreciation as per Income tax Act ( WDM)


Year 2
Year 3
Year 4
8.39
7.55
48.05
36.03
25.65
23.08
82.08
66.67

6.79
27.03
20.78
54.60

Total
93.21
256.24
284.98

Year 5

Year 6
2.80
2.80
28.19 28.19
8.55
8.55
39.53 39.53

Year 5

Year 6
6.12
5.50
20.27 15.20
18.70 16.83
45.08 37.53

Depreciation Rates
Particulars
As per Companies Act
As per Income Tax

Buildings
3.00%
10%

Machinery Miscellaneous Fixed Assets


11.00%
3.00%
25%
10%

(All figures are in lac


Working Capital Require
Particulars
Period Year 1
Raw materials
2.0
86.59
Consumables
2.0
0.33
Work in Progress
0.50
24.46
Finished Goods
1.0
51.36
Creditors
0.50
34.63
TOTAL
197.36
Bank Finance (75%)
148.02
Margin Money(25%)
49.34

Money
Interest

Interest On working ca
Year 1
Year 2
148.02
172.44
31.08
36.21

(All figures are in lacs)


rking Capital Requirement
Year 2
Year 3
Year 4
Year 5
Year 6
101.02
129.89
129.89
129.89 129.89
0.39
0.50
0.50
0.50
0.50
28.44
36.43
36.46
36.49
36.53
59.68
76.29
76.39
76.50
76.61
40.40
51.94
51.94
51.94
51.94
229.92
295.04 295.18 295.32 295.46
172.44
221.28 221.38 221.49 221.60
57.48
73.76
73.79
73.83 73.87

terest On working capital


Year 3
Year 4
Year 5
Year 6
221.28
221.38
221.49
221.60
46.47
46.49
46.51
46.54

Bank standard Loan rate for Working Capital


21.00%

Standard Bank Interest rate


Repayment
Year

20%

Year 1
35.00

(figures are i
Repayment & Intere
Year 1
Amount
Repayed
Interest

175.00
0.00
35.00

Year 2
Year 3
Year 4
Year 5
Year 6
30.63
23.63
16.63
9.63
2.63

(figures are in lacs)


yment & Interest schedule
Year 2
Q1
Q2
Q3
Q4
Q5
175.00
166.25
157.50 148.75 140.00
8.75
8.75
8.75
8.75
8.75
8.31
7.88
7.44
7.00
6.56

Year 3

Year 3
Year 4
Q6
Q7
Q8
Q9
Q10
Q11
131.25 122.50 113.75 105.00
96.25
87.50
8.75
8.75
8.75
8.75
8.75
8.75
6.13
5.69
5.25
4.81
4.38
3.94

Year 5
Year 6
Q12
Q13
Q14
Q15
Q16
Q17
Q18
78.75 70.00 61.25 52.50 43.75 35.00 26.25
8.75 8.75 8.75 8.75 8.75 8.75 8.75
3.50 3.06 2.63 2.19 1.75 1.31 0.88

Year 6
Q19
Q20
17.50 8.75
8.75 8.75
0.44 0.00

Year
PBT
Add Dep. (SLM)
Less Dep( WDV)
Less Unabsorbed losses
Taxable Income
Tax @35%
Total

(figures are in
Computation of Tax
Year 1
78.15
39.53
101.88
0.00
15.81
5.53
5.53

(figures are in lacs)


omputation of Tax (in lacs)
Year 2
Year 3
Year 4
Year 5
Year 6
111.48
176.70
182.40
188.03 193.59
39.53
39.53
39.53
39.53
39.53
82.08
66.67
54.60
45.08
37.53
0.00
0.00
0.00
0.00
0.00
68.93
149.57
167.33
182.48 195.59
24.13
52.35
58.57
63.87
68.46
24.13
52.35
58.57
63.87 68.46

Common questions

Powered by AI

The cash flows generated over the project's lifecycle show a steady increase in operating cash flow from ₹72.62 lacs in Year 1 to ₹124.16 lacs in Year 5. However, there is a notable influence of interest and depreciation on cash flows and net present value (NPV) in different years. The steady increase in cash flow reflects strong financial health potential, provided assumptions about operations remain valid. The implication for financial health is positive, indicating robust capabilities to repay debt obligations and potentially reward shareholders, aligning with the project's strategic goals.

The debt-to-equity (D/E) ratio for the company's project financing is 0.32. This ratio indicates that the company is using a conservative amount of debt compared to equity to finance its project. Such a ratio suggests a balance between leveraging debt for growth and maintaining equity to mitigate financial risk. The choice of this D/E ratio can reflect a strategy to ensure the company has a manageable debt load while still benefitting from the potential tax advantages of debt financing.

In the project setup, the allocated cost for Miscellaneous Fixed Assets is ₹238.00 lacs, while the cost for Plant & Machinery is ₹214.00 lacs. This indicates that Miscellaneous Fixed Assets have a higher allocation by ₹24 lacs compared to Plant & Machinery, highlighting the importance and potential complexity or variety within the category of Miscellaneous Fixed Assets.

As production capacity utilization increases from 60% in Year 1 to 90% by Year 3, the raw material costs significantly rise, reflecting increased consumption. Costs grow from ₹519.54 lacs to ₹779.31 lacs proportionately with the utilization scale. This increase impacts the cost structure by shifting a higher portion of the budget towards raw materials and associated variable costs, necessitating careful management to maintain profitability margins as production scales up. Increased capacity also leverages fixed costs more effectively, enhancing economies of scale.

Fixed expenses, including administrative overheads and salaries, are projected to steadily increase over the five-year period, primarily due to assumed inflationary pressures and planned salary increments. Administrative overheads remain constant, while salaries increase by 5% each year (e.g., ₹7.33 lacs in Year 1), reflecting a structured growth matching industry standards. Such increases support staff retention and operational stability. The forecast indicates a manageable growth outlook of fixed expenses, emphasizing consideration for budget control amidst expanding operational scales.

Despite generating profits (PAT of ₹72.62 lacs) in Year 1, the company chose to retain earnings rather than issue dividends. The rationale likely involves reinvesting profits into the business to bolster future growth, support debt obligations, and strengthen the company's financial position. Retained earnings can provide financial flexibility and serve as a buffer against future operational risks or unexpected expenses. This strategic reinvestment approach aligns with long-term value creation for shareholders, by potentially increasing stock value and ensuring sustainable growth.

The use of different depreciation methods affects the taxable income significantly. The depreciation under the Straight Line Method (SLM) is given as ₹39.53 lacs, whereas the Written Down Value (WDV) method results in ₹101.88 lacs for Year 1. The larger depreciation expense under WDV reduces the taxable income to ₹15.81 lacs, thus lowering the tax liability for the period as it provides a higher expense deduction compared to SLM. This strategic choice effectively minimizes the tax burden in the early years of the asset's life.

The project's working capital management strategy faces potential challenges, notably with increasing raw material costs and the need for higher bank finance every year, from ₹148.02 lacs in Year 1 to ₹221.60 lacs by Year 6. This increasing requirement signifies operational needs could lead to liquidity pressures if cash inflows do not appropriately support outflows. The challenge lies in efficiently managing inventory levels and creditor policies to avoid excessive interest costs and ensure adequate cash available for operational continuity.

Comparing operational performance between Year 1 and Year 2 shows improvements, with sales increasing from ₹831.006 lacs to ₹969.507 lacs. Variable expenses, including raw materials and power, follow this upward trend, driven by increased capacity utilization (from 60% to 70%). Despite the rise in costs, operating profit before interest, depreciation, and tax (OPBIT) increased, suggesting improved cost management and efficiency. These indicators imply a positive business outlook, emphasizing growth potential and the opportunity for enhanced profitability as operational scale increases.

The company's contingency allocation strategy, involving 5% allocation for firm items (e.g., Plant & Machinery) and 10% for non-firm items (e.g., Public Issue Expense), provides flexibility to manage unforeseen expenses or cost overrun situations. This strategic buffer helps ensure project stability and financial resilience. By differing contingency rates, the company strategically differentiates between predictable and variable risk components, allowing for targeted risk management approaches, thus minimizing project disruption risks and enhancing overall project robustness.

You might also like