MS Excel Applied to Financial Analysis
Free access to CISCO courses with international certification.
Hours36 hrs. (24 synchronous hours and 12 asynchronous hours)
Duration4 weeks
Modality 100% online
This course is designed for participants to perfect the use of Ms Excel as a strategic tool for financial analysis, projection and business decision making. Through applied exercises, the participant will learn to read financial statements, project flows, calculate investment profitability, analyze amortizations, value bonds, and simulate business scenarios. All under a realistic, business and applicable approach from day one.
Aimed at:
Professionals and students of administration, accounting, economics, industrial engineering and related careers; as well as businessmen, entrepreneurs, financial analysts and business advisors to strengthen their skills in applied financial analysis with Microsoft Excel.
Thematic Content
Finance for non-financiers in Excel
Peruvian Financial System and business vision
Cash Flow Diagram with practical examples
Simple interest calculation applied to businesses
Compound interest and value of money over time
Future and current value of decisions
Effective and nominal rate conversions
Real cases of loans and returns
Business annuities and income
Present value of invoices, promissory notes or bills
Commercial and financial discount
Discounting as a business strategy
Present value of invoices, promissory notes or bills
Commercial and financial discount
Loan repayment methods
French, German, American and increasing quotas
Depreciation in companies and tax effects
Straight, accelerated line and double decreasing balance
Accounting and tax impact on results
Bonds as investment or financing tools
Types of bonds, valuation in Excel
Decision simulation with advanced Excel
Search target, data tables, Solver
Scenario manager in management decisions
Evaluation of investment projects
NPV, IRR, RBC, IVAN: when to invest and when not
Difference between economic and financial evaluation
Analysis of projected financial statements
Benefits
Access to recording classes for reinforcement
Access to digitized material 24/7
_20260304150350.svg)
Free CISCO self-study courses with international certification
Project-based learning (PBL)
Development of a project applied to the participant's work environment, which consolidates the knowledge acquired during the course.
Instructor profile
- Internationally certified instructors.
- Academic experience.
Certification
Certificate of Approval issued by the César Vallejo University (digital format).
Modality:
Virtual classes 100% live
ATTRIBUTES
