Financial Mathematics using EXCEL

Course Content

This training aims to make the participants understand the importance of risk and return and their importance in financial markets .

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 and Cost of Equity	Basic Financial Ratios & Basic Statistics in EXCEL	Pre payment Option incorporation & Multiple prepayments	Case Study with Questions

Classroom/Online Classes(WebEX).
Training driven through Case Studies (A listed company).
Training conducted by IIM Alumnus
After Classes SUPPORT for 1 YEAR.
Hands On Coaching- Participants may get their laptops for the training to perform along with the trainer.
Support via Email/Phone/Chat/One on One session (with prior appointment).
Complete Recording of the complete Training in Downloadable Format.
Attending training again for NO COST.
Training Completion Certificate for all participants.
Online Trainings will be Live through WebEX - Downloadable Format.

For Faculty Profile Click Here

For registrations Click Here

Batch Start Date	Batch End Date	Timings	Fee
3-May-2012 (Weekday)	4-May-2012 (Weekday)	9AM to 5PM	Rs. 3,000

10% discount for a group of 3 or more

15% discount for a group of 5 or more

P.A.C.E - Recorded Training available for Rs. 1,500. Fee Adjustment for Participants willing upgrade Classroom/Online Training.

SUPPORT FOR RECORDED DVD'S:

Support via Email/Phone/Chat/One on One session for 1 hour (with prior appointment).

Updated recordings of the training in downloadable format for 1 year at no extra cost.

Skill based trainings