Zoho Sheet

NPV Calculator
Add custom cash flows or create auto-generated cash flow series (uniform, gradient, and exponential series).											© 2009 Vertex42 LLC
You can delete, copy, and insert new columns, but make sure the Sum column is correct after making changes.											HELP
The Net Present Value for each series is calculated, along with the Total NPV. Edit the light-blue cells.
The IRR function is used to calculate the overall Internal Rate of Return. It requires an initial guess.

		NPV	14,649.49
		IRR	9.054%

		Discount Rate (i)	6%

			Auto-Generated Cash Flow Series
		Series Type:	Uniform (A)	Gradient (G)	Exp Grad	none
		Value (A, G, or Eo):	100	100	100
		g (for Exp Grad):			5%
		Periods:	5	10	7			Custom Cash Flow Series
		NPV:	421.24	2,960.23	674.08	-	2,148.66	4,471.70	(1,872.95)	5,846.53
						IRR:	16.34%	9.63%	4.14%	8.66%
	Period	Sum	Series 1	Series 2	Series 3	Series 4	Label 1	Label 2	Label 3	Label 4
	0	(150,000.00)	-	-	-	-		(40,000.00)	(40,000.00)	(70,000.00)
	1	18,205.00	100.00	-	105.00	-	(10,000.00)	8,000.00	8,000.00	12,000.00
	2	36,710.25	100.00	100.00	110.25	-	3,000.00	9,200.00	9,200.00	15,000.00
	3	42,615.76	100.00	200.00	115.76	-	4,200.00	10,000.00	10,000.00	18,000.00
	4	52,321.55	100.00	300.00	121.55	-	6,800.00	12,000.00	12,000.00	21,000.00
	5	55,627.63	100.00	400.00	127.63	-		14,500.00	14,500.00	26,000.00
	6	(8,365.99)	-	500.00	134.01	-			(9,000.00)
	7	740.71	-	600.00	140.71	-
	8	700.00	-	700.00	-	-
	9	800.00	-	800.00	-	-
	10	900.00	-	900.00	-	-
	11	-	-	-	-	-
	12	-	-	-	-	-
	13	-	-	-	-	-
	14	-	-	-	-	-
	15	-	-	-	-	-
	16	-	-	-	-	-
	17	-	-	-	-	-
	18	-	-	-	-	-
	19	-	-	-	-	-
	20	-	-	-	-	-
	21	-	-	-	-	-
	22	-	-	-	-	-
	23	-	-	-	-	-
	24	-	-	-	-	-
	25	-	-	-	-	-
	26	-	-	-	-	-
	27	-	-	-	-	-
	28	-	-	-	-	-
	29	-	-	-	-	-
	30	-	-	-	-	-
	31	-	-	-	-	-
	32	-	-	-	-	-
	33	-	-	-	-	-
	34	-	-	-	-	-
	35	-	-	-	-	-
	36	-	-	-	-	-
	37	-	-	-	-	-
	38	-	-	-	-	-
	39	-	-	-	-	-
	40	-	-	-	-	-

NPV

XNPV

TermsOfUse