财务报表建模课程
介绍...
跨9个模块,5个小时以上的视频课程的60多个课程
To Help you Thrive in the Most Prestigious Jobs on Wall Street...
HERE’S JUST SOME OF WHAT YOU’LL GET IN THIS COURSE
基本概念(15次视频课,1个练习)
In this module, we use15 video lessons构建3-statemen时解释的最佳实践t financial models. This includes anexercise at the end of the module以及一个视频解决方案,以确保您有一个良好的基础可以继续。
损益表(5个视频课)
In this module, we use5 video lessonsto introduce you to the income statement and how to build in both historical and projected figuresfor realistic practice using actual financials of Nike, Inc.
营运资金(7个视频课)
In this module, we use7 video lessons向您介绍资产负债表,并关键的营运资本账目这样您就不会错过任何链接您的陈述的步骤...
PP&E And Intangibles (4 video lessons)
In this module, we use4 video lessonsto help explain the PP&E line items as well asintangibles on the balance sheetso that you can complete the build-out of the B/S and are ready to tackle the CF statement.
The Cash Flow Statement (7 video lessons)
In this module, we use7 video lessonsto dive into the cash flow statement, so that you truly grasp投资,运营和融资的现金流量之间的差额so that you're able to take the lessons here an apply them to any company…
Debt & Interest Schedule (6 video lessons)
In this module, we use6 video lessonsto explore the critical concepts of debt andinterest schedules, revolvers, circularity以及如何以优雅的方式处理这种情况,以使您看起来像个模特天才。
完成模型(8个视频)
In this module, we use8 video lessonsto wrap up your model the right way so that you can be confident in the output including lessons onEPS计算,预计股票未偿还,期权收益和股票回购。
奖励模块(3个视频 + 1个答案键)
In this module, we use 3 video lessons to help you build out a more advanced model including lessons on a详细的收入积累,耐克,Inc和Macros的敏感性分析as well as a final answer key with the full 3-statement financial model for Nike, Inc.
WSO财务报表建模课程- Video Preview
课程摘要 - 目录
Below you will find a list of the modules and lessons included in this course.
- 简介和课程概述(5Min)
- 大局(6分钟)
- Setup for Mac Users (5Min)
- Introduction (2Min)
- Excel Proficiency (2Min)
- 快捷方式(3分钟)
- Hotkeys (3Min)
- Excel Settings - Hotkey Practice (3Min)
- If your Excel skills need work... (1Min)
- Formatting Best Practices (5Min)
- Simple Is Better - Inputs (1Min)
- Hard-Coding Formulas (1Min)
- Simple Is Better - Leaving Comments (2Min)
- 简单更好 - 分组(3分钟)
- 使用常识(2分钟)
- Designing For Convenience (2Min)
- 设计以防止错误(2分钟)
- 基本概念练习
- 基本概念练习:答案(8分钟)
- Income Statement Intro (4Min)
- 日期标题(7分钟)
- Historical Income Statement (3Min)
- Income Statement Drivers (4Min)
- 损益表预测(8分钟)
- The Balance Sheet (2Min)
- Historical Balance Sheet (4Min)
- Accounts Receivable (8Min)
- Inventories (3Min)
- Prepaid Expenses (2Min)
- 付款和应计负债(4分钟)
- Wrapping Up (4Min)
- Historical Items (5Min)
- Drivers (3Min)
- Projections (6Min)
- Final Balance Sheet (3Min)
- Introduction (2Min)
- Cash Flow From Operations (3Min)
- Cash Flow From Investing (2Min)
- 股票时间表(2分钟)
- 计算股息(2分钟)
- Calculating Stockholder's Equity (2Min)
- Linking to the CFS (3Min)
- Introduction (1Min)
- 可用于债务偿还的现金(6分钟)
- 长期债务(4分钟)
- Revolver (8Min)
- Interest (4Min)
- 圆形(9分钟)
- Historical Basic Shares (3Min)
- 历史稀释证券(3分钟)
- EPS Calculation (2Min)
- Projected Shares Outstanding (2Min)
- 共享回购(3分钟)
- 新的圆形参考(4分钟)
- Option Proceeds (4Min)
- Wrapping Up (2Min)
- Revenue Build (5Min)
- Sensitivity Analysis (7Min)
- 宏(6分钟)
- NKE Model Answer Key
Our students have landed and thrived at positions across all top Wall Street firms, including:
Don’t Take Our Word For It
Hear from a few of our57,000多名学生。。。
Hear from a few of our57,000多名学生。。。
“与其他课程相比,本课程总体上为使用何时以及如何使用建模以及现金真正代表什么提供了更好的背景,这是我很难学到的东西。我发现课程中的说明非常清楚。I'd definitely recommend anyone looking to take a comprehensive course on financial modeling."
“该课程是有抱负或传入的财务分析师的绝佳资源。本课程与WSO Excel建模课程非常出色。两者结合以形成A强大的培训计划我强烈建议所有有抱负/传入的财务分析师,尤其是对投资银行业务感兴趣的财务分析师。万博app网页版讲师Zack非常出色地以有效的方式引导您完成整个过程,从而触及所有重要方面,而不会过多地陷入细节。I cannot recommend this course more highly!"
"The course was simple to follow and在现实世界中的工作也增加了一些有用的提示。This course would be a great value to someone who has no experience modeling or looking for a quick refresher course."
"I have truly enjoyed the financial statement modeling course and think that theteacher's approach is very thorough and easy to understand.我喜欢课程的内容,该课程从财务报表的开头一直到完成循环。我感谢整个课程中的技巧和窍门 - 它绝对使模型更加升高。我真的很喜欢“格式化”部分,了解投资银行家喜欢如何格式化其财务模型 - 这真是太酷了"
"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.重新观看和重新学习该模块上的主题的能力确实很有帮助。My favorite part of the module, however, was the capstone project. It's a great exercise andto put together a financial model on my own, knowing I can go back to these videos for help, is really empowering, especially as a student. The detail and the care that was put into it really stood out, and I know thatI have learned amazing skills from this that are going to help me in my internship this summer, but also long after I graduate university.This is a great course 10/10 would recommend!"
"Most complete course compared with other financial statement trainings"
"This course provides an excellent walkthrough on how to create a very simple and structurally sound model. I believe it would be very useful for anyone beginning in a job requiring modeling andwill make you more efficient and confident from the start。"
“对于任何第一次打算参加课程的建模者,我建议停止考虑并参加华尔街绿洲财务报表建模课程。在公司开发方面,我了解具有高度熟练的建模技能的必要性。在本课程中,万博app足彩下载您将从头到尾学习如何构建三个语句模型,基本会计基础知识以及华尔街使用的一些最基本的Excel技术。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。任何寻找实习生 /分析师的首先开始的人肯定都会开始学习这门课程。”
"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)"
“内容和课程非常专业且内容丰富。它的制作非常好,并且符合其目的。我建议您向希望了解金融或希望改善工作的专业人员的学生。”
"The financial modeling course is brilliant. Very 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."
Get the FSM Course Certification
After completing the course, all students will be granted the WSO Financial Statement Modeling Course Certification. 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 success in finance careers. Easily share to LinkedIn and other social media sites to highlight your skills and strengthen your profile as a candidate.
How Much is Your
Finance Career Worth?
你得到什么 |
Value |
---|---|
WSO财务报表建模课程 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 Months of Unlimited Elite Support from Actual Finance Pros Have a technical question? Easily drop a comment into any lesson and get a response from a pro within 48hrs. |
$ 300 |
TOTAL VALUE |
$1,250 |
享受84%折扣的无限寿命访问WSO财务报表模型课程
$1,250
$197
...或今天仅以$ 77获取访问权限
Secure checkout
100% Unconditional Money-Back Guarantee
12个月无风险担保
Your investment is protected by our 12-Month Risk-Free Guarantee. If, for any reason, you don't think the WSO Financial Statement Modeling Course is right for you, just send us an email, and we'll refund every penny. No questions asked.In short, you get a great return on your investment, or you get your money back。It's that simple.