966-566111404
Financial Analysis By Using Excel
0
2025
Last updated December 2025
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.
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.
Course Curriculum
4 Lectures
- 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.
- 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.
- 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.
- 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.
Instructor
0
Rating
Reviews
0
trainees
0
Courses
Trainees Feedback
Reviews