وب سایت تخصصی شرکت فرین
دسته بندی دوره ها

Financial Modeling in Excel (Concepts and Application)

سرفصل های دوره

Mastering Financial Modeling in Excel: Build, Analyze, and Optimize - Learn concepts and Application of concepts


1 - Introduction
  • 1 -Introduction
  • 2 -What is Financial Modeling
  • 3 -Introduction to Excel
  • 4 -Pre-requisites in Excel

  • 2 - Excel Functions and Formulas
  • 1 -Basic Excel Formulas
  • 1 -DataSheet 1 for Excel Functions and Formulas.xlsx
  • 2 -Cell Referencing
  • 3 -Basic Formatting in Excel
  • 4 -Cell Formatting in Excel
  • 5 -Date related formulas in excel
  • 6 -Conditional Formatting
  • 7 -Pivot Table
  • 8 -Vlookup, Hlookup, Concatenate and Transpose
  • 9 -Data Validation in Excel
  • 10 -Protect Sheet Protect Workbook Protect Cell

  • 3 - Advance Excel functions and Formulas
  • 1 -Datasheet 2 for advanced excel functions and formulas.xlsx
  • 1 -Name Manager
  • 2 -Goal Seek
  • 3 -Scenario Manager
  • 4 -Data Tables

  • 4 - Financial Statements and Historical Data Plotting
  • 1 -Datasheet 3 From Historical Plotting to Forecasting.xlsx
  • 1 -Financial Statements
  • 2 -Historical Data Plotting
  • 3 -Historical Data Plotting Version 2

  • 5 - Ratio Analysis (Concept)
  • 1 -Ratio Analysis (Introduction)
  • 2 -Liquidity Ratios
  • 3 -Liquidity Ratios - Current Ratio
  • 4 -Liquidity Ratios - Quick Ratio
  • 5 -Liquidity Ratios - Cash Ratio
  • 6 -Liquidity Ratios - Interval Measure Ratio
  • 7 -Liquidity Ratio - Net working Capital Ratio
  • 8 -Solved Illustrations for Liquidity Ratios
  • 9 -Leverage Ratios - Introduction
  • 10 -Leverage Ratio - Equity Ratio
  • 11 -Leverage Ratio - Debt Ratio
  • 12 -Leverage Ratio - Debt to Equity
  • 13 -Leverage Ratio- Debt to Total Assets Ratio
  • 14 -Leverage Ratio - Proprietary Ratio
  • 15 -Leverage Ratio - Capital Gearing Ratio
  • 16 -Leverage Ratios - Debt Service coverage ratio
  • 17 -Leverage Ratios - Interest Coverage Ratios
  • 18 -Leverage Ratios - Fixed Charges coverage ratio
  • 19 -Leverage ratios - Dividend Coverage ratios
  • 20 -Solved Illustration on Leverage ratios - Capital Structure Ratios
  • 21 -Solved Illustration on Leverage ratios - Coverage Ratios
  • 22 -Activity Ratio Introduction
  • 23 -Activity Ratio - Total assets turnover ratio
  • 24 -Activity Ratio - Fixed assets turnover ratio
  • 25 -Activity Ratio - Net Assets turnover Ratio
  • 26 -Activity Ratio - Current Assets turnover ratio
  • 27 -Activity Ratio - Working Capital turnover ratio
  • 28 -Activity Ratio - Inventory turnover ratio
  • 29 -Activity Ratio - Receivables turnover ratio
  • 30 -Activity Ratio - Payables turnover ratio
  • 31 -Solved Illustration - Activity Ratios
  • 32 -Profitability ratios introduction
  • 33 -Profitability ratios - Gross profit Ratio
  • 34 -Profitability Ratios - Net Profit Ratio
  • 35 -Profitability Ratios - Operating Profit Ratio
  • 36 -Profitability Ratios - Expense Ratio
  • 37 -Profitability Ratio - Return on Investment
  • 38 -Profitability Ratio - Return on Asset
  • 39 -Profitability Ratio - Return on Capital Employed
  • 40 -Profitability Ratio - Return on Equity
  • 41 -Profitability Ratios - Dupont Analysis
  • 42 -Profitability Ratio - EPS Ratio
  • 43 -Profitability Ratios - DPS
  • 44 -Profitability Ratios - Dividend Payout Ratio
  • 45 -Profitability Ratio - Price Earning Ratio
  • 46 -Profitability Ratio - Dividend and Earning Yield ratio
  • 47 -Profitability Ratio - Market value by book value
  • 48 -Q Ratio
  • 49 -Solved Illustration - Profitability Ratios

  • 6 - Ratio Analysis (In Excel) - Application of Concepts
  • 1 -Ratio Analysis in Excel (Part 1)
  • 2 -Ratio Analysis in Excel (Part 2)
  • 3 -Ratio Analysis in Excel (Part 3)
  • 4 -Dupont Analysis in Excel (Part 1)
  • 5 -Dupont Analysis in Excel (Part 2)
  • 6 -Altmans Z Score Concept
  • 7 -Almans Z Score Calculation in Excel
  • 8 -Common Size Statement in Excel

  • 7 - Time Value of Money (Concepts)
  • 1 -What is time value of Money
  • 2 -Use of Concept - Time value of money
  • 3 -Time Value of Money - Relationship between Inflation and Purchasing power
  • 4 -Simple Interest and Compound Interest
  • 5 -Present Value and Future Value
  • 6 -Present Value and Future value (for single payments) without Formula
  • 7 -Present Value and Future value (for single payments) with Formula
  • 8 -What is discount factor
  • 9 -What is annuity
  • 10 -Present value of Annuity without Formula
  • 11 -Present value of Annuity with Formula
  • 12 -Present Value of Ordinary annuity using Formula
  • 13 -Present Value of Annuity due using formula
  • 14 -Future Value of Annuity without Formula
  • 15 -Formula for future value of annuity
  • 16 -Future value of annuity calculation using formula
  • 17 -Single payment compounded annually, Semi Annually, Quarterly, Monthly and daily
  • 18 -Annuity compounded annually, Semi Annually, Quarterly, Monthly and daily
  • 19 -Annuity Factor
  • 20 -Internal Rate of Return (IRR)

  • 8 - Capital Budgeting - Concepts
  • 1 -Capital Budgeting basics
  • 2 -Purpose of Capital Budgeting
  • 3 -Process of Capital Budgeting
  • 4 -Types of Capital Investment decisions
  • 5 -Replacement and Modernisation decisions
  • 6 -Expansion decisions
  • 7 -Diversification decisions
  • 8 -Mutually exclusive decisions
  • 9 -Accept or Reject decision
  • 10 -Contingent decisions
  • 11 -Accounting Profit and Cashflow
  • 12 -Incremental Cashflows
  • 13 -Depreciation and Tax Benefit
  • 14 -Opportunity Cost
  • 15 -Sunk Cost
  • 16 -Working Capital Cost
  • 17 -Allocated Overheads cost
  • 18 -Types of Cashflows for new project
  • 19 -Types of Cashflow for replacement project
  • 20 -Basic Principles for calculating cashflows
  • 21 -Block of assets and depreciation concepts
  • 22 -Financing costs treatment
  • 23 -Interest and Depreciation
  • 24 -Post Tax Principle
  • 25 -Capital Budgeting techniques
  • 26 -Payback period introduction
  • 27 -Payback period when cashflow is same
  • 28 -Payback period when cashflow is not same
  • 29 -Advantages and disadvantages of payback method
  • 30 -Payback reciprocal
  • 31 -Accounting Rate of return
  • 32 -Accounting rate of return - Solved example
  • 33 -Advantages and disadvantages of Accounting rate of return
  • 34 -How to determine discount rate
  • 35 -Discounted payback period
  • 36 -Discounted payback period illustration
  • 37 -Advantages and disadvantages of discounted payback period
  • 38 -Profitability Index
  • 39 -Solved illustration - Profitability index
  • 40 -Profitability index - advantages and disadvantages
  • 41 -Net Present value method
  • 42 -Net Present value (Example)
  • 43 -Advantages and disadvantages of Net Present Value method
  • 44 -Internal Rate of Return
  • 45 -Reading Present value annuity factor table
  • 46 -IRR using present value annuity factor table
  • 47 -Solved illustrations on IRR (When cashflows are uniform)
  • 48 -Solved illustrations on IRR (When cashflows are not uniform)
  • 49 -8
  • 49 -IRR and NPV (Reinvestment assumption)
  • 50 -IRR and NPV (Mutually Exclusive projects ) - Illustration 1
  • 51 -IRR and NPV (Mutually Exclusive projects ) - Illustration 2
  • 52 -IRR and NPV (Mutually Exclusive projects ) - Illustration 3
  • 53 -Advantages and Limitations of IRR method
  • 54 -Multiple IRR
  • 55 -Modified internal rate of return
  • 56 -Modified internal rate of return - solved illustration (How to calculate it)
  • 57 -Capital rationing - Divisible and non divisible projects
  • 58 -Methods to analyze mutually exclusive projects
  • 59 -Replacement chain method
  • 60 -Equivalent annualized criterion method

  • 9 - Time Value of Money and Capital Budgeting (In Excel) - Application
  • 1 -Basic formulas for Time Value of Money in excel
  • 2 -Loan amortization schedule in excel
  • 3 -Project evaluation by NPV Method in Excel
  • 4 -Project evaluation by IRR method in excel

  • 10 - Forecasting in Excel
  • 1 -Introduction - Revenue and expense forecasting
  • 2 -Revenue and expense forecasting using arithmetic mean
  • 3 -Revenue and expense forecasting using geometric mean
  • 4 -Revenue and expense forecasting moving average
  • 5 -Basics of Regression
  • 6 -Revenue and expense forecasting using regression
  • 7 -Calculating regression in excel
  • 8 -Balance sheet Forecast basics
  • 9 -Balance sheet Forecasting in Excel
  • 139,000 تومان
    بیش از یک محصول به صورت دانلودی میخواهید؟ محصول را به سبد خرید اضافه کنید.
    افزودن به سبد خرید
    خرید دانلودی فوری

    در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

    ایمیل شما:
    تولید کننده:
    مدرس:
    شناسه: 43705
    حجم: 12221 مگابایت
    مدت زمان: 1561 دقیقه
    تاریخ انتشار: ۸ اسفند ۱۴۰۳
    دسته بندی محصول
    طراحی سایت و خدمات سئو

    139,000 تومان
    افزودن به سبد خرید