Financial Modeling Quick Lesson: Building a Discounted Cash Flow (DCF) Model – Part 1 | financial model คือ

Financial Modeling Quick Lesson: Building a Discounted Cash Flow (DCF) Model – Part 1

นอกจากการดูบทความนี้แล้ว คุณยังสามารถดูข้อมูลที่เป็นประโยชน์อื่นๆ อีกมากมายที่เราให้ไว้ที่นี่: ดูเพิ่มเติม

Learn the building blocks of a simple onepage discounted cash flow (DCF) model consistent with the best practices you would find in investment banking. If you are preparing for investment banking interviews, know that the DCF is the source of a TON of investment banking interview questions.
To download the backup Excel file, go to
The DCF modeled here is a simplified version of a fullyintegrated DCF model. For a deeper dive into DCF modeling in Excel, please visit

Financial Modeling Quick Lesson: Building a Discounted Cash Flow (DCF) Model - Part 1

3 Statement Financial Model | Building From Scratch

We walk through the process of building a 3 statement financial model starting with an empty Excel spreadsheet. Also included is a downloadable template of the model.
🚨 My Finance for Startups program is launching on November 14th 🚨 There will be limited space. Join the waitlist for a chance to get access before the public:
► 3 Statement Financial Model Template Download:
Join My Communities (big announcement coming):
► Subscribe to my email newsletter:
► Discord:
My Excel Courses:
► Become an Excel Power User in 2.5 Hours (85% discount):
► Master Excel Keyboard Shortcuts (85% discount):
Related Financial Modeling Videos:
► Finance Interview Prep Series | Crush Your Interview:
► Basic eCommerce Financial Model:
► Discounted Cash Flow Model:
► How VCs Calculate Customer Retention \u0026 LTV:
In this video, we learn how to build a 3 statement financial model in Excel, which includes an integrated Income Statement, Balance Sheet, and Cash Flow Statement with a balance sheet that balances!
Also included is a link (in \”resources \u0026 links\” section) where you can download the 3 statement financial model Excel template for free.
In order to successfully build these types of models, you need to really understand that the models are representing the operations of a company. And if you understand the operations and construction of these models, you will be better at building them, and better at fixing them.
So in an effort to make you better at financial modeling (and being analytical), let’s zoom out and talk about what these three financial statements represent, and how they work.
Here is a brief explanation of each one.
Income Statement:
The income statement shows the amount of revenue a business generates from providing a service, and the expenses associated with the service, over a window of time. This is why the income statement is considered a flow statement as it summarizes flows of income over time. This statement, however, doesn’t tell us anything about the capital structure of a company (debt, equity, assets purchases, etc).
Balance Sheet:
While the income statement shows us what happened during a period of time, the balance sheet can only show us one precise moment. The balance sheet shows us exactly what a company owns, and owes, on a specific date. But what happens to what we owe / own over periods of time? The balance sheet cannot tell us anything about that.
Cash Flow Statement:
The cash flow statement is a flow statement, similar to the income statement. However, while the income statement is showing us revenues and related costs, the cash flow statement is simply converting the balance sheet into a flow statement by calculating the changes in what we owe / own (on the BS). The cash flow statement doesn’t care about what services we provide, it only tracks where the dollars go. Things like debt repayment and changes in working capital show up on the cash flow statement, but not on the income statement.
0:15 Overview of income statement, balance sheet, and cash flow statement
1:14 Steps for building a 3 statement financial model
1:55 Income statement: building the assumptions
5:39 Income statement: building the forecasting model
13:25 CAPEX \u0026 depreciation schedule
18:57 Balance sheet: historical numbers \u0026 concept discussion
21:05 Liabilities + Equity = Assets (in order for the balance sheet to balance)
21:39 Balance sheet: building the assumptions
23:55 Balance sheet: building the forecasting model
25:20 Balance sheet: linking in the Capex model
26:30 Balance sheet: modeling out debt
28:15 Balance sheet: linking net income (P\u0026L) to retained earnings (BS)
29:55 Cash flow statement: structure \u0026 discussion
31:15 Cash flow statement: operating cash flow section
33:30 Cash flow statement: investing cash flow \u0026 free cash flow
34:00 Cash flow statement: cash flow from financing
35:15 Cash flow statement: net cash flow calculation
35:43 Balancing the balance sheet (linking in net cash flow)
36:32 Troubleshooting checklist if your balance sheet doesn’t balance
I hope that you can now feel confident building a 3 statement financial model in Excel. If you have questions (I’m sure you do) please leave comments below and I’ll try to help. Cheers!
financialmodel 3statementfinancialmodel

