دوره تحلیل داده‌

1. Introduction to Finance (30 minutes)
2. Introduction to Excel (150 minutes)

• • Graphs and Charts in Excel
  • Excel Functions
  • Using Data Tables
  • Using Goal Seek and Solver

۱. The Time Value of Money 

• Future Value
• Present Value

۲. Measures for Evaluation of Investment Opportunities 

• Net Present Value (NPV)
• The Internal Rate of Return (IRR)
• NPV vs. IRR
• Problems with IRR
• Choosing Between Project with Different Life Spans

۳. Loans and Amortization Tables

• Amortization Table
• An Interest-Only Loan
• An Equal Amortization Term Loan
• An Equal Payment Term Loan (mortgage)
• The Market Value vs. the Contractual Value of a LoanCostly Refinancing

۱.Effective Interest Rates 

• Calculating the Cost of Mortgage
• Mortgages with Monthly Payments
• Effective Annual Interest Rate (EAIR)
• Continuous Compounding and Discounting

۲. Capital Budgeting: Valuing Business CashFlows 

• Salvage Values
• Accelerated Depreciation

۳.What is Risk? 

• The Risk Characteristics of Financial Assets
• Using Continuously Compounded Returns to Compete Annualized Return

• Statistics for Portfolios 

  • Basic Statistics for Asset Returns
  • Covariance and Correlation
  • Portfolio Mean and Variance for a Two-Asset Portfolio
  • Using Regressions
  • Portfolio Statistics for Multiple Assets

• ۲.Portfolio Diversification and Risk

  • Doing Regressions in Excel
  • Portfolio alpha, beta and R-squared

۱. Efficient Markets – Some General Principles

• Competitive Markets Have a Single Price for a Single Good
• Transaction Cost are Important

۲. Financial Analysis & Decision-making

•  KPI for Financial Purposes
• Cash Flow Estimation
• Performance Measurement & SWOT Analysis
•  Transferring information to Non-Financial Persons (General
  Managers)
•  Allocation of Resources / Budgeting