Piezoelectric Energy Generation from Vehicle Traffic with Technoeconomic Analysis

Table 13

Cash flow when speed of travel is 100 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	44,117.3	67,896.2	119,579.5	216,042.5	409,347.2	793,052.0	1,558,798.8	3,092,249.9	6,161,383.2	12,307,695.6	202,111,601,242.8	206,962,261,675,992.0	413,924,523,394,598.0
Loan	550,000.0
Production income	0.0	19,411.6	14,144.1	18,269.5	11,365.8	11,744.7	8,840.1	7,177.3	9,134.7	11,365.8	19,411.6	77,096.8	19,411.6	77,096.8	79,666.7
Total cash receipts	550,000.0	49,005.6	58,261.4	86,165.7	130,945.3	227,787.1	418,187.2	800,229.2	1,567,933.5	3,103,615.7	6,180,794.8	12,384,792.4	202,111,620,654.3	206,962,261,753,088.0	413,924,523,474,264.0
Total cash available	550,000.0	78,599.7	102,378.6	154,061.9	250,524.9	443,829.6	827,534.4	1,593,281.2	3,126,732.3	6,195,865.6	12,342,178.0	24,692,488.1	404,223,221,897.1	413,924,523,429,080.0	827,849,046,868,862.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	14,523.2	23,779.0	51,683.3	96,462.9	193,304.7	383,704.8	765,746.8	1,533,451.1	3,069,133.3	6,146,312.4	12,350,310.0	202,111,586,171.9	206,962,261,718,606.0	413,924,523,456,764.0
Net cash flow	−520,405.9	14,523.2	23,779.0	51,683.3	96,462.9	193,304.7	383,704.8	765,746.8	1,533,451.1	3,069,133.3	6,146,312.4	12,350,310.0	202,111,586,171.9	206,962,261,718,606.0	413,924,523,456,764.0
Cumulative cash flow	−520,405.9	−505,882.7	−482,103.8	−430,420.5	−333,957.5	−140,652.8	243,052.0	1,008,798.8	2,542,249.9	5,611,383.2	11,757,695.6	24,108,005.7	404,222,637,414.7	413,924,522,844,598.0	827,849,046,301,362.0
Cash position	29,594.1	44,117.3	67,896.2	119,579.5	216,042.5	409,347.2	793,052.0	1,558,798.8	3,092,249.9	6,161,383.2	12,307,695.6	24,658,005.7	404,223,187,414.7	413,924,523,394,598.0	827,849,046,851,362.0
IRR	96%
ROI	−1.946	−0.973	−0.956	−0.906	−0.824	−0.648	−0.302	0.392	1.788	4.580	10.175	21.455	367474.611	376295020.3	752590041.6
Bankrupt?	False	False	False	False	False	False	False	False	False	False	False	False	False	False	False