Financial planning skills

Availability: In Stock

Category: Financial & Accounting Training

Description

general goal	An intimate knowledge of the principles of financial analysis and the ability to forecast is one of the basic abilities needed to run companies efficiently. So I designed this virtual course on financial analysis, forecasting and modeling, It uses principles of analysis and the capabilities of Excel to identify the strategic factors that enhance shareholder value from your organization.
subsidiary goals	Preparing estimated income statements according to different economic expectations and assumptions Choosing the optimal distribution of limited resources using linear programming based on the Solver Tool Evaluate long-term investment opportunities using the discounted cash flow (DCF) model
Course themes	Fundamentals of designing models using MS Excel Using data validation tests Building equations using MS Excel and common mistakes when designing equations Using the simple (what-if) IF function and establishing relationships between cells using the multiple (what-if) IF function Use of data management tools Filtering Lists (Auto and Advanced) Designing and preparing pivot tables using building a pivot table from a dynamic range Charting (Standard Charts and Pivot Table Charts) Data protection tools Institutional planning model (shareholders – management – stakeholders). Analyze operating/cash cycle components. The basic components of the company’s financial statements (balance sheet and income statement). Sources of information about the company. goals of financial analysis. How to read the financial position of the company. Analysis of the company’s financial position. Horizontal analysis and vertical analysis.