Options Analysis and Regression Analysis | Kaplan Financial
Skip to main content

Excel for Financial Management & Modelling

My Basket | 0 items
Go Search
Training and Qualifications > Financial Markets > Excel for Financial Management & Modelling > Pages > options-analysis-and-regression-analysis.aspx  

Kaplan Financial - Home > Training and Qualifications > Financial Markets > Excel for Financial Management & Modelling > Options Analysis and Regression Analysis

Options Analysis and Regression Analysis

This course looks at two major areas of financial analysis - Options Analysis and Linear Regression Analysis - through the lens of Excel. It links theory and practice in an extremely useful way, and introduces new Excel techniques and functions as practical solutions to computational needs.

This one-day course is suitable for anyone involved in the areas of security and market analysis, particularly those who are moving into such areas and/or are in the process of studying for the CFA examinations.

Options Analysis and Regression Analysis  

Price: £840.00
Price: £840.00

What’s Included?

  • Options analysis, including:
    • Moneyness & payoffs (intrinsic value)
    • Valuation via the Black-Scholes model and put-call parity
    • Charts of option payoffs and profits
  • Simple (2-variable) Regression Analysis
  • Multiple regression, including ANOVA analysis
  • Excel techniques and functions to be used include: goal seek and solver, INTERCEPT(), SLOPE(), COVAR(), CORREL(), FORECAST(), LINEST(), and the regression add-in

Click to see a more detailed course content.

Prerequisite: Candidates on this course should have familiarity with the techniques covered on Introduction to Excel Functionality.

Excel for Financial Management - Save up to £535*

Book more than one course in order to get discounts:

  • Order any two courses, save 5%
  • Order any three courses, save 10%
  • Order any four courses, save 15%
  • Order all five courses and save 20%

If you're interested in other uses for Excel, please check our additional Excel for Financial Management courses:

* T&Cs of discount: Discount will be applied in the basket and the courses must be booked together for the discount to apply. This offer is not applicable with any other offers. Cancellation terms and conditions apply and your discount will be altered in the event of any cancellations.

Items: 0Total: £0.00

  0203 281 7457

  Email Us


Key info

Available on these dates:

29th March 2019
15th October 2019

Course length:
1 day (9am to 5pm)

Study options:
Classroom, using provided laptops

Location:
London
or
In-house by arrangement.

Options Analysis and Regression Analysis