NPV SIMULATION

profileMathStat Genius
_Calculations.xlsx
Home>Business & Finance homework help>Accounting homework help>NPV SIMULATION

Sheet1

Project A
Year Inflow Outflow Net Discount Net Inflation
Flow Factor Present Rate
Value
*2011 $0 $150,000 ($150,000) 1.00 ($150,000.00) 0.02
2011 $0 $100,000 ($100,000) 0.893 ($89,285.71) 0.02
2012 $25,000 $75,000 ($50,000) 0.797 ($39,859.69) 0.02
2013 $120,000 $25,000 $95,000 0.712 $67,619.12 0.02
2014 $400,000 $0 $400,000 0.636 $254,207.23 0.02
Total $545,000 $350,000 $195,000 $42,680.95
Discount Rate 10%

Sheet2

Project A
Year Inflow Outflow Net Discount Net Inflation
Flow Factor Present Rate
Value
*2011 $0 $150,000 ($150,000) 1.00 ($150,000.00) 0.02
2011 $0 $100,000 ($100,000) 0.893 ($89,285.71) 0.02
2012 $25,000 $75,000 ($50,000) 0.797 ($39,859.69) 0.02
2013 $120,000 $25,000 $95,000 0.712 $67,619.12 0.02
2014 $400,000 $0 $400,000 0.636 $254,207.23 0.02
Total $545,000 $350,000 $195,000 $42,680.95
Discount Rate 10%