Microsoft Excel for Finance, Accounting & Financial Analysis

Accounting:

Concept of depreciation and methods of depreciation
Finance:

Concept of Time Value of Money
Present Value and Future Value concept
Conversion from present value to future value, and from future value to present value
Concept of Discount factor and Annuity
Concept and calculation of NPV
Concept of calculation of IRR

Topics Covered:

Calculation of depreciation with Excel formulas
Calculation of PV and FV with Excel formulas
Calculation of NPV with Excel formulas
Calculation of IRR with Excel formulas