Bond Analysis and the Basics of Equity Valuation | 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 > Excel-Modelling-for-Financial-Analysis.aspx  

Kaplan Financial - Home > Training and Qualifications > Financial Markets > Excel for Financial Management & Modelling > Bond Analysis and the Basics of Equity Valuation

Bond Analysis and the Basics of Equity Valuation

This course looks at two major areas of financial analysis - Bond Analysis and Equity Valuation - 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.

Bond Analysis and the Basics of Equity Valuation  

Price: £600.00

What’s Included?

  • Bond analysis
    • Valuation, Bond yields, Duration
    • Reinvestment risk and price risk
    • The principle of immunisation
  • Equity valuation techniques, including via Dividends, Free Cash Flow, Residual income, EVA, and Claims valuation
  • Excel techniques and functions to be used include: data validation, data tables, charts, IF(), NPV(), IRR(), OFFSET(), TVM functions, PV(), FV()

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 £445*

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

  020 3468 2122

  Email Us


Key info

Available on these dates:

17th October 2016

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

Study options:
Classroom, using provided laptops

Location:
London
or
In-house by arrangement.

Bond Analysis and the Basics of Equity Valuation