Piezoelectric Energy Generation from Vehicle Traffic with Technoeconomic Analysis

Table 12

Cash flow when speed of travel is 60 kmph.

	1	2	3	4	6	7	8	9	10	11	12	14	26
Cash receipts
Available cash	0.0	29,594.1	31,242.6	32,623.5	43,017.7	55,402.5	79,515.9	127,142.8	223,102.9	415,448.6	802,951.8	3,119,680.8	12,660,114,761.2
Loan	550,000.0
Production income	0.0	6,536.9	4,620.6	6,122.9	3,849.5	3,193.2	2,593.4	3,299.7	3,725.3	6,536.9	3,732.2	6,536.9	6,536.9
Total cash receipts	550,000.0	36,131.0	35,863.2	38,746.4	46,867.2	58,595.8	82,109.3	130,442.5	226,828.2	421,985.5	806,683.9	3,126,217.7	12,660,121,298.1
Total cash available	550,000.0	65,725.0	67,105.9	71,369.8	89,884.9	113,998.3	161,625.2	257,585.3	449,931.0	837,434.2	1,609,635.7	6,245,898.4	25,320,236,059.4
Cash paid out
Infrastructural and manufactural expenses	−150,712.7
Raw material expenditure	−352,710.8
Total expenditure	−503,423.5	−17,500.0	−17,500.0	−17,500.0	−17,500.0	−17,500.0	−17,500.0	−17,500.0	−17,500.0	−17,500.0	−17,500.0	−17,500.0	−17,500.0
Loan repayment	−16,982.4	−16,982.4	−16,982.4	−16,982.4	−16,982.4	−16,982.4	−16,982.4	−16,982.4	−16,982.4	−16,982.4	−16,982.4	−16,982.4	−16,982.4
Total cash paid out	−520,405.9	−34,482.4	−34,482.4	−34,482.4	−34,482.4	−34,482.4	−34,482.4	−34,482.4	−34,482.4	−34,482.4	−34,482.4	−34,482.4	−34,482.4
Net cash flow with loan	29,594.1	1,648.6	1,380.8	4,264.0	12,384.8	24,113.4	47,626.9	95,960.1	192,345.8	387,503.1	772,201.5	3,091,735.3	12,660,086,815.7
Net cash flow	−520,405.9	1,648.6	1,380.8	4,264.0	12,384.8	24,113.4	47,626.9	95,960.1	192,345.8	387,503.1	772,201.5	3,091,735.3	12,660,086,815.7
Cumulative cash flow	−520,405.9	−518,757.4	−517,376.5	−513,112.6	−494,597.5	−470,484.1	−422,857.2	−326,897.1	−134,551.4	252,951.8	1,025,153.3	5,661,416.0	25,319,651,577.0
Cash position	29,594.1	31,242.6	32,623.5	36,887.4	55,402.5	79,515.9	127,142.8	223,102.9	415,448.6	802,951.8	1,575,153.3	6,211,416.0	25,320,201,577.0
IRR	81%
ROI	−1.946	−0.997	−0.997	−0.992	−0.977	−0.956	−0.913	−0.825	−0.650	−0.295	0.404	4.621	23017.339
Bankrupt?	False	False	False	False	False	False	False	False	False	False	False	False	False