Zoho Sheet - NPV-calculator.xls

NPV

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

XNPV

XIRR, XNPV Calculator
This worksheet uses the XNPV function to calculate the Net Present Value							© 2009 Vertex42 LLC
for a schedule of cash flows that are not necessarily periodic. The XNPV							HELP
function requires the Analysis ToolPak add-in (see Help on XNPV function).
It assumes 365 days in the year. The XIRR function is used to calculated
the Internal Rate of Return. The dates do not need to be in order. You can
have multiple cash flows with the same date.

	Discount Rate	8%
					Days in Year	365
	NPV	#NAME?	NPV	#NAME?	NPV	2,180.51
	IRR	#NAME?	IRR	#NAME?
	Using Dynamic Ranges		Using the Exact Range		Using an Array Formula
	Date	Value	Date	Value	Date	Value
	1/1/08	(10,000.00)	1/1/08	(10,000.00)	1/1/08	(10,000.00)
	3/1/08	2,750.00	3/1/08	2,750.00	3/1/08	2,750.00
	10/30/08	4,250.00	10/30/08	4,250.00	10/30/08	4,250.00
	2/15/09	3,250.00	2/15/09	3,250.00	2/15/09	3,250.00
	4/1/09	2,750.00	4/1/09	2,750.00	4/1/09	2,750.00

TermsOfUse

Terms of Use
© 2009 Vertex42 LLC. All rights reserved.
http://www.vertex42.com/Calculators/npv-irr-calculator.html
This TermsOfUse worksheet may not be removed, modified, or deleted. It may be hidden if necessary.

Limited Use Policy
You may make archival copies and customize this template (the "Software") for personal use or for your
company use. The customized template (with your specific personal or company information) may be
used and shared within your company, but this template or any document including or derived from
this template may NOT be sold, distributed, or placed on a public server such as the internet.

Limited Warranty
We warrant that for a period of 60 days after delivery of this copy of the Software to you:
- The media on which this copy of the Software is provided to you will be free from defects in materials and workmanship under normal use, and
- The Software will perform in substantial accordance with the Documentation.
To the extent permitted by applicable law, THE FOREGOING LIMITED WARRANTY IS IN LIEU OF ALL OTHER
WARRANTIES OR CONDITIONS, EXPRESS OR IMPLIED, AND WE DISCLAIM ANY AND ALL IMPLIED WARRANTIES
OR CONDITIONS, INCLUDING ANY IMPLIED WARRANTY OF TITLE, NONINFRINGEMENT, MERCHANTABILITY OR
FITNESS FOR A PARTICULAR PURPOSE, regardless of whether we know or had reason to know of your
particular needs. No employee, agent, dealer or distributor of ours is authorized to modify this limited
warranty, or to make any additional warranties. This limited warranty gives you the specific legal rights.

Our entire liability and your exclusive remedy for breach of the foregoing warranty shall be, at our option, to either:
- Return the price you paid, or
- Repair or replace the Software or media that does not meet the foregoing warranty if you provide us with a copy of your Receipt Number.

Limitation of Liability
IN NO EVENT SHALL VERTEX42, LLC BE LIABLE TO YOU, FOR ANY DAMAGES, INCLUDING ANY LOST PROFITS,
LOST SAVINGS, OR ANY OTHER DIRECT, INDIRECT, SPECIAL, INCIDENTAL, OR CONSEQUENTIAL DAMAGES
ARISING FROM THE USE OR THE INABILITY TO USE THE SOFTWARE (EVEN IF WE OR AN AUTHORIZED DEALER
OR DISTRIBUTOR HAS BEEN ADVISED OF THE POSSIBILITY OF THESE DAMAGES), OR ANY MISTAKES AND
NEGLIGENCE IN DEVELOPING THIS SOFTWARE, OR FOR ANY CLAIM BY ANY OTHER PARTY. THE
ORGANIZATION, BUSINESS, OR PERSON USING THIS SOFTWARE BEARS ALL RISKS AND RESPONSIBILITY
FOR THE QUALITY AND PERFORMANCE OF THIS SOFTWARE.

Somes states do not allow the limitation or exclusion of liability for incidental or consequential damages,
so the above limitation may not apply to you.