background
Welcome to Wall Street Prep! Use code at checkout for 15% off.
Wharton & Wall Street Prep Certificates
Now Enrolling for February 2025 for September 2024
:
Private EquityReal Estate InvestingFP&A
Wharton & Wall Street Prep Certificates:
Enrollment for February 2025 is Open
Wall Street Prep

Join 750k+ learners today. Learn online from Wall Street Prep — the training firm that prepares new hires at the world's top financial institutions.

Enroll Today

Interest Income

  Table of Contents

How Does Interest Income Work?

Companies retain cash and cash equivalents on their balance sheet to ensure they have sufficient liquidity to meet short-term financing and working capital needs.

Cash not reinvested into operations is frequently invested into interest-yielding accounts such as the following:

  • Checkings or Savings Accounts
  • Commercial Paper
  • Certificate of Deposit (CD)
  • Marketable Securities

These sorts of short-term investments typically carry low yields, but can still enable the company to earn a net positive return and offset losses from having “idle” cash.

For most companies – excluding financial institutions such as commercial banks – interest is reported in the non-operating items section of the income statement.

The interest earned is not considered a non-financial company’s core part of operations, i.e. it is not integral to the company’s normal course of business.

How to Calculate Interest Income

A company’s interest income is determined by its projected cash balances and an interest rate assumption.

With that said, the forecasted interest income can only be computed once the balance sheet and cash flow statement are complete.

Calculating a company’s interest income is a two-step process:

  1. Calculate the Average Cash and Cash Equivalents Balance (Beginning and End of Period)
  2. Multiply Cash and Cash Equivalents Balance by the Interest Rate Earned (%)

In Excel, the standard method used to forecast either type of interest – interest income and interest expense – creates a “circularity” within a financial model, which we’ll discuss how to circumvent later in our modeling tutorial.

Interest Income Formula

The formula to calculate the interest income is the average cash balance multiplied by the cash rate.

Interest Income = Average Cash and Cash Equivalents × Cash Rate (%)
Where:
  • Average Cash and Cash Equivalents → (Beginning + Ending Cash Balance) ÷ 2
  • Cash Rate → Interest Rate Earned on Cash

Interest Income vs. Interest Expense: What is the Difference?

Companies often consolidate interest expense with interest income into a single line item called “Interest Expense, net” on their income statement.

In such cases, it is worth the time to locate the individual amounts broken out separately, so that each item can be referenced and projected in the forecast.

Like its counterpart, interest expense, interest income is modeled when building out the debt schedule of a financial model.

Hence, interest is considered one of the “finishing touches” of a 3-statement model.

On the income statement, interest income and interest expense are often presented together, but there is a clear distinction between the two items:

  • Interest Income → Interest income is the cash “earned” by a company from depositing its funds into low-risk investments such as marketable securities, government bonds, and certificates of deposit.
  • Interest Expense → In contrast, interest expense is the cost of borrowing from lenders and represents the payments “incurred” by a company as part of funding its day-to-day operations (e.g. working capital, capital expenditures).

Interest Income Calculator

We’ll now move to a modeling exercise, which you can access by filling out the form below.

dl

Excel Template | File Download Form

By submitting this form, you consent to receive email from Wall Street Prep and agree to our terms of use and privacy policy.

Submitting...

Step 1: Balance Sheet Assumptions

Suppose a company’s beginning cash balance was $20 million in 2020. Further, we’ll assume the net change in cash – i.e. the total movement of cash in the specified period – is an increase of $2 million across both periods.

2020A Cash Balances

  • Beginning Cash Balance = $20 million
  • Plus: Net Change in Cash = $2 million
  • Ending Cash Balance = $22 million

2021A Cash Balances

  • Beginning Cash Balance = $22 million
  • Plus: Net Change in Cash = $2 million
  • Ending Cash Balance = $24 million

Step 2: Interest Income Formula in Excel (Circularity)

Moreover, the interest rate earned on cash for both periods will be set at 0.40%.

  • Interest Rate (%) = 0.40%

The formula for calculating the interest income in Excel is as follows:

=IF(Circ=0,0,Interest Rate*AVERAGE (Beginning Cash Balance, Ending Cash Balance))

While not necessary for our simple exercise, setting up a circularity switch is crucial in a properly integrated 3-statement model.

  • Circ = 0: If the cell named “Circ” is set to zero, the formula calculates the interest as zero.
  • Circ = 1: Conversely, the formula could also be set so that if the circularity switch is turned on, only the beginning cash balance is used for the calculation.

Step 3: Interest Income Calculation Example

The interest income comes out as $84k in 2020, which increases to $92k in 2021 due to the positive rise in the cash balance on a year-over-year (YoY) basis.

  • Interest Income, 2020A = 0.40% × Average ($20 million, $22 million) = $84k
  • Interest Income, 2021A = 0.40% × Average ($22 million, $24 million) = $92k

Interest Income Example Calculation

Step-by-Step Online Course

Everything You Need To Master Financial Modeling

Enroll in The Premium Package: Learn Financial Statement Modeling, DCF, M&A, LBO and Comps. The same training program used at top investment banks.

Enroll Today

Learn Financial Modeling Online

Everything you need to master financial and valuation modeling: 3-Statement Modeling, DCF, Comps, M&A and LBO.

Learn More

The Wall Street Prep Quicklesson Series

7 Free Financial Modeling Lessons

Get instant access to video lessons taught by experienced investment bankers. Learn financial statement modeling, DCF, M&A, LBO, Comps and Excel shortcuts.