Tag FV

Create Time Value of Money Tables in Excel

Virtually every finance textbook has at the back, a series of tables that contain multipliers that can be used to easily calculate present or future values without the need for a financial calculator. In recent years these tables have given way to financial calculators, but they are still used by some professors and on some professional exams. This tutorial will…

Graduated Annuities on the HP 12C

Strictly speaking, an annuity is a series of equal cash flows, equally spaced in time. However, a graduated annuity (also called a growing annuity) is one in which the cash flows are not all the same, instead they are growing at a constant rate (any other series of cash flows is an uneven cash flow stream). So, the two types…

Graduated Annuities on the HP 17BII

Strictly speaking, an annuity is a series of equal cash flows, equally spaced in time. However, a graduated annuity (also called a growing annuity) is one in which the cash flows are not all the same, instead they are growing at a constant rate (any other series of cash flows is an uneven cash flow stream). So, the two types…

Valuing Graduated Annuities Using Excel

Strictly speaking, an annuity is a series of equal cash flows, equally spaced in time. However, a graduated annuity is one in which the cash flows are not all the same, instead they are growing at a constant rate. So, the two types of cash flows differ only in the growth rate of the cash flows. Annuity cash flows grow…

Graduated Annuities on the HP 19BII

Strictly speaking, an annuity is a series of equal cash flows, equally spaced in time. However, a graduated annuity (also called a growing annuity) is one in which the cash flows are not all the same, instead they are growing at a constant rate (any other series of cash flows is an uneven cash flow stream). So, the two types…

TI 83 and TI 83 Plus Tutorial, Part III

Uneven Cash Flow Streams In the previous section we looked at the basic time value of money keys and how to use them to calculate present and future value of lump sums and regular annuities. In this section we will take a look at how to use the TI 83 Plus to calculate the present and future values of uneven…

TI 83 and TI 83 Plus Tutorial, Part II

Part 2 of a TI-83 calculator tutorial on calculating money value over time. It covers how to find present and future values of annuities (regular payments) and lump sums using the built-in TVM Solver app. The tutorial explains different annuity types (regular and due) and how to solve for missing variables like payment amount, interest rate, or number of periods. It also touches on perpetuities (infinite payments) and how to approximate their present value with the calculator.

TI 83 and TI 83 Plus Tutorial, Part I

This is the first part of a TI-83 calculator tutorial on performing time value of money calculations. It covers finding future and present values of lump sums using the built-in TVM Solver app. The tutorial explains how to enter data considering the calculator's cash flow sign convention and solve for missing variables like the number of periods or interest rate. It also teaches how to adjust the calculator's decimal places for better viewing.

Solving Problems with Non-Annual Periods on the HP 19BII

Many, perhaps most, time value of money problems in the real world involve other than annual time periods. For example, most consumer loans (e.g., mortgages, car loans, credit cards, etc) require monthly payments. All of the examples in the previous pages have used annual time periods for simplicity. On this page, I’ll show you how easy it is to deal…

HP 19BII Tutorial, Part III

In the previous section we looked at the basic time value of money keys and how to use them to calculate present and future value of lump sums and annuities. In this section we will take a look at how to use the HP 19BII to calculate the present and future values of uneven cash flow streams. We will also…

HP 19BII Tutorial, Part II

In the previous section we looked at the basic time value of money keys and how to use them to calculate present and future value of lump sums. In this section we will take a look at how to use the HP 19BII to calculate the present and future values of regular annuities and annuities due. A regular annuity is…

HP 19BII Tutorial, Part I

The HP 19B is a fairly easy to use financial calculator that will serve you well in all finance courses. The 19BII can operate in either RPN (reverse polish notation) or algebraic modes. RPN is better in most cases, so I suggest that you choose that mode if you understand RPN. This tutorial will demonstrate how to use the financial…

Time Value of Money – Future Value of Regular Annuities

An annuity is a series of equal cash flows, equally distributed over time. Examples of annuities abound: Mortgage payments, car loan payments, leases, rent payments, insurance payouts, and so on. If you are paying or receiving the same amount of money every month (or week, or year, or whatever time frame), then you have an annuity. A regular annuity is…

HP 12C Tutorial, Part III

In the previous section we looked at the basic time value of money keys and how to use them to calculate present and future value of lump sums and annuities. In this section we will take a look at how to use the HP 12C to calculate the present and future values of uneven cash flow streams. We will also…

Annuity Due Formulas

These are the main formulas that are needed to work with regular annuity cash flows (Definition/Tutorial). Please note that these formulas work only on a payment date, not between payment dates. This is the same restriction used (but not stated) in financial calculators and spreadsheet functions. I use MathJax to display these formulas. You can click the equations to show…