Financial mathematics on Excel (C2020)

Inter-company training

Who is the training for?

Anyone wishing to be initiated on solving financial problems.

Duration

30,00 hours(s)

Language(s) of service

EN

Prerequisites

Successful completion of the module "MS-Excel essentials" (C1320) or proof of equivalent certified knowledge.

Goals

  • Understand Algebra basis functions for Financial Mathematics: power, logarithm, time series, functions, etc.
  • Understand how to write a mathematical formula, build a table with values, round numbers and plot a function with Excel.
  • Understand how to apply simple and compounded interest rates as well as discount factor rates.
  • Understand the difference between the equivalent interest rate and the proportional ones with respect to the duration.
  • Understand how to compute the yearly and monthly amount of a household credit and/or mortgage, the net present value and the internal rate of return concepts.
  • Understand how to apply main financial function of Excel.
  • Understand how to use Excel to solve financial problems.

Contents

  • Introduction to Excel: Simple table, different notations, Excel operators, some Excel functions.
  • Algebra functions: power, polynomes, equations. Exercises + Graphics on Excel.
  • Algebra functions: Logarithm and Exponential. Exercises + Rounding on Excel.
  • Arithmetical and Geometrical series + Exercises.
  • Simple interest rates, compounded interest rates, present value, future value, annuity + Exercises.
  • Simple interest rates, compounded interest rates, present value, future value, annuity + Exercises.
  • Annuity at the end of period: case of saving or payment. Real cases: Montly payment of a household credit, montly payment of a household mortgage.
  • Installment Sales: Choice between price reduction or interest rate reduction: Exercises.
  • Internal rate of return on Investments + Exercises.
  • Recap of the courses + exercises.

These courses might interest you