100%
Dark site-logo
  • Home
  • Core Program: Level I
    • What is Financial Modelling?
    • Essentials of Excel for Modelling
    • Calculations for Economic Modelling
  • Core Program: Level II
    • Introduction to Data Analysis and Statistics
    • Introduction to Automation with Macros
    • Model Planning, Design and Best Practices
  • Finance Specialisms
    • Financial Statements and Ratio Analysis
    • Valuation in Corporate Finance
    • Risk, Simulation and Optimisation using Excel/VBA
    • Risk Assessment and Modelling with @RISK
    • Introduction to Quantitative Finance
  • Data Specialisms
    • Data Manipulation with Advanced Excel and VBA
    • Using PowerQuery
    • Using PowerPivot
    • Advanced Data Analysis
  • About
    • Benefits of the CertFM Program
    • Course Director
    • Books by Dr. Michael Rees
    • Blog
    • FAQ
    • Privacy Policy
    • Contact Us
    • Live Chat and Support
  • 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

Instructor Image Michael Rees
6 Chapters
1 Student
Free
Login to Enroll
Free
Login to Enroll
Course Details

1.3. Core Calculations for Economic Modelling

Instructor Image Michael Rees
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
Discounting
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
Introduction
Commonalities
Differences
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
Introduction
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