Systematic Finance

Systematic Finance - financial modelling services, financial training, financial model audit and review, financial modelling books

Mastering Financial Mathematics in Excel

Mastering Financial Mathematics provides a handbook of how to apply financial mathematics to Excel as an alternative to using financial calculators such as the HP12C.

The tools enabling managers to carry out financial calculations have evolved in the last 30 years from tables through financial calculators to programs on PCs and smart phones. Today, the majority of finance executives have Microsoft Excel on their desks and often on their laptops, tablets and smart phones.

Content

Mastering Financial Mathematics in Microsoft Excel provides a comprehensive set of tools and methods to apply Excel to solving mathematical problems. The book clearly explains the basic calculations for mathematical finance backed up with simple templates, together with numerous examples and exercises.

Each chapter in the book:

  • Allows you to work step-by-step through each of the chapters and examples
  • Shows the use of formulas using straightforward Excel templates
  • Introduces examples and exercises for extension work
  • Provides a menu of basic templates for further development
  • Enables you to practise, develop and improve your competence with Excel

Mastering Financial Mathematics in Microsoft Excel  will be invaluable in helping you improve your Excel skills and understand the underlying financial concepts.

Systematic financial modelling books cover everything from basic Excel techniques to advanced mathematics, risk and cash flow modelling

Calculations

The early chapters start from future and present values and build financial calculators before moving on to more complex techniques