this 38 minutes better than my whole years in undergraduate degree. Thank you soo much Eric!

Thank you for this video! I found this because I am in the middle of jobs interview and part of the process was a financial modeling test. I studied this video to prepare and I just received the email that I excelled on the test, and I will have the final interview with the CFO. Thanks again!!

38 minutes of my life well spent. Great content. Thank you so much for this informative video.

Great video. Here's a helpful tip for those struggling to balance: if your balance sheet is not balancing, quite often it's because your fixed assets, capex, and depreciation are not in sync across the 3 statements. To test for this, take last year's fixed assets, net of amortization from last year's balance sheet, add capex expenditures from the cash flow statement (which increases net fixed assets), and subtract depreciation shown on the cash flow statement and income statement (which reduces net fixed assets). The result should be the net fixed assets on your current year balance sheet. if it's not, then you're out of sync, and your balance sheet won't balance until you fix it. FA, Deprec, and Capex are a closed loop and must work together.

The interlinkages make way more sense when you are actually working through these statements in a real example case, sure lecture topics help us shape our approach, but without applied examples most of it goes in one ear and out the other! You have a natural talent for teaching, thank you for this content!

In the history of my life I have never commented on KZfaq!! So this is a big deal! AMAZING!! This was soooooo helpful. You have no idea! Being able to learn this the way you teach with templates and myself putting in the data at the same time while I paused the video was worth more than ALLLL the years i spent learning accounting in high school and college. Seriously thanks. Def. subscribed!

This deserves many many more views. Pure, succinct, free !! My best wishes to you, Eric !

Great Tutorial for understanding Business with Excel. I need to watch your video over and over before I get the hang of it. Thanks

Oh man...what a presentation. Can't get any better than that. One of the best learning videos i have seen so far. Feels great that i stumbled upon on this video and did justice by spending 38 quality mins of my life. Thanks a ton Eric :) God bless you...

I have 10 years experience as financial analyst and i can declare - this video is the best. Exactly what u need to know at the beginning

What has been taking me 2 years and counting can literally take me a week or so thank you so so much. New, permanent subscriber here!!!! I'm starting with my financial projections right now @10:30pm.

Gorgeouss I studied these ideas back in 2006-207 :DD but after I moved to other countires, so I studied English. So many new words and also a refresh of my previous studies. I hope to pass my JOB interviewww. Thank you so muchh it was incrediblee

I have to felicitate you!!!!! To do this in 30 minutes, so well explained that a novice excel user can understand it, I am surprise!!!! you are indeed bless. thank you for sharing your teaching blessing in finance!!!! Looking forward to check other lessons.

I smashed my interview in investment banking thanks to you man, with no prior experience, for my BBA internship, they were really really impressed !!!!!! thank you so much

This is simply the best lecture! No need for expensive database. Just excel spreadsheet. Keep it up

Great video Eric! That's the most valuable 38 minutes I've ever spent - now I get a deeper understanding of the difference between FCF and FCFF. Nicely done!

I just realized that what I learned in college much more complicated and when you watch this 38mins video , you got insights which one is important Thank you for the vid

You're amazing! I've watched this three times and it's really helped me with my forecasting. Thank you!

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

A really great video! Thank you so much because this helped me clear the interview of a boutique Investment Banking firm where the interviewer asked me how to link the Cash flow statement and the balance sheet and I at the back of my mind, I was like 'Thank you so much Eric Andrews'!

Good intro video. Couple of quick points to add for people interested. 1. Capex purchases should show as negative in the investment cash flows for consistency. P&L is optional but CF almost always is directional.Any asset sales would be positive for CF. 2. That 30k of undepreciated fixed assets (40-10) in the opening balance sheet most likely should be depreciated, not just the new purchases.

Awesome video Eric. I've been a Finance manager for a few years and have always been forecasting P&Ls because we're a start up. This will help me take my forecasting skills to the next level. Cheers

This is really incredibly helpful. I haven't built a model on my own before, and I think this really gave me a guide to doing it myself. Thank you so much!

But all in all am so so happy ! Your video. Has simplified my life..Thank Thank you.. Respect dear brother

