Free Excel Webinar Recording – Financial Functions Part 1

Feedback score 93%

In June 2019 I explained and demonstrated a number of Excel’s  financial functions – see below for more details.

CPD note – if you are claiming CPD for watching this recording you need to keep your own records. People who attend the live sessions receive an annual listing of attendances.

Webinar Materials

These functions take three or more arguments, but there are a few things you need to know to use them correctly. Most involve loans or calculations associated with the time value of money.

This session covered the following six functions

  • PV – Present Value of future regular cash outflow
  • PMT – periodic loan repayment calculation
  • CUMIPMT – cumulative interest – great for loan schedules
  • RATE – interest rate
  • FV – future value of regular investment
  • NPER – number of periods

The session finishes with a loan model that calculates the “missing” value for a loan scenario based on two out of three inputs. The IFERROR function is also discussed.

Please note: I reserve the right to delete comments that are offensive or off-topic.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.