See also  Ep.115 | การสมัครผู้ประกันตน ม.39 สิทธิที่ได้รับ เงินสมทบที่ต้องจ่ายต่อเดือน การพ้นสภาพ by HR_พี่โล่ | ส่งประกันสังคมเอง ทําอย่างไร
See also  [Eng Sub] Boy For Rent ผู้ชายให้เช่า | EP.1 [1/4] | โรงงานให้เช่า | ข่าวการลงทุนที่มาแรงที่สุดในวันนี้

3 Statement Financial Model | Building From Scratch

Importing Stock Data Dynamically Excel | FAST, EASY, NO PROGRAMMING

Want to automatically import 10 years of a stock’s financials into Excel with one click? This video will take you from a blank excel sheet to automatically updating a stock’s financial information with one click and no programming is involved. This video will step you through how to get the income statement, balance sheet, and cash flow statement. However, if you want price information or other metrics, I show you where to go to access to that information as well.
Two of the biggest struggles when analyzing stocks is getting enough information to get a reasonable look at the company, and secondly getting data into Excel to be able to build models on that data. This video will solve both issues by showing you how to get stock information in Excel. I have seen several other videos that claim to automatically get stocks information into Excel, but all they really get is price and market cap. But if you are anything like me, you realize the price isn’t a driver of a company’s value, so getting the financial information to automatically update in Excel is crucial to your analysis. So I hope this video helps you out too.
If you want to see more videos where I help you find value in the stock market, then you should subscribe. This channel was created to find undervalued stocks with the hopes of teaching people the best investing practices. If you have any questions or comments, please let me know by leaving a comment down below. Otherwise, thank you for watching and please enjoy my video on how to get stocks financial info in Excel.
in case you have future questions:
//Website to pull additional info:

See also  อายุ 55 รับชราภาพ และสมัคร ม 39 ได้มั้ย【ตอบคำถามกฎหมายแรงงานและประกันสังคม EP.36】 | เงิน ประกัน สังคม อายุ 55

Subscribe for more top stock videos:
Top 3 Small Cap Stocks July 2019
CREDIT: Subscribe Button by MrNumber112
Ae Project files:

Importing Stock Data Dynamically Excel | FAST, EASY, NO PROGRAMMING

Top 10 Financial Modeling Skills

This video outlines the top 10 most important financial modeling skills required to be a worldclass financial analyst. Financial modeling is the art of building a dynamic tool (an Excel model) that can be used to evaluate investment opportunities, mergers \u0026 acquisitions (M\u0026A), capital raising, or to assess a company’s historical and forecasted financial performance.
Click here to learn more about this topic:
Interested in CFI’s FMVA® certification program? Click here to find more information:

Top 10 Financial Modeling Skills

Financial Models: Learn the Different Types

There are many different types of financial models. In this video, we will outline the top 10 most common models used in corporate finance.
Click here to learn more about this topic:

Financial Models: Learn the Different Types

นอกจากการดูหัวข้อนี้แล้ว คุณยังสามารถเข้าถึงบทวิจารณ์ดีๆ อื่นๆ อีกมากมายได้ที่นี่: ดูบทความเพิ่มเติมในหมวดหมู่Investement

11 thoughts on “Financial Modeling Quick Lesson: Building a Discounted Cash Flow (DCF) Model – Part 1 | financial model คือ”

  1. 377159 732478Today, I went to the beach front with my children. I found a sea shell and gave it to my 4 year old daughter and said “You can hear the ocean if you put this to your ear.” She placed the shell to her ear and screamed. There was a hermit crab inside and it pinched her ear. She never wants to go back! LoL I know this is entirely off topic but I had to tell someone! 120526

  2. 807175 167626light bulbs are great for lighting the home but stay away from incandescent lamps because they generate so much heat;; 851404

  3. 498808 859537amazing post, really informative. I wonder why the other experts of this sector do not notice this. You ought to continue your writing. Im positive, youve a fantastic readers base already! 175969


Leave a Comment