IRR Question For an Assignment Please Let Me Know the answer through excel working please guys

A brand with annual revenue of Rs. 12 Mn has approached us for Rs. 2 Mn in funding to invest in a new godown. The brand has Rs. 2 Mn in its bank account and currently makes losses of 100k a month.

They already have a term sheet from a competitor, which is offering them 1 Mn for six months at a 10% yield (i.e. Rs. 1.1 Mn to be paid back) by taking a 18.3% revenue share every month, till the full amount is paid back.

However, the brand wants more capital, at least a 12-month product, and also a lower IRR. It feels that it will grow its revenues and therefore pay back the funds sooner than six months, thus resulting in a very high IRR.

What terms (yield, revenue share, or other special terms) would you suggest we offer if we expect the company to grow 10% m-o-m? What IRR will it generate for us?

10 Comments
 

You will get a % of company's revenue? What is the company's current revenue? and you expect the revenue to grow 10% monthly?

 

Is the competitor's loan already in service? Or it's just a proposal that the brand wants to replace with your company's funding?

 

Competitor's annualized IRR is 74% (de-annualized IRR is 32% since the Company is expected to pay back in 5 months). If you charge 10.75% revenue share for 12 months, your IRR is 30% which is lower than Competitor's de-annulized 32%. If you charge 12.25% revenue share for 12 months, your IRR is 67% which is lower than Competitor's annualized IRR. This IRR view is just one way (too simple way) to look at it. If the assumption is that Brand wants to go with a loan from a lender who will experience a lower IRR than its competitor's, then sure. In reality that's not how businesses operate

 

Quis non accusamus voluptates aut laborum dolorem. Expedita dolor maxime voluptas eos velit. Dolor iusto officiis sequi rerum temporibus.

Qui error deserunt dolorem excepturi. Nam cumque inventore minus perspiciatis temporibus aspernatur placeat. Quaerat aspernatur provident aut et id. Hic iste velit ab eius repellat similique.

Unde rerum rerum non. Necessitatibus omnis sapiente sapiente distinctio optio natus. Sit neque non quasi est hic labore.

Reiciendis quisquam fugit et totam. Eveniet est delectus optio quis ducimus nobis quidem dolores. Distinctio consequatur modi qui maiores quisquam id quis. Quidem ab qui dolores nihil est. Molestias odio possimus voluptas aut officiis debitis non perspiciatis. Molestiae et quia quod nobis delectus.

Career Advancement Opportunities

September 2026 Investment Banking

  • Evercore 01 99.5%
  • Moelis & Company 01 98.9%
  • JPMorgan 01 98.4%
  • Goldman Sachs 01 97.8%
  • Morgan Stanley 07 97.3%

Overall Employee Satisfaction

September 2026 Investment Banking

  • Moelis & Company No 99.5%
  • Morgan Stanley 02 98.9%
  • Evercore 01 98.4%
  • Banco Santander 02 97.8%
  • BMO Capital Markets 12 97.3%

Professional Growth Opportunities

September 2026 Investment Banking

  • Evercore 01 99.5%
  • Moelis & Company 01 98.9%
  • Morgan Stanley 07 98.4%
  • Goldman Sachs 01 97.8%
  • JPMorgan No 97.3%

Total Avg Compensation

September 2026 Investment Banking

  • Vice President (16) $429
  • Associates (51) $260
  • 3rd+ Year Analyst (8) $210
  • 2nd Year Analyst (26) $182
  • Intern/Summer Associate (14) $159
  • 1st Year Analyst (84) $151
  • Intern/Summer Analyst (76) $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
Secyh62's picture
Secyh62
99.0
3
BankonBanking's picture
BankonBanking
99.0
4
kanon's picture
kanon
99.0
5
DrApeman's picture
DrApeman
98.9
6
dosk17's picture
dosk17
98.9
7
CompBanker's picture
CompBanker
98.9
8
GameTheory's picture
GameTheory
98.9
9
Betsy Massar's picture
Betsy Massar
98.9
10
bolo up's picture
bolo up
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...”