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

 

Iusto velit accusamus iure. Eveniet quo quasi voluptatem dignissimos modi. Perspiciatis harum quidem eum delectus. Nihil dolores sequi enim ratione consequuntur.

Cumque omnis quia quos rerum assumenda. Cumque accusantium debitis consequatur excepturi non labore. Excepturi tenetur dolores exercitationem consequatur molestias soluta animi. Nihil et aut voluptas provident. Sapiente odit animi similique quis. Magni et repellat et nostrum tempore quia.

Saepe aspernatur illo et aut. Provident sunt incidunt quis voluptatem porro sunt enim. Velit asperiores inventore sint sed quae. Culpa assumenda consequatur numquam incidunt hic magnam repudiandae soluta.

Sit id nihil non sit blanditiis. Adipisci eum rerum facere a quia perferendis est. Quam nam enim iste praesentium at dolorum. Fuga dolore incidunt eum nemo earum in perspiciatis ullam. At labore ex commodi enim cum error consequuntur. Debitis quas est ut reprehenderit soluta modi cum. Non ut labore rerum.

Career Advancement Opportunities

June 2026 Investment Banking

  • Evercore 01 99.4%
  • Moelis & Company 01 98.8%
  • JPMorgan 01 98.2%
  • Guggenheim Partners 01 97.7%
  • Morgan Stanley 07 97.1%

Overall Employee Satisfaction

June 2026 Investment Banking

  • Moelis & Company No 99.4%
  • Morgan Stanley 01 98.8%
  • Evercore 01 98.2%
  • BMO Capital Markets 12 97.6%
  • Banco Santander 01 97.1%

Professional Growth Opportunities

June 2026 Investment Banking

  • Moelis & Company No 99.4%
  • Evercore No 98.8%
  • Morgan Stanley 05 98.2%
  • JPMorgan No 97.7%
  • BMO Capital Markets 12 97.1%

Total Avg Compensation

June 2026 Investment Banking

  • Vice President (14) $434
  • Associates (43) $259
  • 3rd+ Year Analyst (8) $210
  • 2nd Year Analyst (22) $179
  • Intern/Summer Associate (13) $156
  • 1st Year Analyst (75) $151
  • Intern/Summer Analyst (65) $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
dosk17's picture
dosk17
98.9
6
GameTheory's picture
GameTheory
98.9
7
DrApeman's picture
DrApeman
98.9
8
Betsy Massar's picture
Betsy Massar
98.9
9
CompBanker's picture
CompBanker
98.9
10
Jamoldo's picture
Jamoldo
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...”