Estimating lost yield- Stock Repurchase model

Hi Everyone,
I am attempting to recreate a stock repurchase model I was researching from a sell side report. Fro my understanding, the inputs required go like this:

  1. Estimate future cash, Net income, dividend payout
  2. Estimate Net (post-tax) cash yield, given the historical interest income and outlook for rates in the future;
  3. Estimate a % of opening net income that might be used for repurchases this year. This gives us the cash invested. This is then used to estimate the cash yield lost.

I am facing issues in forecasting the cash yield 'lost' (i.e., foregone). Could anyone please advise a methodology acceptable as a best practice? there seem to be a few options to do that:
1. Current year net yield * (average of opening & closing year cumulative cash invested)
2. Current year net yield * ( cumulative cash invested)
3. Last year's lost interest income + Current year net yield * Current year cash used for repurchase

Many thanks in advance. I could point out to a model as well if required.

Career Advancement Opportunities

April 2024 Investment Banking

  • Jefferies & Company 02 99.4%
  • Goldman Sachs 19 98.8%
  • Harris Williams & Co. New 98.3%
  • Lazard Freres 02 97.7%
  • JPMorgan Chase 03 97.1%

Overall Employee Satisfaction

April 2024 Investment Banking

  • Harris Williams & Co. 18 99.4%
  • JPMorgan Chase 10 98.8%
  • Lazard Freres 05 98.3%
  • Morgan Stanley 07 97.7%
  • William Blair 03 97.1%

Professional Growth Opportunities

April 2024 Investment Banking

  • Lazard Freres 01 99.4%
  • Jefferies & Company 02 98.8%
  • Goldman Sachs 17 98.3%
  • Moelis & Company 07 97.7%
  • JPMorgan Chase 05 97.1%

Total Avg Compensation

April 2024 Investment Banking

  • Director/MD (5) $648
  • Vice President (19) $385
  • Associates (87) $260
  • 3rd+ Year Analyst (14) $181
  • Intern/Summer Associate (33) $170
  • 2nd Year Analyst (66) $168
  • 1st Year Analyst (205) $159
  • Intern/Summer Analyst (146) $101
notes
16 IB Interviews Notes

“... there’s no excuse to not take advantage of the resources out there available to you. Best value for your $ are the...”

Leaderboard

1
redever's picture
redever
99.2
2
Betsy Massar's picture
Betsy Massar
99.0
3
Secyh62's picture
Secyh62
99.0
4
BankonBanking's picture
BankonBanking
99.0
5
GameTheory's picture
GameTheory
98.9
6
dosk17's picture
dosk17
98.9
7
kanon's picture
kanon
98.9
8
CompBanker's picture
CompBanker
98.9
9
DrApeman's picture
DrApeman
98.8
10
Linda Abraham's picture
Linda Abraham
98.8
success
From 10 rejections to 1 dream investment banking internship

“... I believe it was the single biggest reason why I ended up with an offer...”