Modelling Question

I've been given a pretty vague task to put together an illustrative model for a private company that factors A/R as my team would like to present this as a potential investment opportunity to our clients as a part of a tech pitch deck

Basically the company automates factoring A/R and takes a small % fee off clients that it pays, and then receives the full amount from their client's original customers. 

Can anyone help me think through how to put this together? Don't have particularly good numbers to work with but just need to understand the big drivers of the business (how to model the top-line for a business that automates factoring A/R, big expense drivers - i.e. probably mainly salary, etc., how things flow through FS) 


Thanks!

Region
 
Most Helpful

I'll take a stab if no one else will. I've only looked at a few of these companies so will defer to others who have more experience.

Option 1: Quick and Dirty

Look at the top line as a function of net funds employed ("NFE") and net yields. These businesses are advancing funds against invoices. As you noted, the company will charge a fee for factoring that it collects when the invoice is actually paid. The business should be able to tell you how much it has advanced, and then how much the fees translate to on an annualized basis (net of charge offs i.e. account debtor defaults). You can stratify this data in any manner that you think makes sense (geographies, account debtor industry, account type, etc.) to have more meaningful net yields. The rest of the PnL pretty much follows like any other company. Among other things, the weakness with this approach is that "net yield" isn't really something you see in the wild, and your model will struggle to tell you what happens if charge offs go up by 5%.

Option 2: Schedule Method

You could also build a schedule where you're modeling each month (or quarter) of invoice origination. With this method, you can get from the company (i) when invoices typically repay, (ii) what the company earns on a gross basis, and (iii) what chargeoffs look like at the invoice level. This should give you enough to model cashflows and returns at the "invoice level", however, the nuance is that there's typically a waterfall structure with respect to invoice repayment. Specifically, as you'd expect, if a customer factors an invoice, but the account debtor doesn't pay, the customer is the one who suffers the first loss. So if you have an invoice of $100, but you advance 85% of that, (ignoring fees) the customer is losing from that first $0-15. After that, the factor can look to repayment from existing or future invoices, the actual customer, or insurance. The point is: your returns won't be smooth as a function of chargeoffs. This method would capture that as well as the general timing of cash flows. The expenses would look similar in both modeling scenarios.

 

Quaerat veritatis est tenetur delectus. Et voluptas illo et molestiae magni repellat. Atque dolore expedita occaecati qui autem earum adipisci. Eaque quibusdam beatae enim sapiente aspernatur quia id aut. Aut quod voluptatem accusantium aperiam omnis esse corrupti.

Nesciunt aspernatur amet odio rerum ea sit non. Mollitia aspernatur sunt est consequatur eum consequatur veniam aut. Earum totam tempore illo est nobis eum voluptatem aut. Vel quia aliquam ipsam qui delectus eveniet architecto. Ut quos eum illo qui in.

Aut id reprehenderit ut ut rerum soluta quia. Nostrum corporis ipsa sit corrupti voluptatibus autem molestias soluta.

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
BankonBanking's picture
BankonBanking
99.0
3
Betsy Massar's picture
Betsy Massar
99.0
4
Secyh62's picture
Secyh62
99.0
5
kanon's picture
kanon
98.9
6
dosk17's picture
dosk17
98.9
7
CompBanker's picture
CompBanker
98.9
8
GameTheory's picture
GameTheory
98.9
9
bolo up's picture
bolo up
98.8
10
DrApeman's picture
DrApeman
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...”