{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["©","NPV","XNPV","TermsOfUse"],"not_rendered":{"images":1,"defined_names":3,"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"©","index":0,"n_rows":3,"n_cols":1,"rows_kept":3,"hidden":true}
["NPV Calculator"]
["© 2009 Vertex42 LLC. All Rights Reserved."]
["http://www.vertex42.com/Calculators/npv-irr-calculator.html"]

{"sheet":"NPV","index":1,"n_rows":60,"n_cols":13,"rows_kept":60}
["NPV Calculator"]
["Add custom cash flows or create auto-generated cash flow series (uniform, gradient, and exponential series).",{"$nulls":11},"© 2009 Vertex42 LLC"]
["You can delete, copy, and insert new columns, but make sure the Sum column is correct after making changes.",{"$nulls":11},"NPV Calculator"]
["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."]
[]
[null,null,"NPV",{"$f":"C20+NPV(D10,C21:C60)","v":{"v":14649.488621501485,"d":"14,649.49"}}]
[null,null,"IRR",{"$f":"IRR(C20:C60,0.1)","v":{"v":0.09054443702978165,"d":"9.054%"}}]
[]
[null,null,"Discount Rate (i)",{"v":0.06,"d":"6%"}]
[]
[{"$nulls":3},"Auto-Generated Cash Flow Series"]
[null,null,"Series Type:","Uniform (A)","Gradient (G)","Exp Grad","none"]
[null,null,"Value (A, G, or Eo):",100,100,100]
[null,null,"g (for Exp Grad):",null,null,{"v":0.05,"d":"5%"}]
[null,null,"Periods:",5,10,7,null,null,"Custom Cash Flow Series"]
[null,null,"NPV:",{"$f":"D20+NPV($D$10,D21:D60)","v":{"v":421.23637855657137,"d":"421.24"}},{"v":2960.232137105858,"d":"2,960.23"},{"v":674.0774704803802,"d":"674.08"},0,{"v":2148.6649546459817,"d":"2,148.66"},{"v":4471.697355188851,"d":"4,471.70"},{"v":-1872.9475087682367,"d":"(1,872.95)"},{"v":5846.527834292065,"d":"5,846.53"}]
[{"$nulls":6},"IRR:",{"$f":"IRR(H20:H60,0.1)","v":{"v":0.16340560068898924,"d":"16.34%"}},{"$f":"IRR(I20:I60,0.1)","v":{"v":0.09634541799419782,"d":"9.63%"}},{"$f":"IRR(J20:J60,0.1)","v":{"v":0.041440062682112755,"d":"4.14%"}},{"$f":"IRR(K20:K60,0.1)","v":{"v":0.08663094803652216,"d":"8.66%"}}]
[null,"Period","Sum","Series 1","Series 2","Series 3","Series 4","Label 1","Label 2","Label 3","Label 4"]
[null,0,{"$f":"SUM(D20:K20)","v":{"v":-150000,"d":"(150,000.00)"}},0,0,0,0,null,{"v":-40000,"d":"(40,000.00)"},{"v":-40000,"d":"(40,000.00)"},{"v":-70000,"d":"(70,000.00)"}]
[null,1,{"$f":"SUM(D21:K21)","v":{"v":18205,"d":"18,205.00"}},{"$f":"IF($B21<=D$16,IF(D$13=\"none\",0,IF(D$13=\"Uniform (A)\",D$14,IF(D$13=\"Gradient (G)\",D$14*($B21-1),IF(D$13=\"Exp Grad\",D$14*(1+D$15)^$B21,\"n/a\")))),0)","v":{"v":100,"d":"100.00"}},{"$f":"IF($B21<=E$16,IF(E$13=\"none\",0,IF(E$13=\"Uniform (A)\",E$14,IF(E$13=\"Gradient (G)\",E$14*($B21-1),IF(E$13=\"Exp Grad\",E$14*(1+E$15)^$B21,\"n/a\")))),0)","v":0},{"v":105,"d":"105.00"},0,{"v":-10000,"d":"(10,000.00)"},{"v":8000,"d":"8,000.00"},{"v":8000,"d":"8,000.00"},{"v":12000,"d":"12,000.00"}]
[null,2,{"v":36710.25,"d":"36,710.25"},{"$f":"IF($B22<=D$16,IF(D$13=\"none\",0,IF(D$13=\"Uniform (A)\",D$14,IF(D$13=\"Gradient (G)\",D$14*($B22-1),IF(D$13=\"Exp Grad\",D$14*(1+D$15)^$B22,\"n/a\")))),0)","v":{"v":100,"d":"100.00"}},{"v":100,"d":"100.00"},110.25,0,{"v":3000,"d":"3,000.00"},{"v":9200,"d":"9,200.00"},{"v":9200,"d":"9,200.00"},{"v":15000,"d":"15,000.00"}]
[null,3,{"v":42615.7625,"d":"42,615.76"},{"v":100,"d":"100.00"},{"v":200,"d":"200.00"},{"v":115.76250000000002,"d":"115.76"},0,{"v":4200,"d":"4,200.00"},{"v":10000,"d":"10,000.00"},{"v":10000,"d":"10,000.00"},{"v":18000,"d":"18,000.00"}]
[null,4,{"v":52321.550625,"d":"52,321.55"},{"v":100,"d":"100.00"},{"v":300,"d":"300.00"},{"v":121.550625,"d":"121.55"},0,{"v":6800,"d":"6,800.00"},{"v":12000,"d":"12,000.00"},{"v":12000,"d":"12,000.00"},{"v":21000,"d":"21,000.00"}]
[null,5,{"v":55627.62815625,"d":"55,627.63"},{"v":100,"d":"100.00"},{"v":400,"d":"400.00"},{"v":127.62815625000002,"d":"127.63"},0,null,{"v":14500,"d":"14,500.00"},{"v":14500,"d":"14,500.00"},{"v":26000,"d":"26,000.00"}]
[null,6,{"v":-8365.9904359375,"d":"(8,365.99)"},0,{"v":500,"d":"500.00"},{"v":134.0095640625,"d":"134.01"},0,null,null,{"v":-9000,"d":"(9,000.00)"}]
[null,7,{"v":740.710042265625,"d":"740.71"},0,{"v":600,"d":"600.00"},{"v":140.71004226562502,"d":"140.71"},0]
[null,8,{"v":700,"d":"700.00"},0,{"v":700,"d":"700.00"},0,0]
[null,9,{"v":800,"d":"800.00"},0,{"v":800,"d":"800.00"},0,0]
[null,10,{"v":900,"d":"900.00"},0,{"v":900,"d":"900.00"},0,0]
[null,11,0,0,0,0,0]
[null,12,0,0,0,0,0]
[null,13,0,0,0,0,0]
[null,14,0,0,0,0,0]
[null,15,0,0,0,0,0]
[null,16,0,0,0,0,0]
[null,17,0,0,0,0,0]
[null,18,0,0,0,0,0]
[null,19,0,0,0,0,0]
[null,20,0,0,0,0,0]
[null,21,0,0,0,0,0]
[null,22,0,0,0,0,0]
[null,23,0,0,0,0,0]
[null,24,0,0,0,0,0]
[null,25,0,0,0,0,0]
[null,26,0,0,0,0,0]
[null,27,0,0,0,0,0]
[null,28,0,0,0,0,0]
[null,29,0,0,0,0,0]
[null,30,0,0,0,0,0]
[null,31,0,0,0,0,0]
[null,32,0,0,0,0,0]
[null,33,0,0,0,0,0]
[null,34,0,0,0,0,0]
[null,35,0,0,0,0,0]
[null,36,0,0,0,0,0]
[null,37,0,0,0,0,0]
[null,38,0,0,0,0,0]
[null,39,0,0,0,0,0]
[null,40,0,0,0,0,0]

{"sheet":"XNPV","index":2,"n_rows":19,"n_cols":11,"rows_kept":19}
["XIRR, XNPV Calculator"]
["This worksheet uses the XNPV function to calculate the Net Present Value",{"$nulls":9},"© 2009 Vertex42 LLC"]
["for a schedule of cash flows that are not necessarily periodic. The XNPV",{"$nulls":9},"NPV Calculator"]
["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."]
[]
[null,"Discount Rate",{"v":0.08,"d":"8%"}]
[{"$nulls":7},"Days in Year",365]
[null,"NPV",{"$f":"XNPV($C$9,OFFSET(C14,1,0,MATCH(9.99E+307,C:C)-ROW(C14),1),OFFSET(B14,1,0,MATCH(9.99E+307,B:B)-ROW(B14),1))","v":{"v":2180.5132770139053,"d":"2,180.51"}},null,"NPV",{"$f":"XNPV($C$9,F15:F19,E15:E19)","v":{"v":2180.5132770139053,"d":"2,180.51"}},null,"NPV",{"$f":"SUM(I15:I19/((1+$C$9)^((H15:H19-INDEX(H15:H19,1))/I10)))","v":{"v":2180.5132770139053,"d":"2,180.51"}}]
[null,"IRR",{"$f":"XIRR(OFFSET(C14,1,0,MATCH(9.99E+307,C:C)-ROW(C14),1),OFFSET(B14,1,0,MATCH(9.99E+307,B:B)-ROW(B14),1),0.1)","v":{"v":0.3733625352382659,"d":"37.34%"}},null,"IRR",{"$f":"XIRR(F15:F19,E15:E19,0.1)","v":{"v":0.3733625352382659,"d":"37.34%"}}]
[null,"Using Dynamic Ranges",null,null,"Using the Exact Range",null,null,"Using an Array Formula"]
[null,"Date","Value",null,"Date","Value",null,"Date","Value"]
[null,"2008-01-01",{"v":-10000,"d":"(10,000.00)"},null,"2008-01-01",{"v":-10000,"d":"(10,000.00)"},null,"2008-01-01",{"v":-10000,"d":"(10,000.00)"}]
[null,"2008-03-01",{"v":2750,"d":"2,750.00"},null,"2008-03-01",{"v":2750,"d":"2,750.00"},null,"2008-03-01",{"v":2750,"d":"2,750.00"}]
[null,"2008-10-30",{"v":4250,"d":"4,250.00"},null,"2008-10-30",{"v":4250,"d":"4,250.00"},null,"2008-10-30",{"v":4250,"d":"4,250.00"}]
[null,"2009-02-15",{"v":3250,"d":"3,250.00"},null,"2009-02-15",{"v":3250,"d":"3,250.00"},null,"2009-02-15",{"v":3250,"d":"3,250.00"}]
[null,"2009-04-01",{"v":2750,"d":"2,750.00"},null,"2009-04-01",{"v":2750,"d":"2,750.00"},null,"2009-04-01",{"v":2750,"d":"2,750.00"}]

{"sheet":"TermsOfUse","index":3,"n_rows":35,"n_cols":1,"rows_kept":35}
["Terms of Use"]
[]
["© 2011 Vertex42 LLC. All rights reserved."]
[]
["This template is considered a copyrighted work under the Unites States and other copyright laws and is the property of Vertex42 LLC. The items listed below are additional points to help clarify how you may use this template."]
[]
[]
["Not for Resale or Public Sharing"]
[]
["You may make archival copies and customize this template only for your personal use or use within your company or organization and not for resale or public sharing."]
[]
["You may not remove or alter any logo, trademark, copyright, disclaimer, brand, terms of use, attribution, or other proprietary notices or marks within this template."]
[]
["This template and any customized or modified version of this template may NOT be sold, distributed, published to an online gallery, hosted on a website, or placed on a public server."]
[]
[]
["Limited Private Sharing"]
[]
["Provided that you observe the above terms, you may share your edited version of this template *privately* with those specific people who **require** access to it within your immediate family, organization, or company."]
[]
["* \"Privately\" means only accessible to those few people who you expressively give permission to view or edit your file. It is your responsibility to ensure that adequate security measures are used so that your file is not available to the public."]
[]
["** Examples of acceptable private sharing with people who \"require access\" may include (a) sharing a budget spreadsheet with a spouse, (b) sharing a project schedule with your project team, or (c) sharing a timesheet with your employee or manager."]
[]
["See the following page on Vertex42.com for the complete license agreement and examples of other allowed uses:"]
["http://www.vertex42.com/licensing/EULA_privateuse.html"]
[]
[]
["Disclaimer"]
[]
["This template is provided for informational or educational use only and is not intended to be relied on as medical, financial, legal, or other professional advice."]
[]
["Vertex42 LLC makes no guarantee or representations about this template, or the accuracy or completeness of the content contained within this template."]
[]
["Vertex42 LLC encourages you to seek the aid of a qualified professional before making decisions regarding health, financial, or legal issues."]