Financial Data Analysis with Excel

วันที่ 1

9.00 – 12.00

• Concept and application of Microsoft Excel in finance
• Financial Modeling an Overview by Microsoft Excel
  • Financial Modeling is transactions and inputs. Including the appropriate values of financial simulation Under variables, quantitative and logical relationships
  • Use Microsoft Excel as a simulation analyzer.
  • Businesses suitable for using financial simulations.
  • Condition of the financial model builder

13.00 - 16.00

• Various functions for use in finance and to make financial models.

• Basic Functions
• Financial Functions
  • ​Net Present Value NPV
  • Internal Rate of Return IRR
  • Future Value FV
• Forecast Function

• Forecast Chart, Forecast and Trend Function

• PivotTable
• What-IF Analysis: Data Table
• What-IF Analysis: Scenario Manager
• Frequently used functions
• Query and reference information functions
• Date and Time Functions
• Math Functions
• Logical Functions
• Array Functions
• SUMPRODUCT

วันที่ 2

9.00 – 12.00

• Cost-Volume-Profit Analysis: CVP.
  • Cost Behaviors: Cost analysis and separation by Excel and the benefits of cost behavior in planning and decision making.
  • Break-even Point Analysis: Excel calculations for single and multiple commodities. Setting the selling price with a break-even point
  • Analysis of risk and surplus for safety (Leverage & Margin of Safety): Analyze the risks and benefits of a business using Excel in the calculation.
• Financial Analysis & Pro forma
  • Concepts and benefits of financial projections. Analyzing historical financial and accounting data with Excel
  • Defining appropriate financial assumptions with Excel.
  • Estimating Financial Statements with Excel
  • Defining appropriate financial assumptions with Excel.
  • Estimating Financial Statements with Excel

13.00 - 16.00

• Capital Budgeting
  • Concepts and benefits of investment analysis. Producing Financial Estimation for Projects Invested with Excel
  • Use of NPV, IRR, Payback Period functions to analyze investment expenditures.
  • Summary of analysis results for presentation to management.

• Sensitivity Analysis
  • Using the Data Table and Scenario Manager tools to test the sensitivity.
  • Break-even analysis sensitivity test.
  • Testing the sensitivity of financial estimates
  • Testing the sensitivity of investment analysis.

วันที่ 3

9.00 – 12.00

• Financial Modeling Best Practices
  • What are the best practices of financial simulation?
  • Errors arising from the financial simulation Is inevitable Due to human error Get involved in the process Source of information.
  • Who is the error checker assigned?
  • Determine the overall environment of best practice.
  • Cases studies of financial models the data loss does not match the truth.
• Planning for your financial modeling
  • Financial Modeling Life Cycle
  • Planning for your Model
  • Assumptions How Realistic Are They
• Security assignments
  • Hiding formulas and not editing cells
  • Providing a password to the file.

13.00 - 16.00

• Case studies of using Microsoft Excel as a tool for financial simulation.
  • The cash flow is the amount of money entering the project.
  • Can calculate the present value of the cash flow for each period.
  • The discount rate is the interest rate an investor wants from a project.
  • Monthly income is considered the cash inflow generated by the project (not profit).
  • Net present value (NPV): Compare today's value to the same amount in the future.