Brilliant!!!

Very helpful, do you have this template available for download?

Perfect, thank you

Would the Mandatory Payment of $150 not reduce the FCF available for Discretionary Pay Down. So wouldn't the discretionary paydown be $182, because that's the cash available after paying $150 of the madatory paydown (from the $332 cash)?

Hi is it possible to get this file please

how to make it work if your inputs are in a different tab?

great video, please speak up next time, my volume is near 100 and can barely hear

what did I just watch

i'm so sick of the unskipable 4 minute mudwtr ads

Is this model up for sale?

Simple, to the point. Thanks

Thank you!!

Very very informative.. looking forward to more of the same. Thanks.

Firstly, thank you for the brilliant video! I have one quick clarification and one observation. A) The interest expenses (which are mandatory) shown for the debt instruments in rows 88, 97 and 106 would flow into the income statement and then to cashflow statement and effectively reduce row 71 - cash available for discretionary debt paydown - is this understanding correct? B) When interest expense for revolver shown in row 85 changes to 1 at 2:50, the net interest expense reduces from 2 to 1. I was thinking it should increase from 2 because using the revolver is more expensive Libor (0.6%) + 500 bps (5%) than commitment fee (0.33%).

I got same input in all cell of data table can you please tell me why this error occurred

So I'm brand brand new to this and will probably have to watch this multiple times to understand...one thing that's puzzling me is the mandatory amortization %. Where do you find information about this in SEC filings? It's puzzling for me because I can usually only find information on the maturity and the interest rate.

nice 👍pls share excel sheet

Great video, could you please share the Excel file?

Very informative stuff! Thank you so much!! Would you consider making content for newcomers in finance (e.g how to network, how to land internships, preparing for interviews, etc.)?

Where do you grab the LIBOR rates from? How do you choose which rates you should use?

Thanks,Very good👌👏 Please resume and keep making other parts✌

Are you able to post the excel file so that we can follow through it?

This is a great video. Love the step-by-step and the formatting for presentation. Can you post the Excel model so that I can see the exact logic in each cell? Actually I see in the comments "we can't share the model at this time." Just for clarification, you can't or won't? Its your model and your choice. Just trying to understand the reason for not sharing. However, can you share the logic in row 154 on the FCF tab? What is the cell logic for the check? Thank you.

Hey, this schedule is applicable for LBO models as well right?

Why don't you make a online training course or something?

for the draw/(paydown) row of the revolver, noticed at 1:32 that the f86 wasn't fixed, but at 2:45 it became $f$86, so which is the correct formula for dragging across? thanks!

Very helpful, do you have this template available for download?

Hey! is there any chance you could do your take on a complete walkthrough model on a particular company (from scratch)? that'll be an interesting video.

@Excelforfinance_1 do I include current liabilities in the debt stack? Also, when I do total debt and net debt calculations on a comp set, do those include total liabilities or only long term liabilities? Thanks!

Hey! Can you provide the excel template?

in the term loan when calculating mandatory payments, I kept getting the same 50 and it goes until the end of my estimates. not like you are showing in the video. Is there anything wrong with my excel set up?

please sent me excel file thanks

Thanks video helpful

Excellent video - straight to the point and helped me answer a question that I had really quickly. Huge thumbs up!

Thanks for the video! If the bond was issued at discount or premium, will the interest be based on the face value of the bond rather than average of BB and EB?

How do letters of credit affect revolver utilization and payback/would this model allow for these variables??

Also is cell 71 the Total liquidity ? but total liquidity = available cash + undrawn revolver

thank you so much for this vid, please someone tell me what do we have in cells 71 and above, what is minimum cash balance? do we assume this or is it given in the reports? i only have information about minimum revolver balance that i need to maintain month on month

If i wanted to calculate the equity value by discounting the FCFE, based on the numbers in the spreadsheet, would i be using row 71 and adding a TV, then discounting that by Ke to get equity value?

Do you sell courses where we can learn to make the above?

Love the videos

What did you get your degree in if you don’t mind me asking?

what happen inside the cell of Interest expenses total for revolving? the formula is not showed in the video

Great easy description I have found to share with students. Would be helpful if you provided the excel worksheet also

Will this be required of a graduate IB analyst for an excel model case interview?

I think the formula in G82 for the Revolver doesn't handle the scenario in which the cash available for discretionary paydown is an amount way less than the undrawn allowed. In short, if I put -1,000 rather than 362 in cell G71, the number I get in G82 is off. I added an absolute value function in the formula to take care of this. Do you guys think is right? I would love to hear your feedback in case I am seeing it wrong. Thanks.

Great video, thanks! How do you separate the bottom boarder line between cells E6 and F6 without having to make another column and removing the boarder?

Thank you. I really appreciate this 🙏

Thank you. I am a student and hadn't heard about feeder tabs before this. Keep sharing useful content

Hello, thank you for the video. Is it 100% necessary to have a circular reference wihtin the model?