Piezoelectric Energy Generation from Vehicle Traffic with Technoeconomic Analysis

Table 15

Cash flow when speed of travel is 120 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	57,517.9	102,302.2	198,213.9	379,421.8	742,420.2	1,463,951.0	2,904,455.8	5,788,475.3	11,559,944.6	23,118,219.0	378,566,157,650.5	387,651,738,247,979.0	775,303,476,481,578.0
Loan	550,000.0
Production income	0.0	32,812.2	21,748.7	28,092.0	17,476.4	18,059.0	13,592.9	11,036.2	14,046.0	17,476.4	32,812.2	20,102.6	32,812.2	20,102.6	20,772.6
Total cash receipts	550,000.0	62,406.3	79,266.6	130,394.2	215,690.3	397,480.8	756,013.2	1,474,987.2	2,918,501.9	5,805,951.7	11,592,756.8	23,138,321.5	378,566,190,462.7	387,651,738,268,081.0	775,303,476,502,350.0
Total cash available	550,000.0	92,000.3	136,784.6	232,696.3	413,904.2	776,902.6	1,498,433.4	2,938,938.2	5,822,957.7	11,594,427.0	23,152,701.4	46,256,540.5	757,132,348,113.2	775,303,476,516,060.0	1,550,606,952,983,930.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	27,923.9	44,784.2	95,911.7	181,207.9	362,998.4	721,530.8	1,440,504.8	2,884,019.5	5,771,469.3	11,558,274.4	23,103,839.1	378,566,155,980.3	387,651,738,233,599.0	775,303,476,484,850.0
Net cash flow	−520,405.9	27,923.9	44,784.2	95,911.7	181,207.9	362,998.4	721,530.8	1,440,504.8	2,884,019.5	5,771,469.3	11,558,274.4	23,103,839.1	378,566,155,980.3	387,651,738,233,599.0	775,303,476,484,850.0
Cumulative cash flow	−520,405.9	−492,482.1	−447,697.8	−351,786.1	−170,578.2	192,420.2	913,951.0	2,354,455.8	5,238,475.3	11,009,944.6	22,568,219.0	45,672,058.1	757,131,763,630.8	775,303,475,931,578.0	1,550,606,952,416,430.0
Cash position	29,594.1	57,517.9	102,302.2	198,213.9	379,421.8	742,420.2	1,463,951.0	2,904,455.8	5,788,475.3	11,559,944.6	23,118,219.0	46,222,058.1	757,132,313,630.8	775,303,476,481,578.0	1,550,606,952,966,430.0
IRR	100%
ROI	−1.946	−0.949	−0.918	−0.825	−0.670	−0.340	0.311	1.619	4.243	9.493	20.015	41.006	688301.101	704821341.2	1409642684
Bankrupt?	False	False	False	False	False	False	False	False	False	False	False	False	False	False	False