Financial Modeling Level 1
Employers around the globe are demanding digital skills especially Financial Modeling skills in the employment process. These changing requirements of the job market have seen the emergence of a gap between the knowledge generated by the traditional learning management system (LMS) and the skills required by employers worldwide.
The need for graduates from high school level to college and university to start jobs with demand driven digital skills is therefore becoming more of a prerequisite for employment all over the world. This course provides them with the insight to uncover a new set of digital skills they need for employment and job security.
This “Financial Modeling Level 1” is a demand driven skill course that shows how to translate Accounting and Finance concepts into computer language to solve complex digital problems. Therefore, the central focus is how to learn Financial Modeling through computer. The objective of this course, “Financial Modeling Level 1”, is to equip every business teacher and student in high school, college and university with demand driven digital skills and prepare them to meet the requirements in the job market.
In furtherance of this objective, Microsoft Excel has been chosen as a tool of teaching and learning of Financial Modeling. Given that Microsoft Excel Spreadsheet is standard software used in commerce and industry across the globe, it is essential to teach teachers, students and finance professionals in their use as an integrated part of their courses.
What you'll learn
Learn how to use computer for Basic Statistics in Finance
Learn how to use computer for case-based Time Value of Money Analysis
Learn how to use computer for Credit and Value at Risk Analysis
Learn how to use computer for Resource Allocation using Linear Programming Solver
The course comprises 4 chapters. Chapter 1 is step by step computer-based approach to Basic Statistics in Finance. Chapter 2 deals with Time Value of Money Analysis. Chapter 3 deals with Credit and Value at Risk Analysis. Chapter 4 covers Resource Allocation using Linear Programming Solver.
Course Content / Title
Chapter 1: Introduction - Basic Statistics in Finance
Lesson 1: How to use keyboard for computer applications
Lesson 2: Probability Distribution in Finance
Lesson 3: Relationship Analysis in Finance
Lesson 4: Forecasting using Regression in Finance
Lesson 5: Hypothesis Testing in Finance
Chapter 2: Time Value of Money Analysis
Lesson 1: Simple Interest Determination
Lesson 2: Compound Interest Determination
Lesson 3: Annuity Payments Analysis
Lesson 4: Mortgage Repayment Analysis
Lesson 5: Retirement Planning
Lesson 6: Loan Repayment Schedule
Chapter 3: Credit and Value at Risk Analysis
Lesson 1: Credit Risk Identification & Analysis
Lesson 2: Value at Risk Analysis
Chapter 4: Resource Allocation using Linear Programming Solver
Lesson 1: Profit Maximization modeling
Lesson 2: Cost Minimization modeling
This Course includes:
5 hours of video tutorials (3 – 6 minutes each)
37 Spreadsheets on Financial Modeling Level 1
Certificate of Completion
Requirements
Target group
Business Students and Teachers at all levels worldwide
Business Graduates looking for employment worldwide
Bankers and Insurance Brokers
Chief Finance Officers
Finance Directors
Finance Managers and Officers
Course Tutor
ISAAC ALORMENU – MBA (International Finance) Brandeis University, USA - 2009
