Year to Date (YTD) (2024)

Step-by-Step Guide to Understanding Year to Date (YTD)

Last Updated December 6, 2023

What is Year to Date?

YTD stands for “year to date” and represents the time period from the beginning of the fiscal year to the present date.

Year to Date (YTD) (1)

Table of Contents

  • What Does YTD Mean?
  • How to Calculate YTD?
  • YTD Formula
  • YTD Returns Calculation Example
  • YTD Calculator
  • 1. Operating Assumptions
  • Step 2. YTD Financials Calculation Example
  • 3. YTD Revenue and Earnings Calculation Example

What Does YTD Mean?

In finance, the term YTD stands for “Year to Date” andrefers to the period starting from the first date of the current year to the current period.

However, the YTD abbreviation could also mean the period between the beginning date of the fiscal year to the current date, or the most recent reporting period, such as the latest quarterly report.

In that case, the year-to-date (YTD) is most likely alluding to the financial statements of the company, rather than a percentage return.

By measuring YTD performance, a company can assess its performance to date and determine how its current trajectory compares to its prior periods and internal forecasts, as well as for benchmarking purposes with comparable companies in either the same or an adjacent industry.

The trend of the company’s sales performance, or alternatively the returns on a portfolio, can be useful for understanding the current state of its performance and if adjustments are necessary in order to reach the goals set by the management team.

How to Calculate YTD?

Suppose the management team of Microsoft (MSFT) were to state that their share price is currently up over 40% YTD.

Therefore, as of the current date in August 2023, MSFT’s stock price has increased over 40% since January 1, 2023.

To calculate the YTD return, subtract the starting period value from the current period value, and divide the resulting figure by the starting year value.

In the final step, multiply the figure in decimal notation by 100 to convert the YTD figure into a percentage.

For most companies, the starting date of the fiscal year tends to be January 1st, however, there are exceptions – such as companies such as Apple (AAPL) with fiscal years that begin on different dates, i.e. the end of September.

Year to Date (YTD) (2)

Apple Fiscal Year Ending Date Example (Source: Apple 10-K)

YTD Formula

The formula to calculate year-to-date (YTD) performance or returns is as follows.

Year to Date (YTD) = [(Current Period Value Beginning of Period Value)] ÷ Beginning of Period Value)

YTD Returns Calculation Example

In order to convert the decimal value into a percentage, the resulting figure must be multiplied by 100.

For example, if an investor’s portfolio was worth $200,000 at the beginning of 2022 and is currently worth $220,000 in the middle of 2022, the year-to-date return is calculated as 10%.

  • Year to Date (YTD) = [($220,000 – $200,000) ÷ $200,000) = 0.10, or 10%

Learn More → Hedge Fund Primer

S&P 500 YTD Returns Graph

The S&P 500, or “Standard and Poor’s 500”, is a stock market index tracking the performance of approximately 500 publicly-traded companies based in the U.S.

The screenshot of the graph below reflects the YTD returns of the S&P 500 index as of the latest closing date, November 23, 2022.

Year to Date (YTD) (3)

S&P 500 Index YTD Returns (Source: S&P Dow Jones Indices)

YTD Calculator

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

1. Operating Assumptions

Suppose a company is measuring its year-to-date financial performance to compare its revenue and earnings figures to that of its last fiscal year, 2021.

The company’s 2021 fiscal year and quarterly income statement metrics are as follows.

Income Statement2021AQ1-2022Q2-2022Q3-2022
Revenue$100 million$26 million$30 million$34 million
Less: COGS(40) million(8) million(10) million(12) million
Gross Profit$60 million$18 million$20 million$22 million
Less: SG&A(20) million(4) million(5) million(6) million
EBIT$40 million$14 million$15 million$16 million
Less: Interest(5) million(1) million(1) million(1) million
EBT$35 million$13 million$14 million$15 million
Taxes (@ 25% Tax Rate)(9) million(3) million(4) million(4) million
Net Income$26 million$10 million$11 million$11 million

Step 2. YTD Financials Calculation Example

By taking the sum of the quarterly figures, we can arrive at our company’s 2022 year-to-date metrics.

Q1 to Q3 2022 Financials

  • Revenue = $90 million
  • COGS = (30) million
  • Gross Profit = $60 million
  • SG&A = (15) million
  • EBIT = $45 million
  • Interest = (3) million
  • EBT = $42 million
  • Taxes = (11) million
  • Net Income = $32 million

Note that year-to-date (YTD) financials could also refer to the last four quarters. If that is the case, we would add the financials from Q4-2021.

But in our modeling exercise, we’re attempting to gauge the progress of only Q-1 to Q-3 2022 performance to determine how it is tracking compared to fiscal year 2021.

By comparing the performance of three quarters to a full fiscal year, a company can quantify the difference to set targets for Q-4 2022 performance.

3. YTD Revenue and Earnings Calculation Example

If we divide the ending values from above by the beginning values (2021A), we can determine how the company is performing to date.

We’ll focus on the company’s revenue and earnings metrics:

  • Revenue (%) → We can see that the company’s revenue is currently only off by 10% (with one more quarter to go) and thus should easily surpass its 2021 amount ($90 million vs. $100 million).
  • Gross Profit (%) → Next, the amount of gross profits generated in the first three quarters of 2022 is equivalent to the total gross profit in 2021 ($60 million vs. $60 million).
  • EBIT (%) → The operating income, or “EBIT”, from the first three quarters has already exceeded the 2021 amount by approximately 12.5% ($45 million vs. $50 million).
  • Net Income (%) → Finally, the company’s year to date net income, i.e. the “bottom line”, is up by roughly 20% ($32 million vs. $26 million).

