Piezoelectric Energy Generation from Vehicle Traffic with Technoeconomic Analysis

Table 14

Cash flow when speed of travel is 80 kmph.

	1	2	3	4	5	6	7	8	9	10	11	12	26	36	37
Cash receipts
Available cash	0.0	29,594.1	35,821.7	45,364.0	66,654.5	105,395.5	183,096.5	336,819.7	643,306.5	1,257,410.1	2,486,906.8	4,950,447.2	80,661,775,741.9	82,597,633,005,820.9	165,195,265,983,507.0
Loan	550,000.0
Production income	0.0	11,116.0	8,203.0	10,408.9	6,568.9	6,787.9	5,109.2	4,149.4	5,279.5	6,568.9	11,116.0	6,347.8	11,116.0	6,347.8	6,559.4
Total cash receipts	550,000.0	40,710.1	44,024.7	55,772.9	73,223.4	112,183.4	188,205.7	340,969.2	648,586.0	1,263,979.1	2,498,022.8	4,956,795.0	80,661,786,857.9	82,597,633,012,168.7	165,195,265,990,067.0
Total cash available	550,000.0	70,304.1	79,846.4	101,136.9	139,877.9	217,578.9	371,302.1	677,788.9	1,291,892.5	2,521,389.2	4,984,929.6	9,907,242.2	161,323,562,599.8	165,195,266,017,990.0	330,390,531,973,574.0
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	−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	−16,982.4	0.0
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	−34,482.4	−17,500.0
Net cash flow with loan	29,594.1	6,227.7	9,542.3	21,290.5	38,741.0	77,701.0	153,723.3	306,486.8	614,103.6	1,229,496.7	2,463,540.4	4,922,312.6	80,661,752,375.5	82,597,632,977,686.3	165,195,265,972,567.0
Net cash flow	−520,405.9	6,227.7	9,542.3	21,290.5	38,741.0	77,701.0	153,723.3	306,486.8	614,103.6	1,229,496.7	2,463,540.4	4,922,312.6	80,661,752,375.5	82,597,632,977,686.3	165,195,265,972,567.0
Cumulative cash flow	−520,405.9	−514,178.3	−504,636.0	−483,345.5	−444,604.5	−366,903.5	−213,180.3	93,306.5	707,410.1	1,936,906.8	4,400,447.2	9,322,759.8	161,322,978,117.4	165,195,265,433,507.0	330,390,531,406,074.0
Cash position	29,594.1	35,821.7	45,364.0	66,654.5	105,395.5	183,096.5	336,819.7	643,306.5	1,257,410.1	2,486,906.8	4,950,447.2	9,872,759.8	161,323,528,117.4	165,195,265,983,507.0	330,390,531,956,074.0
IRR	90%
ROI	−1.946	−0.988	−0.982	−0.961	−0.929	−0.858	−0.720	−0.442	0.116	1.235	3.479	7.949	146656.731	150177513.5	300355028
Bankrupt?	False	False	False	False	False	False	False	False	False	False	False	False	False	False	False