100%

Home
Core Program: Level I
Core Program: Level II
Finance Specialisms
Data Specialisms
About
Your Profile
- Quiz Reports

Login

Home
Core Program
Finance Specialism
Data Specialism
About
Your Profile

What is Financial Modelling?
Essentials of Excel for Modelling
Calculations for Economic Modelling
Introduction to Data Analysis and Statistics
Automation and Algorithms with VBA and Macros
Model Planning, Design and Best Practices

Financial Statements and Ratio Analysis
Valuation in Corporate Finance
Risk, Monte Carlo Simulation and Optimisation
Risk Assessment and Modelling with @RISK
Introduction to Quantitative Finance

Data Manipulation with Advanced Excel and VBA
Using PowerQuery
Using PowerPivot
Advanced Data 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 1.3. Core Calculations for Economic Modelling

1.3. Core Calculations for Economic Modelling

6 Chapters

1 Student

Free

Login to Enroll

Free

Login to Enroll

Course Details

1.3. Core Calculations for Economic Modelling

6 Chapters

5 Quizzes

1 Student

Current Status

Not Enrolled

Price

Free

Get Started

Login to Enroll

Course Content

Expand All

Measuring and Calculating Growth

1 Chapter 1: Growth Measurement and Calculations

6 Topics | 1 Quiz

Expand

Chapter Content

0% Complete 0/6 Steps

Introduction to Functions Covered in This Course

Measuring Growth

Growth Compounding

Average Growth Rates

Deriving Rates for Shorter Periods and Bootstrapping

Inflation, Nominal and Real Terms Values

Quiz 1.3.1 Growth Measurements and Calculations

Interest Rates, Compounding, Discounting and Annuities

2 Chapter 2: Interest Rates and Compounding

6 Topics

Expand

Chapter Content

0% Complete 0/6 Steps

Introduction to the Time Value of Money and Interest Rates

Bootstrapping and Yield Curves

Types of Interest Compounding

Conversions Between Stated Rates and Effective Rates

Conversions between Annual and Periodic Rates

Total Payout Rates and Required Periodic Rates

3 Chapter 3: Discounting, Present Values and Annuities

3 Topics | 1 Quiz

Expand

Chapter Content

0% Complete 0/3 Steps

Net Present Value and NPV

Annuities: The Present Value of Growing Cash Flows

Quiz 1.3.2 Interest Rates, Discounting and Annuities

Returns and Net Present Values

4 Chapter 4: The Internal Rate of Return

6 Topics | 1 Quiz

Expand

Chapter Content

0% Complete 0/6 Steps

Introduction to Measuring and Calculating Returns

The Internal Rate of Return

Using the IRR in Decision-Making

Limitations and Restrictions

Example: Multiple Changes of Sign

Examples: Shifting of Cash Flows in Time

Quiz 1.3.3 Internal Rate of Return

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

3 Topics | 1 Quiz

Expand

Chapter Content

0% Complete 0/3 Steps

Quiz 1.3.4 NPV-IRR Comparison

Loans and Mortgages

6 Chapter 6: Loan and Mortgage Repayments

6 Topics | 1 Quiz

Expand

Chapter Content

0% Complete 0/6 Steps

The Functions PMT, RATE, NPER, FV and PV

Functions for Splitting and Cumulating

Assumptions About Interest Rates and Compounding

Errors Sources and Solutions

Use of GoalSeek

Quiz 1.3.5 Loan and Mortgage Functions

Copyright 2021 - All Rights Reserved