Internal Rate of Return
=IRR(cell range)
cell range = array of cell values containing cash flows
NPV
=NPV(discount, cell range)
discount rate = cost of capital (real cost of capital includes inflation)
cell range = T1- Tx cash flows
Rate (redeemable debenture)
=RATE(number of periods, payment, present value, future value)