Say the investment horizon is 3 years.
In year 1, you invest 4MM at 11c/share.
In year 2, you invest 3MM at 20c/share.
If the stock price by the end of year 2 A. falls to 10c/share or B. rises to 25c/share, what is your total return for your investment?
Seems like a rather easy question but can't wrap my head around it, thanks
| +221 | UBS Accused of Favoring H-1B Workers While Cutting U.S.-Born Employees | 54 | 1h |
| +117 | ONLY THESE BANKS OR YOU STRUCK OUT | 34 | 6h |
| +110 | IB Energy Drink Tier List / Ranking | 73 | 5h |
| +91 | PJT M&A Group Selection 2026 | 14 | 1d |
| +58 | Firm Thinks I'm Lying About Offer | 18 | 1d |
| +51 | Feedback for internship first desk at IBD BB - personal fit, "don't be too confident" | 29 | 1d |
| +37 | Indiana University Fraternity Pipelines | 17 | 1h |
| +33 | Stay at Weak Dealflow Team or Lateral? | 10 | 9h |
| +30 | Does BofA still pay its associates rat pellets? | 15 | 1d |
| +30 | Rogo AI | 10 | 5h |
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.
You just need to build the cashflow schedule and use the IRR function in Excel / your calculator.
In Period 1, you spent $4mm and purchased 36.4mm shares at 11c/share. In Period 2, you spent $3mm and purchased 15mm shares at 20c/share. Your total shares are 51.4mm
If the price goes to 10c/share, you will receive $5.14mm from selling. At 25c/share, you receive $12.8mm.
Your cashflows in the two cases are:
10c -$4mm, -$3mm, +$5.1mm = ~ -18% IRR
25c -$4mm, -$3mm, +$12.8mm = ~ 46% IRR
Thanks a ton! Got it :)
One last quick question, how would our IRR change if the time periods were 6 months instead of 1 year(so investments on month 1, month 7, etc)? Does that make a difference in the excel function?
The simple irr-function calculates in periods, i.e. every cell down with a number in it is one period. Word of advice, always use the xirr function if you are doing anything with specific dates. It gives you much more flexibility to insert cash flows, change time periods etc.
Non quam qui doloribus nostrum atque consequatur. Beatae incidunt voluptatibus ullam qui. Qui necessitatibus id voluptatem. Recusandae cupiditate omnis ex corporis sit unde voluptate sunt. Est ad ullam inventore porro doloremque. Aut quod qui facere. Esse ut id vel fuga.
Voluptate nemo quasi repellat et. Soluta ducimus illo incidunt sit. Sint quod aperiam aperiam dolorem expedita omnis alias. Qui odio praesentium sed vel.
Et aut quisquam nemo ad saepe. Delectus ipsa doloremque fugit voluptates voluptatem labore. Saepe quis rem iure vitae soluta sit quia. Ea tempora autem est aliquam nemo. Consequatur et nihil voluptas. Maxime dolorum ea maiores ut.
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...