An accurate financial analysis is the fundamental element for company’s growth, strategy, and overall success. In this hands-on comprehensive course, you will learn to use proven analytical tools to analyse financial indicators, evaluate management performance, and allocate resources effectively to improve your company’s profit. Key Modules Covered in the Course Model Analysis Tools - Build assumptions documentation tools.- Show multiple scenario outcomes simultaneously with one and two-dimensional data tables- Automatically highlight selected scenarios using complex conditional formatting- Learn to use the Scenario Manager- Learn to build manual scenario- Learn to protect your model Building a Business Case - Build business case scenarios- Business case study-financial calculations- Business case study-scenario analysis How to Measure Management Performance - Build DuPont analysis model- Evaluate profit margins, asset turnover (efficiency) and leverage- Evaluate past performance and project future outcomes- Prepare benchmark analysis for company performance- Trend analysis case: YTY (year to year) growth model- Prepare horizontal and vertical analysis- Prepare actual vs. budget variance analysis- Prepare per unit analysis for payroll cost How to Use Cash Flow Analysis - Understand cash flow from operations, investing and financing- Prepare ratios and metrics for cash flow analysis- Identify patterns of value- Understand cash flow performance indicators—profitability, liquidity, and solvency How to Interpret and Evaluate Financial Information - Revise the contents of the financial statements to suit for management reporting purpose- Prepare common-sized financial statement analysis- Prepare comparative financial statement analysis- Prepare weight analysis for OPEX- Learn managing capital model- Learn breakeven analysis model过往学员反馈：
