WallStreetMojo

WallStreetMojo

WallStreetMojo

MENUMENU
  • Blog
  • Free Video Tutorials
  • Courses
  • All In One Bundle
  • Login
Home » Financial Modeling Tutorials » Excel Modeling » Extrapolation Formula

Extrapolation Formula

By Harsh KataraHarsh Katara | Reviewed By Dheeraj VaidyaDheeraj Vaidya, CFA, FRM

Definition of Extrapolation Formula

Extrapolation Formula refers to the formula that is used in order to estimate the value of the dependent variable with respect to independent variable that shall lie in range which is outside of given data set which is certainly known and for calculation of linear exploration using two endpoints (x1, y1) and the (x2, y2) in the linear graph when value of point which has to be extrapolated is “x”, formula that can be used is represented as y1+ [(x−x1) / (x2−x1)] *(y2−y1).

Y(x) = Y(1)+ (x- x(1)/x(2)-x(1)) * (Y(2) – Y(1))

Extrapolation Formula

Calculation of Linear Extrapolation (Step by Step)

  • Step 1 – The data first needs to be analyzed whether the data is following the trend and whether the same can be forecasted.
  • Step 2 – There should be two variables where one has to be a dependent variable, and the second has to be an independent variable.
  • Step 3 – The numerator of the formula starts with the previous value of a dependent variable, and then one needs to add back the fraction of the independent variable as one does while calculating for mean for class intervals.
  • Step 4 – Finally, multiply the value arrived in step 3 by a difference of immediate given dependent values. After adding step 4 to the value of the dependent variable will yield us the extrapolated value.

Examples

You can download this Extrapolation Formula Excel Template here – Extrapolation Formula Excel Template

Example #1

Suppose that the value of the certain variables is given below in the form of (X, Y):

  • (4, 5)
  • (5, 6)

Based on the above information, you are required to find the value of Y(6) using the extrapolation method.

Solution

Use the below-given data for calculation.

  • X1: 4.00
  • Y2: 6.00
  • Y1: 5.00
  • X2: 5.00

Calculation of Y(6) using extrapolation formula is as follows,

Extrapolation Formula Example 1.1

Extrapolation Y(x) =  Y(1) + (x) – (x1) / (x2) – (x1) x {Y(2) – Y(1)}

Y(6) = 5 + 6 – 4 / 5 – 4 x (6 – 5)

The answer will be –

Extrapolation Formula Example 1.2

  • Y3 =  7

Hence, the value for Y when the value of X is 6 will be 7.

Example #2

Mr. M and Mr. N are students of the 5th standard, and they are currently analyzing the data given to them by their math teacher. The teacher has asked them to compute the weight of students whose height will be 5.90 and has informed that the below set of data follows linear extrapolation.

Popular Course in this category
Sale
Financial Modeling Course (with 15+ Projects)
4.9 (927 ratings)
16 Courses | 15+ Projects | 90+ Hours | Full Lifetime Access | Certificate of Completion
View Course
X Height Y Weight
X1 5.00 Y1 50
X2 5.10 Y2 52
X3 5.20 Y3 53
X4 5.30 Y4 55
X5 5.40 Y5 56
X6 5.50 Y6 57
X7 5.60 Y7 58
X8 5.70 Y8 59
X9 5.80 Y9 62

Assuming that this data follows a linear series, you are required to calculate the weight, which would be dependent variable Y in this example when the independent variable x (height) is 5.90.

Solution

In this example, we now need to find out the value, or in other words, we need to forecast the value of students whose height is 5.90 based on the trend given in the example. We can use below extrapolation formula in excel to calculate the weight, which is a dependent variable for a given height, which is an independent variable

Calculation of Y(5.90) is as follows,

Example 2.1

  • Extrapolation Y(5.90) = Y(8) + (x) – (x8) /(x9) – (x8)   x [Y(9) – Y(8)]
  • Y(5.90) = 59 + 5.90 – 5.70 / 5.80 – 5.70 x (62 – 59)

The answer will be –

Example 2.2

  • = 65

