Financial Analysis Modeling and Forecasting

Financial experts are frequently called to provide financial analyses and estimates to aid management in making choices. You will be able to create financial analysis models, comprehend and evaluate the time value of money, and create predicted financial statements if you take this course.

 

At the end of this course, participant will be able to:

 

  • To interpret corporate financial performance and position, use financial ratio analysis.
  • Calculate the cash flow statement's financial ratios.
  • Calculate the time value of money using Microsoft Excel.
  • Utilize the spinner, list box, option button, and other modeling tools and functionalities in MS Excel.
  • Create models and forecasts for the three primary financial statements.

 

  • Financial controllers
  • Analysts
  • Finance
  • Accounting managers
  •  Supervisors, and finance professionals who need to interpret and analyze financial statements and use them to create financial forecast models in their organizations.

 

  • Vertical analysis and strategy
  • Horizontal, trend analysis, and growth
  • Liquidity analysis: Current, quick, and cash ratios, defensive interval, and cash conversion cycle
  • Asset management and activity ratios:
  • Total and fixed assets turnover
  • Solvency analysis: Debt, equity, and times interest earned ratios
  • Profitability analysis: Profit margin, gross margin, return on assets, return on equity, EBITDA
  • Market and valuation: Price earnings and earnings-per-share ratios
  • DuPont analysis: The three-step and five-step models
  • Limitation of ratio analysis

 

  • Time value of money:
  • Present Value (PV) and Net Present Value (NPV)
  • Internal Rate of Return (IRR) and Multiple IRR (MIRR)
  • Using XNPV and XIRR
  • Effective yields and returns

 

  • Cash flow categories: Operating, investing, and financing
  • Cash flow pattern; the cash cow
  • Cash-flow-related ratios:
  • Quality of earnings
  • Financial management
  • Mandatory cash flow
  • Discretionary cash flow

 

  • Data tables
  • Goal seek
  • Spinner data modeling
  • List box data modeling
  • Option box data modeling

  • Micro and macro factors
  • Forecasting sales
  • Estimating market demand
  • Estimating company demand
  • Developing sales forecast
  • Forecasting cost of sales
  • Forecasting operating expenses
  • Forecasting key assets and liabilities accounts
  • Modeling the income statement
  • Modeling the balance sheet
  • Modeling the cash flow statement

 

Related Courses