Best ever video on the 3 financial statements. For the first time I was able to complete end to end such model for an ongoing business. Thanks for sharing such insightful video.

Maybe the most useful 38 minutes I've spent this year. Fantastic!

Really wonderful video, best 38 minutes of learning I've had all year! Source: I'm a quant

I hope to have a financial analyst job by November/December, I read building a 3 statement model is a must in every FA job interview, thank you for making this Eric!! God bless you!

I watched 2 of your video now back to back. I have always been interested in Excel and financing models but your videos saved me tones of $$$ in planned course fees. Thanks you

Eric to see you had fun going through it without losing the audience... awesome.

Very good video. I’ve been a CPA for 18 years and a CFO for 14. Your accounting/financial statement format knowledge seems broad. Thank you.

Thanks ERIC appreciated good learning, highly recommended for all finance aspirants

The satisfaction at the end when the balance check of all years was zero after plugging in the cash balances !!! Super Video Eric !

Now I can easily understand the models and how they link-up together in simple logical explanation, no technical jargon that even hard to spell. Thanks Eric! ..looking forward for more videos.

Wow ! This is so good. Thank you so much for the clear explanation. All accounting and finance students/professionals must see this.

Literally the best video ever!!! I built the entire model and understood it all. THANK YOU!!

Big thanks for that clear and understandable explanation, all financial accounting course in 38 minutes! just go ahead

You are the best Eric. Thank you. Can you please do a video of how to use a truth table to calculate depreciation? Thanks

I wanted to say that this video is worth of 2 years in finance classes at school but its taken already. Such a great explanation!!!

I really love this...Despite being CPA and having finance bachelor things have never been presented this clearly in my life. Thank you do much 💐😘

Thank very very much. I was just totally lost, but you came along with your tutorial and made my day. 🙏🙏🙏

the last 38mins has been my best understanding of financial modedlling :-) thank you Eric

This was some of the most useful information I’ve ever had the privilege to consume. Am on a job hunt for financial analyst job & need to brush up my skills. Thanks for this !!

Finally I can understand financial modeling. Thanks Erick

This is amazing man, it helps me a lot for my business even though I'm studying CPA, it's so quick and clear with the video. THANK YOU

Just completed this video and i must say it is really great content

Well done. Your explanations are extremely clear. Thank you!

This was by far the best video I’ve seen on 3 statement modeling. I was trying to watch videos by some prep companies a couple months but those went above my head and made me give up for some time. Thanks !

You are an expert at delivering knowledge

Fabulous Teaching Period. Cleared my concepts like Crystal I swear...

3 Statement financial model well elaborated!! You are the best on-line tutor

Thank You Eric, You explained this financial model in such an easy and understandable way.

I do appreciate Brother Eric! I have been a practitioner for self teaching on corporate finance..but your vide on build financial statements is reall good..Thank you very very much

This video was phenomenal! Totally simplifies the 3 financial statements and links them. Allows you to clearly see the difference between all 3 statements. As an economic consultant and finance professional, this video has brought me great value! Thank you so much

not all heroes wear capes, but you wear the crown. Thanks for this Eric!

Of course I'm subscribing, I'm most grateful for such a great presentation. You are a life saver.... Thank you

This is very explanatory and simple to understand. Thanks Eric for the video.

Eric: Thank you for the excellent content, your explanation was so amazing.

where ever you are may whichever deity you pray to bless you infinitely

thank you so much. Your video helped me for our business plan submission. Asante sana

Dude, I have no other words but AMAZING for you and this video! Clear, concise and engaging, as I was following every step in the excel file you provided in the video description. I just found my new KZfaq teacher!!

Awesome. Thank you for your Accounting Teaching. 38 Minutes make me Clear > I ever learned.

Just brilliant. Loved your presentation, loved how quickly you put the whole thing together. Very inspiring. thank you!!!!

Really this 38 mins is worth a lot more then 4 yrs of my graduation. Hats off to you Eric. Your truly an inspiration for accountants like us. Lots of love and gud wishes for you and your future brother. ❤️❤️

I understand insects better than numbers but i understood the logic. Very cool, Thank you

