3.5 Which Finance Formula to Use?

Introduction

Now that we have surveyed the basic kinds of finance calculations that are used, it may not always be obvious which one to use when you are given a problem to solve. In this section, we review our finance formulas and discuss some hints on deciding which equation to use, based on the wording of the problem.

 

Learning Outcomes

  • Determine which financial mathematics formula to use for a given scenario

Determining the Correct Formula

Loans

The easiest types of problems to identify are loans.  Loan problems almost always include words like loan, amortize (the fancy word for loans), finance (i.e. a car), or mortgage (a home loan). Look for words like monthly or annual payment.

The loan formula assumes that you make loan payments on a regular schedule (every month, year, quarter, etc.) and are paying interest on the loan.

Loans Formula

[latex]P_{0}=\frac{d\left(1-\left(1+\frac{r}{k}\right)^{-Nk}\right)}{\left(\frac{r}{k}\right)}[/latex]

  • P0 is the balance in the account at the beginning (the principal, or amount of the loan).
  • d is your loan payment (your monthly payment, annual payment, etc)
  • r is the annual interest rate in decimal form.
  • k is the number of compounding periods in one year.
  • N is the length of the loan, in years.

 

Interest-Bearing Accounts

Accounts that gain interest fall into two main categories.  The first is on where you put money in an account once and let it sit, the other is where you make regular payments or withdrawals from the account as in a retirement account.

Category 1:  You make a one-time deposit and let the money sit and earn interest.  For most accounts in this category, the interest will be Compounding.  This will be stated explicitly in the problem.

COMPOUND INTEREST

[latex]P_{N}=P_{0}\left(1+\frac{r}{k}\right)^{Nk}[/latex]

  • PN is the balance in the account after N years.
  • P0 is the starting balance of the account (also called initial deposit, or principal)
  • r is the annual interest rate in decimal form
  • k is the number of compounding periods in one year
    • If the compounding is done annually (once a year), k = 1.
    • If the compounding is done quarterly, k = 4.
    • If the compounding is done monthly, k = 12.
    • If the compounding is done daily, k = 365.

 

Exceptions:  The exceptions would be bonds and other investments where the interest is not reinvested; in those cases you’re looking at Simple Interest.

SIMPLE INTEREST OVER TIME

[latex]\begin{align}&I={{P}_{0}}rt\\&A={{P}_{0}}+I={{P}_{0}}+{{P}_{0}}rt={{P}_{0}}(1+rt)\\\end{align}[/latex]

  • I is the interest
  • A is the end amount: principal plus interest
  • [latex]\begin{align}{{P}_{0}}\\\end{align}[/latex] is the principal (starting amount)
  • r is the interest rate in decimal form
  • t is time

The units of measurement (years, months, etc.) for the time should match the time period for the interest rate.

 

Category 2: If you’re putting money into the account on a regular basis (monthly/annually/quarterly), then you’re looking at a Savings Annuity problem.  Savings annuities are when you are saving money.  Usually in an annuity problem, your account starts empty, and has money in the future. Annuities assume that you put money in the account on a regular schedule (every month, year, quarter, etc.) and let it sit there earning interest.

ANNUITY FORMULA

[latex]P_{N}=\frac{d\left(\left(1+\frac{r}{k}\right)^{Nk}-1\right)}{\left(\frac{r}{k}\right)}[/latex]

  • PN is the balance in the account after N years.
  • d is the regular deposit (the amount you deposit each year, each month, etc.)
  • r is the annual interest rate in decimal form.
  • k is the number of compounding periods in one year.

 

If the compounding frequency is not explicitly stated, assume there are the same number of compounds in a year as there are deposits made in a year.

If you’re pulling money out of the account on a regular basis, then you’re looking at a Payout Annuity problem.  Payout annuities are used for things like retirement income, where you start with money in your account, pull money out on a regular basis, and your account ends up empty in the future. Payout annuities assume that you take money from the account on a regular schedule (every month, year, quarter, etc.) and let the rest sit there earning interest.

PAYOUT ANNUITY FORMULA

[latex]P_{0}=\frac{d\left(1-\left(1+\frac{r}{k}\right)^{-Nk}\right)}{\left(\frac{r}{k}\right)}[/latex]

  • P0 is the balance in the account at the beginning (starting amount, or principal).
  • d is the regular withdrawal (the amount you take out each year, each month, etc.)
  • r is the annual interest rate (in decimal form. Example: 5% = 0.05)
  • k is the number of compounding periods in one year.
  • N is the number of years we plan to take withdrawals

Remember, the most important part of answering any kind of question, money or otherwise, is first to correctly identify what the question is really asking, and then determine what approach will best allow you to solve the problem.

Try It

For each of the following scenarios, determine if it is a compound interest problem, a savings annuity problem, a payout annuity problem, or a loans problem. Then, try using an Excel spreadsheet (or online loan/annuity calculator) to solve each problem.

  1. Marcy received an inheritance of $20,000, and invested it at 6% interest. She is going to use it for college, withdrawing money for tuition and expenses each quarter. How much can she take out each quarter if she has 3 years of school left?

  2. Paul wants to buy a new car. Rather than take out a loan, he decides to save $200 a month in an account earning 3% interest compounded monthly. How much will he have saved up after 3 years?

  3. Keisha is managing investments for a non-profit company.       They want to invest some money in an account earning 5% interest compounded annually with the goal to have $30,000 in the account in 6 years. How much should Keisha deposit into the account? 

  4. Miao is going to finance new office equipment at a 2% rate over a 4 year term. If she can afford monthly payments of $100, how much new equipment can she buy? 

  5. How much would you need to save every month in an account earning 4% interest to have $5,000 saved up in two years?

 

View the following video to see how to use the language in the above questions to determine which type of formula to use to solve the finance problem.

 

End of Section–No Online HW for this Section

Go to Section 3.6