Hence, the value for Y when the value of X is 5.90 will be 65.

Example #3

Mr. W is the executive director of the company ABC. He was concerned with the sales of the company being following a downward trend. He has asked his research department to produce a new product which shall follow increasing demand as and when the production increases. After 2 years, they develop a product which faced increasing demand.

Below are the details of the last few months:

X (Production) Produced (Units) Y (Demand) Demanded (Units)
X1 10.0 Y1 20.00
X2 20.00 Y2 30.00
X3 30.00 Y3 40.00
X4 40.00 Y4 50.00
X5 50.00 Y5 60.00
X6 60.00 Y6 70.00
X7 70.00 Y7 80.00
X8 80.00 Y8 90.00
X9 90.00 Y9 100.00

They observed that since this was a new product and cheap product and hence initially, this would follow linear demand until a certain point.

Hence moving forward, they would first forecast the demand and then compare them with actual and produce accordingly as this has demanded huge cost for them.

The marketing manager wants to know what the units would be demanded if they produce 100 units. Based on the above information, you are required to calculate the demand in units when they produce 100 units.

Solution

We can use the below formula to calculate the demands in units, which is the dependent variable for given units produce, which is an independent variable.

Calculation of Y(100) is as follows,

Example 3.1

  • Extrapolation Y(100) = Y(8) + (x)- (x8) / (x9) – (x8) x [ Y(9) – Y(8)]
  • Y(100)   =  90 + 100 – 80 / 90 – 80 x (100 – 90)

The answer will be –

Example 3.2

  • = 110

 Hence, the value for Y when the value of X is 100 will be 110.

Relevance and Uses

It is mostly used to forecast the data which is out of the current range of the data. In this case, one is assuming that the trend shall continue for given data and even outside that range, which shall not be the case always, and hence extrapolation should be used very cautiously, and instead, there is a better method to do the same is the use of interpolation method.

Recommended Articles

This article has been a guide to the Extrapolation Formula. Here we discuss the formula to calculate the dependent variable’s value for an independent variable along with practical examples and a downloadable excel template. You can learn more about economics from the following articles –

  • Revenue Run Rate
  • Velocity of Money Formula
  • Excel Trend Line
  • Formula of Multiple Regression
  • Effective Annual Rate
0 Shares
Share
Tweet
Share
Financial Modeling Course (with 15+ Projects)
  • 16 Courses
  • 15+ Projects
  • 90+ Hours
  • Full Lifetime Access
  • Certificate of Completion
LEARN MORE >>
Primary Sidebar
Footer
COMPANY
About
Reviews
Contact
Privacy
Terms of Service
RESOURCES
Blog
Free Courses
Free Tutorials
Investment Banking Tutorials
Financial Modeling Tutorials
Excel Tutorials
Accounting Tutorials
Financial Statement Analysis
COURSES
All Courses
Financial Analyst All in One Course
Investment Banking Course
Financial Modeling Course
Private Equity Course
Venture Capital Course
Excel All in One Course

Copyright © 2021. CFA Institute Does Not Endorse, Promote, Or Warrant The Accuracy Or Quality Of WallStreetMojo. CFA® And Chartered Financial Analyst® Are Registered Trademarks Owned By CFA Institute.
Return to top

WallStreetMojo

Free Investment Banking Course

IB Excel Templates, Accounting, Valuation, Financial Modeling, Video Tutorials

* Please provide your correct email id. Login details for this Free course will be emailed to you

Book Your One Instructor : One Learner Free Class
WallStreetMojo

Free Investment Banking Course

IB Excel Templates, Accounting, Valuation, Financial Modeling, Video Tutorials

* Please provide your correct email id. Login details for this Free course will be emailed to you

Let’s Get Started
Please select the batch
Saturday - Sunday 9 am IST to 5 pm IST
Saturday - Sunday 9 am IST to 5 pm IST

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

Login

Forgot Password?

WallStreetMojo

Download Extrapolation Formula Excel Template

Special Offer - All in One Financial Analyst Bundle (250+ Courses, 40+ Projects) View More