Financial Modeling & Valuation in Excel - Complete Course
Complete package of excel, accounting, ratio analysis, financial modeling, forecasting and business valuation techniques
4.44 (1260 reviews)
9 506
students
33.5 hours
content
Jul 2023
last update
$79.99
regular price
What you will learn
Master Excel Skills: From basic functions to advanced features like PivotTables, learners will gain proficiency in using MS Excel for financial modeling.
Build a Strong Accounting Foundation: Understand financial statements, income statements, and balance sheets. Learn to read annual reports and analyze
Comprehend Income Statements: Explore revenue recognition methods, profit margins, and conduct a detailed analysis using a case study on Colgate
Navigate Balance Sheets: Gain practical insights into current assets, long-term assets, liabilities, and equity. Value inventory, handle prepaid expenses
Comprehensive Cash Flow Analysis: Learn about direct and indirect methods, CFO, CFI and CFF. Engage in practical exercises to calculate various cash flow items
Corporate Valuations: Delve into dividend discount models, income statement forecasting, and enterprise value calculation.
Develop expertise in sensitivity analysis, options, and cost of debt and equity.
Hands-on Financial Modeling: Apply acquired skills to model Apple Inc., covering revenue forecasting, cost sheet calculations, cash flow projections, and DCF
Conclude with sensitivity analysis, growth rate considerations, and exit options.
Through a structured approach and real-world examples, it provides a comprehensive journey from fundamental concepts to advanced techniques in fin modeling
Loading charts...
5271968
udemy ID
14/04/2023
course created date
17/04/2023
course indexed date
Bot
course submited by