Saudi Arabia
Egypt
UAE
Canada
Financial Analysis By Using Excel
This course aims to empower participants to apply practical financial modeling in Excel, in addition to explaining fundamental theoretical topics. The course also features real-life case studies and presentations by participants.
Comments (0)
By the end of this course, participants will be able to:
• Apply present value concepts of money.
• Perform and interpret financial analysis.
• Apply cost of capital calculation techniques.
• Build expected financial data models and conduct sensitivity analysis.
• Use the free cash flow method to determine project or company value.
• Develop financial models using various modeling techniques in Excel.
Module 1 - Financial Calculations- Applications
1 Parts
- Present Value of Money:
- Present Value and Net Present Value
- Internal Rate of Return (IRR) and Modified IRR (MIRR)
- Using XNPV and XIRR
- Loan amortization.
- Effective yields.
Module 2 - Financial Analysis for Companies
1 Parts
- Profit and loss versus general budget analysis.
- Comparative company analysis.
- Building component analysis.
- Vertical, horizontal, and trend analysis.
- Liquidity.
- Current, quick, and cash ratios.
- Asset and activity management.
- AR and AP Turnover
- Cash conversion cycle.
- Asset turnover.
- Financial liquidity, leverage, and indebtedness.
- Debt, equity, and earned interest rate ratios.
- Profitability assessment.
- Profit margin, gross margin, return on assets, return on equity.
- Market and valuation.
- Price-to-earnings and earnings per share ratios.
- DuPont Identity Modeling
- Three-step models.
Module 3 - Capital Cost Calculation and Capital Structure
1 Parts
- Gordon Profit Model.
- Supernormal growth.
- Calculating the cost of equity and the cost of debt.
- Expected market return calculation.
- Weighted average cost of capital calculation.
- Financial data modeling.
- How financial models work.
- Income statement modeling.
- General budget modeling.
- Free cash flow measurement (FCF).
- Using FCF to evaluate the company and its equity.
- Sensitivity analysis.
- Discounted cash flow analysis.
- Developing an integrated financial model.
Module 4 - Model Building Techniques
1 Parts
- Designing data tables.
- Assumptions and rules for input variables.
- Functions and array formulas.
- Data Modeling Spinner.
- Data Modeling Combo Box.
- Data retrieval and updating from text, accessing databases, SQL, and the web.
0
0 Reviews