|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/learn-financial-modeling-part1/
课程评论：没有评论
课程名称：从零开始学习财务模型 - 第一部分 课程概述： 财务建模需要在实际金融、MS Excel 和商业/行业分析方面具备出色的技能。本课程是一站式解决方案，涵盖了所有这些领域，并培训您从空白工作表开始构建电子表格预测。无论您是正在为潜在投资者准备商业计划的企业家，还是梦想在投资银行担任分析师的毕业生，这都是适合您的课程！整个课程分为三个部分： 1. 从零开始学习财务模型 - 第一部分（当前课程） 2. 从零开始学习财务模型 - 第二部分 3. 从零开始学习财务模型 - 第三部分 培训材料： 学习材料包括财务建模案例研究、增值会话视频、每个部分结束时的财务模型版本、最佳实践的插入提示、金融和MS Excel的快速提示、提高效率的键盘快捷键指南，以及基础Excel和基础财务的手册（即将推出！）。 授课教师： 本课程由阿什托什·扎瓦尔（Ashutosh Zawar）主讲，他是一名拥有优异成绩的注册会计师，拥有印度普纳大学的商科学位。阿什托什是金融培训学院（Academy of Financial Training）的联合创始人兼首席培训师，拥有超过9年的投资银行、项目金融、咨询和培训经验。他有超1000小时的专业培训经验，负责管理AFT的在线学习和多媒体内容。阿什托什曾在IDFC的项目金融团队和摩根士丹利的投资银行团队工作，涵盖医疗保健、教育、旅游、电信和能源等多个行业。 课程时长： 整套三部分课程约需8-10小时的视频学习，以及20-30小时的MS Excel自我实践。 课程结构： 本课程旨在指导学员从空白的Excel电子表格开始，逐步建立完整的财务报表预测，包括资产负债表、收入表和现金流量表。课程还考虑了制造公司真实案例研究，并涵盖资本支出、折旧、营运资金、贷款或债务、利息、所得税和现金平衡机制等重要计算计划。 为何选择此课程？ - 该课程已有数百次课堂版本在知名银行、制造公司和商学院开展。 - 课程内容由在投资银行、股票研究、项目金融和商业咨询领域拥有丰富经验的专业人士设计、录制和编辑。 - 强调简单性、准确性和效率。 - 探讨财务建模的最佳实践和常见错误。 - 提供课程期间及之后的专家实时支持。
About the Course: Financial Modeling requires great skills in Practical Finance, MS-Excel and Business / Industry analysis. This course is one-step-solution which precisely covers all these areas and trains you to build spreadsheet based projections from a blank worksheet. So, if you are an entrepreneur preparing a business plan for your potential investors or just a graduate dreaming to work as an analyst at an Investment Bank, this is the program for you! This entire Curriculum is divided into 3 different Courses Learn Financial Modeling from Scratch - Part 1 - Current Course Learn Financial Modeling from Scratch - Part 2 Learn Financial Modeling from Scratch - Part 3 This Course is Part - 1 of the three part series of the entire Course. Training Materials: Learning materials include Financial Modeling Case Study, Value-added Session Videos, Financial Model versions at each section-end,In-video prompters on Best Practices, Quick tips on Finance and MS Excel,Guide on Keyboard Short-cuts for better efficiency,Handbook on Basics of Excel and Basics of Finance (Coming Soon!) Course Facilitator (Faculty): The course is facilitated by Ashutosh Zawar, who is a rank-holder Chartered Accountant and a Bachelor of Commerce from University of Pune, India. He is a Co-Founder & Lead Trainer @ Academy of Financial Training. He has over 9 years of experience across Investment Banking, Project Finance, Consulting and Training. Ashutosh has over 1,000 hours of professional training experience. He looks after the e-learning, multimedia content management at Academy of Financial Training (AFT). He has been instrumental in launching AFT's new training programs and innovating curriculum across topics such as Advanced Financial Modeling, Excel, Banking, Corporate Finance. Before co-founding AFT, he worked with the Project Finance team at IDFC, a leading financial services company in the Infrastructure domain and the Investment Banking team at Morgan Stanley. he has worked on sectors such as healthcare, education, tourism, telecom and energy. His work profile included operational and financial modeling, business appraisal, valuation analysis, drafting of terms and commercial negotiations. Duration: The entire 3 part course takes about 8-10 hours of video-based learning and 20-30 hours of simultaneous self-practice on MS Excel. Structure of the Course: The course guides candidates to start with a blank Excel spreadsheet and goes on to build full-fledged forecasts of Financial statements i.e. Balance Sheet, Income Statement and Cash flow StatementA real-life case-study of a manufacturing company has been considered for this programIt also includes important calculation schedules like Capital Expenditure, Depreciation, Working Capital, Loan or Debt, Interest, Income Tax, Cash balancing mechanism. Why take this Course? Hundreds of classroom editions of the program already executed and ongoing for leading banks, manufacturing companies and b-schools.Course content designed, recorded and edited by professionals with rich work experience in Investment Banking, Equity Research, Project Finance and Business Consulting domains at world-class banks.Focus on simplicity, accuracy and efficiency (Building quickly)Best practices and common errors to avoid in Financial Modeling coveredLive support from expert trainers during and after the programs
