Financial Mathematics using EXCEL
We offer Corporate Training in Financial Mathematics using EXCEL this course is directed to make the participants understand the importance of risk and return and their importance in financial markets.
Topics Covered
Financial Mathematics using EXCEL |
||||
Basic Financial Calculations |
Time Value of Money Calculations |
Cash Flow Calculations |
Bond Calculations |
Depreciation Methods |
Advanced Capital Budgeting Formulas (NPV, IRR, XNPV, XIRR) |
Spot rates from Bond Rates calculations |
Loan Schedule - EMI Calculation Methods |
Risk & Return - Total Risk vs Market Risk | CAPM, Alpha Calculations & Portfolio Ratios (Sharpe/Treynor) |
Deriving Cost of Capital from Financial Statements |
Cost of Debt |
Basic Financial Ratios & Basic Statistics in EXCEL | Pre payment Option incorporation & Multiple prepayments |
Case Study with Questions |
training can be customized as per requirement
- After Training SUPPORT for 1 YEAR to the participants.
- Support via Email/Phone/Chat/One on One session (with prior appointment).
For Faculty Profile Click Here