most informative video i've seen on 3 statement modelling!!!! thank you Eric, please keep up the amazing work!

Awesome! A complete and simple explanation of how all 3 FS work together!

Thank you so much, I agree this is way better than years in undergraduate degree! thank you again

Thank you so much, i've learned a lot and will keep watching your videos!

Hey, I love this. I patiently watch this. Needed in my job. My new company has problem in FS. My recently task is Cash Flow. There's a discrepancy. This video of yours I will try this, hopefully can help my employer. Thank you very much. Please create more content about FS or auditing each titles, and taxes. God bless!

Your explanation was great! I have always struggled with basic financial modelling and you made everything appear very simple! Thanks a ton!

This video is awsome😊 the best modeling course on KZfaq👍🏻

this video is gold...I am able to understand each and everything related to modelling thanks for being a CA student however i was getting problem in excel cause i am like beginner into it....love from india bro and thx for such excellent lesson

Great performance. This was understandable and logical

your explanation is very wonderful

Man! what a course this was!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

Awesome.. This video is better than my MBA accounting class. Thanks Eric

Thanks for the amazing video Eric, excellent as usual. I just need to raise one issue here, which is the way you calculated FCF (@33:57) I have a strong tendency to believe that you have made a mistake here, and let me explain please. FCF can only be equal to Cash flow from Operating Activities - Cash flow from Investing Activities IF THE COMPANY HAS NO OUTSTANDING DEBT ON WHICH IT PAYS INTEREST. In our case the company had an annual interest expense, and so to calculate FCF from the statement of cash flow it should be as follows: FCF = CF from OperatingActivities - Interest Expense + Interest Tax Shield - CapEx. You missed on the "Interest Expense" and the "Interest Tax Shield" and for anyone who is hesitant about this try to calculate the FCF using the original method which is FCF = EBIT(1-t) + Dep&A - Chg in NWC - CapEx and you will find that the numbers are different than in the Video, whereas if you include the "InterestExpense" and the "InterestTaxShield" as I mentioned they would be the same. Thank you

WOW, well explained with basic data . It's really great and huge data can be handled very easily after watching this video . I did less or more in a same way but still got great idea and logic to compile the huge data .

What a valuable 38 minutes of learning 😊

One of the best videos on building a financial model I have ever seen. It's very concise and well-explained. Thanks a lot, Eric.

Hey man, love the video, but wanted to point something out. Just in case anyone is confused, at 22:31 the name of that row should be "Total Current Liabilities", not "Total Current Assets", underneath the deferred revenue and accounts payable.

You just made this feel so seamless. I got everything on point. You are a great Tutor. Thanks very much.

Best learning video in short time thanks sir for making this video

Starting a new career and this video really helped me build a strong foundation for financial models. Thanks so much!

Wow, your video is so well structured and good. You should become a professor or teach a class. I love the way you explain things!

This is exactly what I needed !! Thank you so so much Eric!

wooow this is amazing, thank you soooo much,, 37 min better than my three-month course

I left a small thank you, really helpful video

Excellent and simple Eric ...

I can't thank you enough Sir, the model you created is informative + fun. Please continue to upload such great stuff. Thank you 😍

Right away, I see it is a good video! Eric is a real cool teacher. The skill is important, most analysts don't know who to integrate models with a balance sheet, so are prone to make all sorts of mistakes, which sometimes end up being dissected in courts. I like the layout of the model, even though I prefer to model all the three statements and have all the supporting statements on a single worksheet. And separate out each statement module with an empty gray row of cells. But I see little point in doing "Excel without a mouse" - saving in time is dubious

Kudos... Eric Useful lecture Please continue the good work

Thank you so much Eric. You helped me understand building the financial models and do my work easily.

Hey brother! It was really so good for all the beginners in understanding basics

I truly thank you, for this video I learned a lot.

Really appreciate your simple and informative video. God bless you

Thank you Eric. This explanation is awesome. Very clear and simple.

Superb explanation! You are a pro!

Thanks, Eric. You did a splendid job there. Your teaching skills make it quite easy to understand. You're doing a great job with these tutorials.