Spreadsheet: 142339d1329778470-npv-formula-with-positive-cash-flow-before-an-initial-outlay-npv-question-v2-2-expanded
Sheet: Sheet1

 |  |  |  |  |  |  | With Feb 11 being end of period 1 |  |  |  |  |  |  | If Feb 11 is start of period 1
 | Rate | 0.2 |  | Rate | 0.2 |  | Rate | 0.2 |  |  |  | sum of below |  | Rate | 0.2 |  |  |  | sum of below
 | NPV |  |  | NPV |  |  | NPV |  |  |  | NPV |  |  | NPV |  |  |  | NPV
 | Date | Cash Flows |  | Date | Cash Flows |  | Date | Cash Flows |  | Discount Factor |  | Discounted Cash value |  | Date | Cash Flows |  | Discount Factor |  | Discounted Cash value
 | 2011-02-01 00:00:00 | 27500 |  | 2011-02-01 00:00:00 | 27500 |  | 2011-02-01 00:00:00 | 27500 |  |  |  |  |  | 2011-02-01 00:00:00 | 27500 |  | 1
 | 2011-03-01 00:00:00 | 0 |  | 2011-03-01 00:00:00 | 0 |  | 2011-03-01 00:00:00 | 0 |  |  |  |  |  | 2011-03-01 00:00:00 | 0
 | 2011-04-01 00:00:00 | 0 |  | 2011-04-01 00:00:00 | 0 |  | 2011-04-01 00:00:00 | 0 |  |  |  |  |  | 2011-04-01 00:00:00 | 0
 | 2011-05-01 00:00:00 | -1157859 |  | 2011-05-01 00:00:00 | -1157859 |  | 2011-05-01 00:00:00 | -1157859 |  |  |  |  |  | 2011-05-01 00:00:00 | -1157859
 | 2011-06-01 00:00:00 | -15799 |  | 2011-06-01 00:00:00 | -15799 |  | 2011-06-01 00:00:00 | -15799 |  |  |  |  |  | 2011-06-01 00:00:00 | -15799
 | 2011-07-01 00:00:00 | 0 |  | 2011-07-01 00:00:00 | 0 |  | 2011-07-01 00:00:00 | 0 |  |  |  |  |  | 2011-07-01 00:00:00 | 0
 | 2011-08-01 00:00:00 | 0 |  | 2011-08-01 00:00:00 | 0 |  | 2011-08-01 00:00:00 | 0 |  |  |  |  |  | 2011-08-01 00:00:00 | 0
 | 2011-09-01 00:00:00 | 9534.805186923162 |  | 2011-09-01 00:00:00 | 9534.805186923162 |  | 2011-09-01 00:00:00 | 9534.805186923162 |  |  |  |  |  | 2011-09-01 00:00:00 | 9534.805186923162
 | 2011-10-01 00:00:00 | 10151.86912618949 |  | 2011-10-01 00:00:00 | 10151.86912618949 |  | 2011-10-01 00:00:00 | 10151.86912618949 |  |  |  |  |  | 2011-10-01 00:00:00 | 10151.86912618949
 | 2011-11-01 00:00:00 | 10048.66338887612 |  | 2011-11-01 00:00:00 | 10048.66338887612 |  | 2011-11-01 00:00:00 | 10048.66338887612 |  |  |  |  |  | 2011-11-01 00:00:00 | 10048.66338887612
 | 2011-12-01 00:00:00 | 7080.572420636153 |  | 2011-12-01 00:00:00 | 7080.572420636153 |  | 2011-12-01 00:00:00 | 7080.572420636153 |  |  |  |  |  | 2011-12-01 00:00:00 | 7080.572420636153
 | 2012-01-01 00:00:00 | 10984.67120031488 |  | 2012-01-01 00:00:00 | 10984.67120031488 |  | 2012-01-01 00:00:00 | 10984.67120031488 |  |  |  |  |  | 2012-01-01 00:00:00 | 10984.67120031488
 | 2012-02-01 00:00:00 | 12409.3549720021 |  | 2012-02-01 00:00:00 | 12409.3549720021 |  | 2012-02-01 00:00:00 | 12409.3549720021 |  |  |  |  |  | 2012-02-01 00:00:00 | 12409.3549720021
 | 2012-03-01 00:00:00 | 10961.1043951709 |  | 2012-03-01 00:00:00 | 10961.1043951709 |  | 2012-03-01 00:00:00 | 10961.1043951709 |  |  |  |  |  | 2012-03-01 00:00:00 | 10961.1043951709
 | 2012-04-01 00:00:00 | 11694.35976257058 |  | 2012-04-01 00:00:00 | 11694.35976257058 |  | 2012-04-01 00:00:00 | 11694.35976257058 |  |  |  |  |  | 2012-04-01 00:00:00 | 11694.35976257058
 | 2012-05-01 00:00:00 | 12496.59183435658 |  | 2012-05-01 00:00:00 | 12496.59183435658 |  | 2012-05-01 00:00:00 | 12496.59183435658 |  |  |  |  |  | 2012-05-01 00:00:00 | 12496.59183435658
 | 2012-06-01 00:00:00 | 12071.21660116701 |  | 2012-06-01 00:00:00 | 12071.21660116701 |  | 2012-06-01 00:00:00 | 12071.21660116701 |  |  |  |  |  | 2012-06-01 00:00:00 | 12071.21660116701
 | 2012-07-01 00:00:00 | 12654.01540906436 |  | 2012-07-01 00:00:00 | 12654.01540906436 |  | 2012-07-01 00:00:00 | 12654.01540906436 |  |  |  |  |  | 2012-07-01 00:00:00 | 12654.01540906436
 | 2012-08-01 00:00:00 | 12892.95283849709 |  | 2012-08-01 00:00:00 | 12892.95283849709 |  | 2012-08-01 00:00:00 | 12892.95283849709 |  |  |  |  |  | 2012-08-01 00:00:00 | 12892.95283849709
 | 2012-09-01 00:00:00 | 13451.98374578584 |  | 2012-09-01 00:00:00 | 13451.98374578584 |  | 2012-09-01 00:00:00 | 13451.98374578584 |  |  |  |  |  | 2012-09-01 00:00:00 | 13451.98374578584
 | 2012-10-01 00:00:00 | 13253.14132817025 |  | 2012-10-01 00:00:00 | 13253.14132817025 |  | 2012-10-01 00:00:00 | 13253.14132817025 |  |  |  |  |  | 2012-10-01 00:00:00 | 13253.14132817025
 | 2012-11-01 00:00:00 | 13171.12969859307 |  | 2012-11-01 00:00:00 | 13171.12969859307 |  | 2012-11-01 00:00:00 | 13171.12969859307 |  |  |  |  |  | 2012-11-01 00:00:00 | 13171.12969859307
 | 2012-12-01 00:00:00 | 10965.40799845733 |  | 2012-12-01 00:00:00 | 10965.40799845733 |  | 2012-12-01 00:00:00 | 10965.40799845733 |  |  |  |  |  | 2012-12-01 00:00:00 | 10965.40799845733
 | 2013-01-01 00:00:00 | 14539.69980907964 |  | 2013-01-01 00:00:00 | 14539.69980907964 |  | 2013-01-01 00:00:00 | 14539.69980907964 |  |  |  |  |  | 2013-01-01 00:00:00 | 14539.69980907964
 | 2013-02-01 00:00:00 | 14530.34146026005 |  | 2013-02-01 00:00:00 | 14530.34146026005 |  | 2013-02-01 00:00:00 | 14530.34146026005 |  |  |  |  |  | 2013-02-01 00:00:00 | 14530.34146026005
 | 2013-03-01 00:00:00 | 14514.68836852685 |  | 2013-03-01 00:00:00 | 14514.68836852685 |  | 2013-03-01 00:00:00 | 14514.68836852685 |  |  |  |  |  | 2013-03-01 00:00:00 | 14514.68836852685
 | 2013-04-01 00:00:00 | 2804095.929105625 |  | 2013-04-01 00:00:00 | 2804095.929105625 |  | 2013-04-01 00:00:00 | 2804095.929105625 |  |  |  |  |  | 2013-04-01 00:00:00 | 2804095.929105625