Cash flow for implementing the systems for rainwater harvesting (US$)
| Year . | 0 . | 1 . | 2 . | 3 . | 4 . | 5 . | 6 . | 7 . | 8 . | 9 . | 10 . |
|---|---|---|---|---|---|---|---|---|---|---|---|
| Costs | |||||||||||
| Initial investment | −35,302.1 | – | – | – | – | – | – | – | – | – | – |
| Investment during the project | – | – | – | – | – | −230.0 | – | – | – | – | −230.0 |
| Operation and maintenance | −2,051.9 | −2,225.0 | −2,412.7 | −2,616.5 | −2,837.7 | −3,077.8 | −3,338.5 | −3,621.4 | −3,928.5 | −4,261.8 | −4,623.8 |
| Benefits | |||||||||||
| Water saving from public network | 8,787.2 | 9,557.0 | 10,394.2 | 11,304.7 | 12,295.0 | 13,372.1 | 14,543.5 | 15,817.5 | 17,203.1 | 18,710.1 | 20,349.1 |
| Annual flow | −28,566.8 | 7,332.0 | 7,981.5 | 8,688.2 | 9,457.3 | 10,064.2 | 11,205.0 | 12,196.1 | 13,274.6 | 14,448.2 | 15,495.3 |
| NPV | −28,566.8 | −21,825.3 | −15,077.8 | −8,324.4 | −1,565.3 | 5,048.3 | 11,818.4 | 18,593.9 | 25,374.5 | 32,160.1 | 38,851.4 |
| IRR (%) | – | −76.4% | −38.2% | −15.4% | −2.2% | 5.7% | 10.9% | 14.4% | 16.8% | 18.5% | 19.7% |
| B/I | 0.2 | 0.5 | 0.8 | 1.1 | 1.5 | 1.9 | 2.3 | 2.7 | 3.2 | 3.7 | 4.3 |
| Amortization year | 5.0 | – | – | – | – | – | – | – | – | – | – |
| Year . | 0 . | 1 . | 2 . | 3 . | 4 . | 5 . | 6 . | 7 . | 8 . | 9 . | 10 . |
|---|---|---|---|---|---|---|---|---|---|---|---|
| Costs | |||||||||||
| Initial investment | −35,302.1 | – | – | – | – | – | – | – | – | – | – |
| Investment during the project | – | – | – | – | – | −230.0 | – | – | – | – | −230.0 |
| Operation and maintenance | −2,051.9 | −2,225.0 | −2,412.7 | −2,616.5 | −2,837.7 | −3,077.8 | −3,338.5 | −3,621.4 | −3,928.5 | −4,261.8 | −4,623.8 |
| Benefits | |||||||||||
| Water saving from public network | 8,787.2 | 9,557.0 | 10,394.2 | 11,304.7 | 12,295.0 | 13,372.1 | 14,543.5 | 15,817.5 | 17,203.1 | 18,710.1 | 20,349.1 |
| Annual flow | −28,566.8 | 7,332.0 | 7,981.5 | 8,688.2 | 9,457.3 | 10,064.2 | 11,205.0 | 12,196.1 | 13,274.6 | 14,448.2 | 15,495.3 |
| NPV | −28,566.8 | −21,825.3 | −15,077.8 | −8,324.4 | −1,565.3 | 5,048.3 | 11,818.4 | 18,593.9 | 25,374.5 | 32,160.1 | 38,851.4 |
| IRR (%) | – | −76.4% | −38.2% | −15.4% | −2.2% | 5.7% | 10.9% | 14.4% | 16.8% | 18.5% | 19.7% |
| B/I | 0.2 | 0.5 | 0.8 | 1.1 | 1.5 | 1.9 | 2.3 | 2.7 | 3.2 | 3.7 | 4.3 |
| Amortization year | 5.0 | – | – | – | – | – | – | – | – | – | – |