Think & Done

Excel investment analysis functions

1. Benefit to cost ratio in Excel
   This Excel template permits you to find benefit to cost ratio from a series of net cash flows
2. IRR in Excel
   This Excel template permits you to find internal rate of return from a series of net cash flows
3. XIRR in Excel
   This Excel template permits you to find internal rate of return from a series of net cash flows that may not be periodic
4. NFV in Excel
   This Excel template permits you to find net future value from a series of net cash flows and the discount rate
5. NPV in Excel
   This Excel template permits you to find net present value from a series of net cash flows and the discount rate
6. MIRR in Excel
   This Excel template permits you to find modified internal rate of return from a series of net cash flows, finance and reinvestment rates
7. Discounted Payback Period in Excel
   This Excel template permits you to find discounted payback period from a series of net cash flows
8. Payback Period in Excel
   This Excel template permits you to find undiscounted payback period from a series of net cash flows
9. Profitability Index in Excel
   This Excel template permits you to find profitability index from a series of net cash flows

Excel interest rates functions

1. PVIFA in Excel
   This Excel template permits you to find PVIFA at i% interest rate and for n periods
2. PVIF in Excel
   This Excel template permits you to find PVIF at i% interest rate and for n periods
3. FVIF in Excel
   This Excel template permits you to find FVIF at i% interest rate and for n periods
4. FVIFA in Excel
   This Excel template permits you to find FVIFA at i% interest rate and for n periods

Excel TVM functions

1. FV in Excel
   This Excel template permits you to find future value of a lump sum or an annuity at i% interest rate and for n periods
2. PV in Excel
   This Excel template permits you to find present value of a lump sum or an annuity at i% interest rate and for n periods
3. NPER in Excel
   This Excel template permits you to find number of periods needed of a lump sum or a series of periodic payments to reach a terminal value. Example usage of NPER function has to do with finding the number of years required to pay off a loan or a mortgage or number of years required for your savings to grow to a pre-determined amount in the future.
4. PMT in Excel
   This Excel template permits you to find periodic payments in an annuity such as mortgage or loan payment at i% interest rate and for n periods

Excel bond functions

1. Bond Price in MS Excel
   This Excel template permits you to find price of zero and non zero coupon rate bonds. You plug in values for maturity value of bond, the years to maturity, the coupon rate on bond, and the yield to maturity
2. YTM in MS Excel
   This Excel template permits you to find yield to maturity YTM for non zero coupon rate bonds. You plug in values for maturity value of bond, the years to maturity, the coupon rate on bond, and the market price of the bond