ty

Where can I get the excel drills file ????

Great video - but this shows how wonky of an exercise accounting can be

May I have the link to follow the training?

Where can i get the link ??

In my mac this control +command+v not working what should i do please help

thank you my dear , good job 😃

It is same as windows ... what i see

Friend, your ability to adopt different trading strategies and win with them is crazy!

Icredible content thank you so much for sharing

excellent thank you

my balance did not balance...

I've done something similar before using INDEX and MATCH instead of offset. Here's a single formula you could use to get the values for F13:H16, no copy/paste or fill required; just enter the formula in F13 and it will spill the result in the other cells: =INDEX(F21:H36,MATCH(B13:B16,B21:B36,0)+MATCH(D18,B21:B36,0)-1,SEQUENCE(,3)) (I think I got the cell references to match the sheet in the video but I did it by hand)

Thank you!

Link to file?

❤❤❤

Hedge Fund & Buy-Side Investing Certificate Program | Wharton Online and Wall Street Prep • Learn More → www.wallstreetprep.com/buyside

A-M-A-Z-I-N-G! Thank you!

wow where have you been all my life😀. I been trying to learn this own my own and give up due to learning curve! thank you!!

Very simple & best explanation, now i will construct whole Financial model based on multiple case scenario. Thank you

Whats the drag formula shortcut you use? Kind regards!

I am facing an issue while doing the DCF analysis in my financial model and i am not able to reconcile it correctly. Can someone please help me with my issue, I would be really grateful for it.

where's the index xmatch part?

May l ask a dumb question , my take is that the additional debt formula should be (LTD (Current Year)+CPLTD (Current Year))−LTD (Previous Year) . as the CPLTD from previous year would have gotten paid off

👀

Thank you

I’m loving this

Life saver - reduced 16 hours of work in 6 second

thank you , this might be helpful for me .

share the excel file.

Ohhh my god I wanted to submit my model today And you saved my godamn life bro

Well, i like to start with the financing activity, because that's the first in order technically. Raise money (financing), invest money (investing), and create money (operating)

Exceptional 😊

THANK YOU!!! This just saved me SO MUCH TIME

Why the style is different than a normal comment?

Bro pls recommend Excel Courses for financial modueling

Thank you for the video. Please consider making career guide for private equity, so that it helps with interview preparation and career advancement. Thank you.

yo im now a master of the finance universe hell yeah rly helpful video ty

Thank you ❣️

Thank you! very good tutorial)

Where do GL items like Reserve for Bad Debt, Reserve for Inventory Obsolescence go? Are those netted with AR and Inventory?

Thank you for your videos. can you please create one where you show how to create a hyperlink using a Mac and linking it to a specific cell in another worksheet? Thank you

Hi Would you go about modeling a deal with equity issuance? Thanks

Hi, thank you for such useful and informative videos. I was wondering if there's any other way to bring Paste Special dialogue box as it doesn't work on my Mac M1 2021. Thank you.

Wonderful explanation! Thank you..

Great tutorial, but it seems to me you like to show off your excel (shortcut) skills.

I love Xlookup and use it every day at work, but I'm running into issues with duplicates. In this example, what if you had 2 Armanis? XLookup up would only pull the first one every time. I'm dealing with list of over 100k VINs.

I don't understand how you can assume the interest payments for a sculpted profile would be the same as an annuity. If the principal payments during each period are different, I don't see how the interest could be the same if the interest payment is based on outstanding debt at the beginning of the calculation period?

Love it