BIND = BCR, IRR, NPV, and DPB
Copyright 2014 BusinessAllstars.com - All Rights Reserved
XL    Name Date
Cashflow
Period 0 $ Period 0 must be negative
Period 1 $ WACC %
Period 2 $
Period 3 $ BCR or PI X
Period 4 $ (Benefit Cost Ratio or Profitability Index)
Period 5 $ IRR %
Period 6 $ (Internal Rate of Return)
Period 7 $ NPV $
Period 8 $ (Net Present Value)
Period 9 $ DPB yrs
Period 10 $ (discounted payback)


Enter Inputs in the YELLOW boxes and tab from box to box