All,
Looking for some help in excel.
Trying to do an interpolation model on returns based off of volume.
Pretend I'm selling 3 widgets with a return of 4.402% and when I sell 4 widgets I get a return of 26.626%. How can I interpolate the data in excel to give me 3.25, 3.875, etc.
I've tried scouring the internet, but the best answers I've received are to use the forecast / trend formulas..
Any thoughts?
| +328 | Return Rates For Interns Are Falling? | 138 | 2h |
| +148 | Article: Why UBS's Asian M&A bankers are thriving and UBS's American M&A bankers are not | 16 | 6h |
| +126 | Evercore > Goldman and I don’t think it’s particularly close anymore | 52 | 26m |
| +123 | I am a drunk MD AMA | 40 | 1d |
| +86 | UBS Offer Day | 30 | 14h |
| +64 | I hate Wells Fargo | 19 | 24m |
| +57 | An Outsider’s View of RX Banking Out of College | 6 | 6d |
| +51 | Santander IB? | 10 | 2d |
| +49 | No return offer - feeling like a failure is an understatement | 19 | 9h |
| +43 | WF Return offers | 28 | 1d |
Career Resources
Get instant access to lessons taught by experienced private equity pros and bulge bracket investment bankers including financial statement modeling, DCF, M&A, LBO, Comps and Excel Modeling.
Either this is a fantastically simple question, or you're leaving out information.
Just in case it's fantastically simple, think back to 8th grade Algebra, and "y = mx + b". If you're trying to do a linear interpolation, what you need to find is the slope, which as we all remember, is "(y2 - y1) / (x2 - x1)", and y-intercept. Since you're trying to solve for "% return" we know that "# of widgets" is your dependent variable.
Now, we calculate the slope: (26.626% - 4.402%) / (4 - 3) = 0.22224 And now we calculate the y-intercept: 26.626% = (0.2224)*(4) + b -> b = -0.6227
And here we have your linear interpolation equation: y = 0.22224*x - 0.6227 which will output a return for any number or fraction of widgets you can imagine.
Does that solve your problem? Or did you leave out some information about the widgets and/or model constraints or something? I'm fairly certain I'm missing something here.
Lineint function
Quisquam velit voluptates magni nesciunt aut ad. Nemo omnis distinctio ducimus at cumque ut repellendus dolore. Nostrum facere voluptatum voluptatem aut expedita eius officia occaecati.
Porro id sit voluptatem voluptas. Asperiores eius animi rerum tenetur dolores nostrum enim. Illum est ut officiis aliquam. Saepe sint sint architecto est itaque molestiae vel sint.
Et consequatur reprehenderit harum aliquid velit a. Delectus cupiditate molestiae hic est molestiae odio dolorem. Magnam maxime accusamus quasi est magni est. Qui accusamus est illo.
Dolores ducimus delectus et error eum nobis beatae. Odio quisquam id sapiente mollitia est placeat.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...