FINANCIAL CALCULATIONS/MATHEMATICS using MS EXCEL

Basic Finance Calculations using MS EXCEL

Theme

Key Topics

Basics

Compounding, Frequency, Discounting, Multiple cash flows, Number of compounding periods

Basic Valuations

Stream of future cash flows, Perpetuity, Annualized interest rates, Yield

Applications

Loans amortization, Variations, Deferred Annuity, Annuities with Annuities, YTM of Bonds, Yield Curves, Stock returns and basic valuation of stocks

Evaluating Capital Investments

Net Present Value, Profitability Index, Internal rate of return

Using EXCEL Functions

PV, FV, PMT, RATE, NPV, IRR, XNPV, XIRR, NPER, PPMT, IPMT, YIELD, PRICE

Note - Course content and topics to be covered in the training can be customized as per requirement for Corporates.

Faculty profile

FEES for Corporates

Based on the syllabus, contents and other requirements for the corporate training, scope with detailed inclusions and exclusions along with the fee will be shared. There will be a 14% service tax over and above the training fee.