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

 

Eaque voluptatibus repudiandae omnis magni ea. Tempora ipsam aut sunt ullam numquam expedita. Quod voluptatem nobis labore numquam illo est quo. Accusantium et adipisci occaecati sit veritatis rerum omnis.

Et itaque consequatur dolorum labore. Id similique cumque minus cum.

Career Advancement Opportunities

July 2026 Investment Banking

  • Evercore 01 99.4%
  • Moelis & Company 01 98.9%
  • JPMorgan 01 98.3%
  • Guggenheim Partners 01 97.8%
  • Morgan Stanley 07 97.2%

Overall Employee Satisfaction

July 2026 Investment Banking

  • Moelis & Company No 99.4%
  • Evercore No 98.9%
  • Morgan Stanley 01 98.3%
  • Banco Santander 02 97.7%
  • BMO Capital Markets 12 97.2%

Professional Growth Opportunities

July 2026 Investment Banking

  • Evercore 01 99.4%
  • Moelis & Company 01 98.9%
  • Morgan Stanley 06 98.3%
  • Goldman Sachs 01 97.8%
  • JPMorgan 01 97.2%

Total Avg Compensation

July 2026 Investment Banking

  • Vice President (16) $429
  • Associates (46) $258
  • 3rd+ Year Analyst (8) $210
  • 2nd Year Analyst (22) $179
  • Intern/Summer Associate (14) $159
  • 1st Year Analyst (80) $150
  • Intern/Summer Analyst (73) $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

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...”