معهد الدراسات المصرفية

المملكة الأردنية الهاشمية

Financial Analysis Using MS Excel


المحاضر تاريخ البداية تاريخ النهاية توقيت البداية توقيت النهاية مكان الانعقاد عدد الساعات سجّل الآن
د. محمد ابراهيم تايه
2019-12-02 2019-12-05 16:30 20:00 عمان 14

(Objectives / الأهداف)

:

By the end of this training course, participants will be able to:

 - Use MS Excel functions and improving their ability in building their own equations more creatively, which then, allow them to create a financial model that is easy and less time and effort consuming in applying the financial analysis process.


(Contents / المحتويات)

:

- Introduction to MS Excel:

      - What is Excel?

      - Parts of the Excel screen.

      - Tabs and bars in Excel.

      -  Navigating the worksheet:

            - Cells options, formatting options.

            - Formulas, build in functions.

            - Creating graphics.

 - Build-in functions:

- Math functions, logical functions, statistical functions.

 - Financial statements modeling:

- Building the income statement .

- Building a balance sheet .

- Common-size financial statements.

- Modeling the analysis of financial statements:

- Liquidity ratios.

- Efficiency ratios.

- Leverage ratios.

- Coverage ratios.

- Profitability ratios.

- Financial distress prediction.

- Trend analysis.

- Building a statement of cash flow.

  - Financial forecasting modeling (Extra Topic).

- The percent of sale method.

- Forecasting the income statement.

- Forecasting the balance sheet.

- Measuring the free cash flow produced by the business.

- Using the free cash flow to value the firm and its equity.



(Participants / المشاركون)

:

- New, fresh employees in all banking and financial institutions with a basic Excel knowledge.