Видео

Fantastic video, thanks Eric!

I believe it’s simplicity. As someone starting an investment firm and is tax accountant. I would advise General Partners to restructure ownership through a holding company. Limited Partnerships investment would be treated as a loan and hurdle/preferred return would be the interest rate to LP company. Then ownership would split 80% Limit Partner Company and 20% General Partners Company aka investment firm. Profits still tax as capital gains

Thanks is really helpful!

Good video however your example is not typical real world. The GP is expected to have skin in the game, somewhere between 1-5% (typically 2%) (The capital stack). Also the LP's expect a return over and above their initial investment typically 8% before GP's start to catchup (The hurdle rate). Your example focusses on the carried interest alone which is certainly relevant but not the whole picture. I only comment on this because of the tax incentives that take into account that added context.

Eric, you forgot to deduct the deferred tax asset from earning before tax (EBT), when EBT is positive. The business should be taxed later than your forecast. Also, should there be a decrease in cash flow when the tax asset accumulate? Such asset will increase cash flow once earnings become positive and tax payment is offset by the asset.

great video!

Gather here all those who are going for interview on financial modeling

Pro josef

What is SG&A?

This is great stuff thanks! Just wandering about 1 thing: The model assumes that subscriptions are monthly, i.e. a customer that hasn't churned comes back next month. How would the model look like for subscribers that come back after 3.5 months on average?

Eric, you multiply contract size by lifetime of customer to arrive at LTV. Should we use the gross margin of the contract size instead of the contract itself?

The best way to learn is to follow Eric when creating such model~ Build the model by myself and adapt to my own model.

Dude, awesome!

So helpful

Thanks for sharing.

Man!! to be honest 80% of all these questions were mentioned on the interview one month ago!. Thanks a lot, I will use them on tomorrow's interview.

PERFECT BUT I NEED MORE DETAILED ONE

Great video.Thank you.

The organic new customers are NOT gained through the paid channels. So why the blended CAC sensible? All paid advertising cost should belong to paid new customer, shouldn't it?

Awesome. Do you have a resource of al effective offers to try and maybe ranked by some sort of market baseline?

Can this be done On gohighlevel?

What i have to do if i forgot the password

We are now married😭😂 Seriously, thank you.

❤❤❤❤❤❤

tysmmm for thisss!!! this is soooo valuable!! lots of info in a single vid!! 😭🫶🏻🔥

Wow, youre a champion - thank you so much Eric! What about a transactional product that only takes about 1-3 weeks to close ? How would you format the sheet?

Hi Eric, first of all thanks for the video, great explanation! I wonder though if the profitability you explain around 16:10 is correct? Wouldn't break even occur during month 2 as the profits cummulate vs the one time cac? 33+65+95=193>115

Hey Eric, very helpful, thanks. Question for you: If my product offers only 6 month and 12 month memberships, I'm assuming looking at one year wouldn't really give you a great picture of retention since each customer doesn't have the opportunity to churn every month. That being said, 1) How many years would you recommend looking back to get a good picture of the company's retention 2) Would you break these tables out separately for 6 month memberships and 12 month memberships? Any other insights on longer term contracts and how to analyze them would be extremely valuable, thank you. Edit: one more question. Since sales commission is technically an expense related to acquiring customers, would you put that expense into CAC and exclude it from gross margin calculations? In other words if I give 10% sales commission on a $100 product, I wouldn't deduct $10 from the $100 to get gross margin but would instead add $10 to my CAC, correct?

Hi Eric, I am a new ecom biz owner still getting my fit in the industry so I really appreciate these videos you are making. I've been binge-watching your video to learn all this stuff. Thank you so much for giving us all this info!

This is exactly what I needed. Thank you so much for sharing this.

I’m having trouble building the first table from the dataset (a step back from what you’ve shown)!! can’t find the right formula!

Thank you for the video, however I had to pay $5 for it even video says for free, but I dont mind.

@is forecasting of this analysis / Net sales also possible further? And what methods will be most suitable?

This information is so valuable, and I really appreciate the complete breakdown. Your channel is helping me so much. Thank you!!

Hi Eric , My name is Surprise i was searching questions and answers for an administrator finance position and i bumped into your video where you were explaining about finance interview 3years ago, you know how to explain and I was impressed , so i would like you to help me to understand Administrator finance position and duties , what are the questions and answers. I would be very happy if you help me , thanks in advance.

Hi Eric , i am going to interview for Administrator finance i would like you to help me with questions and duties for this position.

Very great video Eric! Thank you so much :)

Finally after 4 days I have completed this model I have spearing no efforts to learn Financial Start up Models Thanx a lot to upload such a valuable content lot of love from India

Great Video Eric. I am wondering in a more real world scenario - an ecommerce store has 100's of SKU's how would we proceed in calculating contributional margin for the same?

How to assume future revenue growth based on historical data in income statement

This was awesome to watch and use. I am also looking to benchmark L&D NPS in the healthcare industry. Any sources you can point me to?

How can I calculate the churn if a customer is paying a flat fee for my service and, depending on the service, they could be an active customer for 2+ years?

How can I calculate the churn if a customer is paying a flat fee for my service and, depending on the service, they could be an active customer for 2+ years?

Hi Eric～great work～can I know where I can download the Excel?

How do we get the framework excel file used in the video ?

AI short