100%

Home
Core Skills: On-Line Certification
Advanced Level
Expert Level
About
Your Profile
- Quiz Reports

Login

Home
Core Skills: On-Line Certification
Advanced Level
Expert Level
About
Your Profile

Essentials of Modelling with Excel
Economic Modelling: Criteria, Calculations, and Functions
Data Analysis and Statistics
Model Planning, Design and Best Practices

Data Manipulation with Advanced Excel
Using PowerQuery
Financial Statements and Ratio Analysis
Valuation in Corporate Finance

Automation and Algorithms with VBA and Macros
Risk, Simulation and Optimisation using Excel/VBA
Introduction to Quantitative Finance
Using PowerPivot
Advanced Data and Statistical Analysis

Benefits of the CertFM Program
Course Director
Books by Dr. Michael Rees
Blog
FAQ
Privacy Policy
Live Chat and Support
Contact Us

Home Course Core Skills: Economic Modelling

Core Skills: Economic Modelling

8 Chapters

1 Student

Free

Login to Enroll

Free

Login to Enroll

Course Details

Core Skills: Economic Modelling

8 Chapters

6 Quizzes

1 Student

Current Status

Not Enrolled

Price

Free

Get Started

Login to Enroll

Course Content

Expand All

Paybacks, Scenarios and Lookup Functions

1 Chapter 1: Calculating Payback Periods

5 Topics

Expand

Chapter Content

0% Complete 0/5 Steps

1.1 Introduction

1.2 Payback Periods and Variations

1.3 Measuring payback using the MATCH Function

1.4 The XMATCH Function

1.5 Dealing with Errors, and Other Comments

2 Chapter 2: Scenario Modelling

8 Topics | 1 Quiz

Expand

Chapter Content

0% Complete 0/8 Steps

2.1 Introduction

2.2 CHOOSE and SWITCH

2.3 Running Scenarios

2.4 Using Data Validation

2.5 The INDEX Function

2.6 INDEX-MATCH and XLOOKUP

2.7 (Avoiding) HLOOKUP and VLOOKUP

2.8 Other Lookup Functions

Quiz 1.3.0 Paybacks, Lookups and Scenarios

Measuring and Calculating Growth

3 Chapter 3: Growth Measurement and Calculations

5 Topics | 1 Quiz

Expand

Chapter Content

0% Complete 0/5 Steps

3.1 Measuring Growth

3.2 Growth Compounding

3.3 Average Growth Rates

3.4 Deriving Rates for Shorter Periods and Bootstrapping

3.5 Inflation, Nominal and Real Terms Values

Quiz 1.3.1 Growth Measurements and Calculations

Interest Rates, Compounding, Discounting and Annuities

4 Chapter 4: Interest Rates and Compounding

6 Topics

Expand

Chapter Content

0% Complete 0/6 Steps

4.1 Introduction to the Time Value of Money and Interest Rates

4.2 Bootstrapping and Yield Curves

4.3 Types of Interest Compounding

4.4 Conversions Between Stated Rates and Effective Rates

4.5 Conversions between Annual and Periodic Rates

4.6 Total Payout Rates and Required Periodic Rates

5 Chapter 5: Discounting, Present Values and Annuities

3 Topics | 1 Quiz

Expand

Chapter Content

0% Complete 0/3 Steps

5.1 Net Present Value and NPV

5.2 Discounting

5.3 Annuities: The Present Value of Growing Cash Flows

Quiz 1.3.2 Interest Rates, Discounting and Annuities

Returns and Net Present Values

6 Chapter 6: The Internal Rate of Return

6 Topics | 1 Quiz

Expand

Chapter Content

0% Complete 0/6 Steps

6.1 Introduction to Measuring and Calculating Returns

6.2 The Internal Rate of Return

6.3 Using the IRR in Decision-Making

6.4 Limitations and Restrictions

6.5 Example: Multiple Changes of Sign

6.6 Example: Shifting of Cash Flows in Time

Quiz 1.3.3 Internal Rate of Return

7 Chapter 7: Comparison of NPV with IRR as Economic Measures

3 Topics | 1 Quiz

Expand

Chapter Content

0% Complete 0/3 Steps

7.1 Introduction

7.2 Commonalities

7.3 Differences

Quiz 1.3.4 NPV-IRR Comparison

Loans and Mortgages

8 Chapter 8: Loan and Mortgage Repayments

6 Topics | 1 Quiz

Expand

Chapter Content

0% Complete 0/6 Steps

8.1 Introduction

8.2 The Functions PMT, RATE, NPER, FV and PV

8.3 Functions for Splitting and Cumulating

8.4 Assumptions About Interest Rates and Compounding

8.5 Errors Sources and Solutions

8.6 Use of GoalSeek

Quiz 1.3.5 Loan and Mortgage Functions

Copyright 2021 - All Rights Reserved

error: Alert: Content is protected !!