Financial Analysis
Financial Analysis is the key for moving up in your career path if you want to transition from AP, AR, Payroll or AA to FA, MA positions. By analysing the company past performance, you can provide insight to the company’s future forecast, planning and strategic decisions, in our course you will learn the various techniques for analysing financial statements(balance sheet, income statement and cashflow) and build reports/dashboards that is not only eye catching but provide insight for management.
- Different mappings for accounts and how to build a data model that suite management reporting needs
- Horizontal and vertical analysis
- Model for analysis and reporting with YTD, QTD, MTD figures, and Budget V Actual monthly variances
- Department/cost centre level profit and loss reports
- Different ratios and analysis
- Benchmark performance analysis
- Sales Analysis Models
- HR Analysis Models
- Cashflow Statement: use of indirect method to auto generate cashflow statement that reconciles from net income to cash at bank.
- Advanced Sales forecast with linear regression
