FINANCIAL STATEMENT MODELING COURSE
Introducing...
跨9个模块,5个小时以上的视频课程的60多个课程
To Help You Thrive in the Most Prestigious Jobs on Wall Street...
这只是您在本课程中获得的一些
Fundamental Concepts (15 video lessons, 1 exercise)
In this module, we use15个视频课程解释建立三态财务模型时的最佳实践。这包括一个exercise at the end of the moduleand a video solution to make sure you have a good base to continue.
The Income Statement (5 video lessons)
In this module, we use5个视频课程向您介绍损益表以及如何在历史和预测的数字中建立for realistic practice using actual financials of Nike, Inc.
Working Capital (7 video lessons)
In this module, we use7个视频课程to introduce you to the balance sheet andcritical working capital accountsso that you don't miss any steps linking up your statements ...
PP&E和无形(4个视频课)
In this module, we use4个视频课帮助解释PP&E系列项目以及资产负债表上的无形资产这样您就可以完成B/S的建立,并准备解决CF语句。
现金流量声明(7个视频课)
In this module, we use7个视频课程深入了解现金流量声明,以便您真正掌握the difference between cash flow from investing, operations and financing这样您就可以在这里上课将其应用于任何公司…
Debt & Interest Schedule (6 video lessons)
In this module, we use6个视频课探索债务的关键概念和利息时间表,左轮手枪,圆形性以及如何以优雅的方式处理这种情况,以使您看起来像一个模特天才。
Finishing Your Model (8 Videos)
In this module, we use8 video lessons以正确的方式结合您的模型,以便您可以对输出充满信心,包括课程EPS calculations, Projected Shares Outstanding, Option Proceeds and Share Repurchase。
Bonus Module (3 Videos + 1 Answer Key)
在此模块中,我们使用3个视频课程来帮助您建立一个更高级的模型,包括detailed revenue build-up, a sensitivity analysis in the context of Nike, Inc and Macrosas well as a final answer key with the full 3-statement financial model for Nike, Inc.
WSO Financial Statement Modeling Course - Video Preview
Course Summary - Table of Contents
Below you will find a list of the modules and lessons included in this course.
- 简介和课程概述(5分钟)
- 大局(6分钟)
- Setup for Mac Users (5Min)
- 简介(2分钟)
- Excel Proficiency(2Min)
- Shortcuts (3Min)
- Hotkeys (3Min)
- Excel设置 - 热键练习(3分钟)
- If your Excel skills need work... (1Min)
- Formatting Best Practices (5Min)
- Simple Is Better - Inputs (1Min)
- Hard-Coding Formulas (1Min)
- 简单更好 - 留下评论(2分钟)
- Simple Is Better - Grouping (3Min)
- 使用常识(2分钟)
- 为方便起见(2分钟)
- 设计以防止错误(2分钟)
- Fundamental Concepts Exercise
- Fundamental Concepts Exercise: Answer (8Min)
- Income Statement Intro (4Min)
- Date Headers (7Min)
- 历史损益表(3分钟)
- Income Statement Drivers (4Min)
- Income Statement Projections (8Min)
- 资产负债表(2分钟)
- 历史资产负债表(4分钟)
- Accounts Receivable (8Min)
- 库存(3分钟)
- Prepaid Expenses (2Min)
- Payables and Accrued Liabilities (4Min)
- 总结(4分钟)
- Historical Items (5Min)
- 司机(3分钟)
- 预测(6分钟)
- 最终资产负债表(3分钟)
- 简介(2分钟)
- 运营现金流(3分钟)
- Cash Flow From Investing (2Min)
- 股票时间表(2分钟)
- Calculating Dividends (2Min)
- 计算股东权益(2分钟)
- 链接到CFS(3分钟)
- Introduction (1Min)
- 可用于债务偿还的现金(6分钟)
- Long Term Debt (4Min)
- 左轮手枪(8分钟)
- 兴趣(4分钟)
- Circularity (9Min)
- Historical Basic Shares (3Min)
- Historical Dilutive Securities (3Min)
- EPS计算(2分钟)
- Projected Shares Outstanding (2Min)
- Share Repurchase (3Min)
- New Circular Reference (4Min)
- Option Proceeds (4Min)
- Wrapping Up (2Min)
- 收入建设(5分钟)
- Sensitivity Analysis(7Min)
- Macros (6Min)
- NKE模型答案键
Our students have landed and thrived at positions across all top Wall Street firms, including:
Don’t Take Our Word For It
听到我们的一些57,000+ students。。。
听到我们的一些57,000+ students。。。
“与其他课程相比,本课程总体上为使用何时以及如何使用建模以及现金真正代表什么提供了更好的背景,这是我很难学到的东西。我发现课程中的说明非常清楚。我绝对建议任何希望参加财务建模的全面课程。“
“当然是一个很好的资源,为有抱负的or incoming financial analysts. This course pairs excellently with the WSO Excel Modeling course. The two combine to form apowerful training programthat I would highly recommend for all aspiring/incoming financial analysts, particularly those interested in investment banking. Zack, the instructor, does an excellent job of walking you through the entire process in an efficient manner that touches on all the important aspects without getting bogged down in the details too much.我不能更高度推荐本课程!“
“The course was simple to follow and沿途增加了一些有用的提示,以便在现实世界中做什么。对于没有建模经验或寻找快速复习课程的人来说,本课程将是一个巨大的价值。”
“我真的很喜欢财务报表的建模课程,并认为teacher's approach is very thorough and easy to understand.I liked the content of the course, which went through from the beginning of the financial statement all the way until completing the circularity. I appreciate the tips and tricks throughout the course - It made the model definitely more elevated. I really like the "formatting" section andlearn about how investment bankers like to format their financial models - this is super cool to know“
“I don't have a traditional finance background and have had limited exposure to financial statements so this was all very new, but necessary and fun for me to learn. I really like Zack as a teacher, he is relatable and take these somewhat daunting concepts and breaks them down into easy to digest pieces that make the experience fun and enjoyable.重新观看和重新学习该模块上的主题的能力确实很有帮助。但是,我最喜欢的模块部分是Capstone项目。这是一个很棒的练习,to put together a financial model on my own, knowing I can go back to these videos for help, is really empowering,尤其是作为学生。放入其中的细节和护理确实脱颖而出,我知道我已经从今年夏天从中学到了惊人的技能,这些技能将在我的实习期间为我提供帮助,但在我毕业后很久也是如此。This is a great course 10/10 would recommend!"
“与其他财务报表培训相比,最完整的课程”
“本课程为如何创建一个非常简单且结构上合理的模型提供了出色的演练。我相信,对于需要建模和建模的工作的任何人来说,这都是非常有用的will make you more efficient and confident from the start。“
“To any first time modeler contemplating taking a course, I would suggest to stop thinking about it and take the Wall Street Oasis Financial Statement Modeling course. Working in Corporate Development, I understand the necessity of having highly adept modeling skills. During this course, you will learn from start to finish how to build a three statement model, basic accounting fundamentals, and some of the most fundamental Excel techniques used on Wall Street.If I had had this course when I started my career, I would have avoided a lot of mistakes, and saved myself a lot of sleepless nights building my first few models. I firmly believe that anyone who takes this course, actively follows along and completes the accompanying course materials will come out being a better modeler. I cannot recommend this course enough!
“ WSO财务报表建模课程非常好。它可以说是金融工作中最令人沮丧的部分,并将其分解为简单的易于遵循的课程。它削减了其他课程所拥有的绒毛,并结合了最佳实践的绒毛。来自行业。它还包括许多其他课程的组件。What you end up with as a finished product is a clean, professional looking model that can be built out to handle the nuances of any company you are analyzing。Anyone looking for a head start as an intern / analyst would certainly have a head start taking this course".
“Fantastic. A great way to follow the Excel Modeling course - applying the concepts and tools learned in extremely useful ways. I particularly liked Module 7 (Debt & Interest Schedules), as I am a VP in my student-managed investment group at Emory working with our fixed income fund, and the tools learned in there will be very useful to share with my team members (especially new analysts/freshmen beginning in Fall 2020/Spring 2021)"
“内容和课程非常专业且内容丰富。它的制作非常好,并且符合其目的。我建议您向希望了解金融或希望改善工作的专业人员的学生。”
“金融建模课程是辉煌的。非常well explained and someone with just basic accounting knowledge would be able to make the most of it. The course is also ideal in length; a good weekend exercise without taking up too much time."
获得FSM课程认证
After completing the course, all students will be granted the WSO Financial StatementModeling CourseCertification. Use this certificate as a signal to employers that you have the technical FSM skills to immediately add value to your team.
Demonstrate that you have put in the work outside of university courses to make yourself more efficient and master the most critical skills for财务职业的成功。轻松分享LinkedIn和其他社交媒体网站,以突出您的技能并加强您作为候选人的个人资料。
你多少钱
Finance Career Worth?
What You Get |
Value |
---|---|
WSO Financial Statement Modeling Course 50+ video lessons across 9 Modules taught by a top-bucket bulge bracket investment banker... |
$500 |
Statement Modeling Exercise Gain realistic practice drilling the concepts taught in the course with timed benchmarks so that you can ... |
$450 |
实际财务专业人士的24个月无限精英支持 有技术问题吗?轻松将评论放入任何课程中,并在48小时内从专业人士那里获得回复。 |
$300 |
TOTAL VALUE |
$ 1,250 |
Get Unlimited Lifetime Access To The WSO Financial Statement Modeling Course For 84% Off
$ 1,250
$ 197
。。。or get access today for only $77
Secure checkout
100% Unconditional Money-Back Guarantee
12 Month Risk-Free Guarantee
您的投资受到我们12个月无风险保证的保护。如果出于任何原因,您认为WSO财务报表建模课程不适合您,请给我们发送电子邮件,我们将退还每一分钱。无话可问。In short, you get a great return on your investment, or you get your money back。It's that simple.