Receive a Course Pre-Quote by Email
Let a Sales Advisor Contact You by Email
Temarios Cursos- Inglés
Receive complete information in your email!
OBJECTIVE:
Numeral analysis , planning and organizating, performance orientation.
BASIC COURSE INFORMATION:
ADDRESSED TO:
Accountants, comptroller, managers, financial area, financial and accounting personnel prepared for this level.
AGENDA
I. Introduction to Present Value, Annual Equivalent value, Internal Rate of Return, and Recovery Period concepts.
II. Financial statements analysis in calculation sheet with vertical and horizontal analysis.
III. Excel interface overview and some basic formulas.
IV. Difference between the use of Excel and to apply financial formula in a manual mode.
V. Depreciation, Loans, Investments, Bonds, and Index functions.
VI. Financial functions application in practical excersises like: single interest rate, compunded interest rate, effective interest, period number, payment, nominal interest rate, internal rate of return, actual value, future value.
VII. Practical excerises application for time value of money.
VIII. Amortization tables in calculation sheet excersises.
IX. Menu of audit formulas, file protection, and calculation sheet.
X. Analysis menu and SI
XI. Control use in information provision.
BENEFITS
- Will know financial functions bases.
- Will be capable of creating financial contexts and solve them using the Excel tool.
- Will understand and apply the main techniques of financial area by using the calculation sheet.
