The bond amortization calculator calculates the bond premium or discount amortization for both the straight line and effective interest amortization methods

This loan amortization schedule calculator uses Excel to produce a loan amortization table by entering details of the loan amount, term, and interest rate.

The Excel IRR function calculates the internal rate of return of a series of cash flows in time value of money calculations. Its syntax is IRR(Values,Guess)

The Excel YIELD function calculates the yield to maturity on a bond, Its syntax is YIELD (Settlement, Maturity, Rate, Pr, Redemption, Frequency, Basis).

The loan repayment period calculator works out the number of periods required to repay a loan assuming periodic payments (Pmt), and an interest rate (i).

This monthly lease payment calculator works out the lease payments allowing for the cost and salvage value of an asset, and the advance payments required.

This monthly lease payment calculator works out the lease payments allowing for the cost and salvage value of an asset, and the advance payments required.