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

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 تومان
    افزودن به سبد خرید