Year to Date (YTD) (7)

Year to Date (YTD) (8)

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

Comments

2 Comments

most voted

newestoldest

Inline Feedbacks

View all comments

samaneh

May 5, 2023 10:32 am

hi,i want spot formol:
y~=(cp/p0)+(par-p0/T)

Reply

Brad Barlow

May 7, 2023 9:03 pm

Reply tosamaneh

Hi, Samaneh,

Can you clarify your question?

BB

Reply

Year to Date (YTD) (2024)

FAQs

How to use YTD in a sentence? ›

financial/fiscal year to date In the financial year to date, receipts were up 6.3%. For the year to date, sales have fallen by 15.4%.

How do you calculate the YTD? ›

To calculate a YTD return on investment, subtract its value on the first day of the current year from its current value. Then, divide the difference by the value on the first day, and multiply the product by 100 to convert it to a percentage.

What is an example of year to date income? ›

To calculate YTD payroll, look at each employee's pay stub and add the year-to-date gross incomes listed. For example, you have three employees at your small business: Cindy, James, and Neil. Cindy earned a total of $24,000 in gross wages year-to-date. James earned $22,000, and Neil earned $19,000.

What is an example of year to date? ›

For example, if an investor's portfolio was worth $200,000 at the beginning of 2022 and is currently worth $220,000 in the middle of 2022, the year-to-date return is calculated as 10%.

What is the basic meaning of YTD? ›

Year to Date (YTD) The period from the beginning of the current year to a determined date.

What does YTD amount mean? ›

What is the year-to-date payroll? Your company's year-to-date payroll (YTD) is the amount of money your company has spent on the payroll since the beginning of the calendar or fiscal year, up to the current payroll date.

What is a YTD income statement? ›

The Year to Date Income Statement Report , also called profit and loss statement (P&L) and Statement of Operations, is a company's financial statement that indicates how the revenue (money received from the sale of products and services before expenses are deducted) is transformed into the net income (the result after ...

What is the full form of YTD in date? ›

Year to date (YTD) is a term covering the period between the beginning of the year and the present.

How do I calculate my YTD income? ›

To calculate the Year-to-Date income, multiply the monthly income by the number of months that have passed in the year.

Does YTD start over each year? ›

Year to date (YTD) is a term covering the period between the beginning of the year and the present. It can apply to either calendar or fiscal years. Your fiscal year might not necessarily begin on 1st January but no matter the dates, YTD covers the first day of the year in question up until the day of calculation.

How do you calculate year to date spend? ›

How to calculate year to date. In many cases, you can calculate YTD with simple addition. Calculating year to date expenses involves adding up all of the expenses from the beginning of the year until the current day. Finding your YTD profits requires adding up all profits since the start of the year.

What is a year to date proof of income? ›

Most recently filed Federal Income Tax Form 1040, with any appropriate Schedules. It must include: Full name of the person or other identifying information to link to the person (e.g. SSN). Income amount.

How to calculate YTD with an example? ›

Year-to-date return refers to the profit (or loss) generated by an investment during the year. YTD return is calculated by subtracting the starting value from the current value and dividing it by the starting value. The figure can be multiplied by 100 to convert it into a percentage.

How to calculate YTD average? ›

Additional Information: Some financial institutions calculate year average-to-date by summing all the period ending averages-to-date within the year and dividing by the number of periods, excluding any adjusting periods. Another alternative is to sum the four quarter averages-to-date and divide by four.

How to annualize a YTD number? ›

Divide the number 12 by the number of months since the beginning of the year, which will give you the annualization factor. 4. Finally, multiply your YTD return by the annualization factor to determine your annualized investment return.

How do you use year on year basis in a sentence? ›

It is at the mercy of employers on a year-on-year basis. All those museums that went free received year-on-year compensation for loss of admissions income. That means there will be year-on-year real increases in defence spending plans until at least 2005–06.

What does YTD mean in slang? ›

ytd (plural not attested) (Internet slang, text messaging) Abbreviation of yesterday.

What is an example sentence for year by year? ›

Under his direction year by year the work proceeded. This problem has increased year by year. The caps will become stricter year by year. Seal births are increasing year by year at the location.

Does YTD go before or after the year? ›

Year to date (YTD) is a term covering the period between the beginning of the year and the present. It can apply to either calendar or fiscal years. Your fiscal year might not necessarily begin on 1st January but no matter the dates, YTD covers the first day of the year in question up until the day of calculation.

Top Articles
Latest Posts
Article information

Author: Allyn Kozey

Last Updated:

Views: 6271

Rating: 4.2 / 5 (43 voted)

Reviews: 90% of readers found this page helpful

Author information

Name: Allyn Kozey

Birthday: 1993-12-21

Address: Suite 454 40343 Larson Union, Port Melia, TX 16164

Phone: +2456904400762

Job: Investor Administrator

Hobby: Sketching, Puzzles, Pet, Mountaineering, Skydiving, Dowsing, Sports

Introduction: My name is Allyn Kozey, I am a outstanding, colorful, adventurous, encouraging, zealous, tender, helpful person who loves writing and wants to share my knowledge and understanding with you.