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 www.wallstreetprep.com/blog/financialmodelingquicklessonbuildingadiscountedcashflowdcfmodelpart1/
The DCF modeled here is a simplified version of a fullyintegrated DCF model. For a deeper dive into DCF modeling in Excel, please visit www.wallstreetprep.com.
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: https://www.startupfinancecourse.com/earlybirdoptin
RESOURCES \u0026 LINKS:
► 3 Statement Financial Model Template Download: https://bit.ly/3stmt_mlchmp
Join My Communities (big announcement coming):
► Subscribe to my email newsletter: http://bit.ly/joinericnewsletter
► Discord: https://discord.gg/gHghhVcW3S
My Excel Courses:
► Become an Excel Power User in 2.5 Hours (85% discount): http://bit.ly/excelpwrusr521
► Master Excel Keyboard Shortcuts (85% discount): http://bit.ly/shortcuts521
Related Financial Modeling Videos:
► Finance Interview Prep Series | Crush Your Interview: http://bit.ly/fin_intervw_prep
► Basic eCommerce Financial Model: https://youtu.be/KfUam8C40uY
► Discounted Cash Flow Model: https://youtu.be/Gm0Xn_MidZ8
► How VCs Calculate Customer Retention \u0026 LTV: https://youtu.be/OwCATJh4lNg
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.
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).
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!
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.
THIS TUTORIAL IS OUT OF DATE. PLEASE USE THIS UPDATED ONE INSTEAD.
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: https://www.youtube.com/channel/UC2sMouLeeWBiG42JfyZUkfA
//Website to pull additional info: https://financialmodelingprep.com/developer/docs/
Subscribe for more top stock videos: https://www.youtube.com/channel/UC2sMouLeeWBiG42JfyZUkfA?sub_confirmation=1
Top 3 Small Cap Stocks July 2019
CREDIT: Subscribe Button by MrNumber112 https://youtu.be/Fps5vWgKdl0
Ae Project files: https://www.patreon.com/posts/20870148
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: https://corporatefinanceinstitute.com/resources/knowledge/modeling/financialmodelingskills/
Interested in CFI’s FMVA® certification program? Click here to find more information: https://corporatefinanceinstitute.com/certifications/financialmodelingvaluationanalystfmvaprogram/
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: https://corporatefinanceinstitute.com/resources/knowledge/modeling/typesoffinancialmodels/
นอกจากการดูหัวข้อนี้แล้ว คุณยังสามารถเข้าถึงบทวิจารณ์ดีๆ อื่นๆ อีกมากมายได้ที่นี่: ดูบทความเพิ่มเติมในหมวดหมู่Investement