| | 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 |
|
|