Financial Modeling Level 1

Financial Modeling Level 1

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

• The course requires laptop or desktop with Microsoft Window 2007, 2010, 2013 and above.

Target group

1. Business Students and Teachers at all levels worldwide

2. Business Graduates looking for employment worldwide

3. Bankers and Insurance Brokers

4. Chief Finance Officers

5. Finance Directors

6. Finance Managers and Officers

Course Tutor

ISAAC ALORMENU – MBA (International Finance) Brandeis University, USA - 2009

Basic Statistics in Finance, Time Value of Money, Credit & Value at Risk Analysis, Resource Allocation with LP Solver

Url: View Details

What you will learn

• Computer-Based Financial Modeling

Rating: 0

Level: All Levels

Duration: 5 hours

Instructor: Isaac Alormenu