Year 0 Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 sales revenue 91,835.00 318,240.00 318,240.00 318,240.00 318,240.00 318,240.00 costs geodes (37,273.70) (111,027.60) (111,027.60) (111,027.60) (111,027.60) (111,027.60) labor (20,400.00) (20,400.00) (20,400.00) (20,400.00) (20,400.00) (20,400.00) overheads (6,600.00) (3,600.00) (3,600.00) (3,600.00) (3,600.00) (3,600.00) capital requirements investment (450,000.00) cash flow (450,000.00) 27,561.30 183,212.40 183,212.40 183,212.40 183,212.40 183,212.40 cumulative cash flow (450,000.00) (422,438.70) (239,226.30) (56,013.90) 127,198.50 310,410.90 493,623.30 payback period 3.3 years 0.31 discount factor 3% 1.00 0.97 0.94 0.92 0.89 0.86 0.84 discounted cash flow (450,000.00) 26,758.54 172,695.26 167,665.30 162,781.84 158,040.63 153,437.50 cumulative DCF (450,000.00) (423,241.46) (250,546.20) (82,880.90) 79,900.95 237,941.57 391,379.07 NPV 391,379.07